//增加编程的综合题，返回PID
//如果不需要Input的话，就new一个新的List<List<string>>作为Input
public int AddProgram(string PContent, ProgramPType Type, PLanguage Language, int Unit,int PLevel)
{
int PID = -1;
int blankIdx;
List<SqlParameter> ddlparam = new List<SqlParameter>();
ddlparam.Add(CreateParam("@PID", SqlDbType.Int, 0, PID, ParameterDirection.Output));
ddlparam.Add(CreateParam("@PContent", SqlDbType.VarChar, 500, PContent, ParameterDirection.Input));
ddlparam.Add(CreateParam("@Type", SqlDbType.Int, 0, Convert.ToInt32(Type), ParameterDirection.Input));
ddlparam.Add(CreateParam("@Language", SqlDbType.Int, 0, Convert.ToInt32(Language), ParameterDirection.Input));
ddlparam.Add(CreateParam("@Unit", SqlDbType.Int, 0, Unit, ParameterDirection.Input));
ddlparam.Add(CreateParam("@PLevel", SqlDbType.Int, 0, PLevel, ParameterDirection.Input));
try
{
RunProc("AddProgram", ddlparam);
PID = Convert.ToInt32(ddlparam[0].Value);
}
catch (SqlException e)
{
Console.WriteLine(e.ToString());
return -1;
}
return PID;
}
private void btnBrowser_Click(object sender, EventArgs e)
{
if (ofdBrowser.ShowDialog() == DialogResult.OK)
{
tbProblemFile.Text = ofdBrowser.FileName;
BlankCount = InfoControl.coutnAnswer(tbProblemFile.Text);
switch (Path.GetExtension(ofdBrowser.FileName).ToLower())
{
case ".c":
language = PLanguage.C;
break;
case ".cpp":
language = PLanguage.CPP;
break;
case ".vb":
language = PLanguage.VB;
break;
default:
language = PLanguage.Null;
break;
}
}
}
public void UpdateProgram(int PID, ProgramPType Type, PLanguage Language, int Unit, int PLevel)
{
List<SqlParameter> dp = new List<SqlParameter>();
dp.Add(CreateParam("@PID", SqlDbType.Int, 0, PID, ParameterDirection.Input));
dp.Add(CreateParam("@Type", SqlDbType.Int, 0, (int)Type, ParameterDirection.Input));
dp.Add(CreateParam("@Language", SqlDbType.Int, 0, (int)Language, ParameterDirection.Input));
dp.Add(CreateParam("@Unit", SqlDbType.Int, 0, Unit, ParameterDirection.Input));
dp.Add(CreateParam("@PLevel", SqlDbType.Int, 0, PLevel, ParameterDirection.Input));
try
{
RunProc("UpdateProgram", dp);
}
catch (SqlException ex)
{
Console.WriteLine(ex.ToString());
}
}
/*
public ProgramProblem FindProgramByPID(int PID)
{
List<ProgramProblem> result = new List<ProgramProblem>();
DataSet Ds = new DataSet();
ProgramProblem res;
List<SqlParameter> dp = new List<SqlParameter>();
dp.Add(CreateParam("@PID", SqlDbType.Int, 0, PID, ParameterDirection.Input));
try
{
RunProc("FindProgramByPID", dp, Ds);
result = DataSetToListProgram(Ds);
}
catch (SqlException ex)
{
Console.WriteLine(ex.ToString());
}
if (result.Count > 0)
{
res = result[0];
if (res.Type == ProgramPType.Completion)
return (PCompletion)res;
else if (res.Type == ProgramPType.Modify)
return (PModif)res;
else
return (PFunction)res;
}
return result;
}
*/
public List<ProgramProblem> FindAllProgram(string PContent, ProgramPType Type, PLanguage Language, int Unit, int CourseId, int PLevel,
int PageIndex, int PageSize)
{
List<ProgramProblem> result = new List<ProgramProblem>();
DataSet Ds = new DataSet();
List<SqlParameter> dp = new List<SqlParameter>();
dp.Add(CreateParam("@tableName", SqlDbType.VarChar, 50, "Program_Table", ParameterDirection.Input));
dp.Add(CreateParam("@PContent", SqlDbType.VarChar, 9999, PContent, ParameterDirection.Input));
dp.Add(CreateParam("@Type", SqlDbType.Int, 0, (int)Type, ParameterDirection.Input));
dp.Add(CreateParam("@Language", SqlDbType.Int, 0, (int)Language, ParameterDirection.Input));
dp.Add(CreateParam("@Unit", SqlDbType.Int, 0, Unit, ParameterDirection.Input));
dp.Add(CreateParam("@CourseId", SqlDbType.Int, 0, CourseId, ParameterDirection.Input));
dp.Add(CreateParam("@PLevel", SqlDbType.Int, 0, PLevel, ParameterDirection.Input));
dp.Add(CreateParam("@PageIndex", SqlDbType.Int, 0, PageIndex, ParameterDirection.Input));
dp.Add(CreateParam("@PageSize", SqlDbType.Int, 0, PageSize, ParameterDirection.Input));
try
{
RunProc("FindItems", dp, Ds);
result = DataSetToListProgram(Ds);
}
catch (SqlException ex)
{
Console.WriteLine(ex.ToString());
}
return result;
}
private void SetLanguage()
{
switch (Path.GetExtension(tbProblemFile.Text).ToLower())
{
case ".c":
language = PLanguage.C;
break;
case ".cpp":
language = PLanguage.CPP;
break;
case ".vb":
language = PLanguage.VB;
break;
default:
language = PLanguage.Null;
break;
}
}
