/// <summary> /// 查询仓库入库单据细表上报 /// </summary> public string FindInDetailBill() { string tag = "上报仓库入库单据细表成功!"; using (PersistentManager dbpm = new PersistentManager("ZYDB2Connection")) { UploadDao dao = new UploadDao(); dao.SetPersistentManager(dbpm); DataTable inDetailTable = this.QueryInDetailBill(); if (inDetailTable.Rows.Count > 0) { try { dbpm.BeginTransaction(); dao.InsertInDetailBill(inDetailTable); this.UpdateInDetail(""); dbpm.Commit(); } catch (Exception exp) { dbpm.Rollback(); throw new Exception(exp.Message); } } else { tag = "没有新的仓库入库细表信息要上报!"; } } return(tag); }
//入库细表 public void InsertInDetailBill(DataSet busiStock) { using (PersistentManager pm = new PersistentManager("ZYDB2Connection")) { UploadDao dao = new UploadDao(); dao.SetPersistentManager(pm); dao.InsertInDetailBill(busiStock); } }