网页版 和 PDA版 设备点检表和器具点检表 增加 字段,新增器具点检PDA模块
| | |
| | | ",HExplanation='" + omodel.HExplanation + "'" + |
| | | ",HInnerBillNo='" + omodel.HInnerBillNo + "'" + |
| | | |
| | | |
| | | ",HLastResult='" + omodel.HLastResult + "'" + |
| | | ",HErrNote='" + omodel.HErrNote + "'" + |
| | | ",HBigSafeNote='" + omodel.HBigSafeNote + "'" + |
| | | ",HShiftsID=" + omodel.HShiftsID + |
| | | ",HDotCheckNote='" + omodel.HDotCheckNote + "'" + |
| | | " where HInterID=" + lngBillKey.ToString()); |
| | | //å é¤å
³è |
| | | DeleteRelation(ref sReturn, lngBillKey); |
| | |
| | | foreach (Model.ClsSc_MouldDotCheckBillSub oSub in DetailColl) |
| | | { |
| | | oCn.RunProc("Insert into Sc_MouldDotCheckBillSub " + |
| | | " (HInterID,HEntryID" + |
| | | ",HManagerID" + |
| | | ",HDotCheckItemID,HDotCheckItem,HDotCheckPart,HClaim" + |
| | | ",HCloseMan,HCloseType,HRemark" + |
| | | ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" + |
| | | ") values(" |
| | | + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + |
| | | "," + oSub.HManagerID.ToString() + "," + oSub.HDotCheckItemID.ToString() + |
| | | ",'" + oSub.HDotCheckItem + "','" + oSub.HDotCheckPart + "','" + oSub.HClaim + "'" + |
| | | ",'" + 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() + |
| | | ") "); |
| | | " (HInterID,HEntryID" + |
| | | ",HManagerID" + |
| | | ",HDotCheckItemID,HDotCheckItem,HDotCheckPart,HClaim" + |
| | | ",HCloseMan,HCloseType,HRemark" + |
| | | ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" + |
| | | ",HDotCheckItemClassID,HDotCheckItemMethodID,HDotCheckResult" + |
| | | ") values(" |
| | | + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + |
| | | "," + oSub.HManagerID.ToString() + "," + oSub.HDotCheckItemID.ToString() + |
| | | ",'" + oSub.HDotCheckItem + "','" + oSub.HDotCheckPart + "','" + oSub.HClaim + "'" + |
| | | ",'" + 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() + "," + oSub.HDotCheckItemClassID + "," + oSub.HDotCheckItemMethodID + ",'" + oSub.HDotCheckResult + "'" + |
| | | ") "); |
| | | } |
| | | |
| | | ////é
ä»¶é¡¹ç® |
| | |
| | | ",HMouldID,HBeginDate"+ |
| | | ",HEndDate,HPlanNo,HPlanInterID" + |
| | | ",HInnerBillNo,HExplanation,HMouldDotCheckRuleID" + |
| | | ",HLastResult,HErrNote,HBigSafeNote,HShiftsID,HDotCheckNote" + |
| | | ") " + |
| | | " values('" + this.BillType + "','" + this.HBillSubType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate + "','" + omodel.HMaker + "',getdate()" + |
| | | "," + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "'" + |
| | | "," + omodel.HMouldID.ToString() + ",'" + omodel.HBeginDate + "'" + |
| | | ",'" + omodel.HEndDate + "','" + omodel.HPlanNo + "'," + omodel.HPlanInterID.ToString() + |
| | | ",'" + omodel.HInnerBillNo + "','" + omodel.HExplanation + "'," + omodel.HMouldDotCheckRuleID + |
| | | ",'" + omodel.HInnerBillNo + "','" + omodel.HExplanation + "'," + omodel.HMouldDotCheckRuleID + ",'" + omodel.HLastResult + "','" + omodel.HErrNote + "','" + omodel.HBigSafeNote + "'," + omodel.HShiftsID + ",'" + omodel.HDotCheckNote + "'" + |
| | | ") "); |
| | | //æå
¥å表 |
| | | foreach (Model.ClsSc_MouldDotCheckBillSub oSub in DetailColl) |
| | |
| | | ",HDotCheckItemID,HDotCheckItem,HDotCheckPart,HClaim" + |
| | | ",HCloseMan,HCloseType,HRemark" + |
| | | ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" + |
| | | ",HDotCheckItemClassID,HDotCheckItemMethodID,HDotCheckResult" + |
| | | ") values(" |
| | | + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + |
| | | "," + oSub.HManagerID.ToString() +","+ oSub.HDotCheckItemID.ToString()+ |
| | | ",'" + oSub.HDotCheckItem + "','" + oSub.HDotCheckPart + "','" + oSub.HClaim + "'" + |
| | | ",'" + 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() + |
| | | "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() + "," + oSub.HDotCheckItemClassID + "," + oSub.HDotCheckItemMethodID + ",'" + oSub.HDotCheckResult + "'" + |
| | | ") "); |
| | | } |
| | | |
| | |
| | | ",HExplanation='" + omodel.HExplanation+"'" + |
| | | ",HInnerBillNo='" + omodel.HInnerBillNo+"'" + |
| | | ",HEquipDotCheckRuleInterID="+omodel.HEquipDotCheckRuleInterID+ |
| | | ",HLastResult='" + omodel.HLastResult + "'" + |
| | | ",HErrNote='" + omodel.HErrNote + "'" + |
| | | ",HBigSafeNote='" + omodel.HBigSafeNote + "'" + |
| | | ",HShiftsID=" + omodel.HShiftsID + |
| | | ",HDotCheckNote='" + omodel.HDotCheckNote + "'" + |
| | | " where HInterID=" + lngBillKey.ToString()); |
| | | //å é¤å
³è |
| | | DeleteRelation(ref sReturn, lngBillKey); |
| | |
| | | foreach (Model.ClsSb_EquipDotCheckBillSub oSub in DetailColl) |
| | | { |
| | | oCn.RunProc("Insert into Sb_EquipDotCheckBillSub " + |
| | | " (HInterID,HEntryID," + |
| | | "HCloseMan,HEntryCloseDate,HCloseType,HRemark," + |
| | | "HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney," + |
| | | "HDotCheckItemID,HDotCheckItem,HDotCheckPart,HClaim," + |
| | | "HManagerID,HManagerNumber" + |
| | | ") values(" |
| | | + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + |
| | | ",'" + oSub.HCloseMan + "','" + oSub.HEntryCloseDate + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" + |
| | | "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() + |
| | | ",'" + oSub.HDotCheckItemID + "','" + oSub.HDotCheckItem + "','" + oSub.HDotCheckPart + "','" + oSub.HClaim + |
| | | "'," + oSub.HManagerID.ToString() + ",'" + oSub.HManagerNumber + "'" + |
| | | ") "); |
| | | " (HInterID,HEntryID," + |
| | | "HCloseMan,HEntryCloseDate,HCloseType,HRemark," + |
| | | "HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney," + |
| | | "HDotCheckItemID,HDotCheckItem,HDotCheckPart,HClaim," + |
| | | "HManagerID,HManagerNumber,HDotCheckItemClassID,HDotCheckItemMethodID,HDotCheckResult" + |
| | | ") values(" |
| | | + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + |
| | | ",'" + oSub.HCloseMan + "','" + oSub.HEntryCloseDate + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" + |
| | | "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() + |
| | | ",'" + oSub.HDotCheckItemID + "','" + oSub.HDotCheckItem + "','" + oSub.HDotCheckPart + "','" + oSub.HClaim + |
| | | "'," + oSub.HManagerID.ToString() + ",'" + oSub.HManagerNumber + "'," + oSub.HDotCheckItemClassID + "," + oSub.HDotCheckItemMethodID + ",'" + oSub.HDotCheckResult + "'" + |
| | | ") "); |
| | | } |
| | | // |
| | | //foreach (Model.ClsSb_EquipDotCheckBillSub oSub in DetailColl) |
| | |
| | | "(HBillType,HBillSubType,HInterID,HBillNo,HDate,HMaker,HMakeDate" + |
| | | ",HYear,HPeriod,HRemark,HEquipID" + |
| | | ",HBeginDate,HEndDate,HPlanNo,HExplanation,HInnerBillNo,HEquipDotCheckRuleInterID" + |
| | | ",HLastResult,HErrNote,HBigSafeNote,HShiftsID,HDotCheckNote" + |
| | | ") "+ |
| | | " values('" + this.BillType + "','" + this.HBillSubType + "'," +omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate + "','" + omodel.HMaker + "',getdate()" + |
| | | "," + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "'," + omodel.HEquipID.ToString() + |
| | | ",'" + omodel.HBeginDate + "','" + omodel.HEndDate + "','" + omodel.HPlanNo + "','" + omodel.HExplanation + "','" + omodel.HInnerBillNo + "'," +omodel.HEquipDotCheckRuleInterID.ToString()+ |
| | | ",'" + omodel.HBeginDate + "','" + omodel.HEndDate + "','" + omodel.HPlanNo + "','" + omodel.HExplanation + "','" + omodel.HInnerBillNo + "'," +omodel.HEquipDotCheckRuleInterID.ToString() + ",'" + omodel.HLastResult + "','" + omodel.HErrNote + "','" + omodel.HBigSafeNote + "'," + omodel.HShiftsID + ",'" + omodel.HDotCheckNote + "'" + |
| | | ") "); |
| | | //æå
¥å表 |
| | | foreach (Model.ClsSb_EquipDotCheckBillSub oSub in DetailColl) |
| | |
| | | "HCloseMan,HEntryCloseDate,HCloseType,HRemark," + |
| | | "HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney," + |
| | | "HDotCheckItemID,HDotCheckItem,HDotCheckPart,HClaim," + |
| | | "HManagerID,HManagerNumber" + |
| | | "HManagerID,HManagerNumber,HDotCheckItemClassID,HDotCheckItemMethodID,HDotCheckResult" + |
| | | ") values(" |
| | | + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + |
| | | ",'" + oSub.HCloseMan + "','" + oSub.HEntryCloseDate + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" + |
| | | "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() + |
| | | ",'" + oSub.HDotCheckItemID+"','"+oSub.HDotCheckItem + "','" + oSub.HDotCheckPart + "','" + oSub.HClaim + |
| | | "'," + oSub.HManagerID.ToString() + ",'" + oSub.HManagerNumber + "'" + |
| | | "'," + oSub.HManagerID.ToString() + ",'" + oSub.HManagerNumber + "'," + oSub.HDotCheckItemClassID + "," + oSub.HDotCheckItemMethodID + ",'" + oSub.HDotCheckResult + "'" + |
| | | ") "); |
| | | } |
| | | //ç¹æ£å®æï¼åå设å¤ç¹æ£è®¡ååå表æ¯å¦ç¹æ£æ è®° |
| | |
| | | public string HExplanation;// varchar(500) --ÕªÒª |
| | | public string HInnerBillNo;// varchar(50) --å
é¨åæ®å· |
| | | public string HMouldDotCheckRuleID;// å¨å
·ç¹æ£è§ç¨ID |
| | | |
| | | public string HLastResult;// æç»ç»è®ºï¼OKï¼NGï¼ |
| | | public string HErrNote;// å¼å¸¸æ
åµè®°å½ |
| | | public string HBigSafeNote;// é大å®å
¨éæ£è®°å½ |
| | | public Int64 HShiftsID;// çäº§çæ¬¡ï¼Gy_Shiftsï¼ |
| | | public string HDotCheckNote;// ç¹æ£æ°æ® |
| | | } |
| | | } |
| | |
| | | public string HClaim;// varchar(100) --å
·ä½è¦æ± |
| | | public long HManagerID;// int --è´è´£äººid(h_v_IF_Employee) |
| | | |
| | | public Int64 HDotCheckItemClassID;// ç¹æ£é¡¹ç®åç±»(gy_DotCheckItemClass) |
| | | public Int64 HDotCheckItemMethodID;// ç¹æ£æ¹æ³(gy_DotCheckItemMethod) |
| | | public string HDotCheckResult;// ç¹æ£ç»æï¼?ï¼Xï¼ |
| | | } |
| | | } |
| | |
| | | public int HEquipDotCheckPlanInterID; //设å¤ç¹æ£è®¡ååï¼Sb_EquipDotCheckPlanBillSub_Planï¼ä¸»å
ç |
| | | public int HEquipDotCheckPlanEntryID; //设å¤ç¹æ£è®¡ååï¼Sb_EquipDotCheckPlanBillSub_Planï¼åå
ç |
| | | |
| | | public string HLastResult;// æç»ç»è®ºï¼OKï¼NGï¼ |
| | | public string HErrNote;// å¼å¸¸æ
åµè®°å½ |
| | | public string HBigSafeNote;// é大å®å
¨éæ£è®°å½ |
| | | public Int64 HShiftsID;// çäº§çæ¬¡ï¼Gy_Shiftsï¼ |
| | | public string HDotCheckNote;// ç¹æ£æ°æ® |
| | | |
| | | } |
| | | } |
| | |
| | | public string HUnitName; |
| | | public Int64 HManagerID; |
| | | public string HManagerNumber; |
| | | public string HManagerName; |
| | | public string HManagerName; |
| | | |
| | | public Int64 HDotCheckItemClassID;// ç¹æ£é¡¹ç®åç±»(gy_DotCheckItemClass) |
| | | public Int64 HDotCheckItemMethodID;// ç¹æ£æ¹æ³(gy_DotCheckItemMethod) |
| | | public string HDotCheckResult;// ç¹æ£ç»æï¼?ï¼Xï¼ |
| | | } |
| | | } |
| | |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | if (sqlWhere == null || sqlWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select ç¹æ£é¡¹ç®ID HDotCheckItemID,ç¹æ£é¡¹ç®ä»£ç as HDotCheckCode ,ç¹æ£é¡¹ç® HDotCheckItem,ç¹æ£é¨ä½ HDotCheckPart ,å
·ä½è¦æ± HClaim,表ä½å¤æ³¨ HRemark,è´è´£äººID HManagerID,è´è´£äººç¼ç HManagerCode,è´è´£äºº HManagerName from h_v_Sb_EquipDotCheckBillList", "h_v_Sb_EquipDotCheckBillList"); |
| | | ds = oCN.RunProcReturn("select * from h_v_Sb_EquipDotCheckBill_Edit", "h_v_Sb_EquipDotCheckBill_Edit"); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "è·åä¿¡æ¯æåï¼"; |
| | |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select ç¹æ£é¡¹ç®ID HDotCheckItemID,ç¹æ£é¡¹ç®ä»£ç as HDotCheckCode ,ç¹æ£é¡¹ç® HDotCheckItem,ç¹æ£é¨ä½ HDotCheckPart,å
·ä½è¦æ± HClaim,表ä½å¤æ³¨ HRemark,è´è´£äººID HManagerID,è´è´£äººç¼ç HManagerCode,è´è´£äºº HManagerName from h_v_Sb_EquipDotCheckBillList where 1 = 1 "; |
| | | string sql1 = "select * from h_v_Sb_EquipDotCheckBill_Edit where 1 = 1 "; |
| | | string sql = sql1 + sqlWhere; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Sb_EquipDotCheckBillList"); |
| | | ds = oCN.RunProcReturn(sql, "h_v_Sb_EquipDotCheckBill_Edit"); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "è·åä¿¡æ¯æåï¼"; |
| | |
| | | { |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | //è·åç¹æ£é¡¹ç®ç¼è¾æ°æ® |
| | | ds = oCN.RunProcReturn("select HDotCheckItem, HDotCheckPart , HClaim, a.HRemark,a.HManagerID,e.HNumber HManagerCode,e.HName HManagerName from Sc_MouldDotCheckBillSub a left join Gy_Employee e on a.HManagerID=e.HItemID where 1=1 " + sqlWhere, "Sc_MouldDotCheckBillSub"); |
| | | ds = oCN.RunProcReturn("select * from h_v_Sc_MouldDotCheckBill_Edit where 1=1 " + sqlWhere, "h_v_Sc_MouldDotCheckBill_Edit"); |
| | | //è·åé
件项ç®ç¼è¾æ°æ® |
| | | ds1 = oCN.RunProcReturn(@"select b.HMaterID, mt.Hnumber HMaterNumber ,mt.HName HMaterName, b.HUnitID |
| | | ,u2.hnumber HUnitNumber,u2.HName HUnitName,b.HQty,b.HQtyMust,b.HRemark |
| | |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "è·åä¿¡æ¯æåï¼"; |
| | | objJsonResult.data = null; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | objJsonResult.list = list; |
| | | |
| | | } |
| | |
| | | |
| | | #endregion |
| | | |
| | | |
| | | #region æ ¹æ®å¨å
·æ¡ç æ¥æ¾å¨å
·æ¡£æ¡ä¿¡æ¯PDA |
| | | [Route("QJ_PDA_MouldDotCheckBill/txtHBarCode_KeyDown")] |
| | | [HttpGet] |
| | | public object txtHBarCode_KeyDown(string HBarCode) |
| | | { |
| | | try |
| | | { |
| | | if (HBarCode == null || HBarCode.Equals("")) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ¡å½¢ç ä¸è½ä¸ºç©ºï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | //å¾å°ä¿¡æ¯ |
| | | ds = oCN.RunProcReturn("select top 1 * from Gy_MouldFileMain where HNumber= '" + HBarCode + "'", "Gy_MouldFileMain"); |
| | | //åå
¥ä¿¡æ¯ |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æªæ¥è¯¢å°å¨å
·ä¿¡æ¯ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | 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("Web/GetItemByMouldFile")] |
| | | [HttpGet] |
| | | public object GetItemByMouldFile(int MouldProjectID, string Type, string HDate) |
| | | { |
| | | if (MouldProjectID <= 0) |
| | | { |
| | | objjson.code = "0"; |
| | | objjson.count = 0; |
| | | objjson.Message = "产åå¨å
·æªéæ©"; |
| | | objjson.data = null; |
| | | return objjson; |
| | | } |
| | | try |
| | | { |
| | | string HView = ""; |
| | | switch (Type) |
| | | { |
| | | case "DJ": |
| | | HView = "h_v_QJ_GetDotCheckItemList"; |
| | | break; |
| | | default: |
| | | objjson.code = "0"; |
| | | objjson.count = 0; |
| | | objjson.Message = "è®¾å¤æ¨¡åç±»åé误ï¼"; |
| | | objjson.data = null; |
| | | return objjson; |
| | | } |
| | | |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | //string sql = string.Format(@"select * from " + HView + " where HInterID = " + EquipProjectID); |
| | | string sql = string.Format(@"Exec h_p_Sb_GetCheckItem_PDA '" + MouldProjectID + "','" + Type + "','" + HDate + "'"); |
| | | ds = oCN.RunProcReturn(sql, HView); |
| | | if (ds == null || ds.Tables[0].Rows.Count <= 0) |
| | | { |
| | | objjson.code = "0"; |
| | | objjson.count = 0; |
| | | objjson.Message = "è·å失败,æ¥æ æ°æ®" + DBUtility.ClsPub.sErrInfo; |
| | | objjson.data = null; |
| | | return objjson; |
| | | } |
| | | else |
| | | { |
| | | objjson.code = "1"; |
| | | objjson.count = 1; |
| | | objjson.Message = "è·åæå!"; |
| | | objjson.data = ds.Tables[0]; |
| | | return objjson; |
| | | } |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | objjson.code = "0"; |
| | | objjson.count = 0; |
| | | objjson.Message = "è·å失败" + ex.ToString(); |
| | | objjson.data = null; |
| | | return objjson; |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// æ ¹æ®å¨å
·ç¹æ£è®¡å带åºé¡¹ç® |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [Route("Web/GetItemByMouldDotCheckPlan")] |
| | | [HttpGet] |
| | | public object GetItemByMouldDotCheckPlan(int HInterID) |
| | | { |
| | | if (HInterID <= 0) |
| | | { |
| | | objjson.code = "0"; |
| | | objjson.count = 0; |
| | | objjson.Message = "产åå¨å
·ç¹æ£è®¡åæªéæ©"; |
| | | objjson.data = null; |
| | | return objjson; |
| | | } |
| | | try |
| | | { |
| | | |
| | | string sql = string.Format(@"select * from h_v_QJ_GetDotCheckItemList where ç¹æ£è®¡åID = " + HInterID ); |
| | | ds = oCN.RunProcReturn(sql, "h_v_QJ_GetDotCheckItemList"); |
| | | if (ds == null || ds.Tables[0].Rows.Count <= 0) |
| | | { |
| | | objjson.code = "0"; |
| | | objjson.count = 0; |
| | | objjson.Message = "è·å失败,æ¥æ æ°æ®" + DBUtility.ClsPub.sErrInfo; |
| | | objjson.data = null; |
| | | return objjson; |
| | | } |
| | | else |
| | | { |
| | | objjson.code = "1"; |
| | | objjson.count = 1; |
| | | objjson.Message = "è·åæå!"; |
| | | objjson.data = ds.Tables[0]; |
| | | return objjson; |
| | | } |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | objjson.code = "0"; |
| | | objjson.count = 0; |
| | | objjson.Message = "è·å失败" + ex.ToString(); |
| | | objjson.data = null; |
| | | return objjson; |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// æ¥è¯¢å类设å¤åæ®å表ï¼è®¾å¤ç¹æ£ï¼è®¾å¤ç»´ä¿®ï¼è®¾å¤ä¿å
»......ï¼ |
| | | /// </summary> |
| | | /// <returns></returns> |
| | |
| | | string sql = string.Format(@"select b.HDotCheckItemID HDotCheckItemID,c.HNumber HDotCheckCode,b.HDotCheckItem,b.HDotCheckPart,b.HClaim, |
| | | b.HManagerID,e.HNumber HManagerCode,e.HName HManagerName,b.HRemark from Sb_EquipDotCheckRuleBillMain a |
| | | left join Sb_EquipDotCheckRuleBillSub b on a.HInterID=b.HInterID |
| | | left join Gy_QCCheckItem c on c.HItemID=b.HDotCheckItemID |
| | | left join Gy_DotCheck c on c.HItemID=b.HDotCheckItemID |
| | | left join Gy_Employee e on e.HItemID=b.HManagerID |
| | | where a.HInterID=" + HDotCheckRuleInterID); |
| | | ds = oCN.RunProcReturn(sql, "Sb_EquipDotCheckRuleBillMain"); |
| | |
| | | ",HYear,HPeriod,HRemark,HEquipID" + |
| | | ",HBeginDate,HEndDate,HPlanNo,HExplanation,HInnerBillNo" + |
| | | ",HDeptID,HQty,HEquipDotCheckRuleInterID" + |
| | | ",HLastResult,HErrNote,HBigSafeNote,HShiftsID,HDotCheckNote" + |
| | | ") " + |
| | | " values('" + this.BillType + "','" + this.HBillSubType + "'," +omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate + "','" + omodel.HMaker + "',getdate()" + |
| | | "," + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "'," + omodel.HEquipID.ToString() + |
| | | ",'" + omodel.HBeginDate + "','" + omodel.HEndDate + "','" + omodel.HPlanNo + "','" + omodel.HExplanation + "','" + omodel.HInnerBillNo + "'" + |
| | | ",'" + omodel.HDeptID + "'," + omodel.HQty + "," + omodel.HEquipDotCheckRuleInterID + |
| | | ",'" + omodel.HDeptID + "'," + omodel.HQty + "," + omodel.HEquipDotCheckRuleInterID + ",'" + omodel.HLastResult + "','" + omodel.HErrNote + "','" + omodel.HBigSafeNote + "'," + omodel.HShiftsID + ",'" + omodel.HDotCheckNote + "'" + |
| | | ") "); |
| | | //æå
¥å表 |
| | | foreach (Models.ClsSb_EquipDotCheckBillSub oSub in DetailColl) |
| | |
| | | "HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney," + |
| | | "HDotCheckItem,HDotCheckPart,HClaim," + |
| | | "HManagerID,HManagerNumber,HDotCheckResult,HDotCheckItemID " + |
| | | ",HDotCheckItemClassID,HDotCheckItemMethodID" + |
| | | ") values(" |
| | | + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + |
| | | ",'" + oSub.HCloseMan + "','" + oSub.HEntryCloseDate + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" + |
| | | "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() + |
| | | ",'" + oSub.HDotCheckItem + "','" + oSub.HDotCheckPart + "','" + oSub.HClaim + |
| | | "'," + oSub.HManagerID.ToString() + ",'" + oSub.HManagerNumber + "','" + oSub.HDotCheckResult + "'," + oSub.HDotCheckItemID + |
| | | "'," + oSub.HManagerID.ToString() + ",'" + oSub.HManagerNumber + "','" + oSub.HDotCheckResult + "'," + oSub.HDotCheckItemID + "," + oSub.HDotCheckItemClassID + "," + oSub.HDotCheckItemMethodID + |
| | | ") "); |
| | | } |
| | | //æ´æ°ç¹æ£è®¡åå表å
³èæ è®° |
| | |
| | | public long HDeptID;// int --é¨é¨ID |
| | | public decimal HQty; //æ°é |
| | | public Int64 HEquipDotCheckRuleInterID; //ç¹æ£è§ç¨ |
| | | |
| | | public string HLastResult;// æç»ç»è®ºï¼OKï¼NGï¼ |
| | | public string HErrNote;// å¼å¸¸æ
åµè®°å½ |
| | | public string HBigSafeNote;// é大å®å
¨éæ£è®°å½ |
| | | public Int64 HShiftsID;// çäº§çæ¬¡ï¼Gy_Shiftsï¼ |
| | | public string HDotCheckNote;// ç¹æ£æ°æ® |
| | | } |
| | | } |
| | |
| | | public string HManagerNumber; |
| | | public string HManagerName; |
| | | public string HDotCheckResult; |
| | | |
| | | public Int64 HDotCheckItemClassID;// ç¹æ£é¡¹ç®åç±»(gy_DotCheckItemClass) |
| | | public Int64 HDotCheckItemMethodID;// ç¹æ£æ¹æ³(gy_DotCheckItemMethod) |
| | | } |
| | | } |