/// <summary>
/// 申请单出库后更新其审核状态
/// </summary>
/// <param name="sqdh"></param>
/// <param name="ckdh"></param>
/// <param name="deptid"></param>
/// <param name="employeeid"></param>
/// <param name="sdate"></param>
/// <param name="cmd"></param>
public static void Shdj(long sqdh, long ckdh, long deptid, long employeeid, string sdate, RelationalDatabase _DataBase, long jgbm)
{
Guid djid = Guid.Empty;
string ssql = "select * from yf_rksq where djh=" + sqdh + " and deptid=" + deptid + " and shbz=0 ";
DataTable tb = _DataBase.GetDataTable(ssql);
if (tb.Rows.Count > 0)
{
djid = new Guid(tb.Rows[0]["id"].ToString());
}
//回填审核标志
DataTable tbyjks = Yp.SelectYjks(deptid, _DataBase);
if (tbyjks.Rows.Count > 0)
{
if (Convert.ToInt32(tbyjks.Rows[0]["QYBZ"]) == 1)
{
if (Convert.ToInt32(tbyjks.Rows[0]["szjgbm"]) != jgbm)
{
string _err_text = "";
Guid log_djid = Guid.Empty;
ts_HospData_Share.ts_update_log ts = new ts_HospData_Share.ts_update_log();
string bz = TrasenFrame.Forms.FrmMdiMain.CurrentDept.DeptName + " 审核申领单 ";
ts.Save_log(ts_HospData_Share.czlx.yp_药房申请领药单, bz, "YF_RKSQ", "ID", djid.ToString(), jgbm, Convert.ToInt32(tbyjks.Rows[0]["szjgbm"]), 0, "", out log_djid, _DataBase);
}
}
}
ssql = "update YF_RKSQ set shbz=1,shr=" + employeeid + ",shrq='" + sdate + "',ckdh=" + ckdh + " where djh=" + sqdh + " and deptid=" + deptid + " and shbz=0";
_DataBase.DoCommand(ssql);
}
public static void SaveJkh_HK(Guid brxxid, Guid jhkid, int djy, out int err_code, out string err_text, RelationalDatabase _DataBase)
{
try
{
ParameterEx[] parameters = new ParameterEx[4];
parameters[0].Text = "@jhkid";
parameters[0].Value = jhkid;
parameters[1].Text = "@djy";
parameters[1].Value = djy;
parameters[2].Text = "@err_code";
parameters[2].ParaDirection = ParameterDirection.Output;
parameters[2].DataType = System.Data.DbType.Int32;
parameters[2].ParaSize = 100;
parameters[3].Text = "@err_text";
parameters[3].ParaDirection = ParameterDirection.Output;
parameters[3].ParaSize = 100;
_DataBase.DoCommand("SP_MZGH_KDJ_JHK_HK", parameters, 30);
err_code = Convert.ToInt32(parameters[2].Value);
err_text = Convert.ToString(parameters[3].Value);
Guid log_djid = Guid.Empty;
ts_HospData_Share.ts_update_log ts = new ts_HospData_Share.ts_update_log();
string _bz = "病人还卡 jhkid='" + jhkid.ToString() + "'";
ts.Save_log(ts_HospData_Share.czlx.br_病人信息同步, _bz, "yy_brxx", "brxxid", brxxid.ToString(), TrasenFrame.Forms.FrmMdiMain.Jgbm, 0, -999, "", out log_djid, _DataBase);
}
catch (System.Exception err)
{
throw new System.Exception(err.Message);
}
}
/// <summary>
/// 删除升级文件
/// </summary>
/// <param name="ts"></param>
/// <param name="LocalDatabase"></param>
public static void delete(ts_HospData_Share.ts_update_log ts, RelationalDatabase LocalDatabase)
{
string ssql = "";
string sql_insert = "";
string sql_update = "";
string sql_delete = "";
DataTable tb = null;
//returnSql(LocalDatabase, ts.Ymc, ts.Ylm, ts.Yzj, out sql_insert, out sql_update, out sql_delete, out tb);
string sDate = DateManager.ServerDateTimeByDBType(LocalDatabase).ToString();
//Modify By Tany 2010-02-22 找到本地的版本和名称信息，更新目标服务器时不用ID来判断，用版本和名称来判断
tb = LocalDatabase.GetDataTable("select Id, Type, Name, Update_Time, Version, Delete_bit, DelLocalReport from pub_systemupdate where id = " + ts.Yzj);
using (TransactionScope scope = new TransactionScope())
{
//目标服务器的链接
RelationalDatabase MB_DB = TrasenFrame.Classes.WorkStaticFun.GetJgbmDb(Convert.ToInt32(ts.MbjgbM));
//本地服务器的链接
RelationalDatabase BD_DB = TrasenFrame.Classes.WorkStaticFun.GetJgbmDb(Convert.ToInt32(ts.Djjgbm));
#region 业务操作
ssql = "update pub_systemupdate set delete_bit=1 where Version = '" + tb.Rows[0]["Version"].ToString() + "' and Name='" + tb.Rows[0]["Name"].ToString() + "'";
MB_DB.DoCommand(ssql);
#endregion
BD_DB.DoCommand("UPDATE ts_update_log set bwcbz=1,wcsj='" + sDate + "',wcczy=" + TrasenFrame.Forms.FrmMdiMain.CurrentUser.EmployeeId + " where id='" + ts.Id + "' and bwcbz=0");
scope.Complete();
}
}
public static void update(ts_HospData_Share.ts_update_log ts, RelationalDatabase LocalDatabase)
{
string ssql = "";
string sql_insert = "";
string sql_update = "";
string sql_delete = "";
DataTable tb = null;
if (ts.Ymc.ToLower() != "jc_cfmb")
{
throw new Exception("源名称必须是jc_cfmb");
}
returnSql(LocalDatabase, ts.Ymc, ts.Ylm, ts.Yzj, out sql_insert, out sql_update, out sql_delete, out tb);
string sDate = DateManager.ServerDateTimeByDBType(LocalDatabase).ToString();
ssql = "select * from jc_cfmb_mx where mbxh='" + ts.Yzj + "'";
DataTable tbmx = LocalDatabase.GetDataTable(ssql);
using (TransactionScope scope = new TransactionScope())
{
//目标服务器的链接
RelationalDatabase MB_DB = TrasenFrame.Classes.WorkStaticFun.GetJgbmDb(Convert.ToInt32(ts.MbjgbM));
//本地服务器的链接
RelationalDatabase BD_DB = TrasenFrame.Classes.WorkStaticFun.GetJgbmDb(Convert.ToInt32(ts.Djjgbm));
if (tb.Rows.Count == 0)
{
int ncount = MB_DB.DoCommand(sql_delete + " ");
MB_DB.DoCommand("delete from jc_cfmb_mx where mbxh='" + ts.Yzj + "'");
}
else
{
MB_DB.DoCommand("DELETE jc_cfmb WHERE mbxh='" + ts.Yzj + "'");
MB_DB.DoCommand("DELETE jc_cfmb_mx WHERE mbxh='" + ts.Yzj + "'");
MB_DB.DoCommand(sql_insert);
for (int i = 0; i <= tbmx.Rows.Count - 1; i++)
{
ssql = "insert into jc_cfmb_mx(mbmxxh,mbxh,xmid,xmly,jl,jldw,jldwid,dwlx,yf,pc,zt,ts,fzxh,pxxh,bzby,cjid,cfxh,zxks)values(" +
"'" + tbmx.Rows[i]["mbmxxh"].ToString() + "','" + tbmx.Rows[i]["mbxh"].ToString() + "'," + tbmx.Rows[i]["xmid"].ToString() + "," +
tbmx.Rows[i]["xmly"].ToString() + "," + tbmx.Rows[i]["jl"].ToString() + ",'" + tbmx.Rows[i]["jldw"].ToString() + "','" +
tbmx.Rows[i]["jldwid"].ToString() + "','" + tbmx.Rows[i]["dwlx"].ToString() + "','" + tbmx.Rows[i]["yf"].ToString() + "','" +
tbmx.Rows[i]["pc"].ToString() + "','" + tbmx.Rows[i]["zt"].ToString() + "'," + tbmx.Rows[i]["ts"].ToString() + ",'" +
tbmx.Rows[i]["fzxh"].ToString() + "','" + tbmx.Rows[i]["pxxh"].ToString() + "','" + tbmx.Rows[i]["bzby"].ToString() + "','" +
tbmx.Rows[i]["cjid"].ToString() + "','" + tbmx.Rows[i]["cfxh"].ToString() + "','" + tbmx.Rows[i]["zxks"].ToString() + "')";
MB_DB.DoCommand(ssql);
}
}
BD_DB.DoCommand("UPDATE ts_update_log set bwcbz=1,wcsj='" + sDate + "',wcczy=" + TrasenFrame.Forms.FrmMdiMain.CurrentUser.EmployeeId + " where id='" + ts.Id + "' and bwcbz=0");
scope.Complete();
}
}
public static void update(ts_HospData_Share.ts_update_log ts, RelationalDatabase LocalDatabase)
{
string ssql = "";
string sql_insert = "";
string sql_update = "";
string sql_delete = "";
DataTable tb = null;
returnSql(LocalDatabase, ts.Ymc, ts.Ylm, ts.Yzj, out sql_insert, out sql_update, out sql_delete, out tb);
string sDate = DateManager.ServerDateTimeByDBType(LocalDatabase).ToString();
using (TransactionScope scope = new TransactionScope())
{
//目标服务器的链接
RelationalDatabase MB_DB = TrasenFrame.Classes.WorkStaticFun.GetJgbmDb(Convert.ToInt32(ts.MbjgbM));
//本地服务器的链接
RelationalDatabase BD_DB = TrasenFrame.Classes.WorkStaticFun.GetJgbmDb(Convert.ToInt32(ts.Djjgbm));
if (tb.Rows.Count == 0)
{
MB_DB.DoCommand(sql_delete);
}
if (tb.Rows.Count == 1)
{
ssql = "select * from " + ts.Ymc + " where " + ts.Ylm + "='" + ts.Yzj + "'";
DataTable tb_mb = MB_DB.GetDataTable(ssql);
if (tb_mb.Rows.Count == 0)
{
MB_DB.DoCommand("SET IDENTITY_INSERT " + ts.Ymc + " ON");
MB_DB.DoCommand(sql_insert);
MB_DB.DoCommand("SET IDENTITY_INSERT " + ts.Ymc + " OFF");
}
else
{
MB_DB.DoCommand(sql_update);
}
}
if (ts.Ymc.ToLower() == "jc_usetype")
{
tb = null;
MB_DB.DoCommand("delete from jc_usage_usetype_role where type_id = " + ts.Yzj);
ssql = "select * from jc_usage_usetype_role where type_id=" + ts.Yzj + "";
tb = BD_DB.GetDataTable(ssql);
for (int i = 0; i <= tb.Rows.Count - 1; i++)
{
ssql = "insert into jc_usage_usetype_role(type_id,usage_id) values(" + tb.Rows[i]["type_id"] + "," + tb.Rows[i]["usage_id"] + ")";
MB_DB.DoCommand(ssql);
}
}
BD_DB.DoCommand("UPDATE ts_update_log set bwcbz=1,wcsj='" + sDate + "',wcczy=" + TrasenFrame.Forms.FrmMdiMain.CurrentUser.EmployeeId + " where id='" + ts.Id + "' and bwcbz=0");
scope.Complete();
}
}
private void toolbtnDel_Click(object sender, EventArgs e)
{
if (MessageBox.Show("您确定要删除这条记录？", "退出提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Asterisk) == DialogResult.OK)
{
InstanceForm.BDatabase.BeginTransaction();
try
{
ParameterEx[] parameters3 = new ParameterEx[7];
parameters3[0].Text = "@ID";
parameters3[0].Value = _id;
parameters3[1].Text = "@KSID";
parameters3[1].Value = txtDept.Tag.ToString();
parameters3[2].Text = "@FLID";
parameters3[2].Value = txtType.Tag.ToString();
parameters3[3].Text = "@PXXH";
parameters3[3].Value = txtPXXH.Text.Trim();
parameters3[4].Text = "@ZJID_QC";
parameters3[4].Value = 0;
parameters3[5].Text = "@i";
parameters3[5].Value = 3;
parameters3[6].Text = "@newid";
parameters3[6].ParaDirection = ParameterDirection.Output;
parameters3[6].DataType = System.Data.DbType.Int32;
parameters3[6].ParaSize = 100;
InstanceForm.BDatabase.DoCommand("SP_JC_MZPB_KSFLSZ", parameters3, 60);
//三院数据处理_____保存日志
string bz = "";
bz = "删除门诊排班科室分类设置:" + txtDept.Text.ToString().Trim();
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.jc_基础数据单表修改, bz, "JC_MZ_YSPB_KSFLMX", "ID", _id.ToString(), InstanceForm._menuTag.Jgbm, 0, "", out log_djid, InstanceForm.BDatabase);
InstanceForm.BDatabase.CommitTransaction();
ClearTxt();
Bangding();
//三院数据处理___执行同步操作
string errtext = "";
ts_HospData_Share.ts_update_type ty = new ts_HospData_Share.ts_update_type((int)ts_HospData_Share.czlx.jc_基础数据单表修改, InstanceForm.BDatabase);
if (ty.Bzx == 1 && log_djid != Guid.Empty) //只有当立即执行标志为1时才执行
{
ts.Pexec_log(log_djid, InstanceForm.BDatabase, out errtext);
if (errtext != "")
{
MessageBox.Show(errtext, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
catch (System.Exception err)
{
InstanceForm.BDatabase.RollbackTransaction();
MessageBox.Show(err.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
//合并药品
public static void update_hb(ts_HospData_Share.ts_update_log ts, RelationalDatabase LocalDatabase)
{
string ssql = "";
string sql_insert = "";
string sql_update = "";
string sql_delete = "";
DataTable tb = null;
returnSql(LocalDatabase, ts.Ymc, ts.Ylm, ts.Yzj, out sql_insert, out sql_update, out sql_delete, out tb);
string sDate = DateManager.ServerDateTimeByDBType(LocalDatabase).ToString();
if (ts.Ymc.ToLower() != "yp_ypcjd")
{
throw new Exception("源名称必须是yp_ypcjd");
}
using (TransactionScope scope = new TransactionScope())
{
//目标服务器的链接
RelationalDatabase MB_DB = TrasenFrame.Classes.WorkStaticFun.GetJgbmDb(Convert.ToInt32(ts.MbjgbM));
//本地服务器的链接
RelationalDatabase BD_DB = TrasenFrame.Classes.WorkStaticFun.GetJgbmDb(Convert.ToInt32(ts.Djjgbm));
//厂家
ssql = "update yp_ypcjd set ggid=" + Convert.ToInt32(tb.Rows[0]["ggid"]) + ",s_ypspm='" + Convertor.IsNull(tb.Rows[0]["s_ypspm"], "") + "',s_yppm='" + Convertor.IsNull(tb.Rows[0]["s_yppm"], "") +
"',s_ypspmbz='" + Convertor.IsNull(tb.Rows[0]["s_ypspmbz"], "") + "',s_ypgg='" + Convertor.IsNull(tb.Rows[0]["s_ypgg"], "") + "',s_ypdw='" + Convertor.IsNull(tb.Rows[0]["s_ypdw"], "") + "' where cjid=" + ts.Yzj + " ";
MB_DB.DoCommand(ssql);
//药房库存
ssql = "update yf_kcmx set ggid=" + Convert.ToInt32(tb.Rows[0]["ggid"]) + " where cjid=" + ts.Yzj + " ";
MB_DB.DoCommand(ssql);
//药房批号
ssql = "update yf_kcph set ggid=" + Convert.ToInt32(tb.Rows[0]["ggid"]) + " where cjid=" + ts.Yzj + " ";
MB_DB.DoCommand(ssql);
//药库库存
ssql = "update yk_kcmx set ggid=" + Convert.ToInt32(tb.Rows[0]["ggid"]) + " where cjid=" + ts.Yzj + " ";
MB_DB.DoCommand(ssql);
//药库批号
ssql = "update yk_kcph set ggid=" + Convert.ToInt32(tb.Rows[0]["ggid"]) + " where cjid=" + ts.Yzj + " ";
MB_DB.DoCommand(ssql);
//药房盘点表
ssql = "update yf_pdtemp set ggid=" + Convert.ToInt32(tb.Rows[0]["ggid"]) + " where cjid=" + ts.Yzj + " ";
MB_DB.DoCommand(ssql);
//药库盘点表
ssql = "update yk_kcph set ggid=" + Convert.ToInt32(tb.Rows[0]["ggid"]) + " where cjid=" + ts.Yzj + " ";
MB_DB.DoCommand(ssql);
//药品拆零表
ssql = "update yp_ypcl set ggid=" + Convert.ToInt32(tb.Rows[0]["ggid"]) + " where cjid=" + ts.Yzj + " ";
MB_DB.DoCommand(ssql);
BD_DB.DoCommand("UPDATE ts_update_log set bwcbz=1,wcsj='" + sDate + "',wcczy=" + TrasenFrame.Forms.FrmMdiMain.CurrentUser.EmployeeId + " where id='" + ts.Id + "' and bwcbz=0");
scope.Complete();
}
}
/// <summary>
/// 密码修改
/// </summary>
/// <param name="oldPWD">原来密码</param>
/// <param name="newPWD">新密码</param>
public bool ChangePassword(string oldPWD, string newPWD)
{
if (oldPWD != _password)
{
throw new Exception("User\\ChangePassword\\原始密码输入错误！");
}
//定义多院操作日志 Modify By Tany 2010-01-21
ts_HospData_Share.ts_update_log ts = new ts_HospData_Share.ts_update_log();
Guid log_djid = Guid.Empty;
this.Database.BeginTransaction();
try
{
string sql = "update pub_user set password='******' where id=" + _userID;
if (this.Database.DoCommand(sql) <= 0)
{
throw new Exception("密码修改失败！");
}
//处理多院数据处理，首先插入操作日志 Modify By Tany 2010-01-21
string cznr = "修改用户密码:【" + _loginCode + "】";
ts.Save_log(ts_HospData_Share.czlx.jc_用户修改, cznr, "pub_user", "id", _userID.ToString(), TrasenFrame.Forms.FrmMdiMain.Jgbm, -999, "", out log_djid, this.Database);
this.Database.CommitTransaction();
}
catch (Exception err)
{
this.Database.RollbackTransaction();
throw new Exception("User\\ChangePassword\\" + err.Message);
}
try
{
//查看该类型操作是否属于立即执行 Modify By Tany 2010-01-21
string errtext = "";
ts_HospData_Share.ts_update_type ty = new ts_HospData_Share.ts_update_type((int)ts_HospData_Share.czlx.jc_用户修改, this.Database);
if (ty.Bzx == 1 && log_djid != Guid.Empty)
{
//立即执行该操作 Modify By Tany 2010-01-21
ts.Pexec_log(log_djid, this.Database, out errtext);
}
if (errtext != "")
{
throw new Exception(errtext);
}
}
catch (Exception err)
{
MessageBox.Show("发生错误：" + err.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
this.Retrieve();
return(true);
}
private void btnDelPwd_Click(object sender, System.EventArgs e)
{
if (MessageBox.Show("确定要清除该用户的密码吗?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
//定义多院操作日志 Modify By Tany 2010-01-24
ts_HospData_Share.ts_update_log ts = new ts_HospData_Share.ts_update_log();
Guid log_djid = Guid.Empty;
db.BeginTransaction();
try
{
string sql = "update pub_user set [password]='' where id=" + cmbCode.SelectedValue.ToString() + " and employee_id=" + employee.EmployeeId + " and code = '" + this.cmbCode.Text + "'";
db.DoCommand(sql);
//处理多院数据处理，首先插入操作日志 Modify By Tany 2010-01-24
string cznr = "清空用户密码:【" + txtName.Text.Trim() + "】";
ts.Save_log(ts_HospData_Share.czlx.jc_用户修改, cznr, "pub_user", "id", cmbCode.SelectedValue.ToString(), jgbm, -999, "", out log_djid, db);
db.CommitTransaction();
}
catch (Exception err)
{
db.RollbackTransaction();
MessageBox.Show("清空用户密码：" + err.Message);
return;
}
try
{
//查看该类型操作是否属于立即执行 Modify By Tany 2010-01-21
string errtext = "";
ts_HospData_Share.ts_update_type ty = new ts_HospData_Share.ts_update_type((int)ts_HospData_Share.czlx.jc_用户修改, db);
if (ty.Bzx == 1 && log_djid != Guid.Empty)
{
//立即执行该操作 Modify By Tany 2010-01-21
ts.Pexec_log(log_djid, db, out errtext);
}
if (errtext != "")
{
throw new Exception(errtext);
}
}
catch (Exception err)
{
MessageBox.Show("发生错误：" + err.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//写入日志 Add By Tany 2012-02-02
SystemLog systemLog = new SystemLog(-1, FrmMdiMain.CurrentDept.DeptId, FrmMdiMain.CurrentUser.EmployeeId, "清空用户密码", FrmMdiMain.CurrentUser.Name + " 清空【" + employee.Name + "(EmployeeId：" + employee.EmployeeId + ")】密码", DateManager.ServerDateTimeByDBType(FrmMdiMain.Database), 0, "主机名：" + System.Environment.MachineName, (int)SystemModule.系统公共参数);
systemLog.Save();
systemLog = null;
MessageBox.Show("密码已经清除，请及时通知该用户修改密码");
}
}
/// <summary>
/// 修改系统菜单
/// </summary>
/// <param name="ts"></param>
/// <param name="LocalDatabase"></param>
public static void update_systemmenu(ts_HospData_Share.ts_update_log ts, RelationalDatabase LocalDatabase)
{
string ssql = "";
string sql_insert = "";
string sql_update = "";
string sql_delete = "";
DataTable tb = null;
returnSql(LocalDatabase, ts.Ymc, ts.Ylm, ts.Yzj, out sql_insert, out sql_update, out sql_delete, out tb);
string sDate = DateManager.ServerDateTimeByDBType(LocalDatabase).ToString();
using (TransactionScope scope = new TransactionScope())
{
//目标服务器的链接
RelationalDatabase MB_DB = TrasenFrame.Classes.WorkStaticFun.GetJgbmDb(Convert.ToInt32(ts.MbjgbM));
//本地服务器的链接
RelationalDatabase BD_DB = TrasenFrame.Classes.WorkStaticFun.GetJgbmDb(Convert.ToInt32(ts.Djjgbm));
#region 业务操作
ssql = "delete from pub_system_menu where system_Id=" + ts.Yzj + "";
MB_DB.DoCommand(ssql);
for (int i = 0; i <= tb.Rows.Count - 1; i++)
{
//如果目标机器没有这个菜单，则新增一个
ssql = "select * from pub_menu where menu_Id=" + tb.Rows[i]["Menu_Id"].ToString();
DataTable tb_mb = MB_DB.GetDataTable(ssql);
if (tb_mb.Rows.Count == 0)
{
DataTable tb_bd = BD_DB.GetDataTable(ssql);
//菜单需要自己组合入参，主要是因为Icon列是image格式 Modify By Tany 2010-01-29
sql_insert = "insert into pub_menu(Menu_Id, Name, Dll_Name, Function_Name, Icon, Delete_Bit, Function_Tag, ShowToolBar, JGBM)" +
" values ( " + tb_bd.Rows[0]["Menu_Id"].ToString() + ",'" + tb_bd.Rows[0]["Name"].ToString() + "'," +
" '" + tb_bd.Rows[0]["Dll_Name"].ToString() + "','" + tb_bd.Rows[0]["Function_Name"].ToString() + "', " +
" null," + tb_bd.Rows[0]["Delete_Bit"].ToString() + ", " +
" '" + tb_bd.Rows[0]["Function_Tag"].ToString() + "'," + tb_bd.Rows[0]["ShowToolBar"].ToString() + "," + tb_bd.Rows[0]["JGBM"].ToString() + " )";
MB_DB.DoCommand("SET IDENTITY_INSERT pub_menu ON");
MB_DB.DoCommand(sql_insert);
MB_DB.DoCommand("SET IDENTITY_INSERT pub_menu OFF");
}
MB_DB.DoCommand("SET IDENTITY_INSERT pub_system_menu ON");
MB_DB.DoCommand("insert into pub_system_menu(Sys_Menu_Id, System_Id, Menu_Id, Parent_id, Sort_Id, Delete_Bit) " +
"values( " + Convert.ToInt32(tb.Rows[i]["Sys_Menu_Id"]) + "," + Convert.ToInt32(tb.Rows[i]["System_Id"]) + ","
+ Convert.ToInt32(tb.Rows[i]["Menu_Id"]) + "," + Convert.ToInt32(tb.Rows[i]["Parent_id"]) + ","
+ Convert.ToInt32(tb.Rows[i]["Sort_Id"]) + "," + Convert.ToInt32(tb.Rows[i]["Delete_Bit"]) + ")");
MB_DB.DoCommand("SET IDENTITY_INSERT pub_system_menu OFF");
}
#endregion
BD_DB.DoCommand("UPDATE ts_update_log set bwcbz=1,wcsj='" + sDate + "',wcczy=" + TrasenFrame.Forms.FrmMdiMain.CurrentUser.EmployeeId + " where id='" + ts.Id + "' and bwcbz=0");
scope.Complete();
}
}
private void toolbtnDel_Click(object sender, EventArgs e)
{
if (MessageBox.Show("您确定要删除这条记录？", "退出提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Asterisk) == DialogResult.OK)
{
InstanceForm.BDatabase.BeginTransaction();
try
{
ParameterEx[] parameters3 = new ParameterEx[6];
parameters3[0].Text = "@id";
parameters3[0].Value = _id;
parameters3[1].Text = "@USE_NAME";
parameters3[1].Value = Convertor.IsNull(txtUse.Text.Trim(), "");
parameters3[2].Text = "@NUM";
parameters3[2].Value = Convert.ToInt32(this.txtNum.Text.Trim());
parameters3[3].Text = "@HSITEM_ID";
parameters3[3].Value = Convertor.IsNull(txtHsitem.Tag, "");
parameters3[4].Text = "@i";
parameters3[4].Value = 3;
parameters3[5].Text = "@newid";
parameters3[5].ParaDirection = ParameterDirection.Output;
parameters3[5].DataType = System.Data.DbType.Int32;
parameters3[5].ParaSize = 100;
InstanceForm.BDatabase.DoCommand("SP_JC_USEAGE_FEE_MZ", parameters3, 60);
//三院数据处理_____保存日志
string bz = "";
bz = "删除门诊用法附加费用:" + txtUse.Text.ToString().Trim();
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.jc_基础数据单表修改, bz, "jc_useage_fee_mz", "id", _id.ToString(), InstanceForm._menuTag.Jgbm, 0, "", out log_djid, InstanceForm.BDatabase);
InstanceForm.BDatabase.CommitTransaction();
ClearTxt();
Bind();
//三院数据处理___执行同步操作
string errtext = "";
ts_HospData_Share.ts_update_type ty = new ts_HospData_Share.ts_update_type((int)ts_HospData_Share.czlx.jc_基础数据单表修改, InstanceForm.BDatabase);
if (ty.Bzx == 1 && log_djid != Guid.Empty) //只有当立即执行标志为1时才执行
{
ts.Pexec_log(log_djid, InstanceForm.BDatabase, out errtext);
if (errtext != "")
{
MessageBox.Show(errtext, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
catch (System.Exception err)
{
InstanceForm.BDatabase.RollbackTransaction();
MessageBox.Show(err.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
TrasenClasses.DatabaseAccess.RelationalDatabase database = FrmMdiMain.Database;
try
{
database.BeginTransaction();
foreach (DataRow dr in datatableReleasor.Rows)
{
if (dr.RowState == DataRowState.Unchanged)
{
continue;
}
int employeeId = Convert.ToInt32(dr["EMPLOYEE_ID"]);
int allow_delete_all = Convert.IsDBNull(dr["ALLOW_DELETE_ALL"])? 0 : Convert.ToInt32(dr["ALLOW_DELETE_ALL"]);
int allow_edit_all = Convert.IsDBNull(dr["ALLOW_EDIT_ALL"]) ? 0: Convert.ToInt32(dr["ALLOW_EDIT_ALL"]);
int releasor_allserver = Convert.IsDBNull(dr["RELEASE_ALLSERVER"]) ? 0: Convert.ToInt32(dr["RELEASE_ALLSERVER"]);
DataRow r = database.GetDataRow("select * from pub_message_releasor where employee_id=" + employeeId);
string sql = "";
if (r != null)
{
sql = "update pub_message_releasor set allow_delete_all = " + allow_delete_all + " ,allow_edit_all = " + allow_edit_all + " ,release_allserver = " + releasor_allserver + " where employee_id=" + employeeId;
database.DoCommand(sql);
Guid djid;
ts_HospData_Share.ts_update_log log = new ts_HospData_Share.ts_update_log();
log.Save_log(ts_HospData_Share.czlx.jc_基础数据单表修改, "更改消息管理人员权限", "pub_message_releasor", "employee_id", employeeId.ToString(),
FrmMdiMain.Jgbm, -999, "", out djid, database);
}
else
{
sql = "insert into pub_message_releasor(employee_id,allow_delete_all,allow_edit_all,release_allserver) values(" + employeeId + "," + allow_delete_all + "," + allow_edit_all + "," + releasor_allserver + ")";
database.DoCommand(sql);
Guid djid;
ts_HospData_Share.ts_update_log log = new ts_HospData_Share.ts_update_log();
log.Save_log(ts_HospData_Share.czlx.jc_基础数据单表修改, "增加消息管理人员", "pub_message_releasor", "employee_id", employeeId.ToString(),
FrmMdiMain.Jgbm, -999, "", out djid, database);
}
}
database.CommitTransaction();
MessageBox.Show("保存成功", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception err)
{
database.RollbackTransaction();
MessageBox.Show(err.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnSave_Click(object sender, System.EventArgs e)
{
if (lvwNew.Items.Count == 0)
{
return;
}
try
{
//定义多院操作日志 Modify By Tany 2010-01-29
ts_HospData_Share.ts_update_log ts = new ts_HospData_Share.ts_update_log();
Guid log_djid = Guid.Empty;
db.BeginTransaction();
foreach (ListViewItem item in this.lvwNew.Items)
{
string sql = "update pub_system_menu set sort_id=" + item.Text + " where sys_menu_id=" + item.Tag.ToString();
db.DoCommand(sql);
}
//处理多院数据处理，首先插入操作日志 Modify By Tany 2010-01-29
string cznr = "修改系统菜单:【system_id=" + systemId.ToString().Trim() + "】";
ts.Save_log(ts_HospData_Share.czlx.jc_系统菜单修改, cznr, "pub_system_menu", "system_id", systemId.ToString(), jgbm, -999, "", out log_djid, db);
db.CommitTransaction();
try
{
//查看该类型操作是否属于立即执行 Modify By Tany 2010-01-29
string errtext = "";
ts_HospData_Share.ts_update_type ty = new ts_HospData_Share.ts_update_type((int)ts_HospData_Share.czlx.jc_系统菜单修改, db);
if (ty.Bzx == 1 && log_djid != Guid.Empty)
{
//立即执行该操作 Modify By Tany 2010-01-29
ts.Pexec_log(log_djid, db, out errtext);
}
if (errtext != "")
{
throw new Exception(errtext);
}
}
catch (Exception err)
{
MessageBox.Show("发生错误：" + err.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
this.Close();
}
catch (Exception err)
{
db.RollbackTransaction();
MessageBox.Show(err.Message);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
for (int i = 0; i < dgvSystem.Rows.Count; i++)
{
int systemId = Convert.IsDBNull(dgvSystem[COL_SYSTEM_ID.Name, i].Value) ? 0 : Convert.ToInt32(dgvSystem[COL_SYSTEM_ID.Name, i].Value);
int time = Convert.IsDBNull(dgvSystem[COL_AUTO_LOCK_TIME.Name, i].Value) ? 0 : Convert.ToInt32(dgvSystem[COL_AUTO_LOCK_TIME.Name, i].Value);
string bz = "更新锁定时间";
string sql = "update pub_system set auto_lock_time=" + time + " where system_id=" + systemId;
Guid log_djid = Guid.Empty;
ts_HospData_Share.ts_update_log ts = new ts_HospData_Share.ts_update_log();
try
{
FrmMdiMain.Database.BeginTransaction();
FrmMdiMain.Database.DoCommand(sql);
//处理多院数据处理，首先插入操作日志
ts.Save_log(ts_HospData_Share.czlx.jc_基础数据单表修改, bz, "pub_system", "system_id", systemId.ToString(),
FrmMdiMain.Jgbm, -999, "", out log_djid, FrmMdiMain.Database);
FrmMdiMain.Database.CommitTransaction();
}
catch
{
FrmMdiMain.Database.RollbackTransaction();
MessageBox.Show("设置锁定时间发生错误", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
try
{
//查看该类型操作是否属于立即执行
string errtext = "";
ts_HospData_Share.ts_update_type ty = new ts_HospData_Share.ts_update_type((int)ts_HospData_Share.czlx.jc_基础数据单表修改, FrmMdiMain.Database);
if (ty.Bzx == 1 && log_djid != Guid.Empty)
{
//立即执行该操作 Modify By Tany 2010-01-29
ts.Pexec_log(log_djid, FrmMdiMain.Database, out errtext);
}
if (errtext != "")
{
throw new Exception(errtext);
}
}
catch (Exception err)
{
MessageBox.Show("发生错误：" + err.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
MessageBox.Show("时间已设置,重新启动程序后将生效", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
/// <summary>
/// 删除组
/// </summary>
/// <param name="ts"></param>
/// <param name="LocalDatabase"></param>
public static void delete_group(ts_HospData_Share.ts_update_log ts, RelationalDatabase LocalDatabase)
{
string ssql = "";
string sql_insert = "";
string sql_update = "";
string sql_delete = "";
DataTable tb = null;
returnSql(LocalDatabase, ts.Ymc, ts.Ylm, ts.Yzj, out sql_insert, out sql_update, out sql_delete, out tb);
string sDate = DateManager.ServerDateTimeByDBType(LocalDatabase).ToString();
using (TransactionScope scope = new TransactionScope())
{
//目标服务器的链接
RelationalDatabase MB_DB = TrasenFrame.Classes.WorkStaticFun.GetJgbmDb(Convert.ToInt32(ts.MbjgbM));
//本地服务器的链接
RelationalDatabase BD_DB = TrasenFrame.Classes.WorkStaticFun.GetJgbmDb(Convert.ToInt32(ts.Djjgbm));
#region 业务操作
if (tb.Rows.Count == 0)
{
MB_DB.DoCommand(sql_delete);
}
if (tb.Rows.Count == 1)
{
ssql = "select * from " + ts.Ymc + " where " + ts.Ylm + "='" + ts.Yzj + "'";
DataTable tb_mb = MB_DB.GetDataTable(ssql);
if (tb_mb.Rows.Count == 0)
{
MB_DB.DoCommand("SET IDENTITY_INSERT " + ts.Ymc + " ON");
MB_DB.DoCommand(sql_insert);
MB_DB.DoCommand("SET IDENTITY_INSERT " + ts.Ymc + " OFF");
}
else
{
MB_DB.DoCommand(sql_update);
}
}
ssql = "delete from pub_group_menu where group_id=" + ts.Yzj + "";
MB_DB.DoCommand(ssql);
#endregion
BD_DB.DoCommand("UPDATE ts_update_log set bwcbz=1,wcsj='" + sDate + "',wcczy=" + TrasenFrame.Forms.FrmMdiMain.CurrentUser.EmployeeId + " where id='" + ts.Id + "' and bwcbz=0");
scope.Complete();
}
}
public static void UpdateMbmc(Guid mbid, string NewMbmc, RelationalDatabase _DataBase)
{
string ssql = "update jc_cfmb set mbmc='" + NewMbmc + "' where mbxh='" + mbid + "'";
int ii = _DataBase.DoCommand(ssql);
if (ii == 0)
{
throw new Exception("没有更新到处方模板");
}
Guid log_djid = Guid.Empty;
ts_HospData_Share.ts_update_log ts = new ts_HospData_Share.ts_update_log();
string _bz = "修改模板名称为:" + NewMbmc + " mbid='" + mbid + "'";
ts.Save_log(ts_HospData_Share.czlx.jc_处方模板, _bz, "jc_cfmb", "mbxh", mbid.ToString(), TrasenFrame.Forms.FrmMdiMain.Jgbm, 0, -999, "", out log_djid, _DataBase);
}
/// <summary>
/// 回写申请领药单
/// </summary>
/// <param name="ts"></param>
/// <param name="errtext"></param>
public static void SH(ts_HospData_Share.ts_update_log ts)
{
using (TransactionScope scope = new TransactionScope())
{
//目标服务器的链接
RelationalDatabase MB_DB = TrasenFrame.Classes.WorkStaticFun.GetJgbmDb(Convert.ToInt32(ts.MbjgbM));
//本地服务器的链接
RelationalDatabase BD_DB = TrasenFrame.Classes.WorkStaticFun.GetJgbmDb(Convert.ToInt32(ts.Djjgbm));
string sDate = DateManager.ServerDateTimeByDBType(MB_DB).ToString();
string ssql = "update YF_RKSQ set shbz=1,shr=" + ts.Djy + ",shrq='" + ts.Djsj + "' where id='" + ts.Yzj + "' and shbz=0";
MB_DB.DoCommand(ssql);
BD_DB.DoCommand("UPDATE ts_update_log set bwcbz=1,wcsj='" + sDate + "',wcczy=" + TrasenFrame.Forms.FrmMdiMain.CurrentUser.EmployeeId + " where id='" + ts.Id + "' and bwcbz=0");
scope.Complete();
}
}
/// <summary>
///
/// </summary>
/// <param name="kdjid"></param>
/// <param name="brxxid"></param>
/// <param name="_DataBase"></param>
/// <returns></returns>
public static bool UpdateBKJE(Guid kdjid, Guid brxxid, int klx, int czy, RelationalDatabase _DataBase)
{
try
{
string ssql = "select RETAIL_PRICE from JC_HSITEM where ITEM_ID in (select SFXMID from JC_KLX where KLX=" + klx + " ) AND DELETE_BIT=0 ";
decimal bkje = Convert.ToDecimal(Convertor.IsNull(_DataBase.GetDataResult(ssql), "0"));
string usql = "update yy_kdjb set BKJE=" + bkje + " where KDJID='" + kdjid.ToString() + "' ";
_DataBase.DoCommand(usql);
Guid log_djid = Guid.Empty;
ts_HospData_Share.ts_update_log ts = new ts_HospData_Share.ts_update_log();
string _bz = Fun.SeekEmpName(czy, _DataBase) + " 新办卡存入金额 " + bkje.ToString() + " kdjid='" + kdjid.ToString() + "'";
ts.Save_log(ts_HospData_Share.czlx.br_病人信息同步, _bz, "yy_brxx", "brxxid", brxxid.ToString(), TrasenFrame.Forms.FrmMdiMain.Jgbm, 0, -999, "", out log_djid, _DataBase);
return(true);
}
catch (System.Exception err)
{
throw new System.Exception(err.Message);
}
}
//删除模板头
public static void Delete_Mb(Guid mbid, RelationalDatabase _DataBase)
{
string ssql = "update JC_CFMB set bscbz=1 where mbxh='" + mbid + "' and bscbz=0 ";
int i = _DataBase.DoCommand(ssql);
if (i == 0)
{
throw new Exception("删除模板时出错，可能该模板已删除，请刷新后重试");
}
Guid log_djid = Guid.Empty;
ts_HospData_Share.ts_update_log ts = new ts_HospData_Share.ts_update_log();
string _bz = "删除模板: mbid='" + mbid + "'";
ts.Save_log(ts_HospData_Share.czlx.jc_处方模板, _bz, "jc_cfmb", "mbxh", mbid.ToString(), TrasenFrame.Forms.FrmMdiMain.Jgbm, 0, -999, "", out log_djid, _DataBase);
SystemLog systemLog = new SystemLog(-1, TrasenFrame.Forms.FrmMdiMain.CurrentDept.DeptId, TrasenFrame.Forms.FrmMdiMain.CurrentUser.EmployeeId, "删除模板", "删除模板 mbid=" + mbid.ToString() + "", DateManager.ServerDateTimeByDBType(_DataBase), 0, "主机名：" + System.Environment.MachineName, 3);
bool bok = systemLog.Save();
systemLog = null;
}
/// <summary>
/// 更新组对应菜单
/// </summary>
/// <param name="ts"></param>
/// <param name="LocalDatabase"></param>
public static void update_groupmenu(ts_HospData_Share.ts_update_log ts, RelationalDatabase LocalDatabase)
{
string ssql = "";
string sql_insert = "";
string sql_update = "";
string sql_delete = "";
DataTable tb = null;
returnSql(LocalDatabase, ts.Ymc, ts.Ylm, ts.Yzj, out sql_insert, out sql_update, out sql_delete, out tb);
string sDate = DateManager.ServerDateTimeByDBType(LocalDatabase).ToString();
using (TransactionScope scope = new TransactionScope())
{
//目标服务器的链接
RelationalDatabase MB_DB = TrasenFrame.Classes.WorkStaticFun.GetJgbmDb(Convert.ToInt32(ts.MbjgbM));
//本地服务器的链接
RelationalDatabase BD_DB = TrasenFrame.Classes.WorkStaticFun.GetJgbmDb(Convert.ToInt32(ts.Djjgbm));
#region 业务操作
ssql = "delete from pub_group_menu where group_id=" + ts.Yzj + "";
MB_DB.DoCommand(ssql);
MB_DB.DoCommand("SET IDENTITY_INSERT pub_group_menu ON");
for (int i = 0; i <= tb.Rows.Count - 1; i++)
{
MB_DB.DoCommand("insert into pub_group_menu(group_sysmenu_id,group_id,system_menu_id,delete_bit) " +
"values( " + Convert.ToInt32(tb.Rows[i]["group_sysmenu_id"]) + "," + Convert.ToInt32(tb.Rows[i]["group_id"]) + ","
+ Convert.ToInt32(tb.Rows[i]["system_menu_id"]) + "," + Convert.ToInt32(tb.Rows[i]["delete_bit"]) + ")");
}
MB_DB.DoCommand("SET IDENTITY_INSERT pub_group_menu OFF");
#endregion
BD_DB.DoCommand("UPDATE ts_update_log set bwcbz=1,wcsj='" + sDate + "',wcczy=" + TrasenFrame.Forms.FrmMdiMain.CurrentUser.EmployeeId + " where id='" + ts.Id + "' and bwcbz=0");
scope.Complete();
}
}
/// <summary>
/// 删除菜单
/// </summary>
/// <param name="ts"></param>
/// <param name="LocalDatabase"></param>
public static void delete_menu(ts_HospData_Share.ts_update_log ts, RelationalDatabase LocalDatabase)
{
string ssql = "";
string sql_insert = "";
string sql_update = "";
string sql_delete = "";
DataTable tb = null;
returnSql(LocalDatabase, ts.Ymc, ts.Ylm, ts.Yzj, out sql_insert, out sql_update, out sql_delete, out tb);
string sDate = DateManager.ServerDateTimeByDBType(LocalDatabase).ToString();
using (TransactionScope scope = new TransactionScope())
{
//目标服务器的链接
RelationalDatabase MB_DB = TrasenFrame.Classes.WorkStaticFun.GetJgbmDb(Convert.ToInt32(ts.MbjgbM));
//本地服务器的链接
RelationalDatabase BD_DB = TrasenFrame.Classes.WorkStaticFun.GetJgbmDb(Convert.ToInt32(ts.Djjgbm));
#region 业务操作
if (tb.Rows.Count == 0)
{
ssql = "Delete From pub_group_menu where system_menu_id in ( select sys_menu_id from pub_system_menu where menu_id=" + ts.Yzj + ")";
MB_DB.DoCommand(ssql);
ssql = "Delete From pub_system_menu where menu_id = " + ts.Yzj + "";
MB_DB.DoCommand(ssql);
//ssql = "Delete From pub_menu where menu_Id=" + ts.Yzj + "";
//MB_DB.DoCommand(ssql);
MB_DB.DoCommand(sql_delete);
}
#endregion
BD_DB.DoCommand("UPDATE ts_update_log set bwcbz=1,wcsj='" + sDate + "',wcczy=" + TrasenFrame.Forms.FrmMdiMain.CurrentUser.EmployeeId + " where id='" + ts.Id + "' and bwcbz=0");
scope.Complete();
}
}
private void btnRemove_Click(object sender, EventArgs e)
{
if (MessageBox.Show("确定要从消息发布人列表中删除选中的人员吗?", "", MessageBoxButtons.OK, MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
DataRow[] drs = datatableReleasor.Select("SELECTED=1");
try
{
FrmMdiMain.Database.BeginTransaction();
foreach (DataRow r in drs)
{
int employeeId = Convert.ToInt32(r["EMPLOYEE_ID"]);
string sql = "delete from pub_message_releasor where employee_id=" + employeeId;
FrmMdiMain.Database.DoCommand(sql);
Guid djid;
ts_HospData_Share.ts_update_log log = new ts_HospData_Share.ts_update_log();
log.Save_log(ts_HospData_Share.czlx.jc_基础数据单表修改, "从消息管理人员列表删除人员", "pub_message_releasor", "employee_id", employeeId.ToString(),
FrmMdiMain.Jgbm, -999, "", out djid, FrmMdiMain.Database);
datatableReleasor.Rows.Remove(r);
}
FrmMdiMain.Database.CommitTransaction();
}
catch (Exception err)
{
FrmMdiMain.Database.RollbackTransaction();
MessageBox.Show(err.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void butsave_Click(object sender, System.EventArgs e)
{
ts_HospData_Share.ts_update_log ts = new ts_HospData_Share.ts_update_log();
Guid log_djid = Guid.Empty;
DataTable tb = (DataTable)this.myDataGrid1.DataSource;
string[] ss = new string[tb.Rows.Count];
try
{
this.butsave.Enabled = false;
InstanceForm.BDatabase.BeginTransaction();
string ssql = "";
string ghdwmc = "";
string pym = ""; string wbm = ""; string lxdh = ""; string lxr = "";
string lxdz = "";
for (int i = 0; i <= tb.Rows.Count - 1; i++)
{
if (tb.Rows[i].RowState == DataRowState.Unchanged)
{
continue;
}
int ID = Convert.ToInt32(Convertor.IsNull(tb.Rows[i]["id"], "0"));
ghdwmc = tb.Rows[i]["名称"].ToString();
pym = tb.Rows[i]["拼音码"].ToString();
wbm = tb.Rows[i]["五笔码"].ToString();
lxdh = tb.Rows[i]["联系电话"].ToString();
lxr = tb.Rows[i]["联系人"].ToString();
lxdz = tb.Rows[i]["地址"].ToString();
if (ghdwmc.Trim() != "")
{
if (ID == 0)
{
ssql = "insert into yp_ghdw(ghdwmc,pym,wbm,lxdh,lxr,lxdz) values('" + ghdwmc + "','" + pym + "','" + wbm + "','" + lxdh + "','" + lxr + "','" + lxdz + "') ";
}
else
{
ssql = "update yp_ghdw set ghdwmc='" + ghdwmc + "',pym='" + pym + "',wbm='" + wbm + "',lxdh='" + lxdh + "',lxr='" + lxr + "',lxdz='" + lxdz + "' where id=" + ID + " ";
}
//三院数据处理
if (ID == 0)
{
InstanceForm.BDatabase.DoCommand(ssql);
long newid = Convert.ToInt64(InstanceForm.BDatabase.GetDataTable("select @@IDENTITY").Rows[0][0]);
ts.Save_log(ts_HospData_Share.czlx.yp_药品基础数据单表修改, InstanceForm.BCurrentUser.Name + "添加药品供货商 【" + ghdwmc + " 】", "yp_ghdw", "id", newid.ToString(), InstanceForm._menuTag.Jgbm, 0, "", out log_djid, InstanceForm.BDatabase);
ss[i] = log_djid.ToString();
}
else
{
string _ssql = "select * from yp_ghdw where id=" + ID + " and ghdwmc='" + ghdwmc + "' and pym='" + ghdwmc + "' and lxdh='" + lxr + "' and lxdh='" + lxdh + "'";
DataTable tb_x = InstanceForm.BDatabase.GetDataTable(_ssql);
if (tb_x.Rows.Count == 0)
{
ts.Save_log(ts_HospData_Share.czlx.yp_药品基础数据单表修改, InstanceForm.BCurrentUser.Name + "修改药品供货商 【" + ghdwmc + " 】", "yp_ghdw", "id", ID.ToString(), InstanceForm._menuTag.Jgbm, 0, "", out log_djid, InstanceForm.BDatabase);
ss[i] = log_djid.ToString();
}
InstanceForm.BDatabase.DoCommand(ssql);
}
}
}
InstanceForm.BDatabase.CommitTransaction();
//MessageBox.Show("保存成功");
//this.butsave.Enabled=true;
//this.AddData("");
}
catch (System.Exception err)
{
this.butsave.Enabled = true;
InstanceForm.BDatabase.RollbackTransaction();
MessageBox.Show("发生错误" + err.Message);
return;
}
try
{
//三院数据处理
string msg = "";
for (int i = 0; i <= ss.Length - 1; i++)
{
if (Convertor.IsNull(ss[i], "") == "")
{
continue;
}
string errtext = "";
ts_HospData_Share.ts_update_log tss = new ts_HospData_Share.ts_update_log();
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)
{
tss.Pexec_log(new Guid(ss[i]), InstanceForm.BDatabase, out errtext);
msg = msg + errtext;
}
}
MessageBox.Show("保存成功");
this.butsave.Enabled = true;
this.AddData("");
}
catch (System.Exception err)
{
MessageBox.Show("发生错误" + err.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void butdel_Click(object sender, System.EventArgs e)
{
Guid log_djid = Guid.Empty;
ts_HospData_Share.ts_update_log ts = new ts_HospData_Share.ts_update_log();
try
{
DataTable tb = (DataTable)this.myDataGrid1.DataSource;
int nrow = this.myDataGrid1.CurrentCell.RowNumber;
if (nrow > tb.Rows.Count - 1)
{
return;
}
int ID = Convert.ToInt32(Convertor.IsNull(tb.Rows[nrow]["id"], "0"));
//看是否有过使用记录
string ssql = "select * from yk_dj where wldw=" + ID + " and (ywlx='001' or ywlx='002')";
DataTable tab = InstanceForm.BDatabase.GetDataTable(ssql);
if (tab.Rows.Count > 0)
{
MessageBox.Show("对不起，这个单位在系统中已经使用了，不能删除"); return;
}
InstanceForm.BDatabase.BeginTransaction();
ssql = "delete from yp_ghdw where id=" + ID + "";
InstanceForm.BDatabase.DoCommand(ssql);
//三院数据处理_____保存日志
if (ID > 0)
{
string bz = "删除供货单位 【" + tb.Rows[nrow]["名称"].ToString() + "】 ";
ts.Save_log(ts_HospData_Share.czlx.yp_药品基础数据单表修改, bz, "yp_ghdw", "id", ID.ToString(), InstanceForm._menuTag.Jgbm, 0, "", out log_djid, InstanceForm.BDatabase);
}
InstanceForm.BDatabase.CommitTransaction();
DataRow row = tb.Rows[nrow];
tb.Rows.Remove(row);
}
catch (System.Exception err)
{
InstanceForm.BDatabase.RollbackTransaction();
MessageBox.Show("发生错误" + err.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
try
{
//三院数据处理
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)
{
ts.Pexec_log(log_djid, InstanceForm.BDatabase, out errtext);
}
MessageBox.Show("删除成功" + errtext);
}
catch (System.Exception err)
{
MessageBox.Show("发生错误" + err.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
public static void update(ts_HospData_Share.ts_update_log ts, RelationalDatabase LocalDatabase)
{
string ssql = "";
string sql_insert = "";
string sql_update = "";
string sql_delete = "";
DataTable tb = null;
if (ts.Ymc.ToLower() != "yk_dj")
{
throw new Exception("源名称必须是YK_DJ");
}
returnSql(LocalDatabase, ts.Ymc, ts.Ylm, ts.Yzj, out sql_insert, out sql_update, out sql_delete, out tb);
string sDate = DateManager.ServerDateTimeByDBType(LocalDatabase).ToString();
ssql = "select id,djid,cjid,kwid,shh,yppm,ypspm,ypgg,sccj,ypph,ypxq,ypkl,sqsl,ypsl,ypdw,nypdw,ydwbl,jhj,pfj,lsj,jhje,pfje,lsje,djh,deptid,ywlx,bz,shdh from yk_djmx where djid='" + ts.Yzj + "'";
DataTable tbmx = LocalDatabase.GetDataTable(ssql);
int tojgbm = 0;
if (tb.Rows.Count > 0)
{
DataTable tb_jgbm = LocalDatabase.GetDataTable("select * from yp_yjks where deptid=" + tb.Rows[0]["wldw"].ToString() + "");
if (tb_jgbm.Rows.Count > 0)
{
tojgbm = Convert.ToInt32(tb_jgbm.Rows[0]["szjgbm"]);
}
}
using (TransactionScope scope = new TransactionScope())
{
//目标服务器的链接
RelationalDatabase MB_DB = TrasenFrame.Classes.WorkStaticFun.GetJgbmDb(Convert.ToInt32(ts.MbjgbM));
//本地服务器的链接
RelationalDatabase BD_DB = TrasenFrame.Classes.WorkStaticFun.GetJgbmDb(Convert.ToInt32(ts.Djjgbm));
if (tb.Rows.Count == 0)
{
MB_DB.DoCommand(sql_delete);
}
else
{
ssql = "select * from yk_DJ where id='" + ts.Yzj + "'";
DataTable tb_mb = MB_DB.GetDataTable(ssql);
if (tb_mb.Rows.Count > 0)
{
MB_DB.DoCommand(sql_update);
}
else
{
MB_DB.DoCommand(sql_insert);
}
}
for (int i = 0; i <= tbmx.Rows.Count - 1; i++)
{
ssql = "insert into YK_DJMX(id,djid,cjid,kwid,shh,yppm,ypspm,ypgg,sccj,ypph,ypxq,ypkl,sqsl,ypsl,ypdw,nypdw,ydwbl," +
" jhj,pfj,lsj,jhje,pfje,lsje,djh,deptid,ywlx,bz,shdh)values(" +
"'" + tbmx.Rows[i]["id"].ToString() + "','" + tbmx.Rows[i]["djid"].ToString() + "'," + tbmx.Rows[i]["cjid"].ToString() + "," +
tbmx.Rows[i]["kwid"].ToString() + ",'" + tbmx.Rows[i]["shh"].ToString() + "','" + tbmx.Rows[i]["yppm"].ToString() + "','" +
tbmx.Rows[i]["ypspm"].ToString() + "','" + tbmx.Rows[i]["ypgg"].ToString() + "','" + tbmx.Rows[i]["sccj"].ToString() + "','" +
tbmx.Rows[i]["ypph"].ToString() + "','" + tbmx.Rows[i]["ypxq"].ToString() + "'," + tbmx.Rows[i]["ypkl"].ToString() + "," +
tbmx.Rows[i]["sqsl"].ToString() + "," + tbmx.Rows[i]["ypsl"].ToString() + ",'" + tbmx.Rows[i]["ypdw"].ToString() + "'," +
tbmx.Rows[i]["nypdw"].ToString() + "," + Convertor.IsNull(tbmx.Rows[i]["ydwbl"], "") + "," + Convertor.IsNull(tbmx.Rows[i]["jhj"], "") +
"," + tbmx.Rows[i]["pfj"].ToString() + "," + tbmx.Rows[i]["lsj"].ToString() + "," + tbmx.Rows[i]["jhje"].ToString() +
"," + tbmx.Rows[i]["pfje"].ToString() + "," + tbmx.Rows[i]["lsje"].ToString() + ",'" + tbmx.Rows[i]["djh"].ToString() +
"'," + tbmx.Rows[i]["deptid"].ToString() + ",'" + tbmx.Rows[i]["ywlx"].ToString() + "','" + tbmx.Rows[i]["bz"].ToString() + "','" + tbmx.Rows[i]["shdh"].ToString() + "')";
MB_DB.DoCommand(ssql);
}
if (tb.Rows.Count > 0)
{
ParameterEx[] parameters = new ParameterEx[10];
parameters[0].Text = "@djh";
parameters[0].Value = tb.Rows[0]["DJH"].ToString();
parameters[1].Text = "@deptid";
parameters[1].Value = tb.Rows[0]["deptid"].ToString();
parameters[2].Text = "@sqdh";
parameters[2].Value = tb.Rows[0]["sqdh"].ToString();
parameters[3].Text = "@sqks";
parameters[3].Value = tb.Rows[0]["WLDW"].ToString();
parameters[4].Text = "@ywlx";
parameters[4].Value = tb.Rows[0]["YWLX"].ToString();
parameters[5].Text = "@djid";
parameters[5].ParaDirection = ParameterDirection.Output;
parameters[5].DataType = System.Data.DbType.Guid;
parameters[5].ParaSize = 100;
parameters[6].Text = "@err_code";
parameters[6].ParaDirection = ParameterDirection.Output;
parameters[6].DataType = System.Data.DbType.Int32;
parameters[6].ParaSize = 100;
parameters[7].Text = "@err_text";
parameters[7].ParaDirection = ParameterDirection.Output;
parameters[7].ParaSize = 100;
parameters[8].Text = "@tojgbm";
parameters[8].Value = tojgbm;
parameters[9].Text = "@YDJID";
parameters[9].Value = ts.Yzj;
MB_DB.DoCommand("sp_Yk_Rksq_Insert_Djmx", parameters, 30);
Guid djid = new Guid(Convertor.IsNull(parameters[5].Value.ToString(), Guid.Empty.ToString()));
int err_code = Convert.ToInt32(parameters[6].Value);
string err_text = Convert.ToString(parameters[7].Value);
if (err_code != 0)
{
throw new Exception(err_text);
}
MB_DB.DoCommand("delete from yk_dj where id='" + ts.Yzj + "'");
MB_DB.DoCommand("delete from yk_djmx where djid='" + ts.Yzj + "'");
if (new SystemCfg(8018, BD_DB).Config == "1")
{
#region 审核药房的出库单
ssql = "update yf_dj set shbz=1,shy=" + ts.Djy + ",shrq='" + ts.Djsj + "' where id='" + djid + "' and shbz=0";
int nrow = (int)MB_DB.DoCommand(ssql, 30);
if (nrow != 1)
{
throw new System.Exception("审核药房[药品出库单]错误，数据影响了多行或零行，请和管理员联系");
}
ParameterEx[] parameters1 = new ParameterEx[4];
parameters1[0].Text = "@djid";
parameters1[0].Value = djid;
parameters1[1].Text = "@err_code";
parameters1[1].ParaDirection = ParameterDirection.Output;
parameters1[1].DataType = System.Data.DbType.Int32;
parameters1[1].ParaSize = 100;
parameters1[2].Text = "@err_text";
parameters1[2].ParaDirection = ParameterDirection.Output;
parameters1[2].ParaSize = 100;
parameters1[3].Text = "@jgbm";
parameters1[3].Value = tojgbm;
MB_DB.DoCommand("sp_yf_updatekcmx", parameters1, 120);
err_code = Convert.ToInt32(parameters1[1].Value);
err_text = Convert.ToString(parameters1[2].Value);
if (err_code != 0)
{
throw new Exception(err_text);
}
#endregion
}
}
BD_DB.DoCommand("UPDATE ts_update_log set bwcbz=1,wcsj='" + sDate + "',wcczy=" + TrasenFrame.Forms.FrmMdiMain.CurrentUser.EmployeeId + " where id='" + ts.Id + "' and bwcbz=0");
scope.Complete();
}
}
public static void update(ts_HospData_Share.ts_update_log ts, RelationalDatabase LocalDatabase)
{
string ssql = "";
string sql_insert = "";
string sql_update = "";
string sql_delete = "";
DataTable tb = null;
if (ts.Ymc.ToLower() != "jc_hoitemdiction")
{
throw new Exception("源名称必须是jc_hoitemdiction");
}
returnSql(LocalDatabase, ts.Ymc, ts.Ylm, ts.Yzj, out sql_insert, out sql_update, out sql_delete, out tb);
string sDate = DateManager.ServerDateTimeByDBType(LocalDatabase).ToString();
using (TransactionScope scope = new TransactionScope())
{
//目标服务器的链接
RelationalDatabase MB_DB = TrasenFrame.Classes.WorkStaticFun.GetJgbmDb(Convert.ToInt32(ts.MbjgbM));
//本地服务器的链接
RelationalDatabase BD_DB = TrasenFrame.Classes.WorkStaticFun.GetJgbmDb(Convert.ToInt32(ts.Djjgbm));
#region 业务操作
//医嘱项目表
if (tb.Rows.Count == 0)
{
MB_DB.DoCommand(sql_delete);
}
for (int i = 0; i <= tb.Rows.Count - 1; i++)
{
ssql = "select * from " + ts.Ymc + " where " + ts.Ylm + "='" + ts.Yzj + "'";
DataTable tb_mb = MB_DB.GetDataTable(ssql);
if (tb_mb.Rows.Count == 0)
{
MB_DB.DoCommand("SET IDENTITY_INSERT " + ts.Ymc + " ON");
MB_DB.DoCommand(sql_insert);
MB_DB.DoCommand("SET IDENTITY_INSERT " + ts.Ymc + " OFF");
}
else
{
MB_DB.DoCommand(sql_update);
}
}
//医嘱执行科室
tb = null;
ssql = "select * from jc_hoi_dept where order_id=" + ts.Yzj + " ";
tb = BD_DB.GetDataTable(ssql);
ssql = "delete from jc_hoi_dept where order_id=" + ts.Yzj + " ";
MB_DB.DoCommand(ssql);
MB_DB.DoCommand("SET IDENTITY_INSERT jc_hoi_dept ON");
for (int i = 0; i <= tb.Rows.Count - 1; i++)
{
MB_DB.DoCommand("insert into jc_hoi_dept(id,order_id,exec_dept,default_bit) " +
"values( " + Convert.ToInt32(tb.Rows[i]["id"]) + "," + Convert.ToInt32(tb.Rows[i]["order_id"]) + "," + Convert.ToInt32(tb.Rows[i]["exec_dept"]) + "," + Convert.ToInt16(tb.Rows[i]["default_bit"]) + ")");
}
MB_DB.DoCommand("SET IDENTITY_INSERT jc_hoi_dept OFF");
//与收费项目对应
tb = null;
returnSql(BD_DB, "jc_hoi_hdi", "hoitem_id", ts.Yzj, out sql_insert, out sql_update, out sql_delete, out tb);
ssql = "delete from jc_hoi_hdi where hoitem_id=" + ts.Yzj + "";
MB_DB.DoCommand(ssql);
MB_DB.DoCommand("SET IDENTITY_INSERT jc_hoi_hdi ON");
for (int i = 0; i <= tb.Rows.Count - 1; i++)
{
MB_DB.DoCommand("insert into jc_hoi_hdi(id,hoitem_id,hditem_id,num,tc_flag,tcid) " +
"values( " + Convert.ToInt32(tb.Rows[i]["id"]) + "," + Convert.ToInt32(tb.Rows[i]["hoitem_id"]) + "," + Convert.ToInt32(tb.Rows[i]["hditem_id"]) + "," + Convert.ToDecimal(tb.Rows[i]["num"]) + ",'" + Convert.ToInt16(tb.Rows[i]["tc_flag"]) + "'," + Convert.ToInt32(tb.Rows[i]["tcid"]) + ")");
}
MB_DB.DoCommand("SET IDENTITY_INSERT jc_hoi_hdi OFF");
//同步更新检查
tb = null;
ssql = "select * from jc_jc_item where yzid=" + ts.Yzj + " ";
tb = BD_DB.GetDataTable(ssql);
ssql = "delete from jc_jc_item where yzid=" + ts.Yzj + " ";
MB_DB.DoCommand(ssql);
MB_DB.DoCommand("SET IDENTITY_INSERT jc_jc_item ON");
for (int i = 0; i <= tb.Rows.Count - 1; i++)
{
MB_DB.DoCommand("insert into jc_jc_item(id,yzid,jclxid) " +
"values( " + Convert.ToInt32(tb.Rows[i]["id"]) + "," + Convert.ToInt32(tb.Rows[i]["yzid"]) + "," + Convert.ToInt32(tb.Rows[i]["jclxid"]) + ")");
}
MB_DB.DoCommand("SET IDENTITY_INSERT jc_jc_item OFF");
//同步更新化验
tb = null;
ssql = "select * from jc_assay where yzid=" + ts.Yzj + " ";
tb = BD_DB.GetDataTable(ssql);
ssql = "delete from jc_assay where yzid=" + ts.Yzj + " ";
MB_DB.DoCommand(ssql);
MB_DB.DoCommand("SET IDENTITY_INSERT jc_assay ON");
for (int i = 0; i <= tb.Rows.Count - 1; i++)
{
MB_DB.DoCommand("insert into jc_assay(id,yzid,bbid,hylxid) " +
"values( " + Convert.ToInt32(tb.Rows[i]["id"]) + "," + Convert.ToInt32(tb.Rows[i]["yzid"]) + "," + Convert.ToInt32(tb.Rows[i]["bbid"]) + "," + Convert.ToInt32(tb.Rows[i]["hylxid"]) + ")");
}
MB_DB.DoCommand("SET IDENTITY_INSERT jc_assay OFF");
#endregion
BD_DB.DoCommand("UPDATE ts_update_log set bwcbz=1,wcsj='" + sDate + "',wcczy=" + TrasenFrame.Forms.FrmMdiMain.CurrentUser.EmployeeId + " where id='" + ts.Id + "' and bwcbz=0");
scope.Complete();
}
}
public static void update(ts_HospData_Share.ts_update_log ts, RelationalDatabase LocalDatabase)
{
string ssql = "";
string sql_insert = "";
string sql_update = "";
string sql_delete = "";
DataTable tb = null;
if (ts.Ymc.ToLower() != "yf_rksq")
{
throw new Exception("源名称必须是YF_RKSQ");
}
returnSql(LocalDatabase, ts.Ymc, ts.Ylm, ts.Yzj, out sql_insert, out sql_update, out sql_delete, out tb);
string sDate = DateManager.ServerDateTimeByDBType(LocalDatabase).ToString();
ssql = "select * from YF_RKSQMX where djid='" + ts.Yzj + "'";
DataTable tbmx = LocalDatabase.GetDataTable(ssql);
using (TransactionScope scope = new TransactionScope())
{
//目标服务器的链接
RelationalDatabase MB_DB = TrasenFrame.Classes.WorkStaticFun.GetJgbmDb(Convert.ToInt32(ts.MbjgbM));
//本地服务器的链接
RelationalDatabase BD_DB = TrasenFrame.Classes.WorkStaticFun.GetJgbmDb(Convert.ToInt32(ts.Djjgbm));
if (tb.Rows.Count == 0)
{
int ncount = MB_DB.DoCommand(sql_delete + " and shbz=0 ");
if (ncount != 1)
{
throw new Exception("不能删除该申请单,因为该单据已审核");
}
}
else
{
ssql = "select * from YF_RKSQ where id='" + ts.Yzj + "'";
DataTable tb_mb = MB_DB.GetDataTable(ssql);
if (tb_mb.Rows.Count > 0)
{
int ncount = MB_DB.DoCommand(sql_update + " and shbz=0 ");
if (ncount != 1)
{
throw new Exception("不能更新该申请单,因为该单据已审核");
}
}
else
{
MB_DB.DoCommand(sql_insert);
}
}
MB_DB.DoCommand("DELETE YF_RKSQMX WHERE DJID='" + ts.Yzj + "'");
for (int i = 0; i <= tbmx.Rows.Count - 1; i++)
{
ssql = "insert into YF_RKSQMX(id,djid,djh,deptid,cjid,ypdw,ydwbl,ypsl,pfj,lsj,pfje,lsje)values(" +
"'" + tbmx.Rows[i]["id"].ToString() + "','" + tbmx.Rows[i]["djid"].ToString() + "'," + tbmx.Rows[i]["djh"].ToString() + "," +
tbmx.Rows[i]["deptid"].ToString() + "," + tbmx.Rows[i]["cjid"].ToString() + ",'" + tbmx.Rows[i]["ypdw"].ToString() + "','" +
tbmx.Rows[i]["ydwbl"].ToString() + "','" + tbmx.Rows[i]["ypsl"].ToString() + "','" + tbmx.Rows[i]["pfj"].ToString() + "','" +
tbmx.Rows[i]["lsj"].ToString() + "','" + tbmx.Rows[i]["pfje"].ToString() + "'," + tbmx.Rows[i]["lsje"].ToString() + ")";
MB_DB.DoCommand(ssql);
}
BD_DB.DoCommand("UPDATE ts_update_log set bwcbz=1,wcsj='" + sDate + "',wcczy=" + TrasenFrame.Forms.FrmMdiMain.CurrentUser.EmployeeId + " where id='" + ts.Id + "' and bwcbz=0");
scope.Complete();
}
}
private void toolbtnSav_Click(object sender, EventArgs e)
{
Guid log_djid = Guid.Empty;
ts_HospData_Share.ts_update_log ts = new ts_HospData_Share.ts_update_log();
if (txtName.Text.Trim() == "")
{
MessageBox.Show("请输入排班分类名称", "提示");
return;
}
InstanceForm.BDatabase.BeginTransaction();
try
{
ParameterEx[] parameters3 = new ParameterEx[6];
parameters3[0].Text = "@MC";
parameters3[0].Value = txtName.Text.Trim();
parameters3[1].Text = "@BZK";
parameters3[1].Value = cbbOpen.SelectedIndex.ToString();
parameters3[2].Text = "@PXXH";
parameters3[2].Value = txtPXXH.Text.Trim();
parameters3[3].Text = "@id";
parameters3[3].Value = _id;
parameters3[4].Text = "@i";
int iii = 0;
if (mod == 0)
{
iii = 1;
}
if (mod == 1)
{
iii = 2;
}
parameters3[4].Value = iii;
parameters3[5].Text = "@newid";
parameters3[5].ParaDirection = ParameterDirection.Output;
parameters3[5].DataType = System.Data.DbType.Int32;
parameters3[5].ParaSize = 100;
InstanceForm.BDatabase.DoCommand("SP_JC_MZPB_FLSZ", parameters3, 60);
if (mod == 0)
{
//三院数据处理_____保存日志
string newid = Convertor.IsNull(parameters3[5].Value, "");
string bz = "";
bz = "保存门诊排班分类设置:" + txtName.Text.ToString().Trim();
ts.Save_log(ts_HospData_Share.czlx.jc_基础数据单表修改, bz, "JC_MZ_YSPB_KSFL", "ID", newid, InstanceForm._menuTag.Jgbm, 0, "", out log_djid, InstanceForm.BDatabase);
}
if (mod == 1)
{
//三院数据处理_____保存日志
string bz = "";
bz = "更新门诊排班分类设置:" + txtName.Text.ToString().Trim();
ts.Save_log(ts_HospData_Share.czlx.jc_基础数据单表修改, bz, "JC_MZ_YSPB_KSFL", "ID", _id.ToString(), InstanceForm._menuTag.Jgbm, 0, "", out log_djid, InstanceForm.BDatabase);
}
InstanceForm.BDatabase.CommitTransaction();
ThisStatus();
dgvflsz.Enabled = true;
Bangding();
ReadTxt();
//三院数据处理___执行同步操作
string errtext = "";
ts_HospData_Share.ts_update_type ty = new ts_HospData_Share.ts_update_type((int)ts_HospData_Share.czlx.jc_基础数据单表修改, InstanceForm.BDatabase);
if (ty.Bzx == 1 && log_djid != Guid.Empty) //只有当立即执行标志为1时才执行
{
ts.Pexec_log(log_djid, InstanceForm.BDatabase, out errtext);
if (errtext != "")
{
MessageBox.Show(errtext, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
catch (System.Exception err)
{
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);
}
}
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);
}
}
