|  |  | 
 |  |  |             //DAL.ClsIF_Department_View dal = new DAL.ClsIF_Department_View(); | 
 |  |  |             //return dal.GetList(sWhere); | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |         /// <summary> | 
 |  |  |         /// 获取物料列表 | 
 |  |  |         /// </summary> | 
 |  |  |         /// <param name="sWhere"></param> | 
 |  |  |         /// <param name="sErr"></param> | 
 |  |  |         /// <returns></returns> | 
 |  |  |         public DataSet GetMaterialList(string sWhere, ref string sErr) | 
 |  |  |         { | 
 |  |  |             BLL.ClsIF_Material_View bll = new BLL.ClsIF_Material_View(); | 
 |  |  |             return bll.GetList(sWhere, ref DBUtility.ClsPub.sExeReturnInfo); | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |         //ClsGy_Unit_View | 
 |  |  |         /// <summary> | 
 |  |  |         /// 获取单位列表 | 
 |  |  |         /// </summary> | 
 |  |  |         /// <param name="sWhere"></param> | 
 |  |  |         /// <param name="sErr"></param> | 
 |  |  |         /// <returns></returns> | 
 |  |  |         public DataSet GetUnitList(string sWhere, ref string sErr) | 
 |  |  |         { | 
 |  |  |  | 
 |  |  |             DAL.ClsGy_Unit_View dal = new DAL.ClsGy_Unit_View(); | 
 |  |  |             return dal.GetList(sWhere); | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |  | 
 |  |  |         /// <summary> | 
 |  |  |         /// 职员列表 | 
 |  |  |         /// </summary> | 
 |  |  | 
 |  |  |             WebS.WebService1 oWebs = new WebS.WebService1(); | 
 |  |  |             if (oWebs.set_SavePOStockInBill_New(oMain, sHSourceType, ref sErrMsg)) | 
 |  |  |             { | 
 |  |  |                 sErrMsg = "保存成功!" + oMain.HBillNo; | 
 |  |  |                 return true; | 
 |  |  |                 //判断是否反写成功 | 
 |  |  |                 if (set_UpdateHStatus(oMain.HInterID, oMain.HExplanation.ToString())) | 
 |  |  |                 { | 
 |  |  |                     sErrMsg = "保存成功!" + oMain.HBillNo; | 
 |  |  |                     return true; | 
 |  |  |                 } | 
 |  |  |                 else | 
 |  |  |                 { | 
 |  |  |                     sErrMsg = "保存成功!" + oMain.HBillNo + "状态反写失败!"; | 
 |  |  |                     return true; | 
 |  |  |                 } | 
 |  |  |             } | 
 |  |  |             else | 
 |  |  |             { | 
 |  |  | 
 |  |  |             WebS.WebService1 oWebs = new WebS.WebService1(); | 
 |  |  |             if (oWebs.set_SaveProductInBill_New(oMain, sHSourceType, ref sErrMsg)) | 
 |  |  |             { | 
 |  |  |                 sErrMsg = "保存成功!" + oMain.HBillNo; | 
 |  |  |                 return true; | 
 |  |  |                 //判断是否反写成功 | 
 |  |  |                 if (set_UpdateHStatus(oMain.HInterID,oMain.HExplanation.ToString())) | 
 |  |  |                 { | 
 |  |  |                     sErrMsg = "保存成功!" + oMain.HBillNo; | 
 |  |  |                     return true; | 
 |  |  |                 } | 
 |  |  |                 else | 
 |  |  |                 { | 
 |  |  |                     sErrMsg = "保存成功!" + oMain.HBillNo + "状态反写失败!"; | 
 |  |  |                     return true; | 
 |  |  |                 } | 
 |  |  |             } | 
 |  |  |             else | 
 |  |  |             { | 
 |  |  | 
 |  |  |             } | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |         //根据id反写条码档案表状态 | 
 |  |  |         public bool set_UpdateHStatus(long HinterID, string HMESSPName) | 
 |  |  |         { | 
 |  |  |             try | 
 |  |  |             { | 
 |  |  |                 new SQLHelper.ClsCN().RunProcReturn("EXEC h_p_WMS_UpdateMESSPtoBarCode " + HinterID + "," + "'" + HMESSPName + "'", "h_p_WMS_UpdateMESSPtoBarCode"); | 
 |  |  |                 return true; | 
 |  |  |             } | 
 |  |  |             catch (Exception ex) | 
 |  |  |             { | 
 |  |  |                 return false; | 
 |  |  |             } | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |          /// <summary> | 
 |  |  |          /// 生成产品入库单 | 
 |  |  |          /// </summary> | 
 |  |  |          /// <param name="oMain"></param> | 
 |  |  |          /// <param name="sHSourceType"></param> | 
 |  |  |          /// <param name="sErrMsg"></param> | 
 |  |  |          /// <returns></returns> | 
 |  |  |          public bool set_SaveProductInBill(Model.ClsKf_ProductInBillMain oMain, ref string sErrMsg) | 
 |  |  |  | 
 |  |  |         /// <summary> | 
 |  |  |         /// 生成产品入库单 | 
 |  |  |         /// </summary> | 
 |  |  |         /// <param name="oMain"></param> | 
 |  |  |         /// <param name="sHSourceType"></param> | 
 |  |  |         /// <param name="sErrMsg"></param> | 
 |  |  |         /// <returns></returns> | 
 |  |  |         public bool set_SaveProductInBill(Model.ClsKf_ProductInBillMain oMain, ref string sErrMsg) | 
 |  |  |          { | 
 |  |  |              DAL.ClsKf_ProductInBill dal = new DAL.ClsKf_ProductInBill(); | 
 |  |  |              dal.omodel = oMain; | 
 |  |  | 
 |  |  |              DAL.Cls_S_IF_SellOutBill_Lite dal = new DAL.Cls_S_IF_SellOutBill_Lite(); | 
 |  |  |              return dal.DisSourceBillList(sWhere); | 
 |  |  |          } | 
 |  |  |          #endregion | 
 |  |  |  | 
 |  |  |  | 
 |  |  |         | 
 |  |  |         #endregion | 
 |  |  |  | 
 |  |  |         #region   委外入库 | 
 |  |  |  | 
 |  |  |  | 
 |  |  |          /// <summary> | 
 |  |  |          /// 生成委外入库单K3 | 
 |  |  |          /// </summary> | 
 |  |  |          /// <param name="oMain"></param> | 
 |  |  |          /// <param name="sErrMsg"></param> | 
 |  |  |          /// <returns></returns> | 
 |  |  |          public bool SaveEntrustInBill_K3(Model.ClsKf_EntrustInBillMain oMain, string sHSourceType, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg) | 
 |  |  |         /// <summary> | 
 |  |  |         /// 生成委外入库单K3 | 
 |  |  |         /// </summary> | 
 |  |  |         /// <param name="oMain"></param> | 
 |  |  |         /// <param name="sErrMsg"></param> | 
 |  |  |         /// <returns></returns> | 
 |  |  |         public bool SaveEntrustInBill_K3(Model.ClsKf_EntrustInBillMain oMain, string sHSourceType, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg) | 
 |  |  |          { | 
 |  |  |              SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); | 
 |  |  |              DAL.ClsKf_EntrustInBill dal = new DAL.ClsKf_EntrustInBill(); | 
 |  |  | 
 |  |  |              WebS.WebService1 oWebs = new WebS.WebService1(); | 
 |  |  |              if (oWebs.set_SaveEntrustInBill_New(oMain, sHSourceType, ref sErrMsg)) | 
 |  |  |              { | 
 |  |  |                  sErrMsg = "保存成功!" + oMain.HBillNo; | 
 |  |  |                  return true; | 
 |  |  |              } | 
 |  |  |                 //判断是否反写成功 | 
 |  |  |                 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; |