/// <summary>
/// 病房查询
/// </summary>
/// <returns></returns>
public List <Sickroom> sickroom_select()
{
List <Sickroom> ssic = new List <Sickroom>();
SqlDataReader reader = DBHelper.SectionRoomSelect("p_sickroom_select");
while (reader.Read())
{
Sickroom sic = new Sickroom();
sic.Idsickroom = int.Parse(reader[0] + "");
sic.Tyep = reader[2] + "";
sic.Sid = int.Parse(reader[1] + "");
sic.Price = int.Parse(reader[3] + "");
ssic.Add(sic);
}
DBHelper.con.Close();
DBHelper.con.Dispose();
DBHelper.cmd.Dispose();
return(ssic);
}
//确定
private void BtnYes_Click(object sender, RoutedEventArgs e)
{
List <Control> con_list = new List <Control>
{
txtnum,
txtBFnum,
txtPrice,
txtlou1,
txtlou2,
txtfang1,
txtfang2,
cboKeshi,
cboType
};
foreach (Control item in con_list)
{
if (checkBox1.IsChecked == true)
{
if (item is TextBox)
{
if (((TextBox)item).Text == "" && item.Name != "txtnum")
{
Tip t1 = new Tip("请输入完整！");
t1.ShowDialog();
return;
}
}
else
{
if (((ComboBox)item).Text == "" && item.Name != "txtnum")
{
Tip frmPrompting = new Tip("请输入完整！");
frmPrompting.ShowDialog();
return;
}
}
}
else
{
if (item.Name == "txtlou1" || item.Name == "txtlou2" || item.Name == "txtfang1" || item.Name == "txtfang2")
{
break;
}
if (item is TextBox)
{
if (((TextBox)item).Text == "")
{
Tip t1 = new Tip("请输入完整！");
t1.ShowDialog();
return;
}
}
if (item is ComboBox)
{
if (((ComboBox)item).Text == "")
{
Tip t2 = new Tip("请输入完整！");
t2.ShowDialog();
return;
}
}
}
}
List <Sickroom> sics = new List <Sickroom>();//要添加的病房放到sics集合中
if (checkBox1.IsChecked == true)
{
for (int i = int.Parse(txtlou1.Text); i <= int.Parse(txtlou2.Text); i++)
{
for (int j = int.Parse(txtfang1.Text); j <= int.Parse(txtfang2.Text); j++)
{
Sickroom sic = new Sickroom();
if (j > 9)
{
sic.Idsickroom = int.Parse("" + i + j);
}
else
{
sic.Idsickroom = int.Parse("" + i + 0 + j);
}
sic.Sid = cboKeshi.SelectedIndex;
sic.Tyep = cboType.Text;
sic.Price = int.Parse(txtPrice.Text);
sics.Add(sic);
}
}
}
else
{
Sickroom sic = new Sickroom
{
Idsickroom = int.Parse(txtnum.Text),
Sid = cboKeshi.SelectedIndex,
Tyep = cboType.Text,
Price = int.Parse(txtPrice.Text)
};
sics.Add(sic);
}
int num = int.Parse(txtBFnum.Text); //获取病床数
string str = new IdCard_BLL().sickroom(sics, num); //添加相应数量的病床
Tip t = new Tip(str);
t.ShowDialog();
}
