/// <summary> /// PopupForm /// </summary> /// <param name="vo"></param> void PopupForm(EntityContagionDisplay vo) { if (vo == null) { vo = new EntityContagionDisplay(); vo.isNew = true; } vo.reportId = Viewer.ReportId; frmContagionEdit frm = new frmContagionEdit(vo); frm.Text = Viewer.Text; using (ProxyContagion proxy = new ProxyContagion()) { if (Function.Int(vo.rptId) > 0) { string Role = proxy.Service.GetContagionRole(GlobalLogin.objLogin.EmpNo); frm.blbiSave.Enabled = false; if (Role != string.Empty || vo.SHR == null) { frm.blbiSave.Enabled = true; } } } frm.ShowDialog(); if (frm.IsSave) { this.Query(); } }
/// <summary> /// EditReport /// </summary> internal void EditReport() { EntityContagionDisplay vo = GetRowObject(); if (vo != null) { this.PopupForm(vo); } }
/// <summary> /// 构造 /// </summary> public frmContagionEdit(EntityContagionDisplay _ContagionDisplayVo) { InitializeComponent(); if (!DesignMode) { this.defaultLookAndFeel.LookAndFeel.SkinName = GlobalLogin.SkinName; DevExpress.LookAndFeel.UserLookAndFeel.Default.SetSkinStyle(GlobalLogin.SkinName); ((ctlContagionEdit)Controller).ContagionDisplayVo = _ContagionDisplayVo; } }
/// <summary> /// Print /// </summary> internal void Print() { EntityContagionDisplay vo = GetRowObject(); if (vo != null && Function.Dec(vo.rptId) > 0) { frmPrintDocumentSimple frm = new frmPrintDocumentSimple(GetXR(Function.Dec(vo.rptId))); frm.ShowDialog(); } }
/// <summary> /// Export /// </summary> internal void Export() { EntityContagionDisplay vo = GetRowObject(); if (vo != null && Function.Dec(vo.rptId) > 0) { XtraReport xr = GetXR(Function.Dec(vo.rptId)); if (xr != null && xr.DataSource != null) { xr.Name = Viewer.Text; uiHelper.Export(xr); } } }
/// <summary> /// DelReport /// </summary> internal void DelReport() { EntityContagionDisplay vo = GetRowObject(); if (vo != null && Function.Dec(vo.rptId) > 0) { if (DialogBox.Msg("确定是否删除当前记录??", MessageBoxIcon.Question) == DialogResult.Yes) { using (ProxyContagion proxy = new ProxyContagion()) { if (proxy.Service.DelContagion(Function.Dec(vo.rptId)) > 0) { DialogBox.Msg("删除传染病记录成功!"); this.Query(); } else { DialogBox.Msg("删除传染病记录失败。"); } } } } }
/// <summary> /// 获取传染病列表 /// </summary> /// <param name="dicParm"></param> /// <returns></returns> internal List <EntityContagionDisplay> GetContagionList(List <EntityParm> dicParm) { string Sql = string.Empty; string Sql1 = string.Empty; string xmlData = string.Empty; Dictionary <string, string> dicData = new Dictionary <string, string>(); List <EntityContagionDisplay> data = new List <EntityContagionDisplay>(); SqlHelper svc = null; try { #region Sql svc = new SqlHelper(EnumBiz.onlineDB); Sql = @"select t.rptId, t.reportId, t.reportTime, t.reportOperCode, t.reportOperName, t.registerCode, t.patno, t.patname, t.patsex, t.birthday, t.contacttel, t.deptcode, b.DEPT_NAME as deptName, c.xmlData from rptContagion t left join code_department b on t.deptcode = b.DEPT_CODE left join rptContagionData c on t.rptId = c.rptId where t.status = 1 and t.reportId = ? "; Sql1 = @"select t.rptId, t.reportId, t.reportTime, t.reportOperCode, t.reportOperName, t.registerCode, t.patno, t.patname, t.patsex, t.birthday, t.contacttel, t.deptcode, b.DEPT_NAME as deptName, c.xmlData from rptContagion t inner join patientinfo a on t.patno = a.CARD_NO left join code_department b on t.deptcode = b.DEPT_CODE left join rptContagionData c on t.rptId = c.rptId where t.status = 1 and t.reportId = ? "; #endregion #region 条件 string strSub = string.Empty; List <IDataParameter> lstParm = new List <IDataParameter>(); // 默认参数 IDataParameter parm = svc.CreateParm(); parm.Value = dicParm.FirstOrDefault(t => t.key == "reportId").value; lstParm.Add(parm); foreach (EntityParm po in dicParm) { parm = svc.CreateParm(); string keyValue = po.value; parm.Value = keyValue; switch (po.key) { case "reportDate": IDataParameter parm1 = svc.CreateParm(); parm1.Value = keyValue.Split('|')[0] + " 00:00:00"; lstParm.Add(parm1); IDataParameter parm2 = svc.CreateParm(); parm2.Value = keyValue.Split('|')[1] + " 23:59:59"; lstParm.Add(parm2); strSub += " and (t.reportTime between ? and ?)"; break; case "deptCode": if (keyValue.IndexOf("','") > 0) { strSub += " and (t.deptCode in (" + keyValue + "))"; } else { parm.Value = parm.Value.ToString().Replace("'", ""); lstParm.Add(parm); strSub += " and (t.deptCode = ?)"; } break; case "cardNo": lstParm.Add(parm); strSub += " and (t.patno= ?)"; break; case "patName": Sql = Sql1; parm.Value = "%" + keyValue + "%"; lstParm.Add(parm); strSub += " and (a.name like ?)"; break; default: break; } } #endregion #region 赋值 // 组合条件 Sql += strSub; DataTable dt = svc.GetDataTable(Sql, lstParm.ToArray()); if (dt != null) { EntityContagionDisplay vo = null; foreach (DataRow dr in dt.Rows) { vo = new EntityContagionDisplay(); vo.rptId = dr["rptId"].ToString(); vo.reportTime = dr["reportTime"].ToString(); vo.reportOperCode = dr["reportOperCode"].ToString(); vo.reportOperName = dr["reportOperName"].ToString(); vo.registerCode = dr["registerCode"].ToString(); vo.patNo = dr["patNo"].ToString(); vo.patName = dr["patName"].ToString(); vo.patSex = dr["patSex"].ToString() == "1" ? "男" : "女"; if (dr["birthday"] != DBNull.Value) { vo.patBirthDay = dr["birthday"].ToString(); vo.patAge = CalcAge.GetAge(Function.Datetime(dr["birthday"])); } vo.contactTel = dr["contactTel"].ToString(); vo.deptName = dr["deptName"].ToString(); xmlData = dr["xmlData"].ToString(); if (!string.IsNullOrEmpty(xmlData)) { dicData = Function.ReadXmlNodes(xmlData, "FormData"); if (dicData.ContainsKey("XSHR") && dicData["XSHR"] != "") { vo.SH = "已审核"; vo.SHR = dicData["XSHR"]; } if (dicData.ContainsKey("XSHD") && dicData["XSHD"] != "") { vo.SHSJ = dicData["XSHD"]; } if (dicData.ContainsKey("XBKS") && dicData["XBKS"] != "") { vo.reportDept = dicData["XBKS"]; } } data.Add(vo); } } #endregion } catch (Exception e) { ExceptionLog.OutPutException(e); } finally { svc = null; } return(data); }