/// <summary>
/// 得到一个对象实体
/// </summary>
public webs_YueyxShop.Model.vm_PCdetails GetModel(int id)
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 m_UserName,m_NickName,m_RealName,sku_ModifyBy,p_ID,sku_Price,sku_CostPrice,sku_Stock,sku_SalesCount,sku_Code,sku_CreatedOn,sku_CreatedBy,sku_ModifyOn,sku_StatusCode,sku_IsDel,p_Name,p_Sort,p_MeasurementUnit,p_Province,p_City,p_County,p_CreatedOn,p_ModifyOn,p_CreatedBy,p_ModifyBy,p_StatusCode,p_IsDel,p_SellStatus,ct_ID,pt_ID,m_Password,m_UserType,m_YingYZZ,m_Score,m_Rank,m_Sex,m_Birthday,m_Phone,m_Email,m_QQ,m_CreatedOn,m_ZheK,m_StatusCode,m_ShenPstatus,pc_ID,sku_ID,pc_CreatedOn,pc_Type,pc_Content,pc_CreatedBy,pc_StatusCode,pc_huifu,pc_IsDel from vm_PCdetails ");
strSql.Append(" where pc_id="+id);
SqlParameter[] parameters = {
};
webs_YueyxShop.Model.vm_PCdetails model=new webs_YueyxShop.Model.vm_PCdetails();
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.vm_PCdetails DataRowToModel(DataRow row)
{
webs_YueyxShop.Model.vm_PCdetails model=new webs_YueyxShop.Model.vm_PCdetails();
if (row != null)
{
if(row["m_UserName"]!=null)
{
model.m_UserName=row["m_UserName"].ToString();
}
if(row["m_NickName"]!=null)
{
model.m_NickName=row["m_NickName"].ToString();
}
if(row["m_RealName"]!=null)
{
model.m_RealName=row["m_RealName"].ToString();
}
if(row["sku_ModifyBy"]!=null && row["sku_ModifyBy"].ToString()!="")
{
model.sku_ModifyBy= new Guid(row["sku_ModifyBy"].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_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["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_ModifyOn"]!=null && row["p_ModifyOn"].ToString()!="")
{
model.p_ModifyOn=DateTime.Parse(row["p_ModifyOn"].ToString());
}
if(row["p_CreatedBy"]!=null && row["p_CreatedBy"].ToString()!="")
{
model.p_CreatedBy= new Guid(row["p_CreatedBy"].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["pt_ID"]!=null && row["pt_ID"].ToString()!="")
{
model.pt_ID=int.Parse(row["pt_ID"].ToString());
}
if(row["m_Password"]!=null)
{
model.m_Password=row["m_Password"].ToString();
}
if(row["m_UserType"]!=null && row["m_UserType"].ToString()!="")
{
model.m_UserType=int.Parse(row["m_UserType"].ToString());
}
if(row["m_YingYZZ"]!=null)
{
model.m_YingYZZ=row["m_YingYZZ"].ToString();
}
if(row["m_Score"]!=null && row["m_Score"].ToString()!="")
{
model.m_Score=int.Parse(row["m_Score"].ToString());
}
if(row["m_Rank"]!=null && row["m_Rank"].ToString()!="")
{
model.m_Rank=int.Parse(row["m_Rank"].ToString());
}
if(row["m_Sex"]!=null && row["m_Sex"].ToString()!="")
{
model.m_Sex=int.Parse(row["m_Sex"].ToString());
}
if(row["m_Birthday"]!=null && row["m_Birthday"].ToString()!="")
{
model.m_Birthday=DateTime.Parse(row["m_Birthday"].ToString());
}
if(row["m_Phone"]!=null)
{
model.m_Phone=row["m_Phone"].ToString();
}
if(row["m_Email"]!=null)
{
model.m_Email=row["m_Email"].ToString();
}
if(row["m_QQ"]!=null)
{
model.m_QQ=row["m_QQ"].ToString();
}
if(row["m_CreatedOn"]!=null && row["m_CreatedOn"].ToString()!="")
{
model.m_CreatedOn=DateTime.Parse(row["m_CreatedOn"].ToString());
}
if(row["m_ZheK"]!=null && row["m_ZheK"].ToString()!="")
{
model.m_ZheK=decimal.Parse(row["m_ZheK"].ToString());
}
if(row["m_StatusCode"]!=null && row["m_StatusCode"].ToString()!="")
{
model.m_StatusCode=int.Parse(row["m_StatusCode"].ToString());
}
if(row["m_ShenPstatus"]!=null && row["m_ShenPstatus"].ToString()!="")
{
model.m_ShenPstatus=int.Parse(row["m_ShenPstatus"].ToString());
}
if(row["pc_ID"]!=null && row["pc_ID"].ToString()!="")
{
model.pc_ID=int.Parse(row["pc_ID"].ToString());
}
if(row["sku_ID"]!=null && row["sku_ID"].ToString()!="")
{
model.sku_ID=int.Parse(row["sku_ID"].ToString());
}
if(row["pc_CreatedOn"]!=null && row["pc_CreatedOn"].ToString()!="")
{
model.pc_CreatedOn=DateTime.Parse(row["pc_CreatedOn"].ToString());
}
if(row["pc_Type"]!=null)
{
model.pc_Type=row["pc_Type"].ToString();
}
if(row["pc_Content"]!=null)
{
model.pc_Content=row["pc_Content"].ToString();
}
if(row["pc_CreatedBy"]!=null && row["pc_CreatedBy"].ToString()!="")
{
model.pc_CreatedBy=int.Parse(row["pc_CreatedBy"].ToString());
}
if(row["pc_StatusCode"]!=null && row["pc_StatusCode"].ToString()!="")
{
model.pc_StatusCode=int.Parse(row["pc_StatusCode"].ToString());
}
if (row["pc_huifu"] != null && row["pc_huifu"].ToString() != "")
{
model.pc_huifu = int.Parse(row["pc_huifu"].ToString());
}
if(row["pc_IsDel"]!=null && row["pc_IsDel"].ToString()!="")
{
if((row["pc_IsDel"].ToString()=="1")||(row["pc_IsDel"].ToString().ToLower()=="true"))
{
model.pc_IsDel=true;
}
else
{
model.pc_IsDel=false;
}
}
}
return model;
}
