ERP订单删除功能

yl

2023-08-31 f3779c3cbca0d737c7ef7eaf47c1330b355c2f00

 VueWebApi/DLL/DAL/BasicSettingDAL.cs

@@ -1013,14 +1013,14 @@
                        //写入用户组关系表
                        for (int i = 0; i < json[0].children.Count; i++)
                        {
                            sql = @"insert into TGroup(group_code,user_code) values(@groupcode,@usercode)";
                            sql = @"insert into TGroupUser(group_code,user_code) values(@groupcode,@usercode)";
                            list.Add(new
                            {
                                str = sql,
                                parm = new
                                {
                                    groupcode = json[0].code,
                                    groupename = json[0].children[i].usercode
                                    usercode = json[0].children[i].usercode
                                }
                            });
                        }
@@ -1044,7 +1044,7 @@
                else
                {
                    //修改用户组表
                    sql = @"update TGroup see group_name=@,lm_user=@lm_user,lm_date=@lm_date,description=@description,torg_code=@torg_code where group_code=@groupcode";
                    sql = @"update TGroup set group_name=@groupename,lm_user=@lm_user,lm_date=@lm_date,description=@description,torg_code=@torg_code where group_code=@groupcode";
                    list.Add(new
                    {
                        str = sql,
@@ -1078,7 +1078,7 @@
                            parm = new
                            {
                                groupcode = json[0].code,
                                groupename = json[0].children[i].usercode
                                usercode = json[0].children[i].usercode
                            }
                        });
                    }
@@ -1133,6 +1133,8 @@
                }
                sql = @"delete TGroup where group_code=@UserGrupCode";
                list.Add(new { str = sql, parm = new { UserGrupCode = UserGrupCode } });
                sql = @"delete TGroupUser where group_code=@UserGrupCode";
                list.Add(new { str = sql, parm = new { UserGrupCode = UserGrupCode } });

                bool aa = DapperHelper.DoTransaction(list);
                if (aa)
@@ -1168,7 +1170,9 @@
            var dynamicParams = new DynamicParameters();
            try
            {
                sql = @"select *  from TGroupUser where  group_code=@groupcode";
                sql = @"select U.usercode,U.username  from TGroupUser GU
                        left join TUser U on GU.user_code=U.usercode
                        where  GU.group_code=@groupcode";
                dynamicParams.Add("@groupcode", groupcode);
                var data = DapperHelper.selectdata(sql, dynamicParams);
                if (data.Rows.Count > 0)