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