public int kaiyao_Insert(Kaiyao ky)
{
SqlParameter Rid = new SqlParameter("@Rid", SqlDbType.VarChar);
SqlParameter kId = new SqlParameter("@kId", SqlDbType.Int);
SqlParameter yaopinName = new SqlParameter("@yaopinName", SqlDbType.VarChar);
SqlParameter zhuangtai = new SqlParameter("@zhuangtai", SqlDbType.VarChar);
SqlParameter yizhu = new SqlParameter("@yizhu", SqlDbType.VarChar);
SqlParameter yongfa = new SqlParameter("@yongfa", SqlDbType.VarChar);
SqlParameter result = new SqlParameter("@result", SqlDbType.Int);
result.Direction = ParameterDirection.Output;
Rid.Value = ky.Rid;
kId.Value = ky.Kid;
yaopinName.Value = ky.yaopinName;
zhuangtai.Value = ky.zhuangtai;
yizhu.Value = ky.yizhu;
yongfa.Value = ky.yongfa;
SqlParameter[] sp = { kId, Rid, yaopinName, zhuangtai, yizhu, yongfa, result };
bool f = DBHelper.ExecuteNonQueryProc("kaiyao_insert", sp);
if (f)
{
return((int)result.Value);
}
else
{
return(-1);
}
}
/// <summary>
/// 添加药方
/// </summary>
/// <param name="ky"></param>
/// <returns></returns>
public string kaiyao_Insert(Kaiyao ky)
{
int re = new Prescribe_DAL().kaiyao_Insert(ky);
if (re == 0)
{
return("该药方已经存在");
}
else if (re == 1)
{
return("提交药方成功");
}
else
{
return("提交药方失败");
}
}
//中药提交
private void BtnOk_Click(object sender, RoutedEventArgs e)
{
if (txtKId.Text == "" || txtRid.Text == "")
{
var t1 = new Tip("请先选择挂号单 !");
t1.ShowDialog();
return;
}
if (txtYizhu.Text == "" || txtJinji.Text == "")
{
var t2 = new Tip("请把药方填写完整 !");
t2.ShowDialog();
return;
}
string ypName = "";
if (lvwYaofang.SelectedItems.Count > 0)
{
string str = lvwYaofang.Items[lvwYaofang.SelectedIndex].ToString();
string[] ss = str.Split(',');
//foreach (ListViewItem item in lvwYaofang.Items)
//{
// ypName += ss[1].Substring(3).Replace("=", "").Trim() + "-";
//}
Kaiyao ky = new Kaiyao
{
Rid = txtRid.Text,
Kid = int.Parse(txtKId.Text),
yaopinName = ypName,
zhuangtai = "no",
yizhu = txtYizhu.Text,
yongfa = txtJinji.Text
};
if (lvwGuaHaoShow.SelectedItems.Count > 0)
{
lvwGuaHaoShow.Items.RemoveAt(lvwGuaHaoShow.SelectedIndex);
}
string mes = new Prescribe_BLL().kaiyao_Insert(ky);
//MessageBox.Show(mes);
var t = new Tip("提交成功！");
t.ShowDialog();
}
}
