//病历提交
private void Button7_Click(object sender, RoutedEventArgs e)
{
List <Control> tb_list = new List <Control>()
{
txtZhushu,
txtJiwangshi,
txtGerenshi,
txtTijian,
txtJianyi,
txtJiatingshi,
txtGuominshi,
txtXianbingshi,
txtFuzhu
};
if (txtKId.Text == "" || txtRid.Text == "")
{
MessageBox.Show("请先选择挂号单 !");
return;
}
foreach (Control item in tb_list)
{
if (item is TextBox)
{
if (((TextBox)item).Text == "")
{
MessageBox.Show("请把病历填写完整 !");
return;
}
}
}
Bingli Bl = new Bingli
{
kId = int.Parse(txtKId.Text),
Rid = txtRid.Text,
bing = txtZhenduan.Text,
zhusu = txtZhushu.Text,
xianbingshi = txtXianbingshi.Text,
jiwangbingshi = txtJiwangshi.Text,
guominshi = txtGuominshi.Text,
geirenshi = txtGerenshi.Text,
jiatingshi = txtJiatingshi.Text,
tijian = txtTijian.Text,
fuzhu = txtFuzhu.Text,
zhiliaojianyi = txtJianyi.Text
};
string mes = new Prescribe_BLL().Bingli_Insert(Bl);
MessageBox.Show(mes);
}
/// <summary>
/// 添加病历
/// </summary>
/// <param name="bl"></param>
/// <returns></returns>
public string Bingli_Insert(Bingli bl)
{
int re = new Prescribe_DAL().Bingli_Insert(bl);
if (re == 0)
{
return("该病历已经存在");
}
else if (re == 1)
{
return("提交病历成功");
}
else
{
return("提交病历失败");
}
}
public int Bingli_Insert(Bingli bl)
{
SqlParameter kId = new SqlParameter("@kId", SqlDbType.Int);
SqlParameter Rid = new SqlParameter("@Rid", SqlDbType.VarChar);
SqlParameter bing = new SqlParameter("@bing", SqlDbType.VarChar);
SqlParameter zhusu = new SqlParameter("@zhusu", SqlDbType.VarChar);
SqlParameter xianbingshi = new SqlParameter("@xianbingshi", SqlDbType.VarChar);
SqlParameter jiwangbingshi = new SqlParameter("@jiwangbingshi", SqlDbType.VarChar);
SqlParameter guominshi = new SqlParameter("@guominshi", SqlDbType.VarChar);
SqlParameter geirenshi = new SqlParameter("@geirenshi", SqlDbType.VarChar);
SqlParameter jiatingshi = new SqlParameter("@jiatingshi", SqlDbType.VarChar);
SqlParameter tijian = new SqlParameter("@tijian", SqlDbType.VarChar);
SqlParameter fuzhu = new SqlParameter("@fuzhu", SqlDbType.VarChar);
SqlParameter zhiliaojianyi = new SqlParameter("@zhiliaojianyi", SqlDbType.VarChar);
SqlParameter result = new SqlParameter("@result", SqlDbType.Int);
result.Direction = ParameterDirection.Output;
kId.Value = bl.kId;
Rid.Value = bl.Rid;
bing.Value = bl.bing;
zhusu.Value = bl.zhusu;
xianbingshi.Value = bl.xianbingshi;
jiwangbingshi.Value = bl.jiwangbingshi;
guominshi.Value = bl.guominshi;
geirenshi.Value = bl.geirenshi;
jiatingshi.Value = bl.jiatingshi;
tijian.Value = bl.tijian;
fuzhu.Value = bl.fuzhu;
zhiliaojianyi.Value = bl.zhiliaojianyi;
SqlParameter[] sp = { kId, Rid, bing, zhusu, xianbingshi, jiwangbingshi, guominshi, geirenshi, jiatingshi, tijian, fuzhu, zhiliaojianyi, result };
bool f = DBHelper.ExecuteNonQueryProc("Bingli_insert", sp);
if (f)
{
return((int)result.Value);
}
else
{
return(-1);
}
}
private void button7_Click(object sender, EventArgs e)
{
if (txtKId.Text == "" || txtRid.Text == "")
{
MessageBox.Show("请先选择挂号单 !");
return;
}
foreach (Control item in tabPage2.Controls)
{
if (item is TextBox)
{
if (item.Text == "")
{
MessageBox.Show("请把病历填写完整 !");
return;
}
}
}
Bingli Bl = new Bingli();
Bl.kId = int.Parse(txtKId.Text);
Bl.Rid = txtRid.Text;
Bl.bing = txtChenduan.Text;
Bl.zhusu = txtZhushu.Text;
Bl.xianbingshi = txtXianbingshi.Text;
Bl.jiwangbingshi = txtJiwangshi.Text;
Bl.guominshi = txtGuominshi.Text;
Bl.geirenshi = txtGerenshi.Text;
Bl.jiatingshi = txtJiatingshi.Text;
Bl.tijian = txtTijian.Text;
Bl.fuzhu = txtFuzhu.Text;
Bl.zhiliaojianyi = txtJianyi.Text;
string mes = new Prescribe_BLL().Bingli_Insert(Bl);
MessageBox.Show(mes);
}
