public bool DownInBillInfoAuto(string EmployeeCode) { bool tag = true; Employee = EmployeeCode; using (PersistentManager dbpm = new PersistentManager("YXConnection")) { DownInBillDao dao = new DownInBillDao(); dao.SetPersistentManager(dbpm); DataTable WmsInBillTable = this.GetInBillNo(); string inBillNoList = UtinString.StringMake(WmsInBillTable, "BILLNO"); inBillNoList = UtinString.StringMake(inBillNoList); inBillNoList = "ORDER_ID NOT IN(" + inBillNoList + ")"; DataTable masterdt = this.InBillMaster(inBillNoList); DataTable detaildt = this.InBillDetail(inBillNoList); DataRow[] masterdr = masterdt.Select("1=1"); DataRow[] detaildr = detaildt.Select("1=1"); if (masterdr.Length > 0 && detaildr.Length > 0) { DataSet detailds = this.InBillDetail(detaildr); DataSet masterds = this.InBillMaster(masterdr); this.Insert(masterds, detailds); } else { tag = false; } } return(tag); }
/// <summary> /// 根据日期下载入库数据 /// </summary> /// <param name="startDate"></param> /// <param name="endDate"></param> /// <returns></returns> public bool GetInBill(string startDate, string endDate, string EmployeeCode) { bool tag = true; Employee = EmployeeCode; using (PersistentManager pm = new PersistentManager()) { DownInBillDao dao = new DownInBillDao(); dao.SetPersistentManager(pm); DataTable inMasterBillNo = this.GetInBillNo(); string billnolist = UtinString.StringMake(inMasterBillNo, "BILLNO"); billnolist = UtinString.StringMake(billnolist); billnolist = string.Format("ORDER_DATE >='{0}' AND ORDER_DATE <='{1}' AND ORDER_ID NOT IN({2})", startDate, endDate, billnolist); DataTable masterdt = this.InBillMaster(billnolist); string inDetailList = UtinString.StringMake(masterdt, "ORDER_ID"); inDetailList = UtinString.StringMake(inDetailList); inDetailList = "ORDER_ID IN(" + inDetailList + ")"; DataTable detaildt = this.InBillDetail(inDetailList); DataRow[] masterdr = masterdt.Select("1=1"); DataRow[] detaildr = detaildt.Select("1=1"); if (masterdr.Length > 0 && detaildr.Length > 0) { DataSet detailds = this.InBillDetail(detaildr); DataSet masterds = this.InBillMaster(masterdr); this.Insert(masterds, detailds); } else { tag = false; } } return(tag); }
/// <summary> /// 查询数字仓储4天内入库单 /// </summary> /// <returns></returns> public DataTable GetInBillNo() { using (PersistentManager pm = new PersistentManager()) { DownInBillDao dao = new DownInBillDao(); return(dao.GetBillNo()); } }
/// <summary> /// 下载入库单明细表数据 /// </summary> /// <returns></returns> public DataTable InBillDetail(string inBillNoList) { using (PersistentManager dbpm = new PersistentManager("YXConnection")) { DownInBillDao dao = new DownInBillDao(); dao.SetPersistentManager(dbpm); return(dao.GetInBillDetail(inBillNoList)); } }
public string SelectIdList(string billNo) { using (PersistentManager pm = new PersistentManager()) { DownInBillDao dao = new DownInBillDao(); dao.SetPersistentManager(pm); return(dao.SelectIdList(billNo)); } }
public void DeleteDownReturnInBillInfo(string billNo) { using (PersistentManager pm = new PersistentManager()) { DownInBillDao dao = new DownInBillDao(); dao.SetPersistentManager(pm); dao.Delete(billNo); } }
public void UpdateReturnInBillState(string idList, string state) { using (PersistentManager pm = new PersistentManager("ServerConnection")) { DownInBillDao dao = new DownInBillDao(); dao.SetPersistentManager(pm); dao.UpdateReturnInBilLState(idList, state); } }
public void InsertReturnInBillDetail(DataSet ds) { using (PersistentManager pm = new PersistentManager()) { DownInBillDao dao = new DownInBillDao(); dao.SetPersistentManager(pm); dao.InsertInBillDetail(ds); } }
public DataTable ReturnInBillInfo() { using (PersistentManager pm = new PersistentManager()) { DownInBillDao dao = new DownInBillDao(); dao.SetPersistentManager(pm); return(dao.ReturnInBill()); } }
public void InsertReturnInBill(string idList, string billNo) { using (PersistentManager pm = new PersistentManager()) { DownInBillDao dao = new DownInBillDao(); dao.SetPersistentManager(pm); dao.Insert(billNo, idList); } }
public void InsertReturnInBillMaster(string billNo, string memo) { using (PersistentManager pm = new PersistentManager()) { DownInBillDao dao = new DownInBillDao(); dao.SetPersistentManager(pm); dao.InsertReturnInBillMaster(billNo, memo); } }
public int ReturnInBillCount() { using (PersistentManager pm = new PersistentManager("ServerConnection")) { DownInBillDao dao = new DownInBillDao(); dao.SetPersistentManager(pm); return(dao.ReturnInBillCount()); } }
/// <summary> /// 分页查询营销系统数据入库单据明细表 /// </summary> /// <param name="PrimaryKey"></param> /// <param name="papeIndex"></param> /// <param name="papeSize"></param> /// <param name="orderBy"></param> /// <param name="inBillNo"></param> /// <returns></returns> public DataTable GetInBillDetail(string PrimaryKey, int papeIndex, int papeSize, string orderBy, string inBillNo) { using (PersistentManager dbpm = new PersistentManager("YXConnection")) { DownInBillDao dao = new DownInBillDao(); dao.SetPersistentManager(dbpm); return(dao.GetInBillDetailByBillNo(inBillNo)); } }
/// <summary> /// 把查询的数据添加到仓储数据库 /// </summary> /// <param name="masterds"></param> /// <param name="detailds"></param> public void Insert(DataSet masterds, DataSet detailds) { using (PersistentManager pm = new PersistentManager()) { DownInBillDao dao = new DownInBillDao(); if (masterds.Tables["WMS_IN_BILLMASTER"].Rows.Count > 0) { dao.InsertInBillMaster(masterds); } if (detailds.Tables["WMS_IN_BILLDETAIL"].Rows.Count > 0) { dao.InsertInBillDetail(detailds); } } }
/// <summary> /// 分页查询营销系统数据入库单据主表 /// </summary> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <returns></returns> public DataTable GetInBillMaster(int pageIndex, int pageSize) { using (PersistentManager pm = new PersistentManager()) { using (PersistentManager dbpm = new PersistentManager("YXConnection")) { DownInBillDao masterdao = new DownInBillDao(); masterdao.SetPersistentManager(pm); DownInBillDao dao = new DownInBillDao(); dao.SetPersistentManager(dbpm); DataTable billnodt = masterdao.GetBillNo(); string billnolist = UtinString.StringMake(billnodt, "BILLNO"); billnolist = UtinString.StringMake(billnolist); return(dao.GetInBillMasterByBillNo(billnolist)); } } }
/// <summary> /// 下载入库主表 创联 /// </summary> /// <param name="startDate"></param> /// <param name="endDate"></param> /// <param name="EmployeeCode"></param> /// <param name="wareCode"></param> /// <param name="billtype"></param> /// <param name="errorInfo"></param> /// <returns></returns> public bool GetInBills(string startDate, string endDate, string EmployeeCode, string wareCode, string billtype, out string errorInfo) { bool tag = false; Employee = EmployeeCode; errorInfo = string.Empty; using (PersistentManager pm = new PersistentManager()) { try { DownInBillDao dao = new DownInBillDao(); DataTable emply = dao.FindEmployee(EmployeeCode); DataTable inMasterBillNo = this.GetInBillNo(); string billnolist = UtinString.StringMake(inMasterBillNo, "bill_no"); billnolist = UtinString.StringMake(billnolist); billnolist = string.Format("ORDER_DATE >='{0}' AND ORDER_DATE <='{1}' AND ORDER_ID NOT IN({2})", startDate, endDate, billnolist); DataTable masterdt = this.InBillMasters(billnolist); string inDetailList = UtinString.StringMake(masterdt, "ORDER_ID"); inDetailList = UtinString.StringMake(inDetailList); inDetailList = "ORDER_ID IN(" + inDetailList + ")"; DataTable detaildt = this.InBillDetail(inDetailList); if (masterdt.Rows.Count > 0 && detaildt.Rows.Count > 0) { DataSet masterds = this.InBillMaster(masterdt, emply.Rows[0]["employee_id"].ToString(), wareCode, billtype); DataSet detailds = this.InBillDetail(detaildt); this.Insert(masterds, detailds); tag = true; } else { errorInfo = "没有新的入库单下载!"; } } catch (Exception e) { errorInfo = "下载入库单失败!原因:" + e.Message; } } return(tag); }