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));
}
