/// <summary>
/// 转换至EClassAreaModel
/// </summary>
/// <param name="row"></param>
/// <returns></returns>
public AreaModel TransAreaModel(DataRow row)
{
AreaModel areaModel = new AreaModel();
areaModel.F_ID = row["f_id"] != System.DBNull.Value ? row["f_id"].ToString() : string.Empty;
areaModel.F_Name = row["f_name"] != System.DBNull.Value ? row["f_name"].ToString() : string.Empty;
areaModel.F_Parent = row["f_parent"] != System.DBNull.Value ? row["f_parent"].ToString() : string.Empty;
areaModel.F_Order = row["f_order"] != System.DBNull.Value ? Convert.ToInt32(row["f_order"]) : 0;
return areaModel;
}
/// <summary>
/// 加载省市区
/// </summary>
/// <param name="parent">父ID</param>
/// <returns></returns>
public IList<AreaModel> GetAreaInfoList(string parent)
{
IList<AreaModel> areaModelList = new List<AreaModel>();
#region - sql -
string sqlSelectQy = @"SELECT
`f_id`,
`f_name`,
`f_parent`,
`f_order`
FROM `movehouse`.`area` AS ar
where ar.`f_parent`=@Parent";
#endregion
#region - paras -
MySqlParameter[] paras =
{
new MySqlParameter("@Parent",parent)
};
#endregion
#region - excute -
try
{
//记录查询
DataTable dataTable = DbHelperMySql.GetDataSet(DbHelperMySql.connectionStringManager, sqlSelectQy, paras).Tables[0];
if (dataTable != null)
{
AreaModel areaModel = new AreaModel();
foreach (DataRow row in dataTable.Rows)
{
areaModel = TransAreaModel(row);
areaModelList.Add(areaModel);
}
}
}
catch (Exception ex)
{
throw ex;
}
#endregion
return areaModelList;
}