设备/器具(保养规程,设备保养计划,设备保养记录单)表头增加“保养级别”字段
| | |
| | | ",HEndDate='" + omodel.HEndDate + "'" + |
| | | ",HExplanation='" + omodel.HExplanation + "'" + |
| | | ",HInnerBillNo='" + omodel.HInnerBillNo + "'" + |
| | | ",HMouldMaintainRuleInterID="+omodel.HMouldMaintainRuleInterID.ToString()+ |
| | | ",HMouldMaintainRuleInterID=" + omodel.HMouldMaintainRuleInterID.ToString() + |
| | | ",HMaintainLevID=" + omodel.HMaintainLevID + |
| | | //",HDeptID=" + omodel.HDeptID.ToString() + |
| | | //",HDeptNumber='" + omodel.HDeptNumber +"'"+ |
| | | //",HEmpID=" + omodel.HEmpID.ToString() + |
| | |
| | | ",HYear,HPeriod,HRemark" + |
| | | ",HPlanNo,HPlanInterID,HMouldID,HBeginDate"+ |
| | | ",HEndDate"+ |
| | | ",HInnerBillNo,HExplanation,HMouldMaintainRuleInterID" + |
| | | ",HInnerBillNo,HExplanation,HMouldMaintainRuleInterID,HMaintainLevID" + |
| | | ") " + |
| | | " 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.HPlanNo + "'," + omodel.HPlanInterID.ToString() + "," + omodel.HMouldID.ToString() + ",'" + omodel.HBeginDate + "'" + |
| | | ",'" + omodel.HEndDate + "'"+ |
| | | ",'" + omodel.HInnerBillNo + "','" + omodel.HExplanation + "'," +omodel.HMouldMaintainRuleInterID.ToString()+ |
| | | ",'" + omodel.HInnerBillNo + "','" + omodel.HExplanation + "'," +omodel.HMouldMaintainRuleInterID.ToString() + "," + omodel.HMaintainLevID + |
| | | ") "); |
| | | |
| | | if (DetailCol.Count > 0) |
| | |
| | | ",HEndDate='" + omodel.HEndDate + "'" + |
| | | ",HExplanation='" + omodel.HExplanation + "'" + |
| | | ",HInnerBillNo='" + omodel.HInnerBillNo + "'" + |
| | | |
| | | ",HMaintainLevID=" + omodel.HMaintainLevID + |
| | | " where HInterID=" + lngBillKey.ToString()); |
| | | //å é¤å
³è |
| | | DeleteRelation(ref sReturn, lngBillKey); |
| | |
| | | "(HBillType,HBillSubType,HInterID,HBillNo,HDate,HMaker,HMakeDate" + |
| | | ",HYear,HPeriod,HRemark" + |
| | | ",HCycleUnit,HCheckCycle,HBeginDate,HEndDate"+ |
| | | ",HInnerBillNo,HExplanation,HMouldMaintainRuleID" + |
| | | ",HInnerBillNo,HExplanation,HMouldMaintainRuleID,HMaintainLevID" + |
| | | ") " + |
| | | " 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.HMouldMaintainRuleID + "'" + |
| | | ",'" + omodel.HInnerBillNo + "','" + omodel.HExplanation + "','" + omodel.HMouldMaintainRuleID + "'," + omodel.HMaintainLevID + |
| | | ") "); |
| | | //æå
¥å表é
ä»¶ä¿¡æ¯ |
| | | foreach (Model.ClsSc_MouldMaintainPlanBillSub oSub in DetailColl) |
| | |
| | | ",'" + 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() + |
| | | "," + Item.HSourceInterID.ToString() + "," + Item.HSourceEntryID.ToString() + ",'" + Item.HSourceBillNo + "','" + Item.HSourceBillType + "'," + Item.HRelationQty.ToString() + "," + Item.HRelationMoney.ToString() +",'" + Item.HMaintainItem.ToString() + "'" + |
| | | ") "); |
| | | } |
| | | // |
| | |
| | | ",HCheckCycle=" + omodel.HCheckCycle.ToString() + |
| | | ",HExplanation='" + omodel.HExplanation + "'" + |
| | | ",HInnerBillNo='" + omodel.HInnerBillNo + "'" + |
| | | ",HMaintainLevID=" + omodel.HMaintainLevID + |
| | | " where HInterID=" + lngBillKey.ToString()); |
| | | //å é¤å
³è |
| | | //DeleteRelation(ref sReturn, lngBillKey); |
| | |
| | | oCn.RunProc("Insert Into Sc_MouldMaintainRuleBillMain" + |
| | | "(HBillType,HBillSubType,HInterID,HBillNo,HDate" + |
| | | ",HYear,HPeriod,HRemark,HMaker,HMakeDate" + |
| | | ",HCycleUnit,HCheckCycle,HExplanation,HInnerBillNo" + |
| | | ",HCycleUnit,HCheckCycle,HExplanation,HInnerBillNo,HMaintainLevID" + |
| | | ") " + |
| | | " values('" + this.BillType + "','" + this.HBillSubType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate + "'" + |
| | | ", " + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "','" + DBUtility.ClsPub.CurUserName + "',getdate()" + |
| | | ",'" + omodel.HCycleUnit + "'," + omodel.HCheckCycle.ToString() + ",'" + omodel.HExplanation + "','" + omodel.HInnerBillNo + "'" + |
| | | ",'" + omodel.HCycleUnit + "'," + omodel.HCheckCycle.ToString() + ",'" + omodel.HExplanation + "','" + omodel.HInnerBillNo + "'," + omodel.HMaintainLevID + |
| | | ") "); |
| | | ////æå
¥å表 |
| | | foreach (Model.ClsSc_MouldMaintainRuleBillSub oSub in DetailColl_Mater) |
| | |
| | | ",HPlanNo='" + omodel.HPlanNo + "'" + |
| | | ",HExplanation='" + omodel.HExplanation+"'" + |
| | | ",HInnerBillNo='" + omodel.HInnerBillNo+"'" + |
| | | ",HEquipMaintainRuleInterID="+omodel.HEquipMaintainRuleInterID.ToString()+ |
| | | ",HEquipMaintainRuleInterID=" + omodel.HEquipMaintainRuleInterID.ToString()+ |
| | | ",HMaintainLevID=" + omodel.HMaintainLevID + |
| | | " where HInterID=" + lngBillKey.ToString()); |
| | | //å é¤å
³è |
| | | DeleteRelation(ref sReturn, lngBillKey); |
| | |
| | | "(HBillType,HBillSubType,HInterID,HBillNo,HDate,HMaker,HMakeDate" + |
| | | ",HYear,HPeriod,HRemark,HEquipID" + |
| | | ",HBeginDate,HEndDate,HPlanNo,HExplanation,HInnerBillNo,HEquipMaintainRuleInterID" + |
| | | ",HDeptID" + |
| | | ",HDeptID,HMaintainLevID" + |
| | | ") " + |
| | | " 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.HEquipID.ToString() + |
| | | ",'" + omodel.HBeginDate + "','" + omodel.HEndDate + "','" + omodel.HPlanNo + "','" + omodel.HExplanation + "','" + omodel.HInnerBillNo + "'," +omodel.HEquipMaintainRuleInterID.ToString() + "," + omodel.HDeptID + |
| | | ",'" + omodel.HBeginDate + "','" + omodel.HEndDate + "','" + omodel.HPlanNo + "','" + omodel.HExplanation + "','" + omodel.HInnerBillNo + "'," +omodel.HEquipMaintainRuleInterID.ToString() + "," + omodel.HDeptID + "," + omodel.HMaintainLevID + |
| | | ") "); |
| | | //æå
¥é
ä»¶å表 |
| | | foreach (Model.ClsSb_EquipMaintainBillSub oSub in DetailColl) |
| | |
| | | ",HCheckCycle=" + omodel.HCheckCycle.ToString() + |
| | | ",HExplanation='" + omodel.HExplanation+"'" + |
| | | ",HInnerBillNo='" + omodel.HInnerBillNo+"'" + |
| | | ",HMaintainLevID=" + omodel.HMaintainLevID + |
| | | " where HInterID=" + lngBillKey.ToString()); |
| | | //å é¤å
³è |
| | | DeleteRelation(ref sReturn, lngBillKey); |
| | |
| | | oCn.RunProc("Insert Into Sb_EquipMaintainPlanBillMain " + |
| | | "(HBillType,HBillSubType,HInterID,HBillNo,HDate,HMaker,HMakeDate" + |
| | | ",HYear,HPeriod,HRemark,HEquipID" + |
| | | ",HBeginDate,HEndDate,HCheckCycle,HCycleUnit,HExplanation,HInnerBillNo,HMouldMaintainRuleID" + |
| | | ",HBeginDate,HEndDate,HCheckCycle,HCycleUnit,HExplanation,HInnerBillNo,HMouldMaintainRuleID,HMaintainLevID" + |
| | | ") "+ |
| | | " 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.HCheckCycle.ToString() +",'"+ omodel.HCycleUnit + "','" + omodel.HExplanation + "','" + omodel.HInnerBillNo +"','" + omodel.HMouldMaintainRuleID + "'" + |
| | | ",'" + omodel.HBeginDate +"','" +omodel.HEndDate + "'," + omodel.HCheckCycle.ToString() +",'"+ omodel.HCycleUnit + "','" + omodel.HExplanation + "','" + omodel.HInnerBillNo +"','" + omodel.HMouldMaintainRuleID + "'," + omodel.HMaintainLevID + |
| | | ") "); |
| | | if (DetailColl != null) |
| | | { |
| | |
| | | public string HExplanation;// --ÕªÒª |
| | | public string HInnerBillNo;// --å
é¨åæ®å· |
| | | public int HMouldMaintainRuleInterID; |
| | | |
| | | public Int64 HMaintainLevID; //ä¿å
»çº§å«ï¼gy_HMaintainLevï¼ |
| | | } |
| | | } |
| | |
| | | public string HExplanation;// varchar(500) --ÕªÒª |
| | | public string HInnerBillNo;// varchar(50) --å
é¨åæ®å· |
| | | public int HMouldMaintainRuleID; //å¨å
·ä¿å
»è§ç¨id |
| | | |
| | | public Int64 HMaintainLevID; //ä¿å
»çº§å«ï¼gy_HMaintainLevï¼ |
| | | } |
| | | } |
| | |
| | | public Int64 HCheckCycle;// int --ä¿å
»å¨æ |
| | | public string HExplanation;// varchar(500) --ÕªÒª |
| | | public string HInnerBillNo;// varchar(50) --å
é¨åæ®å· |
| | | |
| | | |
| | | |
| | | public Int64 HMaintainLevID; //ä¿å
»çº§å«ï¼gy_HMaintainLevï¼ |
| | | } |
| | | } |
| | |
| | | |
| | | public int HEquipMaintainPlanInterID; //设å¤ä¿å
»è®¡ååï¼Sb_EquipMaintainPlanBillSub_Planï¼ä¸»å
ç |
| | | public int HEquipMaintainPlanEntryID; //设å¤ä¿å
»è®¡ååï¼Sb_EquipMaintainPlanBillSub_Planï¼åå
ç |
| | | |
| | | public Int64 HMaintainLevID; //ä¿å
»çº§å«ï¼gy_HMaintainLevï¼ |
| | | } |
| | | } |
| | |
| | | public string HExplanation; |
| | | public string HInnerBillNo; |
| | | public int HMouldMaintainRuleID; //ä¿å
»è§ç¨id |
| | | |
| | | |
| | | |
| | | public Int64 HMaintainLevID; //ä¿å
»çº§å«ï¼gy_HMaintainLevï¼ |
| | | } |
| | | } |
| | |
| | | if (string.IsNullOrEmpty(HID)) |
| | | return new ApiResult<DataSet> { code = -1, msg = "IDä¸è½ä¸ºç©º" }; |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | var dataSet = oCN.RunProcReturn("select top 1 * from Sc_MouldMaintainRuleBillMain where HInterID= " + HID + " ", "Sc_MouldMaintainRuleBillMain"); |
| | | var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Sc_MouldMaintainRuleBill_Edit where HInterID= " + HID + " ", "h_v_Sc_MouldMaintainRuleBill_Edit"); |
| | | if (dataSet == null || dataSet.Tables[0].Rows.Count == 0) |
| | | return new ApiResult<DataSet> { code = -1, msg = "ä¸åå¨å¨å
·ä¿å
»è§ç¨è®°å½" }; |
| | | return new ApiResult<DataSet> { code = 1, msg = "æ¥è¯¢æå", data = dataSet }; |
| | |
| | | using DBUtility; |
| | | using Newtonsoft.Json; |
| | | using Newtonsoft.Json.Linq; |
| | | using System; |
| | | using System.Collections.Generic; |
| | |
| | | { |
| | | try |
| | | { |
| | | List<object> columnNameList = new List<object>(); |
| | | if (!DBUtility.ClsPub.Security_Log("Sb_EquipMaintainPlanBillList", 1, false, user)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | |
| | | ds = oCN.RunProcReturn(sql, "h_v_Sc_EquipMaintainPlan"); |
| | | } |
| | | |
| | | |
| | | //æ·»å åå |
| | | 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));//è·åå°DataColumnå对象çåå |
| | | } |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | objJsonResult.list = columnNameList; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception ex) |
| | |
| | | if (string.IsNullOrEmpty(HID)) |
| | | return new ApiResult<DataSet> { code = -1, msg = "IDä¸è½ä¸ºç©º" }; |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | var dataSet = oCN.RunProcReturn("select top 1 * from Sb_EquipMaintainRuleBillMain where HInterID= " + HID + " ", "Sb_EquipMaintainRuleBillMain"); |
| | | var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Sb_EquipMaintainRuleBillList where HInterID= " + HID + " ", "h_v_Sb_EquipMaintainRuleBillList"); |
| | | if (dataSet == null || dataSet.Tables[0].Rows.Count == 0) |
| | | return new ApiResult<DataSet> { code = -1, msg = "ä¸åå¨ç¹æ£è®¡å表" }; |
| | | return new ApiResult<DataSet> { code = -1, msg = "ä¸åå¨ä¿å
»è§ç¨è¡¨" }; |
| | | return new ApiResult<DataSet> { code = 1, msg = "æ¥è¯¢æå", data = dataSet }; |
| | | } |
| | | #endregion |
| | |
| | | { |
| | | try |
| | | { |
| | | List<object> columnNameList = new List<object>(); |
| | | if (!DBUtility.ClsPub.Security_Log("Sc_MouldMaintainPlanBillList", 1, false, user)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | |
| | | |
| | | ds = Sc_MouldMaintainPlanBillList_s(sWhere); |
| | | |
| | | //æ·»å åå |
| | | 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));//è·åå°DataColumnå对象çåå |
| | | } |
| | | |
| | | //if (ds.Tables[0].Rows.Count != 0 || ds != null) |
| | | //{ |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | objJsonResult.list = columnNameList; |
| | | return objJsonResult; |
| | | //} |
| | | //else |
| | |
| | | { |
| | | try |
| | | { |
| | | LogService.Write("çäº§æ±æ¥åè¿å
¥åæ¥æ¹æ³ï¼æ±æ¥åå·ï¼" + BillNo); |
| | | |
| | | string sErr = ""; |
| | | oSystemParameter.ShowBill(ref sErr); |
| | | |
| | |
| | | DataSet ds = oCN.RunProcReturn("select * from h_v_MES_StationOutBillList_LastProc where HInterID=" + InterID, "h_v_MES_StationOutBillList_LastProc"); |
| | | if (ds.Tables[0].Rows.Count <= 0) |
| | | { |
| | | LogService.Write("çäº§æ±æ¥ååæ»ï¼æ±æ¥åå·ï¼" + BillNo + " åå ï¼çæçäº§æ±æ¥åè¿ç¨ä¸æ²¡ææ¥è¯¢å°åºç«å"); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "çæçäº§æ±æ¥åè¿ç¨ä¸æ²¡ææ¥è¯¢å°åºç«å"; |
| | |
| | | |
| | | //ä¿å |
| | | oCN.BeginTran(); |
| | | DataSet DsTable = oCN.RunProcReturn($"select * from Sc_ICMOReportBillMain where HBillNo='{HBillNo}'", "Sc_ICMOReportBillMain"); |
| | | DataSet DsTable = oCN.RunProcReturn($"select * from Sc_ICMOReportBillMain with(nolock) where HBillNo='{HBillNo}'", "Sc_ICMOReportBillMain"); |
| | | if (DsTable.Tables[0].Rows.Count > 0) |
| | | { |
| | | LogService.Write("çäº§æ±æ¥ååæ»ï¼æ±æ¥åå·ï¼" + BillNo + " åå ï¼å·²å
¥åº,请ä¸è¦éå¤å
¥åº"); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "å·²å
¥åº,请ä¸è¦éå¤å
¥åº"; |
| | |
| | | var isSuccess = JObject.Parse(loginRet)["LoginResultType"].Value<int>(); |
| | | if (isSuccess == 0) |
| | | { |
| | | LogService.Write("çäº§æ±æ¥ååæ»ï¼æ±æ¥åå·ï¼" + BillNo + " åå ï¼æä½å¤±è´¥,éè¶è´¦å·ç»å½å¼å¸¸"); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æä½å¤±è´¥,éè¶è´¦å·ç»å½å¼å¸¸ã" + loginRet; |
| | |
| | | if (JObject.Parse(result)["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE") |
| | | { |
| | | LogService.Write("å·¥åºæ±æ¥åå
¥åºé误jsonRoot:" + jsonRoot); |
| | | LogService.Write("çäº§æ±æ¥åä¿åå¤±è´¥ï¼æ±æ¥åå·ï¼" + BillNo + " åå ï¼" + result); |
| | | oCN.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | |
| | | result2 = InvokeHelper.Audit("PRD_MORPT", JsonConvert.SerializeObject(json));//æäº¤ |
| | | if (JObject.Parse(result1)["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE") |
| | | { |
| | | LogService.Write("çäº§æ±æ¥åæäº¤å¤±è´¥ï¼æ±æ¥åå·ï¼" + BillNo + " åå ï¼" + result1); |
| | | oCN.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = $"çäº§æ±æ¥ååå·ï¼{fBillNo}ï¼æäº¤å¤±è´¥" + result; |
| | | objJsonResult.Message = $"çäº§æ±æ¥ååå·ï¼{fBillNo}ï¼æäº¤å¤±è´¥" + result1; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | oCN.RunProc("update Sc_StationOutBillMain set HRelationQty=1 where HBillNo='" + BillNo + "'"); |
| | | |
| | | oCN.Commit(); |
| | | |
| | | LogService.Write("çäº§æ±æ¥åä¿åæåï¼æ±æ¥åå·ï¼" + BillNo ); |
| | | |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "ä¿åæåï¼"; |
| | |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | LogService.Write("çäº§æ±æ¥å忥åçå¼å¸¸ï¼æ±æ¥åå·ï¼" + BillNo + " " + e.ToString()); |
| | | oCN.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | |
| | | { |
| | | try |
| | | { |
| | | LogService.Write("ç产å
¥åºåè¿å
¥åæ¥æ¹æ³:" + " å
¥åºåå·ï¼" + BillNo); |
| | | //è·åçäº§æ±æ¥åæå¤§InterIDååæ®å· |
| | | Int64 HInterID = DBUtility.ClsPub.CreateBillID("1202", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | string HBillNo = DBUtility.ClsPub.CreateBillCode("1202", ref DBUtility.ClsPub.sExeReturnInfo, true); |
| | |
| | | //DataRow dr = ds.Tables[0].Rows[0]; |
| | | |
| | | //夿å
¥åºçåæ ¼æ°éæ¯å¦ä¸º0 |
| | | var DTable = oCN.RunProcReturn("select * from Sc_StationOutBillMain where HBillNo='" + BillNo + "' ", "Sc_StationOutBillMain").Tables[0]; |
| | | var DTable = oCN.RunProcReturn("select * from Sc_StationOutBillMain with(nolock) where HBillNo='" + BillNo + "' ", "Sc_StationOutBillMain").Tables[0]; |
| | | |
| | | if (double.Parse(DTable.Rows[0]["HQty"].ToString()) == 0) |
| | | { |
| | | LogService.Write("忥éè¶ç产ç产å
¥åºååæ»--åºç«åå·ï¼" + BillNo + " åæ»åå ï¼åæ ¼æ°é为0,ä¸éè¦å
¥åºï¼"); |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 2; |
| | | objJsonResult.Message = "åæ ¼æ°é为0,ä¸éè¦å
¥åºï¼"; |
| | |
| | | var isSuccess = JObject.Parse(loginRet)["LoginResultType"].Value<int>(); |
| | | if (isSuccess == 0) |
| | | { |
| | | LogService.Write("忥éè¶ç产å
¥åºååæ»--åºç«åå·ï¼" + BillNo + " åæ»åå ï¼æä½å¤±è´¥,éè¶è´¦å·ç»å½å¼å¸¸"); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æä½å¤±è´¥,éè¶è´¦å·ç»å½å¼å¸¸ã" + loginRet; |
| | |
| | | |
| | | if (ds1 == null || ds1.Tables[0].Rows.Count == 0) |
| | | { |
| | | LogService.Write("忥éè¶ç产å
¥åºååæ»--åºç«åå·ï¼" + BillNo + " åæ»åå ï¼æªæ¾å°å¯¹åºçæ¬å°æéè¶äºçäº§æ±æ¥åè®°å½;1.æªæ¥è¯¢å°å¯¹åºççäº§æ±æ¥åï¼2.请确ä¿å½åå·¥åºæ¯æ«éå·¥åº3.æ±æ¥å对åºçå
¥åºæ°é已满 请å¨éè¶äºæ¥çå
¥åºè®°å½ï¼"); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æªæ¾å°å¯¹åºçæ¬å°æéè¶äºçäº§æ±æ¥åè®°å½;1.æªæ¥è¯¢å°å¯¹åºççäº§æ±æ¥åï¼2.请确ä¿å½åå·¥åºæ¯æ«éå·¥åº3.æ±æ¥å对åºçå
¥åºæ°é已满 请å¨éè¶äºæ¥çå
¥åºè®°å½ï¼"; |
| | |
| | | DataRow dr1 = ds1.Tables[0].Rows[0]; |
| | | if (double.Parse(dr1[0].ToString()) <= 0) |
| | | { |
| | | LogService.Write("忥éè¶ç产å
¥åºååæ»--åºç«åå·ï¼" + BillNo + " åæ»åå ï¼æªæ¾å°å¯¹åºççäº§æ±æ¥åè®°å½;1.æªæ¥è¯¢å°å¯¹åºççäº§æ±æ¥åï¼2.请确ä¿å½åå·¥åºæ¯æ«éå·¥åº3.æ±æ¥å对åºçå
¥åºæ°é已满 请å¨éè¶äºæ¥çå
¥åºè®°å½ï¼"); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æªæ¾å°å¯¹åºççäº§æ±æ¥åè®°å½;1.æªæ¥è¯¢å°å¯¹åºççäº§æ±æ¥åï¼2.请确ä¿å½åå·¥åºæ¯æ«éå·¥åº3.æ±æ¥å对åºçå
¥åºæ°é已满 请å¨éè¶äºæ¥çå
¥åºè®°å½ï¼"; |
| | |
| | | |
| | | if (ds.Tables[0].Rows.Count > 0) |
| | | { |
| | | LogService.Write("忥éè¶ç产å
¥åºååæ»--åºç«åå·ï¼" + BillNo + " åæ»åå ï¼å½ååºç«åå·å·²å
¥åº,请ä¸è¦éæ°å
¥åº!"); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "å½ååºç«åå·å·²å
¥åº,请ä¸è¦éæ°å
¥åº!"; |
| | |
| | | } |
| | | |
| | | //夿éè¶äºçäº§æ±æ¥å æ°é æ¯å¦ å¤§äº æ«éåºç«æ°é |
| | | ds = oCN.RunProcReturn($@"select sum(FFinishQty)-sum(FSTOCKINQUASELQTY)-(select HQty from Sc_StationOutBillMain where HBillNo='{BillNo}') |
| | | ds = oCN.RunProcReturn($@"select sum(FFinishQty)-sum(FSTOCKINQUASELQTY)-(select HQty from Sc_StationOutBillMain with(nolock) where HBillNo='{BillNo}') |
| | | from AIS20220308151944..T_PRD_MORPT rpt3 |
| | | left join AIS20220308151944..T_PRD_MORPTENTRY rpt2 on rpt3.FID = rpt2.FID |
| | | left join AIS20220308151944..T_PRD_MORPTENTRY_A rpt1 on rpt2.FID = rpt1.FID |
| | |
| | | |
| | | if (double.Parse(ds.Tables[0].Rows[0][0].ToString()) < 0) |
| | | { |
| | | LogService.Write("忥éè¶ç产å
¥åºååæ»--åºç«åå·ï¼" + BillNo + " åæ»åå ï¼éè¶äºæ±æ¥æ°éå°äºæ¬å°åºç«æ°é!"); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "éè¶äºæ±æ¥æ°éå°äºæ¬å°åºç«æ°é!"; |
| | |
| | | { |
| | | if (item["HWYID"].ToString() == null || item["HWYID"].ToString() == "" || item["HWYID"].ToString() == "undefined") |
| | | { |
| | | LogService.Write("忥éè¶ç产å
¥åºååæ»--åºç«åå·ï¼" + BillNo + " åæ»åå ï¼å¯ä¸ID为空ï¼è¯·éæ°æå¨å
¥åºæè系管çåï¼"); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "å¯ä¸ID为空ï¼è¯·éæ°æå¨å
¥åºæè系管çåï¼"; |
| | |
| | | string result = InvokeHelper.Save("PRD_INSTOCK", JsonConvert.SerializeObject(jsonRoot));//ä¿å |
| | | //夿ä¿åæ¯å¦æå |
| | | if (JObject.Parse(result)["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE") |
| | | { |
| | | LogService.Write("ç产å
¥åºé误jsonRoot:" + jsonRoot); |
| | | { |
| | | LogService.Write("ç产å
¥åºä¿åé误jsonRoot:" + jsonRoot + " å
¥åºåå·ï¼" + BillNo); |
| | | oCN.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | |
| | | //result2 = InvokeHelper.Audit("PRD_INSTOCK", JsonConvert.SerializeObject(json));//æäº¤ |
| | | if (JObject.Parse(result1)["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE") |
| | | { |
| | | LogService.Write("ç产å
¥åºæäº¤é误jsonRoot:" + jsonRoot + " å
¥åºåå·ï¼" + BillNo); |
| | | oCN.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | |
| | | } |
| | | |
| | | oCN.RunProc("update Sc_StationOutBillMain set HRelationQty=1 where HBillNo='" + BillNo + "'"); |
| | | |
| | | LogService.Write("ç产å
¥åºåæ¥æå:" + " å
¥åºåå·ï¼" + BillNo); |
| | | oCN.Commit(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | LogService.Write("ç产å
¥åºåæ¥åçå¼å¸¸:" + " å
¥åºåå·ï¼" + BillNo + " " + e.ToString()); |
| | | oCN.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | |
| | | ",HCheckCycle=" + omodel.HCheckCycle.ToString() + |
| | | ",HExplanation='" + omodel.HExplanation + "'" + |
| | | ",HInnerBillNo='" + omodel.HInnerBillNo + "'" + |
| | | ",HMaintainLevID=" + omodel.HMaintainLevID + |
| | | " where HInterID=" + lngBillKey.ToString()); |
| | | //å é¤å
³è |
| | | DeleteRelation(ref sReturn, lngBillKey); |
| | |
| | | oCn.RunProc("Insert Into Sb_EquipMaintainRuleBillMain " + |
| | | "(HBillType,HBillSubType,HInterID,HBillNo,HDate,HMaker,HMakeDate" + |
| | | ",HYear,HPeriod,HRemark" + |
| | | ",HCheckCycle,HCycleUnit,HExplanation,HInnerBillNo" + |
| | | ",HCheckCycle,HCycleUnit,HExplanation,HInnerBillNo,HMaintainLevID" + |
| | | ") " + |
| | | " values('" + this.BillType + "','" + this.HBillSubType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate + "','" + omodel.HMaker + "',getdate()" + |
| | | "," + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + |
| | | "',"+ omodel.HCheckCycle.ToString() + ",'" + omodel.HCycleUnit + "','" + omodel.HExplanation + "','" + omodel.HInnerBillNo + |
| | | "') "); |
| | | "',"+ omodel.HCheckCycle.ToString() + ",'" + omodel.HCycleUnit + "','" + omodel.HExplanation + "','" + omodel.HInnerBillNo + "'," + omodel.HMaintainLevID + |
| | | ") "); |
| | | |
| | | //æå
¥ä¿å
»é¡¹å表 |
| | | foreach (Models.ClsSb_EquipMaintainRuleBillSub_Item Item in DetailColl_Pay) |
| | |
| | | public int HCheckCycle; //--ä¿å
»å¨æ |
| | | public string HExplanation; // varchar(500) --æè¦ |
| | | public string HInnerBillNo; //varchar(50) --å
é¨åæ®å· |
| | | |
| | | public Int64 HMaintainLevID; //ä¿å
»çº§å«ï¼gy_HMaintainLevï¼ |
| | | } |
| | | } |