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; }
}
