new public static Certificate Certificate(int MID)
{
var m = new Certificate();
try
{
SqlParameter[] param =
{
new SqlParameter("@MID",MID)
};
var dr = SqlHelper.ExecuteReader(C.conn, CommandType.StoredProcedure, "Get_Certificate", param);
if (dr.Read())
{
m.ID = Convert.ToInt32(dr["ID"]);
m.MID = Convert.ToInt32(dr["MID"]);
if (DBNull.Value != dr["CreateDate"])
m.CreateDate = Convert.ToDateTime(dr["CreateDate"]);
if (DBNull.Value != dr["BeginDate"])
m.BeginDate = Convert.ToDateTime(dr["BeginDate"]);
if (DBNull.Value != dr["EndDate"])
m.EndDate = Convert.ToDateTime(dr["EndDate"]);
if (DBNull.Value != dr["CertID"])
m.CertID = Convert.ToString(dr["CertID"]);
}
dr.Close();
}
catch (Exception ex)
{
log.Fatal(ex.Message);
log.Fatal(ex.StackTrace);
}
return m;
}
public ActionResult Certificate()
{
var report = DAL.Get.MyReport(Client.MID);
var reportFinish = report.FindAll(N => N.Score >= 60 && N.Minutes >= 1080);
var cert = new Certificate();
if (reportFinish.Count > 0)
{
DAL.Update.Certificate(Client.MID);
cert = DAL.Get.Certificate(Client.MID);
}
if (reportFinish.Count == 0)
{
GoMessage("您尚未获得合格证书，请继续学习。");
}
ViewData["report"] = reportFinish;
ViewData["cert"] = cert;
return View();
}
public ActionResult Certificate()
{
var member = DAL.Get.Member(Client.MID);
if (member.Level == -1)
{
string Url = "/Account/ProfilesEdit";
//Response.Redirect(Url);
GoMessage("您需要完善个人信息后，才可以打印证书。", Url);
}
var report = DAL.Get.MyReport(Client.MID);
var reportFinish = report.FindAll(N => N.Score >= 60 && N.Minutes >= 1080);
var cert = new Certificate();
if (reportFinish.Count > 0)
{
DAL.Update.Certificate(Client.MID);
cert = DAL.Get.Certificate(Client.MID);
}
if (reportFinish.Count == 0)
{
GoMessage("您尚未获得合格证书，请继续学习。");
}
ViewData["member"] = member;
ViewData["report"] = reportFinish;
ViewData["cert"] = cert;
return View();
}