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