/// <summary>
/// 得到一个对象实体
/// </summary>
public webs_YueyxShop.Model.vm_GBDetails GetModel(int pid)
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 * from vm_GBDetails ");
strSql.Append(" where gp_ID="+pid);
webs_YueyxShop.Model.vm_GBDetails model=new webs_YueyxShop.Model.vm_GBDetails();
DataSet ds=DbHelperSQL.Query(strSql.ToString());
if(ds.Tables[0].Rows.Count>0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public webs_YueyxShop.Model.vm_GBDetails DataRowToModel(DataRow row)
{
webs_YueyxShop.Model.vm_GBDetails model=new webs_YueyxShop.Model.vm_GBDetails();
if (row != null)
{
if (row["gp_ID"] != null && row["gp_ID"].ToString() != "")
{
model.gp_ID = int.Parse(row["gp_ID"].ToString());
}
if(row["p_ID"]!=null && row["p_ID"].ToString()!="")
{
model.p_ID=int.Parse(row["p_ID"].ToString());
}
if(row["pt_ID"]!=null && row["pt_ID"].ToString()!="")
{
model.pt_ID=int.Parse(row["pt_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 && row["p_Province"].ToString()!="")
{
model.p_Province=int.Parse(row["p_Province"].ToString());
}
if(row["p_City"]!=null && row["p_City"].ToString()!="")
{
model.p_City=int.Parse(row["p_City"].ToString());
}
if(row["p_County"]!=null && row["p_County"].ToString()!="")
{
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_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;
}
}
if(row["p_SellStatus"]!=null && row["p_SellStatus"].ToString()!="")
{
model.p_SellStatus=int.Parse(row["p_SellStatus"].ToString());
}
if(row["ct_ID"]!=null && row["ct_ID"].ToString()!="")
{
model.ct_ID=int.Parse(row["ct_ID"].ToString());
}
if(row["pi_Url"]!=null)
{
model.pi_Url=row["pi_Url"].ToString();
}
if(row["gp_StartTime"]!=null && row["gp_StartTime"].ToString()!="")
{
model.gp_StartTime=DateTime.Parse(row["gp_StartTime"].ToString());
}
if(row["gp_EndTime"]!=null && row["gp_EndTime"].ToString()!="")
{
model.gp_EndTime=DateTime.Parse(row["gp_EndTime"].ToString());
}
if(row["gp_pCount"]!=null && row["gp_pCount"].ToString()!="")
{
model.gp_pCount=int.Parse(row["gp_pCount"].ToString());
}
if(row["gp_pPric"]!=null && row["gp_pPric"].ToString()!="")
{
model.gp_pPric=decimal.Parse(row["gp_pPric"].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_scPric"] != null && row["sku_scPric"].ToString() != "")
{
model.sku_scPrice = decimal.Parse(row["sku_scPric"].ToString());
}
if(row["sku_SalesCount"]!=null && row["sku_SalesCount"].ToString()!="")
{
model.sku_SalesCount=int.Parse(row["sku_SalesCount"].ToString());
}
if(row["sku_Stock"]!=null && row["sku_Stock"].ToString()!="")
{
model.sku_Stock=int.Parse(row["sku_Stock"].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_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_Code"]!=null)
{
model.sku_Code=row["sku_Code"].ToString();
}
if(row["sku_ID"]!=null && row["sku_ID"].ToString()!="")
{
model.sku_ID=int.Parse(row["sku_ID"].ToString());
}
if(row["shuxing"]!=null)
{
model.shuxing=row["shuxing"].ToString();
}
if(row["b_ID"]!=null && row["b_ID"].ToString()!="")
{
model.b_ID=int.Parse(row["b_ID"].ToString());
}
if(row["gp_IsDel"]!=null && row["gp_IsDel"].ToString()!="")
{
if((row["gp_IsDel"].ToString()=="1")||(row["gp_IsDel"].ToString().ToLower()=="true"))
{
model.gp_IsDel=true;
}
else
{
model.gp_IsDel=false;
}
}
if(row["gp_StatusCode"]!=null && row["gp_StatusCode"].ToString()!="")
{
model.gp_StatusCode=int.Parse(row["gp_StatusCode"].ToString());
}
if(row["gp_Logo"]!=null)
{
model.gp_Logo=row["gp_Logo"].ToString();
}
if(row["gp_Slogan"]!=null)
{
model.gp_Slogan=row["gp_Slogan"].ToString();
}
if(row["gp_SaleCount"]!=null && row["gp_SaleCount"].ToString()!="")
{
model.gp_SaleCount=int.Parse(row["gp_SaleCount"].ToString());
}
}
return model;
}
