/// <summary>
/// 获取角色权限列表
/// </summary>
private void LoadAdminDeptsList()
{
ListQcAdminDepts.Clear();
short shRet = QcAdminDeptsAccess.Instance.GetQcAdminDeptsList(this.UserInfo.USER_ID, ref ListQcAdminDepts);
if (shRet != SystemData.ReturnValue.OK &&
shRet != SystemData.ReturnValue.RES_NO_FOUND)
{
MessageBoxEx.Show("无法获取角色权限！");
return;
}
if (dicAdminDepts == null)
{
dicAdminDepts = new Dictionary <string, QcAdminDepts>();
}
dicAdminDepts.Clear();
if (ListQcAdminDepts == null || ListQcAdminDepts.Count <= 0)
{
return;
}
for (int index = 0; index < ListQcAdminDepts.Count; index++)
{
QcAdminDepts qcAdminDepts = ListQcAdminDepts[index];
if (dicAdminDepts.ContainsKey(qcAdminDepts.DEPT_CODE))
{
continue;
}
dicAdminDepts.Add(qcAdminDepts.DEPT_CODE, qcAdminDepts);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
ListQcAdminDepts.Clear();
foreach (Control item in this.flpGrant.Controls)
{
CheckBox chk = item as CheckBox;
if (item == null)
{
continue;
}
if (chk.Checked == false)
{
continue;
}
DeptInfo dpetDict = chk.Tag as DeptInfo;
QcAdminDepts qcAdminDepts = new QcAdminDepts();
qcAdminDepts.DEPT_CODE = dpetDict.DEPT_CODE;
qcAdminDepts.DEPT_NAME = dpetDict.DEPT_NAME;
qcAdminDepts.USER_ID = this.UserInfo.USER_ID;
qcAdminDepts.USER_NAME = this.UserInfo.USER_NAME;
ListQcAdminDepts.Add(qcAdminDepts);
}
short shRet = QcAdminDeptsAccess.Instance.SaveQcAdminDeptsList(this.UserInfo.USER_ID, ListQcAdminDepts);
if (shRet != SystemData.ReturnValue.OK)
{
MessageBoxEx.Show("管辖科室设置失败！");
return;
}
MessageBoxEx.ShowMessage("管辖科室设置成功！");
}
/// <summary>
/// 新增一条自动核查规则配置信息
/// </summary>
/// <param name="qcAdminDepts">自动核查规则配置信息</param>
/// <returns>SystemData.ReturnValue</returns>
public short Insert(QcAdminDepts qcAdminDepts)
{
if (qcAdminDepts == null)
{
LogManager.Instance.WriteLog("QcCheckPointAccess.Insert", new string[] { "timeQCRule" }
, new object[] { qcAdminDepts }, "参数不能为空");
return(SystemData.ReturnValue.PARAM_ERROR);
}
string szField = string.Format("{0},{1},{2},{3}"
, SystemData.QcAdminDeptsTable.DEPT_CODE
, SystemData.QcAdminDeptsTable.DEPT_NAME
, SystemData.QcAdminDeptsTable.USER_ID
, SystemData.QcAdminDeptsTable.USER_NAME);
string szValue = string.Format("'{0}','{1}','{2}','{3}'"
, qcAdminDepts.DEPT_CODE
, qcAdminDepts.DEPT_NAME
, qcAdminDepts.USER_ID
, qcAdminDepts.USER_NAME);
string szSQL = string.Format(SystemData.SQL.INSERT, SystemData.DataTable.QC_ADMIN_DEPTS, szField, szValue);
int nCount = 0;
try
{
nCount = base.MedQCAccess.ExecuteNonQuery(szSQL, CommandType.Text);
}
catch (Exception ex)
{
LogManager.Instance.WriteLog("", new string[] { "szSQL" }, new object[] { szSQL }, ex);
return(SystemData.ReturnValue.EXCEPTION);
}
if (nCount <= 0)
{
LogManager.Instance.WriteLog("", new string[] { "szSQL" }, new object[] { szSQL }, "SQL语句执行后返回0!");
return(SystemData.ReturnValue.EXCEPTION);
}
return(SystemData.ReturnValue.OK);
}
/// <summary>
/// 病历质控系统,获取质控管辖科室
/// </summary>
/// <param name="lstQCMessageTemplets">质控反馈信息字典列表</param>
/// <returns>SystemData.ReturnValue</returns>
public short GetQcAdminDeptsList(ref List <QcAdminDepts> lstQcAdminDepts)
{
if (base.MedQCAccess == null)
{
return(SystemData.ReturnValue.PARAM_ERROR);
}
string szField = string.Format("{0},{1},{2},{3}"
, SystemData.QcAdminDeptsTable.USER_ID
, SystemData.QcAdminDeptsTable.USER_NAME
, SystemData.QcAdminDeptsTable.DEPT_CODE
, SystemData.QcAdminDeptsTable.DEPT_NAME
);
string szCondtion = string.Format("1=1");
string szSQL = string.Format(SystemData.SQL.SELECT_WHERE, szField, SystemData.DataTable.QC_ADMIN_DEPTS, szCondtion);
IDataReader dataReader = null;
try
{
dataReader = base.MedQCAccess.ExecuteReader(szSQL, CommandType.Text);
if (dataReader == null || dataReader.IsClosed || !dataReader.Read())
{
return(SystemData.ReturnValue.RES_NO_FOUND);
}
if (lstQcAdminDepts == null)
{
lstQcAdminDepts = new List <QcAdminDepts>();
}
do
{
QcAdminDepts qcAdminDepts = new QcAdminDepts();
if (!dataReader.IsDBNull(0))
{
qcAdminDepts.USER_ID = dataReader.GetString(0);
}
if (!dataReader.IsDBNull(1))
{
qcAdminDepts.USER_NAME = dataReader.GetString(1);
}
if (!dataReader.IsDBNull(2))
{
qcAdminDepts.DEPT_CODE = dataReader.GetString(2);
}
if (!dataReader.IsDBNull(3))
{
qcAdminDepts.DEPT_NAME = dataReader.GetString(3);
}
lstQcAdminDepts.Add(qcAdminDepts);
} while (dataReader.Read());
return(SystemData.ReturnValue.OK);
}
catch (Exception ex)
{
LogManager.Instance.WriteLog("MedQCAccess.GetQCMessageTempletList", new string[] { "szSQL" }, new object[] { szSQL }, ex);
return(SystemData.ReturnValue.EXCEPTION);
}
finally
{
if (dataReader != null)
{
dataReader.Close();
dataReader.Dispose();
dataReader = null;
}
base.MedQCAccess.CloseConnnection(false);
}
}
