派生自 MES-WEB-API
WebAPI/Controllers/»ù´¡×ÊÁÏ/»ù´¡×ÊÁÏ/Gy_StockCheckItemBillController.cs
@@ -290,7 +290,37 @@ } #endregion #region çç¹åæå表 å é¤ ä¸éè¦çæ°æ® [Route("Gy_StockCheckItemBill/StockItemSubDel")] [HttpGet] public object StockItemSubDel(string sID) { try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); oCn.BeginTran(); oCN.RunProc("exec h_p_StockItemSubDel " + sID); oCn.Commit(); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "å é¤æåï¼"; objJsonResult.data = null; return objJsonResult; } catch (Exception ex) { oCn.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ¥è¯¢æ°æ®å¼å¸¸ï¼è¯·ä¸ç®¡çåèç³»ï¼" + ex.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region çç¹åæå表 [Route("Gy_StockCheckItemBill/Get_InventoryAnalysisList")] @@ -306,20 +336,29 @@ //å¤ææ¯å¦éæ©çç¹æ¹æ¡ï¼æ¯=>ï¼ç¨çç¹æ¹æ¡å表å对æ¯ï¼ï¼å¦=>ï¼ç¨å¨å ·æ¡£æ¡å对æ¯ï¼ if (sID == null || sID == "") { if (sWhere == "pk") { sql = string.Format(@"select * from h_v_Sc_MouldInventoryAnalysisPK"); } else { sql = string.Format($"exec h_p_Sc_MouldInventoryAnalysisList2 '{sWhere}'"); } //if (sWhere == "pk") //{ // sql = string.Format(@"select * from h_v_Sc_MouldInventoryAnalysisPK"); //} //else //{ // sql = string.Format($"exec h_p_Sc_MouldInventoryAnalysisList2 '{sWhere}'"); //} objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "请éæ©çç¹æ¹æ¡!"; objJsonResult.data = null; return objJsonResult; } else { if (sWhere == "pk") { sql = string.Format($"exec h_p_Sc_MouldInventoryAnalysisPK '{sID}'"); } else if (sWhere == "py") { sql = string.Format($"exec h_p_Sc_MouldInventoryAnalysisPY '{sID}'"); } else { @@ -355,22 +394,13 @@ { ds = MouldStockBillMainTemp(sWhere); //if (ds.Tables[0].Rows.Count != 0 || ds != null) //{ objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucessï¼"; objJsonResult.data = ds.Tables[0]; return objJsonResult; //} //else //{ //objJsonResult.code = "0"; //objJsonResult.count = 0; //objJsonResult.Message = "æ æ°æ®"; //objJsonResult.data = null; //return objJsonResult; //} } catch (Exception ex) { @@ -448,10 +478,10 @@ string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString();//è¡¨æ ¼æ°æ® string user = sArray[1].ToString();//user string userID = sArray[2].ToString();//userID string HOrgID = sArray[2].ToString();//HOrgID string sName = sArray[3].ToString();//çç¹æ¹æ¡ //æ¥è¯¢çç¹æ¹æ¡å建æ¥æ DataSet dd = oCn.RunProcReturn("select * from Gy_StockCheckItem where HName=" + sName, "Gy_StockCheckItem"); DataSet dd = oCn.RunProcReturn("select * from Gy_StockCheckItem where HName='" + sName+"'", "Gy_StockCheckItem"); string HDate = dd.Tables[0].Rows[0]["HMakeTime"].ToString(); //转åæ ¼å¼ @@ -492,7 +522,7 @@ HStockOrgID,HOWNERID,HOtherOrgID,HOWNERTYPEID) values(" + HInterID + ",1,'',getdate(),0,'" + sName.ToString() + "',0,0,'',''," + "0,0," + dr["HInterID"].ToString() + ",0," + dr["HSecUnitRate"].ToString() + ",0," + dr["HUnitID"].ToString() + ",0," + dr["HProdQty"].ToString() + "," + dr1["HQty"].ToString() + ",0," + "0," + dr["HDesignLife"].ToString() + "," + dr["HLeaveLife"].ToString() + "," + dr["HUseLife"].ToString() + "," + dr1["HCorrespondentID"].ToString() + "," + dr["HNowSupID"].ToString() + ",0,0" + ",0,0,0," + userID + ",0,100005,'')"); + ",0,0,0," + HOrgID + ",0,100005,'')"); //主表 oCn.BeginTran(); @@ -537,10 +567,10 @@ string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString();//è¡¨æ ¼æ°æ® string user = sArray[1].ToString();//user string userID = sArray[2].ToString();//userID string HOrgID = sArray[2].ToString();//HOrgID string sName = sArray[3].ToString();//çç¹æ¹æ¡ //æ¥è¯¢çç¹æ¹æ¡å建æ¥æ DataSet dd = oCn.RunProcReturn("select * from Gy_StockCheckItem where HName=" + sName, "Gy_StockCheckItem"); DataSet dd = oCn.RunProcReturn("select * from Gy_StockCheckItem where HName='" + sName + "'", "Gy_StockCheckItem"); string HDate = dd.Tables[0].Rows[0]["HMakeTime"].ToString(); //转åæ ¼å¼ @@ -561,19 +591,32 @@ ds1 = oCn.RunProcReturn("select top 1 * from Sc_MouldStockBillMain_Temp where HBarCode='" + HBarCode + "' and HItemID='" + HItemID + "'", "Sc_MouldStockBillMain_Temp"); DataRow dr = ds.Tables[0].Rows[0]; DataRow dr1 = ds1.Tables[0].Rows[0]; HInterID = DBUtility.ClsPub.CreateBillID("3827", ref DBUtility.ClsPub.sExeReturnInfo); HBillNo = DBUtility.ClsPub.CreateBillCode("3827", ref DBUtility.ClsPub.sExeReturnInfo, true); string HBillType = ""; if (item.HRealPotType == "ä»åº" ) { HBillType = "3827"; HInterID = DBUtility.ClsPub.CreateBillID("3827", ref DBUtility.ClsPub.sExeReturnInfo); HBillNo = DBUtility.ClsPub.CreateBillCode("3827", ref DBUtility.ClsPub.sExeReturnInfo, true); } else if (item.HRealPotType != "ä»åº") { HBillType = "3802"; HInterID = DBUtility.ClsPub.CreateBillID("3802", ref DBUtility.ClsPub.sExeReturnInfo); HBillNo = DBUtility.ClsPub.CreateBillCode("3802", ref DBUtility.ClsPub.sExeReturnInfo, true); } string sql = "Insert Into Sc_MouldStockBillMain " + "(HBillType,HBillSubType,HInterID,HBillNo,HDate" + ",HMaker,HMakeDate,HRemark" + ",HSupID,HSupTypeID,HWHID,HSCWHID,HEmpID,HManagerID,HSecManagerID" + ",HKeeperID,HDeptID,HInnerBillNo,HRedBlueFlag" + ") " + " values('3827','3827'," + HInterID + ",'" + HBillNo + "','" + HDate + "'" + ", '" + user + "','" +HDate + "','" + sName + "'" + " values('"+ HBillType + "','" + HBillType + "'," + HInterID + ",'" + HBillNo + "','" + HDate + "'" + ", '" + user + "','" + HDate + "','" + sName + "'" + ", " + dr1["HCorrespondentID"].ToString() + "," + dr1["HCorrespondentTypeID"].ToString() + ",isnull('" + dr["HNowSupID"].ToString() + "',0),0,0,0,0" + ", 0," + dr["HDeptID"].ToString() + ",'',0" + ") "; string sql1 = string.Format(@"Insert Into Sc_MouldStockBillSub (HInterID,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark,HSourceInterID, HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney,HMaterID,HPropertyID,HSecUnitRate,HSecUnitID,HUnitID, @@ -581,7 +624,7 @@ HStockOrgID,HOWNERID,HOtherOrgID,HOWNERTYPEID) values(" + HInterID + ",1,'',getdate(),0,'" + sName.ToString() + "',0,0,'',''," + "0,0," + dr["HInterID"].ToString() + ",0," + dr["HSecUnitRate"].ToString() + ",0," + dr["HUnitID"].ToString() + ",0," + dr["HProdQty"].ToString() + "," + dr1["HQty"].ToString() + ",0," + "0," + dr["HDesignLife"].ToString() + "," + dr["HLeaveLife"].ToString() + "," + dr["HUseLife"].ToString() + "," + dr1["HCorrespondentID"].ToString() + "," + dr["HNowSupID"].ToString() + ",0,0" + ",0,0,0," + userID + ",0,100005,'')"); + ",0,0,0," + HOrgID + ",0,100005,'')"); //主表 oCn.BeginTran(); @@ -627,10 +670,10 @@ string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString();//è¡¨æ ¼æ°æ® string user = sArray[1].ToString();//user string userID = sArray[2].ToString();//userID string HOrgID = sArray[2].ToString();//HOrgID string sName = sArray[3].ToString();//çç¹æ¹æ¡ //æ¥è¯¢çç¹æ¹æ¡å建æ¥æ DataSet dd = oCn.RunProcReturn("select * from Gy_StockCheckItem where HName=" + sName, "Gy_StockCheckItem"); DataSet dd = oCn.RunProcReturn("select * from Gy_StockCheckItem where HName='" + sName+"'", "Gy_StockCheckItem"); string HDate = dd.Tables[0].Rows[0]["HMakeTime"].ToString(); @@ -671,7 +714,7 @@ HStockOrgID,HOWNERID,HOtherOrgID,HOWNERTYPEID) values(" + HInterID + ",1,'',getdate(),0,'" + sName.ToString() + "',0,0,'',''," + "0,0," + dr["HInterID"].ToString() + ",0," + dr["HSecUnitRate"].ToString() + ",0," + dr["HUnitID"].ToString() + ",0," + dr["HProdQty"].ToString() + ",0,0," + "0," + dr["HDesignLife"].ToString() + "," + dr["HLeaveLife"].ToString() + "," + dr["HUseLife"].ToString() + ",0,0,0,0" + ",0,0,0," + userID + ",0,100005,'')"); + ",0,0,0," + HOrgID + ",0,100005,'')"); } else { @@ -694,7 +737,7 @@ HStockOrgID,HOWNERID,HOtherOrgID,HOWNERTYPEID) values(" + HInterID + ",1,'',getdate(),0,'" + sName.ToString() + "',0,0,'',''," + "0,0," + dr["HInterID"].ToString() + ",0," + dr["HSecUnitRate"].ToString() + ",0," + dr["HUnitID"].ToString() + ",0," + dr["HProdQty"].ToString() + "," + dr1["HQty"].ToString() + ",0," + "0," + dr["HDesignLife"].ToString() + "," + dr["HLeaveLife"].ToString() + "," + dr["HUseLife"].ToString() + "," + dr1["HCorrespondentID"].ToString() + "," + dr["HNowSupID"].ToString() + ",0,0" + ",0,0,0," + userID + ",0,100005,'')"); + ",0,0,0," + HOrgID + ",0,100005,'')"); } //主表 @@ -740,10 +783,10 @@ string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString();//è¡¨æ ¼æ°æ® string user = sArray[1].ToString();//user string userID = sArray[2].ToString();//userID string HOrgID = sArray[2].ToString();//HOrgID string sName = sArray[3].ToString();//çç¹æ¹æ¡ //æ¥è¯¢çç¹æ¹æ¡å建æ¥æ DataSet dd = oCn.RunProcReturn("select * from Gy_StockCheckItem where HName=" + sName, "Gy_StockCheckItem"); DataSet dd = oCn.RunProcReturn("select * from Gy_StockCheckItem where HName='" + sName + "'", "Gy_StockCheckItem"); string HDate = dd.Tables[0].Rows[0]["HMakeTime"].ToString(); //转åæ ¼å¼ @@ -783,7 +826,7 @@ HStockOrgID,HOWNERID,HOtherOrgID,HOWNERTYPEID) values(" + HInterID + ",1,'',getdate(),0,'" + sName.ToString() + "',0,0,'',''," + "0,0," + dr["HInterID"].ToString() + ",0," + dr["HSecUnitRate"].ToString() + ",0," + dr["HUnitID"].ToString() + ",0," + dr["HProdQty"].ToString() + "," + dr1["HQty"].ToString() + ",0," + "0," + dr["HDesignLife"].ToString() + "," + dr["HLeaveLife"].ToString() + "," + dr["HUseLife"].ToString() + ",'1548785'," + dr["HNowSupID"].ToString() + ",0,0" + ",0,0,0," + userID + ",0,100005,'')"); + ",0,0,0," + HOrgID + ",0,100005,'')"); //主表 oCn.BeginTran(); @@ -828,10 +871,10 @@ string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString();//è¡¨æ ¼æ°æ® string user = sArray[1].ToString();//user string userID = sArray[2].ToString();//userID string HOrgID = sArray[2].ToString();//HOrgID string sName = sArray[3].ToString();//çç¹æ¹æ¡ //æ¥è¯¢çç¹æ¹æ¡å建æ¥æ DataSet dd = oCn.RunProcReturn("select * from Gy_StockCheckItem where HName=" + sName, "Gy_StockCheckItem"); DataSet dd = oCn.RunProcReturn("select * from Gy_StockCheckItem where HName='" + sName + "'", "Gy_StockCheckItem"); string HDate = dd.Tables[0].Rows[0]["HMakeTime"].ToString(); //转åæ ¼å¼ @@ -861,9 +904,9 @@ ",HKeeperID,HDeptID,HInnerBillNo,HRedBlueFlag" + ") " + " values('3803','3803'," + HInterID + ",'" + HBillNo + "','" + HDate + "'" + ", '" + user + "','" +HDate + "','" + sName + "'" + ", '" + user + "','"+ HDate + "','" + sName + "'" + ", " + dr["HNowSupID"].ToString() + "," + dr["HNowSupTypeID"].ToString() + "," + dr["HNowSupID"].ToString() + ",0,0,0,0" + ", 0," + dr["HDeptID"].ToString() + ",' ',0" + ", 0," + dr["HDeptID"].ToString() + ",getdate(),0" + ") "; string sql1 = string.Format(@"Insert Into Sc_MouldStockBillSub (HInterID,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark,HSourceInterID, HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney,HMaterID,HPropertyID,HSecUnitRate,HSecUnitID,HUnitID, @@ -871,7 +914,7 @@ HStockOrgID,HOWNERID,HOtherOrgID,HOWNERTYPEID) values(" + HInterID + ",1,'',getdate(),0,'" + sName.ToString() + "',0,0,'',''," + "0,0," + dr["HInterID"].ToString() + ",0," + dr["HSecUnitRate"].ToString() + ",0," + dr["HUnitID"].ToString() + ",0," + dr["HProdQty"].ToString() + "," + dr1["HQty"].ToString() + ",0," + "0," + dr["HDesignLife"].ToString() + "," + dr["HLeaveLife"].ToString() + "," + dr["HUseLife"].ToString() + "," + dr1["HCorrespondentID"].ToString() + "," + dr["HNowSupID"].ToString() + ",0,0" + ",0,0,0," + userID + ",0,100005,'')"); + ",0,0,0," + HOrgID + ",0,100005,'')"); //主表 oCn.BeginTran();
