private void butadd_Click(object sender, System.EventArgs e)
{
try
{
if (Convert.ToInt32(Convertor.IsNull(lblypmc.Tag, "0")) == 0)
{
MessageBox.Show("没有选择药品");
return;
}
if (Convertor.IsNumeric(Convertor.IsNull(lblypmc.Tag, "0")) == false)
{
MessageBox.Show("基数请输入数字");
return;
}
DataTable tb = (DataTable)this.myDataGrid1.DataSource;
DataRow row = tb.NewRow();
int _ggid = Convert.ToInt32(Convertor.IsNull(lblypmc.Tag, "0"));
DataRow[] selectrow = tb.Select("ggid='" + _ggid.ToString() + "'");
if (selectrow.Length > 0)
{
MessageBox.Show("当前药品已在列表添加了");
return;
}
Ypgg ydgg = new Ypgg(_ggid, InstanceForm.BDatabase);
row["序号"] = tb.Rows.Count + 1;
row["品名"] = ydgg.YPPM;
row["商品名"] = ydgg.YPSPM;
row["规格"] = ydgg.YPGG;
//row["零售价"]=ydcj.LSJ;
row["基数"] = Convertor.IsNull(txtjs.Text, "0");
row["单位"] = Yp.SeekYpdw(ydgg.YPDW, InstanceForm.BDatabase);
//row["货号"]=ydcj.SHH;
row["ggid"] = ydgg.GGID;
row["启用日期"] = this.dtpqyrq.Value.ToShortDateString();
tb.Rows.Add(row);
lblypmc.Text = "";
lblypmc.Tag = "0";
lblgg.Text = "";
//lblcj.Text="";
lbldw.Text = "";
//lbllsj.Text="";
//lblhh.Text="";
txtypdm.Text = "";
txtjs.Text = "";
txtypdm.Focus();
}
catch (System.Exception err)
{
MessageBox.Show(err.Message);
}
}
//初始药品
private void csyp(int ggid, int cjid)
{
try
{
Ypgg ydgg = new Ypgg(ggid, InstanceForm.BDatabase);
this.lblypmc.Tag = ydgg.GGID.ToString();
this.lblypmc.Text = ydgg.YPPM;
this.lblypspm.Text = ydgg.YPSPM;
this.lblgg.Text = ydgg.YPGG;
//this.lblcj.Text=ydcj.S_SCCJ;
//this.lblhh.Text=ydcj.SHH;
//this.lbllsj.Text=ydcj.LSJ.ToString() ;
this.lbldw.Text = Yp.SeekYpdw(ydgg.YPDW, InstanceForm.BDatabase);
}
catch (System.Exception err)
{
MessageBox.Show("发生错误" + err.Message);
}
}
private void butok_hb_Click(object sender, System.EventArgs e)
{
DataTable tb = (DataTable)this.myDataGrid1.DataSource;
DataTable tab = (DataTable)this.myDataGrid2.DataSource;
int nrow1 = this.myDataGrid1.CurrentCell.RowNumber;
int nrow2 = this.myDataGrid2.CurrentCell.RowNumber;
if (nrow1 > tb.Rows.Count - 1)
{
return;
}
if (nrow2 > tab.Rows.Count - 1)
{
return;
}
if (MessageBox.Show("您确定要将上面的厂家替换成下面的规格吗 ？", "询问窗", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.No)
{
return;
}
//要替换成的规格ID
int _gg_ggid = Convert.ToInt32(tab.Rows[nrow2]["ggid"]);
try
{
Ypgg gg = new Ypgg(_gg_ggid, InstanceForm.BDatabase);
if (gg.GGID == 0)
{
MessageBox.Show("该规格可能已经不存在了"); return;
}
InstanceForm.BDatabase.BeginTransaction();
//要被替换的厂家ID
int _cj_cjid = Convert.ToInt32(tb.Rows[nrow1]["CJID"]);
//厂家
string ssql = "update yp_ypcjd set ggid=" + _gg_ggid + ",s_ypspm='" + gg.YPSPM + "',s_yppm='" + gg.YPPM +
"',s_ypspmbz='" + gg.YPSPMBZ + "',s_ypgg='" + gg.YPGG + "',s_ypdw='" + Yp.SeekYpdw(gg.YPDW, InstanceForm.BDatabase) + "' where cjid=" + _cj_cjid + " ";
InstanceForm.BDatabase.DoCommand(ssql);
//药房库存
ssql = "update yf_kcmx set ggid=" + _gg_ggid + " where cjid=" + _cj_cjid + " ";
InstanceForm.BDatabase.DoCommand(ssql);
//药房批号
ssql = "update yf_kcph set ggid=" + _gg_ggid + " where cjid=" + _cj_cjid + " ";
InstanceForm.BDatabase.DoCommand(ssql);
//药库库存
ssql = "update yk_kcmx set ggid=" + _gg_ggid + " where cjid=" + _cj_cjid + " ";
InstanceForm.BDatabase.DoCommand(ssql);
//药库批号
ssql = "update yk_kcph set ggid=" + _gg_ggid + " where cjid=" + _cj_cjid + " ";
InstanceForm.BDatabase.DoCommand(ssql);
//药房盘点表
ssql = "update yf_pdtemp set ggid=" + _gg_ggid + " where cjid=" + _cj_cjid + " ";
InstanceForm.BDatabase.DoCommand(ssql);
//药库盘点表
ssql = "update yk_kcph set ggid=" + _gg_ggid + " where cjid=" + _cj_cjid + " ";
InstanceForm.BDatabase.DoCommand(ssql);
//药品拆零表
ssql = "update yp_ypcl set ggid=" + _gg_ggid + " where cjid=" + _cj_cjid + " ";
InstanceForm.BDatabase.DoCommand(ssql);
//更新药品货号
Ypcj ypcj = new Ypcj();
int _errcode = 0;
string _errtext = "";
ypcj.Update_shh(_gg_ggid, out _errcode, out _errtext, InstanceForm.BDatabase);
if (_errcode != 0)
{
throw new Exception(_errtext);
}
//三院数据处理_____保存日志
Ypcj cj = new Ypcj(_cj_cjid, InstanceForm.BDatabase);
string bz = "取消药品合并:" + cj.S_YPPM + " CJID=" + cj.CJID + " ";
Guid log_djid = Guid.Empty;
ts_HospData_Share.ts_update_log ts = new ts_HospData_Share.ts_update_log();
ts.Save_log(ts_HospData_Share.czlx.yp_药品取消合并, bz, "YP_YPCJD", "CJID", _cj_cjid.ToString(), InstanceForm._menuTag.Jgbm, 0, "", out log_djid, InstanceForm.BDatabase);
InstanceForm.BDatabase.CommitTransaction();
//三院数据处理___执行同步操作
string errtext = "";
ts_HospData_Share.ts_update_type ty = new ts_HospData_Share.ts_update_type((int)ts_HospData_Share.czlx.yp_药品取消合并, InstanceForm.BDatabase);
if (ty.Bzx == 1) //只有当立即执行标志为1时才执行
{
ts.Pexec_log(log_djid, InstanceForm.BDatabase, out errtext);
}
if (errtext != "")
{
MessageBox.Show("取消药品合并成功 " + errtext, "取消合并", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
this.Close();
}
catch (System.Exception err)
{
UpdateRows = null;
InstanceForm.BDatabase.RollbackTransaction();
MessageBox.Show(err.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void butok_Click(object sender, System.EventArgs e)
{
DataTable tb = (DataTable)this.myDataGrid1.DataSource;
DataRow[] rows = tb.Select("合并=1");
DataRow[] hbrow = tb.Select("合并=0");
if (rows.Length == 0)
{
MessageBox.Show("没有选择规格", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (hbrow.Length == 0)
{
MessageBox.Show("没有可匹配的药品，最少要选择两个药品", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
int _gg_ggid = Convert.ToInt32(rows[0]["ggid"]);
try
{
Ypgg gg = new Ypgg(_gg_ggid, InstanceForm.BDatabase);
if (gg.GGID == 0)
{
MessageBox.Show("该规格可能已经不存在了"); return;
}
string[] ss = new string[hbrow.Length];
InstanceForm.BDatabase.BeginTransaction();
for (int i = 0; i <= hbrow.Length - 1; i++)
{
int _cj_cjid = Convert.ToInt32(hbrow[i]["CJID"]);
//厂家
string ssql = "update yp_ypcjd set ggid=" + _gg_ggid + ",s_ypspm='" + gg.YPSPM + "',s_yppm='" + gg.YPPM +
"',s_ypspmbz='" + gg.YPSPMBZ + "',s_ypgg='" + gg.YPGG + "',s_ypdw='" + Yp.SeekYpdw(gg.YPDW, InstanceForm.BDatabase) + "' where cjid=" + _cj_cjid + " ";
InstanceForm.BDatabase.DoCommand(ssql);
//药房库存
ssql = "update yf_kcmx set ggid=" + _gg_ggid + " where cjid=" + _cj_cjid + " ";
InstanceForm.BDatabase.DoCommand(ssql);
//药房批号
ssql = "update yf_kcph set ggid=" + _gg_ggid + " where cjid=" + _cj_cjid + " ";
InstanceForm.BDatabase.DoCommand(ssql);
//药库库存
ssql = "update yk_kcmx set ggid=" + _gg_ggid + " where cjid=" + _cj_cjid + " ";
InstanceForm.BDatabase.DoCommand(ssql);
//药库批号
ssql = "update yk_kcph set ggid=" + _gg_ggid + " where cjid=" + _cj_cjid + " ";
InstanceForm.BDatabase.DoCommand(ssql);
//药房盘点表
ssql = "update yf_pdtemp set ggid=" + _gg_ggid + " where cjid=" + _cj_cjid + " ";
InstanceForm.BDatabase.DoCommand(ssql);
//药库盘点表
ssql = "update yk_kcph set ggid=" + _gg_ggid + " where cjid=" + _cj_cjid + " ";
InstanceForm.BDatabase.DoCommand(ssql);
//药品拆零表
ssql = "update yp_ypcl set ggid=" + _gg_ggid + " where cjid=" + _cj_cjid + " ";
InstanceForm.BDatabase.DoCommand(ssql);
//三院数据处理_____保存日志
Ypcj cj = new Ypcj(_cj_cjid, InstanceForm.BDatabase);
string bz = "将" + hbrow[i]["品名"].ToString() + " CJID=" + hbrow[i]["CJID"] + "的药品合并到新规格 ";
Guid log_djid = Guid.Empty;
ts_HospData_Share.ts_update_log ts = new ts_HospData_Share.ts_update_log();
ts.Save_log(ts_HospData_Share.czlx.yp_药品合并, bz, "YP_YPCJD", "CJID", _cj_cjid.ToString(), InstanceForm._menuTag.Jgbm, 0, "", out log_djid, InstanceForm.BDatabase);
ss[i] = log_djid.ToString();
}
//更新药品货号
Ypcj ypcj = new Ypcj();
int _errcode = 0;
string _errtext = "";
ypcj.Update_shh(_gg_ggid, out _errcode, out _errtext, InstanceForm.BDatabase);
if (_errcode != 0)
{
throw new Exception(_errtext);
}
InstanceForm.BDatabase.CommitTransaction();
UpdateRows = hbrow;
//三院数据处理___执行同步操作
string msg = "";
for (int i = 0; i <= ss.Length - 1; i++)
{
string errtext = "";
ts_HospData_Share.ts_update_type ty = new ts_HospData_Share.ts_update_type((int)ts_HospData_Share.czlx.yp_药品合并, InstanceForm.BDatabase);
if (ty.Bzx == 1) //只有当立即执行标志为1时才执行
{
ts_HospData_Share.ts_update_log ts = new ts_HospData_Share.ts_update_log();
ts.Pexec_log(new Guid(ss[i]), InstanceForm.BDatabase, out errtext);
}
msg = msg + errtext;
if (msg != "")
{
MessageBox.Show("药品合并成功 " + errtext, "合并", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
this.Close();
}
catch (System.Exception err)
{
UpdateRows = null;
InstanceForm.BDatabase.RollbackTransaction();
MessageBox.Show(err.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
