/// <summary>
/// 得到一个对象实体
/// </summary>
public webs_YueyxShop.Model.SKUBase GetModel(int sku_ID)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 sku_ID,p_ID,sku_Price,sku_CostPrice,sku_Stock,sku_SalesCount,sku_Code,sku_CreatedOn,sku_CreatedBy,sku_ModifyOn,sku_ModifyBy,sku_StatusCode,sku_IsDel,sku_scPric,sku_IsMoren,sku_tdcode from SKUBase ");
strSql.Append(" where sku_ID=@sku_ID");
SqlParameter[] parameters = {
new SqlParameter("@sku_ID", SqlDbType.Int,4)
};
parameters[0].Value = sku_ID;
webs_YueyxShop.Model.SKUBase model=new webs_YueyxShop.Model.SKUBase();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public webs_YueyxShop.Model.SKUBase DataRowToModel(DataRow row)
{
webs_YueyxShop.Model.SKUBase model=new webs_YueyxShop.Model.SKUBase();
if (row != null)
{
if(row["sku_ID"]!=null && row["sku_ID"].ToString()!="")
{
model.sku_ID=int.Parse(row["sku_ID"].ToString());
}
if(row["p_ID"]!=null && row["p_ID"].ToString()!="")
{
model.p_ID=int.Parse(row["p_ID"].ToString());
}
if(row["sku_Price"]!=null && row["sku_Price"].ToString()!="")
{
model.sku_Price=decimal.Parse(row["sku_Price"].ToString());
}
if(row["sku_CostPrice"]!=null && row["sku_CostPrice"].ToString()!="")
{
model.sku_CostPrice=decimal.Parse(row["sku_CostPrice"].ToString());
}
if(row["sku_Stock"]!=null && row["sku_Stock"].ToString()!="")
{
model.sku_Stock=int.Parse(row["sku_Stock"].ToString());
}
if(row["sku_SalesCount"]!=null && row["sku_SalesCount"].ToString()!="")
{
model.sku_SalesCount=int.Parse(row["sku_SalesCount"].ToString());
}
if(row["sku_Code"]!=null)
{
model.sku_Code=row["sku_Code"].ToString();
}
if(row["sku_CreatedOn"]!=null && row["sku_CreatedOn"].ToString()!="")
{
model.sku_CreatedOn=DateTime.Parse(row["sku_CreatedOn"].ToString());
}
if(row["sku_CreatedBy"]!=null && row["sku_CreatedBy"].ToString()!="")
{
model.sku_CreatedBy= new Guid(row["sku_CreatedBy"].ToString());
}
if(row["sku_ModifyOn"]!=null && row["sku_ModifyOn"].ToString()!="")
{
model.sku_ModifyOn=DateTime.Parse(row["sku_ModifyOn"].ToString());
}
if(row["sku_ModifyBy"]!=null && row["sku_ModifyBy"].ToString()!="")
{
model.sku_ModifyBy= new Guid(row["sku_ModifyBy"].ToString());
}
if(row["sku_StatusCode"]!=null && row["sku_StatusCode"].ToString()!="")
{
model.sku_StatusCode=int.Parse(row["sku_StatusCode"].ToString());
}
if(row["sku_IsDel"]!=null && row["sku_IsDel"].ToString()!="")
{
if((row["sku_IsDel"].ToString()=="1")||(row["sku_IsDel"].ToString().ToLower()=="true"))
{
model.sku_IsDel=true;
}
else
{
model.sku_IsDel=false;
}
}
if(row["sku_scPric"]!=null && row["sku_scPric"].ToString()!="")
{
model.sku_scPric=decimal.Parse(row["sku_scPric"].ToString());
}
if (row["sku_IsMoren"] != null && row["sku_IsMoren"].ToString() != "")
{
if ((row["sku_IsMoren"].ToString() == "1") || (row["sku_IsMoren"].ToString().ToLower() == "true"))
{
model.sku_IsMoren = true;
}
else
{
model.sku_IsMoren = false;
}
}
if (row["sku_tdcode"] != null)
{
model.sku_tdcode = row["sku_tdcode"].ToString();
}
}
return model;
}
