public static List<CJSITE_MODULE> ToClass(DataTable data)
{
List<CJSITE_MODULE> list = new List<CJSITE_MODULE>();
for (int i = 0; i < data.Rows.Count; i++) {
CJSITE_MODULE cjsite_module = new CJSITE_MODULE();
cjsite_module.ID = data.Rows[i]["ID"]==DBNull.Value?"":Convert.ToString(data.Rows[i]["ID"]);
cjsite_module.GROUPID = data.Rows[i]["GROUPID"]==DBNull.Value?"":Convert.ToString(data.Rows[i]["GROUPID"]);
cjsite_module.MODULENAME = data.Rows[i]["MODULENAME"]==DBNull.Value?"":Convert.ToString(data.Rows[i]["MODULENAME"]);
list.Add(cjsite_module);
}
return list;
}
private void queryModules()
{
string sql = "select * from CJSITE_MODULE order by MODULENAME desc";
DBManager.ConnectCGDB();
DataTable data = DBManager.DBHelperCG.ExcuteSql(sql);
listModules = CJSITE_MODULE.ToClass(data);
CJSITE_MODULE nolimit = new CJSITE_MODULE();
nolimit.ID = "0";
nolimit.MODULENAME = "不限";
listModules.Add(nolimit);
listModules.Reverse(0, listModules.Count);
cbModule.ItemsSource = listModules;
}