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() + "");
}
}
