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); } }