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