采购订单,erp同步接口开发

yl

2022-12-27 4d4e3ad417beccd49f1fe61a158bb1bc3a3537c2

 VueWebApi/DLL/DAL/LoginDAL.cs

@@ -201,9 +201,9 @@
                    {
                        usercode = usercode,
                        oper_date = DateTime.Now.ToString(),
                        oper_type = "PC/APP",
                        oper_type = "PC",
                        description = username + "修改了密码",
                        origin = "PC/APP"
                        origin = "PC"
                    }
                });
                bool aa = DapperHelper.DoTransaction(list);
@@ -226,7 +226,65 @@
        }
        #endregion

        #region[密码重置]
        #region[APP修改密码]
        public static ToMessage AppUpdateUserPassword(string usercode, string username, string password, string newpassword)
        {
            var sql = "";
            List<object> list = new List<object>();
            var dynamicParams = new DynamicParameters();

            sql = @"select *  from [dbo].[TUser] where usercode=@usercode and username=@username and password=@password";
            dynamicParams.Add("@usercode", usercode);
            dynamicParams.Add("@username", username);
            dynamicParams.Add("@password", password);
            var data = DapperHelper.selectdata(sql, dynamicParams);
            if (data.Rows.Count <= 0)
            {
                mes.code = "300";
                mes.count = 0;
                mes.Message = "输入的密码不正确,请重新输入！";
                mes.data = null;
            }
            else
            {
                //修改密码
                sql = @"update [dbo].[TUser] set password=@newpassword where usercode=@usercode and username=@username and password=@password";
                list.Add(new { str = sql, parm = new { usercode = usercode, username = username, password = password, newpassword = newpassword } });
                //写入操作记录表
                sql = @"insert into T_Bas_User_Operlog(usercode,oper_date,oper_type,description,origin) values(@usercode,@oper_date,@oper_type,@description,@origin)";
                list.Add(new
                {
                    str = sql,
                    parm = new
                    {
                        usercode = usercode,
                        oper_date = DateTime.Now.ToString(),
                        oper_type = "APP",
                        description = username + "修改了密码",
                        origin = "APP"
                    }
                });
                bool aa = DapperHelper.DoTransaction(list);
                if (aa)
                {
                    mes.code = "200";
                    mes.count = 0;
                    mes.Message = "修改密码成功!";
                    mes.data = null;
                }
                else
                {
                    mes.code = "300";
                    mes.count = 0;
                    mes.Message = "修改密码失败!";
                    mes.data = null;
                }
            }
            return mes;
        }
        #endregion

        #region[APP密码重置]
        public static ToMessage ResettUserPassword(string usercode, string username)
        {
            var sql = "";
@@ -245,9 +303,9 @@
                {
                    usercode = usercode,
                    oper_date = DateTime.Now.ToString(),
                    oper_type = "PC/APP",
                    oper_type = "APP",
                    description = username + "重置了密码",
                    origin = "PC/APP"
                    origin = "APP"
                }
            });
            bool aa = DapperHelper.DoTransaction(list);