private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e) { ArranageRecordFacade arrageRecordFacade = new ArranageRecordFacade(); string id = officeId; DataSet dsArrange = arrageRecordFacade.FindArrangeInfoByOfficeId(officeId, DateTime.Now.AddDays(7)); //"1130" officeId string Doctors = SkyComm.getvalue("不能挂号的医生USERID"); string[] ArrDoctor = Doctors.Split(','); foreach (DataRow row in dsArrange.Tables[0].Rows) { if (row.RowState == DataRowState.Deleted) { continue; } if (ArrDoctor.Contains(row["DOCTORID"].ToString())) { row.Delete(); } } dsArrange.AcceptChanges(); if (dsArrange.Tables.Count > 0 && dsArrange.Tables[0].Rows.Count > 0) { //此处将医生排序 string mDoctorConfig1 = SkyComm.getvalue("专家挂号"); string mDoctorConfig2 = SkyComm.getvalue("普通挂号"); if (string.IsNullOrEmpty(mDoctorConfig1)) { e.Result = dsArrange; } else { e.Result = mDoctorChoosePresenter.getNewSortDataSet(dsArrange); } } }
private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e) { ArranageRecordFacade of = new ArranageRecordFacade(); ds = of.FindAllArrangeInfo(SysOperatorInfo.OperatorAreaid, 1); string Offices = SkyComm.getvalue("不能挂号的科室"); string[] arrOffice = Offices.Split(','); foreach (DataRow row in ds.Tables[0].Rows) { if (row.RowState == DataRowState.Deleted) { continue; } if (arrOffice.Contains(row["OFFICEID"].ToString())) { row.Delete(); } } ds.AcceptChanges(); if (string.IsNullOrEmpty(SkyComm.getvalue("预约挂号一级科室分类"))) { } else { ds = mOfficeChoosePresenter.fliterLevelTwoOfficeDataSet(mLevelOneOficeName, ds); } //OfficeFacade officeFacade = new OfficeFacade(); //ds = officeFacade.QueryByOfficeType(34, SysOperatorInfo.OperatorAreaid); }
/// <summary> /// 获取E_TECHNICALPOST表中的REGISTERTYPEID /// </summary> /// <param name="role">TECHNICALPOST</param> /// <returns></returns> public string getRegisterTypeId(string role) { ArranageRecordFacade arrageRecordFacade = new ArranageRecordFacade(); DataSet dataSet = arrageRecordFacade.getRegisterTypeId(role); string mRegisterTypeId = ""; if (dataSet == null || dataSet.Tables[0].Rows.Count == 0) { return(""); } mRegisterTypeId = dataSet.Tables[0].Rows[0]["REGISTERTYPEID"].ToString(); return(mRegisterTypeId); }
private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e) { ArranageRecordFacade arrangeFac = new ArranageRecordFacade(); DataSet dsArrage = arrangeFac.FindArrageDetailByarrangerecordId(detailId); int ReservedDays = Convert.ToInt32(SystemInfo.SystemConfigs["预约预留现场当天号源个数"].DefaultValue); if (dsArrage.Tables.Count > 0 && dsArrage.Tables[0].Rows.Count > 0) { if (Convert.ToDateTime(BespeakDataset.Tables[0].Rows[0]["BESPEAKDATE"].ToString()).Date != DateTime.Now.Date) { dsArrage.Tables[0].DefaultView.RowFilter = "QUEUEID>" + ReservedDays + ""; } e.Result = mTimeDetailChoosePresenter.reArrayDatas(dsArrage).Tables[0].DefaultView.ToTable();//号源重新安排 // e.Result = dsArrage.Tables[0].DefaultView.ToTable(); } }