盘点分析维护
器具档案单据 列表维护
器具保养计划单 单据双子列表
器具保养计划单列表加子列表显示
| | |
| | | { |
| | | public Model.ClsSc_MouldMaintainPlanBillMain omodel = new Model.ClsSc_MouldMaintainPlanBillMain(); |
| | | public List<Model.ClsSc_MouldMaintainPlanBillSub> DetailColl = new List<Model.ClsSc_MouldMaintainPlanBillSub>(); |
| | | public List<Model.ClsSc_MouldMaintainPlanBillSub_Item> DetailCol = new List<Model.ClsSc_MouldMaintainPlanBillSub_Item>(); |
| | | |
| | | public ClsSc_MouldMaintainPlanBill() |
| | | { |
| | |
| | | //",HGroupID=" + omodel.HGroupID.ToString() + |
| | | //",HWHID=" + omodel.HWHID.ToString() + |
| | | //",HSCWHID=" + omodel.HSCWHID.ToString() + |
| | | |
| | | ",HEquipDotCheckRuleInterID='" + omodel.HEquipDotCheckRuleInterID + "'" + |
| | | ",HCycleUnit='" + omodel.HCycleUnit + "'" + |
| | | ",HCheckCycle=" + omodel.HCheckCycle.ToString() + |
| | | ",HBeginDate='" + omodel.HBeginDate + "'" + |
| | |
| | | DeleteRelation(ref sReturn, lngBillKey); |
| | | //å é¤å表 |
| | | DeleteBillSub(lngBillKey); |
| | | //æå
¥å表 |
| | | oCn.RunProc("delete from Sc_MouldMaintainPlanBillSub_Item where HInterID=" + lngBillKey); |
| | | |
| | | omodel.HInterID = lngBillKey; |
| | | //æå
¥å表é
ä»¶ä¿¡æ¯ |
| | | foreach (Model.ClsSc_MouldMaintainPlanBillSub oSub in DetailColl) |
| | | { |
| | | oCn.RunProc("Insert into Sc_MouldMaintainPlanBillSub " + |
| | |
| | | ",'" + oSub.HCloseMan + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" + |
| | | "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() + |
| | | ") "); |
| | | } |
| | | |
| | | //æå
¥ä¿å
»é¡¹å表 |
| | | foreach (Model.ClsSc_MouldMaintainPlanBillSub_Item Item in DetailCol) |
| | | { |
| | | oCn.RunProc("Insert into Sc_MouldMaintainPlanBillSub_Item" + |
| | | " (HInterID,HEntryID,HMaintainItemID" + |
| | | ",HMaintainPart,HClaim" + |
| | | ",HManagerID" + |
| | | ",HCloseMan,HCloseType,HRemark" + |
| | | ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney,HMaintainItem" + |
| | | ") values(" |
| | | + omodel.HInterID.ToString() + "," + Item.HEntryID.ToString() + "," + Item.HMaintainItemID.ToString() + |
| | | ",'" + Item.HMaintainPart.ToString() + "','" + Item.HClaim.ToString() + "'" + |
| | | "," + Item.HManagerID.ToString() + |
| | | ",'" + Item.HCloseMan + "'," + Convert.ToString(Item.HCloseType ? 1 : 0) + ",'" + Item.HRemark + "'" + |
| | | "," + Item.HSourceInterID.ToString() + "," + Item.HSourceEntryID.ToString() + ",'" + Item.HSourceBillNo + "','" + Item.HSourceBillType + "'," + Item.HRelationQty.ToString() + "," + Item.HRelationMoney.ToString() + "," + Item.HMaintainItem.ToString() + |
| | | ") "); |
| | | } |
| | | // |
| | | //foreach (Model.ClsSc_MouldMaintainPlanBillSub oSub in DetailColl) |
| | |
| | | "(HBillType,HBillSubType,HInterID,HBillNo,HDate,HMaker,HMakeDate" + |
| | | ",HYear,HPeriod,HRemark" + |
| | | ",HCycleUnit,HCheckCycle,HBeginDate,HEndDate"+ |
| | | ",HInnerBillNo,HExplanation" + |
| | | ",HInnerBillNo,HExplanation,HEquipDotCheckRuleInterID" + |
| | | ") " + |
| | | " values('" + this.BillType + "','" + this.HBillSubType + "'," +omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate + "','" + DBUtility.ClsPub.CurUserName + "',getdate()" + |
| | | "," + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "'"+ |
| | | ",'" + omodel.HCycleUnit + "'," + omodel.HCheckCycle.ToString() + ",'" + omodel.HBeginDate + "','" + omodel.HEndDate + "'" + |
| | | ",'" + omodel.HInnerBillNo + "','" + omodel.HExplanation + "'" + |
| | | ",'" + omodel.HInnerBillNo + "','" + omodel.HExplanation + "'" + "','" + omodel.HEquipDotCheckRuleInterID + "'" + |
| | | ") "); |
| | | //æå
¥å表 |
| | | //æå
¥å表é
ä»¶ä¿¡æ¯ |
| | | foreach (Model.ClsSc_MouldMaintainPlanBillSub oSub in DetailColl) |
| | | { |
| | | oCn.RunProc("Insert into Sc_MouldMaintainPlanBillSub " + |
| | |
| | | "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() + |
| | | ") "); |
| | | } |
| | | |
| | | //æå
¥ä¿å
»é¡¹å表 |
| | | foreach (Model.ClsSc_MouldMaintainPlanBillSub_Item Item in DetailCol) |
| | | { |
| | | oCn.RunProc("Insert into Sc_MouldMaintainPlanBillSub_Item" + |
| | | " (HInterID,HEntryID,HMaintainItemID" + |
| | | ",HMaintainPart,HClaim" + |
| | | ",HManagerID" + |
| | | ",HCloseMan,HCloseType,HRemark" + |
| | | ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney,HMaintainItem" + |
| | | ") values(" |
| | | + omodel.HInterID.ToString() + "," + Item.HEntryID.ToString() + "," + Item.HMaintainItemID.ToString() + |
| | | ",'" + Item.HMaintainPart.ToString() + "','" + Item.HClaim.ToString() + "'" + |
| | | "," + Item.HManagerID.ToString() + |
| | | ",'" + Item.HCloseMan + "'," + Convert.ToString(Item.HCloseType ? 1 : 0) + ",'" + Item.HRemark + "'" + |
| | | "," + Item.HSourceInterID.ToString() + "," + Item.HSourceEntryID.ToString() + ",'" + Item.HSourceBillNo + "','" + Item.HSourceBillType + "'," + Item.HRelationQty.ToString() + "," + Item.HRelationMoney.ToString() +"," + Item.HMaintainItem.ToString() + |
| | | ") "); |
| | | } |
| | | // |
| | | //foreach (Model.ClsSc_MouldMaintainPlanBillSub oSub in DetailColl) |
| | | //{ |
| | |
| | | <Compile Include="ç产管ç\模å
·ç®¡ç\ClsSc_MouldMaintainBillMain.cs" /> |
| | | <Compile Include="ç产管ç\模å
·ç®¡ç\ClsSc_MouldMaintainBillSub.cs" /> |
| | | <Compile Include="ç产管ç\模å
·ç®¡ç\ClsSc_MouldMaintainPlanBillMain.cs" /> |
| | | <Compile Include="ç产管ç\模å
·ç®¡ç\ClsSc_MouldMaintainPlanBillSub_Item.cs" /> |
| | | <Compile Include="ç产管ç\模å
·ç®¡ç\ClsSc_MouldMaintainPlanBillSub.cs" /> |
| | | <Compile Include="ç产管ç\模å
·ç®¡ç\ClsSc_MouldMaintainRuleBillMain.cs" /> |
| | | <Compile Include="ç产管ç\模å
·ç®¡ç\ClsSc_MouldMaintainRuleBillSub.cs" /> |
| | |
| | | public string HEndDate;// datetime --计åç»ææ¥æ |
| | | public string HExplanation;// varchar(500) --ÕªÒª |
| | | public string HInnerBillNo;// varchar(50) --å
é¨åæ®å· |
| | | public int HEquipDotCheckRuleInterID; //å¨å
·ä¿å
»è§ç¨id |
| | | } |
| | | } |
New file |
| | |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Text; |
| | | |
| | | namespace Model |
| | | { |
| | | public class ClsSc_MouldMaintainPlanBillSub_Item : DBUtility.ClsXt_BaseBillSub |
| | | { |
| | | //============ |
| | | |
| | | public Int64 HMaintainItemID;// int --ä¿å
»é¡¹ç®ID |
| | | public string HMaintainItem;// varchar(100) --ä¿å
»é¡¹ç® |
| | | public string HMaintainPart;// varchar(100) --ä¿å
»é¨ä½ |
| | | public string HClaim;// varchar(100) --å
·ä½è¦æ± |
| | | public Int64 HManagerID;// int --è´è´£äººid(èå表) |
| | | } |
| | | } |
| | |
| | | ds = oCN.RunProcReturn(sql, "h_v_Gy_MouldFileList"); |
| | | } |
| | | |
| | | //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 e) |
| | | { |
| | |
| | | Double HProdQty = mainList[0].HProdQty; |
| | | Double HProdWeight = mainList[0].HProdWeight; |
| | | string HRemark = mainList[0].HRemark; |
| | | string HMaker = mainList[0].HMaker; |
| | | string HUpDater = mainList[0].HUpDater; |
| | | string HMaterNumber = mainList[0].HMaterNumber; |
| | | string HSupNumber = mainList[0].HSupNumber; |
| | | long HPrintQty = mainList[0].HPrintQty; |
| | |
| | | ",HYear='" + HYear.ToString() + "'" + |
| | | ",HPeriod='" + HPeriod.ToString() + "'" + |
| | | ",HRemark='" + HRemark + "'" + |
| | | ",HUpDater='" + HMaker + "'" + |
| | | ",HUpDater='" + HUpDater + "'" + |
| | | ",HUpDateDate=getdate()" + |
| | | //======================================== |
| | | ",HMouldNo='" + HMouldNo + "'" + |
| | |
| | | ",HNowSupID=" + HNowSupID.ToString() + |
| | | ",HNowSupTypeID=" + HNowSupTypeID.ToString() + |
| | | ",HProdWeight=" + HProdWeight.ToString() + |
| | | ",HBarCode=" + HBarCode.ToString() + |
| | | ",HBarCode='" + HBarCode.ToString() + "'" + |
| | | " where HInterID=" + HInterID.ToString()); |
| | | |
| | | //ä¿®æ¹å项ç®ä»£ç |
| | |
| | | } |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | //è·åä¿å
»é¡¹ç®ç¼è¾æ°æ® |
| | | string sql = "select ä¿å
»é¡¹ç®ID,ä¿å
»é¡¹ç®,ä¿å
»é¨ä½,å
·ä½è¦æ±,è´è´£äººID,è´è´£äººä»£ç ,è´è´£äººåç§°,å夿³¨2 from h_v_Sc_MouldMaintainRuleBillList where 1 = 1 " + Swhere + ""; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldMaintainRuleBillList"); |
| | | string sql = "select ä¿å
»é¡¹ç®ID,ä¿å
»é¡¹ç®ä»£ç ,ä¿å
»é¡¹ç®,ä¿å
»é¨ä½,å
·ä½è¦æ±,è´è´£äººID,è´è´£äººä»£ç ,è´è´£äººåç§°,å夿³¨2 from h_v_Sc_MouldMaintainRuleBillSub_Item where 1 = 1 " + Swhere + ""; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldMaintainRuleBillSub_Item"); |
| | | //è·åé
件项ç®ç¼è¾æ°æ® |
| | | string sql1 = "select é
ä»¶ID,é
件代ç ,é
ä»¶åç§°,åä½ID,计éåä½ä»£ç ,计éåä½åç§°,ç¨é,æ åç¨é,å夿³¨1 from h_v_Sc_MouldMaintainRuleBillList where 1 = 1 " + Swhere + ""; |
| | | ds1 = oCN.RunProcReturn(sql1, "h_v_Sc_MouldMaintainRuleBillList"); |
| | | string sql1 = "select é
ä»¶ID,é
件代ç ,é
ä»¶åç§°,åä½ID,计éåä½ä»£ç ,计éåä½åç§°,ç¨é,æ åç¨é,å夿³¨1 from h_v_Sc_MouldMaintainRuleBillSub where 1 = 1 " + Swhere + ""; |
| | | ds1 = oCN.RunProcReturn(sql1, "h_v_Sc_MouldMaintainRuleBillSub"); |
| | | |
| | | list.Add(ds.Tables[0]); |
| | | list.Add(ds1.Tables[0]); |
| | |
| | | } |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | //è·åä¿å
»é¡¹ç®ç¼è¾æ°æ® |
| | | string sql = "select ä¿å
»é¡¹ç®ID HMaintainItemID,ä¿å
»é¡¹ç®ä»£ç HMaintainItemNumber,ä¿å
»é¡¹ç® HMaintainItem,ä¿å
»é¨ä½ HMaintainPart,å
·ä½è¦æ± HClaim,è´è´£äººID HManagerID,è´è´£äººä»£ç HManagerNumber,è´è´£äººåç§° HManagerName,å夿³¨2 HRemark from h_v_Sc_MouldMaintainRuleBillList where 1 = 1 " + Swhere + ""; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldMaintainRuleBillList"); |
| | | string sql = "select ä¿å
»é¡¹ç®ID HMaintainItemID,ä¿å
»é¡¹ç®ä»£ç HMaintainItemNumber,ä¿å
»é¡¹ç® HMaintainItem,ä¿å
»é¨ä½ HMaintainPart,å
·ä½è¦æ± HClaim,è´è´£äººID HManagerID,è´è´£äººä»£ç HManagerNumber,è´è´£äººåç§° HManagerName,å夿³¨2 HRemark from h_v_Sc_MouldMaintainRuleBillSub_Item where 1 = 1 " + Swhere + ""; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldMaintainRuleBillSub_Item"); |
| | | //è·åé
件项ç®ç¼è¾æ°æ® |
| | | string sql1 = "select é
ä»¶ID HMaterID,é
件代ç HMaterNumber,é
ä»¶åç§° HMaterName,åä½ID HUnitID,计éåä½ä»£ç HUnitNumber,计éåä½åç§° HUnitName,ç¨é HQty,å夿³¨1 HRemark from h_v_Sc_MouldMaintainRuleBillList where 1 = 1 " + Swhere + ""; |
| | | ds1 = oCN.RunProcReturn(sql1, "h_v_Sc_MouldMaintainRuleBillList"); |
| | | string sql1 = "select é
ä»¶ID HMaterID,é
件代ç HMaterNumber,é
ä»¶åç§° HMaterName,åä½ID HUnitID,计éåä½ä»£ç HUnitNumber,计éåä½åç§° HUnitName,ç¨é HQty,å夿³¨1 HRemark from h_v_Sc_MouldMaintainRuleBillSub where 1 = 1 " + Swhere + ""; |
| | | ds1 = oCN.RunProcReturn(sql1, "h_v_Sc_MouldMaintainRuleBillSub"); |
| | | |
| | | list.Add(ds.Tables[0]); |
| | | list.Add(ds1.Tables[0]); |
| | |
| | | string msg2 = sArray[0].ToString(); |
| | | string msg3 = sArray[1].ToString(); |
| | | string msg4 = sArray[2].ToString(); |
| | | string msg5 = sArray[3].ToString(); |
| | | |
| | | |
| | | string UserName = ""; |
| | |
| | | } |
| | | oBill.omodel = oItem; |
| | | } |
| | | |
| | | //ä¿å
»é¡¹è¡¨ä½æ°æ® |
| | | //æ },{æ¥æåæ°ç» //廿ãåã |
| | | msg5 = msg5.Substring(1, msg5.Length - 2); |
| | | msg5 = msg5.Replace("\\", ""); |
| | | msg5 = msg5.Replace("\n", ""); //\n |
| | | //msg2 = msg2.Replace("'", "â"); |
| | | List<Model.ClsSc_MouldMaintainPlanBillSub_Item> ls1 = new List<Model.ClsSc_MouldMaintainPlanBillSub_Item>(); |
| | | ls1 = oListModels.getObjectByJson_Gy_MouldMaintainPlanBillSub_Item(msg5); |
| | | int j = 0; |
| | | foreach (Model.ClsSc_MouldMaintainPlanBillSub_Item item in ls1) |
| | | { |
| | | |
| | | j++; |
| | | item.HEntryID = j; |
| | | //oItemSub.HCloseMan = ""; //è¡å
³é |
| | | item.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now); |
| | | item.HCloseType = false; //å
³éç±»å |
| | | //oItemSub.HRemark = ""; //夿³¨ |
| | | item.HSourceInterID = 0; // æºå主å
ç |
| | | item.HSourceEntryID = 0; //æºååå
ç |
| | | //oItemSub.HSourceBillNo = ""; //æºååå· |
| | | //oItemSub.HSourceBillType = ""; //æºåç±»å |
| | | item.HRelationQty = 0; //å
³èæ°é |
| | | oBill.DetailCol.Add(item); |
| | | |
| | | } |
| | | |
| | | //è¡¨ä½æ°æ® |
| | | //æ },{æ¥æåæ°ç» //廿ãåã |
| | | msg3 = msg3.Substring(1, msg3.Length - 2); |
| | |
| | | [HttpGet] |
| | | public object Sc_MouldMaintainPlanBillListProjectDetai(string sqlWhere) |
| | | { |
| | | DataSet ds; |
| | | DataSet ds, ds1; |
| | | List<object> list = new List<object>(); |
| | | |
| | | try |
| | | { |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | if (sqlWhere == null || sqlWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select a.HMaterID,m.HNumber HMaterNumber,m.HName HMaterName,a.HUnitID,u.HNumber HUnitNumber,u.HName HUnitName,a.HQty,a.HQtyMust,a.HRemark from Sc_MouldMaintainPlanBillSub a left join Gy_Unit u on a.HUnitID=u.HItemID left join h_v_IF_Material m on a.HMaterID=m.HItemID", "Sc_MouldMaintainPlanBillSub"); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "è·åä¿¡æ¯æåï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select a.HMaterID,m.HNumber HMaterNumber,m.HName HMaterName,a.HUnitID,u.HNumber HUnitNumber,u.HName HUnitName,a.HQty,a.HQtyMust,a.HRemark from Sc_MouldMaintainPlanBillSub a left join Gy_Unit u on a.HUnitID=u.HItemID left join h_v_IF_Material m on a.HMaterID=m.HItemID where 1 = 1 "; |
| | | string sql = sql1 + sqlWhere; |
| | | ds = oCN.RunProcReturn(sql, "Sc_MouldMaintainPlanBillSub"); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "è·åä¿¡æ¯æåï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | } |
| | | //è·åä¿å
»é¡¹ç®ç¼è¾æ°æ® |
| | | string sql = "select ä¿å
»é¡¹ç®ID HMaintainItemID, ä¿å
»é¡¹ç®ä»£ç HMaintainItemNumber,ä¿å
»é¡¹ç® HMaintainItem,ä¿å
»é¨ä½ HMaintainPart,å
·ä½è¦æ± HClaim,è´è´£äººID,è´è´£äººä»£ç HManagerNumber,è´è´£äººåç§° HManagerName,å夿³¨2 HRemark from h_v_Sc_MouldMaintainPlanBillSub_Item where 1 = 1 " + sqlWhere + ""; |
| | | |
| | | ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldMaintainPlanBillSub_Item"); |
| | | //è·åé
件项ç®ç¼è¾æ°æ® |
| | | string sql1 = "select é
ä»¶ID HMaterID, é
件代ç HMaterNumber,é
ä»¶åç§° HMaterName,åä½ID HUnitID,计éåä½ä»£ç HUnitNumber,计éåä½åç§° HUnitName,ç¨é HQty,æ åç¨é HQtyMust,å夿³¨1 HRemark from h_v_Sc_MouldMaintainPlanBillSub where 1 = 1 " + sqlWhere + ""; |
| | | ds1 = oCN.RunProcReturn(sql1, "h_v_Sc_MouldMaintainPlanBillSub"); |
| | | |
| | | list.Add(ds.Tables[0]); |
| | | list.Add(ds1.Tables[0]); |
| | | |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "è·åä¿¡æ¯æåï¼"; |
| | | objJsonResult.data = null; |
| | | objJsonResult.list = list; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | |
| | | //夿æ¯å¦éæ©çç¹æ¹æ¡ï¼æ¯=>ï¼ç¨çç¹æ¹æ¡å表å对æ¯ï¼ï¼å¦=>ï¼ç¨å¨å
·æ¡£æ¡å对æ¯ï¼ |
| | | 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 |
| | | { |
| | |
| | | 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"); |
| | |
| | | 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(); |
| | |
| | | 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"); |
| | |
| | | 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, |
| | |
| | | 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(); |
| | |
| | | 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"); |
| | |
| | | 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 |
| | | { |
| | |
| | | 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,'')"); |
| | | } |
| | | |
| | | //主表 |
| | |
| | | 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"); |
| | |
| | | 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(); |
| | |
| | | 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"); |
| | |
| | | ",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, |
| | |
| | | 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(); |
| | |
| | | } |
| | | |
| | | /// <summary> |
| | | /// å¤çæ°å¢æ¨¡å
·ä¿å
»è®¡ååå表ä¿å
»ä¿¡æ¯çjson |
| | | /// </summary> |
| | | /// <param name="jsonString"></param> |
| | | /// <returns></returns> |
| | | public List<Model.ClsSc_MouldMaintainPlanBillSub_Item> getObjectByJson_Gy_MouldMaintainPlanBillSub_Item(string jsonString) |
| | | { |
| | | jsonString = "[" + jsonString.ToString() + "]"; |
| | | List<Model.ClsSc_MouldMaintainPlanBillSub_Item> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsSc_MouldMaintainPlanBillSub_Item>>(jsonString); |
| | | return list; |
| | | } |
| | | |
| | | /// <summary> |
| | | /// å¤çæ°å¢ä¸è¯åå 表çjson |
| | | /// </summary> |
| | | /// <param name="jsonString"></param> |