| | |
| | | private bool SaveMoveOut_CLD(Model.ClsKf_MoveStockBillMain oMain, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg) |
| | | { |
| | | SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); |
| | | DataSet Ds; |
| | | try |
| | | { |
| | | DataSet Ds; |
| | | // |
| | | oCn.BeginTran(); |
| | | //写入WMS调拨单 |
| | |
| | | //审核单据 |
| | | oCn.RunProc("Update Kf_ICStockBillMain Set HChecker='" + oMain.HMaker + "',HCheckDate=convert(varchar(10),getdate(),120),HBillStatus=2 where HInterID= " + oMain.HInterID.ToString()); |
| | | } |
| | | |
| | | oCn.Commit(); |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | sErrMsg = "生成直接调拨单失败111!" + e.Message; |
| | | oCn.RollBack(); |
| | | return false; |
| | | } |
| | | try |
| | | { |
| | | //根据TMP表 返回 子表信息 |
| | | Ds = oCn.RunProcReturn("exec h_p_Kf_GetMoveOutBill_CLD " + oMain.HInterID.ToString() + ",'" + oMain.HBillNo + "'", "h_p_Kf_GetMoveOutBill_CLD"); |
| | | if (Ds == null || Ds.Tables[0].Rows.Count == 0 || Ds.Tables[1].Rows.Count == 0) |
| | | { |
| | | sErrMsg = "获取子表信息失败!"; |
| | | oCn.RollBack(); |
| | | //oCn.RollBack(); |
| | | return false; |
| | | } |
| | | else |
| | |
| | | if (HReturn.Contains("\"IsSuccess\":false") == true) |
| | | { |
| | | sErrMsg = "生成直接调拨单失败!" + HReturn + sJson; |
| | | oCn.RollBack(); |
| | | //oCn.RollBack(); |
| | | return false; |
| | | } |
| | | else |
| | | { |
| | | oCn.Commit(); |
| | | //oCn.Commit(); |
| | | return true; |
| | | } |
| | | } |
| | | else |
| | | { |
| | | sErrMsg = "生成直接调拨单失败!登录失败!"; |
| | | oCn.RollBack(); |
| | | //oCn.RollBack(); |
| | | return false; |
| | | } |
| | | } |
| | |
| | | catch (Exception e) |
| | | { |
| | | sErrMsg = "生成直接调拨单失败!" + e.Message; |
| | | oCn.RollBack(); |
| | | //oCn.RollBack(); |
| | | return false; |
| | | } |
| | | } |
| | |
| | | //审核单据 |
| | | oCn.RunProc("Update Kf_ICStockBillMain Set HChecker='" + oMain.HMaker + "',HCheckDate=convert(varchar(10),getdate(),120) where HInterID= " + oMain.HInterID.ToString()); |
| | | } |
| | | |
| | | oCn.Commit(); |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | sErrMsg = "生成领料调拨单失败111!" + e.Message; |
| | | oCn.RollBack(); |
| | | return false; |
| | | } |
| | | try |
| | | { |
| | | //根据TMP表 返回 子表信息 |
| | | DataSet Ds; |
| | | Ds = oCn.RunProcReturn("exec h_p_Kf_GetMoveStockBill_MoveStockRequest_CLD_New " + oMain.HInterID.ToString() + ",'" + oMain.HBillNo + "'", "h_p_Kf_GetMoveStockBill_MoveStockRequest_CLD_New"); |
| | |
| | | } |
| | | else |
| | | { |
| | | string sJson_StockStyle = ""; |
| | | if (oSystemParameterMain.WMS_CampanyName == "韩电") //系统参数 客户定制化名称 空白为通用 |
| | | { |
| | | sJson_StockStyle = "\"F_CHLX\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["F_CHLX"]) + "\","; //出货类型 |
| | | } |
| | | else |
| | | { |
| | | sJson_StockStyle = ""; |
| | | } |
| | | string sJson_Main = "{\"Creator\":\"\",\"NeedUpDateFields\":[],\"NeedReturnFields\":[],\"IsDeleteEntry\":\"True\",\"SubSystemId\":\"\",\"IsVerifyBaseDataField\":\"false\"," + |
| | | "\"IsEntryBatchFill\":\"True\",\"ValidateFlag\":\"True\",\"NumberSearch\":\"True\",\"InterationFlags\":\"\"," + |
| | | "\"Model\":{ " + |
| | |
| | | //\"FThirdSystem\":\"\", |
| | | //\"FThirdSrcBillNo\":\"\", |
| | | //\"FThirdSrcId\":\"\", |
| | | sJson_StockStyle + |
| | | "\"FBillEntry\": [ "; |
| | | string sJson_Entry = ""; |
| | | for (int i = 0; i < Ds.Tables[1].Rows.Count; i++) |
| | |
| | | if (HReturn.Contains("\"IsSuccess\":false") == true) |
| | | { |
| | | sErrMsg = "生成直接调拨单失败!" + HReturn + sJson; |
| | | oCn.RollBack(); |
| | | //oCn.RollBack(); |
| | | return false; |
| | | } |
| | | else |
| | | { |
| | | oCn.Commit(); |
| | | //oCn.Commit(); |
| | | return true; |
| | | } |
| | | } |
| | | else |
| | | { |
| | | sErrMsg = "生成直接调拨单失败!登录失败!"; |
| | | oCn.RollBack(); |
| | | //oCn.RollBack(); |
| | | return false; |
| | | } |
| | | } |
| | |
| | | catch (Exception e) |
| | | { |
| | | sErrMsg = "生成直接调拨单失败!" + e.Message; |
| | | oCn.RollBack(); |
| | | //oCn.RollBack(); |
| | | return false; |
| | | } |
| | | } |