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