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