private void lvSick_Click(object sender, EventArgs e) { if (lvSick.SelectedItems != null) { lvRelation.Items.Clear(); currentSick = (Class_Sickarea)lvSick.SelectedItems[0].Tag; lblSelectValue.Text = currentSick.Sick_area_name; DataSet ds = App.GetDataSet(@"select a.SID,SECTION_CODE,SECTION_NAME,BELONGTO_SECTION_ID,case when ISCHECKSECTION='Y' then '是' else '否' end ISCHECKSECTION," + @"BELONGTO_SECTION_NAME,BELONGTO_BIGSECTION_ID,(select SECTION_NAME from T_SECTIONINFO b where b.SID=a.BELONGTO_BIGSECTION_ID) as 大科名称," + @"case when ISBELONGTOBIGSECTION='Y' then '是' else '否' end ISBELONGTOBIGSECTION,TYPEINFO,g.name as TYPEINFO_NAME," + @"case when IN_FLAG='I' then '住院' else '门诊' end IN_FLAG,MANAGE_TYPE,s.name as MANAGE_TYPE_NAME," + @"case when ENABLE_FLAG='Y' then '有效' else '无效' end ENABLE_FLAG," + @"a.SHID,c.sub_hospital_name as SHID_NAME from T_SECTIONINFO a inner join T_SUB_HOSPITALINFO c on a.shid=c.shid inner join T_DATA_CODE s on a.manage_type=s.id inner join T_DATA_CODE g on a.typeinfo=g.id inner join T_SECTION_AREA r on a.SID=r.SID where r.SAID='" + currentSick.Said + "'"); Class_Sections[] Directionarys = GetSectionDirectionary(ds); if (Directionarys != null) { for (int i = 0; i < Directionarys.Length; i++) { ListViewItem lvitem = new ListViewItem(); lvitem.Tag = Directionarys[i]; lvitem.Text = Directionarys[i].Section_Name; lvitem.ImageIndex = 1; lvRelation.Items.Add(lvitem); } } } btnSelect_B_Click(sender, e); }
/// <summary> /// 实例化查询病区结果 /// </summary> /// <param Name="tempds"></param> /// <returns></returns> private Class_Sickarea[] GetDirectionary(DataSet tempds) { if (tempds != null) { if (tempds.Tables[0].Rows.Count > 0) { Class_Sickarea[] Directionary = new Class_Sickarea[tempds.Tables[0].Rows.Count]; for (int i = 0; i < tempds.Tables[0].Rows.Count; i++) { Directionary[i] = new Class_Sickarea(); Directionary[i].Said = tempds.Tables[0].Rows[i]["SAID"].ToString();//Convert.ToInt32( Directionary[i].Shid = tempds.Tables[0].Rows[i]["SHID"].ToString(); Directionary[i].Sick_area_code = tempds.Tables[0].Rows[i]["SICK_AREA_CODE"].ToString(); Directionary[i].Sick_area_name = tempds.Tables[0].Rows[i]["SICK_AREA_NAME"].ToString(); Directionary[i].Isbelongtosection = tempds.Tables[0].Rows[i]["ISBELONGTOSECTION"].ToString(); Directionary[i].Belongtosection = tempds.Tables[0].Rows[i]["BELONGTOSECTION"].ToString(); Directionary[i].Enable_flag = tempds.Tables[0].Rows[i]["ENABLE_FLAG"].ToString(); Directionary[i].Bed_count = tempds.Tables[0].Rows[i]["BED_COUNT"].ToString(); Directionary[i].Alow_count = tempds.Tables[0].Rows[i]["ALOW_COUNT"].ToString(); } return(Directionary); } else { return(null); } } else { return(null); } }
private void lvSmallSick_RightToLeftLayoutChanged(object sender, EventArgs e) { if (lvSmallSick.SelectedItems != null) { currentSickareaSmall = (Class_Sickarea)lvSmallSick.SelectedItems[0].Tag; } }
/// <summary> /// 清除大病区与小病区之间关系 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void 除ToolStripMenuItem_Click(object sender, EventArgs e) { if (currentSickareaBig != null) { if (lvRelation.SelectedItems != null) { if (App.Ask("你是否要删除?")) { //for (int i = 0; i < SickRelations.Length; i++) //{ Class_Sickarea temp = (Class_Sickarea)lvRelation.SelectedItems[0].Tag; ListViewItem lvitem = new ListViewItem(); lvitem.Tag = temp; lvitem.Text = temp.Sick_area_name; App.ExecuteSQL("update T_SICKAREAINFO set BELONGTOSECTION=null where SAID=" + temp.Said + ""); lvitem.ImageIndex = 1; lvSmallSick.Items.Add(lvitem); lvRelation.Items.Remove(lvRelation.SelectedItems[0]); // App.ExecuteSQL("update T_SICKAREAINFO set BELONGTOSECTION=null where SAID='" + SickRelations[i].Said + "'"); // } } } } }
//private void trvRelation_MouseDown(object sender, MouseEventArgs e) //{ // trvRelation.SelectedNode = trvRelation.GetNodeAt(e.X, e.Y); //} private void lvBigSick_Click(object sender, EventArgs e) { if (lvBigSick.SelectedItems != null) { lvRelation.Items.Clear(); SickRelations = null; currentSickareaBig = (Class_Sickarea)lvBigSick.SelectedItems[0].Tag; lblSelectValue.Text = currentSickareaBig.Sick_area_name; DataSet ds = App.GetDataSet("select * from T_SICKAREAINFO where BELONGTOSECTION='" + currentSickareaBig.Said + "'"); Class_Sickarea[] Directionarys = GetSelectDirectionary(ds); if (Directionarys != null) { SickRelations = new Class_Sickarea[Directionarys.Length]; for (int i = 0; i < Directionarys.Length; i++) { SickRelations[i] = Directionarys[i]; } for (int i = 0; i < Directionarys.Length; i++) { ListViewItem lvitem = new ListViewItem(); lvitem.Tag = Directionarys[i]; lvitem.Text = Directionarys[i].Sick_area_name; lvitem.ImageIndex = 1; lvRelation.Items.Add(lvitem); } } } btnSelect_B_Click(sender, e); }
/// <summary> /// 清空关系 /// </summary> /// <param Name="sender"></param> /// <param Name="e"></param> private void btnClear_Click(object sender, EventArgs e) { if (currentSickareaBig != null) { if (lvRelation.SelectedItems != null) { if (App.Ask("确定要删除所有关系?")) { if (SickRelations != null) { for (int i = 0; i < SickRelations.Length; i++) { Class_Sickarea temp = (Class_Sickarea)lvRelation.Items[i].Tag; string sql = "update T_SICKAREAINFO set BELONGTOSECTION=null where SAID='" + temp.Said + "'"; App.ExecuteSQL(sql); } lvRelation.Items.Clear(); } else { App.Msg("请先保存再清空关系设置或点击鼠标右键删除!"); } } } } }
private void btnSave_Click(object sender, EventArgs e) { try { if (currentSection != null) { //清空原有关系 if (currentSection != null) { App.ExecuteSQL("delete T_SECTION_AREA where SID='" + currentSection.Sid + "'"); } //设置现有关系 for (int i = 0; i < lvRelation.Items.Count; i++) { if (lvRelation.Items[i].Tag.GetType().ToString().Contains("Class_Sickarea")) { Class_Sickarea temp = (Class_Sickarea)lvRelation.Items[i].Tag; App.ExecuteSQL("insert into T_SECTION_AREA(id,SID,SAID) values(" + App.GenId().ToString() + "," + currentSection.Sid.ToString() + "," + temp.Said.ToString() + ")"); } } App.Msg("操作成功!"); } else { App.Msg("请先选择病区!"); } } catch (Exception ex) { App.Msg("操作失败,原因:" + ex.ToString() + ""); } }
/// <summary> /// 根据表格选中下拉列表 /// </summary> /// <returns></returns> public void SelectValues(string said) { //bool flag =false; foreach (object var in cboBigsickarea.Items) { Class_Sickarea class_Sickarea = var as Class_Sickarea; if (said == class_Sickarea.Said.ToString()) { cboBigsickarea.SelectedItem = var; break; } else { cboBigsickarea.SelectedIndex = 0; } } }
/// <summary> /// 判断关系是否重复设置 /// </summary> /// <param Name="Id"></param> /// <returns></returns> private bool isExist(string id) { bool flag = false; for (int i = 0; i < lvRelation.Items.Count; i++) { if (lvRelation.Items[i].Tag.GetType().ToString().Contains("class_Sickarea")) { Class_Sickarea temp = (Class_Sickarea)lvRelation.Items[i].Tag; if (temp.Said == id) { flag = true; } } } return(flag); }
private void lvSmallSick_MouseDoubleClick(object sender, MouseEventArgs e) { if (lvSmallSick.SelectedItems != null) { if (lvSmallSick.SelectedItems[0].Tag.GetType().ToString().Contains("Class_Sickarea")) { Class_Sickarea temp = (Class_Sickarea)lvSmallSick.SelectedItems[0].Tag; if (!isExist(temp.Said)) { ListViewItem lvitem = new ListViewItem(); lvitem.Tag = temp; lvitem.Text = temp.Sick_area_name; lvitem.ImageIndex = 1; lvRelation.Items.Add(lvitem); lvSmallSick.Items.Remove(lvSmallSick.SelectedItems[0]); } } } }
private void lvSick_MouseDoubleClick(object sender, MouseEventArgs e) { if (lvSick.SelectedItems != null) { if (lvSick.SelectedItems[0].Tag.GetType().ToString().Contains("Class_Sickarea")) { Class_Sickarea temp = (Class_Sickarea)lvSick.SelectedItems[0].Tag; if (!isExist(Convert.ToInt32(temp.Said))) { ListViewItem lvitem = new ListViewItem(); lvitem.Tag = temp; lvitem.Text = temp.Sick_area_name; lvitem.ImageIndex = 1; lvRelation.Items.Add(lvitem); } else { App.Msg("当前病区已经存在相同的小病区了!"); } } } }
//绑定大病区 private void Bigsickarea() { cboBigsickarea.Items.Clear(); Class_Sickarea none = new Class_Sickarea(); none.Said = ""; none.Shid = "无"; none.Sick_area_code = "无"; none.Sick_area_name = "无"; none.Isbelongtosection = "无"; none.Belongtosection = "无"; none.Enable_flag = "无"; none.Bed_count = "无"; none.Alow_count = "无"; cboBigsickarea.Items.Add(none); DataSet ds = App.GetDataSet("select * from T_SICKAREAINFO where ISBELONGTOSECTION='Y'and ENABLE_FLAG='Y'"); sickarea = new Class_Sickarea[ds.Tables[0].Rows.Count]; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { sickarea[i] = new Class_Sickarea(); sickarea[i].Said = ds.Tables[0].Rows[i]["SAID"].ToString(); sickarea[i].Shid = ds.Tables[0].Rows[i]["SHID"].ToString(); sickarea[i].Sick_area_code = ds.Tables[0].Rows[i]["SICK_AREA_CODE"].ToString(); sickarea[i].Sick_area_name = ds.Tables[0].Rows[i]["SICK_AREA_NAME"].ToString(); sickarea[i].Isbelongtosection = ds.Tables[0].Rows[i]["ISBELONGTOSECTION"].ToString(); sickarea[i].Belongtosection = ds.Tables[0].Rows[i]["BELONGTOSECTION"].ToString(); sickarea[i].Enable_flag = ds.Tables[0].Rows[i]["ENABLE_FLAG"].ToString(); sickarea[i].Bed_count = ds.Tables[0].Rows[i]["BED_COUNT"].ToString(); sickarea[i].Alow_count = ds.Tables[0].Rows[i]["ALOW_COUNT"].ToString(); cboBigsickarea.Items.Add(sickarea[i]); } //cboBigsickarea.DataSource = ds.Tables[0].DefaultView; cboBigsickarea.ValueMember = "SAID"; cboBigsickarea.DisplayMember = "SICK_AREA_NAME"; }
/// <summary> /// 保存 /// </summary> /// <param Name="sender"></param> /// <param Name="e"></param> private void btnSave_Click(object sender, EventArgs e) { try { if (currentSickareaBig != null) { //清空原有关系 if (SickRelations != null) { for (int i = 0; i < SickRelations.Length; i++) { App.ExecuteSQL("update T_SICKAREAINFO set BELONGTOSECTION=null where SAID='" + SickRelations[i].Said + "'"); } } //设置现有关系 for (int i = 0; i < lvRelation.Items.Count; i++) { if (lvRelation.Items[i].Tag.GetType().ToString().Contains("Class_Sickarea")) { Class_Sickarea temp = (Class_Sickarea)lvRelation.Items[i].Tag; App.ExecuteSQL("update T_SICKAREAINFO set BELONGTOSECTION='" + currentSickareaBig.Said + "' where SAID=" + temp.Said + ""); } } App.Msg("操作成功!"); btnSelect_B_Click(sender, e); } else { App.Msg("请先选择大病区表!"); } } catch (Exception ex) { App.Msg("操作失败,原因:" + ex.ToString() + ""); } }
/// <summary> /// 保存 /// </summary> /// <param Name="sender"></param> /// <param Name="e"></param> private void btnSave_Click(object sender, EventArgs e) { try { if (txtNumber.Text.Trim() == "") { App.Msg("病区编号不能为空!"); txtNumber.Focus(); return; } if (txtName.Text.Trim() == "") { App.Msg("病区名称不能为空!"); txtName.Focus(); return; } if (cboBranchcourts.Text.Trim() == "") { App.Msg("所属分院不能为空!"); cboBranchcourts.Focus(); return; } if (!rdtnSickAreaYes.Checked) { BigsickArea = "N"; } if (!rbtnValidmark.Checked) { mark = "N"; } string sql = ""; string bigid = ""; if (rdtnSickAreaYes.Checked) { bigid = null; } else { if (cboBigsickarea.SelectedItem != null) { Class_Sickarea temp = (Class_Sickarea)cboBigsickarea.SelectedItem; bigid = temp.Said.ToString(); } } ID = App.GenId("T_SICKAREAINFO", "SAID").ToString(); if (IsSave) { if (isExisitNames(App.ToDBC(txtNumber.Text.Trim()))) { App.Msg("已经存在了相同名称的病区编号了!"); txtNumber.Focus(); return; } else if (Isnames(App.ToDBC(txtName.Text.Trim()))) { App.Msg("已经存在了相同名称的病区名称了!"); txtName.Focus(); return; } sql = "insert into T_SICKAREAINFO(SAID,SHID,SICK_AREA_CODE,SICK_AREA_NAME,ISBELONGTOSECTION,BELONGTOSECTION,ENABLE_FLAG,BED_COUNT,ALOW_COUNT) values('" + ID + "','" + cboBranchcourts.SelectedValue + "','" + txtNumber.Text + "','" + App.ToDBC(txtName.Text) + "','" + BigsickArea + "','" + bigid + "','" + mark + "','" + txtSickbed.Text + "','" + txtExtrabed.Text + "')"; btnAdd_Click(sender, e); } else { if (sick_area_code.Trim() != "") { if (txtNumber.Text.Trim() != sick_area_code.Trim()) { if (isExisitNames(App.ToDBC(txtNumber.Text.Trim()))) { App.Msg("已经存在了相同名称的病区编号了!"); txtNumber.Focus(); return; } } } else if (sick_area_name.Trim() != "") { if (txtName.Text.Trim() != sick_area_name.Trim()) { if (Isnames(App.ToDBC(txtName.Text.Trim()))) { App.Msg("已经存在了相同名称的病区名称了!"); txtName.Focus(); return; } } } sql = "update T_SICKAREAINFO set SHID='" + cboBranchcourts.SelectedValue + "',SICK_AREA_CODE='" + txtNumber.Text + "',SICK_AREA_NAME='" + App.ToDBC(txtName.Text) + "',ISBELONGTOSECTION='" + BigsickArea + "',BELONGTOSECTION='" + bigid + "',ENABLE_FLAG='" + mark + "',BED_COUNT='" + txtSickbed.Text + "',ALOW_COUNT='" + txtExtrabed.Text + "' where SAID=" + ucGridviewX1.fg["编号", ucGridviewX1.fg.CurrentRow.Index].Value.ToString() + ""; } if (sql != "") { if (App.ExecuteSQL(sql) > 0) { App.Msg("操作成功!"); btnCancel_Click(sender, e); } } //显示列表数据 ShowValue(); //string SQl = T_SickArea_Sql; //ucC1FlexGrid1.DataBd(SQl, "SAID", "SAID,SHID,SHID_NAME,SICK_AREA_CODE,SICK_AREA_NAME,ISBELONGTOSECTION,BELONGTOSECTION,ENABLE_FLAG,BED_COUNT,ALOW_COUNT", "编号,分院编号,分院名称,病区编号,病区名称,是否大病区,所属大病区,有效标志,标准病床数,允许加床数"); } catch (Exception ex) { App.Msg("添加失败,原因:" + ex.ToString() + ""); } }