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