/// <summary>
/// 获取库存信息统计
/// </summary>
/// <param name="Btime"></param>
/// <param name="Etime"></param>
/// <returns></returns>
public PageResult GetBinStore(DateTime Btime, DateTime Etime)
{
var transaction = TransactionServiceFatory.CreateInstance <ITransactionService>();
try
{
var procService = ProcedureServiceFactory.CreateInstance <IProcGetBinstoreService>();
transaction.BeginTransaction();
var para = new ProcGetBinstore();
para.IBtime = Btime;
para.IEdate = Etime;
procService.ExcuteProcedure(para);
transaction.CompleteTransaction();
var pageResult = new PageResult();
var stmtId = "GetZ30BinStore";
pageResult.StatementId = stmtId;
return(this.GetPageDataByReader(pageResult));
}
catch (Exception ex)
{
transaction.RollbackTransaction();
return(null);
}
}
/// <summary>
/// PROC_GET_BINSTORE 执行存储过程
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public ProcGetBinstore ExcuteProcedure(ProcGetBinstore param)
{
var result = this.GetDataSetByStatement("PROC_GET_BINSTORE", param);
param.ProcedureDataSetResult = result;
var idx = 0;
if (result.Tables.Count > idx + 1)
{
param.OCurtable = result.Tables[idx];
}
idx++;
return(param);
}
