/*
* /// <summary>
* /// 分页获取数据列表
* /// </summary>
* public DataSet GetList(int PageSize,int PageIndex,string strWhere)
* {
* SqlParameter[] parameters = {
* new SqlParameter("@tblName", SqlDbType.VarChar, 255),
* new SqlParameter("@fldName", SqlDbType.VarChar, 255),
* new SqlParameter("@PageSize", SqlDbType.Int),
* new SqlParameter("@PageIndex", SqlDbType.Int),
* new SqlParameter("@IsReCount", SqlDbType.Bit),
* new SqlParameter("@OrderType", SqlDbType.Bit),
* new SqlParameter("@strWhere", SqlDbType.VarChar,1000),
* };
* parameters[0].Value = "月度考核内容_详细";
* parameters[1].Value = "id";
* parameters[2].Value = PageSize;
* parameters[3].Value = PageIndex;
* parameters[4].Value = 0;
* parameters[5].Value = 0;
* parameters[6].Value = strWhere;
* return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds");
* }*/
#endregion BasicMethod
#region ExtensionMethod
/// <summary>
///
/// </summary>
/// <param name="FK_月度考核"></param>
/// <param name="考核题目编号"></param>
/// <returns></returns>
public Eastcom.Model.月度考核内容_详细 GetModelByBH_YD(int FK_月度考核, int 考核题目编号)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,FK_月度考核内容,考核题目编号,题目编号,用户答案,回答情况,得分,提交时间,题目内容_原,A选项_原,B选项_原,C选项_原,D选项_原,其他选项_原,标准答案_原 from 月度考核内容_详细 ");
strSql.Append(" where FK_月度考核内容=@FK_月度考核内容 and 考核题目编号=@考核题目编号 ");
SqlParameter[] parameters =
{
new SqlParameter("@FK_月度考核内容", SqlDbType.Int, 4),
new SqlParameter("@考核题目编号", SqlDbType.Int, 4)
};
parameters[0].Value = FK_月度考核;
parameters[1].Value = 考核题目编号;
Eastcom.Model.月度考核内容_详细 model = new Eastcom.Model.月度考核内容_详细();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Eastcom.Model.月度考核内容_详细 model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into 月度考核内容_详细(");
strSql.Append("FK_月度考核内容,考核题目编号,题目编号,用户答案,回答情况,得分,提交时间,题目内容_原,A选项_原,B选项_原,C选项_原,D选项_原,其他选项_原,标准答案_原)");
strSql.Append(" values (");
strSql.Append("@FK_月度考核内容,@考核题目编号,@题目编号,@用户答案,@回答情况,@得分,@提交时间,@题目内容_原,@A选项_原,@B选项_原,@C选项_原,@D选项_原,@其他选项_原,@标准答案_原)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@FK_月度考核内容", SqlDbType.Int, 4),
new SqlParameter("@考核题目编号", SqlDbType.Int, 4),
new SqlParameter("@题目编号", SqlDbType.Int, 4),
new SqlParameter("@用户答案", SqlDbType.VarChar, 50),
new SqlParameter("@回答情况", SqlDbType.VarChar, 50),
new SqlParameter("@得分", SqlDbType.Decimal, 9),
new SqlParameter("@提交时间", SqlDbType.DateTime),
new SqlParameter("@题目内容_原", SqlDbType.NText),
new SqlParameter("@A选项_原", SqlDbType.VarChar, 5000),
new SqlParameter("@B选项_原", SqlDbType.VarChar, 5000),
new SqlParameter("@C选项_原", SqlDbType.VarChar, 5000),
new SqlParameter("@D选项_原", SqlDbType.VarChar, 5000),
new SqlParameter("@其他选项_原", SqlDbType.NText),
new SqlParameter("@标准答案_原", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.FK_月度考核内容;
parameters[1].Value = model.考核题目编号;
parameters[2].Value = model.题目编号;
parameters[3].Value = model.用户答案;
parameters[4].Value = model.回答情况;
parameters[5].Value = model.得分;
parameters[6].Value = model.提交时间;
parameters[7].Value = model.题目内容_原;
parameters[8].Value = model.A选项_原;
parameters[9].Value = model.B选项_原;
parameters[10].Value = model.C选项_原;
parameters[11].Value = model.D选项_原;
parameters[12].Value = model.其他选项_原;
parameters[13].Value = model.标准答案_原;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
///
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
private string CommonModel(Eastcom.Model.月度考核内容_详细 model)
{
StringBuilder str = new StringBuilder();
string 我的选项_A = Request.Params["ck_answer_A"] ?? "";
string 我的选项_B = Request.Params["ck_answer_B"] ?? "";
string 我的选项_C = Request.Params["ck_answer_C"] ?? "";
string 我的选项_D = Request.Params["ck_answer_D"] ?? "";
string 我的选项_E = Request.Params["ck_answer_E"] ?? "";
model.用户答案 = 我的选项_A + "," + 我的选项_B + "," + 我的选项_C + "," + 我的选项_D + "," + 我的选项_E;
model.回答情况 = "";
model.得分 = 0;
model.提交时间 = DateTime.Now;
return(str.ToString());
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Eastcom.Model.月度考核内容_详细 GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from 月度考核内容_详细 ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
Eastcom.Model.月度考核内容_详细 model = new Eastcom.Model.月度考核内容_详细();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Eastcom.Model.月度考核内容_详细 model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update 月度考核内容_详细 set ");
strSql.Append("FK_月度考核内容=@FK_月度考核内容,");
strSql.Append("考核题目编号=@考核题目编号,");
strSql.Append("题目编号=@题目编号,");
strSql.Append("用户答案=@用户答案,");
strSql.Append("回答情况=@回答情况,");
strSql.Append("得分=@得分,");
strSql.Append("提交时间=@提交时间,");
strSql.Append("题目内容_原=@题目内容_原,");
strSql.Append("A选项_原=@A选项_原,");
strSql.Append("B选项_原=@B选项_原,");
strSql.Append("C选项_原=@C选项_原,");
strSql.Append("D选项_原=@D选项_原,");
strSql.Append("其他选项_原=@其他选项_原,");
strSql.Append("标准答案_原=@标准答案_原");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@FK_月度考核内容", SqlDbType.Int, 4),
new SqlParameter("@考核题目编号", SqlDbType.Int, 4),
new SqlParameter("@题目编号", SqlDbType.Int, 4),
new SqlParameter("@用户答案", SqlDbType.VarChar, 50),
new SqlParameter("@回答情况", SqlDbType.VarChar, 50),
new SqlParameter("@得分", SqlDbType.Decimal, 9),
new SqlParameter("@提交时间", SqlDbType.DateTime),
new SqlParameter("@题目内容_原", SqlDbType.NText),
new SqlParameter("@A选项_原", SqlDbType.VarChar, 5000),
new SqlParameter("@B选项_原", SqlDbType.VarChar, 5000),
new SqlParameter("@C选项_原", SqlDbType.VarChar, 5000),
new SqlParameter("@D选项_原", SqlDbType.VarChar, 5000),
new SqlParameter("@其他选项_原", SqlDbType.NText),
new SqlParameter("@标准答案_原", SqlDbType.VarChar, 50),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.FK_月度考核内容;
parameters[1].Value = model.考核题目编号;
parameters[2].Value = model.题目编号;
parameters[3].Value = model.用户答案;
parameters[4].Value = model.回答情况;
parameters[5].Value = model.得分;
parameters[6].Value = model.提交时间;
parameters[7].Value = model.题目内容_原;
parameters[8].Value = model.A选项_原;
parameters[9].Value = model.B选项_原;
parameters[10].Value = model.C选项_原;
parameters[11].Value = model.D选项_原;
parameters[12].Value = model.其他选项_原;
parameters[13].Value = model.标准答案_原;
parameters[14].Value = model.id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Eastcom.Model.月度考核内容_详细 DataRowToModel(DataRow row)
{
Eastcom.Model.月度考核内容_详细 model = new Eastcom.Model.月度考核内容_详细();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["FK_月度考核内容"] != null && row["FK_月度考核内容"].ToString() != "")
{
model.FK_月度考核内容 = int.Parse(row["FK_月度考核内容"].ToString());
}
if (row["考核题目编号"] != null && row["考核题目编号"].ToString() != "")
{
model.考核题目编号 = int.Parse(row["考核题目编号"].ToString());
}
if (row["题目编号"] != null && row["题目编号"].ToString() != "")
{
model.题目编号 = int.Parse(row["题目编号"].ToString());
}
if (row["用户答案"] != null && row["用户答案"].ToString() != "")
{
model.用户答案 = (row["用户答案"].ToString());
}
if (row["回答情况"] != null)
{
model.回答情况 = row["回答情况"].ToString();
}
if (row["得分"] != null && row["得分"].ToString() != "")
{
model.得分 = decimal.Parse(row["得分"].ToString());
}
if (row["提交时间"] != null && row["提交时间"].ToString() != "")
{
model.提交时间 = DateTime.Parse(row["提交时间"].ToString());
}
if (row["题目内容_原"] != null)
{
model.题目内容_原 = row["题目内容_原"].ToString();
}
if (row["A选项_原"] != null)
{
model.A选项_原 = row["A选项_原"].ToString();
}
if (row["B选项_原"] != null)
{
model.B选项_原 = row["B选项_原"].ToString();
}
if (row["C选项_原"] != null)
{
model.C选项_原 = row["C选项_原"].ToString();
}
if (row["D选项_原"] != null)
{
model.D选项_原 = row["D选项_原"].ToString();
}
if (row["其他选项_原"] != null)
{
model.其他选项_原 = row["其他选项_原"].ToString();
}
if (row["标准答案_原"] != null)
{
model.标准答案_原 = row["标准答案_原"].ToString();
}
}
return(model);
}
/// <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()
}
});
}
/// <summary>
///
/// </summary>
private void InitData()
{
Eastcom.Model.月度考核内容_详细 model2 = new Eastcom.Model.月度考核内容_详细();
if (FK_YDKHNR != "")
{
model2 = new Eastcom.BLL.月度考核内容_详细().GetModelByBH_YD(CommonClass.StringHander.Common.GetInt(FK_YDKHNR), CommonClass.StringHander.Common.GetInt(id, 0));
if (model2 == null)
{
throw new Exception("对不起,本月你未生成考题或输入错误的题目序号,请刷新!");
}
else
{
if (!string.IsNullOrEmpty(model2.用户答案))
{
string[] 用户答案 = model2.用户答案.Split(',');
if (用户答案 != null)
{
for (int i = 0; i < 用户答案.Length; i++)
{
switch (用户答案[i])
{
case "A": ck_answer_A.Checked = true; break;
case "B": ck_answer_B.Checked = true; break;
case "C": ck_answer_C.Checked = true; break;
case "D": ck_answer_D.Checked = true; break;
case "E": ck_answer_E.Checked = true; break;
default:; break;
}
}
}
}
}
}
string 题目编号 = model2.题目编号.ToString();
if (题目编号 != "")
{
//Eastcom.Model.考试题库 model = new Eastcom.Model.考试题库();
//model = new Eastcom.BLL.考试题库().GetModel(CommonClass.StringHander.Common.GetInt(题目编号));
//if (model != null)
//{
TitleNo = id;
Answer_A = model2.A选项_原;
Answer_B = model2.B选项_原;
Answer_C = model2.C选项_原;
Answer_D = model2.D选项_原;
Answer_E = model2.其他选项_原;
if (string.IsNullOrEmpty(Answer_A))
{
ck_answer_A.Disabled = true;
}
if (string.IsNullOrEmpty(Answer_B))
{
ck_answer_B.Disabled = true;
}
if (string.IsNullOrEmpty(Answer_C))
{
ck_answer_C.Disabled = true;
}
if (string.IsNullOrEmpty(Answer_D))
{
ck_answer_D.Disabled = true;
}
if (!string.IsNullOrEmpty(Answer_E))
{
hid_OtherOption.Value = "E";
}
Title_ASK = model2.题目内容_原;
//}
}
else
{
throw new Exception("您这个月未生成考题.");
}
SetBindBtn();
}
