/// <summary>
/// 获取PACS用户列表并填充
/// </summary>
/// <param name="strWhere"></param>
private void FindData(string strWhere)
{
DataTable dt = buser.GetList(strWhere + " 1=1 order by DB_USER");
if (dt != null)
{
dgv_ImgEquipment.DataSource = dt;
}
}
/// <summary>
/// 绑定检查医生
/// </summary>
/// <returns></returns>
public void Bind_ExamDoctor(string ExamDept, ComboBox cmb_ExamDoctor)
{
BUser bUser = new BUser();
System.Data.DataTable dt = bUser.GetList("CLINIC_OFFICE = '" + ExamDept + "'");
cmb_ExamDoctor.DataSource = dt;
cmb_ExamDoctor.DisplayMember = dt.Columns["DOCTOR_NAME"].ColumnName;
cmb_ExamDoctor.ValueMember = dt.Columns["DOCTOR_ID"].ColumnName;
cmb_ExamDoctor.SelectedIndex = -1;
}
/// <summary>
/// 查找用户信息填充到左边的网格中
/// </summary>
/// <param name="contidion"></param>
private void Bind_USER_EXAM_CLASS_User(string contidion)
{
DataTable dt = buser.GetList(contidion + " 1=1 order by DB_USER");
if (dt != null)
{
dgv_USER_EXAM_CLASS_User.DataSource = dt;
}
txt_DB_USER.Text = "";
txt_USER_NAME.Text = "";
}
private void FindUserInfo(string strWhere)//查找用户信息
{
DataTable dt = BUse.GetList(strWhere + " CLINIC_OFFICE_CODE = '" + GetConfig.ExamDeptCode + "' order by DOCTOR_ID ");
if (dt.Rows.Count > 0)
{
this.dgv_UserManage.DataSource = dt;
}
this.gb_PromptInfo.Visible = false;
rowcount = this.dgv_UserManage.Rows.Count + 1;
}
/// <summary>
/// 导出
/// </summary>
private void MasterToolBar_DoExport_Click(object sender, EventArgs e)
{
_currentDt = bUser.GetList(GetConduction()).Tables[0];
if (isSearch && _currentDt != null)
{
foreach (DataRow row in _currentDt.Rows)
{
try
{
row["CODE"] = CConvert.ToString(row["CODE"]).Substring(2);
if (row["CREATE_USER"] != null && bCommon.GetBaseMaster("USER", CConvert.ToString(row["CREATE_USER"])) != null)
{
row["CREATE_USER"] = bCommon.GetBaseMaster("USER", CConvert.ToString(row["CREATE_USER"])).Name;
}
if (row["LAST_UPDATE_USER"] != null && bCommon.GetBaseMaster("USER", CConvert.ToString(row["LAST_UPDATE_USER"])) != null)
{
row["LAST_UPDATE_USER"] = bCommon.GetBaseMaster("USER", CConvert.ToString(row["LAST_UPDATE_USER"])).Name;
}
}
catch { }
}
int result = CExport.DataTableToExcel(_currentDt, CConstant.USER_HEADER, CConstant.USER_COLUMNS, "USER", "USER");
if (result == CConstant.EXPORT_SUCCESS)
{
MessageBox.Show("数据已经成功导出!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else if (result == CConstant.EXPORT_FAILURE)
{
MessageBox.Show("数据导出失败。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show("没有可以导出的数据。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
//申请科室改变时填充申请医生下拉框
private void cmb_REQ_DEPT_NAME_SelectedIndexChanged(object sender, EventArgs e)
{
if (cmb_REQ_DEPT_NAME.Text == "")
{
return;
}
BUser bu = new BUser();
DataTable dt = bu.GetList("DEPT_NAME='" + cmb_REQ_DEPT_NAME.Text + "'");
DataRow DR = dt.NewRow();
dt.Rows.InsertAt(DR, 0);
cmb_REFER_DOCTOR.DataSource = dt;
cmb_REFER_DOCTOR.DisplayMember = "USER_NAME";
cmb_REFER_DOCTOR.ValueMember = "USER_NAME";
}
