//报关审核生效 流水操作:写入 流水类型:报关 流水状态:已生效 库存操作:更新 库存状态:预报关库存 public ResultModel Audit(UserModel user, NFMT.WorkFlow.Model.DataSource dataSource, bool isPass) { ResultModel result = new ResultModel(); try { using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required)) { result = this.customsclearanceDAL.Get(user, dataSource.RowId); if (result.ResultStatus != 0) return result; Model.CustomsClearance customsClearance = result.ReturnValue as Model.CustomsClearance; if (customsClearance == null || customsClearance.CustomsId <= 0) { result.ResultStatus = -1; result.Message = "报关不存在"; return result; } //审核,修改数据状态 result = this.customsclearanceDAL.Audit(user, customsClearance, isPass); if (result.ResultStatus != 0) return result; //审核通过 if (isPass) { //加载已生效明细 DAL.CustomsDetailDAL customsDetailDAL = new CustomsDetailDAL(); result = customsDetailDAL.Load(user, customsClearance.CustomsId, StatusEnum.已生效); if (result.ResultStatus != 0) return result; List<Model.CustomsDetail> details = result.ReturnValue as List<Model.CustomsDetail>; if (details == null || !details.Any()) { result.ResultStatus = -1; result.Message = "获取失败"; return result; } DAL.StockDAL stockDAL = new StockDAL(); DAL.StockNameDAL stockNameDAL = new StockNameDAL(); DAL.StockLogDAL stockLogDAL = new StockLogDAL(); Model.Stock stock = null; Model.StockName stockName = null; Model.StockLog stockLog = null; foreach (Model.CustomsDetail detail in details) { //获取库存 result = stockDAL.Get(user, detail.StockId); if (result.ResultStatus != 0) return result; stock = result.ReturnValue as Model.Stock; if (stock == null) { result.ResultStatus = -1; result.Message = "获取库存失败"; return result; } //获取业务单号 result = stockNameDAL.Get(user, stock.StockNameId); if (result.ResultStatus != 0) return result; stockName = result.ReturnValue as Model.StockName; if (stockName == null) { result.ResultStatus = -1; result.Message = "获取业务单号失败"; return result; } //创建库存流水 stockLog = new StockLog() { StockId = stock.StockId, StockNameId = stock.StockNameId, RefNo = stockName.RefNo, LogDirection = (int)LogDirectionEnum.Out, LogType = (int)LogTypeEnum.报关, //ContractId = //SubContractId = LogDate = DateTime.Now, OpPerson = user.EmpId, Bundles = stock.Bundles, GrossAmount = stock.GrossAmount, NetAmount = stock.NetAmount, MUId = stock.UintId, BrandId = stock.BrandId, DeliverPlaceId = stock.DeliverPlaceId, PaperNo = stock.PaperNo, PaperHolder = stock.PaperHolder, CardNo = stock.CardNo, Memo = stock.Memo, LogStatus = StatusEnum.已生效, LogSourceBase = "NFMT", LogSource = "dbo.St_CustomsClearance", SourceId = customsClearance.CustomsId }; result = stockLogDAL.Insert(user, stockLog); if (result.ResultStatus != 0) return result; int stockLogId = 0; if (result.ReturnValue == null || !int.TryParse(result.ReturnValue.ToString(), out stockLogId) || stockLogId <= 0) { result.ResultStatus = -1; result.Message = "流水添加失败"; return result; } //将库存流水Id反向更新到明细表中 detail.StockLogId = stockLogId; result = customsDetailDAL.Update(user, detail); if (result.ResultStatus != 0) return result; //更新库存状态 result = stockDAL.UpdateStockStatus(stock, StockStatusEnum.预报关库存); if (result.ResultStatus != 0) return result; } } scope.Complete(); } } catch (Exception e) { result.Message = e.Message; result.ResultStatus = -1; } return result; }
public ResultModel Audit(UserModel user, NFMT.WorkFlow.Model.DataSource dataSource, bool isPass) { ResultModel result = new ResultModel(); try { DAL.StockDAL stockDAL = new StockDAL(); NFMT.WareHouse.DAL.StockNameDAL stockNameDAL = new StockNameDAL(); DAL.ContractStockInDAL contractStockInDAL = new ContractStockInDAL(); using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required)) { result = this.stockinDAL.Get(user, dataSource.RowId); if (result.ResultStatus != 0) return result; Model.StockIn stockIn = result.ReturnValue as Model.StockIn; if (stockIn == null || stockIn.StockInId <= 0) { result.ResultStatus = -1; result.Message = "入库登记不存在"; return result; } //审核,修改数据状态 result = this.stockinDAL.Audit(user, stockIn, isPass); if (result.ResultStatus != 0) return result; //审核通过 if (isPass) { //写入St_StockName表 result = stockNameDAL.Insert(user, new Model.StockName() { RefNo = stockIn.RefNo }); if (result.ResultStatus != 0) return result; int stockNameId = 0; if (result.ReturnValue == null || !int.TryParse(result.ReturnValue.ToString(), out stockNameId) || stockNameId <= 0) { result.ResultStatus = -1; result.Message = "写库存失败"; return result; } //写入St_Stock库存表 result = stockDAL.Insert(user, new Model.Stock() { StockNameId = stockNameId, StockDate = stockIn.StockInDate, AssetId = stockIn.AssetId, Bundles = stockIn.Bundles, GrossAmount = stockIn.GrossAmount, NetAmount = stockIn.NetAmount, ReceiptInGap = 0, ReceiptOutGap = 0, CurGrossAmount = stockIn.GrossAmount, CurNetAmount = stockIn.NetAmount, UintId = stockIn.UintId, DeliverPlaceId = stockIn.DeliverPlaceId, BrandId = stockIn.BrandId, CustomsType = stockIn.CustomType, GroupId = stockIn.GroupId, CorpId = stockIn.CorpId, DeptId = stockIn.DeptId, ProducerId = stockIn.ProducerId, PaperNo = stockIn.PaperNo, PaperHolder = stockIn.PaperHolder, PreStatus = StockStatusEnum.预入库存, StockStatus = StockStatusEnum.预入库存, CardNo = stockIn.CardNo, Memo = string.Empty, StockType = stockIn.StockType, OriginPlaceId = stockIn.OriginPlaceId, OriginPlace = stockIn.OriginPlace, Format = stockIn.Format }); if (result.ResultStatus != 0) return result; int stockId = 0; if (result.ReturnValue == null || !int.TryParse(result.ReturnValue.ToString(), out stockId) || stockId <= 0) { result.ResultStatus = -1; result.Message = "写库存失败"; return result; } int contractId = 0, subId = 0; //获取合约关联 result = contractStockInDAL.GetByStockInId(user, stockIn.StockInId); if (result.ResultStatus == 0) { Model.ContractStockIn contractStockIn = result.ReturnValue as Model.ContractStockIn; if (contractStockIn != null && contractStockIn.RefId > 0) { contractId = contractStockIn.ContractId; subId = contractStockIn.ContractSubId; } } //创建stockLog对象 NFMT.WareHouse.Model.StockLog stockLog = new StockLog() { StockId = stockId, StockNameId = stockNameId, RefNo = stockIn.RefNo, LogDirection = (int)LogDirectionEnum.In, LogType = (int)LogTypeEnum.入库, ContractId = contractId, SubContractId = subId, LogDate = DateTime.Now, OpPerson = user.EmpId, Bundles = stockIn.Bundles, GrossAmount = stockIn.GrossAmount, NetAmount = stockIn.NetAmount, MUId = stockIn.UintId, BrandId = stockIn.BrandId, DeliverPlaceId = stockIn.DeliverPlaceId, PaperNo = stockIn.PaperNo, PaperHolder = stockIn.PaperHolder, CardNo = stockIn.CardNo, Memo = string.Empty, LogStatus = StatusEnum.已生效, LogSourceBase = "NFMT", LogSource = "dbo.St_StockIn", SourceId = stockIn.StockInId, AssetId = stockIn.AssetId, CorpId = stockIn.CorpId, CustomsType = stockIn.CustomType, DeptId = stockIn.DeptId, ProducerId = stockIn.ProducerId, StockType = stockIn.StockType, OriginPlaceId = stockIn.OriginPlaceId, OriginPlace = stockIn.OriginPlace, Format = stockIn.Format }; DAL.StockLogDAL stockLogDAL = new StockLogDAL(); result = stockLogDAL.Insert(user, stockLog); if (result.ResultStatus != 0) return result; int stockLogId = 0; if (result.ReturnValue == null || !int.TryParse(result.ReturnValue.ToString(), out stockLogId) || stockLogId == 0) { result.ResultStatus = -1; result.Message = "流水添加失败"; return result; } //写入库登记库存关联表 DAL.StockInStockDAL stockInStockDAL = new StockInStockDAL(); result = stockInStockDAL.Insert(user, new Model.StockInStock() { StockInId = stockIn.StockInId, StockId = stockId, StockLogId = stockLogId, RefStatus = StatusEnum.已生效 }); if (result.ResultStatus != 0) return result; } scope.Complete(); } } catch (Exception ex) { result.ResultStatus = -1; result.Message = ex.Message; return result; } return result; }
/// <summary> /// 数据撤返 /// </summary> /// <param name="user">当前操作用户</param> /// <param name="pledge">Pledge对象</param> /// <returns></returns> public ResultModel GoBack(UserModel user, int pledgeId) { ResultModel result = new ResultModel(); try { using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required)) { result = this.Get(user, pledgeId); if (result.ResultStatus != 0) return result; Model.Pledge pledge = result.ReturnValue as Pledge; if (pledge == null) { result.ResultStatus = -1; result.Message = "该数据不存在,不能撤返"; return result; } if (pledge.Status != StatusEnum.待审核 && pledge.Status != StatusEnum.已生效) { result.ResultStatus = -1; result.Message = "非待审核或已生效状态的数据不允许撤返"; return result; } //获取质押申请实体 DAL.PledgeApplyDAL pledgeApplyDAL = new PledgeApplyDAL(); result = pledgeApplyDAL.Get(user, pledge.PledgeApplyId); if (result.ResultStatus != 0) return result; Model.PledgeApply pledgeApply = result.ReturnValue as Model.PledgeApply; //获取申请实体 NFMT.Operate.DAL.ApplyDAL applyDAl = new Operate.DAL.ApplyDAL(); result = applyDAl.Get(user, pledgeApply.ApplyId); if (result.ResultStatus != 0) return result; NFMT.Operate.Model.Apply apply = result.ReturnValue as NFMT.Operate.Model.Apply; if (apply.Status == Common.StatusEnum.已关闭 || apply.Status == Common.StatusEnum.已完成) { result.ResultStatus = -1; result.Message = "质押对应的申请已完成或已关闭,不能进行撤返操作"; return result; } result = pledgeDAL.Goback(user, pledge); if (result.ResultStatus != 0) return result; if (pledge.Status == StatusEnum.待审核) { //同步工作流状态 NFMT.WorkFlow.BLL.DataSourceBLL dataSourceBLL = new WorkFlow.BLL.DataSourceBLL(); result = dataSourceBLL.SynchronousStatus(user, pledge); if (result.ResultStatus != 0) return result; } NFMT.WareHouse.DAL.PledgeDetialDAL pledgeDetialDAL = new DAL.PledgeDetialDAL(); result = pledgeDetialDAL.GetStockId(user, pledgeId); if (result.ResultStatus != 0) return result; if (!string.IsNullOrEmpty(result.ReturnValue.ToString())) { NFMT.WareHouse.DAL.StockDAL stockDAL = new StockDAL(); NFMT.WareHouse.DAL.StockNameDAL stockNameDAL = new StockNameDAL(); NFMT.WareHouse.DAL.StockLogDAL stockLogDAL = new StockLogDAL(); NFMT.WareHouse.Model.StockName stockName = new StockName(); NFMT.WareHouse.Model.Stock stock = new Stock(); NFMT.WareHouse.Model.StockLog stockLog = new StockLog(); foreach (string s in result.ReturnValue.ToString().Split(',')) { result = stockDAL.Get(user, Convert.ToInt32(s)); if (result.ResultStatus != 0) return result; stock = result.ReturnValue as Model.Stock; result = stockNameDAL.Get(user, stock.StockNameId); if (result.ResultStatus != 0) return result; stockName = result.ReturnValue as Model.StockName; ////创建stockLog对象 //stockLog = new StockLog() //{ // StockId = stock.StockId, // StockNameId = stock.StockNameId, // RefNo = stockName.RefNo, // //LogDirection = // LogType = LogEnum.质押冲销, // //ContractId = , // //SubContractId = , // LogDate = DateTime.Now, // OpPerson = user.EmpId, // Bundles = stock.Bundles, // GrossAmount = stock.GrossAmount, // NetAmount = stock.NetAmount, // MUId = stock.UintId, // BrandId = stock.BrandId, // DeliverPlaceId = stock.DeliverPlaceId, // PaperNo = stock.PaperNo, // PaperHolder = stock.PaperHolder, // CardNo = stock.CardNo, // Memo = stock.Memo, // LogStatus = StatusEnum.已生效, // LogSourceBase = "NFMT", // LogSource = "dbo.St_Pledge", // SourceId = pledgeId //}; //result = stockLogDAL.Insert(user, stockLog); //if (result.ResultStatus != 0) // return result; result = stockDAL.UpdateStockStatusToPrevious(user, stock); if (result.ResultStatus != 0) return result; } scope.Complete(); } } } catch (Exception ex) { result.Message = ex.Message; } finally { if (result.ResultStatus != 0) log.ErrorFormat("{0} {1},类型序号:{2}", user.EmpName, result.Message, result.ReturnValue); else if (log.IsInfoEnabled) log.InfoFormat("{0} {1},类型序号:{2}", user.EmpName, result.Message, result.ReturnValue); } return result; }
public ResultModel Audit(UserModel user, NFMT.WorkFlow.Model.DataSource dataSource, bool isPass) { ResultModel result = new ResultModel(); try { DAL.StockDAL stockDAL = new StockDAL(); DAL.StockLogDAL stockLogDAL = new StockLogDAL(); DAL.StockOutDetailDAL detailDAL = new StockOutDetailDAL(); DAL.StockNameDAL stockNameDAL = new StockNameDAL(); DAL.StockOutApplyDAL stockOutApplyDAL = new StockOutApplyDAL(); using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required)) { result = this.stockoutDAL.Get(NFMT.Common.DefaultValue.SysUser, dataSource.RowId); if (result.ResultStatus != 0) return result; Model.StockOut stockOut = result.ReturnValue as Model.StockOut; if (stockOut == null || stockOut.StockOutId <= 0) { result.ResultStatus = -1; result.Message = "出库不存在"; return result; } //审核,修改数据状态 result = this.stockoutDAL.Audit(user, stockOut, isPass); if (result.ResultStatus != 0) return result; //审核通过 if (isPass) { //流水操作:写入 流水类型:出库 流水状态:已生效 库存操作:更新 库存状态:预售库存 //获取出库申请 result = stockOutApplyDAL.Get(user,stockOut.StockOutApplyId); if(result.ResultStatus!=0) return result; Model.StockOutApply stockOutApply = result.ReturnValue as Model.StockOutApply; if(stockOutApply == null || stockOutApply.StockOutApplyId<=0) { result.ResultStatus = -1; result.Message = "出库申请获取失败"; return result; } //获取出库明细 result = detailDAL.Load(user, stockOut.StockOutId); if (result.ResultStatus != 0) return result; List<Model.StockOutDetail> outDetails = result.ReturnValue as List<Model.StockOutDetail>; if (outDetails == null) { result.ResultStatus = -1; result.Message = "出库明细获取失败"; return result; } foreach (Model.StockOutDetail outDetail in outDetails) { //获取库存 result = stockDAL.Get(user, outDetail.StockId); if (result.ResultStatus != 0) return result; Model.Stock stock = result.ReturnValue as Model.Stock; if (stock == null || stock.StockId <= 0) { result.ResultStatus = -1; result.Message = "出库库存不存在"; return result; } //获取业务单 result = stockNameDAL.Get(user,stock.StockNameId); if(result.ResultStatus!=0) return result; Model.StockName stockName = result.ReturnValue as Model.StockName; if(stockName == null || stockName.StockNameId <=0) { result.ResultStatus = -1; result.Message = "业务单号获取失败"; return result; } //出库净重==当前净重时 库存状态更新至 预售库存 if (outDetail.NetAmount == stock.CurNetAmount) { result = stockDAL.UpdateStockStatus(stock, StockStatusEnum.预售库存); if (result.ResultStatus != 0) return result; } //写出库流水,流水状态为已生效 Model.StockLog stockLog = new StockLog() { AssetId = stock.AssetId, BrandId = stock.BrandId, CardNo = stock.CardNo, DeliverPlaceId = stock.DeliverPlaceId, GrossAmount = outDetail.GrossAmount, LogDate = DateTime.Now, LogDirection = (int)LogDirectionEnum.Out, LogSource = "dbo.St_StockOutDetail", LogSourceBase = "NFMT", LogStatus = StatusEnum.已生效, LogType = (int)LogTypeEnum.出库, NetAmount = outDetail.NetAmount, MUId = stock.UintId, OpPerson = user.EmpId, PaperHolder = stock.PaperHolder, PaperNo = stock.PaperNo, RefNo = stockName.RefNo, SourceId = outDetail.DetailId, StockId = stock.StockId, StockNameId = stock.StockNameId, SubContractId = stockOutApply.SubContractId, ContractId = stockOutApply.ContractId, Memo = stockOut.Memo, Bundles = outDetail.Bundles }; result = stockLogDAL.Insert(user, stockLog); if (result.ResultStatus != 0) return result; int stockLogId = 0; if (result.ReturnValue == null || !int.TryParse(result.ReturnValue.ToString(), out stockLogId) || stockLogId <= 0) { result.ResultStatus = -1; result.Message = "出库流水写入失败"; return result; } //更新出库明细的出库流水 outDetail.StockLogId = stockLogId; result = detailDAL.Update(user, outDetail); if (result.ResultStatus != 0) return result; } } scope.Complete(); } } catch (Exception ex) { result.ResultStatus = -1; result.Message = ex.Message; return result; } return result; }
public override IModel CreateModel(SqlDataReader dr) { StockLog stocklog = new StockLog(); int indexStockLogId = dr.GetOrdinal("StockLogId"); stocklog.StockLogId = Convert.ToInt32(dr[indexStockLogId]); int indexStockId = dr.GetOrdinal("StockId"); if (dr["StockId"] != DBNull.Value) { stocklog.StockId = Convert.ToInt32(dr[indexStockId]); } int indexStockNameId = dr.GetOrdinal("StockNameId"); if (dr["StockNameId"] != DBNull.Value) { stocklog.StockNameId = Convert.ToInt32(dr[indexStockNameId]); } int indexRefNo = dr.GetOrdinal("RefNo"); if (dr["RefNo"] != DBNull.Value) { stocklog.RefNo = Convert.ToString(dr[indexRefNo]); } int indexLogDirection = dr.GetOrdinal("LogDirection"); if (dr["LogDirection"] != DBNull.Value) { stocklog.LogDirection = Convert.ToInt32(dr[indexLogDirection]); } int indexLogType = dr.GetOrdinal("LogType"); stocklog.LogType = Convert.ToInt32(dr[indexLogType]); int indexContractId = dr.GetOrdinal("ContractId"); if (dr["ContractId"] != DBNull.Value) { stocklog.ContractId = Convert.ToInt32(dr[indexContractId]); } int indexSubContractId = dr.GetOrdinal("SubContractId"); if (dr["SubContractId"] != DBNull.Value) { stocklog.SubContractId = Convert.ToInt32(dr[indexSubContractId]); } int indexLogDate = dr.GetOrdinal("LogDate"); stocklog.LogDate = Convert.ToDateTime(dr[indexLogDate]); int indexOpPerson = dr.GetOrdinal("OpPerson"); if (dr["OpPerson"] != DBNull.Value) { stocklog.OpPerson = Convert.ToInt32(dr[indexOpPerson]); } int indexAssetId = dr.GetOrdinal("AssetId"); if (dr["AssetId"] != DBNull.Value) { stocklog.AssetId = Convert.ToInt32(dr[indexAssetId]); } int indexBundles = dr.GetOrdinal("Bundles"); stocklog.Bundles = Convert.ToInt32(dr[indexBundles]); int indexGrossAmount = dr.GetOrdinal("GrossAmount"); stocklog.GrossAmount = Convert.ToDecimal(dr[indexGrossAmount]); int indexNetAmount = dr.GetOrdinal("NetAmount"); stocklog.NetAmount = Convert.ToDecimal(dr[indexNetAmount]); int indexGapAmount = dr.GetOrdinal("GapAmount"); if (dr["GapAmount"] != DBNull.Value) { stocklog.GapAmount = Convert.ToDecimal(dr[indexGapAmount]); } int indexMUId = dr.GetOrdinal("MUId"); if (dr["MUId"] != DBNull.Value) { stocklog.MUId = Convert.ToInt32(dr[indexMUId]); } int indexBrandId = dr.GetOrdinal("BrandId"); if (dr["BrandId"] != DBNull.Value) { stocklog.BrandId = Convert.ToInt32(dr[indexBrandId]); } int indexGroupId = dr.GetOrdinal("GroupId"); if (dr["GroupId"] != DBNull.Value) { stocklog.GroupId = Convert.ToInt32(dr[indexGroupId]); } int indexCorpId = dr.GetOrdinal("CorpId"); if (dr["CorpId"] != DBNull.Value) { stocklog.CorpId = Convert.ToInt32(dr[indexCorpId]); } int indexDeptId = dr.GetOrdinal("DeptId"); if (dr["DeptId"] != DBNull.Value) { stocklog.DeptId = Convert.ToInt32(dr[indexDeptId]); } int indexCustomsType = dr.GetOrdinal("CustomsType"); if (dr["CustomsType"] != DBNull.Value) { stocklog.CustomsType = Convert.ToInt32(dr[indexCustomsType]); } int indexDeliverPlaceId = dr.GetOrdinal("DeliverPlaceId"); if (dr["DeliverPlaceId"] != DBNull.Value) { stocklog.DeliverPlaceId = Convert.ToInt32(dr[indexDeliverPlaceId]); } int indexProducerId = dr.GetOrdinal("ProducerId"); if (dr["ProducerId"] != DBNull.Value) { stocklog.ProducerId = Convert.ToInt32(dr[indexProducerId]); } int indexPaperNo = dr.GetOrdinal("PaperNo"); if (dr["PaperNo"] != DBNull.Value) { stocklog.PaperNo = Convert.ToString(dr[indexPaperNo]); } int indexPaperHolder = dr.GetOrdinal("PaperHolder"); if (dr["PaperHolder"] != DBNull.Value) { stocklog.PaperHolder = Convert.ToInt32(dr[indexPaperHolder]); } int indexCardNo = dr.GetOrdinal("CardNo"); if (dr["CardNo"] != DBNull.Value) { stocklog.CardNo = Convert.ToString(dr[indexCardNo]); } int indexStockType = dr.GetOrdinal("StockType"); if (dr["StockType"] != DBNull.Value) { stocklog.StockType = Convert.ToInt32(dr[indexStockType]); } int indexFormat = dr.GetOrdinal("Format"); if (dr["Format"] != DBNull.Value) { stocklog.Format = Convert.ToString(dr[indexFormat]); } int indexOriginPlaceId = dr.GetOrdinal("OriginPlaceId"); if (dr["OriginPlaceId"] != DBNull.Value) { stocklog.OriginPlaceId = Convert.ToInt32(dr[indexOriginPlaceId]); } int indexOriginPlace = dr.GetOrdinal("OriginPlace"); if (dr["OriginPlace"] != DBNull.Value) { stocklog.OriginPlace = Convert.ToString(dr[indexOriginPlace]); } int indexMemo = dr.GetOrdinal("Memo"); stocklog.Memo = Convert.ToString(dr[indexMemo]); int indexLogStatus = dr.GetOrdinal("LogStatus"); if (dr["LogStatus"] != DBNull.Value) { stocklog.LogStatus = (StatusEnum)Convert.ToInt32(dr[indexLogStatus]); } int indexLogSourceBase = dr.GetOrdinal("LogSourceBase"); if (dr["LogSourceBase"] != DBNull.Value) { stocklog.LogSourceBase = Convert.ToString(dr[indexLogSourceBase]); } int indexLogSource = dr.GetOrdinal("LogSource"); if (dr["LogSource"] != DBNull.Value) { stocklog.LogSource = Convert.ToString(dr[indexLogSource]); } int indexSourceId = dr.GetOrdinal("SourceId"); if (dr["SourceId"] != DBNull.Value) { stocklog.SourceId = Convert.ToInt32(dr[indexSourceId]); } int indexCreatorId = dr.GetOrdinal("CreatorId"); if (dr["CreatorId"] != DBNull.Value) { stocklog.CreatorId = Convert.ToInt32(dr[indexCreatorId]); } int indexCreateTime = dr.GetOrdinal("CreateTime"); if (dr["CreateTime"] != DBNull.Value) { stocklog.CreateTime = Convert.ToDateTime(dr[indexCreateTime]); } int indexLastModifyId = dr.GetOrdinal("LastModifyId"); if (dr["LastModifyId"] != DBNull.Value) { stocklog.LastModifyId = Convert.ToInt32(dr[indexLastModifyId]); } int indexLastModifyTime = dr.GetOrdinal("LastModifyTime"); if (dr["LastModifyTime"] != DBNull.Value) { stocklog.LastModifyTime = Convert.ToDateTime(dr[indexLastModifyTime]); } return stocklog; }