From aca2ad77dd242fb9fe223b6cc30bbcf69e9a6eab Mon Sep 17 00:00:00 2001
From: wangyi <2946747746@qq.com>
Date: 星期三, 25 三月 2026 15:08:54 +0800
Subject: [PATCH] 托数字段修改
---
WebAPI/Controllers/BaseSet/Gy_DriverController.cs | 67 ++++++++++++++++-----------------
1 files changed, 33 insertions(+), 34 deletions(-)
diff --git a/WebAPI/Controllers/BaseSet/Gy_DriverController.cs b/WebAPI/Controllers/BaseSet/Gy_DriverController.cs
index 858a78f..e0909ac 100644
--- a/WebAPI/Controllers/BaseSet/Gy_DriverController.cs
+++ b/WebAPI/Controllers/BaseSet/Gy_DriverController.cs
@@ -37,15 +37,15 @@
try
{
List<object> columnNameList = new List<object>();
- ////鏌ョ湅鏉冮檺
- //if (!DBUtility.ClsPub.Security_Log("Gy_Department", 1, false, user))
- //{
- // objJsonResult.code = "0";
- // objJsonResult.count = 0;
- // objJsonResult.Message = "鏃犳煡鐪嬫潈闄�";
- // objJsonResult.data = null;
- // return objJsonResult;
- //}
+ //鏌ョ湅鏉冮檺
+ if (!DBUtility.ClsPub.Security_Log("Gy_Driver_Query", 1, false, user))
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "鏃犳煡鐪嬫潈闄�";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
//string sql1 = string.Format(@"select * from h_v_IF_DepartmentList where 缁勭粐鍚嶇О='" + Organization + "'");
string sql1 = string.Format(@"select * from h_v_Gy_driver where 1=1 ");
if (sWhere == null || sWhere.Equals(""))
@@ -106,7 +106,7 @@
public string title { get; set; }
public List<TreeModel> children = new List<TreeModel>();
}
- [Route("Gy_Department/Gy_DepartmentTreeList")]
+ [Route("Gy_Driver/Gy_DepartmentTreeList")]
[HttpGet]
public object Gy_DepartmentTreeList(string sWhere)
{
@@ -232,14 +232,14 @@
try
{
////鍒犻櫎鏉冮檺
- //if (!DBUtility.ClsPub.Security_Log("Gy_Department_Delete", 1, false, user))
- //{
- // objJsonResult.code = "0";
- // objJsonResult.count = 0;
- // objJsonResult.Message = "鏃犲垹闄ゆ潈闄�";
- // objJsonResult.data = null;
- // return objJsonResult;
- //}
+ if (!DBUtility.ClsPub.Security_Log("Gy_Driver_Delete", 1, false, user))
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "鏃犲垹闄ゆ潈闄�";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
if (string.IsNullOrWhiteSpace(HItemID))
@@ -479,7 +479,7 @@
//string msg5 = sArray[3].ToString();
//缂栬緫鏉冮檺
- if (!DBUtility.ClsPub.Security_Log_second("Gy_Department_Edit", 1, false, msg3))
+ if (!DBUtility.ClsPub.Security_Log_second("Gy_Driver_Edit", 1, false, msg3))
{
objJsonResult.code = "0";
objJsonResult.count = 0;
@@ -492,7 +492,7 @@
msg2 = msg2.Replace("\n", "");
msg2 = "[" + msg2.ToString() + "]";
List<Driver> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Driver>>(msg2);
-
+ long HUSEORGID_1 = Convert.ToInt64(list[0].HUSEORGID);
long HItemID = list[0].HItemID;
string HNumber = list[0].HNumber;
string HName = list[0].HName;
@@ -501,9 +501,9 @@
string HHelpCode = list[0].HHelpCode;
string HModifyEmp = msg3;
string HMakeEmp = msg3;
- bool HStopflag = list[0].HStopflag==null?false:true;
+ int HStopflag = list[0].HStopflag==0?0:1;
long HCREATEORGID = list[0].HCREATEORGID;
- long HUSEORGID = list[0].HUSEORGID;
+ long HUSEORGID = HUSEORGID_1;
long HCompID = list[0].HCompID;
//zidingyi
@@ -577,7 +577,7 @@
" (HNumber,HName,HHelpCode,HShortNumber,HParentID" +
",HLevel,HEndFlag,HStopflag,HRemark,HUSEORGID,HCREATEORGID,HMakeEmp,HMakeTime,HIDCard,HPhone,HDriverCardPic,HDriverCardType,HIDCardPic,HEmpType,HCompID) " +
" Values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "'," + HParentID.ToString() +
- "," + HLevel.ToString() + "," + Convert.ToString(HEndFlag ? 1 : 0) + "," + Convert.ToString(HStopflag ? 1 : 0) + ",'" + HRemark + "'" +
+ "," + HLevel.ToString() + "," + Convert.ToString(HEndFlag ? 1 : 0) + "," + HStopflag + ",'" + HRemark + "'" +
"," + HUSEORGID + "," + HCREATEORGID + ",'" + msg3 + "',getdate()," +"'"+ HIDCard +"',"+
"'"+ HPhone+"','"+ HDriverCardPic+"','"+ HDriverCardType + "','"+ HIDCardPic +"','"+ HEmpType+"',"+ HCompID+
")", ref DBUtility.ClsPub.sExeReturnInfo);
@@ -611,7 +611,7 @@
",HParentID=" + HParentID +
",HUSEORGID=" + HUSEORGID.ToString() +
",HCREATEORGID=" + HCREATEORGID.ToString() +
- ",HStopflag=" + Convert.ToString(HStopflag ? 1 : 0) +
+ ",HStopflag=" + HStopflag +
",HModifyEmp='" + HModifyEmp + "'" +
",HModifyTime='" + DateTime.Now + "'" +
",HIDCard='" + HIDCard + "'" +
@@ -621,7 +621,6 @@
",HIDCardPic='" + HIDCardPic + "'" +
",HEmpType='" + HEmpType + "'" +
",HCompID=" + HCompID + "" +
-
",HRemark= '" + HRemark + "' Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo);
//淇敼瀛愰」鐩唬鐮�
@@ -989,15 +988,15 @@
{
try
{
- ////瀹℃牳鏉冮檺
- //if (!DBUtility.ClsPub.Security_Log_second("Gy_Department_Check", 1, false, CurUserName))
- //{
- // objJsonResult.code = "0";
- // objJsonResult.count = 0;
- // objJsonResult.Message = "瀹℃牳澶辫触锛佹棤鏉冮檺锛�";
- // objJsonResult.data = null;
- // return objJsonResult;
- //}
+ //瀹℃牳鏉冮檺
+ if (!DBUtility.ClsPub.Security_Log_second("Gy_Driver_Check", 1, false, CurUserName))
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "瀹℃牳澶辫触锛佹棤鏉冮檺锛�";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
var ds = oCN.RunProcReturn("select * from Gy_Driver where HItemID=" + HInterID, "Gy_Driver");
if (ds.Tables[0].Rows.Count > 0)
--
Gitblit v1.9.1