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