/// <summary>
/// 得到一个对象实体
/// </summary>
public Eastcom.Model.月度考核内容 GetModelByUser(int FK_User, DateTime 考核月份)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,FK_UserID,月份,考务生成时间,提交时间,回答情况,得分,提交情况 from 月度考核内容 ");
strSql.Append(" where FK_UserID=@FK_UserID and 月份=@月份");
SqlParameter[] parameters =
{
new SqlParameter("@FK_UserID", SqlDbType.Int, 4),
new SqlParameter("@月份", SqlDbType.DateTime)
};
parameters[0].Value = FK_User;
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 bool Update(Eastcom.Model.月度考核内容 model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update 月度考核内容 set ");
strSql.Append("FK_UserID=@FK_UserID,");
strSql.Append("月份=@月份,");
strSql.Append("考务生成时间=@考务生成时间,");
strSql.Append("提交时间=@提交时间,");
strSql.Append("回答情况=@回答情况,");
strSql.Append("得分=@得分,");
strSql.Append("提交情况=@提交情况 ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@FK_UserID", SqlDbType.Int, 4),
new SqlParameter("@月份", SqlDbType.DateTime),
new SqlParameter("@考务生成时间", SqlDbType.DateTime),
new SqlParameter("@提交时间", SqlDbType.DateTime),
new SqlParameter("@回答情况", SqlDbType.VarChar, 50),
new SqlParameter("@得分", SqlDbType.Decimal, 9),
new SqlParameter("@提交情况", SqlDbType.VarChar, 50),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.FK_UserID;
parameters[1].Value = model.月份;
if (model.考务生成时间 != DateTime.MinValue)
{
parameters[2].Value = model.考务生成时间;
}
else
{
parameters[2].Value = DBNull.Value;
}
if (model.提交时间 != DateTime.MinValue)
{
parameters[3].Value = model.提交时间;
}
else
{
parameters[3].Value = DBNull.Value;
}
parameters[4].Value = model.回答情况;
parameters[5].Value = model.得分;
parameters[6].Value = model.提交情况;
parameters[7].Value = model.id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public string GetHTMLValue(string CheckYear, string CheckMonth, string BeChecked_FK_ID, string User_RealName)
{
string returnValue = "";
string[] GetIsExistCheckedValue = new string[2];
GetIsExistCheckedValue = IsExistChecked(CheckYear, CheckMonth, BeChecked_FK_ID, User_RealName);
if (GetIsExistCheckedValue[0] == "error")
{
returnValue += "<li class='ColorRed'>" + GetIsExistCheckedValue[1] + "</li>";
}
else
{
Eastcom.Model.月度考核内容 model = new Eastcom.Model.月度考核内容();
model.FK_UserID = int.Parse(BeChecked_FK_ID);/*被考核人员的ID*/
model.月份 = Convert.ToDateTime(CheckYear + "-" + CheckMonth);
model.得分 = 0;
model.考务生成时间 = DateTime.Now;
model.提交情况 = Config.ConfigArgs.提交情况.未提交.ToString();
/*提交月度考核内容 也要生成模板 */
if (new Eastcom.BLL.月度考核内容().Add_Tran(model) > 0)//添加方法 ZQTS.BLL.MaintianManage_Month_Main_Info()
{
returnValue += "<li class='ColorGreen'>" + GetIsExistCheckedValue[1] + "</li>";
}
}
return(returnValue);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Eastcom.Model.月度考核内容 model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into 月度考核内容(");
strSql.Append("FK_UserID,月份,考务生成时间,提交时间,回答情况,得分,提交情况)");
strSql.Append(" values (");
strSql.Append("@FK_UserID,@月份,@考务生成时间,@提交时间,@回答情况,@得分,@提交情况)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@FK_UserID", SqlDbType.Int, 4),
new SqlParameter("@月份", SqlDbType.DateTime),
new SqlParameter("@考务生成时间", SqlDbType.DateTime),
new SqlParameter("@提交时间", SqlDbType.DateTime),
new SqlParameter("@回答情况", SqlDbType.VarChar, 50),
new SqlParameter("@得分", SqlDbType.Decimal, 9),
new SqlParameter("@提交情况", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.FK_UserID;
parameters[1].Value = model.月份;
if (model.考务生成时间 != DateTime.MinValue)
{
parameters[2].Value = model.考务生成时间;
}
else
{
parameters[2].Value = DBNull.Value;
}
if (model.提交时间 != DateTime.MinValue)
{
parameters[3].Value = model.提交时间;
}
else
{
parameters[3].Value = DBNull.Value;
}
parameters[4].Value = model.回答情况;
parameters[5].Value = model.得分;
parameters[6].Value = model.提交情况;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <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_UserID"] != null && row["FK_UserID"].ToString() != "")
{
model.FK_UserID = int.Parse(row["FK_UserID"].ToString());
}
if (row["月份"] != null && row["月份"].ToString() != "")
{
model.月份 = DateTime.Parse(row["月份"].ToString());
}
if (row["考务生成时间"] != null && row["考务生成时间"].ToString() != "")
{
model.考务生成时间 = DateTime.Parse(row["考务生成时间"].ToString());
}
if (row["提交时间"] != null && row["提交时间"].ToString() != "")
{
model.提交时间 = DateTime.Parse(row["提交时间"].ToString());
}
if (row["回答情况"] != null)
{
model.回答情况 = row["回答情况"].ToString();
}
if (row["得分"] != null && row["得分"].ToString() != "")
{
model.得分 = decimal.Parse(row["得分"].ToString());
}
if (row["提交情况"] != null)
{
model.提交情况 = row["提交情况"].ToString();
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Eastcom.Model.月度考核内容 GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,FK_UserID,月份,考务生成时间,提交时间,回答情况,得分,提交情况 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 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()
}
});
}
public void AjaxMethod()
{
Eastcom.BLL.月度考核内容 BLL_model_列表 = new Eastcom.BLL.月度考核内容();
Eastcom.Model.月度考核内容 model_列表 = null;
StringBuilder strMsg = new StringBuilder();
int isReload = 0;//0:不刷新父页面 1：刷新父页面
bool IsError = false;
switch (handleType) //this.PageType
{
case "See":
#region 查看
//model_详细 = BLL_model_详细.GetModelByBH_YD(CommonClass.StringHander.Common.GetInt(FK_YDKHNR), CommonClass.StringHander.Common.GetInt(id));
model_列表 = BLL_model_列表.GetModelByUser(CurrentUserModel.UserID, CommonClass.StringHander.Common.GetDateTime(Request.Params["ddl_Year_Month"] ?? ""));
if (model_列表 == null)
{
IsError = true;
strMsg.Append(Request.Params["ddl_Year_Month"] + ",您没有考核模板");
}
//strMsg.Append(this.CommonModel(model_详细));
if (strMsg.Length == 0)
{
strMsg.Append(Request.Params["ddl_Year_Month"]);
//if (BLL_model_详细.Update(model_详细))
//{
// IsError = false;
// strMsg.Append("");
// Get考核月份();
//}
//else
//{
// IsError = true;
// strMsg.Append("更新失败");
//}
}
#endregion
break;
case "Change":
#region 查看
model_列表 = BLL_model_列表.GetModelByUser(CurrentUserModel.UserID, CommonClass.StringHander.Common.GetDateTime(Request.Params["ddl_Year_Month"] ?? ""));
if (model_列表 == null)
{
IsError = true;
strMsg.Append(Request.Params["ddl_Year_Month"] + ",您没有考核模板");
}
if (strMsg.Length == 0)
{
if (model_列表.提交情况 == Config.ConfigArgs.提交情况.已提交.ToString())
{
strMsg.Append(model_列表.得分);
}
else
{
strMsg.Append(model_列表.提交情况);
}
}
else
{
IsError = false;
}
#endregion
break;
case "See_ASK_TEST":
#region 进入练习模式
Eastcom.Model.日度练习考核内容 model = new Eastcom.Model.日度练习考核内容();
string 练习日期 = DateTime.Now.ToShortDateString();
int Fk_userID = CurrentUserModel.UserID;
if (!new Eastcom.BLL.日度练习考核内容().Exists_Checked(练习日期, Fk_userID.ToString()))
{
Eastcom.Model.日度练习考核内容 练习model = new Eastcom.Model.日度练习考核内容();
model.FK_UserID = Fk_userID; /*被考核人员的ID*/
model.日期 = Convert.ToDateTime(练习日期);
model.考务生成时间 = DateTime.Now;
model.提交情况 = Config.ConfigArgs.提交情况.未提交.ToString();
if (new Eastcom.BLL.日度练习考核内容().Add_Tran(model) > 0) //添加方法 ZQTS.BLL.MaintianManage_Month_Main_Info()
{
}
}
else
{
//IsError = true;
//strMsg.Append("你未生成当天练习题，请重新点击生成练习数据！");
}
#endregion
break;
default:
strMsg.Append("页面操作类型不明确，操作失败！");
break;
}
CommonClass.Message.Log.WriteMessage(new CommonClass.Message.GoAjaxPara()
{
msg = strMsg.ToString(),
isReload = isReload,
isError = IsError,
msnLog = "",
Data = null
});
}
public void AjaxMethod()
{
Eastcom.BLL.月度考核内容 BLL_model_列表 = new Eastcom.BLL.月度考核内容();
Eastcom.Model.月度考核内容 model_列表 = null;
StringBuilder strMsg = new StringBuilder();
int isReload = 0;//0:不刷新父页面 1：刷新父页面
bool IsError = false;
switch (handleType) //this.PageType
{
case "See":
#region 查看
//model_详细 = BLL_model_详细.GetModelByBH_YD(CommonClass.StringHander.Common.GetInt(FK_YDKHNR), CommonClass.StringHander.Common.GetInt(id));
model_列表 = BLL_model_列表.GetModelByUser(CurrentUserModel.UserID, CommonClass.StringHander.Common.GetDateTime(Request.Params["ddl_Year_Month"] ?? ""));
if (model_列表 == null)
{
IsError = true;
strMsg.Append(Request.Params["ddl_Year_Month"] + ",您没有考核模板");
}
//strMsg.Append(this.CommonModel(model_详细));
if (strMsg.Length == 0)
{
strMsg.Append(Request.Params["ddl_Year_Month"]);
//if (BLL_model_详细.Update(model_详细))
//{
// IsError = false;
// strMsg.Append("");
// Get考核月份();
//}
//else
//{
// IsError = true;
// strMsg.Append("更新失败");
//}
}
#endregion
break;
case "Change":
#region 查看
model_列表 = BLL_model_列表.GetModelByUser(CurrentUserModel.UserID, CommonClass.StringHander.Common.GetDateTime(Request.Params["ddl_Year_Month"] ?? ""));
if (model_列表 == null)
{
IsError = true;
strMsg.Append(Request.Params["ddl_Year_Month"] + ",您没有考核模板");
}
if (strMsg.Length == 0)
{
if (model_列表.提交情况 == Config.ConfigArgs.提交情况.已提交.ToString())
{
strMsg.Append(model_列表.得分);
}
else
{
strMsg.Append(model_列表.提交情况);
}
}
else
{
IsError = false;
}
#endregion
break;
default:
strMsg.Append("页面操作类型不明确，操作失败！");
break;
}
CommonClass.Message.Log.WriteMessage(new CommonClass.Message.GoAjaxPara()
{
msg = strMsg.ToString(),
isReload = isReload,
isError = IsError,
msnLog = "",
Data = null
});
}
/// <summary>
/// 增加一条数据,及其子表数据
/// </summary>
public int Add_Tran(Eastcom.Model.月度考核内容 model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into 月度考核内容(");
strSql.Append("FK_UserID,月份,考务生成时间,提交时间,回答情况,得分,提交情况)");
strSql.Append(" values (");
strSql.Append("@FK_UserID,@月份,@考务生成时间,@提交时间,@回答情况,@得分,@提交情况)");
strSql.Append(";set @ReturnValue= @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@FK_UserID", SqlDbType.Int, 4),
new SqlParameter("@月份", SqlDbType.DateTime),
new SqlParameter("@考务生成时间", SqlDbType.DateTime),
new SqlParameter("@提交时间", SqlDbType.DateTime),
new SqlParameter("@回答情况", SqlDbType.VarChar, 50),
new SqlParameter("@得分", SqlDbType.Decimal, 9),
new SqlParameter("@提交情况", SqlDbType.VarChar, 50),
new SqlParameter("@ReturnValue", SqlDbType.Int)
};
parameters[0].Value = model.FK_UserID;
parameters[1].Value = model.月份;
if (model.考务生成时间 != DateTime.MinValue)
{
parameters[2].Value = model.考务生成时间;
}
else
{
parameters[2].Value = DBNull.Value;
}
if (model.提交时间 != DateTime.MinValue)
{
parameters[3].Value = model.提交时间;
}
else
{
parameters[3].Value = DBNull.Value;
}
parameters[4].Value = model.回答情况;
parameters[5].Value = model.得分;
parameters[6].Value = model.提交情况;
parameters[7].Direction = ParameterDirection.Output;
List <CommandInfo> sqllist = new List <CommandInfo>();
CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters);
sqllist.Add(cmd);
DbHelperSQL.ExecuteSqlTranWithIndentity(sqllist);
StringBuilder strSql2;
sqllist = new List <CommandInfo>();
List <Eastcom.Model.月度考核内容_详细> 月度考核内容_详细s = new List <Model.月度考核内容_详细>();
List <int> 考试题目 = Get题目编号((int)parameters[7].Value);
for (int i = 0; i < 20; i++)
{
Eastcom.Model.考试题库 考题model = new Eastcom.DAL.考试题库().GetModel(考试题目[i]);
月度考核内容_详细s.Add(new Eastcom.Model.月度考核内容_详细()
{
FK_月度考核内容 = (int)parameters[7].Value,
考核题目编号 = i + 1,
题目编号 = 考试题目[i], //随机获取,
得分 = 0,
题目内容_原 = 考题model.题目内容,
A选项_原 = 考题model.A选项,
B选项_原 = 考题model.B选项,
C选项_原 = 考题model.C选项,
D选项_原 = 考题model.D选项,
其他选项_原 = 考题model.其他选项,
标准答案_原 = 考题model.标准答案
});
}
foreach (Eastcom.Model.月度考核内容_详细 models in 月度考核内容_详细s)
{
strSql2 = new StringBuilder();
strSql2.Append("insert into 月度考核内容_详细(");
strSql2.Append("FK_月度考核内容,考核题目编号,题目编号,用户答案,回答情况,得分,提交时间,题目内容_原,A选项_原,B选项_原,C选项_原,D选项_原,其他选项_原,标准答案_原)");
strSql2.Append(" values (");
strSql2.Append("@FK_月度考核内容,@考核题目编号,@题目编号,@用户答案,@回答情况,@得分,@提交时间,@题目内容_原,@A选项_原,@B选项_原,@C选项_原,@D选项_原,@其他选项_原,@标准答案_原)");
SqlParameter[] parameters2 =
{
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)
};
parameters2[0].Value = models.FK_月度考核内容;
parameters2[1].Value = models.考核题目编号;
parameters2[2].Value = models.题目编号;
parameters2[3].Value = models.用户答案;
parameters2[4].Value = models.回答情况;
parameters2[5].Value = models.得分;
parameters2[6].Value = models.提交时间;
parameters2[7].Value = models.题目内容_原;
parameters2[8].Value = models.A选项_原;
parameters2[9].Value = models.B选项_原;
parameters2[10].Value = models.C选项_原;
parameters2[11].Value = models.D选项_原;
parameters2[12].Value = models.其他选项_原;
parameters2[13].Value = models.标准答案_原;
cmd = new CommandInfo(strSql2.ToString(), parameters2);
sqllist.Add(cmd);
}
DbHelperSQL.ExecuteSqlTranWithIndentity(sqllist);
return((int)parameters[7].Value);
}
