/// <summary> /// 根据类别得到通用模板列表 /// </summary> /// <param name="catalog">模板类别</param> /// <returns></returns> public DataTable GetTemplate(string catalog, string deptCode) { string auditConfig = AppConfigReader.GetAppConfig("TempletAuditConfig").Config; string newEmrShowType = AppConfigReader.GetAppConfig("NewEmrShowType").Config;//1:按照病种分组 2:不进行分组 string sqlGetTemplate = string.Empty; if (auditConfig.Split('-')[0] == "1") { if (newEmrShowType == "1") { sqlGetTemplate = sql_queryTemplateAudited + " order by ordername "; } else { sqlGetTemplate = sql_queryTemplateAudited + " order by mr_name "; } } else { if (newEmrShowType == "1") { sqlGetTemplate = sql_queryTemplate + " order by ordername "; } else { sqlGetTemplate = sql_queryTemplate + " order by mr_name "; } } DataTable dt = m_app.SqlHelper.ExecuteDataTable(string.Format(sqlGetTemplate, catalog, deptCode)); //GetActuralTemplate(dt); return(dt); }
private void SetShowType() { string newEmrShowType = AppConfigReader.GetAppConfig("NewEmrShowType").Config; //1:按照病种分组 2:不进行分组 if (newEmrShowType != "1") //不进行分组 { colkIND.GroupIndex = -1; gridView1.OptionsView.ShowGroupPanel = false; } }
/// <summary> /// 针对护理的表单设置页数 /// </summary> private void SetPageIndexForNurseRecord() { string AutoAddPage = AppConfigReader.GetAppConfig("AutoAddPageForNurseRecord").Config; if (AutoAddPage == "1") { string pageIndex = m_PatUtil.GetNurseRecordPageIndex(m_Model.InstanceId.ToString(), m_Model.TempIdentity, m_Model.ModelCatalog, m_noofinpat).ToString(); if (pageIndex != "-1") { CurrentForm.zyEditorControl1.EMRDoc.PageIndexForNurse = pageIndex; CurrentForm.zyEditorControl1.EMRDoc.Refresh(); CurrentForm.zyEditorControl1.Refresh(); } } }
/// <summary> /// 判断是否超时 /// </summary> /// <param name="qccode"></param> /// <param name="dt"></param> /// <returns></returns> bool checkOutTime(string qccode, DataTable dt) { bool result = false; string islock = ""; islock = AppConfigReader.GetAppConfig("IsLockByQcTime").Config; // if(m) //加锁的部门编号 string lockDept = AppConfigReader.GetAppConfig("LockDept").Config; string[] dept = lockDept.Split(','); { foreach (string deptno in dept) { if (m_app.User.CurrentDeptId.Trim() == deptno.Trim()) { result = true; } } } if (result) { if (islock == "0") { result = false; } else { result = false; if (dt != null) { for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["qccode"].ToString().Trim() == qccode) { result = true; } } } } } return(result); }
private void InitWardInfo() { try { string config = AppConfigReader.GetAppConfig("ChangeWardLookAllWard").Config; string[] array = config.Split(new char[] { ',' }); string[] array2 = FormMain.Instance.User.GWCodes.Split(new char[] { ',' }); bool flag = false; string commandText = "select id from jobs "; ArrayList arrayList = new ArrayList(); DataTable dataTable = ((IEmrHost)FormMain.Instance).SqlHelper.ExecuteDataTable(commandText); if (dataTable.Rows.Count > 0) { for (int i = 0; i < dataTable.Rows.Count; i++) { arrayList.Add(dataTable.Rows[i]["ID"].ToString()); } } string[] array3 = array; for (int j = 0; j < array3.Length; j++) { string text = array3[j]; string[] array4 = array2; for (int k = 0; k < array4.Length; k++) { string b = array4[k]; if (text == b && text != "") { if (arrayList.Contains(text)) { flag = true; } } } } if (flag) { string commandText2 = "SELECT a.id deptid, a.name deptname, b.id wardid, b.name wardname \r\n FROM department a, ward b, dept2ward c\r\n WHERE a.id = c.deptid and b.id = c.wardid and a.valid = '1' and b.valid = '1'\r\n ORDER BY a.name "; DataTable dataTable2 = ((IEmrHost)FormMain.Instance).SqlHelper.ExecuteDataTable(commandText2); foreach (DataRow dataRow in dataTable2.Rows) { DeptWardInfo current = new DeptWardInfo(dataRow["deptid"].ToString(), dataRow["deptname"].ToString(), dataRow["wardid"].ToString(), dataRow["wardname"].ToString()); this.comboBoxEdit_Dt.Properties.Items.Add(current); } } else { foreach (DeptWardInfo current in FormMain.Instance.User.RelateDeptWards) { this.comboBoxEdit_Dt.Properties.Items.Add(current); } } } catch (SqlException message) { FormMain.Instance.Logger.Error(message); } catch (Exception message2) { FormMain.Instance.Logger.Error(message2); } }
/// <summary> /// add by ywk 2012年6月1日 14:54:43 /// 修改模板的功能 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnEditTempl_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (treeList1.FocusedNode == null) { return; } TreeListNode focusNode = treeList1.FocusedNode; if (!treeList1.FocusedNode.GetValue("NODETYPE").ToString().Equals("Leaf")) { m_app.CustomMessageBox.MessageShow("请选择模板"); return; } //新增时先记录点击的节点以便修改后还是定位在此处 string nodeID = string.Empty; if (this.treeList1.FocusedNode != null) { nodeID = treeList1.FocusedNode.GetValue("ID").ToString(); } TempletItem item = (TempletItem)treeList1.FocusedNode.Tag; //原显示是有问题的add by 杨伟康 if (item.Content.Contains("\n\r")) { m_ItemContent.MyItem.Content = item.Content.Replace("\n\r", "\r\n"); } else if (item.Content.Contains("'||chr(10)||chr(13)||'")) { m_ItemContent.MyItem.Content = item.Content.Replace("'||chr(10)||chr(13)||'", "\r\n"); } else { m_ItemContent.MyItem.Content = item.Content; } //m_ItemContent.MyItem.Content = item.Content.Replace("\n\r", "\r\n"); m_ItemContent.MyItem.Code = item.Code; //模板CODE m_ItemContent.MyItem.ItemName = item.ItemName; //模板名称 m_ItemContent.MyItem.CatalogName = item.CatalogName; //分类名称 m_ItemContent.MyItem.ParentID = item.ParentID; //父节点 m_ItemContent.MyItem.IsPerson = item.IsPerson; //区分科室和个人小模板 m_ItemContent.MyItem.CreateUser = item.CreateUser; //修改和删除只能控制到是创建人进行操作 add by ywk edit by cyq 2012-09-27 //if (m_ItemContent.MyItem.CreateUser != m_app.User.Id) //{ // m_app.CustomMessageBox.MessageShow("此模板只有创建者可以进行修改"); // return; //} //是否可以修改所有人创建的模板(0不可以 1;K) string CanEditPersonTempleteAll = AppConfigReader.GetAppConfig("CanEditPersonTempleteAll").Config; if (CanEditPersonTempleteAll.Trim() == "0") { string msg = GetMsgIfNotCreateUser(nodeID, item.CreateUser, 1, 0, int.Parse(item.IsPerson)); if (!string.IsNullOrEmpty(msg)) { m_app.CustomMessageBox.MessageShow(msg); return; } } if (m_ItemContent.ShowDialog() == System.Windows.Forms.DialogResult.OK) { string content = string.Empty; if (m_ItemContent.MyItem.Content.Contains("\r\n"))//存在换行,替代插入数据库中 edit by ywk { content = m_ItemContent.MyItem.Content.Replace("\r\n", "'||chr(10)||chr(13)||'"); } else { content = m_ItemContent.MyItem.Content; } string updatesql = @" update emrtemplet_item_person set item_content=@content,name=@name where code=@code "; OracleParameter[] paraList = new OracleParameter[] { new OracleParameter("content", OracleType.Clob), new OracleParameter("name", OracleType.VarChar), new OracleParameter("code", OracleType.VarChar) }; paraList[0].Value = content; paraList[1].Value = m_ItemContent.MyItem.ItemName; paraList[2].Value = item.Code; DS_SqlHelper.CreateSqlHelper(); DS_SqlHelper.ExecuteNonQuery(updatesql, paraList, CommandType.Text); PersonItemManager_Load(null, null); TreeListNode leafnode = treeList1.FindNodeByKeyID(nodeID); m_app.CustomMessageBox.MessageShow("修改成功"); treeList1.FocusedNode = leafnode; } }
private void InitWardInfo() { try { string jobIDs = AppConfigReader.GetAppConfig("ChangeWardLookAllWard").Config; string[] jobArray = jobIDs.Split(','); string[] userJobArray = FormMain.Instance.User.GWCodes.Split(','); bool isLookAllWard = false; //如果删除了岗位,这边要先判断在配置中的岗位存在ywk string sqlSerchJob = "select id from jobs "; ArrayList jobs = new ArrayList(); DataTable DtPower = null; DtPower = ((IEmrHost)FormMain.Instance).SqlHelper.ExecuteDataTable(sqlSerchJob); if (DtPower.Rows.Count > 0) { for (int i = 0; i < DtPower.Rows.Count; i++) { jobs.Add(DtPower.Rows[i]["ID"].ToString()); } } DtPower = null; //add by Ukey 2016-08-26 foreach (string jobID in jobArray) { foreach (string userJobID in userJobArray) { if (jobID == userJobID && jobID != "") { if (jobs.Contains(jobID)) { isLookAllWard = true; } } } } //update by Ukey 2016-08-26 判断非管理员权限的单一员工权限, 限制切换科室的一个人进入两个(非全院科室)权限 DtPower = ((IEmrHost)FormMain.Instance).SqlHelper.ExecuteDataTable("select deptorward from users where id ='" + this.id + "'"); DataRow DrRow = DtPower.Rows[0]; string strdeptorward = null; string[] deptorwardArray = DrRow["deptorward"].ToString().Split(','); foreach (string dept in deptorwardArray) { if (strdeptorward != null) { strdeptorward += "," + "'" + dept + "'"; } else { strdeptorward = "'" + dept + "'"; } } DataTable dt = null; Dictionary <string, int> columnwidth = new Dictionary <string, int>(); SqlWordbook sqlWordBook = null; if (isLookAllWard) //update by Ukey 2016-08-26 { string getAllDeptWards = @"select * from (SELECT a.id || b.id FLOWID, a.id DEPTID, b.id WARDID, a.name DEPTNAME, b.name WardName FROM department a, ward b, dept2ward c WHERE a.id = c.deptid and b.id = c.wardid and a.valid = '1' and b.valid = '1' ORDER BY a.name)"; //update by Ukey 2016-08-26 dt = ((IEmrHost)FormMain.Instance).SqlHelper.ExecuteDataTable(getAllDeptWards); dt.Columns["FLOWID"].Caption = "代码"; dt.Columns["WARDID"].Caption = "病区ID"; dt.Columns["DEPTID"].Caption = "科室ID"; dt.Columns["DEPTNAME"].Caption = "科室"; dt.Columns["WARDNAME"].Caption = "病区"; } else { string getAllDeptWards = @"select * from (SELECT a.id || b.id FLOWID, a.id DEPTID, b.id WARDID, a.name DEPTNAME, b.name WardName FROM department a, ward b, dept2ward c WHERE a.id = c.deptid and b.id = c.wardid and a.valid = '1' and b.valid = '1' and a.id in (" + strdeptorward + @") ORDER BY a.name) union select * from (SELECT a.id || b.id FLOWID, a.id DEPTID, b.id WARDID, a.name DEPTNAME, b.name WardName FROM department a, ward b, dept2ward c WHERE a.id = c.deptid and b.id = c.wardid and a.valid = '1' and b.valid = '1' and b.id in (" + strdeptorward + @") ORDER BY a.name)";//update by Ukey 2016-08-06 dt = ((IEmrHost)FormMain.Instance).SqlHelper.ExecuteDataTable(getAllDeptWards); if (dt == null) { dt = new DataTable(); DataColumn colCode = new DataColumn("DEPTID"); DataColumn colWardId = new DataColumn("WARDID"); DataColumn colFLOWID = new DataColumn("FLOWID"); DataColumn colName = new DataColumn("DEPTNAME"); dt.Columns.Add(colCode); dt.Columns.Add(colName); dt.Columns.Add(colFLOWID); dt.Columns.Add(colWardId); dt.Columns["FLOWID"].Caption = "代码"; dt.Columns["DEPTID"].Caption = "科室ID"; dt.Columns["WARDID"].Caption = "病区ID"; dt.Columns["DEPTNAME"].Caption = "科室"; columnwidth = new Dictionary <string, int>(); foreach (DeptWardInfo ward in FormMain.Instance.User.RelateDeptWards) { DataRow row = dt.NewRow(); row["DEPTID"] = ward.DeptId; row["WARDID"] = ward.WardId; row["FLOWID"] = ward.DeptId + ward.WardId; row["DEPTNAME"] = ward.DeptName + "(" + ward.WardName + ")"; dt.Rows.Add(row); } } else { dt.Columns["FLOWID"].Caption = "代码"; dt.Columns["DEPTID"].Caption = "科室ID"; dt.Columns["WARDID"].Caption = "病区ID"; dt.Columns["DEPTNAME"].Caption = "科室"; dt.Columns["WARDNAME"].Caption = "病区"; } } new GenerateShortCode(((IEmrHost)FormMain.Instance).SqlHelper).AutoAddShortCode(dt, "DEPTNAME"); columnwidth.Add("DEPTID", 45); columnwidth.Add("WARDID", 45); columnwidth.Add("DEPTNAME", 110); sqlWordBook = new SqlWordbook("queryname", dt, "FLOWID", "DEPTNAME", columnwidth, "DEPTID//DEPTNAME//PY//WB"); this.lookUpEditorDepart.SqlWordbook = sqlWordBook; } catch (System.Data.SqlClient.SqlException ex) { FormMain.Instance.Logger.Error(ex); } catch (Exception ex) { FormMain.Instance.Logger.Error(ex); } }