IList <decimal> IDataAccess.GetAccessibleReports() { if (userRepository.HasAllReportAccess(this.CurrentUserId) > 0) { IList <Report> list = new EntityRepository <Report>().GetAll(); var ids = from obj in list select obj.ID; return(ids.ToList <decimal>()); } else { BReport bReport = new BReport(); List <decimal> reportList = new List <decimal>(); List <decimal> childAndParentsList = new List <decimal>(); reportList.AddRange(userRepository.GetUserReportIdList(this.CurrentUserId)); foreach (decimal reportId in reportList)//اضافه کردن بچه ها و والد ها { IList <Report> childs = new List <Report>(); childs = bReport.GetReportChildsByParentPath(reportId); childAndParentsList.AddRange(bReport.GetByID(reportId).ParentPathList); var ids = from child in childs select child.ID; childAndParentsList.AddRange(ids.ToList <decimal>()); } reportList.AddRange(childAndParentsList); return(reportList); } }
public void TestSetup() { report_testObject = new Report(); busReport = new BReport(); DatabaseGateway.TA_ReportDataTable reportTable = new DatabaseGateway.TA_ReportDataTable(); reportTable = reportTA.GetRoot(); if (reportTable.Rows.Count == 0) { reportTA.Insert("TestRoot", 0, "", null, false); reportTable = reportTA.GetRoot(); } ADOReportRoot.ID = Convert.ToInt32(reportTable.Rows[0]["report_ID"]); ADOReportRoot.ParentId = Utility.ToInteger(reportTable.Rows[0]["report_ParentID"]); ADOReportRoot.Name = Convert.ToString(reportTable.Rows[0]["report_Name"]); reportTA.Insert("TestReport1", ADOReportRoot.ID, "", null, false); reportTA.Insert("TestReport2", ADOReportRoot.ID, "", null, false); reportTable = reportTA.GetDataByName("TestReport1"); ADOReport1.ID = Convert.ToInt32(reportTable.Rows[0]["report_ID"]); ADOReport1.ParentId = Utility.ToInteger(reportTable.Rows[0]["report_ParentID"]); ADOReport1.Name = Convert.ToString(reportTable.Rows[0]["report_Name"]); reportTable = reportTA.GetDataByName("TestReport2"); ADOReport2.ID = Convert.ToInt32(reportTable.Rows[0]["report_ID"]); ADOReport2.ParentId = Utility.ToInteger(reportTable.Rows[0]["report_ParentID"]); ADOReport2.Name = Convert.ToString(reportTable.Rows[0]["report_Name"]); reportFileTA.Insert("TestReportFile1", "xml"); reportFileTA.Insert("TestReportFile2", "xml"); DatabaseGateway.TA_ReportFileDataTable reportFileDT = new DatabaseGateway.TA_ReportFileDataTable(); reportFileDT = reportFileTA.GetDataByName("TestReportFile1"); ADOReportFile1.ID = Convert.ToInt32(reportFileDT.Rows[0]["reportfile_ID"]); ADOReportFile1.Name = Convert.ToString(reportFileDT.Rows[0]["reportfile_Name"]); reportFileDT = reportFileTA.GetDataByName("TestReportFile2"); ADOReportFile2.ID = Convert.ToInt32(reportFileDT.Rows[0]["reportfile_ID"]); ADOReportFile2.Name = Convert.ToString(reportFileDT.Rows[0]["reportfile_Name"]); reportTA.Insert("TestReport3", ADOReport2.ID, "", ADOReportFile2.ID, true); reportTable = reportTA.GetDataByName("TestReport3"); ADOReport3.ID = Convert.ToInt32(reportTable.Rows[0]["report_ID"]); ADOReport3.ParentId = Utility.ToInteger(reportTable.Rows[0]["report_ParentID"]); ADOReport3.Name = Convert.ToString(reportTable.Rows[0]["report_Name"]); ADOReport3.ReportFile = new ReportFile() { ID = ADOReportFile2.ID }; ADOReport3.IsReport = true; }
/// <summary> /// Add Events To Cache /// </summary> /// <returns>Operating Events</returns> private List <OpEventInfo> AddEventsToCache() { try { var userData = UserData; var cacheKey = WebUtility.GetCacheKeyName(userData, "operating-events"); HttpRuntime.Cache.Remove(cacheKey); if (LscsComboBox.SelectedItem == null) { return(null); } var ids = WebUtility.ItemSplit(LscsComboBox.SelectedItem.Value); if (ids.Length != 2) { return(null); } var lscId = Int32.Parse(ids[0]); var groupId = Int32.Parse(ids[1]); var lscName = LscsComboBox.SelectedItem.Text; var lscUser = userData.LscUsers.Find(lu => { return(lu.LscID == lscId); }); if (lscUser == null) { return(null); } var fromTime = DateTime.Parse(FromDate.Text); var toTime = DateTime.Parse(ToDate.Text); var userType = WebUtility.DefaultInt32; var userId = lscUser.UserID; string[] eventTypes = null; string[] eventDescs = null; if (EventTypeMultiCombo.SelectedItems.Count > 0) { eventTypes = new string[EventTypeMultiCombo.SelectedItems.Count]; for (int i = 0; i < eventTypes.Length; i++) { eventTypes[i] = EventTypeMultiCombo.SelectedItems[i].Text; } } if (!String.IsNullOrEmpty(EventDescField.Text.Trim())) { eventDescs = WebUtility.StringSplit(EventDescField.Text.Trim()); } var reportEntity = new BReport(); var events = reportEntity.GetOpEvents(lscId, lscName, fromTime, toTime, userType, userId, eventTypes, eventDescs); var cacheDuration = Int32.Parse(WebConfigurationManager.AppSettings["DefaultCacheDuration"]); HttpRuntime.Cache.Insert(cacheKey, events, null, Cache.NoAbsoluteExpiration, TimeSpan.FromSeconds(cacheDuration), CacheItemPriority.Default, null); return(events); } catch { throw; } }
private void dgv_WorkList_Click(object sender, EventArgs e) { if (this.dgv_WorkList.Rows.Count == 0 || this.dgv_WorkList.SelectedRows.Count == 0) { return; } string ExamAccessionNum = this.dgv_WorkList.CurrentRow.Cells["EXAM_ACCESSION_NUM"].Value.ToString(); BReport br = new BReport(); mrpt = (MReport)br.GetModel(ExamAccessionNum); Path = TemDir + ExamAccessionNum + ".doc"; if (!File.Exists(Path)) { fOpe.FileSave(mrpt.REPORT_NAME, Path); } }
private void lv_Patient_MouseDoubleClick(object sender, MouseEventArgs e) { ListViewItem lvi = lv_Patient.GetItemAt(e.X, e.Y); if (lvi == null) return; if (lvi.ImageIndex != 1) return; BWorkList bwk = new BWorkList(); MWorkList mwk = (MWorkList)bwk.GetModel(lvi.Tag.ToString()); BReport brt = new BReport(); MReport mrt = (MReport)brt.GetModel(lvi.Tag.ToString()); ImageCopy ic = new ImageCopy(); string saveDir = System.Windows.Forms.Application.StartupPath + "\\temp"; List<ImgObj> arrayImg = ic.LoadImages(mwk, saveDir); frmReportEdit frmRE = new frmReportEdit(); frmRE.initForm(mwk, mrt,ILL.GetConfig.RS_OpenWord); frmRE.ShowDialog(); }
/// <summary> /// Add Data To Cache /// </summary> private List <PicInfo> AddDataToCache() { try { var userData = UserData; var cacheKey = WebUtility.GetCacheKeyName(userData, "his-pictures"); HttpRuntime.Cache.Remove(cacheKey); if (LscsComboBox.SelectedItem == null) { return(null); } var ids = WebUtility.ItemSplit(LscsComboBox.SelectedItem.Value); if (ids.Length != 2) { return(null); } var lscId = Int32.Parse(ids[0]); var groupId = Int32.Parse(ids[1]); var lscUser = userData.LscUsers.Find(lu => { return(lu.LscID == lscId); }); if (lscUser == null) { return(null); } var reportEntity = new BReport(); var otherEntity = new BOther(); var fromTime = DateTime.Parse(FromDate.Text); var toTime = DateTime.Parse(ToDate.Text); string[] picModels = null; if (PicTypeMultiCombo.SelectedItems.Count > 0) { picModels = new string[PicTypeMultiCombo.SelectedItems.Count]; for (int i = 0; i < picModels.Length; i++) { picModels[i] = PicTypeMultiCombo.SelectedItems[i].Text; } } var pics = reportEntity.GetHisPictures(lscUser.LscID, fromTime, toTime, picModels); if (pics.Count > 0) { var rtus = otherEntity.GetRtus(lscUser.LscID, lscUser.Group.GroupID); pics = (from pic in pics join rtu in rtus on pic.RtuID equals rtu.RtuID where (Area2ComboBox.SelectedIndex == 0 || rtu.Area2Name.Equals(Area2ComboBox.SelectedItem.Text)) && (Area3ComboBox.SelectedIndex == 0 || rtu.Area3Name.Equals(Area3ComboBox.SelectedItem.Text)) && (StaComboBox.SelectedIndex == 0 || rtu.StaName.Equals(StaComboBox.SelectedItem.Text)) && (DevComboBox.SelectedIndex == 0 || rtu.DevName.Equals(DevComboBox.SelectedItem.Text)) orderby pic.PicTime descending select new PicInfo { LscID = rtu.LscID, LscName = rtu.LscName, RtuID = pic.RtuID, PicID = pic.PicID, PicName = String.Format("{0}-{1}-{2}", rtu.StaName, rtu.StaMID, WebUtility.GetDateString(pic.PicTime)), PicModel = pic.PicModel, PicBytes = pic.PicBytes, PicTime = pic.PicTime }).ToList(); } var cacheDuration = Int32.Parse(WebConfigurationManager.AppSettings["DefaultCacheDuration"]); HttpRuntime.Cache.Insert(cacheKey, pics, null, Cache.NoAbsoluteExpiration, TimeSpan.FromSeconds(cacheDuration), CacheItemPriority.Default, null); return(pics); } catch { throw; } }
/// <summary> /// Add Data To Cache /// </summary> private List <AccessRecordInfo> AddDataToCache() { try { var userData = UserData; var cacheKey = WebUtility.GetCacheKeyName(userData, "access-records"); HttpRuntime.Cache.Remove(cacheKey); if (LscsComboBox.SelectedItem == null) { return(null); } var ids = WebUtility.ItemSplit(LscsComboBox.SelectedItem.Value); if (ids.Length != 2) { return(null); } var lscId = Int32.Parse(ids[0]); var groupId = Int32.Parse(ids[1]); var lscName = LscsComboBox.SelectedItem.Text; var lscUser = userData.LscUsers.Find(lu => { return(lu.LscID == lscId); }); if (lscUser == null) { return(null); } var area2Name = WebUtility.DefaultString; var area3Name = WebUtility.DefaultString; var staName = WebUtility.DefaultString; var devName = WebUtility.DefaultString; var fromTime = DateTime.Parse(FromDate.Text); var toTime = DateTime.Parse(ToDate.Text); string[] empNames = null; string[] punchs = null; if (Area2ComboBox.SelectedIndex > 0) { area2Name = Area2ComboBox.SelectedItem.Text; } if (Area3ComboBox.SelectedIndex > 0) { area3Name = Area3ComboBox.SelectedItem.Text; } if (StaComboBox.SelectedIndex > 0) { staName = StaComboBox.SelectedItem.Text; } if (DevComboBox.SelectedIndex > 0) { devName = DevComboBox.SelectedItem.Text; } if (!String.IsNullOrEmpty(EmpNameField.Text.Trim())) { empNames = WebUtility.StringSplit(EmpNameField.Text.Trim()); } if (!String.IsNullOrEmpty(AccessNOField.Text.Trim())) { punchs = WebUtility.StringSplit(AccessNOField.Text.Trim()); } var reportEntity = new BReport(); var records = reportEntity.GetAccessRecords(lscId, lscName, fromTime, toTime, area2Name, area3Name, staName, devName, empNames, punchs); if (records.Count > 0) { records = (from rec in records join gNode in lscUser.Group.GroupNodes on rec.DevID equals gNode.NodeID orderby rec.PunchTime select rec).ToList(); } var cacheDuration = Int32.Parse(WebConfigurationManager.AppSettings["DefaultCacheDuration"]); HttpRuntime.Cache.Insert(cacheKey, records, null, Cache.NoAbsoluteExpiration, TimeSpan.FromSeconds(cacheDuration), CacheItemPriority.Default, null); return(records); } catch { throw; } }