/// <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);
}
}
