public static new List<Question> MyPaper(int MID, int Year, int Type)
{
var l = new List<Question>();
try
{
SqlParameter[] param =
{
new SqlParameter("@MID",MID),
new SqlParameter("@Year",Year),
new SqlParameter("@Type",Type)
};
var dr = SqlHelper.ExecuteReader(SqlHelper.Local, CommandType.StoredProcedure, "Get_MyPaper", param);
while (dr.Read())
{
var m = new Question();
m.QID = Convert.ToInt32(dr["QID"]);
//m.CID = Convert.ToInt32(dr["CID"]);
m.Subject = Convert.ToString(dr["Subject"]);
m.Answer = Convert.ToString(dr["Answer"]);
m.Score = Convert.ToInt32(dr["Score"]);
m.Cate = Convert.ToInt32(dr["Cate"]);
if (DBNull.Value != dr["A"])
m.A = Convert.ToString(dr["A"]);
if (DBNull.Value != dr["B"])
m.B = Convert.ToString(dr["B"]);
if (DBNull.Value != dr["C"])
m.C = Convert.ToString(dr["C"]);
if (DBNull.Value != dr["D"])
m.D = Convert.ToString(dr["D"]);
l.Add(m);
}
dr.Close();
}
catch (Exception ex)
{
log.Fatal(ex.Message);
log.FatalException(ex.Message, ex);
}
return l;
}
public static R Question(Question info)
{
var m = new R();
try
{
SqlParameter[] param =
{
new SqlParameter("@CName",info.CName),
new SqlParameter("@Subject",info.Subject),
new SqlParameter("@A",info.A),
new SqlParameter("@B",info.B),
new SqlParameter("@C",info.C),
new SqlParameter("@D",info.D),
new SqlParameter("@Answer",info.Answer),
new SqlParameter("@Score",info.Score),
new SqlParameter("@Cate",info.Cate)
};
//param[0].Direction = ParameterDirection.InputOutput;
string SQL = @"INSERT INTO [Question]
([CName]
,[Subject]
,[A]
,[B]
,[C]
,[D]
,[Answer]
,[Score]
,[Cate])
VALUES
(@CName
,@Subject
,@A
,@B
,@C
,@D
,@Answer
,@Score
,@Cate)";
var r = SqlHelper.ExecuteNonQuery(SqlHelper.Local, CommandType.Text, SQL, param);
m.Code = 0;
// m.Value = Convert.ToInt32(param[0].Value);
}
catch (Exception ex)
{
m.Code = 300;
m.Message = ex.Message;
log.Fatal(ex.Message);
log.FatalException(ex.Message, ex);
}
return m;
}
public static R Question(string excelPath)
{
var r = new R();
var ds = PreviewQuestion(excelPath);
var dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
var info = new Question();
info.CName = Convert.ToString(dr["CName"]);
info.Subject = Convert.ToString(dr["Subject"]);
info.A = Convert.ToString(dr["A"]);
info.B = Convert.ToString(dr["B"]);
info.C = Convert.ToString(dr["C"]);
info.D = Convert.ToString(dr["D"]);
info.Answer = Convert.ToString(dr["Answer"]);
info.Score = Convert.ToInt32(dr["Score"]);
info.Cate = Convert.ToInt32(dr["Cate"]);
DAL.M.Update.Question(info);
}
return r;
}
public static List<Question> MyPaperResult(int MID)
{
var l = new List<Question>();
try
{
SqlParameter[] param =
{
new SqlParameter("@MID",MID)
//new SqlParameter("@Year",Year),
//new SqlParameter("@Type",Type)
};
string SQL = @"
SELECT q.*,my_Answer=myq.Answer,my_status=myq.Status
FROM dbo.My_Question myq
INNER JOIN dbo.Question q ON myq.QID = q.QID
WHERE myq.MID = @MID
ORDER BY myq.ID ASC
";
var dr = SqlHelper.ExecuteReader(C.conn, CommandType.Text, SQL, param);
while (dr.Read())
{
var m = new Question();
m.QID = Convert.ToInt32(dr["QID"]);
//m.CID = Convert.ToInt32(dr["CID"]);
m.Subject = Convert.ToString(dr["Subject"]);
m.Answer = Convert.ToString(dr["Answer"]);
m.Score = Convert.ToInt32(dr["Score"]);
m.Cate = Convert.ToInt32(dr["Cate"]);
if (DBNull.Value != dr["A"])
m.A = Convert.ToString(dr["A"]);
if (DBNull.Value != dr["B"])
m.B = Convert.ToString(dr["B"]);
if (DBNull.Value != dr["C"])
m.C = Convert.ToString(dr["C"]);
if (DBNull.Value != dr["D"])
m.D = Convert.ToString(dr["D"]);
l.Add(m);
}
dr.Close();
}
catch (Exception ex)
{
log.Fatal(ex.Message);
log.FatalException(ex.Message, ex);
}
return l;
}