/// <summary>
/// 提醒老师复位硬件设备，保存提示信息
/// </summary>
/// <param name="strDescription">提示内容，需要描述清楚</param>
/// <returns>EnumSubmitResult</returns>
public static EnumSubmitResult SaveDeviceResetTip(string strDescription)
{
JAAJ_DeviceResetTipInfo info = new JAAJ_DeviceResetTipInfo();
info.iStatus = 0;
info.nvcResetDescription = strDescription;
string strStoreProcedure = "JAAJ_DeviceResetTip_Save";
SqlDatabase odbDataBase = new SqlDatabase(connectionString);
DbCommand odbCommand = odbDataBase.GetStoredProcCommand(strStoreProcedure);
odbDataBase.AddInParameter(odbCommand, "@iResetID", System.Data.DbType.Int32, info.iResetID);
odbDataBase.AddInParameter(odbCommand, "@nvcResetDescription", System.Data.DbType.String, info.nvcResetDescription);
odbDataBase.AddInParameter(odbCommand, "@iStatus", System.Data.DbType.Int16, info.iStatus);
odbDataBase.AddOutParameter(odbCommand, "@result", System.Data.DbType.Int32, 8);
EnumSubmitResult enmResult = EnumSubmitResult.Failed;
using (IDbConnection connection = odbDataBase.CreateConnection())
{
connection.Open();
try
{
odbDataBase.ExecuteNonQuery(odbCommand);
int i = int.Parse(odbCommand.Parameters["@result"].Value.ToString());
enmResult = (EnumSubmitResult)i;
}
catch (Exception oeException)
{
//throw new Exception(oeException.Message, oeException);
}
connection.Close();
}
odbCommand.Dispose();
return(enmResult);
}
/// <summary>
/// 开始考试
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e)
{
#region 验证考试是否应该参与考试
JAAJ_ExamInfo oeiJAAJ_ExamInfo = ScoreData.GetCurrentExamInfo();
if (oeiJAAJ_ExamInfo != null)
{
oeiJAAJ_ExamineeInfo = ScoreData.GetExamineeInfoByIDNum(txtIDNum.Text.Trim(), oeiJAAJ_ExamInfo.nvcBatchNO);
if (oeiJAAJ_ExamineeInfo == null)
{
MessageBox.Show("不存在该考生信息", "提示");
return;
}
}
#endregion
#region 调出对应考试科目的试题显示在终端界面上
oepiExamProceInfo = ScoreData.GetExamProceInfoByExamineeID(oeiJAAJ_ExamineeInfo.iExamineeID);
if (oepiExamProceInfo != null)
{
int iSubjectItemID = oepiExamProceInfo.iSubjectItemID;
//下面代码可以根据科目子项ID调出对应的子项对应的试题.....
}
#endregion
#region 修改设备状态为忙碌状态
EnumSubmitResult oResult = ScoreData.UpdateDeviceStatus(1);
#endregion
}
/// <summary>
/// 更新设备状态为忙碌
/// </summary>
/// <param name="iStatus">0空闲，1忙碌</param>
/// <returns></returns>
public static EnumSubmitResult UpdateDeviceStatus(int iStatus)
{
EnumSubmitResult enmResult = EnumSubmitResult.Failed;
string strIP = GetLocalIP();
if (strIP != "")
{
JAAJ_DeviceInfo odiDeviceInfo = GetDeviceInfoByIP(strIP);
if (odiDeviceInfo != null)
{
string strSqlString = "Update JAAJ_Devices SET iDeviceStatus=" + iStatus + " WHERE iDeviceID=" + odiDeviceInfo.iDeviceID + " ";
SqlDatabase odbDataBase = new SqlDatabase(connectionString);
DbCommand odbCommand = odbDataBase.GetSqlStringCommand(strSqlString);
try
{
int iResult = odbDataBase.ExecuteNonQuery(odbCommand);
if (iResult > 0)
{
enmResult = EnumSubmitResult.Success;
}
else
{
enmResult = EnumSubmitResult.Failed;
}
}
catch (Exception oeException)
{
throw new Exception(oeException.Message, oeException);
}
}
}
return(enmResult);
}
/// <summary>
/// 更新设备状态为空闲、插入已考试科目ID与子项ID、删除当前子项考试过程记录
/// </summary>
/// <returns>EnumSubmitResult</returns>
public static EnumSubmitResult UpdateDeviceStatusCallListDeleteExamProcess(int iExamineeID)
{
EnumSubmitResult enmResult = EnumSubmitResult.Failed;
string strIP = GetLocalIP();
if (strIP != "")
{
JAAJ_DeviceInfo odiDeviceInfo = GetDeviceInfoByIP(strIP);
JAAJ_ExamProceInfo oepiExamProceInfo = GetExamProceInfoByExamineeID(iExamineeID);
if (oepiExamProceInfo != null)
{
JAAJ_SubjectItemInfo osiiSubjectItemInfo = GetSubjectItemInfoByID(oepiExamProceInfo.iSubjectItemID);
if (odiDeviceInfo != null && osiiSubjectItemInfo != null)
{
string strStoreProcedure = "JAAJ_UpdateDeviceStatusCallListDeleteExamProcess";
SqlDatabase odbDataBase = new SqlDatabase(connectionString);
DbCommand odbCommand = odbDataBase.GetStoredProcCommand(strStoreProcedure);
odbDataBase.AddInParameter(odbCommand, "@iExamineeID", System.Data.DbType.Int32, iExamineeID);
odbDataBase.AddInParameter(odbCommand, "@iSubjectID", System.Data.DbType.Int32, osiiSubjectItemInfo.iSubjectID);
odbDataBase.AddInParameter(odbCommand, "@iSubjectItemID", System.Data.DbType.Int32, osiiSubjectItemInfo.iSubjectItemID);
odbDataBase.AddInParameter(odbCommand, "@iDeviceID", System.Data.DbType.Int32, odiDeviceInfo.iDeviceID);
odbDataBase.AddOutParameter(odbCommand, "@result", System.Data.DbType.Int32, 8);
using (IDbConnection connection = odbDataBase.CreateConnection())
{
connection.Open();
try
{
odbDataBase.ExecuteNonQuery(odbCommand);
int i = int.Parse(odbCommand.Parameters["@result"].Value.ToString());
enmResult = (EnumSubmitResult)i;
}
catch (Exception oeException)
{
//throw new Exception(oeException.Message, oeException);
}
connection.Close();
}
odbCommand.Dispose();
}
}
}
return(enmResult);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="ids"></param>
/// <returns>EnumSubmitResult</returns>
public static EnumSubmitResult DeleteInfoByIds(string ids)
{
string strSqlString = "DELETE FROM JAAJ_Users WHERE iUserID in(" + ids + ")";
SqlDatabase odbDataBase = new SqlDatabase(SQLHelp.CONNECTINSTRING);
DbCommand odbCommand = odbDataBase.GetSqlStringCommand(strSqlString);
EnumSubmitResult enmResult = EnumSubmitResult.Failed;
try
{
odbDataBase.ExecuteNonQuery(odbCommand);
enmResult = EnumSubmitResult.Success;
}
catch (Exception oeException)
{
throw new Exception(oeException.Message, oeException);
}
return(enmResult);
}
/// <summary>
/// 保存
/// </summary>
/// <param name="JAAJ_UserInfo"></param>
/// <returns>EnumSubmitResult</returns>
public static EnumSubmitResult Save(JAAJ_UserInfo info)
{
string strStoreProcedure = "JAAJ_User_Save";
SqlDatabase odbDataBase = new SqlDatabase(SQLHelp.CONNECTINSTRING);
DbCommand odbCommand = odbDataBase.GetStoredProcCommand(strStoreProcedure);
odbDataBase.AddInParameter(odbCommand, "@iUserID", System.Data.DbType.Int32, info.iUserID);
odbDataBase.AddInParameter(odbCommand, "@nvcUserName", System.Data.DbType.String, info.nvcUserName);
odbDataBase.AddInParameter(odbCommand, "@nvcPassword", System.Data.DbType.String, info.nvcPassword);
odbDataBase.AddInParameter(odbCommand, "@nvcRole", System.Data.DbType.String, info.nvcRole);
odbDataBase.AddInParameter(odbCommand, "@nvcCnName", System.Data.DbType.String, info.nvcCnName);
odbDataBase.AddInParameter(odbCommand, "@nvcContact", System.Data.DbType.String, info.nvcContact);
odbDataBase.AddInParameter(odbCommand, "@nvcEmail", System.Data.DbType.String, info.nvcEmail);
odbDataBase.AddInParameter(odbCommand, "@nvcAddress", System.Data.DbType.String, info.nvcAddress);
odbDataBase.AddInParameter(odbCommand, "@nvcMemo", System.Data.DbType.String, info.nvcMemo);
odbDataBase.AddOutParameter(odbCommand, "@result", System.Data.DbType.Int32, 8);
EnumSubmitResult enmResult = EnumSubmitResult.Failed;
using (IDbConnection connection = odbDataBase.CreateConnection())
{
connection.Open();
try
{
odbDataBase.ExecuteNonQuery(odbCommand);
int i = int.Parse(odbCommand.Parameters["@result"].Value.ToString());
enmResult = (EnumSubmitResult)i;
}
catch (Exception oeException)
{
//throw new Exception(oeException.Message, oeException);
}
connection.Close();
}
odbCommand.Dispose();
return(enmResult);
}
/// <summary>
/// 解析成绩XML保存考生成绩
/// </summary>
/// <param name="nvcBatchNO">批次号</param>
/// <param name="iExamineeID">考生ID</param>
public void SaveScore(string nvcBatchNO, int iExamineeID)
{
oepiExamProceInfo = ScoreData.GetExamProceInfoByExamineeID(iExamineeID);
if (oepiExamProceInfo != null)
{
//int iSubjectItemID = oepiExamProceInfo.iSubjectItemID;
//下面代码可以根据科目子项ID调出对应的子项对应的试题.....
BaseInfo obiBaseInfo = JAAJExamManagementSys.Common.CurrentScoreFieldsSetting;
foreach (SubjectItem osiSubjectItem in obiBaseInfo.SubjectItemList)
{
JAAJ_SubjectItemInfo osiiSubjectItemInfo = ScoreData.GetSubjectItemInfoByID(oepiExamProceInfo.iSubjectItemID);
if (osiiSubjectItemInfo != null)
{
#region 给子项分值赋值
ossiJAAJ_SubjectScoreInfo = new JAAJ_SubjectScoreInfo();
ossiJAAJ_SubjectScoreInfo.nvcBatchNO = nvcBatchNO; //批次号
ossiJAAJ_SubjectScoreInfo.iExamineeID = iExamineeID; //考生ID，从考生表查
ossiJAAJ_SubjectScoreInfo.iSubjectID = osiiSubjectItemInfo.iSubjectID;
ossiJAAJ_SubjectScoreInfo.iSubjectItemID = osiiSubjectItemInfo.iSubjectItemID;
ossiJAAJ_SubjectScoreInfo.decSubjectScore = osiSubjectItem.SubjectItemScore; //考生本次考试所考子项总分值
ossiJAAJ_SubjectScoreInfo.datScoreDate = DateTime.Now;
ossiJAAJ_SubjectScoreInfo.nvcMemo = "";
#endregion
foreach (Title otTitle in osiSubjectItem.TitleList[0].TitleList)
{
#region 加入试题成绩
JAAJ_SubItemScoreInfo osisiJAAJ_SubItemScoreInfo = new JAAJ_SubItemScoreInfo();
osisiJAAJ_SubItemScoreInfo.iExamineeID = iExamineeID; //需要根据身份证号查出赋值
osisiJAAJ_SubItemScoreInfo.iTitleID = 0;
osisiJAAJ_SubItemScoreInfo.nvcTitleName = otTitle.TitleName;
osisiJAAJ_SubItemScoreInfo.nvcDescription = otTitle.TitleDescription;
osisiJAAJ_SubItemScoreInfo.decSubjectItemScore = otTitle.TitleScore; //本道题本次考试所得分值
osisiJAAJ_SubItemScoreInfo.nvcMemo = "";
#endregion
#region 循环加入试题对应的步骤成绩
if (otTitle.StepList.Count > 0)
{
foreach (Step osStep in otTitle.StepList[0].StepList)
{
JAAJ_StepScoreInfo ossiJAAJ_StepScoreInfo = new JAAJ_StepScoreInfo();
ossiJAAJ_StepScoreInfo.nvcStepName = osStep.StepName;
ossiJAAJ_StepScoreInfo.nvcDescription = osStep.StepDescription;
ossiJAAJ_StepScoreInfo.decStepScore = osStep.StepScore; //本步骤本次考试所得分值
ossiJAAJ_StepScoreInfo.nvcMemo = "";
osisiJAAJ_SubItemScoreInfo.JAAJ_StepScoreInfoList.Add(ossiJAAJ_StepScoreInfo);
}
}
#endregion
osisiJAAJ_SubItemScoreInfoList.Add(osisiJAAJ_SubItemScoreInfo);
}
EnumSubmitResult enResult = ScoreData.Save(ossiJAAJ_SubjectScoreInfo, osisiJAAJ_SubItemScoreInfoList);
if (enResult == EnumSubmitResult.Success)
{
//MessageBox.Show("分值提交成功", "提示");
}
else
{
//MessageBox.Show("分值提交失败", "提示");
}
}
}
}
}
public void SaveScore()
{
//本次考题得分总数；
int FireSum = 0;
//第一步分数;
int OneFire = 0;;
//第二步骤得分;
int twoFire = 0;
//判断着火的类型与灭火器选择的分数；
//String //FireStruct.sFireType = s[2];//着火的类型 1：水基灭火
int nTemp = 0;
if (nTemp == 0)
{
OneFire = 15;
}
else
{
OneFire = 0;
}
//是否成功对准火焰根部灭火；
int nTemp1 = 0;
if (nTemp1 == 0)
{
twoFire = 10;
}
else
{
twoFire = 0;
}
FireSum = twoFire + OneFire;
string sFireSum = Convert.ToString(FireSum);
sFireSum = "本次灭火总成绩：" + sFireSum;
JAAJ_SubjectItemInfo osiiSubjectItemInfo = ScoreData.GetSubjectItemInfoByID(oepiExamProceInfo.iSubjectItemID);
if (osiiSubjectItemInfo != null)
{
#region 给子项总分值赋值
//给子项总分值赋值
ossiJAAJ_SubjectScoreInfo = new JAAJ_SubjectScoreInfo();
ossiJAAJ_SubjectScoreInfo.nvcBatchNO = oeiJAAJ_ExamineeInfo.nvcBatchNO;
ossiJAAJ_SubjectScoreInfo.iExamineeID = oeiJAAJ_ExamineeInfo.iExamineeID;
ossiJAAJ_SubjectScoreInfo.iSubjectID = osiiSubjectItemInfo.iSubjectID;
ossiJAAJ_SubjectScoreInfo.iSubjectItemID = osiiSubjectItemInfo.iSubjectItemID;
ossiJAAJ_SubjectScoreInfo.decSubjectScore = FireSum; //考生本次考试所考子项总分值
ossiJAAJ_SubjectScoreInfo.datScoreDate = DateTime.Now;
ossiJAAJ_SubjectScoreInfo.nvcMemo = "";
#endregion
#region 第一题
//第一题
JAAJ_SubItemScoreInfo osisiJAAJ_SubItemScoreInfo = new JAAJ_SubItemScoreInfo();
osisiJAAJ_SubItemScoreInfo.iExamineeID = oeiJAAJ_ExamineeInfo.iExamineeID;
osisiJAAJ_SubItemScoreInfo.iTitleID = 0;
osisiJAAJ_SubItemScoreInfo.nvcTitleName = "厨房灭火";
osisiJAAJ_SubItemScoreInfo.nvcDescription = "厨房灭火";
osisiJAAJ_SubItemScoreInfo.decSubjectItemScore = FireSum; //本道题本次考试所得分值
osisiJAAJ_SubItemScoreInfo.nvcMemo = "";
#region 第一题试题步骤实体集赋值
#region 第一步骤
JAAJ_StepScoreInfo ossiJAAJ_StepScoreInfo = new JAAJ_StepScoreInfo();
ossiJAAJ_StepScoreInfo.nvcStepName = "灭火器选择";
ossiJAAJ_StepScoreInfo.nvcDescription = "灭火器选择";
ossiJAAJ_StepScoreInfo.decStepScore = OneFire;//本步骤本次考试所得分值
ossiJAAJ_StepScoreInfo.nvcMemo = "";
osisiJAAJ_SubItemScoreInfo.JAAJ_StepScoreInfoList.Add(ossiJAAJ_StepScoreInfo);
#endregion
#region 第二步骤
ossiJAAJ_StepScoreInfo = new JAAJ_StepScoreInfo();
ossiJAAJ_StepScoreInfo.nvcStepName = "是否对准火焰根部，开始灭火";
ossiJAAJ_StepScoreInfo.nvcDescription = "是否对准火焰根部，开始灭火";
ossiJAAJ_StepScoreInfo.decStepScore = twoFire;//本步骤本次考试所得分值
ossiJAAJ_StepScoreInfo.nvcMemo = "";
osisiJAAJ_SubItemScoreInfo.JAAJ_StepScoreInfoList.Add(ossiJAAJ_StepScoreInfo);
#endregion
#endregion
osisiJAAJ_SubItemScoreInfoList.Add(osisiJAAJ_SubItemScoreInfo);
#endregion
EnumSubmitResult enResult = ScoreData.Save(ossiJAAJ_SubjectScoreInfo, osisiJAAJ_SubItemScoreInfoList);
if (enResult == EnumSubmitResult.Success)
{
//MessageBox.Show("分值提交成功", "提示");
}
else
{
//MessageBox.Show("分值提交失败", "提示");
}
}
}
public static string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["strCon"].ToString();// "Data Source=WANGCHAO;Database=JAAJ;user id=sa;password=123456;Connect Timeout=30";
#region 保存客户端分值 Save
/// <summary>
/// 保存客户端分值
/// </summary>
/// <param name="info">子项成绩</param>
/// <param name="osisiJAAJ_SubItemScoreInfoList">子项试题成绩与试题步骤成绩</param>
/// <returns>保存结果，成功或失败</returns>
public static EnumSubmitResult Save(JAAJ_SubjectScoreInfo info, List <JAAJ_SubItemScoreInfo> osisiJAAJ_SubItemScoreInfoList)
{
int i = 0;
string strStoreProcedure = "JAAJ_SubjectScore_Save";
SqlDatabase odbDataBase = new SqlDatabase(connectionString);
DbConnection conn = odbDataBase.CreateConnection();
DbCommand odbCommand = odbDataBase.GetStoredProcCommand(strStoreProcedure);
conn.Open();
DbTransaction odtTran = conn.BeginTransaction();
EnumSubmitResult enmResult = EnumSubmitResult.Failed;
try
{
odbDataBase.AddInParameter(odbCommand, "@iSubjectScoreID", System.Data.DbType.Int32, info.iSubjectScoreID);
odbDataBase.AddInParameter(odbCommand, "@nvcBatchNO", System.Data.DbType.String, info.nvcBatchNO);
odbDataBase.AddInParameter(odbCommand, "@iExamineeID", System.Data.DbType.Int32, info.iExamineeID);
odbDataBase.AddInParameter(odbCommand, "@iSubjectID", System.Data.DbType.Int32, info.iSubjectID);
odbDataBase.AddInParameter(odbCommand, "@iSubjectItemID", System.Data.DbType.Int32, info.iSubjectItemID);
odbDataBase.AddInParameter(odbCommand, "@decSubjectScore", System.Data.DbType.Decimal, info.decSubjectScore);
odbDataBase.AddInParameter(odbCommand, "@datScoreDate", System.Data.DbType.DateTime, info.datScoreDate);
odbDataBase.AddInParameter(odbCommand, "@nvcMemo", System.Data.DbType.String, info.nvcMemo);
odbDataBase.AddOutParameter(odbCommand, "@result", System.Data.DbType.Int32, 8);
odbDataBase.AddOutParameter(odbCommand, "@iSubjectScoreID2", System.Data.DbType.Int32, 8);
odbDataBase.ExecuteNonQuery(odbCommand, odtTran);
i = int.Parse(odbCommand.Parameters["@result"].Value.ToString());
int iSubjectScoreID = (int)odbDataBase.GetParameterValue(odbCommand, "@iSubjectScoreID2");
enmResult = (EnumSubmitResult)i;
if (enmResult == EnumSubmitResult.Failed)
{
odtTran.Rollback();
return(enmResult = EnumSubmitResult.Failed);
}
//循环执行科目子项试题分数保存
foreach (JAAJ_SubItemScoreInfo osisinfo in osisiJAAJ_SubItemScoreInfoList)
{
strStoreProcedure = "JAAJ_SubItemScore_Save";
odbCommand = odbDataBase.GetStoredProcCommand(strStoreProcedure);
odbDataBase.AddInParameter(odbCommand, "@iSubItemScoreID", System.Data.DbType.Int32, osisinfo.iSubItemScoreID);
odbDataBase.AddInParameter(odbCommand, "@iSubjectScoreID", System.Data.DbType.Int32, iSubjectScoreID);
odbDataBase.AddInParameter(odbCommand, "@iExamineeID", System.Data.DbType.Int32, osisinfo.iExamineeID);
odbDataBase.AddInParameter(odbCommand, "@iTitleID", System.Data.DbType.Int32, osisinfo.iTitleID);
odbDataBase.AddInParameter(odbCommand, "@nvcTitleName", System.Data.DbType.String, osisinfo.nvcTitleName);
odbDataBase.AddInParameter(odbCommand, "@nvcDescription", System.Data.DbType.String, osisinfo.nvcDescription);
odbDataBase.AddInParameter(odbCommand, "@decSubjectItemScore", System.Data.DbType.Decimal, osisinfo.decSubjectItemScore);
odbDataBase.AddInParameter(odbCommand, "@nvcMemo", System.Data.DbType.String, osisinfo.nvcMemo);
odbDataBase.AddOutParameter(odbCommand, "@result", System.Data.DbType.Int32, 8);
odbDataBase.AddOutParameter(odbCommand, "@iSubItemScoreID2", System.Data.DbType.Int32, 8);
odbDataBase.ExecuteNonQuery(odbCommand, odtTran);
i = int.Parse(odbCommand.Parameters["@result"].Value.ToString());
int iSubItemScoreID = (int)odbDataBase.GetParameterValue(odbCommand, "@iSubItemScoreID2");
enmResult = (EnumSubmitResult)i;
if (enmResult == EnumSubmitResult.Failed)
{
odtTran.Rollback();
return(enmResult = EnumSubmitResult.Failed);
}
//循环执行科目子项试题步骤分数保存
strStoreProcedure = "JAAJ_StepScore_Save";
foreach (JAAJ_StepScoreInfo ossiinfo in osisinfo.JAAJ_StepScoreInfoList)
{
odbCommand = odbDataBase.GetStoredProcCommand(strStoreProcedure);
odbDataBase.AddInParameter(odbCommand, "@iStepScoreID", System.Data.DbType.Int32, ossiinfo.iStepScoreID);
odbDataBase.AddInParameter(odbCommand, "@iSubItemScoreID", System.Data.DbType.Int32, iSubItemScoreID);
odbDataBase.AddInParameter(odbCommand, "@iStepID", System.Data.DbType.Int32, ossiinfo.iStepID);
odbDataBase.AddInParameter(odbCommand, "@nvcStepName", System.Data.DbType.String, ossiinfo.nvcStepName);
odbDataBase.AddInParameter(odbCommand, "@nvcDescription", System.Data.DbType.String, ossiinfo.nvcDescription);
odbDataBase.AddInParameter(odbCommand, "@decStepScore", System.Data.DbType.Decimal, ossiinfo.decStepScore);
odbDataBase.AddInParameter(odbCommand, "@nvcMemo", System.Data.DbType.String, ossiinfo.nvcMemo);
odbDataBase.AddOutParameter(odbCommand, "@result", System.Data.DbType.Int32, 8);
odbDataBase.ExecuteNonQuery(odbCommand, odtTran);
i = int.Parse(odbCommand.Parameters["@result"].Value.ToString());
enmResult = (EnumSubmitResult)i;
//出错不在往下执行，直接回滚
if (enmResult == EnumSubmitResult.Failed)//失败
{
odtTran.Rollback();
return(enmResult = EnumSubmitResult.Failed);
}
}
}
odtTran.Commit();
}
catch
{
odtTran.Rollback();
enmResult = EnumSubmitResult.Failed;
}
odbCommand.Dispose();
odtTran.Dispose();
conn.Close();
return(enmResult);
}
