private void 修改ToolStripMenuItem_Click(object sender, EventArgs e) { updateFlag = true; Con_ClearCntrValue.ClearCntrValue(this.gpbFixTime, true); if (lvwQualitys.SelectedItems.Count > 0) { Class_Quality_HLB_View q = (Class_Quality_HLB_View)lvwQualitys.SelectedItems[0].Tag; chp.Id = q.Id; cboTextKind.Text = q.Document_Type; //文书类型 cboMonitoring.Text = q.Sub_Item; //监控子项 cboMonitorType.Text = q.Inpatient_Type; //患者类型 txtExceTimes.Text = q.ExceTimes.ToString(); //执行次数 cboCKTime.Text = q.Base_Time; //参考时间 txtExecCycles.Text = q.Runcycle.ToString(); //执行周期 cboCyclesUnit.Text = q.Runcycleunit; //执行周期单位 txtItemMax.Text = q.Item_Max.ToString(); //项目最大值 txtItemMin.Text = q.Item_Min.ToString(); //项目最小值 if (q.Isprealert == "是") { rdoIsOverAlert.Checked = true; rdoIsOverAlertF.Checked = false; txtPrealertTime.Text = q.Prealerttime.ToString(); //预警时间 cboPrealertUnit.Text = q.Pretimeunit; //单位 } else { rdoIsOverAlert.Checked = false; rdoIsOverAlertF.Checked = true; } if (q.Is_Renew == "是") { rdoIsMend.Checked = true; rdoIsMendF.Checked = false; txtDeduction.Text = q.Take_Grade.ToString();//扣分值 } else { rdoIsMend.Checked = false; rdoIsMendF.Checked = true; } if (q.Is_Notice == "是") { rdoIsNotice.Checked = true;//是否提醒 } else { rdoIsNotice.Checked = false; } if (q.Istoday == "是") { rdoIsCheck.Checked = true;//是否当天检查一次 } else { rdoIsCheck.Checked = false; } if (txtExceTimes.Text != "") { txtExceTimes.Enabled = true; } Con_CheckBoxListUtil.SetCheck(gpbFixTime, q.Fix_Time); } else { App.MsgErr("请选择一条修改的记录"); ResetAll(); } }
private void btnSave_Click(object sender, EventArgs e) { if (chkSectionListBox.CheckedItems.Count <= 0) { //老代码注释掉 //App.MsgErr("请选择科室"); //return; #region 消息提醒使用 if (strT_Msg_Setting == 3) { App.MsgErr("请选择病区"); return; } else { App.MsgErr("请选择科室"); return; } #endregion } if (id != null) { ywcSectionID = Con_CheckBoxListUtil.GetCheckedItems(chkSectionListBox); string tempUpdate = "update t_quality_var_ywc t set t.effect_section='" + ywcSectionID + "' where t.id=" + id; int i = 0; DialogResult resultUpdate = MessageBox.Show("确认要保存已修改的数据?", "警告", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning); if (resultUpdate == DialogResult.OK) { i = App.ExecuteSQL(tempUpdate); } else { return; } if (i > 0) { App.Msg("数据修改成功!"); ShowUpdate(true); this.Close(); return; } else { App.MsgErr("数据修改失败!"); return; } } else { DialogResult resultInsert = MessageBox.Show("确认要保存数据?", "消息", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (resultInsert == DialogResult.OK) { //老代码注释掉 //ywcSectionID = Con_CheckBoxListUtil.GetCheckedItems(chkSectionListBox); //ywcSectionName = Con_CheckBoxListUtil.GetCheckedItemsValue(chkSectionListBox); //ShowTextBoxValue(); //this.Close(); #region 消息提醒使用 flag = true;//消息提醒 if (strT_Msg_Setting != 1 && strT_Msg_Setting != 2 && strT_Msg_Setting != 3) { ywcSectionID = Con_CheckBoxListUtil.GetCheckedItems(chkSectionListBox); ywcSectionName = Con_CheckBoxListUtil.GetCheckedItemsValue(chkSectionListBox); ShowTextBoxValue(); this.Close(); } else//消息提醒使用 { ywcSectionID = Con_CheckBoxListUtil.GetCheckedItems(chkSectionListBox); ywcSectionName = Con_CheckBoxListUtil.GetCheckedItemsValue(chkSectionListBox); this.Close(); } #endregion } } }
/// <summary> /// 保存参数设置 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSave_Click(object sender, EventArgs e) { if (!updateFlag) { ////ID自增设置 chp.Id = App.GenId("T_QUALITY_VAR_HLB", "ID"); } //文书类型 if (cboTextKind.SelectedIndex != 0) { chp.Document_Type = Convert.ToInt32(this.cboTextKind.SelectedValue.ToString()); } else { App.MsgErr("请选择文书类型"); return; } //监控子项 if (this.cboMonitoring.Enabled == false) { chp.Sub_Item = 0; } else { chp.Sub_Item = Convert.ToInt32(this.cboMonitoring.SelectedValue.ToString()); } //监控患者类型 if (cboMonitorType.SelectedIndex != 0) { chp.Inpatient_Type = Convert.ToInt32(this.cboMonitorType.SelectedValue.ToString()); } else { App.MsgErr("请选择监控患者类型"); return; } //执行周期 if (txtExecCycles.Enabled == true && cboCyclesUnit.Enabled == true) { if (txtExecCycles.Text == "" || txtExecCycles.Text == null || cboCyclesUnit.SelectedItem.ToString() == "" || cboCyclesUnit.SelectedItem.ToString() == null) { App.MsgErr("请输入执行周期"); return; } chp.Runcycle = Convert.ToInt32(txtExecCycles.Text); chp.Runcycleunit = cboCyclesUnit.SelectedItem.ToString(); } else { chp.Runcycle = 0; chp.Runcycleunit = ""; } //参考时间 if (cboCKTime.SelectedIndex != 0) { chp.Base_Time = Convert.ToInt32(this.cboCKTime.SelectedValue.ToString()); } else { App.MsgErr("请选择参考时间"); return; } //是否预警 if (this.rdoIsOverAlert.Checked == true) { chp.Isprealert = 'Y'; } else { chp.Isprealert = 'N'; } //超时补上是否扣分 if (this.rdoIsMend.Checked == true) { chp.Is_Renew = 'Y'; } else { chp.Is_Renew = 'N'; } //是否当天检查一次 if (this.rdoIsCheck.Checked == true) { chp.Istoday = 'Y'; //是 } else { chp.Istoday = 'N'; } if (this.txtPrealertTime.Enabled == true) { //预警时间 if (this.txtPrealertTime.Text != "") { chp.Prealerttime = Convert.ToInt32(this.txtPrealertTime.Text); //预警时间 chp.Pretimeunit = this.cboPrealertUnit.SelectedItem.ToString(); //预警单位 } else { App.Msg("请输入预警时间"); } } else { chp.Prealerttime = 0; //预警时间 chp.Pretimeunit = ""; //预警单位 } //扣分值 if (txtDeduction.Enabled == true) { chp.Take_Grade = Convert.ToDouble(this.txtDeduction.Text); } //是否提醒 if (this.rdoIsNotice.Checked == true) { chp.Is_Notice = 'Y'; } else { chp.Is_Notice = 'N'; } chp.Isoveralert = 'Y'; //警告 chp.Overalerttime = 0; //报警提前时间(超过) chp.Overtimeunit = ""; //报警提前时间单位(超过) chp.ThreadState = 1; //线程状态-----------默认为1,启动 chp.Fix_Time = Con_CheckBoxListUtil.GetCheckedItems(this.gpbFixTime); //固定执行时间点 if (txtItemMax.Text != "") { chp.Item_Max = float.Parse(txtItemMax.Text); } else { chp.Item_Max = 0f; } if (txtItemMin.Text != "") { chp.Item_Min = float.Parse(txtItemMin.Text); } else { chp.Item_Min = 0f; } if (this.txtExceTimes.Text == null || this.txtExceTimes.Text == "") { chp.ExceTimes = 1; } else { chp.ExceTimes = Convert.ToInt32(this.txtExceTimes.Text); } if (updateFlag)//=true 修改 { string temp = "update t_quality_var_hlb hlb set hlb.document_type=" + chp.Document_Type + ",hlb.sub_item=" + chp.Sub_Item + ",hlb.inpatient_type=" + chp.Inpatient_Type + ",hlb.base_time=" + chp.Base_Time + ",hlb.runcycle=" + chp.Runcycle + ",hlb.runcycleunit='" + chp.Runcycleunit + "',hlb.isprealert='" + chp.Isprealert + "',hlb.prealerttime=" + chp.Prealerttime + ",hlb.pretimeunit='" + chp.Pretimeunit + "',hlb.isoveralert='" + chp.Isoveralert + "',hlb.overalerttime=" + chp.Overalerttime + ",hlb.overtimeunit='" + chp.Overtimeunit + "',hlb.take_grade=" + chp.Take_Grade + ",hlb.is_notice='" + chp.Is_Notice + "',hlb.is_renew='" + chp.Is_Renew + "',hlb.fix_time='" + chp.Fix_Time + "',hlb.istoday='" + chp.Istoday + "',hlb.excetimes=" + chp.ExceTimes + ",hlb.threadstate=" + chp.ThreadState + ",hlb.item_max=" + chp.Item_Max + ",hlb.item_min=" + chp.Item_Min + "where hlb.id=" + chp.Id; int i = 0; DialogResult result = MessageBox.Show("数据已修改,确认要保存?", "消息", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (result == DialogResult.OK) { i = App.ExecuteSQL(temp); } else { return; } if (i > 0) { App.Msg("修改成功!"); QualityView(); ResetAll(); } else { App.MsgErr("修改失败!"); } } else //新增 { string temp = "insert into T_QUALITY_VAR_HLB values(" + chp.Id + "," + chp.Document_Type + "," + chp.Sub_Item + "," + "" + chp.Inpatient_Type + "," + chp.Base_Time + "," + chp.Runcycle + "," + "'" + chp.Runcycleunit + "','" + chp.Isprealert + "'," + chp.Prealerttime + ",'" + chp.Pretimeunit + "'," + "'" + chp.Isoveralert + "'," + chp.Overalerttime + ",'" + chp.Overtimeunit + "'," + "" + chp.Take_Grade + ",'" + chp.Is_Notice + "','" + chp.Is_Renew + "'," + "'" + chp.Fix_Time + "','" + chp.Istoday + "'," + chp.ExceTimes + "," + chp.ThreadState + "," + chp.Item_Max + "," + chp.Item_Min + ")"; int i = 0; DialogResult result = MessageBox.Show("确认要保存数据?", "消息", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (result == DialogResult.OK) { i = App.ExecuteSQL(temp); } else { return; } if (i > 0) { App.Msg("添加成功!"); QualityView(); ResetAll(); } else { App.MsgErr("添加失败!"); } } }
private void frmSectionCheck_Load(object sender, EventArgs e) { //老代码注释掉 //DataSet dataSet = App.GetDataSet("select distinct(ts.sid),ts.section_name from t_Section_Area tsa inner join t_Sectioninfo ts on tsa.sid=ts.sid"); #region 消息提醒使用 DataSet dataSet = new DataSet(); if (strT_Msg_Setting == 3) { dataSet = App.GetDataSet("select t.said as SID,t.sick_area_name as SECTION_NAME from T_SICKAREAINFO t"); } else { if (strT_Msg_Setting == 2) { dataSet = App.GetDataSet("select distinct(ts.sid),ts.section_name from t_Sectioninfo ts"); } else { dataSet = App.GetDataSet("select distinct(ts.sid),ts.section_name from t_Section_Area tsa inner join t_Sectioninfo ts on tsa.sid=ts.sid"); } } #endregion Class_Sections[] class_Sections; int lenght = dataSet.Tables[0].Rows.Count; CheckBox[] ff = new CheckBox[lenght]; for (int i = 0; i < lenght; i++) { class_Sections = new Class_Sections[lenght]; class_Sections[i] = new Class_Sections(); class_Sections[i].Sid = Convert.ToInt32(dataSet.Tables[0].Rows[i]["SID"].ToString()); class_Sections[i].Section_Name = dataSet.Tables[0].Rows[i]["SECTION_NAME"].ToString(); chkSectionListBox.Items.Add(class_Sections[i]); chkSectionListBox.DisplayMember = "Section_Name"; chkSectionListBox.ValueMember = "SID"; } if (ucYWCParam.FlexSection != null) { // Con_CheckBoxListUtil.SetCheck(this.chkSectionListBox, frmYWCParam.FlexSection); //chkSectionListBox.Items.Clear(); string[] temp = ucYWCParam.FlexSection.Split(','); foreach (string str in temp) { for (int i = 0; i < chkSectionListBox.Items.Count; i++) { if (str == chkSectionListBox.GetItemText(chkSectionListBox.Items[i])) { chkSectionListBox.Items.RemoveAt(i); //除自身规则的科室以外,已被选择的科室则移除它 } } } //Con_CheckBoxListUtil.RemoveExitItems(chkSectionListBox); } if (ywcSectionName != null) { Con_CheckBoxListUtil.SetCheck(this.chkSectionListBox, ywcSectionName); //老代码注释掉 //this.groupBox1.Text = "文书类型为:[" + documentType + "]的科室列表"; #region 消息提醒使用 if (strT_Msg_Setting == 3) { this.groupBox1.Text = "病区列表"; } else if (strT_Msg_Setting == 1 || strT_Msg_Setting == 2) { this.groupBox1.Text = "科室列表"; } else { this.groupBox1.Text = "文书类型为:[" + documentType + "]的科室列表"; } #endregion } else { //老代码注释掉 //this.groupBox1.Text = "科室列表"; #region 消息提醒使用 if (strT_Msg_Setting == 3) { this.groupBox1.Text = "病区列表"; } else { this.groupBox1.Text = "科室列表"; } #endregion } #region 消息提醒使用 if (strT_Msg_Setting == 1 || strT_Msg_Setting == 2 || strT_Msg_Setting == 3)//消息提醒使用 { // DataSet ds; if (STRMSGSECTION_IDS == "")//如果等于空,不需要进行选中提示 { for (int i = 0; i < chkSectionListBox.Items.Count; i++) { chkSectionListBox.SetItemChecked(i, false); } ywcSectionID = ""; ywcSectionName = ""; } } #endregion }