static Local() { DataTable tmp = new xperdex.classes.MySQLDataTable(StaticDsnConnection.dsn, "select misc_item.name as item_name,misc_item.dept as dept_name,* from misc_def join misc_item using(item_id) join misc_dept using(dept_id)"); foreach (DataRow row in tmp.Rows) { String dept = row["dept_name"].ToString(); String item = row["item_name"].ToString(); int item_id = Convert.ToInt32(row["item_id"]); int dept_id = Convert.ToInt32(row["dept_id"]); GenericItemGroup group = Local.GetItemGroup(dept); group.GetGenericItem(item); } inited = true; }