WebAPI/Controllers/BaseSet/Gy_ConkTypeController.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/Controllers/BaseSet/Gy_PackTypeController.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/Controllers/基础资料/基础资料/Gy_WorkStationBillController.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/Models/基础资料/ConkType.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/Models/基础资料/PackType.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/Models/基础资料/WorkStation.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/WebAPI.csproj | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
WebAPI/Controllers/BaseSet/Gy_ConkTypeController.cs
New file @@ -0,0 +1,333 @@ using Newtonsoft.Json.Linq; using Pub_Class; using System; using System.Collections; using System.Collections.Generic; using System.Data; using System.Data.SqlClient; using System.Web.Http; using WebAPI.Models; namespace WebAPI.Controllers { public class Gy_ConkTypeController : ApiController { public DBUtility.ClsPub.Enum_BillStatus BillStatus; private json objJsonResult = new json(); SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); DataSet ds; /// <summary> /// è¿åä»åºå表 ///åæ°ï¼string sqlã ///è¿åå¼ï¼objectã /// </summary> [Route("Gy_ConkType/list")] [HttpGet] public object list(string sWhere, string user) { try { //ç¼è¾æé //if (!DBUtility.ClsPub.Security_Log_second("Gy_ConkType", 1, false, user)) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "æ æ¥çæéï¼"; // objJsonResult.data = null; // return objJsonResult; //} string sql1 = string.Format(@"select * from h_v_Gy_ConkTypeList where 1='" + 1 + "'"); if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn(sql1 + sWhere + " order by æ éç±»å«ä»£ç ", "h_v_Gy_ConkTypeList"); } else { string sql = sql1 + sWhere + " order by æ éç±»å«ä»£ç "; ds = oCN.RunProcReturn(sql, "h_v_Gy_ConkTypeList"); } 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; } } /// <summary> /// ä¿åæé® ///åæ°ï¼string sqlã ///è¿åå¼ï¼objectã /// </summary> [Route("Gy_ConkType/ModifyByID")] [HttpPost] public object ModifyByID([FromBody] JObject oMain) { try { //DAL.ClsGy_Warehouse_Ctl oDept = new DAL.ClsGy_Warehouse_Ctl(); //DAL.ClsGy_Warehouse_View oDeptHlp = new DAL.ClsGy_Warehouse_View(); var _value = oMain["oMain"].ToString(); string msg1 = _value.ToString(); string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); string msg3 = sArray[1].ToString(); //ååºåå msg2 = "[" + msg2.ToString() + "]"; List<ConkType> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ConkType>>(msg2); long HItemID = list[0].HItemID; string HNumber = list[0].HNumber; string HName = list[0].HName; string HHelpCode = list[0].HHelpCode; string HShortNumber = list[0].HShortNumber; long HParentID = list[0].HParentID; long HLevel = list[0].HLevel; bool HEndFlag = list[0].HEndFlag; bool HStopflag = list[0].HStopflag; string HRemark = list[0].HRemark; string HUseFlag = list[0].HUseFlag; DateTime HMakeTime = list[0].HMakeTime; string HMakeEmp = list[0].HMakeEmp; string HCheckEmp = list[0].HCheckEmp; DateTime HCheckTime = list[0].HCheckTime; string HModifyEmp = list[0].HModifyEmp; DateTime HModifyTime = list[0].HModifyTime; string HStopEmp = list[0].HStopEmp; DateTime HStopTime = list[0].HStopTime; long HUSEORGID = list[0].HUSEORGID; long HCREATEORGID = list[0].HCREATEORGID; #region [注é代ç ] ////夿æé //if (!ClsPub.Security_Log("Gy_Warehouse_Edit", 1, false, msg3)) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "æ²¡ææ¾å°è¯¥åè½æ¨¡åï¼"; // objJsonResult.data = null; // return objJsonResult; //} //if (!DBUtility.ClsPub.AllowNumber(HNumber)) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "代ç ä¸ä¸è½åºç°è¿ç»â.âå¹¶ä¸é¦ä½æ«ä½ä¸è½ä¸ºâ.âï¼"; // objJsonResult.data = null; // return objJsonResult; //} //if (oDept.HavSameNumber(HItemID, HNumber)) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "代ç éå¤ï¼"; // objJsonResult.data = null; // return objJsonResult; //} #endregion //ä¿å //ä¿å宿¯åå¤ç if (HItemID == 0) { oCN.BeginTran(); oCN.RunProc("Insert into Gy_ConkType " + " (HNumber,HName,HHelpCode,HShortNumber,HParentID" + ",HLevel,HEndFlag,HStopflag,HRemark,HUseFlag,HMakeTime,HMakeEmp," + "HUSEORGID,HCREATEORGID) " + " Values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "'," + HParentID.ToString() + "," + HLevel.ToString() + "," + Convert.ToString(HEndFlag ? 1 : 0) + "," + Convert.ToString(HStopflag ? 1 : 0) + ",'" + HRemark + "'," + HUseFlag + ",'" + HMakeTime + "','" + HMakeEmp + "','" + HUSEORGID + "','" + HCREATEORGID + "')", ref DBUtility.ClsPub.sExeReturnInfo); //ä¿®æ¹ä¸çº§ä¸ºéæ«çº§ä»£ç oCN.RunProc("Update Gy_ConkType set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo); oCN.Commit(); } else { //è¥MAINDIéå¤åéæ°è·å oCN.BeginTran(); //主表 oCN.RunProc("Update Gy_ConkType set " + " HNumber='" + HNumber + "'" + ",HName='" + HName + "'" + ",HShortNumber='" + HShortNumber + "'" + ",HHelpCode='" + HHelpCode + "'" + ",HLevel=" + HLevel.ToString() + ",HParentID=" + HParentID.ToString() + ",HEndflag=" + Convert.ToString(HEndFlag ? 1 : 0) + ",HStopflag=" + Convert.ToString(HStopflag ? 1 : 0) + ",HMakeEmp='" + HMakeEmp + "'" + ",HUseFlag='" + HUseFlag + "'" + ",HRemark= '" + HRemark + "' Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo); //ä¿®æ¹å项ç®ä»£ç //oCN.RunProc("exec h_p_Gy_UpdateNumber Gy_Warehouse,'" + HNumber + ".','" + this.HOldNumber + ".'", ref DBUtility.ClsPub.sExeReturnInfo); //å°ä¸çº§ ä¸ºéæ«çº§ oCN.RunProc("Update Gy_ConkType set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo); // oCN.Commit(); } objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "ä¿åæåï¼"; //WebAPIController.Add_Log("éè´§å䏿¨", UserName, "çæéè´§å"); objJsonResult.data = 1; return objJsonResult; } catch (Exception e) { //oCN.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exceptionï¼" + e.Message; objJsonResult.data = null; return objJsonResult; } } /// <summary> /// æ ¹æ®åºç¡èµæID æ¥æ¾è®°å½ ///åæ°ï¼string sqlã ///è¿åå¼ï¼objectã /// </summary> [Route("Gy_ConkType/cx")] [HttpGet] public object cx(long HInterID) { try { ds = oCN.RunProcReturn("select * from h_v_Gy_ConkTypeList where HitemID=" + HInterID, "h_v_Gy_ConkTypeList"); if (ds == null || ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "falseï¼"; objJsonResult.data = null; return objJsonResult; } else { 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; } } /// <summary> /// å è£ æ¹å¼å表å é¤åè½ /// </summary> /// <returns></returns> [Route("DeltetGy_ConkType")] [HttpGet] public object DeltetGy_ConkType(string HItemID, string user) { DataSet ds; DataSet ds1; try { ////å 餿é //if (!DBUtility.ClsPub.Security_Log("Gy_Warehouse_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_ConkType where HItemID=" + HItemID, "Gy_ConkType"); 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_ConkType Where HParentID='" + HItemID + "'", "Gy_ConkType"); 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_ConkType 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; } } } } WebAPI/Controllers/BaseSet/Gy_PackTypeController.cs
New file @@ -0,0 +1,333 @@ using Newtonsoft.Json.Linq; using Pub_Class; using System; using System.Collections; using System.Collections.Generic; using System.Data; using System.Data.SqlClient; using System.Web.Http; using WebAPI.Models; namespace WebAPI.Controllers { public class Gy_PackTypeController : ApiController { public DBUtility.ClsPub.Enum_BillStatus BillStatus; private json objJsonResult = new json(); SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); DataSet ds; /// <summary> /// è¿åä»åºå表 ///åæ°ï¼string sqlã ///è¿åå¼ï¼objectã /// </summary> [Route("Gy_PackType/list")] [HttpGet] public object list(string sWhere, string user) { try { //ç¼è¾æé //if (!DBUtility.ClsPub.Security_Log_second("Gy_PackType", 1, false, user)) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "æ æ¥çæéï¼"; // objJsonResult.data = null; // return objJsonResult; //} string sql1 = string.Format(@"select * from h_v_Gy_PackTypeList where 1='" + 1 + "'"); if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn(sql1 + sWhere + " order by å è£ æ¹å¼ä»£ç ", "h_v_Gy_PackTypeList"); } else { string sql = sql1 + sWhere + " order by å è£ æ¹å¼ä»£ç "; ds = oCN.RunProcReturn(sql, "h_v_Gy_PackTypeList"); } 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; } } /// <summary> /// ä¿åæé® ///åæ°ï¼string sqlã ///è¿åå¼ï¼objectã /// </summary> [Route("Gy_PackType/ModifyByID")] [HttpPost] public object ModifyByID([FromBody] JObject oMain) { try { //DAL.ClsGy_Warehouse_Ctl oDept = new DAL.ClsGy_Warehouse_Ctl(); //DAL.ClsGy_Warehouse_View oDeptHlp = new DAL.ClsGy_Warehouse_View(); var _value = oMain["oMain"].ToString(); string msg1 = _value.ToString(); string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); string msg3 = sArray[1].ToString(); //ååºåå msg2 = "[" + msg2.ToString() + "]"; List<PackType> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<PackType>>(msg2); long HItemID = list[0].HItemID; string HNumber = list[0].HNumber; string HName = list[0].HName; string HHelpCode = list[0].HHelpCode; string HShortNumber = list[0].HShortNumber; long HParentID = list[0].HParentID; long HLevel = list[0].HLevel; bool HEndFlag = list[0].HEndFlag; bool HStopflag = list[0].HStopflag; string HRemark = list[0].HRemark; string HUseFlag = list[0].HUseFlag; DateTime HMakeTime = list[0].HMakeTime; string HMakeEmp = list[0].HMakeEmp; string HPackMaterial = list[0].HPackMaterial; decimal HLenhth = list[0].HLenhth; decimal HWidth = list[0].HWidth; decimal HHeight = list[0].HHeight; #region [注é代ç ] ////夿æé //if (!ClsPub.Security_Log("Gy_Warehouse_Edit", 1, false, msg3)) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "æ²¡ææ¾å°è¯¥åè½æ¨¡åï¼"; // objJsonResult.data = null; // return objJsonResult; //} //if (!DBUtility.ClsPub.AllowNumber(HNumber)) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "代ç ä¸ä¸è½åºç°è¿ç»â.âå¹¶ä¸é¦ä½æ«ä½ä¸è½ä¸ºâ.âï¼"; // objJsonResult.data = null; // return objJsonResult; //} //if (oDept.HavSameNumber(HItemID, HNumber)) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "代ç éå¤ï¼"; // objJsonResult.data = null; // return objJsonResult; //} #endregion //ä¿å //ä¿å宿¯åå¤ç if (HItemID == 0) { oCN.BeginTran(); oCN.RunProc("Insert into Gy_PackType " + " (HNumber,HName,HHelpCode,HShortNumber,HParentID" + ",HLevel,HEndFlag,HStopflag,HRemark,HUseFlag,HMakeTime,HMakeEmp,HPackMaterial,HLenhth,HWidth,HHeight) " + " Values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "'," + HParentID.ToString() + "," + HLevel.ToString() + "," + Convert.ToString(HEndFlag ? 1 : 0) + "," + Convert.ToString(HStopflag ? 1 : 0) + ",'" + HRemark + "'," + HUseFlag + ",'" + HMakeTime + "','" + HMakeEmp + "','" + HPackMaterial + "','" + HLenhth + "','" + HWidth + "','" + HHeight + "')", ref DBUtility.ClsPub.sExeReturnInfo); //ä¿®æ¹ä¸çº§ä¸ºéæ«çº§ä»£ç oCN.RunProc("Update Gy_PackType set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo); oCN.Commit(); } else { //è¥MAINDIéå¤åéæ°è·å oCN.BeginTran(); //主表 oCN.RunProc("Update Gy_PackType set " + " HNumber='" + HNumber + "'" + ",HName='" + HName + "'" + ",HShortNumber='" + HShortNumber + "'" + ",HHelpCode='" + HHelpCode + "'" + ",HLevel=" + HLevel.ToString() + ",HParentID=" + HParentID.ToString() + ",HEndflag=" + Convert.ToString(HEndFlag ? 1 : 0) + ",HStopflag=" + Convert.ToString(HStopflag ? 1 : 0) + ",HMakeEmp='" + HMakeEmp + "'" + ",HPackMaterial='" + HPackMaterial + "'" + ",HLenhth='" + HLenhth + "'" + ",HWidth='" + HWidth + "'" + ",HHeight='" + HHeight + "'" + ",HUseFlag='" + HUseFlag + "'" + ",HRemark= '" + HRemark + "' Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo); //ä¿®æ¹å项ç®ä»£ç //oCN.RunProc("exec h_p_Gy_UpdateNumber Gy_Warehouse,'" + HNumber + ".','" + this.HOldNumber + ".'", ref DBUtility.ClsPub.sExeReturnInfo); //å°ä¸çº§ ä¸ºéæ«çº§ oCN.RunProc("Update Gy_PackType set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo); // oCN.Commit(); } objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "ä¿åæåï¼"; //WebAPIController.Add_Log("éè´§å䏿¨", UserName, "çæéè´§å"); objJsonResult.data = 1; return objJsonResult; } catch (Exception e) { //oCN.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exceptionï¼" + e.Message; objJsonResult.data = null; return objJsonResult; } } /// <summary> /// æ ¹æ®åºç¡èµæID æ¥æ¾è®°å½ ///åæ°ï¼string sqlã ///è¿åå¼ï¼objectã /// </summary> [Route("Gy_PackType/cx")] [HttpGet] public object cx(long HInterID) { try { ds = oCN.RunProcReturn("select * from h_v_Gy_PackTypeList where HitemID=" + HInterID, "h_v_Gy_PackTypeList"); if (ds == null || ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "falseï¼"; objJsonResult.data = null; return objJsonResult; } else { 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; } } /// <summary> /// å è£ æ¹å¼å表å é¤åè½ /// </summary> /// <returns></returns> [Route("DeltetGy_PackType")] [HttpGet] public object DeltetGy_PackType(string HItemID, string user) { DataSet ds; DataSet ds1; try { ////å 餿é //if (!DBUtility.ClsPub.Security_Log("Gy_Warehouse_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_PackType where HItemID=" + HItemID, "Gy_PackType"); 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_PackType Where HParentID='" + HItemID + "'", "Gy_PackType"); 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_PackType 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; } } } } WebAPI/Controllers/»ù´¡×ÊÁÏ/»ù´¡×ÊÁÏ/Gy_WorkStationBillController.cs
@@ -54,5 +54,250 @@ } } #endregion #region ä¿åæé® [Route("Gy_WorkStationBill/ModifyByID")] [HttpPost] public object ModifyByID([FromBody] JObject oMain) { try { //DAL.ClsGy_Warehouse_Ctl oDept = new DAL.ClsGy_Warehouse_Ctl(); //DAL.ClsGy_Warehouse_View oDeptHlp = new DAL.ClsGy_Warehouse_View(); var _value = oMain["oMain"].ToString(); string msg1 = _value.ToString(); string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); string msg3 = sArray[1].ToString(); //ååºåå msg2 = "[" + msg2.ToString() + "]"; List<WorkStation> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<WorkStation>>(msg2); long HItemID = list[0].HItemID; string HNumber = list[0].HNumber; string HName = list[0].HName; string HHelpCode = list[0].HHelpCode; string HShortNumber = list[0].HShortNumber; long HParentID = list[0].HParentID; long HLevel = list[0].HLevel; bool HEndFlag = list[0].HEndFlag; bool HStopflag = list[0].HStopflag; string HRemark = list[0].HRemark; long HUSEORGID = list[0].HUSEORGID; long HCREATEORGID = list[0].HCREATEORGID; #region [注é代ç ] ////夿æé //if (!ClsPub.Security_Log("Gy_Warehouse_Edit", 1, false, msg3)) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "æ²¡ææ¾å°è¯¥åè½æ¨¡åï¼"; // objJsonResult.data = null; // return objJsonResult; //} //if (!DBUtility.ClsPub.AllowNumber(HNumber)) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "代ç ä¸ä¸è½åºç°è¿ç»â.âå¹¶ä¸é¦ä½æ«ä½ä¸è½ä¸ºâ.âï¼"; // objJsonResult.data = null; // return objJsonResult; //} //if (oDept.HavSameNumber(HItemID, HNumber)) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "代ç éå¤ï¼"; // objJsonResult.data = null; // return objJsonResult; //} #endregion //ä¿å //ä¿å宿¯åå¤ç if (HItemID == 0) { oCN.BeginTran(); oCN.RunProc("Insert into Gy_WorkStation " + " (HNumber,HName,HHelpCode,HShortNumber,HParentID" + ",HLevel,HEndFlag,HStopflag,HRemark," + "HUSEORGID,HCREATEORGID) " + " Values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "'," + HParentID.ToString() + "," + HLevel.ToString() + "," + Convert.ToString(HEndFlag ? 1 : 0) + "," + Convert.ToString(HStopflag ? 1 : 0) + ",'" + HRemark + "'," + HUSEORGID + ",'" + HCREATEORGID + "')", ref DBUtility.ClsPub.sExeReturnInfo); //ä¿®æ¹ä¸çº§ä¸ºéæ«çº§ä»£ç oCN.RunProc("Update Gy_WorkStation set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo); oCN.Commit(); } else { //è¥MAINDIéå¤åéæ°è·å oCN.BeginTran(); //主表 oCN.RunProc("Update Gy_WorkStation set " + " HNumber='" + HNumber + "'" + ",HName='" + HName + "'" + ",HShortNumber='" + HShortNumber + "'" + ",HHelpCode='" + HHelpCode + "'" + ",HLevel=" + HLevel.ToString() + ",HParentID=" + HParentID.ToString() + ",HEndflag=" + Convert.ToString(HEndFlag ? 1 : 0) + ",HStopflag=" + Convert.ToString(HStopflag ? 1 : 0) + ",HRemark= '" + HRemark + "' Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo); //ä¿®æ¹å项ç®ä»£ç //oCN.RunProc("exec h_p_Gy_UpdateNumber Gy_Warehouse,'" + HNumber + ".','" + this.HOldNumber + ".'", ref DBUtility.ClsPub.sExeReturnInfo); //å°ä¸çº§ ä¸ºéæ«çº§ oCN.RunProc("Update Gy_WorkStation set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo); // oCN.Commit(); } objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "ä¿åæåï¼"; //WebAPIController.Add_Log("éè´§å䏿¨", UserName, "çæéè´§å"); objJsonResult.data = 1; return objJsonResult; } catch (Exception e) { //oCN.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exceptionï¼" + e.Message; objJsonResult.data = null; return objJsonResult; } } #endregion #region æ ¹æ®åºç¡èµæID æ¥æ¾è®°å½ [Route("Gy_WorkStationBill/cx")] [HttpGet] public object cx(long HInterID) { try { ds = oCN.RunProcReturn("select * from h_v_Gy_WorkStationList where HitemID=" + HInterID, "h_v_Gy_WorkStationList"); if (ds == null || ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "falseï¼"; objJsonResult.data = null; return objJsonResult; } else { 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 å·¥ä½å表å é¤åè½ [Route("DeltetGy_WorkStation")] [HttpGet] public object DeltetGy_WorkStation(string HItemID, string user) { DataSet ds; DataSet ds1; try { ////å 餿é //if (!DBUtility.ClsPub.Security_Log("Gy_Warehouse_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_WorkStation where HItemID=" + HItemID, "Gy_WorkStation"); 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_WorkStation Where HParentID='" + HItemID + "'", "Gy_WorkStation"); 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_WorkStation 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 } } WebAPI/Models/»ù´¡×ÊÁÏ/ConkType.cs
New file @@ -0,0 +1,32 @@ using System; using System.Collections.Generic; using System.Linq; using System.Web; namespace WebAPI.Models { public class ConkType { public bool HEndFlag { get; set; } //æ«çº§æ å¿ public string HHelpCode { get; set; } //å©è®°ç public long HItemID { get; set; } //ä¸»é® public long HLevel { get; set; } //ç级 public string HName { get; set; } //åç§° public string HNumber { get; set; } //代ç public long HParentID { get; set; } //ç¶çº§ID public string HRemark { get; set; } //夿³¨ public string HShortNumber { get; set; } //ç代ç public bool HStopflag { get; set; } //ç¦ç¨æ å¿ public string HUseFlag { get; set; } //使ç¨ç¶æ public DateTime HMakeTime { get; set; } //å»ºç«æ¶é´ public string HMakeEmp { get; set; } //å建人 public string HCheckEmp { get; set; } //å®¡æ ¸äºº public DateTime HCheckTime { get; set; } //å®¡æ ¸äºº public string HModifyEmp { get; set; } //ä¿®æ¹äºº public DateTime HModifyTime { get; set; } //ä¿®æ¹æ¶é´ public string HStopEmp { get; set; } //ç¦ç¨äºº public DateTime HStopTime { get; set; } //ç¦ç¨æ¶é´ public long HUSEORGID { get; set; } //使ç¨ç»ç» public long HCREATEORGID { get; set; } //å建ç»ç» } } WebAPI/Models/»ù´¡×ÊÁÏ/PackType.cs
New file @@ -0,0 +1,28 @@ using System; using System.Collections.Generic; using System.Linq; using System.Web; namespace WebAPI.Models { public class PackType { public bool HEndFlag { get; set; } //æ«çº§æ å¿ public string HHelpCode { get; set; } //å©è®°ç public long HItemID { get; set; } //ä¸»é® public long HLevel { get; set; } //ç级 public string HName { get; set; } //åç§° public string HNumber { get; set; } //代ç public long HParentID { get; set; } //ç¶çº§ID public string HRemark { get; set; } //夿³¨ public string HShortNumber { get; set; } //ç代ç public bool HStopflag { get; set; } //ç¦ç¨æ å¿ public string HUseFlag { get; set; } //使ç¨ç¶æ public DateTime HMakeTime { get; set; } //å»ºç«æ¶é´ public string HMakeEmp { get; set; } //å建人 public string HPackMaterial { get; set; } //å è£ æè´¨ public decimal HLenhth { get; set; } //é¿ public decimal HWidth { get; set; } //宽 public decimal HHeight { get; set; } //é« } } WebAPI/Models/»ù´¡×ÊÁÏ/WorkStation.cs
New file @@ -0,0 +1,23 @@ using System; using System.Collections.Generic; using System.Linq; using System.Web; namespace WebAPI.Models { public class WorkStation { public bool HEndFlag { get; set; } //æ«çº§æ å¿ public string HHelpCode { get; set; } //å©è®°ç public long HItemID { get; set; } //ä¸»é® public long HLevel { get; set; } //ç级 public string HName { get; set; } //åç§° public string HNumber { get; set; } //代ç public long HParentID { get; set; } //ç¶çº§ID public string HRemark { get; set; } //夿³¨ public string HShortNumber { get; set; } //ç代ç public bool HStopflag { get; set; } //ç¦ç¨æ å¿ public long HUSEORGID { get; set; } //使ç¨ç»ç» public long HCREATEORGID { get; set; } //å建ç»ç» } } WebAPI/WebAPI.csproj
@@ -320,6 +320,8 @@ <Compile Include="App_Start\SwaggerConfig.cs" /> <Compile Include="App_Start\WebApiConfig.cs" /> <Compile Include="Controllers\BaseSet\Gy_BarCodeBillController.cs" /> <Compile Include="Controllers\BaseSet\Gy_ConkTypeController.cs" /> <Compile Include="Controllers\BaseSet\Gy_PackTypeController.cs" /> <Compile Include="Controllers\BaseSet\Gy_RoutingGroupController.cs" /> <Compile Include="Controllers\BaseSet\Gy_TechnologyController.cs" /> <Compile Include="Controllers\BaseSet\Gy_TechnologyParUnitController.cs" /> @@ -597,7 +599,10 @@ <Compile Include="Models\TechParamByProc.cs" /> <Compile Include="Models\å ¶å®\ReciveBill_FastModel.cs" /> <Compile Include="Models\卿å\OptionListModel.cs" /> <Compile Include="Models\åºç¡èµæ\ConkType.cs" /> <Compile Include="Models\åºç¡èµæ\Gy_ClassTimePrj.cs" /> <Compile Include="Models\åºç¡èµæ\PackType.cs" /> <Compile Include="Models\åºç¡èµæ\WorkStation.cs" /> <Compile Include="Models\å·¥èµç®¡ç\ClsGy_ClassTimePrj_Model.cs" /> <Compile Include="Models\å·¥èµç®¡ç\ClsPay_GroupBalBillEmp.cs" /> <Compile Include="Models\å·¥èµç®¡ç\ClsPay_GroupBalBillMain.cs" /> @@ -851,9 +856,11 @@ <Folder Include="Views\Cj_CallGoodsBillMain\" /> <Folder Include="Views\Cj_ComplementGoodsBill\" /> <Folder Include="Views\Cj_SendGoodsBill\" /> <Folder Include="Views\Gy_ConkType\" /> <Folder Include="Views\Gy_EquipType\" /> <Folder Include="Views\Gy_ICBomBill\" /> <Folder Include="Views\Gy_MateMould\" /> <Folder Include="Views\Gy_PackType\" /> <Folder Include="Views\Gy_RoutingGroup\" /> <Folder Include="Views\Gy_WorkStation\" /> <Folder Include="Views\JIT_DayPlanPlatFormBill\" />