/// <summary>
/// 获取省市区县镇乡列表
/// </summary>
/// <param name="serModel">查询实体</param>
/// <returns></returns>
public IList <Pro_City_Area_Street> GetProList(Pro_City_Area_StreetSer serModel)
{
IList <Pro_City_Area_Street> list = new List <Pro_City_Area_Street>();
StringBuilder query = new StringBuilder();
query.Append("select * from tbl_prov_city_area_street where 1=1");
if (serModel != null)
{
if (serModel.id > 0)
{
query.AppendFormat(" and id={0} ", serModel.id);
}
if (serModel.level > 0)
{
query.AppendFormat(" and level={0} ", serModel.level);
}
if (!string.IsNullOrEmpty(serModel.parentId))
{
query.AppendFormat(" and parentId='{0}' ", serModel.parentId);
}
}
query.Append("order by id asc");
DbCommand cmd = this._db.GetSqlStringCommand(query.ToString());
using (IDataReader dr = DbHelper.ExecuteReader(cmd, this._db))
{
while (dr.Read())
{
var model = new Pro_City_Area_Street();
model.id = dr.GetInt32(dr.GetOrdinal("id"));
model.code = dr["code"].ToString();
model.level = dr.GetInt32(dr.GetOrdinal("level"));
model.name = dr["name"].ToString();
model.parentId = dr["parentId"].ToString();
list.Add(model);
}
}
return(list);
}
/// <summary>
/// 获取省市区县镇乡列表
/// </summary>
/// <param name="serModel">查询实体</param>
/// <returns></returns>
public IList <Pro_City_Area_Street> GetProList(Pro_City_Area_StreetSer serModel)
{
return(dal.GetProList(serModel));
}
