/// <summary> /// 不显示三级科目 /// </summary> /// <param name="condition"></param> /// <param name="id"></param> /// <param name="isTwo"></param> /// <returns></returns> public List<string> GetChildSubjectList(string condition, string id, bool isTwo) { list = new List<string>(); string sql1 = string.Empty; string sql2 = string.Empty; sql = "select subject_id,subject_name from " + DBTablesName.T_SUBJECT; if (isTwo) { sql1 = " where parent_id = '" + id + "'"; } else { sql1 = " where parent_id like '" + id + "%'"; } if (!string.IsNullOrEmpty(condition)) { sql2 = " and subject_id like '" + condition + "%'"; } sql += sql1 + sql2 + " order by subject_id"; DataBase db = new DataBase(); DataTable dt = db.Query(sql).Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { string str = dt.Rows[i][0] + "\t" + dt.Rows[i][1]; list.Add(str); } return list; }
/// <summary> /// 获取所有科目的最低级科目(子细目) /// </summary> /// <returns></returns> public List<string> GetChildSubjectList(string condition) { List<string> lists = new List<string>(); string parm = string.Empty; if (!string.IsNullOrEmpty(condition)) { parm = " and a.subject_id like '" + condition + "%'"; } string sql = " SELECT " + " a.SUBJECT_ID, " + " a.subject_name, " + " b.SUBJECT_ID ParentID, " + " b.subject_name ParentName, " + " c.SUBJECT_ID ParentID, " + " c.subject_name ParentName, " + " d.SUBJECT_ID ParentID, " + " d.subject_name ParentName " + " FROM " + DBTablesName.T_SUBJECT + " a LEFT JOIN " + DBTablesName.T_SUBJECT + " b ON substr(a.SUBJECT_ID, 0, 4) = b.SUBJECT_ID " + " LEFT JOIN " + DBTablesName.T_SUBJECT + " c ON substr(a.SUBJECT_ID, 0, 6) = c.SUBJECT_ID " + " LEFT JOIN " + DBTablesName.T_SUBJECT + " d ON substr(a.SUBJECT_ID, 0, 8) = d.SUBJECT_ID " + " WHERE " + " a.SUBJECT_ID NOT IN ( " + " SELECT " + " PARENT_ID " + " FROM " + " T_SUBJECT_0 " + " GROUP BY " + " PARENT_ID " + " ) " + parm + " ORDER BY " + " a.SUBJECT_ID "; DataBase db = new DataBase(); DataTable dt = db.Query(sql).Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { string str = dt.Rows[i][0] + "\t" + dt.Rows[i][1] + "\t" //name + dt.Rows[i][2] + "\t" + dt.Rows[i][3] + "\t" //name + dt.Rows[i][4] + "\t" + dt.Rows[i][5] + "\t" //name + dt.Rows[i][6] + "\t" + dt.Rows[i][7]; //name lists.Add(str); } return lists; }
public List<string> GetSubjectList(string condition) { list = new List<string>(); if (string.IsNullOrEmpty(condition)) { sql = "select subject_id,subject_name from " + DBTablesName.T_SUBJECT + " where used_mark=0 and parent_id=0 order by id"; } else { sql = "select subject_id,subject_name from " + DBTablesName.T_SUBJECT + " where used_mark=0 " + "and subject_id like '" + condition + "%' and parent_id=0 order by id"; } DataBase db = new DataBase(); DataTable dt = db.Query(sql).Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { string str = dt.Rows[i][0]+"\t"+dt.Rows[i][1]; list.Add(str); } return list; }