From 1f0141096cbd804741948a4a56aaabf73a07eefe Mon Sep 17 00:00:00 2001
From: 沈泽 <211959439@qq.com>
Date: 星期三, 27 十月 2021 08:13:33 +0800
Subject: [PATCH] 1
---
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