隐藏列完善 用户新增完善

yangle

2022-06-30 04b8731095ba2a679b936cc79b2851a12c152aba

隐藏列完善
用户新增完善

 WebAPI/Controllers/BLL/Xt_UserController.cs

@@ -166,18 +166,94 @@
                //保存
                if (msg3=="Add") //新增
                {
                    oCN.RunProc("insert into Gy_Czygl (Czybm,Czymc,Czmm,Explain,HEmpID) values ('" + lsmain[0].Czybm.ToString() + "','" + lsmain[0].Czymc.ToString() + "','" + ClsPub.StrToPsd(lsmain[0].Czmm.ToString()) + "','" + lsmain[0].Explain.ToString() + "','" + lsmain[0].HEmpID.ToString() + "')");
                    ds = oCN.RunProcReturn("select * from  Gy_Czygl where Czybm='" + lsmain[0].Czybm.ToString() + "'", "Gy_Czygl");
                    if (ds.Tables[0].Rows.Count != 0)
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 0;
                        objJsonResult.Message = "* 编码重复！！";
                        objJsonResult.data = null;
                        return objJsonResult;
                    }

                    ds = oCN.RunProcReturn("select * from  Gy_Czygl where Czymc='" + lsmain[0].Czymc.ToString() + "'", "Gy_Czygl");
                    if (ds.Tables[0].Rows.Count != 0)
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 0;
                        objJsonResult.Message = "* 用户名重复！！";
                        objJsonResult.data = null;
                        return objJsonResult;
                    }

                    oCN.RunProc("insert into Gy_Czygl (Czybm,Czymc,Czmm,Explain,HempID,HK3UserID " +
                    ",HKeeperID,HKeeper,HSecManagerID,HSecManager " +
                    ",HSellManID,HSellMan,HDeptID,HDept " +
                    ",HWhID,HWHName,HSupID,HSupName " +
                    ",HSCWHID,HSCWHName " +
                    ",HCloudUserName,HCloudUserPsd,HUSEORGID) " +
                    "values ('" + lsmain[0].Czybm.ToString() + "','" + lsmain[0].Czymc.ToString() + "','" + ClsPub.StrToPsd(lsmain[0].Czmm.ToString()) + "','" + lsmain[0].Explain.ToString() + "','" + lsmain[0].HEmpID.ToString() + "',"+ lsmain[0].HK3UserID.ToString() + "" +
                    ","+ lsmain[0].HKeeperID.ToString() + ",'"+ lsmain[0].HKeeper.ToString() + "',"+ lsmain[0].HSecManagerID.ToString() + ",'"+ lsmain[0].HSecManager.ToString() + "'" +
                    "," + lsmain[0].HSellManID.ToString() + ",'" + lsmain[0].HSellMan.ToString() + "'," + lsmain[0].HDeptID.ToString() + ",'" + lsmain[0].HDept.ToString() + "'" +
                    "," + lsmain[0].HWhID.ToString() + ",'" + lsmain[0].HWHName.ToString() + "'," + lsmain[0].HSupID.ToString() + ",'" + lsmain[0].HSupName.ToString() + "'" +
                    "," + lsmain[0].HSCWHID.ToString() + ",'" + lsmain[0].HSCWHName.ToString() + "'" + 
                    ",'" + lsmain[0].HCloudUserName.ToString() + "','" + lsmain[0].HCloudUserPsd.ToString() + "',"+ lsmain[0].HOrgID.ToString() + ")");
                }
                else //修改
                {
                    if (lsmain[0].Czyyz != "" && lsmain[0].Czmm == lsmain[0].Czyyz)  //修改密码
                    ds = oCN.RunProcReturn("select * from  Gy_Czygl where Czybm='" + lsmain[0].Czybm.ToString() + "'", "Gy_Czygl");
                    if (ds.Tables[0].Rows[0]["Czmm"].ToString() !=  lsmain[0].Czmm)  //修改密码
                    {
                        oCN.RunProc("update Gy_Czygl set Czymc='"+lsmain[0].Czymc.ToString()+ "',Czmm='"+ ClsPub.StrToPsd(lsmain[0].Czmm.ToString()) + "',Explain='" + lsmain[0].Explain.ToString() + "' ,HEmpID='" + lsmain[0].HEmpID.ToString() + "'  where  Czybm='" + lsmain[0].Czybm.ToString()+"'");
                        oCN.RunProc("update Gy_Czygl set Czymc='" + lsmain[0].Czymc.ToString() +
                        "',Czmm='" + ClsPub.StrToPsd(lsmain[0].Czmm.ToString()) +
                        "',Explain='" + lsmain[0].Explain.ToString() + "'" +
                        ",HEmpID=" + lsmain[0].HEmpID.ToString() +
                        ",HK3UserID=" + lsmain[0].HK3UserID.ToString() +
                        ",HKeeperID=" + lsmain[0].HKeeperID.ToString() +
                        ",HKeeper='" + lsmain[0].HKeeper.ToString() + "'" +
                        ",HSecManagerID=" + lsmain[0].HSecManagerID.ToString() +
                        ",HSecManager='" + lsmain[0].HSecManager.ToString() + "'" +
                        ",HSellManID=" + lsmain[0].HSellManID.ToString() +
                        ",HSellMan='" + lsmain[0].HSellMan.ToString() + "'" +
                        ",HDeptID=" + lsmain[0].HDeptID.ToString() +
                        ",HDept='" + lsmain[0].HDept.ToString() + "'" +
                        ",HWhID=" + lsmain[0].HWhID.ToString() +
                        ",HWHName='" + lsmain[0].HWHName.ToString() + "'" +
                        ",HSCWHID=" + lsmain[0].HSCWHID.ToString() +
                        ",HSCWHName='" + lsmain[0].HSCWHName.ToString() + "'" +
                        ",HSupID=" + lsmain[0].HSupID.ToString() +
                        ",HSupName='" + lsmain[0].HSupName.ToString() + "'" +
                        ",HCloudUserName='" + lsmain[0].HCloudUserName.ToString() + "'" +
                        ",HCloudUserPsd='" + lsmain[0].HCloudUserPsd.ToString() + "'" +
                        ",HUSEORGID=" + lsmain[0].HOrgID.ToString() +
                        "  where  Czybm='" + lsmain[0].Czybm.ToString() + "'");
                    }
                    else 
                    else
                    {
                        oCN.RunProc("update Gy_Czygl set Czymc='" + lsmain[0].Czymc.ToString() + "',Explain='" + lsmain[0].Explain.ToString() + "',HEmpID='" + lsmain[0].HEmpID.ToString() + "'  where  Czybm='" + lsmain[0].Czybm.ToString() + "'");
                        oCN.RunProc("update Gy_Czygl set Czymc='" + lsmain[0].Czymc.ToString() +
                           "',Explain='" + lsmain[0].Explain.ToString() + "'" +
                           ",HEmpID=" + lsmain[0].HEmpID.ToString() +
                           ",HK3UserID=" + lsmain[0].HK3UserID.ToString() +
                           ",HKeeperID=" + lsmain[0].HKeeperID.ToString() +
                           ",HKeeper='" + lsmain[0].HKeeper.ToString() + "'" +
                           ",HSecManagerID=" + lsmain[0].HSecManagerID.ToString() +
                           ",HSecManager='" + lsmain[0].HSecManager.ToString() + "'" +
                           ",HSellManID=" + lsmain[0].HSellManID.ToString() +
                           ",HSellMan='" + lsmain[0].HSellMan.ToString() + "'" +
                           ",HDeptID=" + lsmain[0].HDeptID.ToString() +
                           ",HDept='" + lsmain[0].HDept.ToString() + "'" +
                           ",HWhID=" + lsmain[0].HWhID.ToString() +
                           ",HWHName='" + lsmain[0].HWHName.ToString() + "'" +
                           ",HSCWHID=" + lsmain[0].HSCWHID.ToString() +
                           ",HSCWHName='" + lsmain[0].HSCWHName.ToString() + "'" +
                           ",HSupID=" + lsmain[0].HSupID.ToString() +
                           ",HSupName='" + lsmain[0].HSupName.ToString() + "'" +
                           ",HCloudUserName='" + lsmain[0].HCloudUserName.ToString() + "'" +
                           ",HCloudUserPsd='" + lsmain[0].HCloudUserPsd.ToString() + "'" +
                           ",HUSEORGID=" + lsmain[0].HOrgID.ToString() +
                           "  where  Czybm='" + lsmain[0].Czybm.ToString() + "'");
                    }

                }

                objJsonResult.code = "1";

 WebAPI/Controllers/BaseSet/Xt_grdAlignment_WMESController.cs

@@ -55,6 +55,7 @@
            public string HTextHeight;
            public string HSortFlag;
            public string HSelTotal;
            public string HColumnWidth;
          
        }
        public class grdAlignmentSub
@@ -114,11 +115,11 @@

                oCN.RunProc("Delete from Xt_grdAlignment_WMES where HUserName='" + user + "' and HModName='" + HModName + "' ");
                oCN.RunProc("insert into Xt_grdAlignment_WMES (HUserName,HModName,HGridString,HFixCols" +
                    ",HFontSize,HHeadTextHeight,HTextHeight,HSortFlag,HSelTotal" +
                    ",HFontSize,HHeadTextHeight,HTextHeight,HSortFlag,HSelTotal,HColumnWidth" +
                    ")  values('" + user + "','" + HModName + "','" + HGridString + "'," + (omdelMian.HFixCols == "" ? "0" : omdelMian.HFixCols) +
                    "," + (omdelMian.HFontSize == "" ? "0" : omdelMian.HFontSize) + "," + (omdelMian.HHeadTextHeight == "" ? "0" : omdelMian.HHeadTextHeight) +
                    "," + (omdelMian.HTextHeight == "" ? "0" : omdelMian.HTextHeight) + ",'" + omdelMian.HSortFlag + "','" + omdelMian.HSelTotal + "'" +
                    ")");
                    "," + (omdelMian.HFontSize == "" ? "0" : omdelMian.HFontSize) + ",0" +
                    ",0,'" + omdelMian.HSortFlag + "','" + omdelMian.HSelTotal + "'" +
                    ","+ (omdelMian.HColumnWidth == "" ? "0" : omdelMian.HColumnWidth) + ")");


                objJsonResult.code = "1";

 WebAPI/Models/Gy_User.cs

@@ -12,6 +12,24 @@
        public string Czmm { get; set; }
        public string Czyyz { get; set; }
        public string Explain { get; set; }
        public string HEmpID { get; set; }
        public int HEmpID { get; set; }
        public string HCloudUserName { get; set; }
        public string HCloudUserPsd { get; set; }
        public int HOrgID;
        public int HK3UserID;
        public int HKeeperID;
        public string HKeeper;
        public int HSecManagerID;
        public string HSecManager;
        public int HSellManID;
        public string HSellMan;
        public int HDeptID;
        public string HDept;
        public int HWhID;
        public string HWHName;
        public int HSCWHID;
        public string HSCWHName;
        public int HSupID;
        public string HSupName;
    }
}