/// <summary>
/// 查询是否存在指定的对照记录
/// </summary>
/// <param name="iuserExamClass"></param>
/// <returns></returns>
public override bool Exists(IModel iuserExamClass)
{
MUserExamClass userExamClass = (MUserExamClass)iuserExamClass;
strSql = "select * from " + TableName + " where DB_USER='******' and EXAM_CLASS = '" + userExamClass.EXAM_CLASS + "'";
return(recordIsExist(strSql));
}
/// <summary>
/// 获取指定DB_USER、检查类别的对照记录
/// </summary>
/// <param name="DB_USER"></param>
/// <param name="EXAM_CLASS"></param>
/// <returns></returns>
public override IModel GetModel(string DB_USER, string EXAM_CLASS)
{
strSql = "select * from " + TableName + " where DB_USER='******' and EXAM_CLASS = '" + EXAM_CLASS + "'";
DataTable dt = GetDataTable(strSql);
if (dt.Rows.Count == 0)
{
return(null);
}
MUserExamClass userExamClass = new MUserExamClass();
userExamClass.DB_USER = dt.Rows[0]["DB_USER"].ToString();
userExamClass.DEPT_NAME = dt.Rows[0]["DEPT_NAME"].ToString();
userExamClass.EXAM_CLASS = dt.Rows[0]["EXAM_CLASS"].ToString();
userExamClass.USER_DEPT = dt.Rows[0]["USER_DEPT"].ToString();
if (dt.Rows[0]["REPORT_CAPABILITY"] == null)
{
userExamClass.REPORT_CAPABILITY = null;
}
else
{
userExamClass.REPORT_CAPABILITY = Convert.ToInt32(dt.Rows[0]["REPORT_CAPABILITY"].ToString());
}
return(userExamClass);
}
/// <summary>
/// 批量插入对照列表
/// </summary>
/// <param name="ht2"></param>
/// <returns></returns>
public override int AddMore(Hashtable ht2)
{
MUserExamClass MUserRol = new MUserExamClass();
Hashtable ht = new Hashtable();
Hashtable htstr = new Hashtable();
if (ht2.Count > 0)
{
for (int i = 0; i < ht2.Count; i++)
{
ht.Clear();
MUserRol = ((MUserExamClass)ht2[i]);
ht.Add("DB_USER", MUserRol.DB_USER);
ht.Add("DEPT_NAME", MUserRol.DEPT_NAME);
ht.Add("EXAM_CLASS", MUserRol.EXAM_CLASS);
ht.Add("USER_DEPT", MUserRol.USER_DEPT);
ht.Add("REPORT_CAPABILITY", MUserRol.REPORT_CAPABILITY);
bool bl = Exists(MUserRol);
if (bl)
{
continue; //如果存在则不添加
}
htstr.Add(i, StringConstructor.InsertSql(TableName, ht).ToString());
}
return(ExecuteNonSql(htstr));
}
else
{
return(0);
}
}
/// <summary>
/// 更新指定对照记录的报告权限
/// </summary>
/// <param name="iuserExamClass"></param>
/// <param name="where"></param>
/// <returns></returns>
public override int Update2(IModel iuserExamClass, string where)
{
MUserExamClass userExamClass = (MUserExamClass)iuserExamClass;
string sql = "Update USER_EXAM_CLASS set REPORT_CAPABILITY='" + userExamClass.REPORT_CAPABILITY + "' Where " + where;
return(ExecuteSql(sql));
}
/// <summary>
/// 当单击修改报告权限时，执行修改
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_Mondify_Click(object sender, EventArgs e)
{
if (NowClickRowIndex < 0)
{
MessageBoxEx.Show("请双击选中需要修改的用户!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (dgv_User_Exam_Class.Rows.Count < 1)
{
MessageBoxEx.Show("此用户还未绑定报告类别!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
MUserExamClass muec = new MUserExamClass();
muec.DB_USER = dgv_USER_EXAM_CLASS_User.Rows[NowClickRowIndex].Cells["DB_USER"].Value.ToString();
muec.DEPT_NAME = dgv_USER_EXAM_CLASS_User.Rows[NowClickRowIndex].Cells["DEPT_NAME"].Value.ToString();
muec.USER_DEPT = dgv_USER_EXAM_CLASS_User.Rows[NowClickRowIndex].Cells["USER_DEPT"].Value.ToString();
muec.REPORT_CAPABILITY = Convert.ToInt32(cmb_REPORT_CAPABILITY.SelectedValue);
int i = burRl.Update2(muec, " DB_USER='******'");
if (i > 0)
{
MessageBoxEx.Show("修改报告权限成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
Bind_User_Exam_Class(muec.DB_USER);
}
else
{
MessageBoxEx.Show("修改报告权限失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
/// <summary>
/// 插入一条对照记录
/// </summary>
/// <param name="iuserExamClass"></param>
/// <returns></returns>
public override int Add(IModel iuserExamClass)
{
MUserExamClass userExamClass = (MUserExamClass)iuserExamClass;
Hashtable ht = new Hashtable();
ht.Add("DB_USER", userExamClass.DB_USER);
ht.Add("DEPT_NAME", userExamClass.DEPT_NAME);
ht.Add("EXAM_CLASS", userExamClass.EXAM_CLASS);
ht.Add("USER_DEPT", userExamClass.USER_DEPT);
ht.Add("REPORT_CAPABILITY", userExamClass.REPORT_CAPABILITY);
return(ExecuteSql(StringConstructor.InsertSql(TableName, ht).ToString()));
}
/// <summary>
/// 单击保存时，执行新增
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_Save_Click(object sender, EventArgs e)
{
DataGridViewSelectedRowCollection dgvsr = dgv_USER_EXAM_CLASS_Exam.SelectedRows;
if (dgvsr == null)
{
MessageBoxEx.Show("没有选中的记录!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (NowDoubleClickIndex < 0)
{
return;
}
Hashtable ht = new Hashtable();
for (int i = 0; i < dgvsr.Count; i++)
{
MUserExamClass muec = new MUserExamClass();
muec.DB_USER = dgv_USER_EXAM_CLASS_User.Rows[NowDoubleClickIndex].Cells["DB_USER"].Value.ToString();
muec.DEPT_NAME = dgv_USER_EXAM_CLASS_User.Rows[NowDoubleClickIndex].Cells["DEPT_NAME"].Value.ToString();
muec.USER_DEPT = dgv_USER_EXAM_CLASS_User.Rows[NowDoubleClickIndex].Cells["USER_DEPT"].Value.ToString();
muec.EXAM_CLASS = dgvsr[i].Cells["EXAM_CLASS"].Value.ToString();
muec.REPORT_CAPABILITY = Convert.ToInt32(cmb_REPORT_CAPABILITY.SelectedValue);
ht.Add(i, muec);
}
int j = burRl.AddMore(ht);
if (j > 0)
{
MessageBoxEx.Show("新增报告类别成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
Bind_User_Exam_Class(dgv_USER_EXAM_CLASS_User.Rows[NowDoubleClickIndex].Cells["DB_USER"].Value.ToString());
}
else
{
MessageBoxEx.Show("新增报告类别失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
