private void butexec_Click(object sender, EventArgs e)
{
try
{
pb.Value = 0;
pb.Minimum = 0;
pb.Maximum = listView_log.Items.Count;
string _sDate = DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase).ToString();
if (listView_log.Items.Count > 0)
{
txtbz.Text = "开始协同操作(" + _sDate.Trim() + ")..........";
}
for (int i = 0; i <= listView_log.Items.Count - 1; i++)
{
string id = listView_log.Items[i].SubItems["id"].Text;
try
{
ts_update_log ts = new ts_update_log();
ts.exec_log(new Guid(id), InstanceForm.BDatabase);
pb.Value = pb.Value + 1;
txtbz.Text = txtbz.Text + "\n 第" + i.ToString() + "行成功!";
}
catch (System.Exception err)
{
string ss = err.Message.ToString().Replace("\n", "");
txtbz.Text = txtbz.Text + "\n 第" + i.ToString() + "行失败!" + ss;
}
}
_sDate = DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase).ToString();
if (listView_log.Items.Count > 0)
{
txtbz.Text = txtbz.Text + "\n操作完成(" + _sDate.Trim() + ")..........\n";
}
butall_Click(sender, e);
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void listView_log_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
txtbz.Text = "";
if (listView_log.SelectedIndices != null && listView_log.SelectedIndices.Count > 0)
{
ListView.SelectedIndexCollection c = listView_log.SelectedIndices;
string id = listView_log.Items[c[0]].SubItems["id"].Text;
ts_update_log ts = new ts_update_log();
DataTable tb = ts_HospData_Share.ts_update_log.Getlog_err(new Guid(id), InstanceForm.BDatabase);
for (int i = 0; i <= tb.Rows.Count - 1; i++)
{
txtbz.Text = txtbz.Text + " \n★[" + tb.Rows[i]["djsj"].ToString() + "] " + tb.Rows[i]["SBYY"].ToString().Trim() + "";
}
}
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
/// <summary>
/// 根据log的ID来执行
/// </summary>
/// <param name="id"></param>
/// <param name="database"></param>
public void exec_log(Guid id, RelationalDatabase database)
{
ts_update_log ts = null;
string czmc = "";
try
{
ts = new ts_update_log(id, database);
if (ts.Czlx == Convert.ToInt32(ts_HospData_Share.czlx.yp_药品字典修改))
{
czmc = ts_HospData_Share.czlx.yp_药品字典修改.ToString();
ts_HospData_Share.yp_cd.update(ts, database);
}
if (ts.Czlx == Convert.ToInt32(ts_HospData_Share.czlx.yp_药品合并))
{
czmc = ts_HospData_Share.czlx.yp_药品合并.ToString();
ts_HospData_Share.yp_cd.update_hb(ts, database);
}
if (ts.Czlx == Convert.ToInt32(ts_HospData_Share.czlx.yp_药品取消合并))
{
czmc = ts_HospData_Share.czlx.yp_药品取消合并.ToString();
ts_HospData_Share.yp_cd.update_qxhb(ts, database);
}
if (ts.Czlx == Convert.ToInt32(ts_HospData_Share.czlx.yp_药品调价))
{
czmc = ts_HospData_Share.czlx.yp_药品调价.ToString();
ts_HospData_Share.yp_tj.update(ts, database);
}
if (ts.Czlx == Convert.ToInt32(ts_HospData_Share.czlx.yp_药房出库单))
{
czmc = ts_HospData_Share.czlx.yp_药房出库单.ToString();
ts_HospData_Share.yp_yfck.update(ts, database);
}
if (ts.Czlx == Convert.ToInt32(ts_HospData_Share.czlx.yp_药库出库单))
{
czmc = ts_HospData_Share.czlx.yp_药库出库单.ToString();
ts_HospData_Share.yp_ykck.update(ts, database);
}
if (ts.Czlx == Convert.ToInt32(ts_HospData_Share.czlx.yp_药房申请领药单))
{
czmc = ts_HospData_Share.czlx.yp_药房申请领药单.ToString();
ts_HospData_Share.yp_lysq.update(ts, database);
}
if (ts.Czlx == Convert.ToInt32(ts_HospData_Share.czlx.yp_药房申请领药单审核))
{
czmc = ts_HospData_Share.czlx.yp_药房申请领药单审核.ToString();
ts_HospData_Share.yp_lysq.SH(ts);
}
if (ts.Czlx == Convert.ToInt32(ts_HospData_Share.czlx.yp_删除药房出库单))
{
czmc = ts_HospData_Share.czlx.yp_删除药房出库单.ToString();
ts_HospData_Share.yp_yfck.update_DeleteDj(ts, database);
}
if (ts.Czlx == Convert.ToInt32(ts_HospData_Share.czlx.yp_药品基础数据单表修改))
{
czmc = ts_HospData_Share.czlx.yp_药品基础数据单表修改.ToString();
ts_HospData_Share.yp_jc.update(ts, database);
}
if (ts.Czlx == Convert.ToInt32(ts_HospData_Share.czlx.jc_科室修改))
{
czmc = ts_HospData_Share.czlx.jc_科室修改.ToString();
ts_HospData_Share.jc_ks.update(ts, database);
}
if (ts.Czlx == Convert.ToInt32(ts_HospData_Share.czlx.jc_人员修改))
{
czmc = ts_HospData_Share.czlx.jc_人员修改.ToString();
ts_HospData_Share.jc_employ.update(ts, database);
}
if (ts.Czlx == Convert.ToInt32(ts_HospData_Share.czlx.jc_基础数据单表修改))
{
czmc = ts_HospData_Share.czlx.jc_基础数据单表修改.ToString();
ts_HospData_Share.jc_db.update(ts, database);
}
if (ts.Czlx == Convert.ToInt32(ts_HospData_Share.czlx.jc_收费项目修改))
{
czmc = ts_HospData_Share.czlx.jc_收费项目修改.ToString();
ts_HospData_Share.jc_sfxm.update(ts, database);
}
if (ts.Czlx == Convert.ToInt32(ts_HospData_Share.czlx.jc_医嘱项目修改))
{
czmc = ts_HospData_Share.czlx.jc_医嘱项目修改.ToString();
ts_HospData_Share.jc_yzxm.update(ts, database);
}
//tany
if (ts.Czlx == Convert.ToInt32(ts_HospData_Share.czlx.jc_用户修改))
{
czmc = ts_HospData_Share.czlx.jc_用户修改.ToString();
ts_HospData_Share.pub_user.update(ts, database);
}
if (ts.Czlx == Convert.ToInt32(ts_HospData_Share.czlx.jc_组菜单修改))
{
czmc = ts_HospData_Share.czlx.jc_组菜单修改.ToString();
ts_HospData_Share.pub_group.update_groupmenu(ts, database);
}
if (ts.Czlx == Convert.ToInt32(ts_HospData_Share.czlx.jc_组删除))
{
czmc = ts_HospData_Share.czlx.jc_组删除.ToString();
ts_HospData_Share.pub_group.delete_group(ts, database);
}
if (ts.Czlx == Convert.ToInt32(ts_HospData_Share.czlx.jc_菜单删除))
{
czmc = ts_HospData_Share.czlx.jc_菜单删除.ToString();
ts_HospData_Share.pub_menu.delete_menu(ts, database);
}
if (ts.Czlx == Convert.ToInt32(ts_HospData_Share.czlx.jc_菜单修改))
{
czmc = ts_HospData_Share.czlx.jc_菜单修改.ToString();
ts_HospData_Share.pub_menu.update(ts, database);
}
if (ts.Czlx == Convert.ToInt32(ts_HospData_Share.czlx.jc_系统菜单修改))
{
czmc = ts_HospData_Share.czlx.jc_系统菜单修改.ToString();
ts_HospData_Share.pub_menu.update_systemmenu(ts, database);
}
if (ts.Czlx == Convert.ToInt32(ts_HospData_Share.czlx.jc_修改升级文件))
{
czmc = ts_HospData_Share.czlx.jc_修改升级文件.ToString();
ts_HospData_Share.pub_systemupdate.update(ts, database);
}
if (ts.Czlx == Convert.ToInt32(ts_HospData_Share.czlx.jc_删除升级文件))
{
czmc = ts_HospData_Share.czlx.jc_删除升级文件.ToString();
ts_HospData_Share.pub_systemupdate.delete(ts, database);
}
if (ts.Czlx == Convert.ToInt32(ts_HospData_Share.czlx.jc_处方模板))
{
czmc = ts_HospData_Share.czlx.jc_处方模板.ToString();
ts_HospData_Share.jc_cfmb.update(ts, database);
}
if (ts.Czlx == Convert.ToInt32(ts_HospData_Share.czlx.br_病人信息同步))
{
czmc = ts_HospData_Share.czlx.br_病人信息同步.ToString();
ts_HospData_Share.br_brxx.update(ts, database);
}
}
catch (System.Exception err)
{
string jgmc = "";
DataTable tb = database.GetDataTable("select jgmc from jc_jgbm where jgbm=" + ts.MbjgbM + "");
if (tb.Rows.Count > 0)
{
jgmc = tb.Rows[0][0].ToString();
}
string _sDate = DateManager.ServerDateTimeByDBType(database).ToString();
string err1 = err.Message.ToString(); err1 = err1.Replace("'", " ");
string ssql = "insert into ts_update_errlog(logid,sbyy,djsj,djy,ipdz)values('" + ts.Id + "','" + err1 + "','" + _sDate + "'," + ts.Czry + ",'" + TrasenClasses.GeneralClasses.PubStaticFun.GetMacAddress() + "') ";
database.DoCommand(ssql);
throw new Exception("\n\n 在向 [" + jgmc + "] 执行 [" + czmc + "] 时遇到下列问题:\n\n" + err.Message);
}
}
private void btnsave_Click(object sender, EventArgs e)
{
string sql = " SELECT H.* "
+ "FROM ( SELECT A.ORDER_ID, A.ORDER_NAME, A.ORDER_UNIT, A.PY_CODE, A.BZ, A.DEFAULT_USAGE, "
+ " D.EXEC_DEPT AS DEFAULT_DEPT,SAMP_NAME SAMPLE,0 SORT_INDEX,C.SAMP_CODE CODE "
+ " FROM (SELECT * "
+ " FROM JC_HOITEMDICTION "
+ " WHERE DELETE_BIT = 0 AND ORDER_TYPE = 5) A "
+ " INNER JOIN "
+ " JC_ASSAY B ON A.ORDER_ID = B.YZID AND B.HYLXID=" + this.cmbClass.SelectedValue.ToString()
+ " INNER JOIN "
+ " JC_HOI_DEPT D ON A.ORDER_ID = D.ORDER_ID AND D.EXEC_DEPT=" + this.cmbDept.SelectedValue.ToString()
+ " LEFT JOIN "
+ " LS_AS_SAMPLE C ON B.BBID=C.SAMP_CODE "
+ " ) AA join JC_HOI_hdi b on aa.ORDER_ID=b.hoitem_ID "
+ " left join jc_jyxm_bm H on aa.ORDER_ID=H.hoitem_id ";
InstanceForm._database.BeginTransaction();
try
{
DataTable tb = (DataTable)this.dataGridView1.DataSource;
DataTable temptb = new DataTable();
temptb.Columns.Add("id", typeof(System.Int32));
temptb.Columns.Add("Hoitem_id", typeof(System.Int32));
temptb.Columns.Add("item_alias", typeof(System.String));
temptb.Columns.Add("delete_bit", typeof(System.Int32));
for (int i = 0; i < tb.Rows.Count; i++)
{
DataRow drow = temptb.NewRow();
drow["id"] = tb.Rows[i]["id"];
drow["Hoitem_id"] = tb.Rows[i]["order_id"];
drow["item_alias"] = tb.Rows[i]["item_alias"];
drow["delete_bit"] = tb.Rows[i]["delete_bit"];
temptb.Rows.Add(drow);
if (tb.Rows[i]["id"].ToString() == "")
{
tb.Rows[i]["id"] = -1;
}
string sql1 = "select * from jc_jyxm_bm where delete_bit=0 and Hoitem_id=" + tb.Rows[i]["order_id"].ToString();
DataTable ttbb = InstanceForm._database.GetDataTable(sql1);
if (ttbb.Rows.Count < 1)
{
string insert = "insert into jc_jyxm_bm(Hoitem_id,item_alias) values(" + tb.Rows[i]["order_id"].ToString() + ",'" + tb.Rows[i]["item_alias"].ToString() + "')";
InstanceForm._database.DoCommand(insert);
}
else
{
string update = "update jc_jyxm_bm set item_alias='" + tb.Rows[i]["item_alias"].ToString() + "' where Hoitem_id=" + tb.Rows[i]["order_id"].ToString();
InstanceForm._database.DoCommand(update);
}
if (tb.Rows[i]["ischange"].ToString().Trim() == "1")
{
tb.Rows[i]["ischange"] = 0;
Guid guid = new Guid();
ts_HospData_Share.ts_update_log ts_share = new ts_HospData_Share.ts_update_log();
ts_share.Save_log(ts_HospData_Share.czlx.jc_基础数据单表修改, "Lis简写同步", "jc_jyxm_bm", "id", tb.Rows[i]["id"].ToString(), jgbm, -999, "", out guid, InstanceForm._database);
}
}
InstanceForm._database.CommitTransaction();
MessageBox.Show("保存成功");
}
catch (Exception ex)
{
InstanceForm._database.RollbackTransaction();
MessageBox.Show(ex.Message);
}
finally
{
// ts_HospData_Share.ts_update_log ts_share = new ts_HospData_Share.ts_update_log();
//ts_share.Save_log(ts_HospData_Share.czlx.zy_特殊治疗申请, "特殊治疗申请【复制病人相关数据】", "ZY_TS_APPLY", "id", tb.Rows[curindex]["id"].ToString(), FrmMdiMain.Jgbm, int.Parse(tb.Rows[curindex]["TS_DEPT"].ToString()), "", out guid, FrmMdiMain.Database);
//add by zouchihua 增加日志
}
// databaseupdate("select * from JC_CONFIG select * from JC_ASSAY ", new DataTable());
}
