private void button9_Click(object sender, EventArgs e)
{
List <zhuyuanxiaofei> xfs = new List <zhuyuanxiaofei>();
foreach (ListViewItem item in lvwselect.Items)
{
zhuyuanxiaofei xf = new zhuyuanxiaofei();
xf.kId = int.Parse(txtId.Text);
xf.yaoName = item.SubItems[0].Text;
xf.yaonum = int.Parse(item.SubItems[3].Text);
xfs.Add(xf);
//MessageBox.Show(item.SubItems[3].Text);
}
new IdCard_BLL().p_zhuyuanxiaofei_insert(xfs);
}
//保存
private void Button9_Click(object sender, RoutedEventArgs e)
{
List <zhuyuanxiaofei> xfs = new List <zhuyuanxiaofei>();
string s = listView2.Items[listView2.SelectedIndex].ToString();
string[] ss = s.Split(',');
foreach (ListViewItem item in listView2.Items)
{
zhuyuanxiaofei xf = new zhuyuanxiaofei();
xf.kId = int.Parse(txtId.Text);
xf.yaoName = ss[0].Substring(4).Replace("=", "").Trim();
xf.yaonum = int.Parse(ss[3].Substring(3).Replace("=", "").Trim());
xfs.Add(xf);
//MessageBox.Show(item.SubItems[3].Text);
}
new IdCard_BLL().p_zhuyuanxiaofei_insert(xfs);
}
/// <summary>
/// 查询住院费用
/// </summary>
/// <param name="i"></param>
/// <returns></returns>
public List <zhuyuanxiaofei> p_zhuyuanxiaofei_select(int i)
{
SqlParameter kId = new SqlParameter("@kId", SqlDbType.Int);
kId.Value = i;
SqlParameter[] sp = { kId };
SqlDataReader reader = DBHelper.SectionRoomSelect("p_zhuyuanxiaofei_select", sp);
List <zhuyuanxiaofei> zhu = new List <zhuyuanxiaofei>();
while (reader.Read())
{
zhuyuanxiaofei cd = new zhuyuanxiaofei();
cd.kId = int.Parse(reader[1] + "");
cd.yaoName = reader[2] + "";
cd.yaonum = int.Parse(reader[3] + "");
zhu.Add(cd);
}
DBHelper.con.Close();
DBHelper.con.Dispose();
DBHelper.cmd.Dispose();
return(zhu);
}
