| | |
| | | } |
| | | } |
| | | |
| | | //根据托条码 获取条码档案列表唯一码信息 |
| | | public DataSet GetBarCode(string HBarCode) |
| | | { |
| | | SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); |
| | | // |
| | | try |
| | | { |
| | | DataSet DS = oCn.RunProcReturn("select HBarCode,HQty from Sc_PackUnionBillSub where HBarCode_Pack ='" + HBarCode.ToString() + "'", "Sc_PackUnionBillSub", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //DataSet DS = oCn.RunProcReturn("Select * from h_v_Sc_AssemblyBill Where HInterID=" + HInterID.ToString() + " and HBillType='" + sBillType + "' " + sWhere, "h_v_Sc_AssemblyBill", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | if (DS.Tables[0].Rows.Count == 0) |
| | | return null; |
| | | else |
| | | { |
| | | return DS; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | throw (e); |
| | | } |
| | | } |
| | | |
| | | public DataSet GetHBW(long HBadType) |
| | | { |
| | | SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); |
| | |
| | | return dal.GetKf_ICStockBillList(sHBillType, HMaker, HOrgID); |
| | | } |
| | | |
| | | //返回缓存列表查询已上传列表信息 |
| | | public DataSet GetQueryBillUpdateLoad_Json(string BillType, string HBillNo, string HSourceBillNo) |
| | | { |
| | | DAL.ClsKF_PonderationBillMain_Temp_View dal = new DAL.ClsKF_PonderationBillMain_Temp_View(); |
| | | return dal.GetKf_ICStockBillQueryList(BillType, HBillNo, HSourceBillNo); |
| | | } |
| | | |
| | | } |
| | | } |