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