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 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());
}
