private void InitializeButtonStatus()
{
try
{
int lockstatus = ComponentCommand.GetLockStatusValue(this.cbxLockStatus.Text);
if (lockstatus == 4700)
{//未完成
this.btn_reback.Enabled = false;
this.btnCancel.Enabled = false;
this.simpleButton_BackCommit.Enabled = false;
}
else if (lockstatus == 4701)
{//已归档
this.btn_reback.Enabled = false;
this.btnCancel.Enabled = false;
this.simpleButton_BackCommit.Enabled = false;
}
else if (lockstatus == 4702)
{//撤销归档
this.btn_reback.Enabled = true;
this.btnCancel.Enabled = false;
this.simpleButton_BackCommit.Enabled = false;
}
else if (lockstatus == 4704)
{//已完成
this.btn_reback.Enabled = false;
this.btnCancel.Enabled = false;
this.simpleButton_BackCommit.Enabled = false;
}
else if (lockstatus == 4706)
{//已提交
this.btn_reback.Enabled = true;
this.btnCancel.Enabled = false;
this.simpleButton_BackCommit.Enabled = true;
}
else if (lockstatus == 4707)
{//已提交
this.btn_reback.Enabled = true;
this.btnCancel.Enabled = false;
this.simpleButton_BackCommit.Enabled = true;
}
else if (lockstatus == 4705)
{//科室质控
this.btn_reback.Enabled = false;
this.btnCancel.Enabled = false;
this.simpleButton_BackCommit.Enabled = false;
}
else
{
this.btn_reback.Enabled = true;
this.btnCancel.Enabled = false;
this.simpleButton_BackCommit.Enabled = false;
}
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 根据查询按钮后归档状态控制归档按钮
/// </summary>
private void InitBtnStatus()
{
try
{
int lockstatus = ComponentCommand.GetLockStatusValue(this.cbxLockStatus.Text);
if (lockstatus == 4705 || lockstatus == 4707)
{//未归档
this.btn_reback.Enabled = true;
this.btnCancel.Enabled = false;
}
else if (lockstatus == 4701)
{//已归档
this.btn_reback.Enabled = false;
this.btnCancel.Enabled = true;
}
else if (lockstatus == 4702)
{//撤销归档
this.btn_reback.Enabled = true;
this.btnCancel.Enabled = false;
}
else
{
this.btn_reback.Enabled = true;
this.btnCancel.Enabled = true;
}
}
catch (Exception ex)
{
DrectSoft.Common.Ctrs.DLG.MyMessageBox.Show("错误信息！" + ex.Message);
return;
}
}
private void InitializeButtonStatus()
{
try
{
int lockstatus = ComponentCommand.GetLockStatusValue(this.cbxLockStatus.Text);
}
catch (Exception)
{
throw;
}
}
private void InitializeButtonStatus()
{
try
{
int lockstatus = ComponentCommand.GetLockStatusValue(this.cbxLockStatus.Text);
if (lockstatus == 4700)
{//未完成
this.btnCompelete.Enabled = true;
this.btnCancleCom.Enabled = false;
this.btnQc.Enabled = false;
this.btnCancleQC.Enabled = false;
this.btnCommit.Enabled = false;
}
else if (lockstatus == 4704)
{//已完成
this.btnCompelete.Enabled = false;
this.btnCancleCom.Enabled = true;
// this.btnQc.Enabled = true;
this.btnCancleQC.Enabled = false;
this.btnCommit.Enabled = false;
}
else if (lockstatus == 4705)
{//撤销归档
this.btnCompelete.Enabled = false;
this.btnCancleCom.Enabled = false;;
//this.btnQc.Enabled = false;
this.btnCancleQC.Enabled = true;
this.btnCommit.Enabled = true;
}
else
{
this.btnCompelete.Enabled = false;
this.btnCancleCom.Enabled = false;
this.btnQc.Enabled = false;
this.btnCancleQC.Enabled = false;
this.btnCommit.Enabled = false;
}
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 根据条件查询
/// </summary>
private void LoadDataByTerm()
{
try
{
if (this.dateLeaveStart.DateTime > this.dateLeaveEnd.DateTime)
{
MessageBox.Show("入院起始日期不能大于结束日期", "信息提示");
this.dateLeaveStart.Focus();
return;
}
int lockstatus = ComponentCommand.GetLockStatusValue(this.cbxLockStatus.Text);
string initsql = @"select OUTBED,patid,name,noofinpat,outhosdept,admitdept,islock from inpatient where status in (1502,1503) and islock='" + lockstatus + "' ";
//xll 未归档的应包括4700和null的值 2013-08-06
if (lockstatus == 4700)
{
initsql = @"select OUTBED, patid, name, noofinpat, outhosdept, admitdept, islock from inpatient where status in (1502, 1503) and( islock = '4700' or islock is null) ";
}
if (!string.IsNullOrEmpty(this.lookUpEditorDepartment.CodeValue))
{
initsql += string.Format(" and outhosdept='{0}' ", this.lookUpEditorDepartment.CodeValue);
}
if (!string.IsNullOrEmpty(txtName.Text))
{
initsql += string.Format(" and name like '%{0}%'", txtName.Text.ToString().Trim());
}
if (this.dateLeaveStart.Text.Trim() != null && this.dateLeaveStart.Text.Trim() != "")
{
string ds = this.dateLeaveStart.DateTime.ToString("yyyy-MM-dd 00:00:00");
string de = this.dateLeaveEnd.DateTime.ToString("yyyy-MM-dd 23:59:59");
initsql += string.Format(" and OUTHOSDATE<= '{0}' and OUTHOSDATE>='{1}'", de, ds);
}
//新增住院号查询 add by ywk 2013年8月14日 10:00:27
if (!string.IsNullOrEmpty(txtpatid.Text.ToString().Trim()))
{
initsql += string.Format(" and patid like '%{0}%'", txtpatid.Text.ToString().Trim());
}
initsql += "order by name";
DataTable dt = DS_SqlHelper.ExecuteDataTable(initsql, CommandType.Text);
this.gcInpatient.DataSource = dt;
}
catch (Exception ex)
{
DrectSoft.Common.Ctrs.DLG.MyMessageBox.Show("错误信息！" + ex.Message);
return;
}
}
/// <summary>
/// 出院病人查询方法
/// </summary>
/// <param name="valueStr"></param>
private void GoSerachOutHosPatInfo(string valueStr)
{
try
{
string sql = MedicalRecordManage.Object.DaoCommand._SELECT_MEDICAL_RECORD_INPATIENT_LONG;
if (valueStr.ToLower().Contains("iem_mainpage_diagnosis_sx"))
{
sql = DaoCommand._SELECT_MEDICAL_RECORD_INPATIENT_LONG_ZY;
}
List <DbParameter> sqlParams = new List <DbParameter>();
if (this.txtName.Text.Trim() != null && this.txtName.Text.Trim() != "")
{
sql = sql + " and i.name like '%'||@name||'%' ";
SqlParameter param1 = new SqlParameter("@name", SqlDbType.VarChar);
param1.Value = this.txtName.Text.Trim();
sqlParams.Add(param1);
}
if (this.txtNumber.Text.Trim() != null && this.txtNumber.Text.Trim() != "")
{
sql = sql + " and i.patid like '%'||@patId||'%'";
SqlParameter param2 = new SqlParameter("@patId", SqlDbType.VarChar);
param2.Value = this.txtNumber.Text.Trim();
sqlParams.Add(param2);
}
if (this.lookUpEditorDepartment.Text != null && this.lookUpEditorDepartment.Text.Trim() != "")
{
if (lookUpEditorDepartment.CodeValue != "0000")
{
sql = sql + " and i.outhosdept = @code ";
SqlParameter param5 = new SqlParameter("@code", SqlDbType.VarChar);
param5.Value = lookUpEditorDepartment.CodeValue;
sqlParams.Add(param5);
}
}
//add by ck 2013-8-26
if (this.lookUpEditorDoctor.Text != null && this.lookUpEditorDoctor.Text.Trim() != "")
{
sql = sql + " and i.resident = @inpatientID";
SqlParameter param4 = new SqlParameter("@inpatientID", SqlDbType.VarChar);
param4.Value = lookUpEditorDoctor.CodeValue;
sqlParams.Add(param4);
}//主治医生
if (this.dateAdmitStart.Text.Trim() != null && this.dateAdmitStart.Text.Trim() != "")
{
string ds = this.dateAdmitStart.DateTime.ToString("yyyy-MM-dd 00:00:00");//开始时间默认当天的0点
sql = sql + " and i.admitdate >= @ds ";
SqlParameter param6 = new SqlParameter("@ds", SqlDbType.VarChar);
param6.Value = ds;
sqlParams.Add(param6);
}
if (this.dateAdmitEnd.Text.Trim() != null && this.dateAdmitEnd.Text.Trim() != "")
{
string de = this.dateAdmitEnd.DateTime.ToString("yyyy-MM-dd 23:59:59");//结束时间默认当天23:59:59
sql = sql + " and i.admitdate <= @de ";
SqlParameter param7 = new SqlParameter("@de", SqlDbType.VarChar);
param7.Value = de;
sqlParams.Add(param7);
}
if (this.dateLeaveStart.Text.Trim() != null && this.dateLeaveStart.Text.Trim() != "")
{
string ds = this.dateLeaveStart.DateTime.ToString("yyyy-MM-dd 00:00:00");
sql = sql + " and i.outhosdate >= @dss";
SqlParameter param8 = new SqlParameter("@dss", SqlDbType.VarChar);
param8.Value = ds;
sqlParams.Add(param8);
}
if (this.dateLeaveEnd.Text.Trim() != null && this.dateLeaveEnd.Text.Trim() != "")
{
string de = this.dateLeaveEnd.DateTime.ToString("yyyy-MM-dd 23:59:59");
sql = sql + " and i.outhosdate <= @dee";
SqlParameter param9 = new SqlParameter("@dee", SqlDbType.VarChar);
param9.Value = de;
sqlParams.Add(param9);
}
if (this.cbxLockStatus.Text.Trim() != null && this.cbxLockStatus.Text.Trim() != "")
{
int lockstatus = ComponentCommand.GetLockStatusValue(this.cbxLockStatus.Text);
if (lockstatus == 4700)
{
sql = sql + " and (i.islock = @lockstatus OR i.islock is null)";
}
else
{
sql = sql + " and (i.islock = @lockstatus or @lockstatus =0) ";
}
SqlParameter param10 = new SqlParameter("@lockstatus", SqlDbType.VarChar);
param10.Value = lockstatus;
sqlParams.Add(param10);
}
DataTable dataTable = DrectSoft.DSSqlHelper.DS_SqlHelper.ExecuteDataTable(sql, sqlParams, CommandType.Text);
//压缩数据源生成新的数据源
//压缩DateSet中的记录，将住院诊断信息合并
ComponentCommand.ImpressDataSet(ref dataTable, "noofinpat", "cyzd", "operation_name");
//add by zjy 2013-6-17
string wheresql = "1=1 ";
if (this.lookUpEditorDiagnosis.Text.Trim() != null && this.lookUpEditorDiagnosis.Text.Trim() != "")
{
wheresql = wheresql + " and cyzd like '%" + this.lookUpEditorDiagnosis.Text.Trim() + "%'";
}
if (this.lookUpEditorOperation.Text.Trim() != null && this.lookUpEditorOperation.Text.Trim() != "")
{
wheresql = wheresql + " and operation_name like '%" + this.lookUpEditorOperation.Text.Trim().Trim() + "%'";
}
DataRow[] dr = dataTable.Select(wheresql);
if (dr != null && dr.Length > 0)
{
DataTable tableRecord = ToDataTable(dr);
string ResultName = string.Empty;//声明最终要在列表显示的姓名的内容
for (int i = 0; i < tableRecord.Rows.Count; i++)
{
ResultName = SqlUtil.GetPatsBabyContent(SqlUtil.App, tableRecord.Rows[i]["noofinpat"].ToString());
tableRecord.Rows[i]["Name"] = ResultName;
if (tableRecord.Rows[i]["isbaby"].ToString() == "1")
{
tableRecord.Rows[i]["PATID"] = SqlUtil.GetPatsBabyMother(dataTable.Rows[i]["mother"].ToString());
}
}
//绑定控件
this.dbGrid.DataSource = tableRecord;
lblTip.Text = "共" + tableRecord.Rows.Count.ToString() + "条";
}
else
{
this.dbGrid.DataSource = null;
lblTip.Text = "共0条";
}
}
catch (Exception ex)
{
MyMessageBox.Show(1, ex);
}
}
