/// <summary>
/// 得到一个对象实体
/// </summary>
public webs_YueyxShop.Model.ProductRecommendTypeBase DataRowToModel(DataRow row)
{
webs_YueyxShop.Model.ProductRecommendTypeBase model=new webs_YueyxShop.Model.ProductRecommendTypeBase();
if (row != null)
{
if(row["prt_ID"]!=null && row["prt_ID"].ToString()!="")
{
model.prt_ID=int.Parse(row["prt_ID"].ToString());
}
if(row["prt_Name"]!=null)
{
model.prt_Name=row["prt_Name"].ToString();
}
if(row["prt_Title"]!=null)
{
model.prt_Title=row["prt_Title"].ToString();
}
if(row["prt_Status"]!=null && row["prt_Status"].ToString()!="")
{
if((row["prt_Status"].ToString()=="1")||(row["prt_Status"].ToString().ToLower()=="true"))
{
model.prt_Status=true;
}
else
{
model.prt_Status=false;
}
}
if(row["prt_IsDelete"]!=null && row["prt_IsDelete"].ToString()!="")
{
if((row["prt_IsDelete"].ToString()=="1")||(row["prt_IsDelete"].ToString().ToLower()=="true"))
{
model.prt_IsDelete=true;
}
else
{
model.prt_IsDelete=false;
}
}
if(row["prt_Directions"]!=null)
{
model.prt_Directions=row["prt_Directions"].ToString();
}
}
return model;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public webs_YueyxShop.Model.ProductRecommendTypeBase GetModel(int prt_ID)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 prt_ID,prt_Name,prt_Title,prt_Status,prt_IsDelete,prt_Directions from ProductRecommendTypeBase ");
strSql.Append(" where prt_ID=@prt_ID");
SqlParameter[] parameters = {
new SqlParameter("@prt_ID", SqlDbType.Int,4)
};
parameters[0].Value = prt_ID;
webs_YueyxShop.Model.ProductRecommendTypeBase model=new webs_YueyxShop.Model.ProductRecommendTypeBase();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
