/// <summary>
///
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
private string CommonModel(Eastcom.Model.错题提交信息 model)
{
StringBuilder str = new StringBuilder();
model.FK_考试题库 = FK_ID;
model.错误提交信息 = Request.Params["area_Err"].Trim();
model.提交人 = Submiter;
model.提交时间 = CommonClass.StringHander.Common.GetDateTime(SubmitTime);
Eastcom.Model.考试题库 考题 = new Eastcom.Model.考试题库();
考题 = new Eastcom.BLL.考试题库().GetModel(CommonClass.StringHander.Common.GetInt(FK_ID));
if (考题 != null)
{
model.题目信息 = 考题.题目内容;
model.答案信息 = 考题.标准答案;
}
return(str.ToString());
}
public void btn_Save_Click(object sender, EventArgs e)
{
List <Eastcom.Model.考试题库> modlelist = new List <Eastcom.Model.考试题库>();
modlelist = new Eastcom.BLL.考试题库().GetModelList("");
foreach (Eastcom.Model.考试题库 m in modlelist)
{
string 标准答案 = "";
标准答案 = m.标准答案2.ToUpper();
标准答案 = 标准答案.Replace("A", "A,");
标准答案 = 标准答案.Replace("B", "B,");
标准答案 = 标准答案.Replace("C", "C,");
标准答案 = 标准答案.Replace("D", "D,");
标准答案 = 标准答案.Replace("E", "E,");
m.标准答案 = 标准答案;
new Eastcom.BLL.考试题库().Update(m);
}
}
public bool Update标准答案()
{
List <Eastcom.Model.考试题库> modlelist = new List <Eastcom.Model.考试题库>();
modlelist = new Eastcom.BLL.考试题库().GetModelList("");
foreach (Eastcom.Model.考试题库 m in modlelist)
{
string 标准答案 = "";
标准答案 = m.标准答案2.ToUpper();
标准答案 = 标准答案.Replace("A", "A,");
标准答案 = 标准答案.Replace("B", "B,");
标准答案 = 标准答案.Replace("C", "C,");
标准答案 = 标准答案.Replace("D", "D,");
标准答案 = 标准答案.Replace("E", "E,");
m.标准答案 = 标准答案;
if (!new Eastcom.BLL.考试题库().Update(m))
{
return(false);
}
}
return(true);
}
/// <summary>
///
/// </summary>
public void AjaxMethod()
{
Eastcom.BLL.月度考核内容_详细 BLL_model_详细 = new Eastcom.BLL.月度考核内容_详细();
Eastcom.BLL.月度考核内容 BLL_model_列表 = new Eastcom.BLL.月度考核内容();
Eastcom.Model.月度考核内容_详细 model_详细 = null;
Eastcom.Model.月度考核内容 model_列表 = null;
StringBuilder strMsg = new StringBuilder();
int isReload = 0;//0:不刷新父页面 1：刷新父页面
bool IsError = false;
switch (handleType) //this.PageType
{
case "Save":
#region 保存
model_详细 = BLL_model_详细.GetModelByBH_YD(CommonClass.StringHander.Common.GetInt(FK_YDKHNR), CommonClass.StringHander.Common.GetInt(id));
strMsg.Append(this.CommonModel(model_详细));
if (strMsg.Length == 0)
{
if (BLL_model_详细.Update(model_详细))
{
IsError = false;
strMsg.Append("");
Get考核月份();
}
else
{
IsError = true;
strMsg.Append("更新失败");
}
}
else
{
IsError = false;
}
#endregion
break;
case "Submit":
#region 提交
List <Eastcom.Model.月度考核内容_详细> ModelList = new List <Eastcom.Model.月度考核内容_详细>();
ModelList = BLL_model_详细.GetModelList("FK_月度考核内容='" + FK_YDKHNR + "'");
model_列表 = BLL_model_列表.GetModel(Common.GetInt(FK_YDKHNR));
decimal 总得分 = 0;
if (undoneid != 0)
{
IsError = true;
strMsg.Append("你还有未完成的题!");
}
else
{
foreach (Eastcom.Model.月度考核内容_详细 m in ModelList)
{
string 用户答案 = m.用户答案 == "" ? ",,," : m.用户答案;
Eastcom.Model.考试题库 model_题库 = new Eastcom.Model.考试题库();
model_题库 = new Eastcom.BLL.考试题库().GetModel(Common.GetInt(m.题目编号));
if (model_题库 != null)
{
UserPoint c = new UserPoint();
c = c.Get用户得分情况(用户答案, model_题库.标准答案.Trim());
m.得分 = c.用户得分;
m.回答情况 = c.得分情况;
BLL_model_详细.Update(m);
总得分 += Common.GetDecimal(m.得分);
}
}
}
model_列表.得分 = 总得分;
model_列表.提交时间 = DateTime.Now;
model_列表.提交情况 = Eastcom.ConfigUntility.ConfigArgs.提交情况.已提交.ToString();
//strMsg.Append(this.CommonModel(model_详细));
if (strMsg.Length == 0)
{
if (BLL_model_列表.Update(model_列表))
{
IsError = false;
strMsg.Append("提交成功");
}
else
{
IsError = true;
strMsg.Append("更新失败");
}
}
else
{
IsError = true;
}
#endregion
break;
default:
strMsg.Append("页面操作类型不明确，操作失败！");
break;
}
CommonClass.Message.Log.WriteMessage(new CommonClass.Message.GoAjaxPara()
{
msg = strMsg.ToString(),
isReload = isReload,
isError = IsError,
msnLog = "",
Data = new ExamId()
{
nextid = nextid.ToString(), preid = preid.ToString(), Undoneid = undoneid.ToString()
}
});
}
protected void Upload1_Click(object sender, EventArgs e)
{
if (FileUpload1.HasFile)
{
Lbl_Messaage.Text = "";
Label_1.Text = "";
#region
string fileExt = System.IO.Path.GetExtension(FileUpload1.FileName);
if (fileExt == ".xls" || fileExt == ".xlsx")
{
#region
try
{
string newname = System.DateTime.Now.ToString("yyyyMMddHHmmssffff");//重命名
newname += ".xls";
FileUpload1.SaveAs(Server.MapPath("excel") + "\\" + newname);
string filename = (Server.MapPath("excel") + "\\" + newname).ToString();
if (filename != "")
{
try
{
DataTable dt = CommonClass.DataHandler.ExcelToData.ReadExcelToTable(filename, 0);
#region 插入
Eastcom.BLL.考试题库 bll = new Eastcom.BLL.考试题库();
int success = 0, error = 0;
string ErrorMsg = "";
DateTime now = DateTime.Now;
/*添加备份*/
string RealName = "";
if (CurrentUserModel != null)
{
RealName = CurrentUserModel.RealName;
}
bll.AddHisBak(now, RealName.ToString());
bll.ExecuteTrunCate();
for (int i = 0; i < dt.Rows.Count; i++)
{
try
{
string 题目内容 = dt.Rows[i]["题目内容"].ToString().Trim();
string 项A = dt.Rows[i]["选项A"].ToString().Trim();
string 项B = dt.Rows[i]["选项B"].ToString().Trim();
string 项C = dt.Rows[i]["选项C"].ToString().Trim();
string 项D = dt.Rows[i]["选项D"].ToString().Trim();
string 项E = dt.Rows[i]["选项E"].ToString().Trim();
string 标准答案 = dt.Rows[i]["答案"].ToString().Trim();
//string 标准答案2 = dt.Rows[i]["标准答案2"].ToString().Trim();
Eastcom.Model.考试题库 model = new Eastcom.Model.考试题库();
model.题目内容 = 题目内容;
model.A选项 = 项A;
model.B选项 = 项B;
model.C选项 = 项C;
model.D选项 = 项D;
model.其他选项 = 项E;
//model.标准答案 = 标准答案;
model.标准答案2 = 标准答案;
bll.Add(model);
success++;
}
catch
{
ErrorMsg += "第" + (i + 1) + "行数据录入出错<br>";
error++;
}
}
bll.Update标准答案();
if (error == 0)
{
Lbl_Messaage.Text = success.ToString() + "条导入成功";
Lbl_Messaage.ForeColor = System.Drawing.Color.Green;
}
else
{
Lbl_Messaage.Text = success.ToString() + "条导入成功," + error.ToString()
+ "条导入失败.失败数据请修改后重新导入！<BR>" + ErrorMsg;
Lbl_Messaage.ForeColor = System.Drawing.Color.Red;
}
#endregion
}
catch (Exception ex)
{
Eastcom.Common.MessageBox.Show(this, "导入失败");
}
}
}
catch (Exception ex)
{
Label_1.Text = "ERROR: " + ex.Message.ToString();
Label_1.ForeColor = System.Drawing.Color.Red;
}
#endregion
}
else
{
Label_1.Text = "只能上传Excel文件！";
Label_1.ForeColor = System.Drawing.Color.Red;
}
#endregion
}
else
{
Label_1.Text = "请选择一个Excel文件。";
Label_1.ForeColor = System.Drawing.Color.Red; //字体为 红色 System.Drawing.Color.Red
}
}
