| | |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [Route("WEBSController/set_SaveQCPOStockInCheckBill_Json")] |
| | | [HttpPost] |
| | | [HttpGet] |
| | | public object set_SaveQCPOStockInCheckBill_Json(Int64 HInterID, string HBillNo, string HSourceBillType, string HSourceBillNo, Int64 HSourceInterID, string sHSourceEntryID, Int64 HFirstCheckEmp, string HMaker) |
| | | { |
| | | try |
| | |
| | | oSub.HBadQty = Pub_Class.ClsPub.isDoule(Ds.Tables[1].Rows[i]["HBadQty"]); |
| | | |
| | | oCn.RunProc("Insert Into QC_POStockInCheckBillSub " + |
| | | "(HInterID,HEntryID,,HBillNo_bak,HRemark" + |
| | | "(HInterID,HEntryID,HBillNo_bak,HRemark" + |
| | | ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType" + |
| | | ",HQCCheckClassID,HQCCheckItemID,HQCStd,HQCRelValue" + |
| | | "HResult,HProcCheckEmp,HProcCheckTime" + |
| | | "HMaterID,HInStockQty,HCheckQty,HRightQty,HBadQty" + |
| | | ",HResult,HProcCheckEmp,HProcCheckTime" + |
| | | ",HMaterID,HInStockQty,HCheckQty,HRightQty,HBadQty" + |
| | | ") " + |
| | | " values(" + oMain.HInterID.ToString() + "," + oSub.HEntryID.ToString() + ",'" + oMain.HBillNo + "','" + oSub.HRemark + "'" + |
| | | ", " + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'" + |
| | | ", " + oSub.HQCCheckClassID.ToString() + "," + oSub.HQCCheckItemID.ToString() + ",'" + oSub.HQCStd + "','" + oSub.HQCRelValue + "'" + |
| | | ",'" + oSub.HResult + "'," + oSub.HProcCheckEmp.ToString() + "',getdate()" + |
| | | ",'" + oSub.HResult + "'," + oSub.HProcCheckEmp.ToString() + ",getdate()" + |
| | | ", " + oSub.HMaterID.ToString() + "," + oSub.HInStockQty.ToString() + "," + oSub.HCheckQty.ToString() + "," + oSub.HRightQty.ToString() + "," + oSub.HBadQty.ToString() + |
| | | ") "); |
| | | } |
| | |
| | | if (isSuccess == 1) |
| | | { |
| | | string result = InvokeHelper.Save("QM_InspectBill", sJson); //ä¿å |
| | | |
| | | sRemark = sRemark + " ï¼çæCLOUDåæ®" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff"); |
| | | |
| | | HReturn = result.ToString(); |
| | |
| | | else |
| | | { |
| | | sRemark = sRemark + sJson; |
| | | // æäº¤åä¿ååæ® |
| | | string result1 = string.Empty; |
| | | string result2 = string.Empty; |
| | | var fID = JObject.Parse(result)["Result"]["Id"].ToString(); |
| | | var fBillNo = JObject.Parse(result)["Result"]["Number"].ToString(); |
| | | var json = new |
| | | { |
| | | Ids = fID, |
| | | }; |
| | | |
| | | result1 = InvokeHelper.Submit("QM_InspectBill", JsonConvert.SerializeObject(json));//æäº¤ |
| | | result2 = InvokeHelper.Audit("QM_InspectBill", JsonConvert.SerializeObject(json));//å®¡æ ¸ |
| | | if (JObject.Parse(result1)["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE") |
| | | { |
| | | oCn.RollBack(); |
| | | sErrMsg = $"æ¥ææ£éªåå·ï¼{fBillNo}ï¼æäº¤å¤±è´¥" + result; |
| | | return false; |
| | | } |
| | | oCn.Commit(); |
| | | } |
| | | } |
| | |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = DBUtility.ClsPub.sErrInfo; //æåï¼ |
| | | objJsonResult.data = oDs.Tables[0]; |
| | | return objJsonResult; |