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_ViewController.cs | 31 +++++++++++++++----------------
1 files changed, 15 insertions(+), 16 deletions(-)
diff --git a/WebAPI/Controllers/BaseSet/Xt_DataDictionary_ViewController.cs b/WebAPI/Controllers/BaseSet/Xt_DataDictionary_ViewController.cs
index 82cf333..f4b8ec3 100644
--- a/WebAPI/Controllers/BaseSet/Xt_DataDictionary_ViewController.cs
+++ b/WebAPI/Controllers/BaseSet/Xt_DataDictionary_ViewController.cs
@@ -114,7 +114,7 @@
public object DeltetXt_DataDictionary_View(string HItemID)
{
DataSet ds;
- DataSet ds1;
+ //DataSet ds1;
try
{
//鍒犻櫎鏉冮檺
@@ -146,15 +146,15 @@
objJsonResult.data = null;
return objJsonResult; ;
}
- ds1 = oCN.RunProcReturn("Select HItemID from h_v_IF_DataDictionary_View Where HParentID='" + HItemID + "'", "h_v_IF_DataDictionary_View");
- 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 h_v_IF_DataDictionary_View Where HParentID='" + HItemID + "'", "h_v_IF_DataDictionary_View");
+ //if (ds1.Tables[0].Rows.Count != 0)
+ //{
+ // objJsonResult.code = "0";
+ // objJsonResult.count = 0;
+ // objJsonResult.Message = "姝ら」鐩瓨鍦ㄥ瓙椤圭洰锛屼笉鑳藉垹闄わ紒";
+ // objJsonResult.data = null;
+ // return objJsonResult;
+ //}
oCN.RunProc("delete from h_v_IF_DataDictionary_View where HItemID=" + HItemID);
@@ -322,7 +322,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();
//鍙嶅簭鍒楀寲
@@ -352,30 +352,29 @@
",HStopflag,HMakeTime,HMakeEmp,HModifyTime" +
",HModifyEmp" +
") " +
- " values(" + HModNameID + "," + HBillTypeID + "," + HBillTypeID + ",'" + HViewName + "','" + HViewCaption + "'" +
+ " values(" + HModNameID + "," + HBillTypeID + ",'" + HViewName + "','" + HViewCaption + "'" +
",'" + HRemark + "'," + Convert.ToString(HStopflag ? 1 : 0) + "" +
",'" + HMakeTime + "','" + HMakeEmp + "','" + HModifyTime + "','" + HModifyEmp + "'" +
") ", ref DBUtility.ClsPub.sExeReturnInfo);
//淇敼涓婄骇涓洪潪鏈骇浠ｇ爜
- oCN.RunProc("Update Xt_DataDictionary_Table set HStopflag=0 where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo);
+ oCN.RunProc("Update Xt_DataDictionary_View set HStopflag=0 where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo);
oCN.Commit();
}
else
{
oCN.BeginTran();
//涓昏〃
- oCN.RunProc("Update Xt_DataDictionary_Table set " +
+ oCN.RunProc("Update Xt_DataDictionary_View set " +
" HModNameID= "+ HModNameID +
- " HBillTypeID= " + HBillTypeID +
" HBillTypeID= " + HBillTypeID +
",HViewName='" + HViewName + "'" +
",HViewCaption='" + HViewCaption + "'" +
",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