/// <summary> /// 保存日志 /// </summary> /// <param name="czlx">操作类型</param> /// <param name="cznr">操作内容</param> /// <param name="ymc">源名称 相对于主键的表名 请正确输入表名</param> /// <param name="ylm">源名称 相对于主键的字段名</param> /// <param name="yzj">表的主键ID 所修改的记录的值</param> /// <param name="djjgbm">登记机构编码</param> /// <param name="djjgbm">目标机构编码 </param> /// <param name="mbks">目标科室 即往来科室 主要是用来验证这个科室所属的机构编码.一般不需填写,只有当有业务往来时,才填 比如转科:请填写目的科室</param> /// <param name="bz">备注</param> /// <param name="database">数据库连接</param> public void Save_log(ts_HospData_Share.czlx lx, string cznr, string ymc, string ylm, string yzj, long djjgbm, long mbjgbm, int mbks, string bz, out Guid djid, RelationalDatabase database) { ts_HospData_Share.ts_update_type ty = new ts_HospData_Share.ts_update_type((int)(lx), database); if (ty.BscBz == 0) { _czlx = (int)(lx); _czks = TrasenFrame.Forms.FrmMdiMain.CurrentDept.DeptId; _czry = TrasenFrame.Forms.FrmMdiMain.CurrentUser.EmployeeId; _cznr = cznr; _ymc = ymc; _ylm = ylm; _yzj = yzj; _djsj = DateManager.ServerDateTimeByDBType(database).ToString(); _djy = TrasenFrame.Forms.FrmMdiMain.CurrentUser.EmployeeId; _djjgbm = djjgbm; _mbjgbm = mbjgbm; _mbks = mbks; _bz = bz; Save(database, out djid); } else { djid = Guid.Empty; } }
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); } } }
/// <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("密码已经清除,请及时通知该用户修改密码"); } }
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, 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); }
private void butdel_Click(object sender, EventArgs e) { ts_HospData_Share.ts_update_log ts = new ts_HospData_Share.ts_update_log(); Guid log_djid = Guid.Empty; DataTable tb = (DataTable)dataGridView1.DataSource; if (tb.Rows.Count == 0) { return; } int nrow = dataGridView1.CurrentCell.RowIndex; if (MessageBox.Show("您确定要删除 [" + Convertor.IsNull(tb.Rows[nrow]["klxmc"], "") + "] 吗 ?", "询问窗", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.No) { return; } try { InstanceForm.BDatabase.BeginTransaction(); int id = Convert.ToInt32(Convertor.IsNull(tb.Rows[nrow]["id"], "0")); string ssql = "delete from JC_KLX where id=" + id + ""; InstanceForm.BDatabase.DoCommand(ssql); //三院数据处理 ts.Save_log(ts_HospData_Share.czlx.jc_基础数据单表修改, "删除卡类型:【" + tb.Rows[nrow]["klxmc"].ToString() + "】", "jc_klx", "klx", tb.Rows[nrow]["klx"].ToString(), InstanceForm._menuTag.Jgbm, -999, "", out log_djid, InstanceForm.BDatabase); InstanceForm.BDatabase.CommitTransaction(); dataGridView1.Rows.Remove(dataGridView1.Rows[nrow]); } catch (System.Exception err) { InstanceForm.BDatabase.RollbackTransaction(); MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } try { //三院数据处理 string msg = ""; 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) { ts.Pexec_log(log_djid, InstanceForm.BDatabase, out msg); } if (msg != "") { MessageBox.Show(msg, "", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (System.Exception err) { MessageBox.Show("发生错误" + err.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void butsave_Click(object sender, EventArgs e) { DataTable tb = (DataTable)dataGridView1.DataSource; if (tb.Rows.Count == 0) { return; } ts_HospData_Share.ts_update_log ts = new ts_HospData_Share.ts_update_log(); Guid log_djid = Guid.Empty; string[] ss = new string[tb.Rows.Count]; try { string ssql = ""; InstanceForm.BDatabase.BeginTransaction(); for (int i = 0; i <= tb.Rows.Count - 1; i++) { int id = Convert.ToInt32(Convertor.IsNull(tb.Rows[i]["id"], "0")); int klx = Convert.ToInt32(Convertor.IsNull(tb.Rows[i]["klx"], "0")); string klxmc = tb.Rows[i]["klxmc"].ToString().Trim(); int bjebz = Convert.ToInt16(Convertor.IsNull(tb.Rows[i]["bjebz"], "0")); int bqfgz = Convert.ToInt16(Convertor.IsNull(tb.Rows[i]["bqfgz"], "0")); int bqybz = Convert.ToInt16(Convertor.IsNull(tb.Rows[i]["bqybz"], "0")); int bmm = Convert.ToInt16(Convertor.IsNull(tb.Rows[i]["bmm"], "0")); string mrmm = tb.Rows[i]["mrmm"].ToString().Trim(); int kcd = Convert.ToInt32(Convertor.IsNull(tb.Rows[i]["kcd"], "0")); int xh = Convert.ToInt32(Convertor.IsNull(tb.Rows[i]["xh"], "0")); int binput = Convert.ToInt16(Convertor.IsNull(tb.Rows[i]["binput"], "0")); //Modify by Kevin 2013-04-03 //begin decimal csje = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["csje"], "0")); //初始金额 int mzzy = Convert.ToInt32(Convertor.IsNull(tb.Rows[i]["mzorzy"], "0")); //门诊住院 int isycx = Convert.ToInt32(Convertor.IsNull(tb.Rows[i]["isycx"], "0")); //是否一次性消费 //end if (klx <= 0) { throw new Exception("卡类型编码必填"); } if (klxmc == "") { throw new Exception("卡类型名称必填"); } if (kcd == 0) { throw new Exception("卡长度必填"); } if (xh == 0) { throw new Exception("卡排序序号必填"); } if (bmm == 1 && mrmm == "") { throw new Exception("启用密码验证时,默认密码必填"); } //Modify by Kevin 2013-04-03 if (mzzy < 1 && mzzy > 2) //防止维护人员乱输入数字,造成检索错误 { throw new Exception("输入的门诊住院数字有误,请重新输入"); } //Modify by Kevin 2013-04-03 csje,mzorzy,isycx if (id == 0) { ssql = "insert into JC_KLX(klx,klxmc,bjebz,bqfgz,bqybz,bmm,mrmm,kcd,xh,binput,csje,mzorzy,isycx)values(" + klx + ",'" + klxmc + "'," + bjebz + "," + bqfgz + "," + bqybz + "," + bmm + ",'" + mrmm + "'," + kcd + "," + xh + "," + binput + ",'" + csje + "'," + mzzy + "," + isycx + ")"; } else { ssql = "update JC_KLX set klx=" + klx + ",klxmc='" + klxmc + "',bjebz=" + bjebz + ",bqfgz=" + bqfgz + ",bqybz=" + bqybz + ",bmm=" + bmm + ",mrmm='" + mrmm + "',kcd=" + kcd + ",xh=" + xh + ",binput=" + binput + ",csje = '" + csje + "',mzorzy = " + mzzy + ",isycx = " + isycx + " where id=" + id + ""; } InstanceForm.BDatabase.DoCommand(ssql); //三院数据处理 ts.Save_log(ts_HospData_Share.czlx.jc_基础数据单表修改, "卡类型设置 【" + klxmc + " 】", "jc_klx", "klx", klx.ToString(), InstanceForm._menuTag.Jgbm, -999, "", out log_djid, InstanceForm.BDatabase); ss[i] = log_djid.ToString(); } InstanceForm.BDatabase.CommitTransaction(); } catch (System.Exception err) { InstanceForm.BDatabase.RollbackTransaction(); MessageBox.Show(err.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); 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_type ty = new ts_HospData_Share.ts_update_type((int)ts_HospData_Share.czlx.jc_基础数据单表修改, InstanceForm.BDatabase); if (ty.Bzx == 1) { ts.Pexec_log(new Guid(ss[i]), InstanceForm.BDatabase, out errtext); msg = msg + errtext; } } MessageBox.Show("保存成功" + msg); FillData(); } catch (System.Exception err) { MessageBox.Show("发生错误" + err.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
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(); #region 数据校验 if (txtUse.Text.Trim() == "") { MessageBox.Show("请输入用法名称", "提示"); return; } if (txtNum.Text.Trim() == "") { MessageBox.Show("请输入数量", "提示"); return; } #endregion InstanceForm.BDatabase.BeginTransaction(); try { ParameterEx[] parameters3 = new ParameterEx[6]; parameters3[0].Text = "@USE_NAME"; parameters3[0].Value = Convertor.IsNull(txtUse.Text.Trim(), ""); parameters3[1].Text = "@NUM"; parameters3[1].Value = Convert.ToInt32(this.txtNum.Text.Trim()); parameters3[2].Text = "@HSITEM_ID"; parameters3[2].Value = Convertor.IsNull(txtHsitem.Tag, ""); 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_USEAGE_FEE_MZ", parameters3, 60); if (mod == 0) { //三院数据处理_____保存日志 string newid = Convertor.IsNull(parameters3[5].Value, ""); string bz = ""; bz = "保存门诊用法附加费用:" + txtUse.Text.ToString().Trim(); ts.Save_log(ts_HospData_Share.czlx.jc_基础数据单表修改, bz, "jc_useage_fee_mz", "id", newid, InstanceForm._menuTag.Jgbm, 0, "", out log_djid, InstanceForm.BDatabase); } if (mod == 1) { //三院数据处理_____保存日志 string bz = ""; bz = "更新门诊用法附加费用:" + txtUse.Text.ToString().Trim(); 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(); ThisStatus(); dgvUseageFee.Enabled = true; Bind(); 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 dataGridView2_DoubleClick(object sender, EventArgs e) { ts_HospData_Share.ts_update_log ts = new ts_HospData_Share.ts_update_log(); Guid log_djid = Guid.Empty; try { if (this.dataGridView2.CurrentCell == null) { return; } int nrow = this.dataGridView2.CurrentCell.RowIndex; DataTable tb = (DataTable)this.dataGridView2.DataSource; if (nrow > tb.Rows.Count - 1) { return; } int deptid = Convert.ToInt32(tb.Rows[nrow]["deptid"]); int p_deptid = Convert.ToInt32(Convertor.IsNull(lblyk.Tag, "0")); string sDate = DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase).ToString(); if (p_deptid == 0) { MessageBox.Show("请选择要设置的药库"); return; } string ssql = "select * from yp_yjks_gx where deptid=" + deptid + ""; DataTable tab = InstanceForm.BDatabase.GetDataTable(ssql); if (tab.Rows.Count > 0) { MessageBox.Show("该仓库已被添加过了,不能再次添加"); return; } try { InstanceForm.BDatabase.BeginTransaction(); ssql = "select * from yp_yjks_gx where p_deptid=" + p_deptid + ""; DataTable tab2 = InstanceForm.BDatabase.GetDataTable(ssql); if (tab2.Rows.Count == 0) { ssql = "insert into yp_djh(ywlx,djh,deptid) select ywlx,0," + p_deptid + " from yk_ywlx where ywlx='005'"; InstanceForm.BDatabase.DoCommand(ssql); } ssql = "insert into yp_yjks_gx(p_deptid,deptid,djsj,djy)values(" + p_deptid + "," + deptid + ",'" + sDate + "'," + InstanceForm.BCurrentUser.EmployeeId + ")"; InstanceForm.BDatabase.DoCommand(ssql); //三院数据处理 ts.Save_log(ts_HospData_Share.czlx.yp_药品基础数据单表修改, InstanceForm.BCurrentUser.Name + "添加药库管理关系 子仓库【" + tb.Rows[nrow]["仓库名称"].ToString() + " 】", "yp_yjks_gx", "p_deptid", p_deptid.ToString(), InstanceForm._menuTag.Jgbm, -999, "", out log_djid, InstanceForm.BDatabase); InstanceForm.BDatabase.CommitTransaction(); } catch (System.Exception err) { InstanceForm.BDatabase.RollbackTransaction(); MessageBox.Show(err.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } try { //三院数据处理 string msg = ""; 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 && log_djid != Guid.Empty) { ts.Pexec_log(log_djid, InstanceForm.BDatabase, out msg); } if (msg != "") { MessageBox.Show(msg, "", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (System.Exception err) { MessageBox.Show("发生错误" + err.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error); } AddView1(); AddView2(); AddView3(p_deptid); } catch (System.Exception err) { MessageBox.Show(err.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
/// <summary> /// 2014-7-15 jianqg 增加函数,整合收费项目联动处理医嘱项目状态(收费项目停用调用本函数,处理医嘱项目停用) /// 使用前 需要实例化类,主要是,_order_id,_order_name /// </summary> /// <param name="Used"></param> /// <param name="db">数据库连接</param> /// <param name="bTransaction">是否启用事务(医嘱项目直接保存用true,收费项目联动保存用false)</param> /// <param name="jgbm">机构编码(医嘱项目直接保存用InstanceForm._menuTag.Jgbm,收费项目联动保存传入)</param> /// <returns></returns> public bool SetUseable(bool Used, RelationalDatabase db, bool bTransaction, int jgbm) { ts_HospData_Share.ts_update_log ts = new ts_HospData_Share.ts_update_log(); Guid log_djid = Guid.Empty; string bz = ""; try { //InstanceForm.BDatabase.BeginTransaction(); if (bTransaction) { db.BeginTransaction(); //2014-7-15 修改,采用参数判断处理 } string sql = "update jc_hoitemdiction set delete_bit=" + (Used ? "0" : "1") + " where order_id=" + this._order_id; //InstanceForm.BDatabase.DoCommand(sql); db.DoCommand(sql); //2014-7-15 修改,采用参数处理 //三院数据处理 bz = Used == true ? "启用医嘱项目:" + _order_name : "停用医嘱项目:" + _order_name; //ts.Save_log(ts_HospData_Share.czlx.jc_基础数据单表修改, bz, "jc_hoitemdiction", "order_id", _order_id.ToString(), InstanceForm._menuTag.Jgbm, 0, "", out log_djid, InstanceForm.BDatabase); ts.Save_log(ts_HospData_Share.czlx.jc_基础数据单表修改, bz, "jc_hoitemdiction", "order_id", _order_id.ToString(), jgbm, 0, "", out log_djid, db);//2014-7-15 修改,采用参数处理 //InstanceForm.BDatabase.CommitTransaction(); if (bTransaction) { db.CommitTransaction(); //2014-7-15 修改,采用参数判断处理 } //三院数据处理 try { string errtext = ""; //ts_HospData_Share.ts_update_type ty = new ts_HospData_Share.ts_update_type((int)ts_HospData_Share.czlx.jc_基础数据单表修改, InstanceForm.BDatabase); ts_HospData_Share.ts_update_type ty = new ts_HospData_Share.ts_update_type((int)ts_HospData_Share.czlx.jc_基础数据单表修改, db);//2014-7-15 修改,采用参数处理 if (ty.Bzx == 1) { //ts.Pexec_log(log_djid, InstanceForm.BDatabase, out errtext); ts.Pexec_log(log_djid, db, out errtext);//2014-7-15 修改,采用参数处理 } if (errtext != "") { throw new Exception(errtext); } } catch (System.Exception err) { MessageBox.Show(bz + "成功 ." + err.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception err) { //InstanceForm.BDatabase.RollbackTransaction(); if (bTransaction) { db.RollbackTransaction(); //2014-7-15 修改,采用参数判断处理 } throw new Exception("Set医嘱项目Useable/" + err.Message); } return(true); }
private void butdel_Click(object sender, System.EventArgs e) { try { DataTable tb = (DataTable)this.myDataGrid1.DataSource; int nrow = this.myDataGrid1.CurrentCell.RowNumber; if (nrow > tb.Rows.Count - 1) { return; } int dyksid = Convert.ToInt32(Convertor.IsNull(tb.Rows[nrow]["dyksid"], "0")); long id = 0; string ssql = "select * from yp_lyks where dyksid=" + dyksid + " and deptid=" + Convert.ToInt32(cmbyjks.SelectedValue) + ""; DataTable tbdel = InstanceForm.BDatabase.GetDataTable(ssql); if (tbdel.Rows.Count > 0) { id = Convert.ToInt64(tbdel.Rows[0]["id"]); } Guid log_djid = Guid.Empty; try { InstanceForm.BDatabase.BeginTransaction(); ssql = "delete from yp_lyks where dyksid=" + dyksid + " and deptid=" + Convert.ToInt32(cmbyjks.SelectedValue) + ""; InstanceForm.BDatabase.DoCommand(ssql); //三院数据处理_____保存日志 if (id > 0) { string bz = "删除" + cmbyjks.Text + "的所有往来科室 [" + Convertor.IsNull(tb.Rows[nrow]["科室名称"], "0") + "]"; ts_HospData_Share.ts_update_log ts = new ts_HospData_Share.ts_update_log(); ts.Save_log(ts_HospData_Share.czlx.yp_药品基础数据单表修改, bz, "yp_lyks", "id", id.ToString(), InstanceForm._menuTag.Jgbm, 0, "", out log_djid, InstanceForm.BDatabase); } InstanceForm.BDatabase.CommitTransaction(); } catch (System.Exception err) { InstanceForm.BDatabase.RollbackTransaction(); MessageBox.Show("发生错误" + err.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } //三院数据处理___执行同步操作 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) //只有当立即执行标志为1时才执行 { tss.Pexec_log(log_djid, InstanceForm.BDatabase, out errtext); } MessageBox.Show("删除成功" + errtext); DataRow row = tb.Rows[nrow]; tb.Rows.Remove(row); } catch (System.Exception err) { MessageBox.Show("发生错误" + err.Message); } }
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; } }
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 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 (txtDept.Text.Trim() == "") { MessageBox.Show("请输入科室名称", "提示"); return; } if (txtType.Text.Trim() == "") { MessageBox.Show("请输入分类名称", "提示"); return; } InstanceForm.BDatabase.BeginTransaction(); try { string sql = "select * from JC_MZ_YSPB_KSFLMX where KSID='" + txtDept.Tag.ToString() + "' and FLID='" + txtType.Tag.ToString() + "'"; DataTable dt = InstanceForm.BDatabase.GetDataTable(sql); if (dt.Rows.Count > 0) { MessageBox.Show("【" + txtType.Text.Trim() + "】" + "已存在名称为" + "【" + txtDept.Text.Trim() + "】的科室", "提示"); return; } 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(); if (cfg3035.Config == "0") { parameters3[4].Text = "@ZJID_QC"; parameters3[4].Value = 0; } else { parameters3[4].Text = "@ZJID_QC"; parameters3[4].Value = txtDept.Tag.ToString(); } parameters3[5].Text = "@i"; int iii = 0; if (mod == 0) { iii = 1; } if (mod == 1) { iii = 2; } parameters3[5].Value = iii; 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); if (mod == 0) { //三院数据处理_____保存日志 string newid = Convertor.IsNull(parameters3[5].Value, ""); string bz = ""; bz = "保存门诊排班科室分类设置:" + txtDept.Text.ToString().Trim(); ts.Save_log(ts_HospData_Share.czlx.jc_基础数据单表修改, bz, "JC_MZ_YSPB_KSFLMX", "ID", newid, InstanceForm._menuTag.Jgbm, 0, "", out log_djid, InstanceForm.BDatabase); } if (mod == 1) { //三院数据处理_____保存日志 string bz = ""; bz = "更新门诊排班科室分类设置:" + txtDept.Text.ToString().Trim(); 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(); ThisStatus(); this.dgvkssz.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 dataGridView3_DoubleClick(object sender, EventArgs e) { ts_HospData_Share.ts_update_log ts = new ts_HospData_Share.ts_update_log(); Guid log_djid = Guid.Empty; try { if (this.dataGridView3.CurrentCell == null) { return; } int nrow = this.dataGridView3.CurrentCell.RowIndex; DataTable tb = (DataTable)this.dataGridView3.DataSource; if (nrow > tb.Rows.Count - 1) { return; } int deptid = Convert.ToInt32(tb.Rows[nrow]["deptid"]); int p_deptid = Convert.ToInt32(Convertor.IsNull(lblyk.Tag, "0")); if (MessageBox.Show("您确定要删除第" + Convert.ToString((nrow + 1)) + "行吗 ?", "询问窗", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.No) { return; } InstanceForm.BDatabase.BeginTransaction(); string ssql = "delete from yp_yjks_gx where deptid=" + deptid + ""; InstanceForm.BDatabase.DoCommand(ssql); ssql = "select * from yp_yjks_gx where p_deptid=" + p_deptid + ""; DataTable tab = InstanceForm.BDatabase.GetDataTable(ssql); if (tab.Rows.Count == 0) { ssql = "delete yp_djh where deptid=" + p_deptid + ""; InstanceForm.BDatabase.DoCommand(ssql); } //三院数据处理 ts.Save_log(ts_HospData_Share.czlx.yp_药品基础数据单表修改, InstanceForm.BCurrentUser.Name + "删除药库管理关系 子仓库【" + tb.Rows[nrow]["仓库名称"].ToString() + " 】", "yp_yjks_gx", "p_deptid", p_deptid.ToString(), InstanceForm._menuTag.Jgbm, -999, "", out log_djid, InstanceForm.BDatabase); InstanceForm.BDatabase.CommitTransaction(); AddView1(); AddView2(); AddView3(p_deptid); } catch (System.Exception err) { InstanceForm.BDatabase.RollbackTransaction(); MessageBox.Show(err.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } try { //三院数据处理 string msg = ""; 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 && log_djid != Guid.Empty) { ts.Pexec_log(log_djid, InstanceForm.BDatabase, out msg); } if (msg != "") { MessageBox.Show(msg, "", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (System.Exception err) { MessageBox.Show("发生错误" + err.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnOk_Click(object sender, System.EventArgs e) { if (cmbCode.Text.Trim() == "") { MessageBox.Show("用户名不能为空!", "", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } //定义多院操作日志 Modify By Tany 2010-01-25 ts_HospData_Share.ts_update_log ts = new ts_HospData_Share.ts_update_log(); Guid log_djid = Guid.Empty; try { string sql = ""; db.BeginTransaction(); int userId = 0; if (UserExists() && cmbCode.SelectedValue != null && Convert.ToInt32(cmbCode.SelectedValue) != -1) { //更新用户 sql = "update pub_user set locked_bit = " + (this.chkLock.Checked ? "1" : "0") + " where id=" + cmbCode.SelectedValue.ToString();//employee_id=" + employee.EmployeeId; db.DoCommand(sql); userId = Convert.ToInt32(this.cmbCode.SelectedValue); } else { //添加用户 sql = "insert into pub_user (employee_id,code,password) values (" + employee.EmployeeId + ",'" + cmbCode.Text.Trim() + "','')"; object obj; db.InsertRecord(sql, out obj); userId = Convert.ToInt32(obj); } //分配组 sql = "delete from pub_group_user where user_id =" + userId; db.DoCommand(sql); for (int i = 0; i < this.cklstGroup.Items.Count; i++) { if (this.cklstGroup.GetItemChecked(i)) { int groupId = Convert.ToInt32(((TrasenFrame.Classes.CheckListBoxItem)cklstGroup.Items[i]).ItemId.ToString()); sql = "insert into pub_group_user (group_id,user_id,delete_bit) values (" + groupId + "," + userId + ",0)"; db.DoCommand(sql); } } //处理多院数据处理,首先插入操作日志 Modify By Tany 2010-01-25 string cznr = "修改用户信息:【" + txtName.Text.Trim() + "】"; ts.Save_log(ts_HospData_Share.czlx.jc_用户修改, cznr, "pub_user", "id", userId.ToString(), jgbm, -999, "", out log_djid, db); db.CommitTransaction(); try { //查看该类型操作是否属于立即执行 Modify By Tany 2010-01-25 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-25 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); } MessageBox.Show("保存成功!"); this.DialogResult = DialogResult.OK; this.Close(); } catch (Exception err) { db.RollbackTransaction(); MessageBox.Show(err.Message); } //} }
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 + 1]; try { this.butsave.Enabled = false; InstanceForm.BDatabase.BeginTransaction(); string ssql = ""; int deptid = Convert.ToInt32(cmbyjks.SelectedValue); ssql = "delete from yp_gllx where deptid=" + deptid + ""; InstanceForm.BDatabase.DoCommand(ssql); //三院数据处理 ts.Save_log(ts_HospData_Share.czlx.yp_药品基础数据单表修改, InstanceForm.BCurrentUser.Name + "删除 【" + cmbyjks.Text + " 】所对应的药品管理类型", "yp_gllx", "deptid", deptid.ToString(), InstanceForm._menuTag.Jgbm, 0, "", out log_djid, InstanceForm.BDatabase); ss[0] = log_djid.ToString(); for (int i = 0; i <= tb.Rows.Count - 1; i++) { int yplx = Convert.ToInt32(Convertor.IsNull(tb.Rows[i]["yplxid"], "0")); int ypzlx = Convert.ToInt32(Convertor.IsNull(tb.Rows[i]["ypzlxid"], "0")); int glqx = Convert.ToInt32(Convertor.IsNull(tb.Rows[i]["管理权限"], "0")); if (glqx == 1) { ssql = "insert into yp_gllx(yplx,ypzlx,deptid)values(" + yplx + "," + ypzlx + "," + deptid + ") "; 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 + "为 【" + cmbyjks + " 】添加【" + Convertor.IsNull(tb.Rows[i]["药品类型"], "0") + "】 管理类型", "yp_gllx", "id", newid.ToString(), InstanceForm._menuTag.Jgbm, 0, "", out log_djid, InstanceForm.BDatabase); ss[i + 1] = log_djid.ToString(); } } InstanceForm.BDatabase.CommitTransaction(); } 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 && ss[i] != "") { tss.Pexec_log(new Guid(ss[i]), InstanceForm.BDatabase, out errtext); msg = msg + errtext; } } MessageBox.Show("保存成功"); this.butsave.Enabled = true; this.AddData(Convert.ToInt32(cmbyjks.SelectedValue)); } catch (System.Exception err) { MessageBox.Show("发生错误" + err.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void butsave_Click(object sender, System.EventArgs e) { try { this.butsave.Enabled = false; InstanceForm.BDatabase.BeginTransaction(); string ssql = ""; string code = ""; int dyksid = 0; int deptid = Convert.ToInt32(cmbyjks.SelectedValue); DataTable tb = (DataTable)this.myDataGrid1.DataSource; ssql = "delete from yp_lyks where deptid=" + deptid + ""; InstanceForm.BDatabase.DoCommand(ssql); string[] ss = new string[tb.Rows.Count + 1]; //三院数据处理_____保存日志 string bz = "删除" + cmbyjks.Text + "的所有往来科室 "; 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_lyks", "deptid", deptid.ToString(), InstanceForm._menuTag.Jgbm, 0, "", out log_djid, InstanceForm.BDatabase); ss[0] = log_djid.ToString(); for (int i = 0; i <= tb.Rows.Count - 1; i++) { dyksid = Convert.ToInt32(Convertor.IsNull(tb.Rows[i]["dyksid"], "0")); code = tb.Rows[i]["code"].ToString().Trim(); if (code.Trim() == "") { throw new Exception("请为" + tb.Rows[i]["科室名称"].ToString().Trim() + "选择科室类别"); } ssql = "insert into yp_lyks(dyksid,code,deptid) values(" + dyksid + ",'" + code + "'," + deptid + ")"; InstanceForm.BDatabase.DoCommand(ssql); long id = Convert.ToInt64(InstanceForm.BDatabase.GetDataTable("select @@IDENTITY").Rows[0][0]); //三院数据处理_____保存日志 log_djid = Guid.Empty; bz = "添加" + cmbyjks.Text + "的往来科室 ['" + tb.Rows[i]["科室名称"].ToString().Trim() + "'] "; ts.Save_log(ts_HospData_Share.czlx.yp_药品基础数据单表修改, bz, "yp_lyks", "id", id.ToString(), InstanceForm._menuTag.Jgbm, 0, "", out log_djid, InstanceForm.BDatabase); ss[i + 1] = log_djid.ToString(); } InstanceForm.BDatabase.CommitTransaction(); //三院数据处理___执行同步操作 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 && ss[i] != "") //只有当立即执行标志为1时才执行 { ts.Pexec_log(new Guid(ss[i]), InstanceForm.BDatabase, out errtext); } msg = msg + errtext; } MessageBox.Show("保存成功" + msg); this.butsave.Enabled = true; } catch (System.Exception err) { this.butsave.Enabled = true; InstanceForm.BDatabase.RollbackTransaction(); MessageBox.Show("发生错误" + err.Message); return; } }
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; } if (MessageBox.Show("您确定要删除" + tb.Rows[nrow]["名称"].ToString() + "这个厂家吗 ?", "询问窗", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) != DialogResult.Yes) { return; } string ssql = "select * from yp_ypcjd where sccj=" + Convert.ToInt32(Convertor.IsNull(tb.Rows[nrow]["id"], "0")) + ""; DataTable myTb = InstanceForm.BDatabase.GetDataTable(ssql); if (myTb.Rows.Count != 0) { MessageBox.Show("这个厂家在药典中已经使用了,不能删除它"); return; } long ID = Convert.ToInt32(Convertor.IsNull(tb.Rows[nrow]["id"], "0")); InstanceForm.BDatabase.BeginTransaction(); ssql = "delete from yp_sccj 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_sccj", "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; } }
/// <summary> /// 保存 /// </summary> /// <returns></returns> public bool Save(OP_TYPE OpType) { ts_HospData_Share.ts_update_log ts = new ts_HospData_Share.ts_update_log(); Guid log_djid = Guid.Empty; try { string sql = ""; InstanceForm.BDatabase.BeginTransaction(); if (OpType == OP_TYPE.新增项目) { //插入新纪录 sql = "insert into jc_hoitemdiction ( order_name,order_unit,order_type,default_usage,default_dept,py_code,wb_code,bz,FJSMBT,d_code)"; sql += " values ('" + _order_name + "','" + _order_unit + "'," + _order_type_id + ",'" + _usage + "'," + _default_exec_dept + ",'" + _py_code + "','" + _wb_code + "','" + bz + "'," + _fjsmbt.ToString() + ",'" + _d_code + "')"; object obj; InstanceForm.BDatabase.InsertRecord(sql, out obj); _order_id = Convert.ToInt32(obj); } if (OpType == OP_TYPE.更新项目) { sql = "update jc_hoitemdiction set order_name='" + _order_name + "',order_unit='" + _order_unit + "',order_type=" + _order_type_id + ",default_usage='" + _usage + "',default_dept=" + _default_exec_dept + ",py_code='" + _py_code + "',wb_code='" + _wb_code + "',bz='" + bz + "',FJSMBT=" + _fjsmbt.ToString() + ",d_code='" + _d_code + "'"; sql += " where order_id=" + _order_id; InstanceForm.BDatabase.DoCommand(sql); } //执行科室 sql = "delete from jc_hoi_dept where order_id = " + _order_id; InstanceForm.BDatabase.DoCommand(sql); for (int i = 0; i < _execdeptList.Count; i++) { sql = "insert into jc_hoi_dept ( order_id,exec_dept ) values (" + _order_id + "," + ((TrasenFrame.Classes.Department)_execdeptList[i]).DeptId + ")"; InstanceForm.BDatabase.DoCommand(sql); } //与收费项目对应 sql = "delete from jc_hoi_hdi where hoitem_id=" + _order_id; InstanceForm.BDatabase.DoCommand(sql); if (_match_type == 1) { if (_charge_item_id != 0) { sql = "insert into jc_hoi_hdi ( hoitem_id,hditem_id,num,tc_flag,tcid ) values (" + _order_id + "," + _charge_item_id + "," + _item_exec_num + ",1," + _charge_item_id + ")"; InstanceForm.BDatabase.DoCommand(sql); } } else { if (_charge_item_id != 0) { sql = "insert into jc_hoi_hdi ( hoitem_id,hditem_id,num,tc_flag,tcid ) values (" + _order_id + "," + _charge_item_id + "," + _item_exec_num + ",0,-1)"; InstanceForm.BDatabase.DoCommand(sql); } } //同步更新检查化验表 sql = "delete from jc_jc_item where yzid=" + _order_id; InstanceForm.BDatabase.DoCommand(sql); sql = "delete from jc_assay where yzid=" + _order_id; InstanceForm.BDatabase.DoCommand(sql); if (this.isJCorHy == 1) { sql = "insert into jc_jc_item(yzid,jclxid) values (" + _order_id + "," + jclx + ")"; InstanceForm.BDatabase.DoCommand(sql); } else if (this.isJCorHy == 2) { sql = "insert into jc_assay(yzid,bbid,hylxid) values (" + _order_id + "," + sample + ", " + hylx + ")"; InstanceForm.BDatabase.DoCommand(sql); } string _bz = ""; if (OpType == OP_TYPE.新增项目) { _bz = "新增医嘱项目:【" + _order_name + "】"; } else { _bz = "修改医嘱项目:【" + _order_name + "】"; } ts.Save_log(ts_HospData_Share.czlx.jc_医嘱项目修改, _bz, "jc_hoitemdiction", "order_id", _order_id.ToString(), InstanceForm._menuTag.Jgbm, 0, "", out log_djid, InstanceForm.BDatabase); InstanceForm.BDatabase.CommitTransaction(); } catch (Exception err) { InstanceForm.BDatabase.RollbackTransaction(); throw err; } //三院数据处理 try { 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) { ts.Pexec_log(log_djid, InstanceForm.BDatabase, out errtext); } if (errtext != "") { throw new Exception(errtext); } } catch (System.Exception err) { MessageBox.Show("保存成功 " + err.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(true); }
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 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]; this.Cursor = PubStaticFun.WaitCursor(); string ssql = ""; long fid = 0; string flbh = ""; string flmc = ""; int pxid = 0; string flms = ""; int bdelete = 0; string pym = ""; string wbm = ""; string hwbh = ""; string yhwbh = ""; try { if (this.treeView1.SelectedNode == null) { MessageBox.Show("请选择节点", "", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } bool bmodif = false; for (int i = 0; i <= tb.Rows.Count - 1; i++) { hwbh = tb.Rows[i]["货位编号"].ToString().Trim(); yhwbh = tb.Rows[i]["原货位编号"].ToString().Trim(); if (hwbh != yhwbh && Convert.ToInt32(Convertor.IsNull(tb.Rows[i]["id"], "0")) > 0) { bmodif = true; } } if (bmodif == true) { if (MessageBox.Show("您对货位编号进行了修改,此修改将影响所有该分类药品的货号,您确定吗 ?", "询问窗", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.No) { return; } } this.butsave.Enabled = false; InstanceForm.BDatabase.BeginTransaction(); for (int i = 0; i <= tb.Rows.Count - 1; i++) { int ID = Convert.ToInt32(Convertor.IsNull(tb.Rows[i]["id"], "0")); fid = Convert.ToInt64(Convertor.IsNull(tb.Rows[i]["fid"], "0")); hwbh = tb.Rows[i]["货位编号"].ToString().Trim(); yhwbh = tb.Rows[i]["原货位编号"].ToString().Trim(); flbh = tb.Rows[i]["编号"].ToString().Trim(); flmc = tb.Rows[i]["名称"].ToString().Trim(); flms = tb.Rows[i]["描述"].ToString().Trim(); bdelete = Convert.ToInt32(Convertor.IsNull(tb.Rows[i]["禁用"], "0")); pym = tb.Rows[i]["拼音码"].ToString().Trim(); wbm = tb.Rows[i]["五笔码"].ToString().Trim(); if (flmc.Trim() != "") { if (ID == 0) { ssql = "insert into yp_ylfl(fid,flbh,flmc,flms,bdelete,pym,wbm,yjdbz,hwbh) values(" + fid + ",'" + flbh + "','" + flmc + "'" + ",'" + flms + "'," + bdelete + ",'" + pym + "','" + wbm + "',1,'" + hwbh + "') "; } else { ssql = "update yp_ylfl set fid=" + fid + ",flbh='" + flbh + "',flmc='" + flmc + "',flms='" + flms + "',bdelete=" + bdelete + ",pym='" + pym + "',wbm='" + wbm + "',hwbh='" + hwbh + "' where id=" + ID + " "; //如果更改了货位编码,则重新生成药品货位号 int _errcode = 0; string _errtext = ""; if (hwbh.Trim() != yhwbh.Trim()) { string ssql1 = "select ggid from yp_ypggd where ylfl=" + ID + ""; DataTable tab = InstanceForm.BDatabase.GetDataTable(ssql1); Ypcj cj = new Ypcj(); for (int j = 0; j <= tab.Rows.Count - 1; j++) { cj.Update_shh(Convert.ToInt32(tab.Rows[j]["ggid"]), out _errcode, out _errtext, InstanceForm.BDatabase); if (_errcode != 0) { throw new Exception("重新生成药品货位编号时发生错误"); } } } } //三院数据处理 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 + "添加药理分类 【" + flmc + " 】", "yp_ylfl", "id", newid.ToString(), InstanceForm._menuTag.Jgbm, 0, "", out log_djid, InstanceForm.BDatabase); ss[i] = log_djid.ToString(); } else { string _ssql = "select * from yp_ylfl where id=" + ID + " and flmc='" + flmc + "' and pym='" + pym + "'"; DataTable tb_x = InstanceForm.BDatabase.GetDataTable(_ssql); if (tb_x.Rows.Count == 0) { ts.Save_log(ts_HospData_Share.czlx.yp_药品基础数据单表修改, InstanceForm.BCurrentUser.Name + "修改药理分类 【" + flmc + " 】", "yp_ylfl", "id", ID.ToString(), InstanceForm._menuTag.Jgbm, 0, "", out log_djid, InstanceForm.BDatabase); ss[i] = log_djid.ToString(); } InstanceForm.BDatabase.DoCommand(ssql); } ssql = "update yp_ylfl set yjdbz=0 where id=" + fid + ""; InstanceForm.BDatabase.DoCommand(ssql); } } InstanceForm.BDatabase.CommitTransaction(); } catch (System.Exception err) { this.butsave.Enabled = true; InstanceForm.BDatabase.RollbackTransaction(); MessageBox.Show("发生错误" + err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); 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; } } AddTreeViewNode(this.treeView1.SelectedNode); this.treeView1.SelectedNode.Expand(); string sss = ""; sss = "select 0 序号,hwbh 货位编号,hwbh 原货位编号,flbh 编号,flmc 名称,pym 拼音码,wbm 五笔码,flms 描述,dbo.fun_yp_ylfl(fid) 所属上级编目,cast(bdelete as smallint) 禁用,fid,id,yjdbz from yp_ylfl where fid=" + fid + " order by fid "; tb = InstanceForm.BDatabase.GetDataTable(sss); tb.TableName = "Tb"; this.myDataGrid1.DataSource = tb; this.myDataGrid1.TableStyles[0].MappingName = "Tb"; // this.myDataGrid1.CaptionText="当前节点:"+e.Node.Text.Trim();; FunBase.AddRowtNo(tb); MessageBox.Show("保存成功" + msg); this.butsave.Enabled = true; } catch (System.Exception err) { MessageBox.Show("发生错误" + err.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { this.Cursor = Cursors.Arrow; } }
private void butok_hb_Click(object sender, System.EventArgs e) { DataTable tb = (DataTable)this.myDataGrid1.DataSource; DataTable tab = (DataTable)this.myDataGrid2.DataSource; int nrow1 = this.myDataGrid1.CurrentCell.RowNumber; int nrow2 = this.myDataGrid2.CurrentCell.RowNumber; if (nrow1 > tb.Rows.Count - 1) { return; } if (nrow2 > tab.Rows.Count - 1) { return; } if (MessageBox.Show("您确定要将上面的厂家替换成下面的规格吗 ?", "询问窗", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.No) { return; } //要替换成的规格ID int _gg_ggid = Convert.ToInt32(tab.Rows[nrow2]["ggid"]); try { Ypgg gg = new Ypgg(_gg_ggid, InstanceForm.BDatabase); if (gg.GGID == 0) { MessageBox.Show("该规格可能已经不存在了"); return; } InstanceForm.BDatabase.BeginTransaction(); //要被替换的厂家ID int _cj_cjid = Convert.ToInt32(tb.Rows[nrow1]["CJID"]); //厂家 string ssql = "update yp_ypcjd set ggid=" + _gg_ggid + ",s_ypspm='" + gg.YPSPM + "',s_yppm='" + gg.YPPM + "',s_ypspmbz='" + gg.YPSPMBZ + "',s_ypgg='" + gg.YPGG + "',s_ypdw='" + Yp.SeekYpdw(gg.YPDW, InstanceForm.BDatabase) + "' where cjid=" + _cj_cjid + " "; InstanceForm.BDatabase.DoCommand(ssql); //药房库存 ssql = "update yf_kcmx set ggid=" + _gg_ggid + " where cjid=" + _cj_cjid + " "; InstanceForm.BDatabase.DoCommand(ssql); //药房批号 ssql = "update yf_kcph set ggid=" + _gg_ggid + " where cjid=" + _cj_cjid + " "; InstanceForm.BDatabase.DoCommand(ssql); //药库库存 ssql = "update yk_kcmx set ggid=" + _gg_ggid + " where cjid=" + _cj_cjid + " "; InstanceForm.BDatabase.DoCommand(ssql); //药库批号 ssql = "update yk_kcph set ggid=" + _gg_ggid + " where cjid=" + _cj_cjid + " "; InstanceForm.BDatabase.DoCommand(ssql); //药房盘点表 ssql = "update yf_pdtemp set ggid=" + _gg_ggid + " where cjid=" + _cj_cjid + " "; InstanceForm.BDatabase.DoCommand(ssql); //药库盘点表 ssql = "update yk_kcph set ggid=" + _gg_ggid + " where cjid=" + _cj_cjid + " "; InstanceForm.BDatabase.DoCommand(ssql); //药品拆零表 ssql = "update yp_ypcl set ggid=" + _gg_ggid + " where cjid=" + _cj_cjid + " "; InstanceForm.BDatabase.DoCommand(ssql); //更新药品货号 Ypcj ypcj = new Ypcj(); int _errcode = 0; string _errtext = ""; ypcj.Update_shh(_gg_ggid, out _errcode, out _errtext, InstanceForm.BDatabase); if (_errcode != 0) { throw new Exception(_errtext); } //三院数据处理_____保存日志 Ypcj cj = new Ypcj(_cj_cjid, InstanceForm.BDatabase); string bz = "取消药品合并:" + cj.S_YPPM + " CJID=" + cj.CJID + " "; Guid log_djid = Guid.Empty; ts_HospData_Share.ts_update_log ts = new ts_HospData_Share.ts_update_log(); ts.Save_log(ts_HospData_Share.czlx.yp_药品取消合并, bz, "YP_YPCJD", "CJID", _cj_cjid.ToString(), InstanceForm._menuTag.Jgbm, 0, "", out log_djid, InstanceForm.BDatabase); InstanceForm.BDatabase.CommitTransaction(); //三院数据处理___执行同步操作 string errtext = ""; ts_HospData_Share.ts_update_type ty = new ts_HospData_Share.ts_update_type((int)ts_HospData_Share.czlx.yp_药品取消合并, InstanceForm.BDatabase); if (ty.Bzx == 1) //只有当立即执行标志为1时才执行 { ts.Pexec_log(log_djid, InstanceForm.BDatabase, out errtext); } if (errtext != "") { MessageBox.Show("取消药品合并成功 " + errtext, "取消合并", MessageBoxButtons.OK, MessageBoxIcon.Error); } this.Close(); } catch (System.Exception err) { UpdateRows = null; InstanceForm.BDatabase.RollbackTransaction(); MessageBox.Show(err.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void ResumeEmployee() { ts_HospData_Share.ts_update_log ts = new ts_HospData_Share.ts_update_log(); Guid log_djid = Guid.Empty; if (this.lvwEmployee.SelectedItems.Count == 0) { return; } if (MessageBox.Show("确定要恢复该数据吗?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { DataRow dr = InstanceForm.BDatabase.GetDataRow("select * from jc_employee_property where name='" + lvwEmployee.SelectedItems[0].Text + "' and delete_bit=0"); if (dr != null) { if (MessageBox.Show("已经有相同的名称存在,是否继续操作?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) { return; } } try { InstanceForm.BDatabase.BeginTransaction(); string sql = "update jc_employee_property set delete_bit=0 where employee_id=" + lvwEmployee.SelectedItems[0].Tag.ToString(); InstanceForm.BDatabase.DoCommand(sql); //三院数据处理 string bz = "恢复停用人员:【" + lvwEmployee.SelectedItems[0].Text + "】"; ts.Save_log(ts_HospData_Share.czlx.jc_人员修改, bz, "jc_employee_property", "employee_id", lvwEmployee.SelectedItems[0].Tag.ToString(), InstanceForm._menuTag.Jgbm, 0, "", out log_djid, InstanceForm.BDatabase); InstanceForm.BDatabase.CommitTransaction(); } catch (System.Exception err) { InstanceForm.BDatabase.RollbackTransaction(); throw err; } lvwEmployee.Items.Remove(lvwEmployee.SelectedItems[0]); //三院数据处理 try { 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.jc_人员修改, InstanceForm.BDatabase); if (ty.Bzx == 1 && log_djid != Guid.Empty) { tss.Pexec_log(log_djid, InstanceForm.BDatabase, out errtext); } if (errtext != "") { throw new Exception(errtext); } } 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(); DataTable tb = (DataTable)this.myDataGrid1.DataSource; try { int nrow = this.myDataGrid1.CurrentCell.RowNumber; if (nrow > tb.Rows.Count - 1) { return; } int ID = Convert.ToInt32(Convertor.IsNull(tb.Rows[nrow]["id"], "-1")); int FID = Convert.ToInt32(Convertor.IsNull(tb.Rows[nrow]["Fid"], "0")); if (MessageBox.Show("您确定要删除" + tb.Rows[nrow]["名称"].ToString() + "这个分类吗 ?", "询问窗", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) != DialogResult.Yes) { return; } //看是否有子节点 string ssql = "select * from yp_ylfl where fid=" + ID + ""; DataTable tab = InstanceForm.BDatabase.GetDataTable(ssql); if (tab.Rows.Count > 0) { MessageBox.Show("对不起,当前节点还有子节点,请先删除子节点", "删除", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } //看是否使用 ssql = "select * from yp_ypggd where ylfl=" + ID + ""; DataTable tab1 = InstanceForm.BDatabase.GetDataTable(ssql); if (tab1.Rows.Count > 0) { MessageBox.Show("对不起,这个分类在药品词典中已经使用了,不能删除"); return; } InstanceForm.BDatabase.BeginTransaction(); //删除 ssql = "delete from yp_ylfl where id=" + ID + ""; InstanceForm.BDatabase.DoCommand(ssql); //更新叶节点标记 if (FID > 0) { ssql = "select * from yp_ylfl where fid=" + FID + ""; DataTable ftab = InstanceForm.BDatabase.GetDataTable(ssql); if (ftab.Rows.Count == 0) { ssql = "update yp_ylfl set yjdbz=1 where id=" + FID + ""; InstanceForm.BDatabase.DoCommand(ssql); } } //三院数据处理_____保存日志 if (ID > 0) { string bz = "删除药理分类 【" + tb.Rows[nrow]["名称"].ToString() + "】 "; ts.Save_log(ts_HospData_Share.czlx.yp_药品基础数据单表修改, bz, "yp_ylfl", "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); AddTreeViewNode(this.treeView1.SelectedNode); this.treeView1.SelectedNode.Expand(); FunBase.AddRowtNo(tb); } catch (System.Exception err) { MessageBox.Show("发生错误" + err.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } }
private void btnChangeCode_Click(object sender, System.EventArgs e) { string newCode = ""; string sql = ""; newCode = DlgInputBoxStatic.InputBox("请输入新的用户名", "修改用户名", this.cmbCode.Text); if (DlgInputBoxStatic.dlgResult == DialogResult.Cancel) { return; } sql = "select * from pub_user where upper(code)='" + newCode.Trim().ToUpper() + "' and id <>" + this.cmbCode.SelectedValue.ToString(); DataRow dr = db.GetDataRow(sql); while (dr != null) { object obj = db.GetDataResult("select name from jc_employee_property where employee_id in (select employee_id from pub_user where code='" + newCode + "')"); newCode = DlgInputBoxStatic.InputBox("输入的用户名[ " + newCode + " ]已经存在,使用者[" + obj.ToString() + "],请重新输入", "修改用户名", this.cmbCode.Text); if (DlgInputBoxStatic.dlgResult == DialogResult.Cancel) { return; } sql = "select * from pub_user where upper(code)='" + newCode.Trim().ToUpper() + "' and id <>" + this.cmbCode.SelectedValue.ToString(); dr = db.GetDataRow(sql); } //定义多院操作日志 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 { //更新用户 sql = "update pub_user set code ='" + newCode.Trim() + "' where id=" + cmbCode.SelectedValue.ToString(); 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-24 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-24 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); } MessageBox.Show("用户名修改成功!"); ShowUserInfo(); }
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); } }
/// <summary> /// 更新菜单信息 /// </summary> private bool UpdateMenuInfo() { try { //jianqg emr-his 整合暂时注释 本函数 需要修改几处 //增加参数CanUsePublicPwd jianqg 2012-10-6 emr-his框架整合 增加 ParameterEx[] paras = new ParameterEx[10]; #region ... paras[0].Text = "@MenuId"; paras[0].Value = this.m_currentMenuId; paras[1].Text = "@Name"; paras[1].Value = txtMenuName.Text.Trim(); paras[2].Text = "@DllName"; paras[2].Value = this.txtDllName.Text.Trim(); paras[3].Text = "@FunctionName"; paras[3].Value = this.txtFunctionName.Text.Trim(); paras[4].Text = "@DeleteBit"; paras[4].Value = 0; paras[5].Text = "@ShowToolBar"; paras[5].Value = this.chkShowToolbar.Checked ? 1 : 0; paras[6].Text = "@FunctionTag"; paras[6].Value = this.txtFunctionTag.Text.Trim(); paras[7].Text = "@Jgbm"; paras[7].Value = this.cmbJgbm.SelectedValue; paras[8].Text = "@Errmsg"; paras[8].ParaDirection = ParameterDirection.Output; paras[8].ParaSize = 200; paras[9].Text = "@CanUsePublicPwd"; paras[9].Value = this.chk_CanUserPublicPwd.Checked ? 1 : 0; #endregion 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(); db.DoCommand("up_UpdateMenuInfo", paras, 30); if (chkIco.Checked && Convertor.IsNull(picIco.Tag, "") != "") { System.IO.FileStream fs = new System.IO.FileStream(picIco.Tag.ToString(), System.IO.FileMode.OpenOrCreate, System.IO.FileAccess.Read); byte[] byteIco = new byte[fs.Length]; fs.Read(byteIco, 0, Convert.ToInt32(fs.Length)); fs.Close(); string sql = "update pub_menu set icon=@Ico where menu_id=@menuId"; IDbCommand cmd = db.GetCommand(); cmd.CommandText = sql; cmd.CommandType = CommandType.Text; IDataParameter parameter; parameter = cmd.CreateParameter(); parameter.ParameterName = "@Ico"; parameter.Value = byteIco; cmd.Parameters.Add(parameter); parameter = cmd.CreateParameter(); parameter.ParameterName = "@menuId"; parameter.Value = m_currentMenuId; cmd.Parameters.Add(parameter); cmd.Transaction = db.GetTransaction(); cmd.ExecuteNonQuery(); } else { if (picIco.Image != null) { db.DoCommand("update pub_menu set icon=null where menu_id=" + m_currentMenuId); } } //处理多院数据处理,首先插入操作日志 Modify By Tany 2010-01-29 string cznr = "修改菜单:【" + txtMenuName.Text.Trim() + "】"; ts.Save_log(ts_HospData_Share.czlx.jc_菜单修改, cznr, "pub_menu", "menu_Id", this.m_currentMenuId.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); } return(true); } catch (Exception err) { db.RollbackTransaction(); throw err; } } catch (Exception err) { MessageBox.Show(err.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } }