From ee9154e9095cc830b1a80811930ca53a0705be0b Mon Sep 17 00:00:00 2001
From: duhe <226547893@qq.com>
Date: 星期四, 06 七月 2023 14:14:45 +0800
Subject: [PATCH] 基础资料 项目阶段和列表
---
WebAPI/Controllers/项目管理/项目阶段/Gy_ProjectStageController.cs | 275 ++++++++++++++++++++++++++++++++++++++++++++----------
1 files changed, 224 insertions(+), 51 deletions(-)
diff --git "a/WebAPI/Controllers/\351\241\271\347\233\256\347\256\241\347\220\206/\351\241\271\347\233\256\351\230\266\346\256\265/Gy_ProjectStageController.cs" "b/WebAPI/Controllers/\351\241\271\347\233\256\347\256\241\347\220\206/\351\241\271\347\233\256\351\230\266\346\256\265/Gy_ProjectStageController.cs"
index e26d500..8ae2bce 100644
--- "a/WebAPI/Controllers/\351\241\271\347\233\256\347\256\241\347\220\206/\351\241\271\347\233\256\351\230\266\346\256\265/Gy_ProjectStageController.cs"
+++ "b/WebAPI/Controllers/\351\241\271\347\233\256\347\256\241\347\220\206/\351\241\271\347\233\256\351\230\266\346\256\265/Gy_ProjectStageController.cs"
@@ -1,5 +1,6 @@
锘縰sing DBUtility;
using Model;
+using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
using System;
using System.Collections.Generic;
@@ -20,7 +21,7 @@
- #region 椤圭洰闃舵 鏂板
+ #region 椤圭洰闃舵 鏂板/缂栬緫
#region 椤圭洰闃舵 鏂板/缂栬緫 淇℃伅鍒楄〃
public class Gy_ProjectStage_eidt_add
{
@@ -28,7 +29,7 @@
public string HNumber;
public string HName;
public long HParentID;
- public bool HStopFlag;
+ public bool HStopflag;
public string HRemark;
public string HHelpCode;
public int HUSEORGID;
@@ -43,9 +44,9 @@
///鍙傛暟锛歴tring sql銆�
///杩斿洖鍊硷細object銆�
/// </summary>
- [Route("Gy_ProjectStage/AddNew")]
+ [Route("Gy_ProjectStage/AddNewProjectStage")]
[HttpPost]
- public object AddNew([FromBody] JObject oMain)
+ public object AddNewProjectStage([FromBody] JObject oMain)
{
try
{
@@ -58,15 +59,15 @@
string msg2 = sArray[0].ToString();
string user = sArray[1].ToString();//鐢ㄦ埛鍚�
- ////鍒ゆ柇鏄惁鏈夌紪杈戞潈闄�
- //if (!DBUtility.ClsPub.Security_Log("Gy_Process_Edit", 1, false, user))
- //{
- // objJsonResult.code = "0";
- // objJsonResult.count = 0;
- // objJsonResult.Message = "鏃犳潈闄愮紪杈�!";
- // objJsonResult.data = null;
- // return objJsonResult;
- //}
+ //鍒ゆ柇鏄惁鏈夌紪杈戞潈闄�
+ if (!DBUtility.ClsPub.Security_Log("PM_ProjectStage_edit", 1, false, user))
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "鏃犳潈闄愮紪杈�!";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
//string msg3 = sArray[1].ToString();
//string msg4 = sArray[2].ToString();
@@ -84,7 +85,7 @@
long HParentID = list[0].HParentID;
long HLevel = ClsPub.GetLevel(list[0].HNumber.Trim());
bool HEndFlag = true;
- bool HStopFlag = list[0].HStopFlag;
+ bool HStopflag = list[0].HStopflag;
string HRemark = list[0].HRemark;
string HHelpCode = list[0].HHelpCode;
string HMakeEmp = user;
@@ -109,7 +110,7 @@
"," + HParentID.ToString() + "" +
"," + HLevel.ToString() + "" +
"," + Convert.ToString(HEndFlag ? 1 : 0) + "" +
- "," + Convert.ToString(HStopFlag ? 1 : 0) + "" +
+ "," + Convert.ToString(HStopflag ? 1 : 0) + "" +
",'" + HRemark + "'" +
",'" + HHelpCode + "'" +
",'" + HMakeEmp + "'" +
@@ -128,42 +129,29 @@
else
{
////鑻AINDI閲嶅鍒欓噸鏂拌幏鍙�
- //oCN.BeginTran();
- //oCN.RunProc("Update Gy_Process set " +
- // " HNumber='" + HNumber + "'" +
- // ",HName='" + HName + "'" +
- // ",HHelpCode='" + HHelpCode + "'" +
- // ",HShortNumber='" + HShortNumber + "'" +
- // ",HParentID= " + HParentID +
- // ",HTypeFlow= '" + HTypeFlow + "'" +
- // ",HTypeCount= '" + HTypeCount + "'" +
- // ",HDeptNumber='" + HDeptNumber + "'" +
- // ",HSNo= " + HSNo +
- // ",HLevel= " + HLevel +
- // ",HEndFlag= '" + HEndFlag + "'" +
- // ",HTProcessFlag= '" + HTProcessFlag + "'" +
- // ",HStopflag= '" + HStopflag + "'" +
- // ",HRemark='" + HRemark + "'" +
- // ",HDeptID= " + HDeptID +
- // ",HBarCodeForBase='" + HBarCode + "'" +
- // ",HProcessID_K3= " + HProcessID_K3 +
- // ",HBillSubType='" + HBillSubType + "'" +
- // ",HAutoTrunFlag= '" + HAutoTrunFlag + "'" +
- // ",HFixPrice= " + HFixPrice +
- // ",HOverFixPrice= " + HOverFixPrice +
- // ",HProcMulID= " + HProcMulID +
- // ",HWorkCenterID= " + HWorkCenterID +
- // ",HBadWHID= " + HBadWHID +
- // ",HWasterWHID= " + HWasterWHID +
- // ",HBadCountDevelopWHID= " + HBadCountDevelopWHID +
- // ",HWWBadWHID= " + HWWBadWHID +
- // ",HWWWasterWHID= " + HWWWasterWHID +
- // ",HWHID= " + HWHID +
- // ",HProcCheckNote='" + HProcCheckNote + "' Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo);
- ////淇敼涓婄骇涓洪潪鏈骇浠ｇ爜
- //oCN.RunProc("Update Gy_Process set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo);
- ////
- //oCN.Commit();
+ oCN.BeginTran();
+ string sql = "Update Gy_ProjectStage set " +
+ "HNumber='" + HNumber + "'" +
+ ",HName='" + HName + "'" +
+ ",HShortNumber='" + HShortNumber + "'" +
+ ",HParentID=" + HParentID.ToString() + "" +
+ ",HLevel=" + HLevel.ToString() + "" +
+ ",HEndFlag=" + Convert.ToString(HEndFlag ? 1 : 0) + "" +
+ ",HStopflag=" + Convert.ToString(HStopflag ? 1 : 0) + "" +
+ ",HRemark='" + HRemark + "'" +
+ ",HHelpCode='" + HHelpCode + "'" +
+ ",HMakeEmp='" + HMakeEmp + "'" +
+ ",HUSEORGID=" + HUSEORGID + "" +
+ ",HStageNote='" + HStageNote + "'" +
+ ",HRelationGoods='" + HRelationGoods + "'" +
+ ",HIsKey=" + Convert.ToString(HIsKey ? 1 : 0) + "" +
+ ",HRate=" + HRate + "" +
+ " where HItemID=" + HItemID;
+ oCN.RunProc(sql, ref DBUtility.ClsPub.sExeReturnInfo);
+ //淇敼涓婄骇涓洪潪鏈骇浠ｇ爜
+ oCN.RunProc("Update Gy_ProjectStage set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo);
+ //
+ oCN.Commit();
}
objJsonResult.code = "0";
objJsonResult.count = 1;
@@ -183,5 +171,190 @@
}
}
#endregion
+
+ #region 椤圭洰闃舵 鏌ヨ
+ /// <summary>
+ /// 杩斿洖椤圭洰闃舵鍒楄〃
+ ///鍙傛暟锛歴tring sql銆�
+ ///杩斿洖鍊硷細object銆�
+ /// </summary>
+ [Route("Gy_ProjectStage/list")]
+ [HttpGet]
+ public object getProjectStageList(string sWhere, string user)
+ {
+ try
+ {
+ List<object> columnNameList = new List<object>();
+ //鏌ョ湅鏉冮檺
+ //if (!DBUtility.ClsPub.Security_Log("Gy_ProjectStage_Query", 1, false, user))
+ //{
+ // objJsonResult.code = "0";
+ // objJsonResult.count = 0;
+ // objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒";
+ // objJsonResult.data = null;
+ // return objJsonResult;
+ //}
+
+ if (sWhere == null || sWhere.Equals(""))
+ {
+ ds = oCN.RunProcReturn("select * from Gy_ProjectStage order by HNumber ", "Gy_ProjectStage");
+ }
+ else
+ {
+ string sql1 = "select * from Gy_ProjectStage where 1 = 1 ";
+ string sql = sql1 + sWhere + " order by HNumber ";
+ ds = oCN.RunProcReturn(sql, "Gy_ProjectStage");
+ }
+
+ //娣诲姞鍒楀悕
+ foreach (DataColumn col in ds.Tables[0].Columns)
+ {
+ Type dataType = col.DataType;
+ string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
+ columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//鑾峰彇鍒癉ataColumn鍒楀璞＄殑鍒楀悕
+ }
+
+ objJsonResult.code = "1";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "Sucess锛�";
+ objJsonResult.data = ds.Tables[0];
+ objJsonResult.list = columnNameList;
+ return objJsonResult;
+ }
+ catch (Exception e)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "Exception锛�" + e.ToString();
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ }
+ #endregion
+
+ #region 椤圭洰闃舵 鏌ヨ鎸囧畾椤圭洰闃舵璁板綍
+ /// <summary>
+ /// 鏍规嵁鍩虹璧勬枡ID 鏌ユ壘璁板綍
+ ///鍙傛暟锛歴tring sql銆�
+ ///杩斿洖鍊硷細object銆�
+ /// </summary>
+ [Route("Gy_ProjectStage/cx")]
+ [HttpGet]
+ public object cx(long HInterID)
+ {
+ try
+ {
+
+ ds = oCN.RunProcReturn("select * from Gy_ProjectStage where HitemID=" + HInterID, "Gy_ProjectStage");
+
+ objJsonResult.code = "1";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "Sucess锛�";
+ objJsonResult.data = ds.Tables[0];
+ return objJsonResult;
+ }
+ catch (Exception e)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "Exception锛�" + e.ToString();
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ }
+ #endregion
+
+ #region 椤圭洰闃舵 鍒犻櫎
+ /// <summary>
+ /// 椤圭洰闃舵鍒楄〃鍒犻櫎鍔熻兘
+ /// </summary>
+ /// <returns></returns>
+ [Route("DeltetGy_ProjectStage")]
+ [HttpGet]
+ public object DeltetGy_ProjectStage(string HItemID, string user)
+ {
+ DataSet ds;
+ DataSet ds1;
+ try
+ {
+ //鍒犻櫎鏉冮檺
+ if (!DBUtility.ClsPub.Security_Log("PM_ProjectStage_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))
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "HItemID涓虹┖锛�";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+
+ oCN.BeginTran();//寮�濮嬩簨鍔�
+ ds = oCN.RunProcReturn("select * from Gy_ProjectStage where HItemID=" + HItemID, "Gy_ProjectStage");
+ if (ds == null || ds.Tables[0].Rows.Count == 0)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "娌℃湁鏁版嵁锛屾棤娉曞垹闄わ紒";
+ objJsonResult.data = null;
+ return objJsonResult; ;
+ }
+ //var HStopflag = Convert.ToBoolean(ds.Tables[0].Rows[0]["HStopflag"]);
+ //if (HStopflag)
+ //{
+ // oCN.RollBack();//鍥炴粴浜嬪姟
+ // objJsonResult.code = "0";
+ // objJsonResult.count = 0;
+ // objJsonResult.Message = "鏁版嵁宸插垹闄ゆ棤娉曞啀娆″垹闄わ紒";
+ // objJsonResult.data = null;
+ // return objJsonResult;
+ //}
+ ds1 = oCN.RunProcReturn("Select HItemID from Gy_ProjectStage Where HParentID='" + HItemID + "'", " Gy_ProjectStage");
+ if (ds1.Tables[0].Rows.Count != 0)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "姝ら」鐩瓨鍦ㄥ瓙椤圭洰锛屼笉鑳藉垹闄わ紒";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+
+ string HUseFlag = Convert.ToString(ds.Tables[0].Rows[0]["HUseFlag"]);
+ if (HUseFlag == "宸蹭娇鐢�")
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "姝ら」鐩凡浣跨敤锛屼笉鑳藉垹闄わ紒";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+
+ oCN.RunProc("delete from Gy_ProjectStage where HItemID=" + HItemID);
+ oCN.Commit();//鎻愪氦浜嬪姟
+ objJsonResult.code = "0";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "* 鏁版嵁鍒犻櫎鎴愬姛锛�";
+ objJsonResult.data = null;
+ return objJsonResult; ;
+
+ }
+ catch (Exception e)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "鍒犻櫎澶辫触锛�" + e.ToString();
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ }
+ #endregion
}
}
\ No newline at end of file
--
Gitblit v1.9.1