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