/// <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); } }