public string getGenType(Qualified_Student student_data) { Qualified_Student qualifiedObj = new Qualified_Student(); ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string gen_type = ""; string studentid1_2 = student_data.Year_Admission.Substring(2, 2); string studentid3_4 = student_data.Faculty_Code; string studentid5_6 = student_data.Department_Code_StudentID; string studentid7 = student_data.Major_Code_StudentID; string studentid8 = student_data.Degree_Admission; string studentid9 = student_data.Admission_Type; string tmp_studentid = studentid1_2 + studentid3_4 + studentid5_6 + studentid7 + studentid8 + studentid9; string table = qualifiedObj.getTableName(student_data.Degree_Char); string sql = "Select GEN_GROUP From " + table + " Where STUDENT_ID Like '" + tmp_studentid + "%' group by GEN_GROUP"; oracleObj.SelectCommand = sql; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { gen_type = rowData["GEN_GROUP"].ToString(); } return(gen_type); }
//public List<string> getStudentID(string academic_year, string faculty_code, string department_code, string major_code, string degree_code, string admissiontype_code, string gen_type, string sec_number, int amount) //{ // ConnectDB db = new ConnectDB(); // SqlDataSource oracleObj = db.ConnectionOracle(); // string sql = ""; // if (gen_type == "0") // ใช้ Sec // { // oracleObj.SelectCommand = "Select * From Run_Student_ID Where ACADEMIC_YEAR='" + academic_year + "' AND FACULTY_CODE='" + faculty_code + "' AND DEPARTMENT_CODE='" + department_code + "' AND MAJOR_CODE='" + major_code + "' AND DEGREE_CODE='" + degree_code + "' AND ADMISSION_TYPE='" + admissiontype_code + "' AND NUMBER1='" + sec_number + "' AND GEN_TYPE='" + gen_type + "'"; // DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); // string studentid1_2 = academic_year; // string studentid3_4 = faculty_code; // string studentid5_6 = department_code; // string studentid7 = major_code; // string studentid8 = degree_code; // string studentid9 = admissiontype_code; // string studentid10 = sec_number; // if (allData.Count == 0) // { // for (int i = 1; i <= amount; i++) // { // string runNum = i.ToString("00"); // string studentid11 = runNum.Substring(0, 1); // string studentid12 = runNum.Substring(1, 1); // string tmp_studentid = studentid1_2 + studentid3_4 + studentid5_6 + studentid7 + studentid8 + studentid9 + studentid10 + studentid11 + studentid12; // gen_student_id.Add(getCheckDigit(tmp_studentid)); // } // } // else // { // int start_num = 0; // foreach (DataRowView rowData in allData) // { // int studentid11 = Convert.ToInt16(rowData["NUMBER2"]) * 10; // int studentid12 = Convert.ToInt16(rowData["NUMBER3"]); // start_num = studentid11 + studentid12; // } // for (int i = 1; i <= amount; i++) // { // int j = start_num + i; // string runNum = j.ToString("00"); // string studentid11 = runNum.Substring(0, 1); // string studentid12 = runNum.Substring(1, 1); // string tmp_studentid = studentid1_2 + studentid3_4 + studentid5_6 + studentid7 + studentid8 + studentid9 + studentid10 + studentid11 + studentid12; // gen_student_id.Add(getCheckDigit(tmp_studentid)); // } // } // } // else if (gen_type == "1") // ไม่ใช้ Sec // { // oracleObj.SelectCommand = "Select * From Run_Student_ID Where ACADEMIC_YEAR='" + academic_year + "' AND FACULTY_CODE='" + faculty_code + "' AND DEPARTMENT_CODE='" + department_code + "' AND MAJOR_CODE='" + major_code + "' AND DEGREE_CODE='" + degree_code + "' AND ADMISSION_TYPE='" + admissiontype_code + "' AND GEN_TYPE='" + gen_type + "'"; // DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); // string studentid1_2 = academic_year; // string studentid3_4 = faculty_code; // string studentid5_6 = department_code; // string studentid7 = major_code; // string studentid8 = degree_code; // string studentid9 = admissiontype_code; // if (allData.Count == 0) // { // for (int i = 1; i <= amount; i++) // { // string runNum = i.ToString("000"); // string studentid10 = runNum.Substring(0, 1); // string studentid11 = runNum.Substring(1, 1); // string studentid12 = runNum.Substring(2, 1); // string tmp_studentid = studentid1_2 + studentid3_4 + studentid5_6 + studentid7 + studentid8 + studentid9 + studentid10 + studentid11 + studentid12; // gen_student_id.Add(getCheckDigit(tmp_studentid)); // } // } // else // { // int start_num = 0; // foreach (DataRowView rowData in allData) // { // int studentid10 = Convert.ToInt16(rowData["NUMBER1"]) * 100; // int studentid11 = Convert.ToInt16(rowData["NUMBER2"]) * 10; // int studentid12 = Convert.ToInt16(rowData["NUMBER3"]); // start_num = studentid10 + studentid11 + studentid12; // } // for (int i = 1; i <= amount; i++) // { // int j = start_num + i; // string runNum = j.ToString("000"); // string studentid10 = runNum.Substring(0, 1); // string studentid11 = runNum.Substring(1, 1); // string studentid12 = runNum.Substring(2, 1); // string tmp_studentid = studentid1_2 + studentid3_4 + studentid5_6 + studentid7 + studentid8 + studentid9 + studentid10 + studentid11 + studentid12; // gen_student_id.Add(getCheckDigit(tmp_studentid)); // } // } // } // //gen_student_id.Add(sql); // return gen_student_id; //} //public string getStudentID(string academic_year, string faculty_code, string department_code, string major_code, string degree_code, string admissiontype_code, string gen_type, string sec_number, string project_code) public string getStudentID(Qualified_Student student_data) { Qualified_Student qualifiedObj = new Qualified_Student(); ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string student_id = ""; if (student_data.Gen_Gruop == "y") // ใช้ Sec { string studentid1_2 = student_data.Year_Admission.Substring(2, 2); string studentid3_4 = student_data.Faculty_Code; string studentid5_6 = student_data.Department_Code_StudentID; string studentid7 = student_data.Major_Code_StudentID; string studentid8 = student_data.Degree_Admission; string studentid9 = student_data.Admission_Type; string studentid10 = ""; if (student_data.StudentGruop == "001") { studentid10 = "0"; } else if (student_data.StudentGruop == "002") { studentid10 = "1"; } else if (student_data.StudentGruop == "003") { studentid10 = "2"; } else if (student_data.StudentGruop == "004") { studentid10 = "3"; } else if (student_data.StudentGruop == "005") { studentid10 = "4"; } else if (student_data.StudentGruop == "006") { studentid10 = "5"; } else if (student_data.StudentGruop == "007") { studentid10 = "6"; } else if (student_data.StudentGruop == "008") { studentid10 = "7"; } else if (student_data.StudentGruop == "009") { studentid10 = "8"; } else if (student_data.StudentGruop == "010") { studentid10 = "9"; } else { studentid10 = "x"; } string max_student_id = ""; string tmp_studentid = studentid1_2 + studentid3_4 + studentid5_6 + studentid7 + studentid8 + studentid9 + studentid10; string table = qualifiedObj.getTableName(student_data.Degree_Char); string sql = "Select Max(TO_NUMBER(student_id)) AS MAX_ID From " + table + " Where STUDENT_ID Like '" + tmp_studentid + "%'"; oracleObj.SelectCommand = sql; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { max_student_id = rowData["MAX_ID"].ToString(); } if (max_student_id == "") { string studentid11 = "0"; string studentid12 = "1"; string tmp_studentid2 = tmp_studentid + studentid11 + studentid12; student_id = getCheckDigit(tmp_studentid2); } else if (max_student_id.Length == 13) { int run_num = Convert.ToInt16(max_student_id.Substring(10, 2)); run_num++; if (run_num <= 99) { string tmp_studentid2 = tmp_studentid + run_num.ToString("00"); student_id = getCheckDigit(tmp_studentid2); } else { student_id = "max"; } } else { student_id = "err"; } } else if (student_data.Gen_Gruop == "n") // ไม่ใช้ Sec { string studentid1_2 = student_data.Year_Admission.Substring(2, 2); string studentid3_4 = student_data.Faculty_Code; string studentid5_6 = student_data.Department_Code_StudentID; string studentid7 = student_data.Major_Code_StudentID; string studentid8 = student_data.Degree_Admission; string studentid9 = student_data.Admission_Type; string max_student_id = ""; string tmp_studentid = studentid1_2 + studentid3_4 + studentid5_6 + studentid7 + studentid8 + studentid9; string table = qualifiedObj.getTableName(student_data.Degree_Char); string sql = "Select Max(TO_NUMBER(student_id)) AS MAX_ID From " + table + " Where STUDENT_ID Like '" + tmp_studentid + "%'"; oracleObj.SelectCommand = sql; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { max_student_id = rowData["MAX_ID"].ToString(); } if (max_student_id == "") { string studentid10 = "0"; string studentid11 = "0"; string studentid12 = "1"; string tmp_studentid2 = tmp_studentid + studentid10 + studentid11 + studentid12; student_id = getCheckDigit(tmp_studentid2); } else if (max_student_id.Length == 13) { int run_num = Convert.ToInt16(max_student_id.Substring(9, 3)); run_num++; if (run_num <= 999) { string tmp_studentid2 = tmp_studentid + run_num.ToString("000"); student_id = getCheckDigit(tmp_studentid2); } else { student_id = "max"; } } else { student_id = "err"; } } if (student_id.Length == 13) { return(student_id); } else { return("ID_Error" + student_id); } }