/// <summary>
/// 将数据库里面的值重新获取，重新加载这个页面的内容
/// </summary>
/// <returns></returns>
public ObservableCollection <TBL_TH_QuGroup_Ext> GetExamQuGroupInfo()
{
string sql = "SELECT B.QUGR_KEY,B.QUGR_PARENTKEY,A.QUGR_NAME,B.QUGR_NAME,B.QUGR_STATE FROM TBL_TH_QUGROUP A INNER JOIN TBL_TH_QUGROUP B ON A.QUGR_KEY=B.QUGR_PARENTKEY WHERE A.QUGR_STATE='1' AND B.QUGR_STATE='1' ORDER BY A.QUGR_NAME,B.QUGR_NAME";
List <TBL_TH_QuGroup_Ext> result = ExamHandle.TryGetData <TBL_TH_QuGroup_Ext>(sql);
return(new ObservableCollection <TBL_TH_QuGroup_Ext>(result));
}
/// <summary>
/// </summary>
/// <param name="m_Key"></param>
/// <returns>
/// 1 成功
/// -1 通讯失败
/// -2 已被使用，不能删除
/// </returns>
public static int DelQuestion(string m_Key)
{
var en = new TransEntity();
en.AddOperation(SQL.EXISTINTEGRANT, new[] { m_Key });
ExamHandle.TryGetData(en);
if (!en.ReceiveData.ExcuteIsComplete)
{
return(-1);
}
if (!en.ReceiveData.DataTables.Rows[0][0].ToString().Equals("0"))
{
return(-2);
}
en = new TransEntity();
en.AddOperation(SQL.DELTRADEVALUESTA, new[] { m_Key });
en.AddOperation(SQL.DELTRADESTA, new[] { m_Key });
en.AddOperation(SQL.DELQUESTION, new[] { m_Key });
ExamHandle.Execute(en);
if (en.ReceiveData.ExcuteIsComplete)
{
return(1);
}
else
{
return(-1);
}
}
public void ChangeFromTable(object[] parms)
{
if (parms.Length == 7)
{
Key = Guid.NewGuid().ToString("N").ToUpper();
Teller_No = parms[0].ToString();
Teller_Name = parms[1].ToString();
Teller_Id = parms[2].ToString();
Teller_Age = Convert.ToInt32(parms[3]);
Teller_Unit = parms[4].ToString();
Teller_UnitName = parms[5].ToString();
Teller_Role = parms[6].ToString();
Client_key = parms[7].ToString();
Date = ExamHandle.GetNowDateTime();
Is_stop = Convert.ToInt32(parms[8]);
}
else
{
Key = parms[0].ToString();
Teller_No = parms[1].ToString();
Teller_Name = parms[2].ToString();
Teller_Id = parms[3].ToString();
Teller_Age = Convert.ToInt32(parms[4].ToString() == string.Empty ? "0" : parms[4]);
Teller_Unit = parms[5].ToString();
Teller_UnitName = parms[6].ToString();
Teller_Role = parms[7].ToString();
Client_key = parms[8].ToString();
Date = CommonFunction.ConvertDateTimeToNullable(parms[9]);
Is_stop = Convert.ToInt32(parms[10]);
}
}
/// <summary>
/// 删除指定柜员
/// </summary>
/// <param name="m_TellerID">柜员ID</param>
/// <returns></returns>
public static bool DeleteStaff(string m_TellerID)
{
var en = new TransEntity();
en.AddOperation(SQL.DELETESTAFF, new[] { m_TellerID });
ExamHandle.Execute(en);
return(en.ReceiveData.ExcuteIsComplete);
}
//加入白名单
private bool JoinWhite()
{
string[] sqllist = Datas.Where(c => c.IsSelected).Select(c => SQL.JOINWHITE).ToArray();
string[][] paramlist =
Datas.Where(c => c.IsSelected).Select(c => c.Data.IP).Select(c => new[] { c }).ToArray();
return(ExamHandle.TryExecute(sqllist, paramlist));
}
//得到符合筛选条件的题目信息
private ObservableCollection <T_Question_Collection> GetSearchQCInf()
{
var str = new string[4] {
Date1.Date.ToString("yyyy-MM-dd HH:mm:ss"), Date2.Date.ToString("yyyy-MM-dd HH:mm:ss"), DifficultyL, DifficultyL
};
var result = ExamHandle.TryGetData <T_Question_Collection>(SQL.GETRSEARCHQCINFO, str);
return(new ObservableCollection <T_Question_Collection>(result));
}
//筛选的模板信息
private ObservableCollection <T_Mould> GetSearchPaperInfo()
{
var str = new string[2] {
CreateDate1.Date.ToString("yyyy-MM-dd HH:mm:ss"), CreateDate2.Date.ToString("yyyy-MM-dd HH:mm:ss")
};
var result = ExamHandle.TryGetData <T_Mould>(SQL.GETSEARCHTESTPAPERINFO, str);
return(new ObservableCollection <T_Mould>(result));
}
/// <summary>
/// 清空白名单或黑名单
/// </summary>
/// <param name="m_WhiteList"></param>
/// <returns></returns>
public static bool ClearClient(bool m_WhiteList)
{
var en = new TransEntity();
string iswhite = m_WhiteList ? "1" : "0";
en.AddOperation(SQL.CLEARCLIENT, new[] { iswhite });
ExamHandle.Execute(en);
return(en.ReceiveData.ExcuteIsComplete);
}
//初始化
public override void Loaded()
{
string sql = @"SELECT
KINBRNO,
KINBRNAME
FROM
TT_KINBRINFO";
KinbrInfo = ExamHandle.TryGetData <TT_KINBRINFO>(sql);
}
/// <summary>
/// </summary>
/// <param name="m_ModeName"></param>
/// <param name="m_ScoreTotal"></param>
/// <param name="m_MouldQuestions"></param>
/// <returns>
/// 1 成功
/// -1 通讯失败
/// -2 变量信息不完整
/// </returns>
public static int AddTestPaper(string m_ModeName, string m_ScoreTotal, List <MouldQuestion> m_MouldQuestions)
{
var keys = new List <string>();
for (int i = 0; i < m_MouldQuestions.Count; i++)
{
keys.Add(m_MouldQuestions[i].QUESTIONKEY);
}
DataTable dtvariablequstion = GetVariableQuestion(keys);
if (dtvariablequstion == null)
{
return(-1);
}
for (int i = 0; i < dtvariablequstion.Rows.Count; i++)
{
string key = dtvariablequstion.Rows[i]["F_KEY"].ToString();
List <MouldQuestion> question = m_MouldQuestions.Where(p => p.QUESTIONKEY == key).ToList();
if (question[0].VARIABLE.Length == 0)
{
return(-2);
}
}
for (int i = 0; i < m_MouldQuestions.Count; i++)
{
if (m_MouldQuestions[i].VARIABLE.Length == 0)
{
m_MouldQuestions[i].VARIABLE = "|";
}
}
string guid = Guid.NewGuid().ToString();
var en = new TransEntity();
en.AddOperation(SQL.ADDTESTPAPER, new[] { guid, m_ModeName, m_ScoreTotal });
foreach (MouldQuestion item in m_MouldQuestions)
{
string questionguid = Guid.NewGuid().ToString();
en.AddOperation(SQL.AddINTEGRANTQUESTION,
new[] { questionguid, guid, item.QUESTIONKEY, item.SCORE, item.SORT, item.VARIABLE });
}
ExamHandle.Execute(en);
if (en.ReceiveData.ExcuteIsComplete)
{
return(1);
}
else
{
return(-1);
}
}
public static bool ExportExamStaff(string m_Key, string m_Examname)
{
var stringbuilder = new StringBuilder();
var en = new TransEntity();
en.AddOperation(@"select f_teller_no, f_teller_name, f_teller_unit, f_teller_role
from t_paper
where f_exam_key =?", new[] { m_Key });
ExamHandle.TryGetData(en);
if (en.ReceiveData.ExcuteIsComplete)
{
var saveDialog = new SaveFileDialog();
saveDialog.Filter = "(*.csv)|*.csv";
saveDialog.FileName = m_Examname + "_柜员列表";
saveDialog.ShowDialog();
string outputFile = saveDialog.FileName;
if (en.ReceiveData.DataTables == null || en.ReceiveData.DataTables.Rows.Count == 0)
{
return(false);
}
stringbuilder.Append("工号,姓名,机构,角色\r\n");
for (int i = 0; i < en.ReceiveData.DataTables.Rows.Count; i++)
{
for (int j = 0; j < en.ReceiveData.DataTables.Columns.Count; j++)
{
stringbuilder.Append(en.ReceiveData.DataTables.Rows[i][j]);
if (j != en.ReceiveData.DataTables.Columns.Count - 1)
{
stringbuilder.Append(",");
}
}
if (i != en.ReceiveData.DataTables.Rows.Count - 1)
{
stringbuilder.Append("\r\n");
}
}
try
{
var filestream = new FileStream(outputFile, FileMode.Create);
var streamwriter = new StreamWriter(filestream, Encoding.GetEncoding("GB2312"));
streamwriter.Write(stringbuilder.ToString());
streamwriter.Close();
filestream.Close();
}
catch
{
return(false);
}
return(true);
}
else
{
return(false);
}
}
//得到所有模板信息
private ObservableCollection <SelectionObject <T_Mould> > GetAllInfo()
{
List <T_Mould> result = ExamHandle.TryGetData <T_Mould>(SQL.GETALLMOULDS);
IEnumerable <SelectionObject <T_Mould> > q = from p in result
select new SelectionObject <T_Mould>
{
Data = p
};
return(new ObservableCollection <SelectionObject <T_Mould> >(q.ToList()));
}
//确定
private void Okay()
{
bool result = true;
//sql语句列表
var SqlList = new Dictionary <List <string>, string>();
string guid;
guid = Guid.NewGuid().ToString("N").ToUpper();
SqlList.Add(new List <string> {
guid, QuestionName, Difficulty, "1"
}, SQL.AddQuestions);
//添加操作题标准答案交易
for (int i = 0; i < LvTradeInfo.Count(); i++)
{
string tradeGuid = Guid.NewGuid().ToString("N").ToUpper();
SqlList.Add(new List <string>
{
tradeGuid,
guid,
LvTradeInfo[i].Trade_No,
LvTradeInfo[i].Proportion.ToString(),
LvTradeInfo[i].Sort.ToString()
}, SQL.ADDTRADESTAANSWER);
foreach (DataRow item in ld[i].Rows)
{
string answerGuid = Guid.NewGuid().ToString("N").ToUpper();
SqlList.Add(new List <string>
{
answerGuid,
tradeGuid,
item["F_VALUE_TYPE"].ToString(),
item["F_DOMAIN"].ToString(),
item["F_DOMAIN_VALUE"].ToString(),
item["F_IS_WRITE"].ToString(),
item["F_PROPORTION"].ToString(),
item["F_SORT"].ToString()
}, SQL.ADDTRADEVALSTAANSWER);
}
}
//执行事务处理
result = ExamHandle.TryExecute(SqlList.Values.ToArray(), SqlList.Keys.Select(c => c.ToArray()).ToArray());
if (result)
{
Messenger.Default.Send("提交成功!");
Close();
}
else
{
Messenger.Default.Send("提交失败!");
}
}
//显示黑名单
private ObservableCollection <SelectionObject <T_Client_Computer> > GetBlackInfo()
{
List <T_Client_Computer> result = ExamHandle.TryGetData <T_Client_Computer>(SQL.GETBLACKINFO);
IEnumerable <SelectionObject <T_Client_Computer> > q = from p in result
select new SelectionObject <T_Client_Computer>
{
Data = p
};
return(new ObservableCollection <SelectionObject <T_Client_Computer> >(q.ToList()));
}
/// <summary>
/// 将数据库里面的值重新获取，重新加载这个页面的内容
/// </summary>
/// <returns></returns>
public ObservableCollection <TBL_TH_QUTYPE> GetExamQuTypeInfo()
{
string sql = @"SELECT
QUTY_KEY,
QUTY_NAME, QUTY_STATE
FROM
TBL_TH_QUTYPE WHERE QUTY_STATE='1'";
List <TBL_TH_QUTYPE> result = ExamHandle.TryGetData <TBL_TH_QUTYPE>(sql);
return(new ObservableCollection <TBL_TH_QUTYPE>(result));
}
//得到所有题目信息的方法
private ObservableCollection <SelectionObject <T_Question_Collection> > GetAllQCInf()
{
List <T_Question_Collection> result = ExamHandle.TryGetData <T_Question_Collection>(SQL.GETRALLQCINFO);
IEnumerable <SelectionObject <T_Question_Collection> > q = from p in result
select new SelectionObject <T_Question_Collection>
{
Data = p
};
return(new ObservableCollection <SelectionObject <T_Question_Collection> >(q.ToList()));
}
private ObservableCollection <TBL_TH_QUTYPE> GetSerchAllQuType()
{
string sql = @"SELECT
QUTY_KEY,
QUTY_NAME, QUTY_STATE
FROM
TBL_TH_QUTYPE WHERE QUTY_STATE='1' AND QUTY_NAME LIKE ?";
List <TBL_TH_QUTYPE> result = ExamHandle.TryGetData <TBL_TH_QUTYPE>(sql, string.Format("%{0}%", SearchQuType));
return(new ObservableCollection <TBL_TH_QUTYPE>(result));
}
//得到所有模板信息
private ObservableCollection <SelectionObject <T_Mould> > GetAllMouldsInfo()
{
List <T_Mould> result = ExamHandle.TryGetData <T_Mould>(@"SELECT F_KEY,F_MOULD_NAME,F_SCORE_TOTAL,F_DATE,F_IS_STOP,F_IS_USE FROM T_MOULD");
IEnumerable <SelectionObject <T_Mould> > q = from p in result
select new SelectionObject <T_Mould>
{
Data = p
};
return(new ObservableCollection <SelectionObject <T_Mould> >(q.ToList()));
}
//得到所有符合查询条件的柜员信息
private ObservableCollection <SelectionObject <T_Staff> > GetSearchStaffInfo()
{
List <T_Staff> result = ExamHandle.TryGetData <T_Staff>(SQL.GETSEARCHSTAFFINFO, "%" + TellerNo + "%", "%" + TellerNo + "%", "%" + TellerNo + "%");
IEnumerable <SelectionObject <T_Staff> > q = from p in result
select new SelectionObject <T_Staff>
{
Data = p
};
return(new ObservableCollection <SelectionObject <T_Staff> >(q.ToList()));
}
private ObservableCollection <SelectionObject <T_INVIGILATE> > GetTotalInvInfo()
{
string sql = @"SELECT INV_KEY, INV_NO, INV_NAME, INV_PWD,INV_IDNO, INV_UNIT, INV_UPDATE_TIME, INV_STATE ,INV_UNITNAME FROM T_INVIGILATE";
var result = ExamHandle.TryGetData <T_INVIGILATE>(sql);
IEnumerable <SelectionObject <T_INVIGILATE> > q = from p in result
select new SelectionObject <T_INVIGILATE>
{
Data = p
};
return(new ObservableCollection <SelectionObject <T_INVIGILATE> >(q.ToList()));
}
/// <summary>
/// 更新客户端，移入或移除白名单
/// </summary>
/// <param name="m_ClientIds"></param>
/// <returns></returns>
public static bool UpdateClient(List <string> m_ClientIds, bool m_IsWhite)
{
var en = new TransEntity();
string iswhite = m_IsWhite ? "1" : "0";
foreach (string item in m_ClientIds)
{
en.AddOperation(SQL.UPDATECLIENT, new[] { iswhite, item });
}
ExamHandle.Execute(en);
return(en.ReceiveData.ExcuteIsComplete);
}
//得到所有符合查询条件的柜员信息
private ObservableCollection <SelectionObject <T_Staff> > GetSearchStaffInfo()
{
List <T_Staff> result = ExamHandle.TryGetData <T_Staff>(@"SELECT F_KEY, F_TELLER_NO, F_TELLER_NAME, F_TELLER_ID, F_TELLER_UNIT, F_TELLER_ROLE,F_CLIENT_KEY, F_DATE, F_IS_STOP from t_staff where F_Teller_no like ? AND F_IS_STOP = 1", "%" + TellerNo + "%");
IEnumerable <SelectionObject <T_Staff> > q = from p in result
select new SelectionObject <T_Staff>
{
Data = p
};
return(new ObservableCollection <SelectionObject <T_Staff> >(q.ToList()));
}
private ObservableCollection <SelectionObject <TBL_TH_INVIGILATE> > GetSearchInvInfo(string invNo)
{
string sql = @"SELECT INV_KEY, INV_NO, INV_NAME, INV_IDNO, INV_UNIT, INV_UPDATE_TIME, INV_STATE FROM TBL_TH_INVIGILATE WHERE INV_NO LIKE ?";
var result = ExamHandle.TryGetData <TBL_TH_INVIGILATE>(sql, "%" + invNo + "%");
IEnumerable <SelectionObject <TBL_TH_INVIGILATE> > q = from p in result
select new SelectionObject <TBL_TH_INVIGILATE>
{
Data = p
};
return(new ObservableCollection <SelectionObject <TBL_TH_INVIGILATE> >(q.ToList()));
}
//得到所有柜员的信息
private ObservableCollection <SelectionObject <T_Staff> > GetAllStaffInfo()
{
List <T_Staff> result = ExamHandle.TryGetData <T_Staff>(SQL.GETALLSTAFFS);
IEnumerable <SelectionObject <T_Staff> > q = from p in result
select new SelectionObject <T_Staff>
{
Data = p
};
return(new ObservableCollection <SelectionObject <T_Staff> >(q.ToList()));
}
//数据格式验证
public override string DataValidate(string name)
{
switch (name)
{
case "Teller_No":
{
object result = ExamHandle.TryGetSingleData(SQL.ISSTAFFEXIST, Staff_Info.Teller_No);
if (Convert.ToInt32(result) > 0)
{
return("柜员已存在!");
}
}
break;
case "Teller_Name":
{
if (!Regex.IsMatch(Staff_Info.Teller_Name, @"^[\u4e00-\u9fa5]{0,}$"))
{
return("姓名只能输入汉字!");
}
}
break;
case "Teller_Id":
{
if (!Regex.IsMatch(Staff_Info.Teller_Id, @"^\d{15}|\d{18}$"))
{
return("身份证输入有误!");
}
}
break;
case "Teller_Unit":
{
if (!Regex.IsMatch(Staff_Info.Teller_Unit, @"^[0-9]{1,}$"))
{
return("机构只能输入数字!");
}
}
break;
case "Teller_Role":
{
if (!Regex.IsMatch(Staff_Info.Teller_Role, @"^[\u4e00-\u9fa5]{0,}$"))
{
return("角色只能输入汉字!");
}
}
break;
}
return(null);
}
public static string Exprot()
{
var saveDialog = new SaveFileDialog();
saveDialog.Filter = "(*.csv)|*.csv";
saveDialog.FileName = "柜员列表";
saveDialog.ShowDialog();
string outputFile = saveDialog.FileName;
var en = new TransEntity();
en.AddOperation(SQL.GETEXPORT, null);
ExamHandle.TryGetData(en);
if (!en.ReceiveData.ExcuteIsComplete || en.ReceiveData.DataTables == null)
{
return("-1");
}
DataTable result = en.ReceiveData.DataTables;
var stringbuilder = new StringBuilder();
stringbuilder.Append("工号,姓名,身份证号,部门,角色\r\n");
for (int i = 0; i < result.Rows.Count; i++)
{
for (int j = 0; j < result.Columns.Count; j++)
{
stringbuilder.Append(result.Rows[i][j]);
if (j != result.Columns.Count - 1)
{
stringbuilder.Append(",");
}
}
if (i != result.Rows.Count - 1)
{
stringbuilder.Append("\r\n");
}
}
try
{
var filestream = new FileStream(outputFile, FileMode.Create);
var streamwriter = new StreamWriter(filestream, Encoding.GetEncoding("GB2312"));
streamwriter.Write(stringbuilder.ToString());
streamwriter.Close();
filestream.Close();
}
catch (Exception e)
{
return(e.Message);
}
return("1");
}
//登录的方法
private bool Register()
{
DataTable result = ExamHandle.TryGetData(SQL.REGISTER, UserId, Password);
if (Convert.ToInt32(result.Rows[0][0]) == 1)
{
return(true);
}
else
{
return(false);
}
}
//得到所有符合查询条件的模板信息
private ObservableCollection <SelectionObject <T_Mould> > GetSearchInfo()
{
var str = new string[2] {
CreateDate1.Date.ToString("yyyy-MM-dd HH:mm:ss"), CreateDate2.Date.ToString("yyyy-MM-dd HH:mm:ss")
};
List <T_Mould> result = ExamHandle.TryGetData <T_Mould>(SQL.GETALLMOULDS, str);
IEnumerable <SelectionObject <T_Mould> > q = from p in result
select new SelectionObject <T_Mould>
{
Data = p
};
return(new ObservableCollection <SelectionObject <T_Mould> >(q.ToList()));
}
/// <summary>
///
/// </summary>
private void QueryTeacherExam()
{
List <T_Exam> result = ExamHandle.TryGetData <T_Exam>
(Sql.QUERYEXAM_TEACHER, App.Teller.Teller_No, App.Teller.Teller_Id);
if (result == null && result.Count == 0)
{
//TODO:考试查询出错
return;
}
ExamList = new ObservableCollection <T_Exam>(result);
}
/// <summary>
/// 交卷操作
/// </summary>
private void SubmitPaper(bool isForce = false)
{
//是否强制交卷
if (!isForce)
{
bool flag = false;
Messenger.Default.Send(new DialogMessage("确定是否要交卷？", result =>
{
if (result == MessageBoxResult.OK)
{
flag = true;
}
})
{
Button = MessageBoxButton.OKCancel, Caption = "提示", Icon = MessageBoxImage.Question
});
if (!flag)
{
return;
}
}
if (!ExamHandle.TryExecute(Sql.UPDATE_PAPERENDTIME, PaperData.Key))
{
Messenger.Default.Send("提交试卷发生错误");
return;
}
foreach (Process thisproc in System.Diagnostics.Process.GetProcesses())
{
if (thisproc.ProcessName == "TellerSystem.Client" || thisproc.ProcessName == "TellerSystem.Client.vshost")
{
thisproc.Kill();
}
}
// 停止倒计时
this.ExamClock.StopTime();
//打开考试选择窗口
Messenger.Default.Send(
new WindowMessage
{
WindowName = "ExamResult",
Operation = WindowOperation.Show,
Param = new object[] { PaperData.Key, PaperData.Variables }
});
Close();
}
