/// <summary> /// 分页查询 /// </summary> /// isEnabled 为 true 时,过滤掉未启用的记录 /// <param name="pageNum"></param> /// <param name="pageSize"></param> /// <returns></returns> public SPagintion <ClinicarItem> FindByPagination(int pageNum, int pageSize, string code, string name, string dtpCode, string dtpName, bool isEnabled) { List <object> listParam = new List <object>(); String whereSql = ""; if (code != null && code.Length > 0) { whereSql += " and code like ? "; listParam.Add("%" + code + "%"); } if (name != null && name.Length > 0) { whereSql += " and name like ? "; listParam.Add("%" + name + "%"); } if (dtpCode != null && dtpCode.Length > 0) { whereSql += " and dpt_code like ? "; listParam.Add("%" + dtpCode + "%"); } if (dtpName != null && dtpName.Length > 0) { whereSql += " and dpt_name like ? "; listParam.Add("%" + dtpName + "%"); } if (isEnabled) { whereSql += " and enabled = 1 "; } SPagintion <ClinicarItem> page = ClinicarItemDao.FindByPagintion(whereSql, listParam.ToArray(), "code desc", pageSize, pageNum); return(page); }
private int FindResult(int pageNum, int pageSize) { int check_id = 0; if (DataEntityClinicarCheck != null && !string.IsNullOrEmpty(DataEntityClinicarCheck.Id)) { check_id = Convert.ToInt32(DataEntityClinicarCheck.Id); } SPagintion <ClinicarCheckItem> page = clinicarCheckItemBiz.FindByPagination(pageNum, pageSize, check_id); IList <ClinicarCheckItem> list = page != null ? page.Data : new List <ClinicarCheckItem>(); SGridViewUtil.BindingData <ClinicarCheckItem>(list, this.ucDgv_list.UcDataGridViewControl, displayProperties); //移除控件 this.picb_left.Controls.Clear(); this.panel3.Controls.Clear(); if (list != null && !Convert.IsDBNull(list) && list.Count > 0) { listDraw = list; for (int i = 0; i < list.Count; i++) { //右边条码 createBarCode(uTxt_checkNum.Text.Trim(), list[i].ItemCode, 27, 6 + i * 88); } } //左上角条码 createLeftBarCode(uTxt_checkNum.Text.Trim()); return(page.TotalRecordCount); }
/// <summary> /// 分页查询 /// </summary> /// <param name="pageNum"></param> /// <param name="pageSize"></param> /// <returns></returns> public SPagintion <ClinihospitalDpt> FindByPagination(int pageNum, int pageSize, string code, string name, string hospitalcode) { List <object> listParam = new List <object>(); String whereSql = ""; if (code != null && code.Length > 0) { whereSql += " and code like ? "; listParam.Add("%" + code + "%"); } if (name != null && name.Length > 0) { whereSql += " and name like ? "; listParam.Add("%" + name + "%"); } if (hospitalcode != null && hospitalcode.Length > 0) { whereSql += " and hospitalcode = ? "; listParam.Add(hospitalcode); } SPagintion <ClinihospitalDpt> page = ClinihospitalDptDao.FindByPagintion(whereSql, listParam.ToArray(), "code desc", pageSize, pageNum); return(page); }
/// <summary> /// /// </summary> private void fillBack() { ClinicarItem entity = null; //项目管理实体类 if (this.dgrdView.CurrentRow != null && this.dgrdView.CurrentRow.Index >= 0 && f_CheckId != 0) { entity = ((BindingList <ClinicarItem>) this.dgrdView.DataSource)[this.dgrdView.CurrentRow.Index]; SResult rst = new SResult(); ClinicarCheckItem clinicarCheckItem = new ClinicarCheckItem(); clinicarCheckItem.ItemCode = entity.Id; clinicarCheckItem.ItemName = entity.Name; clinicarCheckItem.DptCode = entity.DptCode; clinicarCheckItem.DptName = entity.DptName; clinicarCheckItem.CheckId = f_CheckId; rst = clinicarCheckItemBiz.Insert(clinicarCheckItem); if (rst.success) { UcMessageBox.Information("添加成功!", "提示"); } else { UcMessageBox.Error(rst.message, "提示"); } //刷新登记界面中的检查项目表 SPagintion <ClinicarCheckItem> page = clinicarCheckItemBiz.FindByPagination(1, 999, f_CheckId); IList <ClinicarCheckItem> list = page != null ? page.Data : new List <ClinicarCheckItem>(); SGridViewUtil.BindingData <ClinicarCheckItem>(list, this.dataGridViewTranmit, displayPropertiesTranmit); } else { UcMessageBox.Warning("请先选择一行数据", "提示"); } }
private int FindResult(int pageNum, int pageSize) { SPagintion<ClinicarConsultation> page = clinicarConsultationBiz.FindByPagination(pageNum, pageSize, uDat_Start.Value.ToString("yyyy-MM-dd"), uDat_End.Value.ToString("yyyy-MM-dd")); IList<ClinicarConsultation> list = page != null ? page.Data : new List<ClinicarConsultation>(); SGridViewUtil.BindingData<ClinicarConsultation>(list, this.ucDgv_list.UcDataGridViewControl, displayProperties); return page.TotalRecordCount; }
/// <summary> /// 分页查询 /// </summary> /// <param name="pageNum"></param> /// <param name="pageSize"></param> /// <returns></returns> public SPagintion <ClinicarCheck> FindByPagination(int pageNum, int pageSize, string checkNum, string name, string cardNum) { List <object> listParam = new List <object>(); String whereSql = ""; if (checkNum != null && checkNum.Length > 0) { whereSql += " and check_number like ? "; listParam.Add("%" + checkNum + "%"); } if (name != null && name.Length > 0) { whereSql += " and name like ? "; listParam.Add("%" + name + "%"); } if (cardNum != null && cardNum.Length > 0) { whereSql += " and certificate_number like ? "; listParam.Add("%" + cardNum + "%"); } SPagintion <ClinicarCheck> page = ClinicarCheckDao.FindByPagintion(whereSql, listParam.ToArray(), "check_number desc", pageSize, pageNum); return(page); }
private int FindResult(int pageNum, int pageSize) { SPagintion <ClinicarCheckItem> page = clinicarCheckItemBiz.FindUnCompletedPagination(pageNum, pageSize, check_id); IList <ClinicarCheckItem> list = page != null ? page.Data : new List <ClinicarCheckItem>(); SGridViewUtil.BindingData <ClinicarCheckItem>(list, ucDgvlist, displayProperties); return(page.TotalRecordCount); }
private int FindResult(int pageNum, int pageSize) { SPagintion <ClinicarCheckItem> page = clinicarCheckItemBiz.FindByPagination(pageNum, pageSize, DataEntityId); IList <ClinicarCheckItem> list = page != null ? page.Data : new List <ClinicarCheckItem>(); SGridViewUtil.BindingData <ClinicarCheckItem>(list, this.ucDgv_list.UcDataGridViewControl, displayProperties); return(page.TotalRecordCount); }
private int FindResult(int pageNum, int pageSize) { SPagintion <ClinihospitalDpt> page = ClinihospitalDptBiz.FindByPagination(pageNum, pageSize, this.ucTxt_code.Text, this.ucTxt_name.Text, hospitalcod); IList <ClinihospitalDpt> list = page != null ? page.Data : new List <ClinihospitalDpt>(); SGridViewUtil.BindingData <ClinihospitalDpt>(list, this.ucDgv_list.UcDataGridViewControl, displayProperties); return(page.TotalRecordCount); }
private int FindResult(int pageNum, int pageSize) { SPagintion <ClinicarItem> page = clinicarItemBiz.FindByPagination(1, 9999, this.ucTxt_code.Text, this.ucTxt_name.Text, this.ucTxt_DtpCode.Text, this.ucTxt_DtpName.Text, false); IList <ClinicarItem> list = page != null ? page.Data : new List <ClinicarItem>(); SGridViewUtil.BindingData <ClinicarItem>(list, this.ucDgv_list.UcDataGridViewControl, displayProperties); return(page.TotalRecordCount); }
private int FindResult(int pageNum, int pageSize) { SPagintion <ClinicarCheck> page = clinicarCheckBiz.FindByPagination(pageNum, pageSize, this.ucTxt_checkNumber.Text, this.ucTxt_name.Text, this.ucTxt_cre.Text); IList <ClinicarCheck> list = page != null ? page.Data : new List <ClinicarCheck>(); SGridViewUtil.BindingData <ClinicarCheck>(list, this.ucDgv_list.UcDataGridViewControl, displayProperties); return(page.TotalRecordCount); }
private int FindResult(int pageNum, int pageSize) { SPagintion <SysBaseData> page = SysBaseDataBiz.FindByPagination(pageNum, pageSize, this.ucTxt_code.Text); IList <SysBaseData> list = page != null ? page.Data : new List <SysBaseData>(); SGridViewUtil.BindingData <SysBaseData>(list, this.ucDgv_list.UcDataGridViewControl, displayProperties); return(page.TotalRecordCount); }
/// <summary> /// 刷新子表 /// </summary> private void detailGridSearch(ClinicarItem entity) { if (entity == null) { return; } SPagintion <ClinicarItemDetail> page = clinicarItemDetailBiz.FindByPagination(1, 9999, entity.Id); IList <ClinicarItemDetail> list = page != null ? page.Data : new List <ClinicarItemDetail>(); SGridViewUtil.BindingData <ClinicarItemDetail>(list, this.ucdgv_itemDetail.UcDataGridViewControl, displayPropertiesDetail); }
/// <summary> /// 子表数据分页查询 /// </summary> /// <param name="pageNum"></param> /// <param name="pageSize"></param> /// <returns></returns> public SPagintion <ClinicarCheckResult> FindByPagination(int pageNum, int pageSize, string checkNum) { List <object> listParam = new List <object>(); String whereSql = ""; whereSql += " and deleted=0 and check_number = ? "; listParam.Add(checkNum); SPagintion <ClinicarCheckResult> page = ClinicarCheckResultDao.FindByPagintion(whereSql, listParam.ToArray(), "item_code asc", pageSize, pageNum); return(page); }
/// <summary> /// 分页查询 /// </summary> /// <param name="pageNum"></param> /// <param name="pageSize"></param> /// <returns></returns> public SPagintion <ClinicarItemDetail> FindByPagination(int pageNum, int pageSize, string itemCode) { List <object> listParam = new List <object>(); String whereSql = ""; whereSql += " and item_code = ? "; listParam.Add(itemCode); SPagintion <ClinicarItemDetail> page = ClinicarItemDetailDao.FindByPagintion(whereSql, listParam.ToArray(), "code desc", pageSize, pageNum); return(page); }
/// <summary> /// 子表数据分页查询 /// </summary> /// <param name="pageNum"></param> /// <param name="pageSize"></param> /// <returns></returns> public SPagintion <ClinicarCheckItem> FindByPagination(int pageNum, int pageSize, int checkId) { List <object> listParam = new List <object>(); String whereSql = ""; whereSql += " and deleted=0 and check_id = ? "; listParam.Add(checkId); SPagintion <ClinicarCheckItem> page = ClinicarCheckItemDao.FindByPagintion(whereSql, listParam.ToArray(), "id desc", pageSize, pageNum); return(page); }
/// <summary> /// 子表数据分页查询 /// </summary> /// <param name="pageNum"></param> /// <param name="pageSize"></param> /// <returns></returns> public SPagintion <ClinicarCheckResult> FindByPagination(int pageNum, int pageSize, string checkNum, string itemCode) { List <object> listParam = new List <object>(); String whereSql = ""; whereSql += " and IFNULL(item_detail_name,'') not in ('Ref Group','Blood Mode','Take Mode') and deleted=0 and check_number = ? and item_code = ? "; listParam.Add(checkNum); listParam.Add(itemCode); SPagintion <ClinicarCheckResult> page = ClinicarCheckResultDao.FindByPagintion(whereSql, listParam.ToArray(), "create_time desc", pageSize, pageNum); return(page); }
/// <summary> /// 分页查询 /// </summary> /// <param name="pageNum"></param> /// <param name="pageSize"></param> /// <returns></returns> public SPagintion <ClinicarAllCheck> FindByPagination(int pageNum, int pageSize, string checkNumber) { List <object> listParam = new List <object>(); String whereSql = ""; if (checkNumber != null && checkNumber.Length > 0) { whereSql += " and check_number like ? "; listParam.Add("%" + checkNumber + "%"); } SPagintion <ClinicarAllCheck> page = ClinicarAllCheckDao.FindByPagintion(whereSql, listParam.ToArray(), "id desc", pageSize, pageNum); return(page); }
/// <summary> /// 分页查询 /// </summary> /// <param name="pageNum"></param> /// <param name="pageSize"></param> /// <returns></returns> public SPagintion <SysBaseData> FindByPagination(int pageNum, int pageSize, string code) { List <object> listParam = new List <object>(); String whereSql = ""; if (code != null && code.Length > 0) { whereSql += " and code like ? "; listParam.Add("%" + code + "%"); } SPagintion <SysBaseData> page = SysBaseDataDao.FindByPagintion(whereSql, listParam.ToArray(), "code asc", pageSize, pageNum); return(page); }
/// <summary> /// 行改变监听事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void dgrdViewLeft_SelectionChanged(object sender, EventArgs e) { ClinicarCheck entity = this.GetCurrentRowData(); if (entity == null || Convert.IsDBNull(entity)) { return; } //检查科室表格绑定数据 SPagintion <ClinicarCheckItem> page = clinicarCheckItemBiz.FindByPagination(1, 100, Convert.ToInt32(entity.Id)); IList <ClinicarCheckItem> list = page != null ? page.Data : new List <ClinicarCheckItem>(); SGridViewUtil.BindingData <ClinicarCheckItem>(list, this.dataGridView_Dtp.UcDataGridViewControl, displayPropertiesCenter); }
private int FindResult(int pageNum, int pageSize) { //检查科室表格绑定数据 SPagintion <ClinicarCheck> page = clinicarCheckBiz.FindByPagination(1, 999, uTxt_checkNumber.Text.Trim(), "", entityCheckTransmit.CertificateNumber == null?"": entityCheckTransmit.CertificateNumber); IList <ClinicarCheck> list = page != null ? page.Data : new List <ClinicarCheck>(); SGridViewUtil.BindingData <ClinicarCheck>(list, this.ucDgv_listLeft.UcDataGridViewControl, displayPropertiesLeft); if (list == null || Convert.IsDBNull(list) || list.Count <= 0) { dgrdViewCenter.DataSource = null; dgrdViewRight.DataSource = null; } return(page.TotalRecordCount); }
/// <summary> /// 根据检查号和项目编号分页查询 /// </summary> /// <param name="pageNum"></param> /// <param name="pageSize"></param> /// <returns></returns> public SPagintion <ClinicarCheckResult> FindByNumAndItem(int pageNum, int pageSize, string checkNum, string itemCode) { List <object> listParam = new List <object>(); String whereSql = ""; if (!string.IsNullOrWhiteSpace(checkNum)) { whereSql += " and check_number = ? "; listParam.Add(checkNum); } whereSql += " and deleted=0 and item_code = ? "; listParam.Add(itemCode); SPagintion <ClinicarCheckResult> page = ClinicarCheckResultDao.FindByPagintion(whereSql, listParam.ToArray(), "id desc", pageSize, pageNum); return(page); }
/// <summary> /// 分页查询 /// </summary> /// <param name="pageNum"></param> /// <param name="pageSize"></param> /// <returns></returns> public SPagintion <ClinicarHospital> FindByPagination(int pageNum, int pageSize, string hospitalCode, string hospitalName) { List <object> listParam = new List <object>(); String whereSql = ""; if (hospitalCode != null && hospitalCode.Length > 0) { whereSql += " and hospitalcode like ? "; listParam.Add("%" + hospitalCode + "%"); } if (hospitalName != null && hospitalName.Length > 0) { whereSql += " and hospitalname like ? "; listParam.Add("%" + hospitalName + "%"); } SPagintion <ClinicarHospital> page = ClinicarHospitalDao.FindByPagintion(whereSql, listParam.ToArray(), "hospitalcode desc", pageSize, pageNum); return(page); }
/// <summary> /// 分页查询 /// </summary> /// <param name="pageNum"></param> /// <param name="pageSize"></param> /// <returns></returns> public SPagintion <SysUser> FindByPagination(int pageNum, int pageSize, string code, string name) { List <object> listParam = new List <object>(); String whereSql = ""; if (code != null && code.Length > 0) { whereSql += " and code like ? "; listParam.Add("%" + code + "%"); } if (name != null && name.Length > 0) { whereSql += " and name like ? "; listParam.Add("%" + name + "%"); } SPagintion <SysUser> page = SysUserDao.FindByPagintion(whereSql, listParam.ToArray(), "id desc", pageSize, pageNum); return(page); }
/// <summary> /// 分页查询 /// </summary> /// <param name="pageNum"></param> /// <param name="pageSize"></param> /// <returns></returns> public SPagintion <ClinicarConsultation> FindByPagination(int pageNum, int pageSize, string beginDate, string endDate) { List <object> listParam = new List <object>(); String whereSql = ""; //if (beginDate != null && beginDate.Length > 0 && endDate != null && endDate.Length > 0) //{ // whereSql += " and sechedulDate between ? and ? "; // listParam.Add(beginDate); // listParam.Add(endDate); //} whereSql += " and DATE_FORMAT(applyhospitaldate,'%Y-%m-%d') between ? and ? "; listParam.Add(beginDate); listParam.Add(endDate); SPagintion <ClinicarConsultation> page = ClinicarConsultationDao.FindByPagintion(whereSql, listParam.ToArray(), "applyhospitaldate desc", pageSize, pageNum); return(page); }
/// <summary> /// 分页查询 /// </summary> /// <param name="pageNum"></param> /// <param name="pageSize"></param> /// <returns></returns> public SPagintion <SysUser> FindByPagination(int pageNum, int pageSize, string username, string fullName) { List <object> listParam = new List <object>(); String whereSql = ""; if (username != null && username.Length > 0) { whereSql += " and username like ? "; listParam.Add("%" + username + "%"); } if (fullName != null && fullName.Length > 0) { whereSql += " and fullName like ? "; listParam.Add("%" + fullName + "%"); } SPagintion <SysUser> page = SysUserDao.FindByPagintion(whereSql, listParam.ToArray(), "id desc", pageSize, pageNum); return(page); }
/// <summary> /// 分页查询 /// </summary> /// <param name="pageNum"></param> /// <param name="pageSize"></param> /// <returns></returns> public SPagintion <ClinicarDptSechedul> FindByPagination(int pageNum, int pageSize, string deptCode, string beginDate, string endDate) { List <object> listParam = new List <object>(); String whereSql = ""; if (deptCode != null && deptCode.Length > 0) { whereSql += " and deptCode like ? "; listParam.Add("%" + deptCode + "%"); } if (beginDate != null && beginDate.Length > 0 && endDate != null && endDate.Length > 0) { whereSql += " and sechedulDate between ? and ? "; listParam.Add(beginDate); listParam.Add(endDate); } SPagintion <ClinicarDptSechedul> page = ClinicarDptSechedulDao.FindByPagintion(whereSql, listParam.ToArray(), "code desc", pageSize, pageNum); return(page); }
/// <summary> /// 分页查询 /// </summary> /// <param name="whereHql">以and开始,例如"and name=?"</param> /// <param name="whereParams">对应whereHql的参数(?)</param> /// <param name="orderSql">排序sql,例如"name desc, id desc"</param> /// <param name="pageSize">每页显示条数</param> /// <param name="pageNo">要查询的页数</param> /// <returns></returns> public static SPagintion <T> FindByPagintion(string _whereHql, object[] _whereParams, string _orderSql, int _pageSize, int _pageNo) { try { if (_pageNo < 1) { _pageNo = 1; } Type tt = typeof(T); SPagintion <T> page = new SPagintion <T>(); page.WhereSql = _whereHql; page.WhereParams = _whereParams; page.OrderSql = _orderSql; page.PageSize = _pageSize; page.CurrentPageNum = _pageNo; string filter = "1=1 " + page.WhereSql; page.TotalRecordCount = ActiveRecordBase.Count(tt, filter, page.WhereParams);//获得总条数 if (page.TotalRecordCount > 0) { string hql = "FROM " + tt.Name + " WHERE " + filter; if (page.OrderSql != null && page.OrderSql.Trim().Length > 0) { hql += " ORDER BY " + page.OrderSql; } SimpleQuery <T> sq = new SimpleQuery <T>(hql, page.WhereParams); int startRecordNum = (page.CurrentPageNum - 1) * page.PageSize; sq.SetQueryRange(startRecordNum, page.PageSize);// Mysql是分页语句 page.Data = (IList <T>)ActiveRecordBase.ExecuteQuery(sq); } return(page); } catch (Exception err) { throw err; } }
/// <summary> /// 根据检查号回填信息 /// </summary> private void fillByCheckNum() { if (DataEntity != null && Convert.IsDBNull(DataEntity) == false) { label8.Text = DataEntity.CheckNumber; uTxt_name.Text = DataEntity.Name; uTxt_genderName.Text = DataEntity.GenderName; uNum_age.Text = DataEntity.Age.ToString(); uTxt_maritalStatusName.Text = DataEntity.MaritalStatusName; uTxt_nationalityName.Text = DataEntity.NationalityName; uTxt_checkNumber.Text = DataEntity.CheckNumber; //检查科室表格绑定数据 SPagintion <ClinicarCheckItem> page = clinicarCheckItemBiz.FindByPagination(1, 100, Convert.ToInt32(DataEntity.Id)); IList <ClinicarCheckItem> list = page != null ? page.Data : new List <ClinicarCheckItem>(); SGridViewUtil.BindingData <ClinicarCheckItem>(list, this.ucDgv_listLeft.UcDataGridViewControl, displayPropertiesLeft); } else { UcMessageBox.Warning("所查询的检查号不存在.", "提示!"); } }
/// <summary> /// /// </summary> private void showResult(ClinicarCheckItem entity) { //检查结果表格绑定数据 SPagintion <ClinicarCheckResult> page = clinicarCheckResultBiz.FindByPagination(1, 100, uTxt_checkNumber.Text.Trim(), entity.ItemCode); IList <ClinicarCheckResult> list = page != null ? page.Data : new List <ClinicarCheckResult>(); this.imageOrPdfPath = string.Empty; //数据类展示(表格) if (Util.showType(entity.DptName).Equals(Util.data)) { //添加数据标签页 tabControl1.TabPages.Insert(0, tabPage1); //结果表有数据则查询结果表,没有数据则查询项目表 if (list != null && Convert.IsDBNull(list) == false && list.Count > 0) { //不自动生成列 this.dataGridView_Result.AutoGenerateColumns = false; this.dataGridView_Result.DataSource = list; this.f_blEdit = true; } else { SPagintion <ClinicarItemDetail> pageItem = clinicarItemDetailBiz.FindByPagination(1, 100, entity.ItemCode); IList <ClinicarItemDetail> listItem = pageItem != null ? pageItem.Data : new List <ClinicarItemDetail>(); //不自动生成列 this.dataGridView_Result.AutoGenerateColumns = false; this.dataGridView_Result.DataSource = listItem; this.f_blEdit = false; } } //图片类展示 else if (Util.showType(entity.DptName).Equals(Util.image)) { //添加图片类标签页 tabControl1.TabPages.Insert(0, tabPage2); //加载图片 if (list != null && Convert.IsDBNull(list) == false && list.Count > 0) { if (list[0].AttachmentPath != null && !list[0].AttachmentPath.Equals("")) { this.label9.Visible = false; try { pictureBox1.Image = Image.FromFile(Util.basePath + list[0].AttachmentPath); this.imageOrPdfPath = list[0].AttachmentPath; } catch { pictureBox1.Image = null; this.label9.Visible = true; } } else { pictureBox1.Image = null; this.label9.Visible = true; } } else { pictureBox1.Image = null; this.label9.Visible = true; } } //pdf类展示 else if (Util.showType(entity.DptName).Equals(Util.pdf)) { //添加pdf类标签页 tabControl1.TabPages.Insert(0, tabPage3); //加载pdf if (list != null && Convert.IsDBNull(list) == false && list.Count > 0) { if (list[0].AttachmentPath != null && !list[0].AttachmentPath.Equals("")) { this.label10.Visible = false; try { if (list[0].AttachmentPath.ToString().ToLower().EndsWith(".pdf")) { axAcroPDF1.LoadFile(Util.basePath + list[0].AttachmentPath); this.imageOrPdfPath = list[0].AttachmentPath; } else { axAcroPDF1.LoadFile(""); this.label10.Visible = true; } } catch { axAcroPDF1.LoadFile(""); this.label10.Visible = true; } } else { axAcroPDF1.LoadFile(""); this.label10.Visible = true; } } else { axAcroPDF1.LoadFile(""); this.label10.Visible = true; } } }