/// <summary>
/// 抓取受邀医师
/// Add by xlb 2013-03-11
/// </summary>
/// <param name="deptId"></param>
private void InitDoctor(string deptId)
{
try
{
lookUpEditorEmployee.Kind = WordbookKind.Sql;
lookUpEditorEmployee.ListWindow = lookUpWindowEmployee;
//抓取当前科室配置项里指定级别的医师
string value = ConsultCommon.GetConfigKey("ConsultDocLevel");
string[] levelList = value.Split(',');
if (levelList == null || levelList.Length <= 1)
{
throw new Exception("会诊受邀级别配置项出错");
}
string str = "(";
for (int i = 0; i < levelList.Length; i++)
{
str += levelList[i] + ",";
}
str += "'')";
//Modify by xlb 2013-06-06 窜科室查询
string sql = @"SELECT ID, NAME, PY, WB,grade FROM users u WHERE deptid =@deptid AND valid = '1'
and grade in " + str +
"union SELECT ID, NAME, PY, WB,grade FROM users u WHERE valid = '1'" +
" and grade in " + str + " and exists (SELECT 1 FROM user2dept WHERE user2dept.userid = u.id and user2dept.deptid =@deptid ) ";
SqlParameter[] sps =
{
new SqlParameter("@deptid", deptId)
};
DataTable dt = DS_SqlHelper.ExecuteDataTable(sql, sps, CommandType.Text);
for (int i = 0; i < dt.Columns.Count; i++)
{
if (dt.Columns[i].ColumnName.ToUpper().Trim() == "ID")
{
dt.Columns[i].Caption = "代码";
}
else if (dt.Columns[i].ColumnName.ToUpper().Trim() == "NAME")
{
dt.Columns[i].Caption = "名称";
}
}
Dictionary <string, int> colWidths = new Dictionary <string, int>();
colWidths.Add("ID", 60);
colWidths.Add("NAME", 70);
SqlWordbook wordBook = new SqlWordbook("ApplyDoctor", dt, "ID", "NAME", colWidths, "ID//NAME//PY//WB");
lookUpEditorEmployee.SqlWordbook = wordBook;
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 初始化指定医师级别
/// Add by xlb 2013-03-11
/// </summary>
private void InitDoctorLevel()
{
try
{
lookUpEditorDocLevel.Kind = WordbookKind.Sql;
lookUpEditorDocLevel.ListWindow = lookUpWindowLevel;
string value = ConsultCommon.GetConfigKey("ConsultDocLevel");//根据配置抓取指定级别
string[] levelList = value.Split(',');
if (levelList == null || levelList.Length <= 1)
{
throw new Exception("会诊受邀级别配置项出错");
}
string str = "(";
for (int i = 0; i < levelList.Length; i++)
{
str += levelList[i] + ",";
}
str += "'')";
string sqlForDocLevel = @"SELECT ID, NAME, PY, WB FROM categorydetail cd
WHERE cd.ID IN " + str + "";
DataTable dtDocLevel = DS_SqlHelper.ExecuteDataTable(sqlForDocLevel, CommandType.Text);
if (dtDocLevel == null || dtDocLevel.Rows.Count <= 0)
{
return;
}
for (int i = 0; i < dtDocLevel.Columns.Count; i++)
{
if (dtDocLevel.Columns[i].ColumnName.ToUpper().Trim() == "NAME")
{
dtDocLevel.Columns[i].Caption = "医生级别";
}
}
Dictionary <string, int> colWidths = new Dictionary <string, int>();
colWidths.Add("NAME", 130);
SqlWordbook wordBook = new SqlWordbook("Director", dtDocLevel, "ID", "NAME", colWidths, "ID//NAME//PY//WB");
lookUpEditorDocLevel.SqlWordbook = wordBook;
}
catch (Exception ex)
{
throw ex;
}
}
