public FrmBedEdit(DeptInfo deptInfo, RoomInfo roomInfo) { // // Windows 窗体设计器支持所必需的 // InitializeComponent(); // // TODO: 在 InitializeComponent 调用后添加任何构造函数代码 // //新增床位 // _addNew = true; AddButtonToTextBox(this.btnChargeDoc, this.txtChargeDoc); AddButtonToTextBox(this.btnManageDoc, this.txtManageDoc); AddButtonToTextBox(this.btnFunNurse, this.txtFunNurse); AddButtonToTextBox(this.btnLinkFee, this.txtLinkFee); #region 初始化录入控件 this.ClearTextBoxInfo(this.txtChargeDoc); this.ClearTextBoxInfo(this.txtManageDoc); this.ClearTextBoxInfo(this.txtFunNurse); this.ClearTextBoxInfo(this.txtLinkFee); #endregion _deptInfo = deptInfo; _roomInfo = roomInfo; _bedInfo = new BedInfo(); lblWardInfo.Text = "病区:[" + roomInfo.WardName + "] 科室:[" + deptInfo.DeptName + "]"; lblCaption.Text = "新增病房"; this.Text = lblCaption.Text; this.txtBedNo.Text = this.GetDefaultBedNo(); LoadWardDept(deptInfo.WardID); }
private void bedCardControl1_BedFormatStyleEvent(BedInfo bed, string dataPropertyName, ref Font contextFont, ref Brush contextBrush) { if (bed.PatientID % 3 == 1 && dataPropertyName == "PatientNum") { contextFont = new System.Drawing.Font("微软雅黑", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); contextBrush = new SolidBrush(Color.Red); } }
public List <BedInfo> getBedInfoList(DataConnection pclsCache, string id) { List <BedInfo> bedInfoList = new List <BedInfo>(); CacheCommand cmd = null; CacheDataReader cdr = null; try { if (!pclsCache.Connect()) { //MessageBox.Show("Cache数据库连接失败"); return(null); } cmd = new CacheCommand(); cmd = Vs.DeckBed.GetBedInfoList(pclsCache.CacheConnectionObject); //cmd = Vs.MstDeckInfo.SetData(pclsCache.CacheConnectionObject); cmd.Parameters.Add("DeckId", CacheDbType.NVarChar).Value = id; cdr = cmd.ExecuteReader(); while (cdr.Read()) { BedInfo bedInfo = new BedInfo(); bedInfo.DeckId = cdr["DeckId"].ToString(); bedInfo.DeckSectionId = cdr["DeckSectionId"].ToString(); bedInfo.WardCode = cdr["WardCode"].ToString(); bedInfo.RoomCode = cdr["RoomCode"].ToString(); bedInfo.BedCode = cdr["BedCode"].ToString(); bedInfo.Status = Convert.ToInt32(cdr["Status"]); bedInfo.PatientName = cdr["PatientId"].ToString(); bedInfoList.Add(bedInfo); } return(bedInfoList); } catch (Exception ex) { HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "DeckInfoMethod.getBedInfoList", "数据库操作异常! error information : " + ex.Message + Environment.NewLine + ex.StackTrace); return(null); } finally { if ((cdr != null)) { cdr.Close(); cdr.Dispose(true); cdr = null; } if ((cmd != null)) { cmd.Parameters.Clear(); cmd.Dispose(); cmd = null; } pclsCache.DisConnect(); } }
private void LoadBedDataNew() { //other //bedCardControl1.BedContextFields.Add(new ContextField("其 他", "other")); //第二步:获取病人数据,数据必须是List集合 List <BedInfo> list = new List <BedInfo>(); for (int i = 0; i < 20; i++)//前20病人显示信息 { //支持自定义床头卡的内容显示 BedInfo bed = new BedInfo(); bed.BedNo = "W" + i.ToString(); bed.PatientID = i + 1; bed.PatientNum = "0000012" + i; bed.PatientName = "昂三" + i; if (i % 3 == 0) { bed.Sex = "男"; } else { bed.Sex = "女"; } bed.Age = "120岁"; bed.Diet = "计算"; bed.PatTypeName = "居民医保"; bed.Diagnosis = "诊断是的安定和水电费水电费和、安定和水电费水电费和"; bed.Dept = "妇产科"; bed.Doctor = "李医生"; bed.Nurse = "王美女"; bed.NursingLever = "3"; bed.EnterTime = DateTime.Now.ToString("yyyy-MM-dd hh:mm"); bed.Situation = (i % 5).ToString(); bed.NursingLever = (i % 5).ToString(); bed.DietType = (i % 6).ToString(); if (i > 16) { bed.Group = true; } if (i == 15) { bed.Step = 8; } //bed.other = "!@#$%^&"; list.Add(bed); } //后面的显示空床位 for (int i = 20; i < 34; i++) { BedInfo bed = new BedInfo(); bed.BedNo = i.ToString(); list.Add(bed); } //第三步:将病人数据绑定到数据源上显示 bedCardControlNew1.DataSource = list; }
private void LoadBedData() { //第一步:添加床头卡要显示的内容项 bedCardControl1.BedContextFields = new List <ContextField>(); bedCardControl1.BedContextFields.Add(new ContextField("住院号", "PatientNum")); bedCardControl1.BedContextFields.Add(new ContextField("结 算", "Diet")); //bedCardControl1.BedContextFields.Add(new ContextField("诊 断", "Diagnosis")); bedCardControl1.BedContextFields.Add(new ContextField("科 室", "Dept")); bedCardControl1.BedContextFields.Add(new ContextField("医 生", "Doctor")); bedCardControl1.BedContextFields.Add(new ContextField("入 科", "EnterTime")); //other //bedCardControl1.BedContextFields.Add(new ContextField("其 他", "other")); //第二步:获取病人数据,数据必须是List集合 List <BedInfo> list = new List <BedInfo>(); for (int i = 0; i < 20; i++)//前20病人显示信息 { //支持自定义床头卡的内容显示 BedInfo bed = new BedInfo(); bed.BedNo = i.ToString(); bed.PatientID = i + 1; bed.PatientNum = "0000012" + i; bed.PatientName = "昂三" + i; if (i % 3 == 0) { bed.Sex = "男"; } else { bed.Sex = "女"; } bed.Age = "11岁"; bed.Diet = "计算"; bed.Diagnosis = "诊断是的安定和水电费水电费和、安定和水电费水电费和"; bed.Dept = "妇产科"; bed.Doctor = "李医生"; bed.Nurse = "03"; bed.EnterTime = DateTime.Now.ToString("yyyy-MM-dd hh:mm"); //bed.other = "!@#$%^&"; list.Add(bed); } //后面的显示空床位 for (int i = 20; i < 34; i++) { BedInfo bed = new BedInfo(); bed.BedNo = i.ToString(); list.Add(bed); } //第三步:将病人数据绑定到数据源上显示 bedCardControl1.DataSource = list; }
private void ShowBedInfo(BedInfo bedInfo) { this.txtBedNo.Tag = bedInfo.BedID; this.txtBedNo.Text = bedInfo.BedNo; this.txtChargeDoc.Text = bedInfo.ChargeDocName; this.txtChargeDoc.Tag = bedInfo.ChargeDocID; this.txtManageDoc.Text = bedInfo.ManageDocName; this.txtManageDoc.Tag = bedInfo.ManageDocID; this.txtFunNurse.Text = bedInfo.FunNurseName; this.txtFunNurse.Tag = bedInfo.FunNurseID; this.txtLinkFee.Text = bedInfo.LinkFeeName.Trim(); this.txtLinkFee.Tag = bedInfo.LinkFeeID; this.chkPlus.Checked = bedInfo.IsPlus; }
public void Execute ( Entity entity, int index, [ReadOnly] ref Bed c0, [ReadOnly] ref Translation c1) { BedInfos[index] = new BedInfo { Entity = entity, Pos = c1.Value, SleepTime = c0.SleepTime, Restoration = c0.Restoration, }; }
private bool DataExists(BedInfo bedInfo) { string sql = ""; DataRow dr = null; //判断床位号是否存在 sql = "select bed_id from zy_beddiction where ward_id='" + bedInfo.WardID + "' and bed_no='" + bedInfo.BedNo + "'"; dr = InstanceForm.BDatabase.GetDataRow(sql); if (dr != null) { MessageBox.Show("[" + bedInfo.WardName + "] 已经有床号为[" + bedInfo.BedNo + "]的病床", "", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } return(true); }
private void ultraButtonRefresh_Click(object sender, EventArgs e) { dsBedList = new DataSet(); //ultraGridBedList.Rows.Refresh(Infragistics.Win.UltraWinGrid.RefreshRow.RefreshDisplay); try { objHospDB = new HospitalDB(); BedInfo objBedinfo = new BedInfo(objHospDB); dtBedList = objBedinfo.GetAllAsDataTable(); ultraGridBedList.DataSource = dtBedList; } catch (Exception ex) { MessageBox.Show("Error"); } }
public FrmBedEdit(BedInfo bedInfo) { // // Windows 窗体设计器支持所必需的 // InitializeComponent(); // // TODO: 在 InitializeComponent 调用后添加任何构造函数代码 // //修改床位 // _addNew = false; AddButtonToTextBox(this.btnChargeDoc, this.txtChargeDoc); AddButtonToTextBox(this.btnManageDoc, this.txtManageDoc); AddButtonToTextBox(this.btnFunNurse, this.txtFunNurse); AddButtonToTextBox(this.btnLinkFee, this.txtLinkFee); _bedInfo = bedInfo; this.ShowBedInfo(bedInfo); lblWardInfo.Text = "病区:[" + bedInfo.WardName + "] 科室:[" + bedInfo.DeptName + "]"; lblCaption.Text = "修改病房"; this.Text = lblCaption.Text; this.txtBedNo.Enabled = false; #region 增加房间菜单 DataTable dtRoom = InstanceForm.BDatabase.GetDataTable("select distinct(room_no) as room_no from zy_beddiction where ward_id='" + bedInfo.WardID + "' and room_no<>'" + bedInfo.RoomNo + "' order by room_no"); for (int i = 0; i <= dtRoom.Rows.Count - 1; i++) { MenuItem mRoom = new MenuItem(); mRoom.Text = dtRoom.Rows[i]["room_no"].ToString(); mRoom.Click += new EventHandler(mRoom_Click); this.mnuRoom.MenuItems.Add(mRoom); } #endregion LoadWardDept(bedInfo.WardID); for (int i = 0; i <= this.cboKs.Items.Count - 1; i++) { cboKs.SelectedIndex = i; if (Convert.ToInt64(cboKs.SelectedValue) == bedInfo.DeptID) { break; } } }
private void ultraButtonDelete_Click(object sender, EventArgs e) { ultraGridBedList.Rows[this.ultraGridBedList.ActiveRow.Index].Delete(true); try { objHospDB = new HospitalDB(); BedInfo objBedInfo = new BedInfo(objHospDB); BedInfoRow objBedInfoRow = new BedInfoRow(); objBedInfoRow.BedIDD = Convert.ToInt32(id); objBedInfo.Delete(objBedInfoRow); //SqlCommand cmd = objHospDB.CreateCommand("delete from BedInfo where ID='" + this.id + "';"); // int o = cmd.ExecuteNonQuery(); // conn.Close(); MessageBox.Show(":deleted"); }catch (Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// 床头卡信息绑定 /// </summary> /// <param name="dtPatient">病人信息</param> /// <returns>床头卡信息</returns> private List <BedInfo> GetBedInfo(DataTable dtPatient) { // 定义床位集合 List <BedInfo> list = new List <BedInfo>(); // 当前病区有床位的场合 if (dtPatient != null && dtPatient.Rows.Count > 0) { // 循环显示床位 for (int i = 0; i < dtPatient.Rows.Count; i++) { BedInfo bed = new BedInfo(); // 床位相关数据 bed.BedNo = dtPatient.Rows[i]["BedNO"].ToString(); // 床位号 bed.WardCode = dtPatient.Rows[i]["WardID"].ToString(); // 病区ID bed.PatientID = Convert.ToInt32(dtPatient.Rows[i]["PatListID"].ToString()); // 病人登记ID bed.PatientNum = dtPatient.Rows[i]["SerialNumber"].ToString(); // 住院流水号 bed.CaseNumber = Tools.ToDecimal(dtPatient.Rows[i]["CaseNumber"].ToString()); // 住院病案号 bed.PatientName = dtPatient.Rows[i]["PatName"].ToString(); // 病人姓名 bed.Sex = dtPatient.Rows[i]["PatSex"].ToString(); // 性别 bed.Age = GetAge(dtPatient.Rows[i]["Age"].ToString()); // 年龄 bed.Diagnosis = dtPatient.Rows[i]["EnterDiseaseName"].ToString(); // 入院诊断 bed.Dept = dtPatient.Rows[i]["DeptName"].ToString(); // 入院科室 bed.DeptCode = dtPatient.Rows[i]["PatDeptID"].ToString(); // 入院科室 bed.Doctor = dtPatient.Rows[i]["DoctorName"].ToString(); // 医生 bed.Nurse = dtPatient.Rows[i]["NurseName"].ToString(); // 护士 bed.EnterTime = DateTime.Parse(dtPatient.Rows[i]["EnterHDate"].ToString()).ToString("yyyy-MM-dd"); // 入院时间 bed.PatTypeName = dtPatient.Rows[i]["patTypeName"].ToString(); bed.NursingLever = dtPatient.Rows[i]["NursingLever"].ToString(); //护理级别 bed.DietType = dtPatient.Rows[i]["DietType"].ToString(); //饮食种类 bed.Situation = dtPatient.Rows[i]["OutSituation"].ToString(); //出院情况 bed.Step = Convert.ToInt32(dtPatient.Rows[i]["IsLeaveHosOrder"]); //是否定义出院 list.Add(bed); } } return(list); }
private void ultraButtonRegister_Click(object sender, EventArgs e) { try { if (this.frmStrMode == "Edit") { objHospDB = new HospitalDB(); BedInfo objBedInfo = new BedInfo(objHospDB); BedInfoRow objBedInfoRow = new BedInfoRow(); objBedInfoRow.BedIDD = Convert.ToInt32(classtextEditorID.Text); objBedInfoRow.BedName = ultraTextEditorBedName.Text; objBedInfoRow.RatePerDay = Convert.ToInt32(classtERatePerDay.Text); objBedInfoRow.BedType = ultraComboBedType.Value.ToString(); objBedInfo.Update(objBedInfoRow); MessageBox.Show(":updated"); openfrmBedList(); } else { objHospDB = new HospitalDB(); BedInfo objBedInfo = new BedInfo(objHospDB); BedInfoRow objBedInfoRow = new BedInfoRow(); objBedInfoRow.BedName = ultraTextEditorBedName.Text; objBedInfoRow.RatePerDay = Convert.ToInt32(classtextEditorID.Text); objBedInfoRow.BedType = ultraComboBedType.Text; objBedInfo.Insert(objBedInfoRow); MessageBox.Show(":Registerd"); openfrmBedList(); } }catch (Exception ex) { MessageBox.Show(ex.Message); } }
private bool SaveBedInfo(BedInfo _bedInfo_old) { if (!DataExists()) { return(false); } try { string sql = ""; int plus = this.chkPlus.Checked ? 1 : 0; string cznr = ""; if (_addNew) { //新增 sql = "insert into zy_beddiction (ward_id,dept_id,room_no,bed_no,hoitem_id,zz_doc,zy_doc,chargenurse,isplus,isinuse)"; sql += " values('" + _bedInfo.WardID + "'," + _bedInfo.DeptID + ",'" + _bedInfo.RoomNo + "','" + _bedInfo.BedNo + "'," + _bedInfo.LinkFeeID + "," + _bedInfo.ChargeDocID + "," + _bedInfo.ManageDocID + "," + _bedInfo.FunNurseID + "," + plus + ",0)"; cznr = "增加: " + _bedInfo.WardName + _bedInfo.DeptName + "(" + _bedInfo.BedNo + "床) hoitem_id:" + _bedInfo.LinkFeeName + "(" + _bedInfo.LinkFeeID + ")"; } else { //更新 sql = "update zy_beddiction set zz_doc=" + _bedInfo.ChargeDocID + ",zy_doc=" + _bedInfo.ManageDocID + ",chargenurse=" + _bedInfo.FunNurseID + ",hoitem_id=" + _bedInfo.LinkFeeID + ",isplus=" + plus + ",dept_id=" + _bedInfo.DeptID; sql += " where bed_id='" + _bedInfo.BedID + "'"; cznr = "修改:原" + _bedInfo_old.WardName + _bedInfo_old.DeptName + "(" + _bedInfo_old.BedNo + "床) hoitem_id:" + _bedInfo_old.LinkFeeName + "(" + _bedInfo_old.LinkFeeID + ") 现改为" + _bedInfo.WardName + _bedInfo.DeptName + "(" + _bedInfo.BedNo + "床) hoitem_id:" + _bedInfo.LinkFeeName + "(" + _bedInfo.LinkFeeID + ")" + " 主治医生|" + _bedInfo.ChargeDocName + "|护士|" + _bedInfo.FunNurseName + "|管床医生|" + _bedInfo.ManageDocName; } InstanceForm.BDatabase.DoCommand(sql); SaveLog("床位保存", cznr); return(true); } catch (Exception err) { MessageBox.Show(err.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } }
private void btnSave_Click(object sender, System.EventArgs e) { #region 重新赋值_bedInfo BedInfo _bedInfo_old = _bedInfo; _bedInfo.DeptID = Convert.ToInt64(this.cboKs.SelectedValue);//this._deptInfo.DeptID; _bedInfo.BedNo = this.txtBedNo.Text; _bedInfo.RoomNo = this._roomInfo.RoomNo; _bedInfo.WardID = this._roomInfo.WardID; _bedInfo.WardName = this._roomInfo.WardName; _bedInfo.ChargeDocID = Convert.ToInt64(this.txtChargeDoc.Tag); _bedInfo.ChargeDocName = this.txtChargeDoc.Text; _bedInfo.ManageDocID = Convert.ToInt64(this.txtManageDoc.Tag); _bedInfo.ManageDocName = this.txtManageDoc.Text; _bedInfo.FunNurseID = Convert.ToInt64(this.txtFunNurse.Tag); _bedInfo.FunNurseName = this.txtFunNurse.Text; SystemCfg cfg = new SystemCfg(7601); if (cfg != null && cfg.Config != null && cfg.Config.ToString().Trim() == "1") { if (this.txtLinkFee.Tag == null || string.Empty == this.txtLinkFee.Text.Trim()) { MessageBox.Show("床位费不能为空,请录入床位费!"); txtLinkFee.Focus(); return; } } _bedInfo.LinkFeeID = Convert.ToInt64(this.txtLinkFee.Tag); _bedInfo.LinkFeeName = this.txtLinkFee.Text; _bedInfo.IsPlus = this.chkPlus.Checked; #endregion if (this.SaveBedInfo(_bedInfo_old)) { this._operateCancel = false; this.Close(); } }
private void btnSave_Click(object sender, System.EventArgs e) { SystemCfg cfg = new SystemCfg(7601); bool sfbt = cfg != null && cfg.Config != null && cfg.Config.ToString().Trim() == "1" ? true : false; string bedNo = ""; int count = ((DataTable)dtgrdBed.DataSource).Rows.Count; try { string strCws = string.Format("select CWS from jc_dept_property where DEPT_ID='{0}'", _deptInfo.DeptID); string strUnPlusCws = string.Format("select count(1) as Num from zy_beddiction where dept_id='{0}' and ISPLUS=0", _deptInfo.DeptID); int iCws = int.Parse(InstanceForm.BDatabase.GetDataResult(strCws).ToString()); int iNonPlus = int.Parse(InstanceForm.BDatabase.GetDataResult(strUnPlusCws).ToString()); if (iCws != 0) { int myNonPlusCw = 0; for (int i = 0; i <= count - 1; i++) { DataTable dtCw = dtgrdBed.DataSource as DataTable; if (Convert.ToInt32(dtCw.Rows[i]["plus"]) == 0) { ++myNonPlusCw; } } if (iCws < iNonPlus + myNonPlusCw) { MessageBox.Show("本次添加床位已大于该科室编制床位数:" + iCws + ",请添加加床!", "", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } } catch { } for (int i = 0; i <= count - 1; i++) { bedNo = ((DataTable)dtgrdBed.DataSource).Rows[i]["bed_no"].ToString().Trim(); DataRow[] drs = ((DataTable)dtgrdBed.DataSource).Select("bed_no='" + bedNo + "'"); if (drs.Length > 1) { MessageBox.Show("床位号" + bedNo + "有重复!", "", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (sfbt) //床位费为必填项 { object hoitem = ((DataTable)dtgrdBed.DataSource).Rows[i]["hoitem_id"]; if (hoitem == null || hoitem.ToString().Trim() == string.Empty || Convert.ToInt64(hoitem) <= 0) //Modify By Tany 2015-04-20 增加<=0的判断 { MessageBox.Show("床位费不能为空,请录入床位费!"); return; } } } for (int i = 0; i <= count - 1; i++) { bedNo = ((DataTable)dtgrdBed.DataSource).Rows[i]["bed_no"].ToString().Trim(); int sel = Convert.ToInt32(((DataTable)dtgrdBed.DataSource).Rows[dtgrdBed.CurrentRowIndex]["plus"]); if (bedNo != "") { #region GetData string zz_doc_name = ((DataTable)dtgrdBed.DataSource).Rows[i]["zz_doc_name"].ToString(); long zz_doc = -1; if (!Convert.IsDBNull(((DataTable)dtgrdBed.DataSource).Rows[i]["zz_doc"])) { if (((DataTable)dtgrdBed.DataSource).Rows[i]["zz_doc"].ToString() != "") { zz_doc = Convert.ToInt64(((DataTable)dtgrdBed.DataSource).Rows[i]["zz_doc"]); } } string zy_doc_name = ((DataTable)dtgrdBed.DataSource).Rows[i]["zy_doc_name"].ToString(); long zy_doc = -1; if (!Convert.IsDBNull(((DataTable)dtgrdBed.DataSource).Rows[i]["zy_doc"])) { if (((DataTable)dtgrdBed.DataSource).Rows[i]["zy_doc"].ToString() != "") { zy_doc = Convert.ToInt64(((DataTable)dtgrdBed.DataSource).Rows[i]["zy_doc"]); } } string nurse_name = ((DataTable)dtgrdBed.DataSource).Rows[i]["nurse_name"].ToString(); long charge_nurse = -1; if (!Convert.IsDBNull(((DataTable)dtgrdBed.DataSource).Rows[i]["charge_nurse"])) { if (((DataTable)dtgrdBed.DataSource).Rows[i]["charge_nurse"].ToString() != "") { charge_nurse = Convert.ToInt64(((DataTable)dtgrdBed.DataSource).Rows[i]["charge_nurse"]); } } string hoitem_name = ((DataTable)dtgrdBed.DataSource).Rows[i]["hoitem_name"].ToString(); long hoitem_id = -1; if (!Convert.IsDBNull(((DataTable)dtgrdBed.DataSource).Rows[i]["hoitem_id"])) { if (((DataTable)dtgrdBed.DataSource).Rows[i]["hoitem_id"].ToString() != "") { hoitem_id = Convert.ToInt64(((DataTable)dtgrdBed.DataSource).Rows[i]["hoitem_id"]); } } #endregion if (bedNo.Trim() != "") { #region InitBed BedInfo bedInfo = new BedInfo(); bedInfo.WardID = _deptInfo.WardID; bedInfo.WardName = _deptInfo.WardName; bedInfo.DeptID = _deptInfo.DeptID; bedInfo.DeptName = _deptInfo.DeptName; bedInfo.RoomNo = _roomInfo.RoomNo; bedInfo.BedNo = bedNo; bedInfo.ChargeDocID = zz_doc; bedInfo.ChargeDocName = zz_doc_name; bedInfo.ManageDocID = zy_doc; bedInfo.ManageDocName = zy_doc_name; bedInfo.FunNurseID = charge_nurse; bedInfo.FunNurseName = nurse_name; bedInfo.LinkFeeID = hoitem_id; bedInfo.LinkFeeName = hoitem_name; bedInfo.IsInuse = false; bedInfo.IsPlus = false; int plus = sel; #endregion if (DataExists(bedInfo)) { int _jgbm = Convert.ToInt32(InstanceForm.BDatabase.GetDataResult("select jgbm from jc_DEpt_property where dept_id = " + bedInfo.DeptID.ToString())); string sql = "insert into zy_beddiction (bed_id,ward_id,dept_id,room_no,bed_no,hoitem_id,zz_doc,zy_doc,chargenurse,isplus,isinuse,pxxh,jgbm)"; sql += " values(DBO.FUN_GETGUID(NEWID(),GETDATE()),'" + bedInfo.WardID + "'," + bedInfo.DeptID + ",'" + bedInfo.RoomNo + "','" + bedInfo.BedNo + "'," + bedInfo.LinkFeeID + "," + bedInfo.ChargeDocID + "," + bedInfo.ManageDocID + "," + bedInfo.FunNurseID + "," + plus + ",0,0," + _jgbm + ")"; InstanceForm.BDatabase.DoCommand(sql); } else { return; } } } } MessageBox.Show("操作成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); }
/// <summary> /// 绑定床位列表 /// </summary> /// <param name="bedListDt">床位列表</param> public void Bind_BedList(DataTable bedListDt) { // 定义床位集合 List <BedInfo> list = new List <BedInfo>(); // 当前病区有床位的场合 if (bedListDt != null && bedListDt.Rows.Count > 0) { // 循环显示床位 for (int i = 0; i < bedListDt.Rows.Count; i++) { BedInfo bed = new BedInfo(); // 床位相关数据 bed.BedNo = bedListDt.Rows[i]["BedNO"].ToString(); // 床位号 bed.WardCode = bedListDt.Rows[i]["WardID"].ToString(); // 病区ID // 病人住院信息相关数据 if (Convert.ToInt32(bedListDt.Rows[i]["PatListID"].ToString()) > 0) { bed.PatientID = Convert.ToInt32(bedListDt.Rows[i]["PatListID"].ToString()); // 病人登记ID bed.PatientNum = bedListDt.Rows[i]["SerialNumber"].ToString(); // 住院流水号 bed.CaseNumber = Tools.ToDecimal(bedListDt.Rows[i]["CaseNumber"]); // 住院流水号 bed.PatientName = bedListDt.Rows[i]["PatName"].ToString(); // 病人姓名 bed.Sex = bedListDt.Rows[i]["PatSex"].ToString(); // 性别 bed.Age = GetAge(bedListDt.Rows[i]["Age"].ToString()); // 年龄 bed.Diagnosis = bedListDt.Rows[i]["EnterDiseaseName"].ToString(); // 入院诊断 bed.Dept = bedListDt.Rows[i]["DeptName"].ToString(); // 入院科室 bed.DeptCode = bedListDt.Rows[i]["PatDeptID"].ToString(); // 入院科室 bed.Doctor = bedListDt.Rows[i]["DoctorName"].ToString(); // 医生 bed.Nurse = bedListDt.Rows[i]["NurseName"].ToString(); // 护士 bed.EnterTime = DateTime.Parse(bedListDt.Rows[i]["EnterHDate"].ToString()).ToString("yyyy-MM-dd HH:mm"); // 入院时间 bed.Situation = bedListDt.Rows[i]["OutSituation"].ToString(); // 病人情况 bed.Step = Convert.ToInt32(bedListDt.Rows[i]["IsLeaveHosOrder"].ToString()); // 是否出院医嘱 bed.DietType = bedListDt.Rows[i]["DietType"].ToString(); // 饮食级别 bed.NursingLever = bedListDt.Rows[i]["NursingLever"].ToString(); // 护理级别 bed.PatTypeName = bedListDt.Rows[i]["PatTypeName"].ToString(); // 病人类型 bed.Group = bedListDt.Rows[i]["IsPack"].ToString().Trim() == "1"; } list.Add(bed); } } bedCardControl1.DataSource = list; StatisticalBedCount(); if (sumBedCount > 0) { decimal occupancyRate = 0; if (occupyBedCount > 0) { decimal tempOccupancyRate = ((occupyBedCount / sumBedCount) * 100); occupancyRate = Math.Round(tempOccupancyRate, 2); } lblBedStatistical.Text = string.Format( " 总床位数:{0} 占用床位:{1} 占床比例:{2}% 可用床位:{3}", sumBedCount, occupyBedCount, occupancyRate, sumBedCount - occupyBedCount); } else { lblBedStatistical.Text = string.Format( " 总床位数:{0} 占用床位:{1} 占床比例:{2}% 可用床位:{3}", 0, 0, 0, 0); } }