/// <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; } }