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