From 04b8731095ba2a679b936cc79b2851a12c152aba Mon Sep 17 00:00:00 2001
From: yangle <admin@YINMOU>
Date: 星期四, 30 六月 2022 08:42:21 +0800
Subject: [PATCH] 隐藏列完善 用户新增完善
---
WebAPI/Controllers/BaseSet/Xt_grdAlignment_WMESController.cs | 9 ++--
WebAPI/Controllers/BLL/Xt_UserController.cs | 86 ++++++++++++++++++++++++++++++++++++++++--
WebAPI/Models/Gy_User.cs | 20 +++++++++
3 files changed, 105 insertions(+), 10 deletions(-)
diff --git a/WebAPI/Controllers/BLL/Xt_UserController.cs b/WebAPI/Controllers/BLL/Xt_UserController.cs
index 124559c..e3701a6 100644
--- a/WebAPI/Controllers/BLL/Xt_UserController.cs
+++ b/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";
diff --git a/WebAPI/Controllers/BaseSet/Xt_grdAlignment_WMESController.cs b/WebAPI/Controllers/BaseSet/Xt_grdAlignment_WMESController.cs
index 98c011a..9268d94 100644
--- a/WebAPI/Controllers/BaseSet/Xt_grdAlignment_WMESController.cs
+++ b/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";
diff --git a/WebAPI/Models/Gy_User.cs b/WebAPI/Models/Gy_User.cs
index 9b1d83d..ec260cb 100644
--- a/WebAPI/Models/Gy_User.cs
+++ b/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;
}
}
\ No newline at end of file
--
Gitblit v1.9.1