public static string queryJSONStringByPropertyType(mg_PropertyEnum propEnum)
{
string jsonStr = "[]";
List <mg_PropertyModel> list = mg_PropertyDAL.queryJSONStringByPropertyType(propEnum);
jsonStr = JSONTools.ScriptSerialize <List <mg_PropertyModel> >(list);
return(jsonStr);
}
public static List <mg_PropertyModel> queryJSONStringByPropertyType(mg_PropertyEnum propEnum)
{
List <mg_PropertyModel> list = null;
string sql = @"SELECT [prop_id]
,[Prop_type]
,[prop_name]
FROM [mg_Property] where Prop_type=" + (int)propEnum + @" order by prop_name";
DataTable dt = SqlHelper.GetDataDataTable(SqlHelper.SqlConnString, System.Data.CommandType.Text, sql, null);
if (DataHelper.HasData(dt))
{
list = new List <mg_PropertyModel>();
foreach (DataRow row in dt.Rows)
{
mg_PropertyModel model = new mg_PropertyModel();
model.prop_id = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "prop_id"));
model.prop_name = DataHelper.GetCellDataToStr(row, "prop_name");
list.Add(model);
}
}
return(list);
}
