/// <summary>
/// 查询事件
/// edit by Yanqiao.Cai 2012-11-16
/// 1、add try ... catch
/// 2、加载性别图片
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnQuery_Click(object sender, EventArgs e)
{
try
{
Application.DoEvents();
DevExpress.Utils.WaitDialogForm m_WaitDialog = new DevExpress.Utils.WaitDialogForm("正在查询数据...", "请稍等");
string errorStr = CheckItem();
if (!string.IsNullOrEmpty(errorStr))
{
MessageBox.Show(errorStr);
m_WaitDialog.Hide();
m_WaitDialog.Close();
return;
}
//加载性别图片
DS_Common.InitializeImage_XB(repositoryItemImageXB, imageListXB);
SqlParameter[] sqlpars = new SqlParameter[]
{
new SqlParameter("@DateOutHosBegin", dateEditBegin.DateTime.Date.ToString("yyyy-MM-dd")),
new SqlParameter("@DateOutHosEnd", string.IsNullOrEmpty(this.dateEditEnd.Text) ? DateTime.Now.ToString("yyyy-MM-dd") : this.dateEditEnd.DateTime.ToString("yyyy-MM-dd")),
new SqlParameter("@DateInHosBegin", "1900-01-01"), //dateEditInBegin.DateTime.Date.ToString("yyyy-MM-dd")
new SqlParameter("@DateInHosEnd", DateTime.Now.ToString("yyyy-MM-dd")), //string.IsNullOrEmpty(this.dateEditInEnd.Text) ? DateTime.Now.ToString("yyyy-MM-dd") : this.dateEditInEnd.DateTime.ToString("yyyy-MM-dd")
new SqlParameter("@DeptID", lookUpEditorDepartment.CodeValue.ToString() == ""?"0000":lookUpEditorDepartment.CodeValue.ToString()),
new SqlParameter("@InDiag", lookUpEditorInDiag.CodeValue.ToString()),
new SqlParameter("@OutDiag", lookUpEditorOutDiag.CodeValue.ToString()),
new SqlParameter("@Status", lookUpRecordStatus.EditValue.ToString()),
new SqlParameter("@Patientname", this.txt_patiName.Text.Trim()),
new SqlParameter("@Recordid", this.txt_recordID.Text.Trim()),
new SqlParameter("@Physician", this.lookUpEditorPhysician.CodeValue.ToString())
};
DataTable table = SqlUtil.App.SqlHelper.ExecuteDataTable("usp_GetRecordNoOnFileWyt", sqlpars, CommandType.StoredProcedure);
//gridviewRecordNoOnFile.SelectAll();
//gridviewRecordNoOnFile.DeleteSelectedRows();
gridControlRecordNoOnFile.DataSource = table;
m_WaitDialog.Hide();
lblTip.Text = "共" + table.Rows.Count.ToString() + "份";
if (table.Rows.Count <= 0)
{
SqlUtil.App.CustomMessageBox.MessageShow("没有满足条件的记录");
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
/// <summary>
/// 查询事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnQuery_Click(object sender, EventArgs e)
{
try
{
if (CheckDate())
{
DevExpress.Utils.WaitDialogForm m_WaitDialog = new DevExpress.Utils.WaitDialogForm("正在查询数据...", "请稍等");
InitializeButtonStatus();
string serachtype = string.Empty;
if (rdbtnInPat.Checked)
{
serachtype = "inhos";
}
if (rdbtnOutPat.Checked)
{
serachtype = "outhos";
}
LoadData(serachtype);
m_WaitDialog.Hide();
}
}
catch (Exception ex)
{
MyMessageBox.Show(1, ex);
}
}
public static void WaitClear()
{
//if (dlgWaitWind != null)
// dlgWaitWind.Close();
//ptEndProcess();
dlgWaitWind.Hide();
}
private void btnQuery_Click(object sender, EventArgs e)
{
try
{
//if (CheckDate())
//{
DevExpress.Utils.WaitDialogForm m_WaitDialog = new DevExpress.Utils.WaitDialogForm("正在查询数据...", "请稍等");
LoadData();
m_WaitDialog.Hide();
//}
}
catch (Exception ex)
{
DrectSoft.Common.Ctrs.DLG.MyMessageBox.Show(1, ex);
}
}
//s
private void btnQuery_Click(object sender, EventArgs e)
{
try
{
//if (CheckDate())
//{
DevExpress.Utils.WaitDialogForm m_WaitDialog = new DevExpress.Utils.WaitDialogForm("正在查询数据...", "请稍等");
LoadData();
m_WaitDialog.Hide();
this.txtDoctor.Focus();
//}
}
catch (Exception ex)
{
MyMessageBox.Show(1, ex);
}
}
/// <summary>
/// 查询事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnQuery_Click(object sender, EventArgs e)
{
try
{
if (CheckDate())
{
m_WaitDialog = new DevExpress.Utils.WaitDialogForm("正在查询数据...", "请稍等");
GetInitDB(true);
MyControlEventArgs retvals = new MyControlEventArgs(true, this.User_Table.Rows.Count.ToString(), this);
if (OnButtonClick != null)
{
OnButtonClick(this, retvals);
}
m_WaitDialog.Hide();
m_WaitDialog.Close();
}
}
catch (Exception ex)
{
m_WaitDialog.Close();
MyMessageBox.Show(1, ex);
}
}
/// <summary>
/// 查询事件
/// edit by Yanqiao.Cai 2012-11-16
/// 1、add try ... catch
/// 2、加载性别图片
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnQuery_Click(object sender, EventArgs e)
{
try
{
DevExpress.Utils.WaitDialogForm m_WaitDialog = new DevExpress.Utils.WaitDialogForm("正在查询数据...", "请稍等");
string errorStr = CheckItem();
if (!string.IsNullOrEmpty(errorStr))
{
m_WaitDialog.Hide();
MessageBox.Show(errorStr);
return;
}
SqlParameter[] sqlParam = new SqlParameter[]
{ new SqlParameter("@DateBegin", SqlDbType.VarChar),
new SqlParameter("@DateEnd", SqlDbType.VarChar),
new SqlParameter("@PatID", SqlDbType.VarChar),
new SqlParameter("@Name", SqlDbType.VarChar),
new SqlParameter("@SexID", SqlDbType.VarChar),
new SqlParameter("@AgeBegin", SqlDbType.VarChar),
new SqlParameter("@AgeEnd", SqlDbType.VarChar),
new SqlParameter("@OutHosDept", SqlDbType.VarChar),
new SqlParameter("@InDiag", SqlDbType.VarChar),
new SqlParameter("@OutDiag", SqlDbType.VarChar),
new SqlParameter("@SurgeryID", SqlDbType.VarChar),
new SqlParameter("@Physician", SqlDbType.VarChar) };
sqlParam[0].Value = dateEditBegin.DateTime.Date.ToString("yyyy-MM-dd");
sqlParam[1].Value = string.IsNullOrEmpty(this.dateEditEnd.Text) ? DateTime.Now.ToString("yyyy-MM-dd") : this.dateEditEnd.DateTime.ToString("yyyy-MM-dd");
sqlParam[2].Value = txtPatID.Text.Trim();
sqlParam[3].Value = txtName.Text.Trim();
sqlParam[4].Value = radioSex.SelectedIndex == 0 ? "" : radioSex.SelectedIndex.ToString();
sqlParam[5].Value = txtAgeBegin.Text.Trim();
sqlParam[6].Value = txtAgeEnd.Text.Trim();
sqlParam[7].Value = lookUpEditorDepartment.CodeValue;
sqlParam[8].Value = lookUpEditorInDiag.CodeValue;
sqlParam[9].Value = lookUpEditorOutDiag.CodeValue;
sqlParam[10].Value = lookUpEditorSurgery.CodeValue;
sqlParam[11].Value = this.lookUpEditorPhysician.CodeValue.Trim();
DataTable table = SqlUtil.App.SqlHelper.ExecuteDataTable("usp_GetRecordOnFile", sqlParam, CommandType.StoredProcedure);
//加载性别图片
DS_Common.InitializeImage_XB(repositoryItemImageXB, imageListXB);
gridViewRecordOnFile.SelectAll();
gridViewRecordOnFile.DeleteSelectedRows();
gridControlRecordOnFile.DataSource = table;
m_WaitDialog.Hide();
lblTip.Text = "共" + table.Rows.Count.ToString() + "条记录";
if (table.Rows.Count <= 0)
{
SqlUtil.App.CustomMessageBox.MessageShow("没有满足条件的记录");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}