private void button1_Click(object sender, EventArgs e) { foreach (Control item in groupBox1.Controls) { if ((item is TextBox || item is ComboBox) && item.Text == "") { PromptingForm prom = new PromptingForm("请把信息填完整!"); prom.ShowDialog(); return; } } zhuyuan zhu = new zhuyuan(); zhu.kId = int.Parse(txtKId.Text); zhu.Idsickroom = int.Parse(cbobingfang.Text); zhu.Sid = cboKebie.SelectedIndex; zhu.BedNo = cbobingchuang.Text; zhu.Imprest = int.Parse(txtyujiaofei.Text); zhu.Bewrite = txtmiaoshu.Text; zhu.Tabu = txtjinji.Text; zhu.Ztime = DateTime.Now + ""; string str = new IdCard_BLL().p_zhuyuan_insert(zhu); PromptingForm p = new PromptingForm(str); p.ShowDialog(); }
/// <summary> /// 查询病人信息 /// </summary> /// <returns></returns> public List <zhuyuan> p_zhuyuan_Select() { SqlDataReader reader = DBHelper.SectionRoomSelect("p_zhuyuan_select"); List <zhuyuan> zhu = new List <zhuyuan>(); while (reader.Read()) { zhuyuan cd = new zhuyuan(); cd.kId = int.Parse(reader[0] + ""); cd.Sid = int.Parse(reader[1] + ""); cd.Idsickroom = int.Parse(reader[2] + ""); cd.BedNo = (reader[3] + ""); cd.Imprest = int.Parse(reader[4] + ""); cd.Bewrite = reader[5] + ""; cd.Tabu = reader[6] + ""; cd.Ztime = reader[7] + ""; cd.Kname = reader[8] + ""; zhu.Add(cd); } DBHelper.con.Close(); DBHelper.con.Dispose(); DBHelper.cmd.Dispose(); return(zhu); //return cards; }
private void BtnSure_Click(object sender, RoutedEventArgs e) { List <Control> con_list = new List <Control>() { txtjinji, txtKId, txtmiaoshu, txtyujiaofei, cbobingchuang, cbobingfang, cboKebie }; foreach (Control item in con_list) { if (item is TextBox) { if (((TextBox)item).Text == "") { var t = new Tip("请把信息填完整!"); t.ShowDialog(); return; } } else { if (((ComboBox)item).Text == "") { var t = new Tip("请把信息填完整!"); t.ShowDialog(); return; } } } zhuyuan zhu = new zhuyuan { kId = int.Parse(txtKId.Text), Idsickroom = int.Parse(cbobingfang.Text), Sid = cboKebie.SelectedIndex, BedNo = cbobingchuang.Text, Imprest = int.Parse(txtyujiaofei.Text), Bewrite = txtmiaoshu.Text, Tabu = txtjinji.Text, Ztime = DateTime.Now + "" }; string str = new IdCard_BLL().p_zhuyuan_insert(zhu); var p = new Tip(str); p.ShowDialog(); }
/// <summary> /// 住院病人信息添加 /// </summary> /// <param name="zhu"></param> /// <returns></returns> public string p_zhuyuan_insert(zhuyuan zhu) { SqlParameter kId = new SqlParameter("@kId", SqlDbType.Int); SqlParameter Sid = new SqlParameter("@Sid", SqlDbType.Int); SqlParameter Idsickroom = new SqlParameter("@Idsickroom", SqlDbType.Int); SqlParameter BedNo = new SqlParameter("@BedNo", SqlDbType.Char); SqlParameter Imprest = new SqlParameter("@Imprest", SqlDbType.Int); SqlParameter Bewrite = new SqlParameter("@Bewrite", SqlDbType.Char); SqlParameter Tabu = new SqlParameter("@Tabu", SqlDbType.Char); SqlParameter Ztime = new SqlParameter("@Ztime", SqlDbType.Char); SqlParameter result = new SqlParameter("@result", SqlDbType.Char, 2); result.Direction = ParameterDirection.Output; kId.Value = zhu.kId; Sid.Value = zhu.Sid; Idsickroom.Value = zhu.Idsickroom; BedNo.Value = zhu.BedNo; Imprest.Value = zhu.Imprest; Bewrite.Value = zhu.Bewrite; Tabu.Value = zhu.Tabu; Ztime.Value = zhu.Ztime; SqlParameter[] sp = { kId, Sid, Idsickroom, BedNo, Imprest, Bewrite, Tabu, Ztime, result }; bool f = DBHelper.ExecuteNonQueryProc("p_zhuyuan_insert", sp); if (result.Value + "" == "KO") { return("此卡已申请过!"); } if (result.Value + "" == "NO") { return("此卡不存在,请确认输入正确!"); } else if (f) { return("提交成功,需预交费" + Imprest.Value + "元!"); } else { return("系统出错"); } }
public string p_zhuyuan_insert(zhuyuan zhu) { return(new IdCard_DAL().p_zhuyuan_insert(zhu)); }