/// <summary> /// /// </summary> /// <param name="applyunitid"></param> /// <returns></returns> public long lngDeleteLimitTime(string applyunitid) { using (clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc))) { return(svc.DeleteLimitTime(applyunitid)); } }
public void init() { //标本类型绑定数据 #region clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc)); DataTable dt = svc.GetSampleType(); this.cboSampleType.Items.Add("全部"); this.cboTimeType.Items.Add("核收时间"); this.cboTimeType.Items.Add("开单时间"); this.cboTimeType.SelectedIndex = 0; try { if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { this.cboSampleType.Items.Add(dr["sample_type_desc_vchr"].ToString()); } } } finally { svc = null; } #endregion }
/// <summary> /// 细菌分布趋势报告 /// </summary> /// <param name="micname"></param> /// <param name="p_dtDateFrom"></param> /// <param name="p_dtDateTO"></param> /// <param name="SamtNo"></param> /// <param name="DisNo"></param> /// <param name="Sex"></param> /// <param name="TestMethod"></param> /// <param name="dtbResult"></param> /// <returns></returns> public long lngGetMicdistributionTend(string micname, DateTime p_dtDateFrom, DateTime p_dtDateTO, string applicationStr, string DeptIdArr, string sampleId, string DisNo, string Sex, string TestMethod, out DataTable dtbResult) { using (clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc))) { return(svc.lngGetMicdistributionTend(micname, p_dtDateFrom, p_dtDateTO, applicationStr, DeptIdArr, sampleId, DisNo, Sex, TestMethod, out dtbResult)); } }
/// <summary> /// lngGetLimitTime /// </summary> /// <param name="dtbResult"></param> /// <param name="applyunitid"></param> /// <returns></returns> public long lngGetLimitTime(out DataTable dtbResult, string applyunitid) { using (clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc))) { return(svc.GetLimitTime(out dtbResult, applyunitid)); } }
private void frmCritialDeptList_Load(object sender, EventArgs e) { this.dgvDeptList.SelectionMode = DataGridViewSelectionMode.FullRowSelect; try { clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc)); DataTable dt = svc.GetDeptList(deptint); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { int index = this.dgvDeptList.Rows.Add(); //this.dataGridView1.Rows[index].Cells[0].Value = index.ToString(); this.dgvDeptList.Rows[index].Cells[1].Value = (index + 1).ToString(); this.dgvDeptList.Rows[index].Cells[2].Value = dr["code_vchr"].ToString().Trim(); this.dgvDeptList.Rows[index].Cells[3].Value = dr["deptname_vchr"].ToString().Trim(); } } } finally { } }
/// <summary> /// 模糊查询抗生素 /// </summary> /// <param name="micName"></param> /// <param name="IsEnglish"></param> /// <param name="dtbResult"></param> /// <returns></returns> public long lngGetFuzzyQueryAnti(string micName, bool IsEnglish, out DataTable dtbResult) { using (clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc))) { return(svc.lngGetFuzzyQueryAnti(micName, IsEnglish, out dtbResult)); } }
/// <summary> /// /// </summary> /// <param name="p_dtDateFrom"></param> /// <param name="p_dtDateTo"></param> /// <param name="SamtName"></param> /// <param name="strTempAntiName"></param> /// <param name="dtbResult"></param> /// <returns></returns> public long lngGetMicApplication(string strTempAntiName, DateTime p_dtDateFrom, DateTime p_dtDateTo, string criticalStr, string DeptIdArr, out DataTable dtbResult) { using (clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc))) { return(svc.lngGetApplicateion(strTempAntiName, p_dtDateFrom, p_dtDateTo, criticalStr, DeptIdArr, out dtbResult)); } }
/// <summary> /// /// </summary> /// <param name="applicationStr"></param> /// <param name="dtbResult"></param> /// <returns></returns> public long lngGetGss(string applicationStr, out DataTable dtbResult) { using (clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc))) { return(svc.lngGetGss(applicationStr, out dtbResult)); } }
/// <summary> /// /// </summary> /// <param name="p_dtDateFrom"></param> /// <param name="p_dtDateTO"></param> /// <param name="dtbResult"></param> /// <returns></returns> public long lngGetAntiCheckItem(DateTime p_dtDateFrom, DateTime p_dtDateTO, out DataTable dtbResult) { using (clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc))) { return(svc.lngGetAntiCheckItem(p_dtDateFrom, p_dtDateTO, out dtbResult)); } }
/// <summary> /// 细菌 按类型 /// </summary> /// <param name="p_dtDateFrom"></param> /// <param name="p_dtDateTO"></param> /// <param name="applicationStr"></param> /// <param name="sampleId"></param> /// <param name="DisNo"></param> /// <param name="Sex"></param> /// <param name="TestMethod"></param> /// <param name="strTempAntiID"></param> /// <param name="dtbResult"></param> /// <returns></returns> public long lngGetAntiByDept(string strTempName, string applicationStr, string DeptIdArr, string sampleId, string DisNo, string Sex, out DataTable dtbResult) { using (clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc))) { return(svc.lngGetAntiByDept(strTempName, applicationStr, DeptIdArr, sampleId, DisNo, Sex, out dtbResult)); } }
/// <summary> /// 细菌明细 /// </summary> /// <param name="p_dtDateFrom"></param> /// <param name="p_dtDateTO"></param> /// <param name="applicationStr"></param> /// <param name="sampleId"></param> /// <param name="DisNo"></param> /// <param name="Sex"></param> /// <param name="TestMethod"></param> /// <param name="strTempAntiID"></param> /// <param name="dtbResult"></param> /// <returns></returns> public long lngGetAntiDetail(string strTempName, DateTime p_dtDateFrom, DateTime p_dtDateTO, string DeptIdArr, string sampleId, string DisNo, string Sex, out DataTable dtbResult) { using (clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc))) { return(svc.lngGetAntiDetail(strTempName, p_dtDateFrom, p_dtDateTO, DeptIdArr, sampleId, DisNo, Sex, out dtbResult)); } }
/// <summary> /// 获取所有革兰细菌 /// </summary> /// <param name="dt"></param> /// <returns></returns> public long lngGetAllGlMic(out DataTable dt) { using (clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc))) { return(svc.lngGetAllGlMic(out dt)); } }
/// <summary> /// 检验项目阳性结果分析统计表 /// </summary> /// <param name="dtbResult"></param> /// <returns></returns> public long lngGetPositiveReport(out DataTable dtbResult, string dteStart, string dteEnd, string checkItemId, string strDept, string groupId, string patNo) { using (clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc))) { return(svc.GetPositiveReport(out dtbResult, dteStart, dteEnd, checkItemId, strDept, groupId, patNo)); } }
/// <summary> /// 获取所有检验项目 /// </summary> /// <param name="dtbResult"></param> /// <returns></returns> public long lngGetAllCheckItem(out DataTable dtbResult, string groupId) { using (clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc))) { return(svc.GetAllCheckItemCpy(out dtbResult, groupId)); } }
/// <summary> /// /// </summary> /// <param name="dt"></param> /// <returns></returns> public long lngSaveLimitTime(DataTable dt) { using (clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc))) { return(svc.SaveLimitTime(dt)); } }
/// <summary> /// 免费母婴阻断阳性结果汇总 /// </summary> /// <param name="dteStart"></param> /// <param name="dteEnd"></param> /// <param name="dtbResult"></param> /// <returns></returns> public long lngGetPmpcDetail(string dteStart, string dteEnd, string patType, out DataTable dtbResult) { using (clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc))) { return(svc.GetPmpctDetail(dteStart, dteEnd, patType, out dtbResult)); } }
/// <summary> /// 检验标本周转中位数统计表 /// </summary> /// <param name="dtbResult"></param> /// <returns></returns> public long lngGetSampleMedSpec(out DataTable dtbResult, string dteStart, string dteEnd, string groupId, string applyUnitId, string strDept, string enmergencyFlg, string patType) { using (clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc))) { return(svc.GetSampleMedSpec(out dtbResult, dteStart, dteEnd, groupId, applyUnitId, strDept, enmergencyFlg, patType)); } }
/// <summary> /// /// </summary> /// <param name="dteStart"></param> /// <param name="dteEnd"></param> /// <param name="categoryId"></param> /// <param name="dtbResult"></param> /// <returns></returns> public long GetWorkLoadCount(string dteStart, string dteEnd, string categoryId, out DataTable dtbResult) { using (clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc))) { return(svc.GetWorkLoadCount(dteStart, dteEnd, categoryId, out dtbResult)); } }
private void frmByDept_Load(object sender, EventArgs e) { this.LstDeptID = new List <string>(); this.LstDeptName = new List <string>(); //clsDcl_Charge clsDcl_Charge = new clsDcl_Charge(); clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc)); long num = 0; DataTable dataTable = null; if (this.area == 1) { num = svc.GetArea(out dataTable); } else { num = svc.GetDeptArea(out dataTable); } if (num > 0L) { int i = 0; while (i < dataTable.Rows.Count) { DataRow dataRow = dataTable.Rows[i]; if (this.LimitDeptIDArr.Count <= 0 || this.LimitDeptIDArr.IndexOf(dataRow["deptid_chr"].ToString()) >= 0) { string[] values = { "F", Convert.ToString(i + 1), dataRow["code_vchr"].ToString().Trim(), dataRow["deptname_vchr"].ToString().Trim() }; int index = this.dtDept.Rows.Add(values); this.dtDept.Rows[index].Tag = dataRow; } i++; } } this.txtVal.Focus(); }
/// <summary> /// 科室用药汇总 /// </summary> /// <param name="dteStart"></param> /// <param name="dteEnd"></param> /// <param name="dtbResult"></param> /// <returns></returns> public long lngGetKsMedStatment(string dteStart, string dteEnd, string deptStr, out DataTable dtbResult) { using (clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc))) { return(svc.lngGetKsMedStatment(dteStart, dteEnd, deptStr, out dtbResult)); } }
/// <summary> /// 预发药冲减 /// </summary> /// <param name="putmeddetailId"></param> /// <param name="dtbResult"></param> /// <returns></returns> public long lngGetRePretestMedStat(string putmeddetailId, out DataTable dtbResult) { using (clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc))) { return(svc.lngGetRePretestMedStat(putmeddetailId, out dtbResult)); } }
/// <summary> /// 累计MIC报告 /// </summary> /// <param name="p_dtDateFrom"></param> /// <param name="p_dtDateTO"></param> /// <param name="SamtNo"></param> /// <param name="DisNo"></param> /// <param name="Sex"></param> /// <param name="TestMethod"></param> /// <param name="strTempAntiID"></param> /// <param name="dtbResult"></param> /// <returns></returns> public long lngGetMicCumulative(string applicationStr, string sampleId, string DisNo, string Sex, string TestMethod, string strTempAntiID, out DataTable dtbResult) { using (clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc))) { return(svc.lngGetMicCumulative(applicationStr, sampleId, DisNo, Sex, TestMethod, strTempAntiID, out dtbResult)); } }
public List <string> GetYGItem() { #region clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc)); DataTable dt = svc.GetYGItemType(); List <string> lstData = new List <string>(); try { if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { lstData.Add(dr["refDesc"].ToString()); } } } finally { svc = null; } return(lstData); #endregion }
/// <summary> /// 名称检索检验项目 /// </summary> /// <param name="strTempName"></param> /// <param name="dtbResult"></param> /// <returns></returns> public long lngGetCheckItemByName(string strTempName, string groudId, out DataTable dtbResult) { using (clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc))) { return(svc.GetCheckItemByNameCpy(strTempName, groudId, out dtbResult)); } }
/// <summary> /// 获取专业组 /// </summary> /// <param name="dtbResult"></param> /// <returns></returns> public void lngGetAllCheckSpec(out DataTable dtbResult) { dtbResult = null; using (clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc))) { dtbResult = svc.GetGategoryType(); } }
/// <summary> /// 细菌名称检验细菌 /// </summary> /// <param name="micName"></param> /// <param name="IsEnglish"></param> /// <param name="dtbResult"></param> /// <returns></returns> public long lngGetFuzzyQueryMic(string micName, bool IsEnglish, out DataTable dtbResult) { long lngRes = 0; dtbResult = null; using (clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc))) lngRes = svc.lngGetFuzzyQueryMic(micName, IsEnglish, out dtbResult); return(lngRes); }
/// <summary> /// 敏感率趋势报告 /// </summary> /// <param name="micname"></param> /// <param name="p_dtDateFrom"></param> /// <param name="p_dtDateTO"></param> /// <param name="SamtNo"></param> /// <param name="DisNo"></param> /// <param name="Sex"></param> /// <param name="AgeFrom"></param> /// <param name="AgeTo"></param> /// <param name="TestMethod"></param> /// <param name="strTempAntiID"></param> /// <param name="dtbResult"></param> /// <returns></returns> public long lngGetSensitiveTend(string applictionStr, string sampleId, string DisNo, string Sex, string strTempAntiID, out DataTable dtbResult) { long lngRes = 0; dtbResult = null; using (clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc))) lngRes = svc.lngGetSensitiveTend(applictionStr, sampleId, DisNo, Sex, strTempAntiID, out dtbResult); return(lngRes); }
/// <summary> /// /// </summary> /// <param name="dtbResult"></param> /// <returns></returns> public long lngGgetAllZyz(out DataTable dtbResult) { long lngRes = 0; using (clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc))) { dtbResult = svc.GetGategoryType(); } return(lngRes); }
private void btnSelect_Click(object sender, EventArgs e) { string BeginDate = this.dteRq1.Value.ToString("yyyy-MM-dd"); string EndDate = this.dteRq2.Value.ToString("yyyy-MM-dd"); if (Convert.ToDateTime(BeginDate + " 00:00:01") > Convert.ToDateTime(EndDate + " 00:00:01")) { MessageBox.Show("开始日期不能大于结束日期。", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } try { clsPublic.PlayAvi("findFILE.avi", "正在统计院感项目信息,请稍候..."); dwRep.Reset(); clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc)); DataTable dt = svc.GetYGItem(BeginDate, EndDate); if (dt != null && dt.Rows.Count > 0) { int row = 0; dwRep.SetRedrawOff(); foreach (DataRow dr in dt.Rows) { row = dwRep.InsertRow(0); dwRep.SetItemString(row, "areaName", dr["areaName"].ToString()); dwRep.SetItemString(row, "bedNo", dr["bedNo"].ToString()); dwRep.SetItemString(row, "ipNo", dr["ipNo"].ToString()); dwRep.SetItemString(row, "patName", dr["patName"].ToString()); dwRep.SetItemString(row, "sex", dr["patsex"].ToString()); dwRep.SetItemString(row, "age", dr["birthday"] != DBNull.Value ? clsPublic.CalcAge(Convert.ToDateTime(dr["birthday"].ToString())):""); dwRep.SetItemString(row, "itemCode", dr["itemCode"].ToString()); dwRep.SetItemString(row, "itemName", dr["itemName"].ToString()); dwRep.SetItemString(row, "startDate", dr["startDate"] != DBNull.Value ? Convert.ToDateTime(dr["startDate"].ToString()).ToString("yyyy-MM-dd HH:mm") : ""); dwRep.SetItemString(row, "stopDate", dr["stopDate"] != DBNull.Value ? Convert.ToDateTime(dr["stopDate"].ToString()).ToString("yyyy-MM-dd HH:mm") : ""); } dwRep.SetRedrawOn(); } else { dwRep.InsertRow(0); } dwRep.Modify("t_date.text = '" + BeginDate + " ~ " + EndDate + "'"); } finally { clsPublic.CloseAvi(); } this.dwRep.Refresh(); }
internal void Query() { List <string> lstParam = new List <string>(); string beginDate = string.Empty; string endDate = string.Empty; string sampleType = string.Empty; string patName = string.Empty; string barCode = string.Empty; string peno = string.Empty; string ownerDept = string.Empty; //string deptStr= string.Empty; int checkState = 0; getdeptstr(); if (!chkDeptSelect.Checked) { lstParam.Add("ownerDept"); deptStr = "('" + this.LoginInfo.m_strDepartmentID + "','" + this.LoginInfo.m_strInpatientAreaID + "')"; } else { lstParam.Add("deptStr"); } //this.LoginInfo.m_strDepartmentID beginDate = this.dteRq1.Value.ToString("yyyy-MM-dd HH:mm"); endDate = this.dteRq2.Value.ToString("yyyy-MM-dd HH:mm"); int timeType = this.cboTimeType.SelectedIndex; lstParam.Add("queryDate"); if (Convert.ToDateTime(beginDate + " :01") > Convert.ToDateTime(endDate + ":59")) { MessageBox.Show("开始日期不能大于结束日期。", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (this.cboSampleType.Text.Trim() != string.Empty) { lstParam.Add("sampleType"); sampleType = cboSampleType.Text.Trim(); } if (this.txtBarcode.Text.Trim() != string.Empty) { lstParam.Add("barCode"); barCode = this.txtBarcode.Text; } if (this.txtPatName.Text.Trim() != string.Empty) { lstParam.Add("patName"); patName = this.txtPatName.Text; } if (this.txtPeno.Text.Trim() != string.Empty) { lstParam.Add("peno"); peno = this.txtPeno.Text; } if (this.chkChecked.Checked == true) { lstParam.Add("check"); checkState = 1; } if (this.chkUnchecked.Checked == true) { lstParam.Add("check"); checkState = 2; } if (this.chkRefuseCheck.Checked == true) { lstParam.Add("check"); checkState = 3; } try { clsPublic.PlayAvi("findFILE.avi", "正在项目信息,请稍候..."); dwRep.Reset(); clsHISReportZy_Supported_Svc svc = (clsHISReportZy_Supported_Svc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(clsHISReportZy_Supported_Svc)); DataTable dt = svc.GetSamplePackStat(lstParam, beginDate, endDate, sampleType, patName, barCode, peno, deptStr, checkState, timeType); if (dt != null && dt.Rows.Count > 0) { int row = 0; dwRep.SetRedrawOff(); foreach (DataRow dr in dt.Rows) { row = dwRep.InsertRow(0); dwRep.SetItemString(row, "barcode", dr["barcode"].ToString()); dwRep.SetItemString(row, "patcardno", dr["patcardno"].ToString().Trim()); if (dr["peno"].ToString().Trim().Length < 12) { dwRep.SetItemString(row, "inpatno", dr["peno"].ToString().Trim()); } else { dwRep.SetItemString(row, "peno", dr["peno"].ToString().Trim()); } dwRep.SetItemString(row, "pattype", dr["pattype"].ToString()); dwRep.SetItemString(row, "patname", dr["patname"].ToString()); dwRep.SetItemString(row, "sampletype", dr["sampletype"].ToString()); dwRep.SetItemString(row, "checkcontent", dr["checkcontent"].ToString()); dwRep.SetItemString(row, "applyername", dr["applyername"].ToString()); dwRep.SetItemString(row, "deptname", dr["deptname"].ToString()); dwRep.SetItemString(row, "packtime", dr["packtime"] != DBNull.Value ? Convert.ToDateTime(dr["packtime"].ToString()).ToString("yyyy-MM-dd HH:mm") : ""); dwRep.SetItemString(row, "packname", dr["packname"].ToString()); dwRep.SetItemString(row, "checktime", dr["checktime"] != DBNull.Value ? Convert.ToDateTime(dr["checktime"].ToString()).ToString("yyyy-MM-dd HH:mm") : ""); dwRep.SetItemString(row, "checkname", dr["checkname"].ToString()); dwRep.SetItemString(row, "rechecktime", dr["rechecktime"] != DBNull.Value ? Convert.ToDateTime(dr["rechecktime"].ToString()).ToString("yyyy-MM-dd HH:mm") : ""); dwRep.SetItemString(row, "recheckreason", dr["recheckreason"].ToString()); } dwRep.SetRedrawOn(); } else { dwRep.InsertRow(0); } dwRep.Modify("t_date.text = '" + beginDate + " ~ " + endDate + "'"); } finally { lstParam = null; clsPublic.CloseAvi(); } this.dwRep.Refresh(); }