public override IModel CreateModel(SqlDataReader dr) { PricingDetail pricingdetail = new PricingDetail(); int indexDetailId = dr.GetOrdinal("DetailId"); pricingdetail.DetailId = Convert.ToInt32(dr[indexDetailId]); int indexPricingId = dr.GetOrdinal("PricingId"); if (dr["PricingId"] != DBNull.Value) { pricingdetail.PricingId = Convert.ToInt32(dr[indexPricingId]); } int indexPricingApplyId = dr.GetOrdinal("PricingApplyId"); if (dr["PricingApplyId"] != DBNull.Value) { pricingdetail.PricingApplyId = Convert.ToInt32(dr[indexPricingApplyId]); } int indexPricingApplyDetailId = dr.GetOrdinal("PricingApplyDetailId"); if (dr["PricingApplyDetailId"] != DBNull.Value) { pricingdetail.PricingApplyDetailId = Convert.ToInt32(dr[indexPricingApplyDetailId]); } int indexStockId = dr.GetOrdinal("StockId"); if (dr["StockId"] != DBNull.Value) { pricingdetail.StockId = Convert.ToInt32(dr[indexStockId]); } int indexStockLogId = dr.GetOrdinal("StockLogId"); if (dr["StockLogId"] != DBNull.Value) { pricingdetail.StockLogId = Convert.ToInt32(dr[indexStockLogId]); } int indexPricingWeight = dr.GetOrdinal("PricingWeight"); if (dr["PricingWeight"] != DBNull.Value) { pricingdetail.PricingWeight = Convert.ToDecimal(dr[indexPricingWeight]); } int indexAvgPrice = dr.GetOrdinal("AvgPrice"); if (dr["AvgPrice"] != DBNull.Value) { pricingdetail.AvgPrice = Convert.ToDecimal(dr[indexAvgPrice]); } int indexPricingTime = dr.GetOrdinal("PricingTime"); if (dr["PricingTime"] != DBNull.Value) { pricingdetail.PricingTime = Convert.ToDateTime(dr[indexPricingTime]); } int indexPricinger = dr.GetOrdinal("Pricinger"); if (dr["Pricinger"] != DBNull.Value) { pricingdetail.Pricinger = Convert.ToInt32(dr[indexPricinger]); } int indexDetailStatus = dr.GetOrdinal("DetailStatus"); if (dr["DetailStatus"] != DBNull.Value) { pricingdetail.DetailStatus = (Common.StatusEnum)Convert.ToInt32(dr[indexDetailStatus]); } int indexCreatorId = dr.GetOrdinal("CreatorId"); if (dr["CreatorId"] != DBNull.Value) { pricingdetail.CreatorId = Convert.ToInt32(dr[indexCreatorId]); } int indexCreateTime = dr.GetOrdinal("CreateTime"); if (dr["CreateTime"] != DBNull.Value) { pricingdetail.CreateTime = Convert.ToDateTime(dr[indexCreateTime]); } int indexLastModifyId = dr.GetOrdinal("LastModifyId"); if (dr["LastModifyId"] != DBNull.Value) { pricingdetail.LastModifyId = Convert.ToInt32(dr[indexLastModifyId]); } int indexLastModifyTime = dr.GetOrdinal("LastModifyTime"); if (dr["LastModifyTime"] != DBNull.Value) { pricingdetail.LastModifyTime = Convert.ToDateTime(dr[indexLastModifyTime]); } return pricingdetail; }
public ResultModel Load(UserModel user, int pricingId, Common.StatusEnum status = Common.StatusEnum.已生效) { ResultModel result = new ResultModel(); try { string cmdText = string.Format("select * from dbo.Pri_PricingDetail where PricingId ={0} and DetailStatus>={1}", pricingId, (int)status); DataTable dt = SqlHelper.ExecuteDataTable(ConnectString, cmdText, null, CommandType.Text); List<PricingDetail> pricingDetails = new List<PricingDetail>(); foreach (DataRow dr in dt.Rows) { PricingDetail pricingdetail = new PricingDetail(); pricingdetail.DetailId = Convert.ToInt32(dr["DetailId"]); if (dr["PricingId"] != DBNull.Value) { pricingdetail.PricingId = Convert.ToInt32(dr["PricingId"]); } if (dr["PricingApplyId"] != DBNull.Value) { pricingdetail.PricingApplyId = Convert.ToInt32(dr["PricingApplyId"]); } if (dr["PricingApplyDetailId"] != DBNull.Value) { pricingdetail.PricingApplyDetailId = Convert.ToInt32(dr["PricingApplyDetailId"]); } if (dr["StockId"] != DBNull.Value) { pricingdetail.StockId = Convert.ToInt32(dr["StockId"]); } if (dr["PricingWeight"] != DBNull.Value) { pricingdetail.PricingWeight = Convert.ToDecimal(dr["PricingWeight"]); } if (dr["AvgPrice"] != DBNull.Value) { pricingdetail.AvgPrice = Convert.ToDecimal(dr["AvgPrice"]); } if (dr["PricingTime"] != DBNull.Value) { pricingdetail.PricingTime = Convert.ToDateTime(dr["PricingTime"]); } if (dr["Pricinger"] != DBNull.Value) { pricingdetail.Pricinger = Convert.ToInt32(dr["Pricinger"]); } if (dr["DetailStatus"] != DBNull.Value) { pricingdetail.DetailStatus = (Common.StatusEnum)Convert.ToInt32(dr["DetailStatus"]); } if (dr["CreatorId"] != DBNull.Value) { pricingdetail.CreatorId = Convert.ToInt32(dr["CreatorId"]); } if (dr["CreateTime"] != DBNull.Value) { pricingdetail.CreateTime = Convert.ToDateTime(dr["CreateTime"]); } if (dr["LastModifyId"] != DBNull.Value) { pricingdetail.LastModifyId = Convert.ToInt32(dr["LastModifyId"]); } if (dr["LastModifyTime"] != DBNull.Value) { pricingdetail.LastModifyTime = Convert.ToDateTime(dr["LastModifyTime"]); } pricingDetails.Add(pricingdetail); } result.AffectCount = dt.Rows.Count; result.Message = "获取列表成功"; result.ResultStatus = 0; result.ReturnValue = pricingDetails; } catch (Exception ex) { result.Message = ex.Message; } return result; }
public override IModel CreateModel(DataRow dr) { PricingDetail pricingdetail = new PricingDetail(); pricingdetail.DetailId = Convert.ToInt32(dr["DetailId"]); if (dr["PricingId"] != DBNull.Value) { pricingdetail.PricingId = Convert.ToInt32(dr["PricingId"]); } if (dr["PricingApplyId"] != DBNull.Value) { pricingdetail.PricingApplyId = Convert.ToInt32(dr["PricingApplyId"]); } if (dr["PricingApplyDetailId"] != DBNull.Value) { pricingdetail.PricingApplyDetailId = Convert.ToInt32(dr["PricingApplyDetailId"]); } if (dr["StockId"] != DBNull.Value) { pricingdetail.StockId = Convert.ToInt32(dr["StockId"]); } if (dr["StockLogId"] != DBNull.Value) { pricingdetail.StockLogId = Convert.ToInt32(dr["StockLogId"]); } if (dr["PricingWeight"] != DBNull.Value) { pricingdetail.PricingWeight = Convert.ToDecimal(dr["PricingWeight"]); } if (dr["AvgPrice"] != DBNull.Value) { pricingdetail.AvgPrice = Convert.ToDecimal(dr["AvgPrice"]); } if (dr["PricingTime"] != DBNull.Value) { pricingdetail.PricingTime = Convert.ToDateTime(dr["PricingTime"]); } if (dr["Pricinger"] != DBNull.Value) { pricingdetail.Pricinger = Convert.ToInt32(dr["Pricinger"]); } if (dr["DetailStatus"] != DBNull.Value) { pricingdetail.DetailStatus = (Common.StatusEnum)Convert.ToInt32(dr["DetailStatus"]); } if (dr["CreatorId"] != DBNull.Value) { pricingdetail.CreatorId = Convert.ToInt32(dr["CreatorId"]); } if (dr["CreateTime"] != DBNull.Value) { pricingdetail.CreateTime = Convert.ToDateTime(dr["CreateTime"]); } if (dr["LastModifyId"] != DBNull.Value) { pricingdetail.LastModifyId = Convert.ToInt32(dr["LastModifyId"]); } if (dr["LastModifyTime"] != DBNull.Value) { pricingdetail.LastModifyTime = Convert.ToDateTime(dr["LastModifyTime"]); } return pricingdetail; }