From 5057ba80001ab72765800b8fc008828d099b17dc Mon Sep 17 00:00:00 2001 From: zzr99 <1940172413@qq.com> Date: 星期五, 29 十月 2021 19:52:15 +0800 Subject: [PATCH] nothing --- WebAPI/Controllers/BaseSet/Xt_DataDictionary_TableController.cs | 31 +++++++++++++++---------------- 1 files changed, 15 insertions(+), 16 deletions(-) diff --git a/WebAPI/Controllers/BaseSet/Xt_DataDictionary_TableController.cs b/WebAPI/Controllers/BaseSet/Xt_DataDictionary_TableController.cs index 55563f8..45e70b1 100644 --- a/WebAPI/Controllers/BaseSet/Xt_DataDictionary_TableController.cs +++ b/WebAPI/Controllers/BaseSet/Xt_DataDictionary_TableController.cs @@ -114,7 +114,7 @@ public object DeltetXt_DataDictionary_Table(string HItemID) { DataSet ds; - DataSet ds1; + //DataSet ds1; try { //鍒犻櫎鏉冮檺 @@ -146,15 +146,15 @@ objJsonResult.data = null; return objJsonResult; ; } - ds1 = oCN.RunProcReturn("Select HItemID from Xt_DataDictionary_Table Where HParentID='" + HItemID + "'", "Xt_DataDictionary_Table"); - if (ds1.Tables[0].Rows.Count != 0) - { - objJsonResult.code = "0"; - objJsonResult.count = 0; - objJsonResult.Message = "姝ら」鐩瓨鍦ㄥ瓙椤圭洰锛屼笉鑳藉垹闄わ紒"; - objJsonResult.data = null; - return objJsonResult; - } + //ds1 = oCN.RunProcReturn("Select HItemID from Xt_DataDictionary_Table Where HParentID='" + HItemID + "'", "Xt_DataDictionary_Table"); + //if (ds1.Tables[0].Rows.Count != 0) + //{ + // objJsonResult.code = "0"; + // objJsonResult.count = 0; + // objJsonResult.Message = "姝ら」鐩瓨鍦ㄥ瓙椤圭洰锛屼笉鑳藉垹闄わ紒"; + // objJsonResult.data = null; + // return objJsonResult; + //} oCN.RunProc("delete from Xt_DataDictionary_Table where HItemID=" + HItemID); @@ -285,7 +285,7 @@ ",HStopflag,HMakeTime,HMakeEmp,HModifyTime" + ",HModifyEmp" + ") " + - " values(" + HModNameID + "," + HBillTypeID + "," + HBillTypeID + ",'" + HTableName + "'"+ + " values(" + HModNameID + "," + HBillTypeID + ",'" + HTableName + "'"+ ",'" + HTableCaption + "','" + HFieldName + "','" + HFieldCaption + "','" + HDataType + "'" + ",'" + HDefaultValue + "','" + HRemark + "'," + Convert.ToString(HStopflag ? 1 : 0) + "" + ",'" + HMakeTime + "','" + HMakeEmp + "','" + HModifyTime + "','" + HModifyEmp + "'" + @@ -328,7 +328,7 @@ string msg1 = _value.ToString(); string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); - string msg3 = sArray[1].ToString(); + //string msg3 = sArray[1].ToString(); //string msg4 = sArray[2].ToString(); //string msg5 = sArray[3].ToString(); //鍙嶅簭鍒楀寲 @@ -362,7 +362,7 @@ ",HFieldName,HFieldCaption,HDataType,HDefaultValue,HRemark" + ",HStopflag,HMakeTime,HMakeEmp,HModifyTime" + ",HModifyEmp" + - ") " + " values(" + HModNameID + "," + HBillTypeID + "," + HBillTypeID + ",'" + HTableName + "'" + + ") " + " values(" + HModNameID + "," + HBillTypeID + ",'" + HTableName + "'" + ",'" + HTableCaption + "','" + HFieldName + "','" + HFieldCaption + "','" + HDataType + "'" + ",'" + HDefaultValue + "','" + HRemark + "'," + Convert.ToString(HStopflag ? 1 : 0) + "" + ",'" + HMakeTime + "','" + HMakeEmp + "','" + HModifyTime + "','" + HModifyEmp + "'" + @@ -378,19 +378,18 @@ oCN.RunProc("Update Xt_DataDictionary_Table set " + " HModNameID= "+ HModNameID + " HBillTypeID= " + HBillTypeID + - " HBillTypeID= " + HBillTypeID + ",HTableName='" + HTableName + "'" + ",HTableCaption='" + HTableCaption + "'" + ",HFieldName='" + HFieldName + "'" + ",HDataType='" + HDataType + "'" + ",HFieldName='" + HFieldName + "'" + ",HFieldCaption='" + HFieldCaption + "'" + - ",HRemark='" + HRemark + "'" + + //",HRemark='" + HRemark + "'" + + ",HStopflag=" + Convert.ToString(HStopflag ? 1 : 0) + ",HMakeTime='" + HMakeTime + "'" + ",HMakeEmp='" + HMakeEmp + "'" + ",HModifyTime='" + HModifyTime + "'" + ",HModifyEmp='" + HModifyEmp + "'" + - ",HStopflag=" + Convert.ToString(HStopflag ? 1 : 0) + //",HUpdater='" + HUpdater + "'" + //",HUpdateDate= getdate()" + ",HRemark= '" + HRemark + "' Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo); -- Gitblit v1.9.1