/// <summary>
/// 得到一个对象实体
/// </summary>
public webs_YueyxShop.Model.ProductBase DataRowToModel(DataRow row)
{
webs_YueyxShop.Model.ProductBase model=new webs_YueyxShop.Model.ProductBase();
if (row != null)
{
if(row["p_ID"]!=null && row["p_ID"].ToString()!="")
{
model.p_ID=int.Parse(row["p_ID"].ToString());
}
if (row["b_ID"] != null && row["b_ID"].ToString() != "")
{
model.b_ID = int.Parse(row["b_ID"].ToString());
}
if(row["pt_ID"]!=null && row["pt_ID"].ToString()!="")
{
model.pt_ID=int.Parse(row["pt_ID"].ToString());
}
if (row["ct_ID"] != null && row["ct_ID"].ToString() != "")
{
model.ct_ID = int.Parse(row["ct_ID"].ToString());
}
if(row["p_Name"]!=null)
{
model.p_Name=row["p_Name"].ToString();
}
if(row["p_Sort"]!=null && row["p_Sort"].ToString()!="")
{
model.p_Sort=int.Parse(row["p_Sort"].ToString());
}
if(row["p_MeasurementUnit"]!=null)
{
model.p_MeasurementUnit=row["p_MeasurementUnit"].ToString();
}
if(row["p_Province"]!=null)
{
model.p_Province=int.Parse(row["p_Province"].ToString());
}
if(row["p_City"]!=null)
{
model.p_City=int.Parse(row["p_City"].ToString());
}
if(row["p_County"]!=null)
{
model.p_County=int.Parse(row["p_County"].ToString());
}
if(row["p_CreatedOn"]!=null && row["p_CreatedOn"].ToString()!="")
{
model.p_CreatedOn=DateTime.Parse(row["p_CreatedOn"].ToString());
}
if(row["p_CreatedBy"]!=null && row["p_CreatedBy"].ToString()!="")
{
model.p_CreatedBy= new Guid(row["p_CreatedBy"].ToString());
}
if(row["p_ModifyOn"]!=null && row["p_ModifyOn"].ToString()!="")
{
model.p_ModifyOn=DateTime.Parse(row["p_ModifyOn"].ToString());
}
if(row["p_ModifyBy"]!=null && row["p_ModifyBy"].ToString()!="")
{
model.p_ModifyBy= new Guid(row["p_ModifyBy"].ToString());
}
if(row["p_StatusCode"]!=null && row["p_StatusCode"].ToString()!="")
{
model.p_StatusCode=int.Parse(row["p_StatusCode"].ToString());
}
if (row["p_sellStatus"] != null && row["p_sellStatus"].ToString() != "")
{
model.p_SellStatus = int.Parse(row["p_sellStatus"].ToString());
}
if(row["p_IsDel"]!=null && row["p_IsDel"].ToString()!="")
{
if((row["p_IsDel"].ToString()=="1")||(row["p_IsDel"].ToString().ToLower()=="true"))
{
model.p_IsDel=true;
}
else
{
model.p_IsDel=false;
}
}
}
return model;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public webs_YueyxShop.Model.ProductBase GetModel(int p_ID)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 b_ID ,p_ID,ct_ID,pt_ID,p_Name,p_Sort,p_MeasurementUnit,p_Province,p_City,p_County,p_CreatedOn,p_CreatedBy,p_ModifyOn,p_ModifyBy,p_StatusCode,p_IsDel,p_sellStatus from ProductBase ");
strSql.Append(" where p_ID=@p_ID");
SqlParameter[] parameters = {
new SqlParameter("@p_ID", SqlDbType.Int,4)
};
parameters[0].Value = p_ID;
webs_YueyxShop.Model.ProductBase model=new webs_YueyxShop.Model.ProductBase();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
