public bool insertAQuiz(Model.QuizForDB quiz) { OxcoderIFactory.IFactory factory = new OxcoderFactory.SqlSeverFactory(); OxcoderIDAL.QuizInfoIDAL en = factory.getQuizInstance(); if (quiz.Quiz_Type.Equals("php")) { quiz.Quiz_TypeID = 29; } else if (quiz.Quiz_Type.Equals("cpp")) { quiz.Quiz_TypeID = 1; } else if (quiz.Quiz_Type.Equals("python")) { quiz.Quiz_TypeID = 4; } else if (quiz.Quiz_Type.Equals("c")) { quiz.Quiz_TypeID = 34; } else if (quiz.Quiz_Type.Equals("java")) { quiz.Quiz_TypeID = 10; } return(en.insertAQuiz(quiz)); }
public bool insertAQuiz(Model.QuizForDB quiz) { OxcoderIFactory.IFactory factory = new OxcoderFactory.SqlSeverFactory(); OxcoderIDAL.QuizInfoIDAL en = factory.getQuizInstance(); if (quiz.Quiz_Type.Equals("php")) { quiz.Quiz_TypeID = 29; } else if (quiz.Quiz_Type.Equals("cpp")) { quiz.Quiz_TypeID = 1; } else if (quiz.Quiz_Type.Equals("python")) { quiz.Quiz_TypeID = 4; } else if (quiz.Quiz_Type.Equals("c")) { quiz.Quiz_TypeID = 34; } else if (quiz.Quiz_Type.Equals("java")) { quiz.Quiz_TypeID = 10; } return en.insertAQuiz(quiz); }
private DataSet AddOtherInfo(DataSet ds,DataSet ds2) { DataColumn dc = new DataColumn(); dc.DataType = System.Type.GetType("System.String"); dc.ColumnName = "Enterprice_FullName"; ds.Tables[0].Columns.Add(dc); dc = new DataColumn(); dc.DataType = System.Type.GetType("System.String"); dc.ColumnName = "Enterprice_Logo"; ds.Tables[0].Columns.Add(dc); dc = new DataColumn(); dc.DataType = System.Type.GetType("System.String"); dc.ColumnName = "Test_Quiz0"; ds.Tables[0].Columns.Add(dc); dc = new DataColumn(); dc.DataType = System.Type.GetType("System.String"); dc.ColumnName = "Test_Quiz1"; ds.Tables[0].Columns.Add(dc); dc = new DataColumn(); dc.DataType = System.Type.GetType("System.String"); dc.ColumnName = "Test_Quiz2"; ds.Tables[0].Columns.Add(dc); DataRow dr = ds.Tables[0].Rows[0]; DataRow dr2 = ds2.Tables[0].Rows[0]; dr["Enterprice_FullName"] = dr2["Enterprice_FullName"].ToString(); dr["Enterprice_Logo"] = dr2["Enterprice_Logo"].ToString(); OxcoderIFactory.IFactory factory = new OxcoderFactory.SqlSeverFactory(); OxcoderIDAL.QuizInfoIDAL quiz = factory.getQuizInstance(); String strTemp = dr2["Challenge_Quiz_First"].ToString(); if (dr["Test_Quiz0_State"].ToString() != "-1") dr["Test_Quiz0"] = quiz.QuizName(strTemp) + "通过"; else dr["Test_Quiz0"] = quiz.QuizName(strTemp) + "未通过"; strTemp = dr2["Challenge_Quiz_Sec"].ToString(); if (dr["Test_Quiz1_State"].ToString() != "-1") dr["Test_Quiz1"] = quiz.QuizName(strTemp) + "通过"; else dr["Test_Quiz1"] = quiz.QuizName(strTemp) + "未通过"; strTemp = dr2["Challenge_Quiz_Third"].ToString(); if (dr["Test_Quiz2_State"].ToString() != "-1") dr["Test_Quiz2"] = quiz.QuizName(strTemp) + "通过"; else dr["Test_Quiz2"] = quiz.QuizName(strTemp) + "未通过"; return ds; }
private DataSet AddPositionAndQuiz(DataSet ds) { OxcoderIFactory.IFactory factory = new OxcoderFactory.SqlSeverFactory(); OxcoderIDAL.QuizInfoIDAL quiz = factory.getQuizInstance(); DataColumn dc = new DataColumn(); dc.DataType = System.Type.GetType("System.String"); dc.ColumnName = "Challenge_Position0"; ds.Tables[0].Columns.Add(dc); dc = new DataColumn(); dc.DataType = System.Type.GetType("System.String"); dc.ColumnName = "Challenge_Position1"; ds.Tables[0].Columns.Add(dc); dc = new DataColumn(); dc.DataType = System.Type.GetType("System.String"); dc.ColumnName = "Challenge_Position2"; ds.Tables[0].Columns.Add(dc); dc = new DataColumn(); dc.DataType = System.Type.GetType("System.String"); dc.ColumnName = "Challenge_Quiz0"; ds.Tables[0].Columns.Add(dc); dc = new DataColumn(); dc.DataType = System.Type.GetType("System.String"); dc.ColumnName = "Challenge_Quiz1"; ds.Tables[0].Columns.Add(dc); dc = new DataColumn(); dc.DataType = System.Type.GetType("System.String"); dc.ColumnName = "Challenge_Quiz2"; ds.Tables[0].Columns.Add(dc); foreach (DataRow dr in ds.Tables[0].Rows) { if (dr["Challenge_Salary"].ToString() == "1") { dr["Challenge_Salary"] = "2k~5k"; } else if (dr["Challenge_Salary"].ToString() == "2") { dr["Challenge_Salary"] = "5k~8k"; } else if (dr["Challenge_Salary"].ToString() == "3") { dr["Challenge_Salary"] = "8k~10k"; } else if (dr["Challenge_Salary"].ToString() == "4") { dr["Challenge_Salary"] = "10k~12k"; } else if (dr["Challenge_Salary"].ToString() == "5") { dr["Challenge_Salary"] = "12k~15k"; } else if (dr["Challenge_Salary"].ToString() == "6") { dr["Challenge_Salary"] = "15k以上"; } string strTemp = dr["Challenge_Position"].ToString(); if (strTemp.IndexOf(",") == -1) { //没逗号直接赋值 dr["Challenge_Position0"] = strTemp; } else { //有逗号就分割 string[] arrTemp = strTemp.Split(','); dr["Challenge_Position0"] = arrTemp[0].ToString(); dr["Challenge_Position1"] = arrTemp[1].ToString(); dr["Challenge_Position2"] = arrTemp[1].ToString(); } strTemp = dr["Challenge_Quiz_First"].ToString(); dr["Challenge_Quiz0"] = quiz.QuizName(strTemp); strTemp = dr["Challenge_Quiz_Sec"].ToString(); dr["Challenge_Quiz1"] = quiz.QuizName(strTemp); strTemp = dr["Challenge_Quiz_Third"].ToString(); dr["Challenge_Quiz2"] = quiz.QuizName(strTemp); } return(ds); }
public DataSet AllQuizInfo() { OxcoderIFactory.IFactory factory = new OxcoderFactory.SqlSeverFactory(); OxcoderIDAL.QuizInfoIDAL en = factory.getQuizInstance(); return(en.AllQuizInfo()); }
private DataSet AddPositionAndQuiz(DataSet ds) { OxcoderIFactory.IFactory factory = new OxcoderFactory.SqlSeverFactory(); OxcoderIDAL.QuizInfoIDAL quiz = factory.getQuizInstance(); DataColumn dc = new DataColumn(); dc.DataType = System.Type.GetType("System.String"); dc.ColumnName = "Challenge_Position0"; ds.Tables[0].Columns.Add(dc); dc = new DataColumn(); dc.DataType = System.Type.GetType("System.String"); dc.ColumnName = "Challenge_Position1"; ds.Tables[0].Columns.Add(dc); dc = new DataColumn(); dc.DataType = System.Type.GetType("System.String"); dc.ColumnName = "Challenge_Position2"; ds.Tables[0].Columns.Add(dc); dc = new DataColumn(); dc.DataType = System.Type.GetType("System.String"); dc.ColumnName = "Challenge_Quiz0"; ds.Tables[0].Columns.Add(dc); dc = new DataColumn(); dc.DataType = System.Type.GetType("System.String"); dc.ColumnName = "Challenge_Quiz1"; ds.Tables[0].Columns.Add(dc); dc = new DataColumn(); dc.DataType = System.Type.GetType("System.String"); dc.ColumnName = "Challenge_Quiz2"; ds.Tables[0].Columns.Add(dc); foreach (DataRow dr in ds.Tables[0].Rows) { if (dr["Challenge_Salary"].ToString() == "1") { dr["Challenge_Salary"] = "2k~5k"; } else if (dr["Challenge_Salary"].ToString() == "2") { dr["Challenge_Salary"] = "5k~8k"; } else if (dr["Challenge_Salary"].ToString() == "3") { dr["Challenge_Salary"] = "8k~10k"; } else if (dr["Challenge_Salary"].ToString() == "4") { dr["Challenge_Salary"] = "10k~12k"; } else if (dr["Challenge_Salary"].ToString() == "5") { dr["Challenge_Salary"] = "12k~15k"; } else if (dr["Challenge_Salary"].ToString() == "6") { dr["Challenge_Salary"] = "15k以上"; } string strTemp = dr["Challenge_Position"].ToString(); if (strTemp.IndexOf(",") == -1) { //没逗号直接赋值 dr["Challenge_Position0"] = strTemp; } else { //有逗号就分割 string[] arrTemp = strTemp.Split(','); dr["Challenge_Position0"] = arrTemp[0].ToString(); dr["Challenge_Position1"] = arrTemp[1].ToString(); dr["Challenge_Position2"] = arrTemp[1].ToString(); } strTemp = dr["Challenge_Quiz_First"].ToString(); dr["Challenge_Quiz0"] = quiz.QuizName(strTemp); strTemp = dr["Challenge_Quiz_Sec"].ToString(); dr["Challenge_Quiz1"] = quiz.QuizName(strTemp); strTemp = dr["Challenge_Quiz_Third"].ToString(); dr["Challenge_Quiz2"] = quiz.QuizName(strTemp); } return ds; }
public DataSet QuizInfo(string id) { OxcoderIFactory.IFactory factory = new OxcoderFactory.SqlSeverFactory(); OxcoderIDAL.QuizInfoIDAL en = factory.getQuizInstance(); return en.QuizInfo(id); }