/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.CityLocalTagEntity DataRowToModel(DataRow row) { Maticsoft.Model.CityLocalTagEntity model=new Maticsoft.Model.CityLocalTagEntity(); if (row != null) { if(row["LocalTagID"]!=null) { model.LocalTagID=row["LocalTagID"].ToString(); } if(row["TagName"]!=null) { model.TagName=row["TagName"].ToString(); } if(row["DistrictID"]!=null) { model.DistrictID=row["DistrictID"].ToString(); } if(row["CityID"]!=null) { model.CityID=row["CityID"].ToString(); } if(row["TagGrade"]!=null && row["TagGrade"].ToString()!="") { model.TagGrade=int.Parse(row["TagGrade"].ToString()); } if(row["Sort"]!=null && row["Sort"].ToString()!="") { model.Sort=int.Parse(row["Sort"].ToString()); } if(row["GLat"]!=null) { model.GLat=row["GLat"].ToString(); } if(row["GLng"]!=null) { model.GLng=row["GLng"].ToString(); } if(row["BLat"]!=null) { model.BLat=row["BLat"].ToString(); } if(row["BLng"]!=null) { model.BLng=row["BLng"].ToString(); } if(row["FLetter"]!=null) { model.FLetter=row["FLetter"].ToString(); } if(row["BusinessesNumber"]!=null && row["BusinessesNumber"].ToString()!="") { model.BusinessesNumber=int.Parse(row["BusinessesNumber"].ToString()); } } return model; }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.CityLocalTagEntity GetModel(string LocalTagID) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 LocalTagID,TagName,DistrictID,CityID,TagGrade,Sort,GLat,GLng,BLat,BLng,FLetter,BusinessesNumber from CityLocalTag "); strSql.Append(" where LocalTagID=@LocalTagID "); SqlParameter[] parameters = { new SqlParameter("@LocalTagID", SqlDbType.NVarChar,50) }; parameters[0].Value = LocalTagID; Maticsoft.Model.CityLocalTagEntity model=new Maticsoft.Model.CityLocalTagEntity(); DataSet ds=ServerDbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }