|  |  | 
 |  |  | using System.Data; | 
 |  |  | using System.Linq; | 
 |  |  | using System.Web; | 
 |  |  | using Kingdee.BOS.WebApi.Client; | 
 |  |  | //using Kingdee.BOS.WebApi.Client; | 
 |  |  |  | 
 |  |  |  | 
 |  |  | namespace WebAPI | 
 |  |  | 
 |  |  |         } | 
 |  |  |         #endregion | 
 |  |  |  | 
 |  |  |  | 
 |  |  |         #region 一键扫码    入库模块 | 
 |  |  |  | 
 |  |  |         //一键扫码模式,根据条码前缀走 不同方法(仓库、仓位、部门)(源单、物料条码)    入库模块 | 
 |  |  |         public Model.ClsKf_ICStockBill_WMS get_CheckTypeByBarCode(string sBarCode, Int64 HBillID, string HBillType, string HBillNo, string HMaker, Int64 HWhID, Int64 HSPID, Double HQty, bool HRedBlueFlag, bool SourceFlag, string HSourceBillNo, string HSourceBillType, Int64 HOWNERID, ref string sErrMsg) | 
 |  |  |         public Model.ClsKf_ICStockBill_WMS get_CheckTypeByBarCode(string sBarCode, Int64 HBillID, string HBillType, string HBillNo, string HMaker, Int64 HWhID, Int64 HSPID, Double HQty, bool HRedBlueFlag, bool SourceFlag, string HSourceBillNo, string HSourceBillType, Int64 HOWNERID,Int64 HOrgID, ref string sErrMsg) | 
 |  |  |         { | 
 |  |  |             BLL.ClsKF_PonderationBillMain_Temp bll = new ClsKF_PonderationBillMain_Temp(); | 
 |  |  |             return bll.get_CheckTypeByBarCode(sBarCode, HBillID, HBillType, HBillNo, HMaker, HWhID, HSPID, HQty, HRedBlueFlag, SourceFlag, HSourceBillNo, HSourceBillType, HOWNERID, ref DBUtility.ClsPub.sExeReturnInfo); | 
 |  |  | 
 |  |  |  | 
 |  |  |         #endregion | 
 |  |  |  | 
 |  |  |  | 
 |  |  |         #region 外购退料    外购入库(红字)   * | 
 |  |  |  | 
 |  |  |         public bool set_SavePOStockInBackBill_New(WebAPI.WebS.ClsKf_ICStockBillMain oMain, string sHSourceType, ref string sErrMsg) | 
 |  |  | 
 |  |  |         public DataSet GetKf_ProductInBillList(string sWhere) | 
 |  |  |         { | 
 |  |  |             DAL.Cls_S_IF_ProductInBill_Lite dal = new DAL.Cls_S_IF_ProductInBill_Lite(); | 
 |  |  |             return dal.DisSourceBillList(sWhere); | 
 |  |  |         } | 
 |  |  |         public DataSet GetKf_MoveStockRequestBillList(string sWhere) | 
 |  |  |         { | 
 |  |  |             DAL.Cls_S_IF_MoveStockRequestBill_Lite dal = new DAL.Cls_S_IF_MoveStockRequestBill_Lite(); | 
 |  |  |             return dal.DisSourceBillList(sWhere); | 
 |  |  |         } | 
 |  |  |         #endregion | 
 |  |  | 
 |  |  |             //sErrMsg = "保存调拨单失败!" + sErrMsg; | 
 |  |  |             //return false; | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |         public bool set_MoveStockStepOutBill(WebAPI.WebS.ClsKf_MoveStockStepOutBillMain oMain, string sHSourceType, ref string sErrMsg) | 
 |  |  |         { | 
 |  |  |             WebS.WebService1 oWebs = new WebS.WebService1(); | 
 |  |  |             if (oWebs.set_SaveMoveStockStepOutBill_New(oMain, sHSourceType, ref sErrMsg)) | 
 |  |  |             { | 
 |  |  |                 sErrMsg = "保存成功!" + oMain.HBillNo; | 
 |  |  |                 return true; | 
 |  |  |             } | 
 |  |  |             else | 
 |  |  |             { | 
 |  |  |                 sErrMsg = "单据号:" + oMain.HBillNo + ", 单据ID:" + oMain.HInterID + ";" + sErrMsg; | 
 |  |  |                 return false; | 
 |  |  |             } | 
 |  |  |  | 
 |  |  |              | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |  | 
 |  |  |         //删除记录 | 
 |  |  |         public bool set_DelPonderationBillMain_Temp_InterIDAndSource(long HInterID, long HMaterID, long HAuxPropID, string HMTONo, long HSourceInterID, long HSourceEntryID, string sHBillType, ref string sErrMsg) | 
 |  |  |         { | 
 |  |  | 
 |  |  |  | 
 |  |  |  | 
 |  |  |         //返回缓存列表信息  同步资料 | 
 |  |  |         public DataSet GetKf_PonderationBillMain_TempList_New(string sHBillType, string sHMaker, Int64 sHOWNERID) | 
 |  |  |         { | 
 |  |  |             DAL.ClsKF_PonderationBillMain_Temp_View dal = new DAL.ClsKF_PonderationBillMain_Temp_View(); | 
 |  |  |             return dal.GetKf_PonderationBillMain_TempList_New(sHBillType, sHMaker, sHOWNERID); | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |  | 
 |  |  |         //返回缓存列表信息  同步资料 | 
 |  |  |         public DataSet GetKf_PonderationBillMain_TempList(string sHBillType, string sWhere) | 
 |  |  |         { | 
 |  |  |             DAL.ClsKF_PonderationBillMain_Temp_View dal = new DAL.ClsKF_PonderationBillMain_Temp_View(); | 
 |  |  |             return dal.GetKf_PonderationBillMain_TempList(sHBillType, sWhere); | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |  | 
 |  |  |  | 
 |  |  |  | 
 |  |  | 
 |  |  |                 return false; | 
 |  |  |             } | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |         public bool set_SaveICMOReportBill_Json(WebAPI.WebS.ClsSc_ICMOReportBillMain oMain, string sHSourceType, ref string sErrMsg) | 
 |  |  |         { | 
 |  |  |             //BLL.ClsKf_POStockInBill bll = new BLL.ClsKf_POStockInBill(); | 
 |  |  |             //return bll.set_SavePOStockInBill_New(oMain, sHSourceType, ref DBUtility.ClsPub.sExeReturnInfo); | 
 |  |  |             WebS.WebService1 oWebs = new WebS.WebService1(); | 
 |  |  |             if (oWebs.set_SaveICMOReportBill_New(oMain, sHSourceType, ref sErrMsg)) | 
 |  |  |             { | 
 |  |  |                 //判断是否反写成功 | 
 |  |  |                 //if (set_UpdateHStatus(oMain.HInterID, oMain.HExplanation.ToString())) | 
 |  |  |                 //{ | 
 |  |  |                     sErrMsg = "保存成功!" + oMain.HBillNo; | 
 |  |  |                     return true; | 
 |  |  |                 //} | 
 |  |  |                 //else | 
 |  |  |                 //{ | 
 |  |  |                 //    sErrMsg = "保存成功!" + oMain.HBillNo + "状态反写失败!"; | 
 |  |  |                 //    return true; | 
 |  |  |                 //} | 
 |  |  |             } | 
 |  |  |             else | 
 |  |  |             { | 
 |  |  |                 sErrMsg = "单据号:" + oMain.HBillNo + ", 单据ID:" + oMain.HInterID + ";" + sErrMsg; | 
 |  |  |                 return false; | 
 |  |  |             } | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |  | 
 |  |  |         /// <summary> | 
 |  |  |         /// 生成外购入库单K3 | 
 |  |  | 
 |  |  |             WebS.WebService1 oWebs = new WebS.WebService1(); | 
 |  |  |             if (oWebs.set_SaveProductInBill_New(oMain, sHSourceType, ref sErrMsg)) | 
 |  |  |             { | 
 |  |  |                 //判断是否反写成功 | 
 |  |  |                 if (set_UpdateHStatus(oMain.HInterID,oMain.HExplanation.ToString())) | 
 |  |  |                 { | 
 |  |  |                     sErrMsg = "保存成功!" + oMain.HBillNo; | 
 |  |  |                     return true; | 
 |  |  |                 } | 
 |  |  |                 else | 
 |  |  |                 { | 
 |  |  |                     sErrMsg = "保存成功!" + oMain.HBillNo + "状态反写失败!"; | 
 |  |  |                     return true; | 
 |  |  |                 } | 
 |  |  |                 ////判断是否反写成功 | 
 |  |  |                 //if (set_UpdateHStatus(oMain.HInterID,oMain.HExplanation.ToString())) | 
 |  |  |                 //{ | 
 |  |  |                 //    sErrMsg = "保存成功!" + oMain.HBillNo; | 
 |  |  |                 //    return true; | 
 |  |  |                 //} | 
 |  |  |                 //else | 
 |  |  |                 //{ | 
 |  |  |                 //    sErrMsg = "保存成功!" + oMain.HBillNo + "状态反写失败!"; | 
 |  |  |                 //    return true; | 
 |  |  |                 //} | 
 |  |  |                 sErrMsg = "保存成功!" + oMain.HBillNo; | 
 |  |  |                 return true; | 
 |  |  |             } | 
 |  |  |             else | 
 |  |  |             { | 
 |  |  | 
 |  |  |  | 
 |  |  |                      //生成 委外出库  | 
 |  |  |                      string HReturn; | 
 |  |  |                      ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl); | 
 |  |  |                      string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117 | 
 |  |  |                      bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052); | 
 |  |  |                      if (bLogin) | 
 |  |  |                      { | 
 |  |  |                          var result = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Save", | 
 |  |  |                          new object[] { "SUB_PickMtrl", sJson }); | 
 |  |  |                      //ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl); | 
 |  |  |                      //string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117 | 
 |  |  |                      //bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052); | 
 |  |  |                      //if (bLogin) | 
 |  |  |                      //{ | 
 |  |  |                      //    var result = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Save", | 
 |  |  |                      //    new object[] { "SUB_PickMtrl", sJson }); | 
 |  |  |  | 
 |  |  |                          if (oSystemParameterMain.Kf_EntrustOutBill_AutoCheck == "Y") //系统参数  自动审核  | 
 |  |  |                          { | 
 |  |  |                              string sJson2 = "{\"CreateOrgId\":0,\"Numbers\":[\"" + oMain.HBillNo + "\"]}"; | 
 |  |  |                              var result2 = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Submit", | 
 |  |  |                              new object[] { "SUB_PickMtrl", sJson2 }); | 
 |  |  |                      //    if (oSystemParameterMain.Kf_EntrustOutBill_AutoCheck == "Y") //系统参数  自动审核  | 
 |  |  |                      //    { | 
 |  |  |                      //        string sJson2 = "{\"CreateOrgId\":0,\"Numbers\":[\"" + oMain.HBillNo + "\"]}"; | 
 |  |  |                      //        var result2 = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Submit", | 
 |  |  |                      //        new object[] { "SUB_PickMtrl", sJson2 }); | 
 |  |  |  | 
 |  |  |                              string sJson3 = "{\"CreateOrgId\":0,\"Numbers\":[\"" + oMain.HBillNo + "\"]}"; | 
 |  |  |                              var result3 = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Audit", | 
 |  |  |                              new object[] { "SUB_PickMtrl", sJson3 }); | 
 |  |  |                      //        string sJson3 = "{\"CreateOrgId\":0,\"Numbers\":[\"" + oMain.HBillNo + "\"]}"; | 
 |  |  |                      //        var result3 = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Audit", | 
 |  |  |                      //        new object[] { "SUB_PickMtrl", sJson3 }); | 
 |  |  |  | 
 |  |  |                              HReturn = result.ToString() + "," + result2.ToString() + "," + result3.ToString(); | 
 |  |  |                          } | 
 |  |  |                          else | 
 |  |  |                          { | 
 |  |  |                              HReturn = result.ToString(); | 
 |  |  |                          } | 
 |  |  |                          if (HReturn.Contains("\"IsSuccess\":false") == true) | 
 |  |  |                          { | 
 |  |  |                              sErrMsg = "生成委外出库单失败!" + HReturn + sJson; | 
 |  |  |                              oCn.RollBack(); | 
 |  |  |                              return false; | 
 |  |  |                          } | 
 |  |  |                          else | 
 |  |  |                          { | 
 |  |  |                              oCn.Commit(); | 
 |  |  |                      //        HReturn = result.ToString() + "," + result2.ToString() + "," + result3.ToString(); | 
 |  |  |                      //    } | 
 |  |  |                      //    else | 
 |  |  |                      //    { | 
 |  |  |                      //        HReturn = result.ToString(); | 
 |  |  |                      //    } | 
 |  |  |                      //    if (HReturn.Contains("\"IsSuccess\":false") == true) | 
 |  |  |                      //    { | 
 |  |  |                      //        sErrMsg = "生成委外出库单失败!" + HReturn + sJson; | 
 |  |  |                      //        oCn.RollBack(); | 
 |  |  |                      //        return false; | 
 |  |  |                      //    } | 
 |  |  |                      //    else | 
 |  |  |                      //    { | 
 |  |  |                      //        oCn.Commit(); | 
 |  |  |                              return true; | 
 |  |  |                          } | 
 |  |  |                      } | 
 |  |  |                      else | 
 |  |  |                      { | 
 |  |  |                          sErrMsg = "生成委外出库单失败!登录失败!"; | 
 |  |  |                          oCn.RollBack(); | 
 |  |  |                          return false; | 
 |  |  |                      } | 
 |  |  |                          //} | 
 |  |  |                      //} | 
 |  |  |                      //else | 
 |  |  |                      //{ | 
 |  |  |                      //    sErrMsg = "生成委外出库单失败!登录失败!"; | 
 |  |  |                      //    oCn.RollBack(); | 
 |  |  |                      //    return false; | 
 |  |  |                      //} | 
 |  |  |                  } | 
 |  |  |              } | 
 |  |  |              catch (Exception e) | 
 |  |  | 
 |  |  |  | 
 |  |  |  | 
 |  |  |          //生成其他入库单  | 
 |  |  |          public bool set_SaveOtherInBill_New(Model.ClsKf_OtherInBillMain oMain, string sHSourceType, ref string sErrMsg) | 
 |  |  |          //public bool set_SaveOtherInBill_New(Model.ClsKf_OtherInBillMain oMain, string sHSourceType, ref string sErrMsg) | 
 |  |  |          //{ | 
 |  |  |          //    //获取系统参数 | 
 |  |  |          //    Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter(); | 
 |  |  |          //    if (oSystemParameter.ShowBill(ref sErrMsg) == false) | 
 |  |  |          //    { | 
 |  |  |          //        sErrMsg = "获取系统参数失败! " + sErrMsg; | 
 |  |  |          //        return false; | 
 |  |  |          //    } | 
 |  |  |          //    // | 
 |  |  |          //    if (oSystemParameter.omodel.Kf_OtherInBill_ERPMode.ToUpper() == "WISE") //判断同步模式是金蝶WISE | 
 |  |  |          //    { | 
 |  |  |          //        if (SaveOtherInBill_K3(oMain, sHSourceType, oSystemParameter.omodel, ref sErrMsg)) | 
 |  |  |          //        { | 
 |  |  |          //            //"保存成功!"; | 
 |  |  |          //            sErrMsg = "保存成功!" + oMain.HBillNo; | 
 |  |  |          //            return true; | 
 |  |  |          //        } | 
 |  |  |          //        else | 
 |  |  |          //        { | 
 |  |  |          //            //"保存失败!"; | 
 |  |  |          //            sErrMsg = sErrMsg; | 
 |  |  |          //            return false; | 
 |  |  |          //        } | 
 |  |  |          //    } | 
 |  |  |          //    if (oSystemParameter.omodel.Kf_OtherInBill_ERPMode.ToUpper() == "CLOUD")  //判断同步模式是金蝶CLOUD | 
 |  |  |          //    { | 
 |  |  |          //       ////上传前必填项判断 | 
 |  |  |          //       //if (oMain.HDeptID == 0) | 
 |  |  |          //       //{ | 
 |  |  |          //       //    sErrMsg = "部门没有选择!"; | 
 |  |  |          //       //    return false; | 
 |  |  |          //       //} | 
 |  |  |          //       //同步生成CLOUD单据 | 
 |  |  |          //       //if (SaveOtherInBill_CLD(oMain, sHSourceType, oSystemParameter.omodel, ref sErrMsg) == true) | 
 |  |  |          //       //{ | 
 |  |  |          //       //    //"保存成功!"; | 
 |  |  |          //       //    return true; | 
 |  |  |          //       //} | 
 |  |  |          //       //else | 
 |  |  |          //       //{ | 
 |  |  |          //       //    //"保存失败!"; | 
 |  |  |          //       //    return false; | 
 |  |  |          //       //} | 
 |  |  |          //   } | 
 |  |  |  | 
 |  |  |          //    sErrMsg = "保存其他入库单失败!" + sErrMsg; | 
 |  |  |          //    return false; | 
 |  |  |          //} | 
 |  |  |  | 
 |  |  |          public bool set_SaveOtherInBill_New(WebAPI.WebS.ClsKf_OtherInBillMain oMain, string sHSourceType,WebS.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg) | 
 |  |  |          { | 
 |  |  |              //获取系统参数 | 
 |  |  |              Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter(); | 
 |  |  |              if (oSystemParameter.ShowBill(ref sErrMsg) == false) | 
 |  |  |              { | 
 |  |  |                  sErrMsg = "获取系统参数失败! " + sErrMsg; | 
 |  |  |                  return false; | 
 |  |  |              } | 
 |  |  |              // | 
 |  |  |              if (oSystemParameter.omodel.Kf_OtherInBill_ERPMode.ToUpper() == "WISE") //判断同步模式是金蝶WISE | 
 |  |  |              { | 
 |  |  |                  if (SaveOtherInBill_K3(oMain, sHSourceType, oSystemParameter.omodel, ref sErrMsg)) | 
 |  |  |                  { | 
 |  |  |                      //"保存成功!"; | 
 |  |  |                      sErrMsg = "保存成功!" + oMain.HBillNo; | 
 |  |  |                      return true; | 
 |  |  |                  } | 
 |  |  |                  else | 
 |  |  |                  { | 
 |  |  |                      //"保存失败!"; | 
 |  |  |                      sErrMsg = sErrMsg; | 
 |  |  |                      return false; | 
 |  |  |                  } | 
 |  |  |              } | 
 |  |  |              if (oSystemParameter.omodel.Kf_OtherInBill_ERPMode.ToUpper() == "CLOUD")  //判断同步模式是金蝶CLOUD | 
 |  |  |              { | 
 |  |  |                  ////上传前必填项判断 | 
 |  |  |                  //if (oMain.HDeptID == 0) | 
 |  |  |                  //{ | 
 |  |  |                  //    sErrMsg = "部门没有选择!"; | 
 |  |  |                  //    return false; | 
 |  |  |                  //} | 
 |  |  |                  ////同步生成CLOUD单据 | 
 |  |  |                  //if (set_SaveOtherInBill_CLD(oMain, sHSourceType, oSystemParameter.omodel, ref sErrMsg) == true) | 
 |  |  |                  //{ | 
 |  |  |                  //    //"保存成功!"; | 
 |  |  |                  //    return true; | 
 |  |  |                  //} | 
 |  |  |                  //else | 
 |  |  |                  //{ | 
 |  |  |                  //    //"保存失败!"; | 
 |  |  |                      return false; | 
 |  |  |                  //} | 
 |  |  |              } | 
 |  |  |  | 
 |  |  |              sErrMsg = "保存其他入库单失败!" + sErrMsg; | 
 |  |  |              return false; | 
 |  |  |          } | 
 |  |  |             WebS.WebService1 oWebs = new WebS.WebService1();//set_SaveOtherInBill_CLD_New | 
 |  |  |             if (oWebs.set_SaveOtherInBill_CLD_New(oMain, sHSourceType,oSystemParameterMain,ref sErrMsg)) | 
 |  |  |             { | 
 |  |  |                 sErrMsg = "保存成功!" + oMain.HBillNo; | 
 |  |  |                 return true; | 
 |  |  |             } | 
 |  |  |             else | 
 |  |  |             { | 
 |  |  |                 sErrMsg = "单据号:" + oMain.HBillNo + ", 单据ID:" + oMain.HInterID + ";" + sErrMsg; | 
 |  |  |                 return false; | 
 |  |  |             } | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |  | 
 |  |  |          ///生成其他入库单 | 
 |  |  |          public bool set_SaveOtherInBill(Model.ClsKf_OtherInBillMain oMain, ref string sErrMsg) | 
 |  |  |         public bool SaveOtherInBill_CLD(Model.ClsKf_OtherInBillMain oMain, string sHSourceType, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg) | 
 |  |  |         { | 
 |  |  |             SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); | 
 |  |  |             try | 
 |  |  |             { | 
 |  |  |                 //判断会计期是否合理 | 
 |  |  |                 string s = ""; | 
 |  |  |                 int sYear = 0; | 
 |  |  |                 int sPeriod = 0; | 
 |  |  |                 if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(oMain.HDate, ref sYear, ref sPeriod, ref s) == false) | 
 |  |  |                 { | 
 |  |  |                     sErrMsg = s; | 
 |  |  |                     return false; | 
 |  |  |                 } | 
 |  |  |                 oMain.HYear = sYear; | 
 |  |  |                 oMain.HPeriod = sPeriod; | 
 |  |  |  | 
 |  |  |                 oCn.BeginTran(); | 
 |  |  |                 //生成出入库单据 | 
 |  |  |                 //插入子表 | 
 |  |  |                 oCn.RunProc("EXEC h_p_Kf_OtherInBillSub_Insert_New " + oMain.HInterID.ToString() + ",'" + oMain.HBillNo + "','" + sHSourceType + "'"); | 
 |  |  |                 //插入主表 | 
 |  |  |                 oCn.RunProc("Insert Into Kf_ICStockBillMain   " + | 
 |  |  |                 "(HBillType,HBillSubType,HInterID,HBillNo,HDate,HMainSourceBillType" + | 
 |  |  |                 ",HYear,HPeriod,HRemark,HMaker,HMakeDate" + | 
 |  |  |                 ",HSupID,HWHID,HSCWHID,HEmpID,HManagerID,HSecManagerID" + | 
 |  |  |                 ",HKeeperID,HDeptID,HExplanation,HInnerBillNo,HRedBlueFlag" + | 
 |  |  |                 ",HStockStyle" + | 
 |  |  |                 ",HSTOCKORGID,HOWNERID" + | 
 |  |  |                 ") " + | 
 |  |  |                 " values('1203','1203'," + oMain.HInterID.ToString() + ",'" + oMain.HBillNo + "',convert(varchar(10),getdate(),120),'" + oMain.HMainSourceBillType + "'" + | 
 |  |  |                 ", " + oMain.HYear.ToString() + "," + oMain.HPeriod.ToString() + ",'" + oMain.HRemark + "','" + oMain.HMaker + "',convert(varchar(10),getdate(),120)" + | 
 |  |  |                 ", " + oMain.HSupID.ToString() + "," + oMain.HWHID.ToString() + "," + oMain.HSCWHID.ToString() + "," + oMain.HEmpID.ToString() + "," + oMain.HManagerID.ToString() + "," + oMain.HSecManagerID.ToString() + | 
 |  |  |                 ", " + oMain.HKeeperID.ToString() + "," + oMain.HDeptID.ToString() + ",'" + oMain.HExplanation + "','" + oMain.HInnerBillNo + "'," + DBUtility.ClsPub.BoolToString(oMain.HRedBlueFlag) + | 
 |  |  |                 ",'" + oMain.HStockStyle + "'" + | 
 |  |  |                 ", " + oMain.HSTOCKORGID.ToString() + "," + oMain.HOWNERID.ToString() + | 
 |  |  |                 ") "); | 
 |  |  |                 //更新关联数量 | 
 |  |  |  | 
 |  |  |                 if (oSystemParameterMain.Kf_OtherInBill_AutoCheck == "Y") //系统参数  自动审核  | 
 |  |  |                 { | 
 |  |  |                     //审核单据 | 
 |  |  |                     oCn.RunProc("Update Kf_ICStockBillMain Set HChecker='" + oMain.HMaker + "',HCheckDate=convert(varchar(10),getdate(),120) where HInterID= " + oMain.HInterID.ToString()); | 
 |  |  |                 } | 
 |  |  |  | 
 |  |  |                 //根据TMP表 返回 子表信息 | 
 |  |  |                 DataSet Ds; | 
 |  |  |                 Ds = oCn.RunProcReturn("exec h_p_Kf_GetOtherInBill_CLD " + oMain.HInterID.ToString() + ",'" + oMain.HBillNo + "'", "h_p_Kf_GetOtherInBill_CLD"); | 
 |  |  |                 if (Ds == null || Ds.Tables[0].Rows.Count == 0 || Ds.Tables[1].Rows.Count == 0) | 
 |  |  |                 { | 
 |  |  |                     sErrMsg = "获取子表信息失败!"; | 
 |  |  |                     oCn.RollBack(); | 
 |  |  |                     return false; | 
 |  |  |                 } | 
 |  |  |                 else | 
 |  |  |                 { | 
 |  |  |                     string sJson_StockStyle = ""; | 
 |  |  |                     if (oSystemParameterMain.WMS_CampanyName == "韩电") //系统参数  客户定制化名称     空白为通用 | 
 |  |  |                     { | 
 |  |  |                         sJson_StockStyle = "\"F_RKLX\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["F_RKLX"]) + "\",";    //入库类型 | 
 |  |  |                     } | 
 |  |  |                     else if (oSystemParameterMain.WMS_CampanyName == "四维尔") //系统参数  客户定制化名称     空白为通用 | 
 |  |  |                     { | 
 |  |  |                         sJson_StockStyle = "\"F_ABCD_COMBO\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["F_ABCD_COMBO"]) + "\",";    //其他入库业务类型 | 
 |  |  |                     } | 
 |  |  |                     else | 
 |  |  |                     { | 
 |  |  |                         sJson_StockStyle = ""; | 
 |  |  |                     } | 
 |  |  |                     string sJson_Main = "{\"Creator\":\"\",\"NeedUpDateFields\":[],\"NeedReturnFields\":[],\"IsDeleteEntry\":\"True\",\"SubSystemId\":\"\",\"IsVerifyBaseDataField\":\"false\",\"IsEntryBatchFill\":\"True\",\"Model\":{\"FBillNo\":\"" + oMain.HBillNo + "\"," + | 
 |  |  |  | 
 |  |  |                         //\"FID\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FID"]) + "\"," + | 
 |  |  |                         "\"FBillTypeID\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FBillTypeID"]) + "\"}," + | 
 |  |  |                         "\"FStockOrgId\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FStockOrgId"]) + "\"}," + | 
 |  |  |                         "\"FStockDirect\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FStockDirect"]) + "\"," + | 
 |  |  |                         "\"FDate\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FDate"]) + "\"," + | 
 |  |  |                         //"\"FSUPPLIERID\":{\"FNumber\":\"" + oMain.HSupplyID.ToString() + "\"}," + | 
 |  |  |                         "\"FDEPTID\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FDEPTID"]) + "\"}," + | 
 |  |  |                         //"\"FSTOCKERID\":{\"FName\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FSTOCKERID"]) + "\"}," + | 
 |  |  |                         //"\"FSTOCKERGROUPID\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FSTOCKERGROUPID"]) + "\"}," + | 
 |  |  |                         "\"FOwnerTypeIdHead\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FOwnerTypeIdHead"]) + "\"," + | 
 |  |  |                         "\"FOwnerIdHead\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FOwnerIdHead"]) + "\"}," + | 
 |  |  |                         "\"FNOTE\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FNOTE"]) + "\"," + | 
 |  |  |                         "\"FBaseCurrId\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FBaseCurrId"]) + "\"}," + | 
 |  |  |                         "\"FScanBox\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FScanBox"]) + "\"," + | 
 |  |  |                         sJson_StockStyle + | 
 |  |  |                         "\"FEntity\":["; | 
 |  |  |                     string sJson_Entry = ""; | 
 |  |  |                     for (int i = 0; i < Ds.Tables[1].Rows.Count; i++) | 
 |  |  |                     { | 
 |  |  |                         if (sJson_Entry != "") | 
 |  |  |                         { | 
 |  |  |                             sJson_Entry = sJson_Entry + " , "; | 
 |  |  |                         } | 
 |  |  |                         string sJson_BatchNo = ""; | 
 |  |  |                         string sJson_StockPlace = ""; | 
 |  |  |                         string sJson_FAUXPROPID = ""; | 
 |  |  |                         if (Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["HISBATCHMANAGE"]) == "1") //是否启用批次管理 | 
 |  |  |                         { | 
 |  |  |                             sJson_BatchNo = "  \"FLOT\": {\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FLOT"]) + "\"},    \"FLOT_TEXT\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FLOT"]) + "\"  , "; | 
 |  |  |                         } | 
 |  |  |                         else | 
 |  |  |                         { | 
 |  |  |                             sJson_BatchNo = ""; | 
 |  |  |                         } | 
 |  |  |  | 
 |  |  |                         if (oSystemParameterMain.WMS_CampanyName == "卓力") //系统参数  客户定制化名称     空白为通用 | 
 |  |  |                         { | 
 |  |  |                             sJson_StockPlace = "\"FStockLocId\":{\"FSTOCKLOCID__FF100002\":{\"FNUMBER\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FStockLocId"]) + "\"}},"; | 
 |  |  |                         } | 
 |  |  |                         else | 
 |  |  |                         { | 
 |  |  |                             if (Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FStockLocId"]) == "") | 
 |  |  |                             { | 
 |  |  |                                 sJson_StockPlace = ""; | 
 |  |  |                             } | 
 |  |  |                             else | 
 |  |  |                             { | 
 |  |  |                                 sJson_StockPlace = Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FStockLocId"]) + "\"}},"; | 
 |  |  |                             } | 
 |  |  |                         } | 
 |  |  |                         //辅助属性 | 
 |  |  |                         if (oSystemParameterMain.WMS_CampanyName == "卓力" || oSystemParameterMain.WMS_CampanyName == "韩电") //系统参数  客户定制化名称     空白为通用 | 
 |  |  |                         { | 
 |  |  |                             sJson_FAUXPROPID = ""; | 
 |  |  |                         } | 
 |  |  |                         else | 
 |  |  |                         { | 
 |  |  |                             sJson_FAUXPROPID = " \"FAUXPROPID\":{\"FAUXPROPID__FF100002\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FAUXPROPID"]) + "\"}},"; | 
 |  |  |                         } | 
 |  |  |                         //自定义字段处理 | 
 |  |  |  | 
 |  |  |                         sJson_Entry = sJson_Entry + "{\"FEntryID\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FEntryID"]) + "\"," + | 
 |  |  |                             "\"FMATERIALID\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FMATERIALID"]) + "\"}," + | 
 |  |  |                             sJson_FAUXPROPID + | 
 |  |  |                             //"\"FAuxPropId\":{\"FAUXPROPID__FF100001\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FAuxPropId"]) + "\"}," + | 
 |  |  |                             //"\"FAUXPROPID__FF100030\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FAUXPROPID__FF100030"]) + "\"}," + | 
 |  |  |                             //"\"FAUXPROPID__FF100002\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FAUXPROPID__FF100002"]) + "\"}}," + | 
 |  |  |                             "\"FUnitID\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FUnitID"]) + "\"}," + | 
 |  |  |                             "\"FSTOCKSTATUSID\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FSTOCKSTATUSID"]) + "\"}," + | 
 |  |  |                             "\"FQty\":" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FQty"]) + "," + | 
 |  |  |                             "\"FBaseUnitId\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FBaseUnitId"]) + "\"}," + | 
 |  |  |                             "\"FSTOCKID\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FSTOCKID"]) + "\"}," + | 
 |  |  |                             sJson_StockPlace + | 
 |  |  |                             //"\"FStockLocId\":{\"FSTOCKLOCID__FF100002\":{\"FNUMBER\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FStockLocId"]) + "\"}}," + | 
 |  |  |                             //"\"FLOT\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FLOT"]) + "\"}," + | 
 |  |  |                             sJson_BatchNo + | 
 |  |  |                             "\"FEntryNote\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FEntryNote"]) + "\"," + | 
 |  |  |                             //"\"FBOMID\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FBOMID"]) + "\"}," + | 
 |  |  |                             //"\"FPRODUCEDATE\":" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FPRODUCEDATE"]) + "," + | 
 |  |  |                             //"\"FMTONO\":" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FMTONO"]) + "," + | 
 |  |  |                             "\"FExtAuxUnitId\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FExtAuxUnitId"]) + "\"}," + | 
 |  |  |                             //"\"FProjectNo\":" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FProjectNo"]) + "," + | 
 |  |  |                             "\"FExtAuxUnitQty\":" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FExtAuxUnitQty"]) + "," + | 
 |  |  |                             "\"FOWNERTYPEID\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FOWNERTYPEID"]) + "\"," + | 
 |  |  |                             "\"FOWNERID\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FOWNERID"]) + "\"}," + | 
 |  |  |                             "\"FKEEPERTYPEID\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FKEEPERTYPEID"]) + "\"," + | 
 |  |  |                             "\"FKEEPERID\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FKEEPERID"]) + "\"}} "; | 
 |  |  |                     } | 
 |  |  |                     //"\"FInStockEntry_Link_FSId\":" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FInStockEntry_Link_FSId"]) + | 
 |  |  |                     string sJson_End = "  ]  }}"; | 
 |  |  |                     string sJson = sJson_Main + sJson_Entry + sJson_End; | 
 |  |  |  | 
 |  |  |                     //从配置文件获取 CLOUD网址、账套信息、登录用户、登录密码 | 
 |  |  |                     if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo)) | 
 |  |  |                     { | 
 |  |  |                         sErrMsg = Pub_Class.ClsPub.sExeReturnInfo; | 
 |  |  |                         return false; | 
 |  |  |                     } | 
 |  |  |  | 
 |  |  |                     //获取CLOUD账号密码 | 
 |  |  |                     string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName; | 
 |  |  |                     string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd; | 
 |  |  |                     DataSet ds11 = get_SaveCLOUDUseNameandPsd(oMain.HInterID); | 
 |  |  |                     if (ds11 == null || ds11.Tables[0].Rows.Count == 0) | 
 |  |  |                     { | 
 |  |  |                     } | 
 |  |  |                     else | 
 |  |  |                     { | 
 |  |  |                         sCLOUDUseName = DBUtility.ClsPub.isStrNull(ds11.Tables[0].Rows[0]["HCloudUserName"]); | 
 |  |  |                         sCLOUDPsd = DBUtility.ClsPub.isStrNull(ds11.Tables[0].Rows[0]["HCloudUserPsd"]); | 
 |  |  |                     } | 
 |  |  |  | 
 |  |  |                     //生成 其他入库单 1个物料1单 | 
 |  |  |                     string HReturn; | 
 |  |  |                     //ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl); | 
 |  |  |                     //string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117 | 
 |  |  |                     //bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052); | 
 |  |  |                     //if (bLogin) | 
 |  |  |                     //{ | 
 |  |  |                     //    var result = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Save", | 
 |  |  |                     //    new object[] { "STK_MISCELLANEOUS", sJson }); | 
 |  |  |  | 
 |  |  |                     //    if (oSystemParameterMain.Kf_OtherInBill_AutoCheck == "Y") //系统参数  自动审核  | 
 |  |  |                     //    { | 
 |  |  |                     //        string sJson2 = "{\"CreateOrgId\":0,\"Numbers\":[\"" + oMain.HBillNo + "\"]}"; | 
 |  |  |                     //        var result2 = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Submit", | 
 |  |  |                     //        new object[] { "STK_MISCELLANEOUS", sJson2 }); | 
 |  |  |  | 
 |  |  |                     //        string sJson3 = "{\"CreateOrgId\":0,\"Numbers\":[\"" + oMain.HBillNo + "\"]}"; | 
 |  |  |                     //        var result3 = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Audit", | 
 |  |  |                     //        new object[] { "STK_MISCELLANEOUS", sJson3 }); | 
 |  |  |  | 
 |  |  |                     //        HReturn = result.ToString() + "," + result2.ToString() + "," + result3.ToString(); | 
 |  |  |                     //    } | 
 |  |  |                     //    else | 
 |  |  |                     //    { | 
 |  |  |                     //        HReturn = result.ToString(); | 
 |  |  |                     //    } | 
 |  |  |                     //    if (HReturn.Contains("\"IsSuccess\":false") == true) | 
 |  |  |                     //    { | 
 |  |  |                     //        sErrMsg = "其他入库单失败!" + HReturn + sJson; | 
 |  |  |                     //        oCn.RollBack(); | 
 |  |  |                             return false; | 
 |  |  |                         //} | 
 |  |  |                         //else | 
 |  |  |                         //{ | 
 |  |  |                         //    oCn.Commit(); | 
 |  |  |                         //    return true; | 
 |  |  |                         //} | 
 |  |  |                     //} | 
 |  |  |                     //else | 
 |  |  |                     //{ | 
 |  |  |                     //    sErrMsg = "其他入库单失败!登录失败!"; | 
 |  |  |                     //    oCn.RollBack(); | 
 |  |  |                     //    return false; | 
 |  |  |                     //} | 
 |  |  |                 } | 
 |  |  |             } | 
 |  |  |             catch (Exception e) | 
 |  |  |             { | 
 |  |  |                 sErrMsg = "其他入库单失败!" + e.Message; | 
 |  |  |                 oCn.RollBack(); | 
 |  |  |                 return false; | 
 |  |  |             } | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |         ///生成其他入库单 | 
 |  |  |         public bool set_SaveOtherInBill(Model.ClsKf_OtherInBillMain oMain, ref string sErrMsg) | 
 |  |  |          { | 
 |  |  |              //获取系统参数 | 
 |  |  |              Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter(); | 
 |  |  | 
 |  |  |  | 
 |  |  |  | 
 |  |  |          //生成其他出库单  | 
 |  |  |          public bool set_SaveOtherOutBill_New(Model.ClsKf_OtherOutBillMain oMain, string sHSourceType, ref string sErrMsg) | 
 |  |  |          public bool set_SaveOtherOutBill_New(WebAPI.WebS.ClsKf_OtherOutBillMain oMain, string sHSourceType, WebS.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg) | 
 |  |  |          { | 
 |  |  |              //获取系统参数 | 
 |  |  |              Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter(); | 
 |  |  |              if (oSystemParameter.ShowBill(ref sErrMsg) == false) | 
 |  |  |              { | 
 |  |  |                  sErrMsg = "获取系统参数失败! " + sErrMsg; | 
 |  |  |                  return false; | 
 |  |  |              } | 
 |  |  |              // | 
 |  |  |              if (oSystemParameter.omodel.Kf_OtherOutBill_ERPMode.ToUpper() == "WISE") //判断同步模式是金蝶WISE | 
 |  |  |              { | 
 |  |  |                  if (SaveOtherOutBill_K3(oMain, sHSourceType, oSystemParameter.omodel, ref sErrMsg)) | 
 |  |  |                  { | 
 |  |  |                      //"保存成功!"; | 
 |  |  |                      sErrMsg = "保存成功!" + oMain.HBillNo; | 
 |  |  |                      return true; | 
 |  |  |                  } | 
 |  |  |                  else | 
 |  |  |                  { | 
 |  |  |                      //"保存失败!"; | 
 |  |  |                      sErrMsg = sErrMsg; | 
 |  |  |                      return false; | 
 |  |  |                  } | 
 |  |  |              } | 
 |  |  |              if (oSystemParameter.omodel.Kf_OtherOutBill_ERPMode.ToUpper() == "CLOUD")  //判断同步模式是金蝶CLOUD | 
 |  |  |              { | 
 |  |  |                  //上传前必填项判断 | 
 |  |  |                  //if (oMain.HDeptID == 0) | 
 |  |  |                  //{ | 
 |  |  |                  //    sErrMsg = "部门没有选择!"; | 
 |  |  |                  //    return false; | 
 |  |  |                  //} | 
 |  |  |                  ////同步生成CLOUD单据 | 
 |  |  |                  //if (set_SaveOtherOutBill_CLD(oMain, sHSourceType, oSystemParameter.omodel, ref sErrMsg) == true) | 
 |  |  |                  //{ | 
 |  |  |                  //    //"保存成功!"; | 
 |  |  |                  //    return true; | 
 |  |  |                  //} | 
 |  |  |                  //else | 
 |  |  |                  //{ | 
 |  |  |                      //"保存失败!"; | 
 |  |  |                      return false; | 
 |  |  |                  //} | 
 |  |  |              } | 
 |  |  |  | 
 |  |  |              sErrMsg = "保存其他出库单失败!" + sErrMsg; | 
 |  |  |              return false; | 
 |  |  |          } | 
 |  |  |             WebS.WebService1 oWebs = new WebS.WebService1();//set_SaveOtherInBill_CLD_New | 
 |  |  |             if (oWebs.set_SaveOtherOutBill_CLD_New(oMain, sHSourceType, oSystemParameterMain, ref sErrMsg)) | 
 |  |  |             { | 
 |  |  |                 sErrMsg = "保存成功!" + oMain.HBillNo; | 
 |  |  |                 return true; | 
 |  |  |             } | 
 |  |  |             else | 
 |  |  |             { | 
 |  |  |                 sErrMsg = "单据号:" + oMain.HBillNo + ", 单据ID:" + oMain.HInterID + ";" + sErrMsg; | 
 |  |  |                 return false; | 
 |  |  |             } | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |  | 
 |  |  |  | 
 |  |  | 
 |  |  |          } | 
 |  |  |         #endregion | 
 |  |  |  | 
 |  |  |         #region [获取打印模板] | 
 |  |  |         /// <summary> | 
 |  |  |         /// 打印模板列表 | 
 |  |  |         /// </summary> | 
 |  |  |         /// <param name="sWhere"></param> | 
 |  |  |         /// <param name="sErr"></param> | 
 |  |  |         /// <returns></returns> | 
 |  |  |         public DataSet GetOpenTmpList(string sWhere, ref string sErr) | 
 |  |  |         { | 
 |  |  |             SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); | 
 |  |  |             DataSet ds = new DataSet(); | 
 |  |  |             ds = oCn.RunProcReturn("select * from h_v_IF_OpenTmpList " + sWhere, "h_v_IF_OpenTmpList"); | 
 |  |  |             return ds; | 
 |  |  |         } | 
 |  |  |         #endregion | 
 |  |  |  | 
 |  |  |         /// <summary> | 
 |  |  |         /// 返回扫码明细信息 | 
 |  |  |         /// </summary> | 
 |  |  |         public DataSet GetBarcodeList(long HInterID, string HBillNo, string sBillType, ref string sMouldManagerCtl, ref string sFIFOCtl, ref string sErrMsg) | 
 |  |  |         { | 
 |  |  |             DAL.ClsKF_PonderationBillMain_Temp_View bll = new DAL.ClsKF_PonderationBillMain_Temp_View(); | 
 |  |  |             return bll.GetBillEntry_TmpList(HInterID, HBillNo, sBillType, ref sMouldManagerCtl, ref sFIFOCtl, ref sErrMsg); | 
 |  |  |             //DAL.ClsKF_PonderationBillMain_Temp_View dal = new DAL.ClsKF_PonderationBillMain_Temp_View(); | 
 |  |  |             //return dal.GetInfoByID_View(HInterID, sBillType, sWhere); | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |         //撤销缓存列表选中数据 | 
 |  |  |         public bool RescindBillList(Int64 sHInterID, string sBillNo, string sBillType, ref string sErrMsg) | 
 |  |  |         { | 
 |  |  |             DAL.ClsKF_PonderationBillMain_Temp_Ctl dal = new DAL.ClsKF_PonderationBillMain_Temp_Ctl(); | 
 |  |  |             if (dal.DeleteICStockBillAndWMS(sHInterID, sBillNo, sBillType, ref sErrMsg)) | 
 |  |  |             { | 
 |  |  |                 sErrMsg = "删除成功!"; | 
 |  |  |                 return true; | 
 |  |  |             } | 
 |  |  |             else | 
 |  |  |             { | 
 |  |  |                 sErrMsg = "删除失败!"; | 
 |  |  |                 return false; | 
 |  |  |             } | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |         //返回缓存列表已上传列表信息 | 
 |  |  |         public DataSet GetDisBillUpdateLoad_Json(string sHBillType, string HMaker, Int64 HOrgID) | 
 |  |  |         { | 
 |  |  |             DAL.ClsKF_PonderationBillMain_Temp_View dal = new DAL.ClsKF_PonderationBillMain_Temp_View(); | 
 |  |  |             return dal.GetKf_ICStockBillList(sHBillType, HMaker, HOrgID); | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |     } | 
 |  |  | } |