public byte[] GetReport(ReportFilter reportFilter)
{
//Querying with Object Services and Entity SQL
/*string sqlString = "SELECT VALUE st FROM SchoolDBEntities.Students " +
* "AS st WHERE st.StudentName == 'Bill'";
*
* var objctx = (ctx as IObjectContextAdapter).ObjectContext;
*
* ObjectQuery<Student> student = objctx.CreateQuery<Student>(sqlString);
* Student newStudent = student.First<Student>();*/
using (var command = _context.Database.GetDbConnection().CreateCommand())
{
command.CommandText = "query";
command.CommandType = CommandType.Text;
_context.Database.OpenConnection();
using (var result = command.ExecuteReader())
{
//var entities = new List<T>();
while (result.Read())
{
result[0].ToString();
//entities.Add(map(result));
}
//return entities;
}
}
var workbook = new XLWorkbook();
IXLWorksheet worksheet = workbook.Worksheets.Add("Authors");
worksheet.Cell(1, 1).Value = "Id";
worksheet.Cell(1, 2).Value = "FirstName";
worksheet.Cell(1, 3).Value = "LastName";
for (int index = 1; index <= 3; index++)
{
worksheet.Cell(index + 1, 1).Value = (index + 1) * index;
worksheet.Cell(index + 1, 2).Value = (index + 2) * index;
worksheet.Cell(index + 1, 3).Value = (index + 3) * index;
}
using (var stream = new MemoryStream())
{
workbook.SaveAs(stream);
var content = stream.ToArray();
return(content);
//return File(content, contentType, fileName);
}
//return null;
}
public IActionResult GetCustomerInvoices([FromBody] ReportFilter filter)
{
return(Ok(reportService.GetCustomerInvoices(filter)));
}
public IActionResult GetProductSaleDetail(long productId, [FromBody] ReportFilter filter)
{
return(Ok(reportService.GetProductSaleDetail(productId, filter)));
}
public void BindData(ReportFilter rp)
{
}
public IActionResult GetProfitAndLostDetail([FromBody] ReportFilter filter)
{
return(Ok(reportService.GetProfitAndLostDetail(filter)));
}
/// <summary>
/// Updates the filters.
/// </summary>
/// <param name="reportFilter">The report filter.</param>
/// <param name="menuItem">The menu item.</param>
private static void UpdateFilters(ReportFilter reportFilter, string menuItem)
{
if (!string.IsNullOrEmpty(menuItem))
{
if (menuItem.Equals(ReportOption.ProjectTeamMemberAllocation.ToString()))
{
reportFilter.DateTo = reportFilter.DateFrom.AddDays(ApplicationSettings.Instance.DashboardAllocationGraphDayDuration);
}
else if (menuItem.Equals(ReportOption.WeeklyProjectHourBurndown.ToString()) || menuItem.Equals(ReportOption.ProjectHourBreakdown.ToString()))
{
reportFilter.DateFrom = DateTimeHelper.RetrieveCurrentDate().RetrieveLastWeekStartDate();
reportFilter.DateTo = DateTimeHelper.RetrieveCurrentDateTime().RetrieveLastWeekStartDate().AddDays(6);
}
}
}
/// <summary>
/// Updates the filters.
/// </summary>
/// <param name="reportFilter">The report filter.</param>
/// <param name="menuItem">The menu item.</param>
private void UpdateFilters(ReportFilter reportFilter, string menuItem)
{
if (menuItem != null)
{
if (menuItem.Equals(ReportOption.ProjectHoursAnalysisDrillDown.ToString()) || menuItem.Equals(ReportOption.ProjectHoursAnalysis.ToString()) || menuItem.Equals(ReportOption.ProductivityGraph.ToString()) || menuItem.Equals(ReportOption.ProjectHoursGraph.ToString()) || menuItem.Equals(ReportOption.Feedback.ToString()))
{
reportFilter.DateFrom = reportFilter.DateTo.AddMonths(-1);
}
else if (menuItem.Equals(ReportOption.TeamMemberHours.ToString()))
{
reportFilter.DateFrom = this.timesheetService.RetrieveApplicableDate(true, DateTimeHelper.RetrieveCurrentDateTime(), SessionData.Instance.UserInfo.Developer.DeveloperID);
reportFilter.DateTo = reportFilter.DateFrom;
}
else if (menuItem.Equals(ReportOption.TimesheetDefaulters.ToString()) || menuItem.Equals(ReportOption.MyConVsTimesheetWebsite.ToString()))
{
reportFilter.DateFrom = this.timesheetService.RetrieveApplicableDate(false, DateTimeHelper.RetrieveCurrentDateTime(), SessionData.Instance.UserInfo.Developer.DeveloperID);
reportFilter.DateTo = reportFilter.DateFrom;
}
else if (menuItem.Equals(ReportOption.DailyReport.ToString()))
{
reportFilter.DateFrom = this.timesheetService.RetrieveApplicableDate(true, DateTimeHelper.RetrieveCurrentDateTime(), SessionData.Instance.UserInfo.Developer.DeveloperID);
reportFilter.DateTo = DateTimeHelper.RetrieveCurrentDate();
}
else if (menuItem.Equals(ReportOption.WeeklyProjectHourBurndown.ToString()) || menuItem.Equals(ReportOption.WeeklyProjectStatus.ToString()) || menuItem.Equals(ReportOption.ProjectHourBreakdown.ToString()) || menuItem.Equals(ReportOption.ProjectComplianceStatus.ToString()) || menuItem.Equals(ReportOption.TrendForProjectAndNonProjectHours.ToString()))
{
reportFilter.DateFrom = DateTimeHelper.RetrieveCurrentDate().RetrieveLastWeekStartDate();
reportFilter.DateTo = DateTimeHelper.RetrieveCurrentDateTime().RetrieveLastWeekStartDate().AddDays(6);
}
else if (menuItem.Equals(ReportOption.ProjectTeamMemberAllocationReport.ToString()) || menuItem.Equals(ReportOption.ProjectTeamMemberAllocation.ToString()) || menuItem.Equals(ReportOption.RoleProjectAllocation.ToString()) || menuItem.Equals(ReportOption.RoleAllocation.ToString()) || menuItem.Equals(ReportOption.ProjectAllocation.ToString()) || menuItem.Equals(ReportOption.RoleAllocationDrillDown.ToString()) || menuItem.Equals(ReportOption.RoleWiseAllocation.ToString()))
{
reportFilter.DateFrom = DateTimeHelper.RetrieveCurrentDate();
reportFilter.DateTo = reportFilter.DateFrom.AddDays(ApplicationSettings.Instance.DashboardAllocationGraphDayDuration);
}
else if (menuItem.Equals(ReportOption.NameLeaveRoaster.ToString()) || menuItem.Equals(ReportOption.HrLeaveRoaster.ToString()) || menuItem.Equals(ReportOption.TeamLeaveRoaster.ToString()) || menuItem.Equals(ReportOption.SalarySheet.ToString()) || menuItem.Equals(ReportOption.SpecialLeave.ToString()))
{
reportFilter.DateFrom = reportFilter.DateFromYear = reportFilter.DateFrom.RetrieveCurrentMonthStartDate();
}
else if (menuItem.Equals(ReportOption.SwipeInOut.ToString()) || menuItem.Equals(ReportOption.CardCompliance.ToString()))
{
reportFilter.DateFrom = reportFilter.DateTo.AddDays(-6);
}
if (menuItem.Equals(ReportOption.ProjectTeamMemberAllocationReport.ToString()) || menuItem.Equals(ReportOption.ProjectTeamMemberAllocation.ToString()) || menuItem.Equals(ReportOption.RoleProjectAllocation.ToString()))
{
reportFilter.SelectedRoleGroup = -1;
}
}
}
public ActionResult formSubmit(ReportView model, string actionType)
{
List <string> errorMessage = new List <string>();
string successMessage = Resources.NotifResource.DataSuccess;
SessionForSP sessionParam = new SessionForSP();
sessionParam.CurrentUserID = new Guid(Session["CurrentUserID"].ToString());
Guid tempDuplicateID = Guid.Empty;
if (ModelState.IsValid)
{
KeyValuePair <int, string> results = new KeyValuePair <int, string>(1, "");
model.ModifiedBy = new Guid(Session["CurrentUserID"].ToString());
if (actionType == "Create")
{
model.ID = Guid.NewGuid();
model.CreatedBy = new Guid(Session["CurrentUserID"].ToString());
Guid SecurityRoleID = new Guid(Session["RoleID"].ToString());
results = db.Report_Insert(model, SecurityRoleID);
Guid entityID = new Guid(model.EntityID.ToString());
string entityType = db.entity.Where(x => x.ID == model.EntityID).FirstOrDefault().Name;
ReportFilter filter = new ReportFilter();
ReportColumn column = new ReportColumn();
List <string> defaultFilters = new List <string>();
List <string> defaultColumns = new List <string>();
defaultFilters.Add("CreatedOn");
switch (entityType)
{
case "Request":
defaultFilters.Add("CategoryID");
defaultColumns.Add("TicketNumber");
break;
case "Task":
defaultFilters.Add("WorkgroupID");
defaultColumns.Add("TaskNumber");
break;
case "SystemUser":
defaultColumns.Add("DomainName");
break;
case "CallWrapUp":
defaultColumns.Add("CallStartTime");
defaultColumns.Add("CallEndTime");
break;
}
//Insert default ReportFilter
for (int i = 0; i < defaultFilters.Count; i++)
{
filter = new ReportFilter();
filter.ReportID = new Guid(model.ID.ToString());
filter.ID = Guid.NewGuid();
string defaultValTemp = defaultFilters[i];
filter.EntityColumnID = db.entityColumn.Where(x => x.EntityID == entityID).Where(x => x.Name == defaultValTemp).FirstOrDefault().ID;
results = db.ReportFilter_Insert(filter);
}
//Insert default ReportColumn
for (int i = 0; i < defaultColumns.Count; i++)
{
column = new ReportColumn();
column.ReportID = new Guid(model.ID.ToString());
column.ID = Guid.NewGuid();
string defaultValTemp = defaultColumns[i];
column.EntityColumnID = db.entityColumn.Where(x => x.EntityID == entityID).Where(x => x.Name == defaultValTemp).FirstOrDefault().ID;
results = db.ReportColumn_Insert(column);
}
}
else if (actionType == "Edit")
{
results = db.Report_Update(model);
}
else if (actionType == "Duplicate")
{
Guid?tempID = model.ID;
model.ID = Guid.NewGuid();
string ReportID = model.ID.ToString();
tempDuplicateID = new Guid(ReportID);
model.CreatedBy = new Guid(Session["CurrentUserID"].ToString());
model.Name += " - Copy";
model.Hyperlink = model.Hyperlink == null ? false : model.Hyperlink;
Guid SecurityRoleID = new Guid(Session["RoleID"].ToString());
results = db.Report_Insert(model, SecurityRoleID);
var filter = db.reportFilter.Where(x => x.ReportID == tempID).OrderBy(x => x.Name).ToList();
var column = db.reportColumn.Where(x => x.ReportID == tempID).OrderBy(x => x.SeqNo).ToList();
foreach (var x in filter)
{
ReportFilter a = new ReportFilter();
a = x;
a.ID = Guid.NewGuid();
a.ReportID = new Guid(ReportID);
results = db.ReportFilter_Insert(a);
}
foreach (var x in column)
{
ReportColumn a = new ReportColumn();
a = x;
a.ID = Guid.NewGuid();
a.ReportID = new Guid(ReportID);
results = db.ReportColumn_Insert(a);
}
}
else if (actionType == "Delete")
{
results = db.Report_Delete(model);
}
if (results.Key == 0 || results.Key == 16 || results.Key == 6)
{
UrlHelper u = new UrlHelper(this.ControllerContext.RequestContext);
string url = u.Action("Edit", "ReportNew", new { id = model.ID, success = successMessage });
string urlNew = u.Action("Create", "ReportNew");
var jsonData = new { flag = true, Message = url, urlNew = urlNew, ID = tempDuplicateID };
return(Json(jsonData));
}
else
{
var jsonData = new { flag = false, Message = results.Value.ToString() };
return(Json(jsonData));
}
}
else
{
foreach (var key in ModelState.Keys)
{
var error = ModelState[key].Errors.FirstOrDefault();
if (error != null)
{
errorMessage.Add(error.ErrorMessage);
}
}
var jsonData = new { flag = false, Message = errorMessage.First() };
return(Json(jsonData));
}
}
public void BindData(ReportFilter rp)
{
//string filter dạng hoten_bh,ngaysinh_bh,thangsinh_bh,namsinh_bh,gioitinh_bh,socmnd_bh,ngaycmnd_bh,thangcmnd_bh,namcmnd_bh,noicapcmnd_bh,diachi_bh,noidangky_bh,noidungthaydoi,manhanvien_baohiem
string hoten_bh = rp.WhereClause.Split(',')[0];
string ngaysinh_bh = rp.WhereClause.Split(',')[1];
string thangsinh_bh = rp.WhereClause.Split(',')[2];
string namsinh_bh = rp.WhereClause.Split(',')[3];
string gioitinh_bh = rp.WhereClause.Split(',')[4];
string socmnd_bh = rp.WhereClause.Split(',')[5];
string ngaycmnd_bh = rp.WhereClause.Split(',')[6];
string thangcmnd_bh = rp.WhereClause.Split(',')[7];
string namcmnd_bh = rp.WhereClause.Split(',')[8];
string noicapcmnd_bh = rp.WhereClause.Split(',')[9];
string diachi_bh = rp.WhereClause.Split(',')[10];
string noidangky_bh = rp.WhereClause.Split(',')[11];
string noidungthaydoi = rp.WhereClause.Split(',')[12];
string manhanvien_baohiem = rp.WhereClause.Split(',')[13];
DAL.BHNHANVIEN_BAOHIEM nvbh = new NhanVien_BaoHiemController().GetNhanVien_BaoHiemByMaNhanVien(manhanvien_baohiem);
if (!string.IsNullOrEmpty(hoten_bh))
{
xrlhoten.Text = "- Tên tôi là (viết chữ in hoa có dấu): " + hoten_bh.ToUpper();
}
else
{
if (!string.IsNullOrEmpty(nvbh.HoTen))
{
xrlhoten.Text = "- Tên tôi là (viết chữ in hoa có dấu): " + nvbh.HoTen.ToUpper();
}
}
if (!string.IsNullOrEmpty(ngaysinh_bh) && !string.IsNullOrEmpty(thangsinh_bh) && !string.IsNullOrEmpty(namsinh_bh))
{
xrlnamsinh.Text = "- Ngày tháng năm sinh: " + ngaysinh_bh + "/" + thangsinh_bh + "/" + namsinh_bh;
}
else
{
if (nvbh.NgaySinh != null && !nvbh.NgaySinh.ToString().Contains("0001"))
{
xrlnamsinh.Text = "- Ngày tháng năm sinh: " + Convert.ToDateTime(nvbh.NgaySinh).Day + "/" + Convert.ToDateTime(nvbh.NgaySinh).Month + "/" + Convert.ToDateTime(nvbh.NgaySinh).Year;
}
}
if (!string.IsNullOrEmpty(gioitinh_bh))
{
if (gioitinh_bh == "0")
{
xrlgioitinh.Text = "Giới tính: " + "Nữ";
}
else
{
xrlgioitinh.Text = "Giới tính: " + "Nam";
}
}
else
{
if (!string.IsNullOrEmpty(nvbh.GioiTinh.ToString()))
{
if (nvbh.GioiTinh == true)
{
xrlgioitinh.Text = "Giới tính: " + "Nam";
}
else
{
xrlgioitinh.Text = "Giới tính: " + "Nữ";
}
}
}
string tendonvi = new DM_DONVIController().GetNameById(nvbh.MaDonVi);
if (!string.IsNullOrEmpty(tendonvi))
{
xrldonvi.Text = "- Đơn vị: " + tendonvi;
}
if (!string.IsNullOrEmpty(socmnd_bh))
{
xrlcmt.Text = "- CMT số: " + socmnd_bh;
}
else
{
if (!string.IsNullOrEmpty(nvbh.SoCMTND))
{
xrlcmt.Text = "- CMT số: " + nvbh.SoCMTND;
}
}
if (!string.IsNullOrEmpty(noicapcmnd_bh))
{
xrlnoicap.Text = "nơi cấp: " + noicapcmnd_bh;
}
else
{
if (!string.IsNullOrEmpty(nvbh.NoiCapCMTND))
{
xrlnoicap.Text = "nơi cấp: " + nvbh.NoiCapCMTND;
}
}
if (!string.IsNullOrEmpty(ngaycmnd_bh) && !string.IsNullOrEmpty(thangcmnd_bh) && !string.IsNullOrEmpty(namcmnd_bh))
{
xrlngaycap.Text = "ngày cấp: " + ngaycmnd_bh + "/" + thangcmnd_bh + "/" + namcmnd_bh;
}
else
{
// txtSoCMNDCu.Text = nvbh.SoCMTND;
if (nvbh.NgayCapCMTND != null && !nvbh.NgayCapCMTND.ToString().Contains("0001"))
{
xrlngaycap.Text = "ngày cấp: " + Convert.ToDateTime(nvbh.NgayCapCMTND).Day + "/" + Convert.ToDateTime(nvbh.NgayCapCMTND).Month + "/" + Convert.ToDateTime(nvbh.NgayCapCMTND).Year;
}
}
if (!string.IsNullOrEmpty(noidungthaydoi))
{
xrlnoidungthaydoi.Text = noidungthaydoi;
}
}
public void BindData(ReportFilter filter)
{
xrl_TenCongTy.Text = ReportController.GetInstance().GetCompanyName(filter.SessionDepartment);
xrl_ThanhPho.Text = ReportController.GetInstance().GetCityName(filter.SessionDepartment);
DataTable table = DataHandler.GetInstance().ExecuteDataTable("sp_DanhSachCanBoCongNhanVienChuc", "@MaDonVi", "@MaBoPhan", "@WhereClause", filter.SessionDepartment, filter.SelectedDepartment == "" ? filter.SelectedDepartment : filter.SelectedDepartment, filter.WhereClause);
DataSource = table;
xrtsohieuccvc.DataBindings.Add("Text", DataSource, "SOHIEU_CCVC");
xrthoten.DataBindings.Add("Text", DataSource, "HO_TEN");
xrtngaysinh.DataBindings.Add("Text", DataSource, "NGAY_SINH", "{0:dd/MM/yyyy}");
xrtgioitinh.DataBindings.Add("Text", DataSource, "TEN_GIOITINH");
xrthesobaoluu.Text = "";
xrthesoluong.DataBindings.Add("Text", DataSource, "HS_LUONG", "{0:n0}");
xrtmasongach.DataBindings.Add("Text", DataSource, "MA_NGACH");
xrtchucdanhcongviec.DataBindings.Add("Text", DataSource, "TEN_CHUCVU");
xrtngaythangnamxepluong.DataBindings.Add("Text", DataSource, "NGAY_HLUONG", "{0:dd/MM/yyyy}");
xrtpcqd244.DataBindings.Add("Text", DataSource, "PHUCAP_KHAC", "{0:n0}");
xrtpctnvk.DataBindings.Add("Text", DataSource, "PhuCapThamNienVuotKhung", "{0:n0}");
xrtphucapchucvu.DataBindings.Add("Text", DataSource, "PhuCapChucVu", "{0:n0}");
xrtphucaptrachnhiem.DataBindings.Add("Text", DataSource, "PhuCapTrachNhiem", "{0:n0}");
this.GroupHeader1.GroupFields.AddRange(new DevExpress.XtraReports.UI.GroupField[] {
new DevExpress.XtraReports.UI.GroupField("TEN_PHONG", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending)
});
xrttenphongban.DataBindings.Add("Text", DataSource, "TEN_PHONG");
xrtngayketxuat.Text = ReportController.GetInstance().GetFooterReport(filter.SessionDepartment, filter.ReportedDate);
if (!string.IsNullOrEmpty(filter.ReportTitle))
{
xrl_TitleBC.Text = filter.ReportTitle.ToUpper();
}
if (!string.IsNullOrEmpty(filter.Title1))
{
xrl_footer1.Text = filter.Title1;
}
if (!string.IsNullOrEmpty(filter.Title2))
{
xrl_footer2.Text = filter.Title2;
}
if (!string.IsNullOrEmpty(filter.Title3))
{
xrl_footer3.Text = filter.Title3;
}
//if (!string.IsNullOrEmpty(filter.Ten1))
//{
// xrl_ten1.Text = filter.Ten1;
//}
//else
//{
// xrl_ten1.Text = filter.NguoiLapBaoCao.ToString();
//}
if (!string.IsNullOrEmpty(filter.Name1))
{
xrl_ten1.Text = filter.Name1;
}
if (!string.IsNullOrEmpty(filter.Name2))
{
xrl_ten2.Text = filter.Name2;
}
if (!string.IsNullOrEmpty(filter.Name3))
{
xrl_ten3.Text = filter.Name3;
}
}
public void BindData(ReportFilter filter)
{
try
{
ReportController rpCtr = new ReportController();
xrl_ThangBaoCao.Text = "Ngày báo cáo: " + filter.ReportedDate.ToString().Replace(" 12:00:00 SA", "");
xrtngayketxuat.Text = new ReportController().GetFooterReport(filter.SessionDepartment, DateTime.Now);
xrl_TenCongTy.Text = rpCtr.GetCompanyName(filter.SessionDepartment);
DataTable table = DataHandler.GetInstance().ExecuteDataTable("sp_CanBoByPhongBan", "@MaBoPhan", "@Gender", "@TinhTrang", "@MinSeniority", "@MaxSeniority", "@WhereClause", filter.SelectedDepartment, filter.Gender, filter.WorkingStatus, filter.MinSeniority, filter.MaxSeniority, filter.WhereClause);
DataSource = table;
xrtmanhanvien.DataBindings.Add("Text", DataSource, "MA_CB");
xrttencbcnv.DataBindings.Add("Text", DataSource, "HO_TEN");
xrt_ngaysinh.DataBindings.Add("Text", DataSource, "NGAY_SINH", "{0:dd/MM/yyyy}");
xrtgioitinh.DataBindings.Add("Text", DataSource, "TEN_GIOITINH");
xrtDiaChiLH.DataBindings.Add("Text", DataSource, "DIA_CHI_LH");
xrtdienthoai.DataBindings.Add("Text", DataSource, "DI_DONG");
xrtNgayVao.DataBindings.Add("Text", DataSource, "NGAY_TUYEN_CHINHTHUC", "{0:dd/MM/yyyy}");
xrtNgayHuongLuong.DataBindings.Add("Text", DataSource, "NgayHuongLuong", "{0:dd/MM/yyyy}");
xrtChucDanh.DataBindings.Add("Text", DataSource, "TEN_CONGVIEC");
xrtTonGiao.DataBindings.Add("Text", DataSource, "TEN_TONGIAO");
xrtTrinhDo.DataBindings.Add("Text", DataSource, "TEN_TRINHDO");
xrtSoCMND.DataBindings.Add("Text", DataSource, "SO_CMND");
this.GroupHeader1.GroupFields.AddRange(new DevExpress.XtraReports.UI.GroupField[] {
new DevExpress.XtraReports.UI.GroupField("MA_PHONG", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending)
});
xrl_tenphongban.DataBindings.Add("Text", DataSource, "TEN_PHONG");
//
if (!string.IsNullOrEmpty(filter.Title1))
{
xrl_footer1.Text = filter.Title1;
}
else
{
xrl_footer1.Text = rpCtr.GetTitleOfSignature(xrl_footer1.Text, filter.Title1);
}
if (!string.IsNullOrEmpty(filter.Title2))
{
xrl_footer2.Text = filter.Title2;
}
else
{
xrl_footer2.Text = rpCtr.GetTitleOfSignature(xrl_footer2.Text, filter.Title2);
}
if (!string.IsNullOrEmpty(filter.Title3))
{
xrl_footer3.Text = filter.Title3;
}
else
{
xrl_footer3.Text = rpCtr.GetTitleOfSignature(xrl_footer3.Text, filter.Title3);
}
if (!string.IsNullOrEmpty(filter.Name1))
{
xrl_ten1.Text = filter.Name1;
}
else
{
xrl_ten1.Text = rpCtr.GetCreatedReporterName(filter.SessionDepartment, filter.Reporter);
}
if (!string.IsNullOrEmpty(filter.Name2))
{
xrl_ten2.Text = filter.Name2;
}
else
{
xrl_ten2.Text = rpCtr.GetHeadOfHRroom(filter.SessionDepartment, filter.Name2);
}
if (!string.IsNullOrEmpty(filter.Name3))
{
xrl_ten3.Text = filter.Name3;
}
else
{
xrl_ten3.Text = rpCtr.GetDirectorName(filter.SessionDepartment, filter.Name3);
}
//tieu de
if (!string.IsNullOrEmpty(filter.ReportTitle))
{
xrl_TitleBC.Text = filter.ReportTitle;
}
}
catch (Exception ex)
{
ExtMessage.Dialog.Alert("Có lỗi xảy ra: " + ex.Message);
}
}
public IActionResult PostReport(ReportFilter reportFilter)
{
return(File(_reportService.GetReport(reportFilter), "application/vnd.ms-excel", "report.xls"));
}
protected void btnShowReport_Click(object sender, DirectEventArgs e)
{
try
{
var whereList = new List <WhereClause>();
var sql = "(";
if (!string.IsNullOrEmpty(e.ExtraParams["SQL"]))
{
var filter = e.ExtraParams["SQL"].Split(';');
whereList.AddRange(from item in filter
where !string.IsNullOrEmpty(item)
select item.Split('=')
into pair
select new WhereClause
{
WhereField = pair[0],
WhereValue = pair[1]
});
var lastWhere = whereList.OrderBy(t => t.WhereField).FirstOrDefault().WhereField;
foreach (var item in whereList.OrderBy(t => t.WhereField))
{
if (item.WhereField == lastWhere)
{
sql += " " + item.WhereField + " = N'" + item.WhereValue + "' or";
}
else
{
if (sql.EndsWith("or"))
{
sql = sql.Remove(sql.LastIndexOf("or"));
sql += ") and (";
}
else if (sql.EndsWith("and"))
{
sql = sql.Remove(sql.LastIndexOf("and"));
sql += " ) ";
}
sql += " " + item.WhereField + " = N'" + item.WhereValue + "' or";
}
lastWhere = item.WhereField;
}
sql = sql.Remove(sql.LastIndexOf(" ")) + ")";
}
else
{
sql = "1 = 1";
}
var reportFilter = new ReportFilter()
{
ReportTitle = txtReportTitle.Text.Trim(),
RecordId = int.Parse("0" + hdfChonCanBo.Text),
Note = htmlNote.Value.ToString(),
WhereClause = sql,
Reporter = CurrentUser.User.DisplayName,
Gender = cbGender.SelectedItem.Value,
LoaiCanBo = cbCanBo.SelectedItem.Value,
SelectedDepartment = hdfSelectedDepartmentIdList.Text,
SessionDepartment = CurrentUser.DepartmentsTree[0].Id.ToString(),
StartMonth = ReportController.GetInstance().GetStartMonth(cbMonth.SelectedItem.Value),
EndMonth = ReportController.GetInstance().GetEndMonth(cbMonth.SelectedItem.Value),
Month = ReportController.GetInstance().GetMonth(cbMonth.SelectedItem.Value),
MinSeniority = int.Parse("0" + txtSeniorityMin.Text),
MaxSeniority = int.Parse("0" + txtSeniorityMax.Text),
MinAge = int.Parse("0" + txtAgeMin.Text),
MaxAge = int.Parse("0" + txtAgeMax.Text),
Title1 = txttieudechuky1.Text,
Title2 = txttieudechuky2.Text,
Title3 = txttieudechuky3.Text,
Name1 = txtnguoiky1.Text,
Name2 = txtnguoiky2.Text,
Name3 = txtnguoiky3.Text,
ReportedDate = dfReportDate.SelectedDate,
BirthPlaceWard = hdfBirthPlaceWardId.Text,
BirthPlaceDistrict = hdfBirthPlaceDistrictId.Text,
BirthPlaceProvince = hdfBirthPlaceProvinceId.Text,
HopDong = cb_HopDong.SelectedItem.Value,
LoginDepartment = string.Join(",", CurrentUser.Departments.Select(d => d.Id)),
TimeSheetReportId = int.Parse("0" + hdfTimeSheetReport.Text),
};
var tbl = hr_RecordServices.GetById(reportFilter.RecordId);
if (tbl != null)
{
reportFilter.EmployeeCode = tbl.EmployeeCode;
}
if (!Util.GetInstance().IsDateNull(dfStartDate.SelectedDate))
{
reportFilter.StartDate = dfStartDate.SelectedDate;
}
if (!Util.GetInstance().IsDateNull(dfEndDate.SelectedDate))
{
reportFilter.EndDate = dfEndDate.SelectedDate;
}
reportFilter.Year = string.IsNullOrEmpty(spfyear.Text) ? DateTime.Now.Year : int.Parse(spfyear.Text);
if (string.IsNullOrEmpty(reportFilter.Gender))
{
reportFilter.Gender = "";
}
var tinhTrang = cbWorkingStatus.SelectedItems.ValuesToJsonArray();
var split = tinhTrang.Split('[', ']', ' ', '"');
tinhTrang = split.Where(item => item.Trim() != "").Aggregate("", (current, item) => current + item);
reportFilter.WorkingStatus = tinhTrang;
Session["rp"] = reportFilter;
var s = Util.GetInstance().RemoveSpaceAndVietnamese(hdfTitle.Text);
RM.RegisterClientScriptBlock("addTabReport",
string.Format(
"addTabReport(pnTabReport,hdfReportID.getValue(),'BaoCao_Main.aspx?type={0}',hdfTitle.getValue());",
s.Replace(",", "")));
RM.RegisterClientScriptBlock("RemoveAndAddNewTab", "RemoveAndAddNewTab('" + hdfReportID.Text + "')");
}
catch (Exception ex)
{
X.MessageBox.Alert("Có lỗi xảy ra", ex.Message).Show();
}
}
public void BindData(ReportFilter reportfillter)
{
ReportController controller = new ReportController();
xrLabel1.Text = controller.GetCompanyName(reportfillter.SessionDepartment);
xrLabel11.Text = controller.GetFromDateToDate(reportfillter.StartDate, reportfillter.EndDate);
// company information
if (!string.IsNullOrEmpty(reportfillter.ReportTitle))
{
xrLabel2.Text = reportfillter.ReportTitle;
}
else
{
xrLabel2.Text = "BÁO CÁO NHÂN VIÊN THAM GIA BẢO HIỂM XÃ HỘI";
}
xrLabel4.Text = controller.GetTitleOfSignature(xrLabel4.Text, reportfillter.Title1);
xrLabel6.Text = controller.GetTitleOfSignature(xrLabel6.Text, reportfillter.Title2);
xrLabel9.Text = controller.GetTitleOfSignature(xrLabel9.Text, reportfillter.Title3);
// Title
if (!string.IsNullOrEmpty(reportfillter.ReportTitle))
{
xrLabel3.Text = reportfillter.ReportTitle;
}
//Nguoi tao bao cao
if (!string.IsNullOrEmpty(reportfillter.Name1))
{
xrLabel5.Text = reportfillter.Name1;
}
else
{
xrLabel5.Text = controller.GetCreatedReporterName(reportfillter.SessionDepartment, reportfillter.Reporter);
}
//Ke toan truong
if (!string.IsNullOrEmpty(reportfillter.Name2))
{
xrLabel7.Text = reportfillter.Name2;
}
else
{
xrLabel7.Text = controller.GetHeadAccountant(reportfillter.SessionDepartment, reportfillter.Name2);
}
//Truong phong hanh chinh nhan su
if (!string.IsNullOrEmpty(reportfillter.Name3))
{
xrLabel10.Text = reportfillter.Name3;
}
else
{
xrLabel10.Text = controller.GetHeadOfHRroom(reportfillter.SessionDepartment, reportfillter.Name3);
}
DataTable export = DataController.DataHandler.GetInstance().ExecuteDataTable("rp_baocaonhanvienthamgiaBHXH", "@WhereClause", "@GioiTinh", "@TuNgay", "@DenNgay", reportfillter.WhereClause, reportfillter.Gender, reportfillter.StartDate, reportfillter.EndDate);
DataSource = export;
if (export != null)
{
xrTableCell8.DataBindings.Add("Text", DataSource, "MaNhanVien");
xrTableCell9.DataBindings.Add("Text", DataSource, "HoTen");
xrTableCell10.DataBindings.Add("Text", DataSource, "TEN_CHUCVU");
xrTableCell11.DataBindings.Add("Text", DataSource, "NgayDangKyBHXH", "{0:dd/MM/yyyy}");
}
//xrTableCell12.DataBindings.Add("Text", DataSource, "NGAY_DONGBH", "{0:dd/MM/yyyy}");
xrLabel8.Text = controller.GetCityName(reportfillter.SessionDepartment) + ", ngày" + DateTime.Now.Day + " tháng " + DateTime.Now.Month + " năm " + DateTime.Now.Year;
xrLabel3.Text = "Ngày báo cáo: " + reportfillter.ReportedDate.ToString().Remove(10);
}
//-//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// Old Reports
/// <summary>
/// LoadDrawingReportData
/// </summary>
/// <param name="reportFilter"></param>
/// <returns></returns>
public DrawingReportData LoadDrawingReportData( ReportFilter reportFilter )
{
return new DrawingReport().Load( reportFilter );
}
/// <summary>
/// @Nghia
/// </summary>
/// <param name="disposing">Báo cáo Austfeed.</param>
///
public void BinData(ReportFilter filter)
{
try
{
if (filter.StartMonth != filter.EndMonth)
{
X.Msg.Alert("Thông báo", "Bạn chọn tháng báo cáo không đúng (Tháng 1 - Tháng 12)").Show();
return;
}
ReportController rct = new ReportController();
xrLabel8.Text = rct.GetFooterReport(filter.SessionDepartment, DateTime.Now);
xrLabel2.Text = "Ngày báo cáo: " + string.Format("{0:dd/MM/yyyy}", filter.ReportedDate);
DataTable table = DataHandler.GetInstance().ExecuteDataTable("report_BaoCaoNhanVienNghiCheDoTrongThang", "@Thang", "@Nam", "@MaDonVi", filter.StartMonth, filter.Year, filter.SelectedDepartment);
DataSource = table;
xrLabel10.Text = rct.GetFromDateToDate(filter.StartDate, filter.EndDate);
xrTableCell8.DataBindings.Add("Text", DataSource, "MA_CB");
xrTableCell9.DataBindings.Add("Text", DataSource, "ho_ten");
xrTableCell10.DataBindings.Add("Text", DataSource, "chucvu");
xrTableCell11.DataBindings.Add("Text", DataSource, "Ngay_Nghi_Che_Do", "{0:dd/MM/yyyy}");
xrTableCell12.DataBindings.Add("Text", DataSource, "GhiChu");
this.GroupHeader1.GroupFields.AddRange(new DevExpress.XtraReports.UI.GroupField[] {
new DevExpress.XtraReports.UI.GroupField("MA_DONVI", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending)
});
xrTableCell17.DataBindings.Add("Text", DataSource, "TEN_DONVI").ToString().ToUpper();
//
//Người lập báo cáo
if (!string.IsNullOrEmpty(filter.Name1))
{
xrLabel5.Text = filter.Name1;
}
else
{
xrLabel5.Text = rct.GetCreatedReporterName(filter.SessionDepartment, filter.Reporter);
}
//chữ ký
xrLabel4.Text = rct.GetTitleOfSignature(xrLabel4.Text, filter.Title1);
xrLabel6.Text = rct.GetTitleOfSignature(xrLabel6.Text, filter.Title2);
xrLabel9.Text = rct.GetTitleOfSignature(xrLabel9.Text, filter.Title3);
//Trưởng phòng HCNS
if (!string.IsNullOrEmpty(filter.Name3))
{
xrLabel10.Text = filter.Name3;
}
else
{
xrLabel10.Text = rct.GetHeadOfHRroom(filter.SessionDepartment, filter.Name3);
}
//Kế toán trưởng
if (!string.IsNullOrEmpty(filter.Name2))
{
xrLabel7.Text = filter.Name2;
}
else
{
xrLabel7.Text = rct.GetHeadAccountant(filter.SessionDepartment, filter.Name2);
}
//tieu de
if (!string.IsNullOrEmpty(filter.ReportTitle))
{
xrLabel1.Text = filter.ReportTitle + " " + filter.StartMonth + " NĂM " + filter.Year;
}
else
{
xrLabel1.Text = "BÁO CÁO NHÂN VIÊN NGHỈ CHẾ ĐỘ TRONG THÁNG " + filter.StartMonth + " NĂM " + filter.Year;
}
}
catch (Exception ex)
{
Ext.Net.X.Msg.Alert("Thông báo", ex.Message).Show();
}
}
private PagedData<Task> GetTasks(IDataTablesRequest request, ReportFilter reportFilter)
{
var filter = reportFilter ?? new ReportFilter();
var query = Query.ForReport(filter).Include(x => x.Project().TaskSteps());
var pageSize = request.Length;
var pageNumber = request.Start / request.Length;
PagedData<Task> tasks = null;
var sorting = request.Sortings<ReportListColumns>().FirstOrDefault();
if (sorting != null)
{
var column = sorting.Item1;
var direction = sorting.Item2;
if (columnsWithClientSorting.Contains(column))
{
tasks = this.GetSortedOnClientTasks(query, pageSize, pageNumber, column, direction);
}
else
{
tasks = this.GetSortedOnServerTasks(query, pageSize, pageNumber, column, direction);
}
}
else
{
tasks = this.GetTasksWithoutSorting(query, pageSize, pageNumber);
}
return tasks;
}
/// <summary>
/// Builds a report filter from the filter values specified
/// </summary>
/// <param name="registeredReport">The registered report</param>
/// <param name="reportDefinition">The report definition</param>
/// <param name="filterValues">The filter values</param>
/// <param name="userInfo">The user information</param>
/// <returns>The report filter</returns>
private ReportFilter BuildReportFilter
(
RegisteredReport registeredReport,
ReportDefinition reportDefinition,
SubmittedReportFilterValues filterValues,
ReportUserInfo userInfo
)
{
var submittedParameterValues = filterValues.ParameterValues;
var convertedParameterValues = new Dictionary <string, object>();
var filter = new ReportFilter
(
reportDefinition.Parameters.ToArray()
);
// Process the parameter values submitted and convert them to their expected types
if (submittedParameterValues != null && submittedParameterValues.Any())
{
var groupedValues = new Dictionary <string, List <object> >();
foreach (var submittedValue in submittedParameterValues)
{
var parameterName = submittedValue.ParameterName;
if (String.IsNullOrEmpty(parameterName))
{
throw new InvalidOperationException
(
"The submitted parameter name cannot be null."
);
}
var convertedValue = ConvertParameterValue
(
filter,
submittedValue
);
if (groupedValues.ContainsKey(parameterName))
{
groupedValues[parameterName].Add
(
convertedValue
);
}
else
{
groupedValues.Add
(
parameterName,
new List <object> {
convertedValue
}
);
}
}
// Flatten the grouped values into individual parameter values
foreach (var pair in groupedValues)
{
if (pair.Value.Count > 1)
{
convertedParameterValues.Add
(
pair.Key,
pair.Value.ToArray()
);
}
else
{
convertedParameterValues.Add
(
pair.Key,
pair.Value.First()
);
}
}
}
// Add any missing parameter values by using the definition defaults
foreach (var definition in filter.ParameterDefinitions)
{
var parameter = definition.Parameter;
var matchFound = convertedParameterValues.Any
(
pair => pair.Key.Equals
(
parameter.Name,
StringComparison.InvariantCultureIgnoreCase
)
);
if (false == matchFound)
{
convertedParameterValues.Add
(
parameter.Name,
parameter.DefaultValue
);
}
}
var constrainedParameters = CompileParameterConstraints
(
registeredReport,
userInfo
);
filter.SetParameterValues
(
convertedParameterValues,
constrainedParameters
);
if (filterValues.SortingRules != null)
{
foreach (var submittedRule in filterValues.SortingRules)
{
filter.SetSortingRule
(
submittedRule.SectionType,
submittedRule.ComponentName,
submittedRule.ColumnName,
submittedRule.Direction
);
}
}
return(filter);
}
/// <summary>
/// Load of Transport items
/// </summary>
/// <returns></returns>
public List<RecTMTransport> LoadTransports( PlanningFilter filter, ReportFilter reportFilter )
{
if( filter == null )
{
throw new ArgumentNullException( "Transport" );
}
var where = WhereGroup.And( ImpTransport.Factory.Equal( filter.Factory ) );
if( !string.IsNullOrWhiteSpace( filter.Project ) )
{
where.Add( ImpTransport.Project.Equal( filter.Project ) );
}
WhereGroup whereStatus = WhereGroup.Or( new Where[] { } );
if( filter.NoStatus )
{
whereStatus.Add( ImpTransport.TransportStatus.Equal( TransportStatus.NoStatus ) );
}
if( filter.Planned )
{
whereStatus.Add( ImpTransport.TransportStatus.Equal( TransportStatus.Planned ) );
}
if( filter.CallOff )
{
whereStatus.Add( ImpTransport.TransportStatus.Equal( TransportStatus.CallOff ) );
}
if( filter.Delivered )
{
whereStatus.Add( ImpTransport.TransportStatus.Equal( TransportStatus.Delivered ) );
}
if( whereStatus.Count > 0 )
{
where.Add( whereStatus );
}
where.Add( ImpTransport.IsTemplate.Equal( false ) );
WhereGroup wgDeleted = WhereGroup.Or( ImpModelGeometry.Deleted.NotEqual( 1 ),
ImpModelGeometry.Deleted.IsNull() );
where.Add( wgDeleted );
if( filter.UseLoadDateFrom )
{
where.Add( ImpTransport.LoadDate.GreaterThanOrEqual( filter.LoadDateFrom ) );
}
if( filter.UseLoadDateTo )
{
where.Add( ImpTransport.LoadDate.LessThanOrEqual( filter.LoadDateTo ) );
}
if( filter.UseDeliveryDateFrom )
{
where.Add( ImpTransport.DeliveryDate.GreaterThanOrEqual( filter.DeliveryDateFrom ) );
}
if( filter.UseDeliveryDateTo )
{
where.Add( ImpTransport.DeliveryDate.LessThanOrEqual( filter.DeliveryDateTo ) );
}
if( reportFilter != null && reportFilter.Ranges.Count > 0 )
{
var list = new List<Where>();
foreach( var range in reportFilter.Ranges )
{
if( !string.IsNullOrEmpty( range.From ) && !string.IsNullOrEmpty( range.To ) )
{
list.Add( ImpTransport.TransportId.Between( range.From, range.To ) );
}
}
if( list.Count > 0 )
{
where.Add( WhereGroup.Or( list.ToArray() ) );
}
}
where.Add( ImpTransport.TransportId.GreaterThan( 0 ) );
ImpactQuery query = new ImpactQuery()
{
Select =
{
ImpTransport.Project,
ImpTransport.TransportId,
ImpTransport.Description,
ImpTransport.LoadDate,
ImpTransport.DeliveryDate,
ImpTransport.TransportStatus,
ImpTransportVehicle.VehicleId,
ImpTransportVehicleStd.Name,
ImpTransportVehicleStd.MaxMass,
ImpTransportVehicle.TransportType,
ImpTransportVehicleStd.VehicleType,
ImpTransportStack.StackId,
//ImpTransportStack.Rack,
ImpTransportStack.MaxMass,
ImpTransportStack.Description,
ImpTransportStack.StackType,
ImpModelPlanning.ElementId,
ImpModelPlanning.ErectionSequenceNo,
ImpModelPlanning.StackSequenceNo,
ImpModelPlanning.StackId,
ImpModelPlanning.ElementIdStatus,
ImpModelPlanning.PlannedDeliveryDate,
ImpModelPlanning.DeliveryDate,
ImpModelGeometry.ElementMark,
ImpModelGeometry.Building,
ImpModelGeometry.FloorId,
ImpModelGeometry.Phase,
ImpElement.ElementType,
ImpElement.Product,
ImpElement.Style,
ImpElement.Mass,
ImpElement.ElementLength,
ImpElement.ElementWidth,
ImpElement.ElementHeight,
ImpElement.GrossArea,
ImpElement.NetArea,
},
//ELEMENT_TYPE, STYLE BOUNDING_BOX_AREA
From = { ImpTransport.As( "TRA" ) },
Join =
{
Join.Left( ImpTransportVehicle.As( "TRV" ),
ImpTransport.Factory.Equal( ImpTransportVehicle.Factory ),
ImpTransport.Project.Equal( ImpTransportVehicle.Project ),
ImpTransport.TransportId.Equal( ImpTransportVehicle.TransportId ) ),
Join.Left( ImpTransportVehicleStd.As( "VST" ),
ImpTransport.Factory.Equal( ImpTransportVehicleStd.Factory ),
ImpTransport.Factory.Equal( ImpTransportVehicleStd.Project ), // Factory, factory only so far (Needs to be complated with company, company)
ImpTransportVehicle.Vehicle.Equal( ImpTransportVehicleStd.Name ) ),
Join.Left( ImpTransportStack.As( "RCK" ),
ImpTransport.Factory.Equal( ImpTransportStack.Factory ),
ImpTransport.Project.Equal( ImpTransportStack.Project ),
ImpTransport.TransportId.Equal( ImpTransportStack.TransportId ),
ImpTransportVehicle.VehicleId.Equal( ImpTransportStack.VehicleId )),
Join.Left( ImpModelPlanning.As( "MPL" ),
ImpTransport.Factory.Equal( ImpModelPlanning.Factory ),
ImpTransport.Project.Equal( ImpModelPlanning.Project ),
ImpTransport.TransportId.Equal( ImpModelPlanning.TransportId ),
ImpTransportVehicle.VehicleId.Equal( ImpModelPlanning.VehicleId ) ,
ImpTransportStack.StackId.Equal( ImpModelPlanning.StackId ) ),
Join.Left( ImpModelGeometry.As( "MGO" ),
ImpModelPlanning.Factory.Equal( ImpModelGeometry.Factory ),
ImpModelPlanning.Project.Equal( ImpModelGeometry.Project ),
ImpModelPlanning.ElementId.Equal( ImpModelGeometry.ElementId ) ),
Join.Left( ImpElement.As( "ELM" ),
ImpModelGeometry.Factory.Equal( ImpElement.Factory ),
ImpModelGeometry.Project.Equal( ImpElement.Project ),
ImpModelGeometry.ElementMark.Equal( ImpElement.ElementMark ) ),
},
Where = { where },
OrderBy =
{
{ ImpTransport.TransportId, OrderBy.Descending },
{ ImpTransportVehicle.VehicleId },
{ ImpTransportStack.StackId },
{ ImpModelPlanning.StackSequenceNo, OrderBy.Descending }
},
};
string statement = query.ToString();
List<RecTMTransport> tmList = new List<RecTMTransport>();
TranportParser parser = new TranportParser( tmList );
using( ImpactDatabase database = new ImpactDatabase() )
{
var list = database.GetAll( statement, column =>
{
string project = DataConverter.Cast<string>( column[0] );
int transportId = DataConverter.Cast<int>( column[1] );
return new
{
// TODO: THEIB, you must handle null dates in your record class.
transport = new RecTransport()
{
Factory = filter.Factory,
Project = project,
TransportId = transportId,
Description = DataConverter.Cast<string>( column[2] ),
LoadDate = DataConverter.Cast<DateTime>( column[3] ),
DeliveryDate = DataConverter.Cast<DateTime?>( column[4] ),
TransportStatus = DataConverter.Cast<int>( column[5] ),
},
veh = new RecTransportVehicleStd()
{
Factory = filter.Factory,
Project = project,
VehicleId = DataConverter.Cast<int?>( column[6] ) ?? 0,
Name = DataConverter.Cast<string>( column[7] ),
MaxMass = DataConverter.Cast<double?>( column[8] ) ?? 0d,
TransportId = transportId,
TransportType = DataConverter.Cast<int?>( column[9] ) ?? 0,
VehicleType = DataConverter.Cast<int?>( column[10] ) ?? 0
},
stack = new RecTransportVehicleStackStd()
{
StackId = DataConverter.Cast<int?>( column[11] ) ?? 0,
MaxMass = DataConverter.Cast<double?>( column[12] ) ?? 0,
Description = DataConverter.Cast<string>( column[13] ),
StackType = DataConverter.Cast<int?>( column[14] ) ?? 0
},
elem = new RecTMElement()
{
Factory = filter.Factory,
Project = project,
ElementId = DataConverter.Cast<int?>( column[15] ) ?? 0,
ErectionSequenceNo = DataConverter.Cast<int?>( column[16] ) ?? 0,
StackSequenceNo = DataConverter.Cast<int?>( column[17] ) ?? 0,
StackId = DataConverter.Cast<int?>( column[18] ) ?? 0,
ElementIdStatus = DataConverter.Cast<int?>( column[19] ) ?? 0,
PlannedDeliveryDate = DataConverter.Cast<DateTime?>( column[20] ),
DeliveryDate = DataConverter.Cast<DateTime?>( column[21] ),
ElementMark = DataConverter.Cast<string>( column[22] ),
Building = DataConverter.Cast<string>( column[23] ),
FloorId = DataConverter.Cast<int?>( column[24] ) ?? 0,
Phase = DataConverter.Cast<string>( column[25] ),
ElementType = DataConverter.Cast<string>( column[26] ),
Product = DataConverter.Cast<string>( column[27] ),
Style = DataConverter.Cast<string>( column[28] ),
Mass = DataConverter.Cast<double?>( column[29] ) ?? 0d,
ElementLength = DataConverter.Cast<double?>( column[30] ) ?? 0d,
ElementWidth = DataConverter.Cast<double?>( column[31] ) ?? 0d,
ElementHeight = DataConverter.Cast<double?>( column[32] ) ?? 0d,
GrossArea = DataConverter.Cast<double?>( column[33] ) ?? 0d,
NetArea = DataConverter.Cast<double?>( column[34] ) ?? 0d,
}
};
} );
foreach( var item in list )
{
parser.Parse( item.transport, item.veh, item.stack, item.elem );
}
}
return tmList;
}
/// <summary>
/// Converts a submitted parameter value into the value type expected
/// </summary>
/// <param name="filter">The report filter</param>
/// <param name="submittedValue">The submitted value</param>
/// <returns>The converted value</returns>
private object ConvertParameterValue
(
ReportFilter filter,
SubmittedParameterValue submittedValue
)
{
if (submittedValue.Values == null)
{
return(null);
}
var definition = filter.GetDefinition
(
submittedValue.ParameterName
);
var expectedType = definition.Parameter.ExpectedType;
if (expectedType.IsArray)
{
expectedType = expectedType.GetElementType();
var convertedValues = Array.CreateInstance
(
expectedType,
submittedValue.Values.Length
);
var index = 0;
foreach (var rawValue in submittedValue.Values)
{
convertedValues.SetValue
(
ConvertValue(rawValue),
index
);
index++;
}
return(convertedValues);
}
else if (submittedValue.Values.Length == 0)
{
return(null);
}
else
{
return(ConvertValue
(
submittedValue.Values[0]
));
}
object ConvertValue(string value)
{
if (expectedType == typeof(string))
{
return(value);
}
else
{
return(ObjectConverter.Convert
(
value,
expectedType
));
}
}
}
private static string GetlogicStringFromLogic(AppTile appTile)
{
string logicString = string.Empty;
switch (appTile.logicType)
{
case LogicType.Selected:
logicString = string.Join(",", (appTile.BasicLogic as IN <int>).FieldValue.GetValue());
break;
case LogicType.Filtered:
List <Logic> elements = (appTile.BasicLogic as AND).LogicElements;
if (elements != null && elements.Count > 0)
{
#region Get ReportFilter from Logic
ReportFilter filer = new ReportFilter();
foreach (var t in elements)
{
if (t as IN <int> != null)
{
if ((t as IN <int>).Field is TagId)
{
filer.TagsIdCollection = (t as IN <int>).FieldValue.GetValue();
}
if ((t as IN <int>).Field is SubCategoryId)
{
filer.SubCategoryIdCollection = (t as IN <int>).FieldValue.GetValue();
}
}
if ((t as IN <string>) != null)
{
if ((t as IN <string>).Field is ReportOwnerId)
{
filer.OwnerIdCollection = (t as IN <string>).FieldValue.GetValue();
}
}
}
#endregion
#region Get TileFilterListViewModel from ReportFilter
TileFilterListViewModel vm = new TileFilterListViewModel();
if (filer.TagsIdCollection != null && filer.TagsIdCollection.Count > 0)
{
vm.Tag = filer.TagsIdCollection.Select(id => new AppTeamTag {
Id = id
});
}
if (filer.SubCategoryIdCollection != null && filer.SubCategoryIdCollection.Count > 0)
{
vm.SubCategory = filer.SubCategoryIdCollection.Select(id => new AppCategory {
Id = id
});
}
if (filer.OwnerIdCollection != null && filer.OwnerIdCollection.Count > 0)
{
vm.Owner = filer.OwnerIdCollection.Select(id => new UserLoginApp {
Id = id
});
}
#endregion
JavaScriptSerializer jss = new JavaScriptSerializer();
logicString = jss.Serialize(vm);
}
break;
case LogicType.Tagged:
logicString = string.Join(",", (appTile.BasicLogic as IN <int>).FieldValue.GetValue());
break;
default:
break;
}
return(logicString);
}
/// <summary>
/// @Nghia
/// </summary>Austfeed
/// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>
///
public void BindData(ReportFilter filter)
{
try
{
ReportController rpCtr = new ReportController();
xrLabel3.Text = "Ngày báo cáo: " + string.Format("{0:dd/MM/yyyy}", filter.ReportedDate);
xrLabel8.Text = rpCtr.GetFooterReport(filter.SessionDepartment, DateTime.Now);
DataTable table = DataHandler.GetInstance().ExecuteDataTable("report_BaoCaoNhanVienLamNgayLeTetTrongThang", "@WhereClause", "@Thang", "@Nam", filter.WhereClause, filter.StartMonth, filter.Year);
DataSource = table;
xrTableCell8.DataBindings.Add("Text", DataSource, "MA_CB");
xrTableCell9.DataBindings.Add("Text", DataSource, "HO_TEN");
xrTableCell10.DataBindings.Add("Text", DataSource, "TEN_CHUCVU");
xrTableCell11.DataBindings.Add("Text", DataSource, "So_Ngay_Lam");
xrTableCell12.DataBindings.Add("Text", DataSource, "GhiChu");
//Người lập báo cáo
if (!string.IsNullOrEmpty(filter.Name1))
{
xrLabel5.Text = filter.Name1;
}
else
{
xrLabel5.Text = rpCtr.GetCreatedReporterName(filter.SessionDepartment, filter.Reporter);
}
//chữ ký
xrLabel4.Text = rpCtr.GetTitleOfSignature(xrLabel4.Text, filter.Title1);
xrLabel6.Text = rpCtr.GetTitleOfSignature(xrLabel6.Text, filter.Title2);
xrLabel9.Text = rpCtr.GetTitleOfSignature(xrLabel9.Text, filter.Title3);
//Trưởng phòng HCNS
if (!string.IsNullOrEmpty(filter.Name3))
{
xrLabel10.Text = filter.Name3;
}
else
{
xrLabel10.Text = rpCtr.GetHeadOfHRroom(filter.SessionDepartment, filter.Name3);
}
//Kế toán trưởng
if (!string.IsNullOrEmpty(filter.Name2))
{
xrLabel7.Text = filter.Name2;
}
else
{
xrLabel7.Text = rpCtr.GetHeadAccountant(filter.SessionDepartment, filter.Name2);
}
//tieu de
if (!string.IsNullOrEmpty(filter.ReportTitle))
{
xrLabel2.Text = filter.ReportTitle + " " + filter.StartMonth + " NĂM " + filter.Year;
}
else
{
xrLabel2.Text = "BÁO CÁO NHÂN VIÊN LÀM NGÀY LỄ TẾT TRONG THÁNG " + filter.StartMonth + " NĂM " + filter.Year;
}
}
catch (Exception ex)
{
Ext.Net.X.Msg.Alert("", ex.Message).Show();
}
}
public void BindData(ReportFilter filter)
{
try
{
ReportController controller = new ReportController();
xrtngayketxuat.Text = controller.GetFooterReport(filter.SessionDepartment, filter.ReportedDate);
xrl_TenCongTy.Text = controller.GetCompanyName(filter.SessionDepartment);
DataTable table = DataHandler.GetInstance().ExecuteDataTable("report_DanhSachNhanVienCoThamNienLamViec", "@MaBoPhan", "@Gender", "@TinhTrang", "@MinSeniority", "@MaxSeniority", "@WhereClause", filter.SelectedDepartment, filter.Gender, filter.WorkingStatus, filter.MinSeniority, filter.MaxSeniority, filter.WhereClause);
DataSource = table;
xrt_TenPhongBan.DataBindings.Add("Text", DataSource, "TEN_PHONG");
xrtmanhanvien.DataBindings.Add("Text", DataSource, "MA_CB");
xrt_ngaysinh.DataBindings.Add("Text", DataSource, "NGAY_SINH", "{0:dd/MM/yyyy}");
xrt_hoten.DataBindings.Add("Text", DataSource, "HO_TEN", "{0:dd/MM/yyyy}");
xrtgioitinh.DataBindings.Add("Text", DataSource, "TEN_GIOITINH");
xrtngayvaocongty.DataBindings.Add("Text", DataSource, "NGAY_TUYEN_CHINHTHUC", "{0:dd/MM/yyyy}");
xrt_thamNien.DataBindings.Add("Text", DataSource, "ThamNien");
xrtchucvu.DataBindings.Add("Text", DataSource, "TEN_CHUCVU");
xrtTenCongViec.DataBindings.Add("Text", DataSource, "TEN_CONGVIEC");
this.GroupHeader1.GroupFields.AddRange(new DevExpress.XtraReports.UI.GroupField[] {
new DevExpress.XtraReports.UI.GroupField("ChuoiSX", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending)
});
ReportController rpCtr = new ReportController();
if (!string.IsNullOrEmpty(filter.Title1))
{
xrl_footer1.Text = filter.Title1;
}
else
{
xrl_footer1.Text = rpCtr.GetTitleOfSignature(xrl_footer1.Text, filter.Title1);
}
if (!string.IsNullOrEmpty(filter.Title2))
{
xrl_footer2.Text = filter.Title2;
}
else
{
xrl_footer2.Text = rpCtr.GetTitleOfSignature(xrl_footer2.Text, filter.Title2);
}
if (!string.IsNullOrEmpty(filter.Title3))
{
xrl_footer3.Text = filter.Title3;
}
else
{
xrl_footer3.Text = rpCtr.GetTitleOfSignature(xrl_footer3.Text, filter.Title3);
}
if (!string.IsNullOrEmpty(filter.Name1))
{
xrl_ten1.Text = filter.Name1;
}
else
{
xrl_ten1.Text = rpCtr.GetCreatedReporterName(filter.SessionDepartment, filter.Reporter);
}
if (!string.IsNullOrEmpty(filter.Name2))
{
xrl_ten2.Text = filter.Name2;
}
else
{
xrl_ten2.Text = rpCtr.GetHeadOfHRroom(filter.SessionDepartment, filter.Name2);
}
if (!string.IsNullOrEmpty(filter.Name3))
{
xrl_ten3.Text = filter.Name3;
}
else
{
xrl_ten3.Text = rpCtr.GetDirectorName(filter.SessionDepartment, filter.Name3);
}
//tieu de
if (!string.IsNullOrEmpty(filter.ReportTitle))
{
xrl_TitleBC.Text = filter.ReportTitle;
}
}
catch (Exception ex)
{
ExtMessage.Dialog.Alert("Có lỗi xảy ra: " + ex.Message);
}
}
/// <summary>
/// Asynchronously generates a component from a report definition and filter
/// </summary>
/// <param name="definition">The component definition</param>
/// <param name="sectionType">The report section type</param>
/// <param name="filter">The report filter</param>
/// <returns>The report component generated</returns>
public override async Task <IReportComponent> GenerateAsync
(
IReportComponentDefinition definition,
ReportSectionType sectionType,
ReportFilter filter
)
{
Validate.IsNotNull(definition);
Validate.IsNotNull(filter);
var chartDefinition = definition.As <ChartDefinition>();
var queryTasks = new Dictionary <ChartDataSetDefinition, Task <QueryResults> >();
var dataSets = new List <ChartDataSet>();
// Build a dictionary of query tasks to execute
foreach (var setDefinition in chartDefinition.DataSets)
{
var query = setDefinition.Query;
var defaultParameters = setDefinition.DefaultParameterValues;
var parameterValues = filter.GetQueryParameters
(
query,
defaultParameters.ToArray()
);
var task = query.ExecuteAsync
(
parameterValues.ToArray()
);
queryTasks.Add(setDefinition, task);
}
await Task.WhenAll
(
queryTasks.Select(pair => pair.Value)
)
.ConfigureAwait
(
false
);
var labelList = new List <ChartAxisLabel>();
// Compile and process the results of each query
foreach (var item in queryTasks)
{
var dataPoints = new List <ChartDataPoint>();
var setDefinition = item.Key;
var queryResults = await item.Value.ConfigureAwait
(
false
);
if (queryResults.AllRows.Any())
{
var rowNumber = 1;
foreach (var row in queryResults.AllRows)
{
var xLabelValue = default(object);
var xValue = setDefinition.XAxisBinding.Resolve <double>
(
row
);
if (setDefinition.XAxisLabelBinding == null)
{
xLabelValue = xValue;
}
else
{
xLabelValue = setDefinition.XAxisLabelBinding.Resolve
(
row
);
}
var xLabel = GenerateLabel
(
xLabelValue,
rowNumber,
chartDefinition.XAxisLabelTemplate
);
var yValue = setDefinition.YAxisBinding.Resolve <double>
(
row
);
var point = new ChartDataPoint
(
xValue,
yValue,
setDefinition.Color
);
dataPoints.Add(point);
if (false == labelList.Any(l => l.Text == xLabel.Text))
{
labelList.Add(xLabel);
}
}
var set = new ChartDataSet
(
setDefinition.Name,
dataPoints.ToArray()
);
dataSets.Add(set);
rowNumber++;
}
}
var chart = new Chart
(
chartDefinition,
labelList,
dataSets.ToArray()
);
return(chart);
}
public IActionResult GetCustomerBalanceSummary([FromBody] ReportFilter filter)
{
return(Ok(reportService.GetCustomerBalanceSummary(filter)));
}
/// <summary>
/// 保存筛选条件信息
/// 将未设置筛选的字段一起保存（未设置的字段IsSearch = false）
/// </summary>
/// <param name="tbReport"></param>
/// <param name="tbReportId"></param>
private void SaveRpFilterList(TbReportModel tbReport, long tbReportId)
{
//新增或修改筛选
if (tbReport.FilterListJson != null && tbReport.FilterListJson.Length > 0)
{
//保存说明：无差别式保存.然后在报表解析时去差别处理
//tbReport.FilterListJson返回的所有字段+自定义筛选的内容
var ftList = JSON.EncodeToEntity <List <ReportFilterModel> >(tbReport.FilterListJson);
//原筛选项
var oldFtList = _reportFilterRepository.GetAllList(p => p.TbReportId == tbReportId);
//获得新的字段
var fdCodes = ftList.Select(p => p.FieldCode);
//未在新字段的(应被删的)
var delFtList = oldFtList.Where(p => p.FieldCode != null && !fdCodes.Contains(p.FieldCode)).ToList();
//批量修改原筛选全部fasle
if (oldFtList != null && oldFtList.Count > 0)
{
for (int j = oldFtList.Count - 1; j >= 0; j--)
{
var ft = oldFtList[j];
if (delFtList.Contains(ft))
{
_reportFilterRepository.Delete(ft);
}
else
{
ft.IsSearch = false;
_reportFilterRepository.Update(ft);
}
}
//CurrentUnitOfWork.SaveChanges();
}
//批量添加或修改筛选信息
if (ftList != null && ftList.Count > 0)
{
for (int i = 0; i < ftList.Count; i++)
{
var ft = ftList[i];
ReportFilter curFt = new ReportFilter();
if (ft.IsCustom)//自定筛选
{
if (ft.Id != 0)
{
curFt = oldFtList.FirstOrDefault(p => p.Id == ft.Id);
}
else
{
curFt = oldFtList.FirstOrDefault(p => p.FieldParam == ft.FieldParam);//根据参数名判断
}
}
else
{
curFt = oldFtList.FirstOrDefault(p => p.FieldCode == ft.FieldCode);//根据字段编码判断
}
curFt = AutoMapper.Mapper.Map(ft, curFt);
curFt.TbReportId = tbReportId;
_reportFilterRepository.InsertOrUpdate(curFt);//保存筛选
}
}
}
}
public IActionResult GetProductSaleSummaries([FromBody] ReportFilter filter)
{
return(Ok(reportService.GetProductSaleSummaries(filter)));
}
public void BinData(ReportFilter filter)
{
try
{
ReportController rp = new ReportController();
DataTable dt = DataHandler.GetInstance().ExecuteDataTable("rp_austfeed_BaoCaoTongHopLuongKhoan", "@Thang", "@Nam", "@MaDonVi",
filter.StartMonth, filter.Year, filter.SelectedDepartment);
foreach (DataRow item in dt.Rows)
{
try
{
double congchuan = 0;
try { congchuan = new ThietLapCaTheoBoPhanController().GetCongChuan(filter.SessionDepartment); }
catch (Exception) { }
int soNgayLe = int.Parse(DataController.DataHandler.GetInstance().ExecuteScalar("f_Khoan_GetNgayLeKhongDiLam",
"@MaCanBo", "@Thang", "@Nam", item["MA_CB"].ToString(), filter.StartMonth, filter.Year).ToString());
decimal tienLe = 0;
double luongQD = 0;
try { luongQD = double.Parse("0" + item["LuongDongBH"].ToString()); }
catch (Exception) { }
try { tienLe = Math.Round((decimal)(soNgayLe * luongQD / congchuan), 0); }
catch (Exception) { }
item["TienLe"] = tienLe;
decimal tong = 0;
try { tong = decimal.Parse("0" + item["TongCong"].ToString()); }
catch (Exception) { }
tong = tong + tienLe;
item["TongCong"] = tong;
}
catch (Exception)
{
}
}
if (dt.Rows.Count > 0)
{
DataSource = dt;
xrTableCell72.DataBindings.Add("Text", DataSource, "MA_CB");
xrTableCell73.DataBindings.Add("Text", DataSource, "HO_TEN");
xrTableCell74.DataBindings.Add("Text", DataSource, "Ngay1", "{0:n0}");
xrTableCell75.DataBindings.Add("Text", DataSource, "Ngay2", "{0:n0}");
xrTableCell76.DataBindings.Add("Text", DataSource, "Ngay3", "{0:n0}");
xrTableCell77.DataBindings.Add("Text", DataSource, "Ngay4", "{0:n0}");
xrTableCell78.DataBindings.Add("Text", DataSource, "Ngay5", "{0:n0}");
xrTableCell79.DataBindings.Add("Text", DataSource, "Ngay6", "{0:n0}");
xrTableCell80.DataBindings.Add("Text", DataSource, "Ngay7", "{0:n0}");
xrTableCell81.DataBindings.Add("Text", DataSource, "Ngay8", "{0:n0}");
xrTableCell82.DataBindings.Add("Text", DataSource, "Ngay9", "{0:n0}");
xrTableCell83.DataBindings.Add("Text", DataSource, "Ngay10", "{0:n0}");
xrTableCell84.DataBindings.Add("Text", DataSource, "Ngay11", "{0:n0}");
xrTableCell85.DataBindings.Add("Text", DataSource, "Ngay12", "{0:n0}");
xrTableCell86.DataBindings.Add("Text", DataSource, "Ngay13", "{0:n0}");
xrTableCell87.DataBindings.Add("Text", DataSource, "Ngay14", "{0:n0}");
xrTableCell88.DataBindings.Add("Text", DataSource, "Ngay15", "{0:n0}");
xrTableCell89.DataBindings.Add("Text", DataSource, "Ngay16", "{0:n0}");
xrTableCell90.DataBindings.Add("Text", DataSource, "Ngay17", "{0:n0}");
xrTableCell91.DataBindings.Add("Text", DataSource, "Ngay18", "{0:n0}");
xrTableCell92.DataBindings.Add("Text", DataSource, "Ngay19", "{0:n0}");
xrTableCell93.DataBindings.Add("Text", DataSource, "Ngay20", "{0:n0}");
xrTableCell94.DataBindings.Add("Text", DataSource, "Ngay21", "{0:n0}");
xrTableCell95.DataBindings.Add("Text", DataSource, "Ngay22", "{0:n0}");
xrTableCell96.DataBindings.Add("Text", DataSource, "Ngay23", "{0:n0}");
xrTableCell97.DataBindings.Add("Text", DataSource, "Ngay24", "{0:n0}");
xrTableCell98.DataBindings.Add("Text", DataSource, "Ngay25", "{0:n0}");
xrTableCell99.DataBindings.Add("Text", DataSource, "Ngay26", "{0:n0}");
xrTableCell100.DataBindings.Add("Text", DataSource, "Ngay27", "{0:n0}");
xrTableCell101.DataBindings.Add("Text", DataSource, "Ngay28", "{0:n0}");
xrTableCell102.DataBindings.Add("Text", DataSource, "Ngay29", "{0:n0}");
xrTableCell103.DataBindings.Add("Text", DataSource, "Ngay30", "{0:n0}");
xrTableCell104.DataBindings.Add("Text", DataSource, "Ngay31", "{0:n0}");
xrTableCell39.DataBindings.Add("Text", DataSource, "TienLe", "{0:n0}");
xrTableCell105.DataBindings.Add("Text", DataSource, "TongCong", "{0:n0}");
//Group header
this.GroupHeader1.GroupFields.AddRange(new DevExpress.XtraReports.UI.GroupField[] {
new DevExpress.XtraReports.UI.GroupField("MA_DONVI", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending)
});
xrTableCell38.DataBindings.Add("Text", DataSource, "TEN_DONVI");
//Title
xrLabel1.Text = string.Format(xrLabel1.Text, filter.StartMonth, filter.Year);
}
}
catch (Exception e)
{
X.Msg.Alert("Thông báo", "Có lỗi: " + e).Show();
}
}
public void BinData(ReportFilter rp)
{
//string a = xrLabel5.Text.Replace("{1}","d");
DataTable dt = new DataController.DataHandler().ExecuteDataTable("sp_MauInCheDo", "@IDChiTietCheDoBaoHiem", rp.WhereClause);
if (!string.IsNullOrEmpty(dt.Rows[0]["SoDienThoai"].ToString()))
{
// xrt_sdt.Text = "Số điện thoại (nếu có): " + dt.Rows[0]["SoDienThoai"].ToString();
xrt_hoten.Text = xrt_hoten.Text.Replace("{9}", dt.Rows[0]["SoDienThoai"].ToString());
}
else
{
xrt_hoten.Text = xrt_hoten.Text.Replace("{9}", "...................................................................................");
}
if (!string.IsNullOrEmpty(dt.Rows[0]["HoTen"].ToString()))
{
// xrt_hoten.Text = "Họ và tên: " + dt.Rows[0]["HoTen"].ToString();
xrt_hoten.Text = xrt_hoten.Text.Replace("{1}", dt.Rows[0]["HoTen"].ToString());
}
else
{
xrt_hoten.Text = xrt_hoten.Text.Replace("{1}", " ................................................");
}
if (!string.IsNullOrEmpty(dt.Rows[0]["SoSoBHXH"].ToString()))
{
// xrt_sosobhxh.Text = "Số sổ BHXH: " + dt.Rows[0]["SoSoBHXH"].ToString();
xrt_hoten.Text = xrt_hoten.Text.Replace("{2}", dt.Rows[0]["SoSoBHXH"].ToString());
}
else
{
xrt_hoten.Text = xrt_hoten.Text.Replace("{2}", "..........................,");
}
if (!string.IsNullOrEmpty(dt.Rows[0]["SoCMTND"].ToString()))
{
//xrt_cmnd.Text = "Số CMND "+dt.Rows[0]["SoCMTND"].ToString();
xrt_hoten.Text = xrt_hoten.Text.Replace("{3}", dt.Rows[0]["SoCMTND"].ToString());
}
else
{
xrt_hoten.Text = xrt_hoten.Text.Replace("{3}", "...................................");
}
if (!string.IsNullOrEmpty(dt.Rows[0]["NoiCapCMND"].ToString()))
{
//xrt_noicap.Text = "do " + dt.Rows[0]["NoiCapCMND"].ToString();
xrt_hoten.Text = xrt_hoten.Text.Replace("{4}", dt.Rows[0]["NoiCapCMND"].ToString());
}
else
{
xrt_hoten.Text = xrt_hoten.Text.Replace("{4}", "...................");
}
if (!string.IsNullOrEmpty(dt.Rows[0]["DiaChiLienHe"].ToString()))
{
// xrt_diachilienhe.Text="Hiện tại cư trú tại: "+dt.Rows[0]["DiaChiLienHe"].ToString();
xrt_hoten.Text = xrt_hoten.Text.Replace("{8}", dt.Rows[0]["NoiCapCMND"].ToString());
}
else
{
xrt_hoten.Text = xrt_hoten.Text.Replace("{8}", "..........................................................................................");
}
if (!string.IsNullOrEmpty(dt.Rows[0]["NgayCapCMTND"].ToString()))
{
xrt_hoten.Text = xrt_hoten.Text.Replace("{5}", Convert.ToDateTime(dt.Rows[0]["NgayCapCMTND"]).Day.ToString());
xrt_hoten.Text = xrt_hoten.Text.Replace("{6}", Convert.ToDateTime(dt.Rows[0]["NgayCapCMTND"]).Month.ToString());
xrt_hoten.Text = xrt_hoten.Text.Replace("{7}", Convert.ToDateTime(dt.Rows[0]["NgayCapCMTND"]).Year.ToString());
// xrt_capngay.Text = Convert.ToDateTime(dt.Rows[0]["NgayCapCMTND"]).Day + " tháng " + Convert.ToDateTime(dt.Rows[0]["NgayCapCMTND"]).Month + " năm " + Convert.ToDateTime(dt.Rows[0]["NgayCapCMTND"]).Year;
}
else
{
xrt_hoten.Text = xrt_hoten.Text.Replace("{5}", "..."); xrt_hoten.Text = xrt_hoten.Text.Replace("{6}", "..."); xrt_hoten.Text = xrt_hoten.Text.Replace("{7}", "....");
}
if (!string.IsNullOrEmpty(dt.Rows[0]["NgayBatDau"].ToString()))
{
xrt_hoten.Text = xrt_hoten.Text.Replace("{12}", Convert.ToDateTime(dt.Rows[0]["NgayBatDau"]).Month.ToString());
xrt_hoten.Text = xrt_hoten.Text.Replace("{13}", Convert.ToDateTime(dt.Rows[0]["NgayBatDau"]).Year.ToString());
// xrt_ngaybatdau.Text = "Nghỉ việc, không đóng BHXH từ tháng " + Convert.ToDateTime(dt.Rows[0]["NgayBatDau"]).Month + " năm " + Convert.ToDateTime(dt.Rows[0]["NgayBatDau"]).Year;
}
else
{
xrt_hoten.Text = xrt_hoten.Text.Replace("{12}", " ... ");
xrt_hoten.Text = xrt_hoten.Text.Replace("{13}", " ....");
}
if (!string.IsNullOrEmpty(dt.Rows[0]["NgayKetThuc"].ToString()))
{
xrt_hoten.Text = xrt_hoten.Text.Replace("{14}", Convert.ToDateTime(dt.Rows[0]["NgayKetThuc"]).Day.ToString());
xrt_hoten.Text = xrt_hoten.Text.Replace("{15}", Convert.ToDateTime(dt.Rows[0]["NgayKetThuc"]).Month.ToString());
xrt_hoten.Text = xrt_hoten.Text.Replace("{16}", Convert.ToDateTime(dt.Rows[0]["NgayKetThuc"]).Year.ToString());
//xrt_ngayketthuc.Text = "Sinh con/Nhận nuôi con ngày " + Convert.ToDateTime(dt.Rows[0]["NgayKetThuc"]).Day + " tháng " + Convert.ToDateTime(dt.Rows[0]["NgayBatDau"]).Month + " năm " + Convert.ToDateTime(dt.Rows[0]["NgayKetThuc"]).Year;
}
else
{
xrt_hoten.Text = xrt_hoten.Text.Replace("{14}", " ... ");
xrt_hoten.Text = xrt_hoten.Text.Replace("{15}", " ... ");
xrt_hoten.Text = xrt_hoten.Text.Replace("{16}", " .... ");
}
if (!string.IsNullOrEmpty(dt.Rows[0]["ThoiGianDongBaoHiem"].ToString()))
{
int nam = 0;
int thang = 0;
if (Convert.ToInt32(dt.Rows[0]["ThoiGianDongBaoHiem"]) > 12)
{
nam = nam + Convert.ToInt32(dt.Rows[0]["ThoiGianDongBaoHiem"]) / 12;
thang = thang + Convert.ToInt32(dt.Rows[0]["ThoiGianDongBaoHiem"]) % 12;
}
else
{
thang = Convert.ToInt32(dt.Rows[0]["ThoiGianDongBaoHiem"]);
}
xrt_hoten.Text = xrt_hoten.Text.Replace("{10}", nam.ToString());
xrt_hoten.Text = xrt_hoten.Text.Replace("{11}", thang.ToString());
}
else
{
xrt_hoten.Text = xrt_hoten.Text.Replace("{10}", "...");
xrt_hoten.Text = xrt_hoten.Text.Replace("{11}", "....");
}
xrt_ngay1.Text = ".........., " + "ngày " + DateTime.Now.Day + " tháng " + DateTime.Now.Month + " năm " + DateTime.Now.Year;
xrt_ngay2.Text = ".........., " + "ngày " + DateTime.Now.Day + " tháng " + DateTime.Now.Month + " năm " + DateTime.Now.Year;
}
public void BindData(ReportFilter filter)
{
DataTable dt = DataController.DataHandler.GetInstance().ExecuteDataTable("report_Tuyendung_Ds_TrungTuyen", "@TuNgay", "@DenNgay", filter.StartDate, filter.EndDate);
DataSource = dt;
this.GroupHeader1.GroupFields.AddRange(new DevExpress.XtraReports.UI.GroupField[] {
new DevExpress.XtraReports.UI.GroupField("TEN_DOT_TD", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending)
});
xrt_Dottuyendung.DataBindings.Add("Text", DataSource, "TEN_DOT_TD");
xrt_Maungvien.DataBindings.Add("Text", DataSource, "MA_UNG_VIEN");
xrt_Tenungvien.DataBindings.Add("Text", DataSource, "HO_TEN");
xrt_Ngaysinh.DataBindings.Add("Text", DataSource, "NGAY_SINH");
xrt_Gioitinh.DataBindings.Add("Text", DataSource, "GIOI_TINH");
xrt_Mucluong.DataBindings.Add("Text", DataSource, "MUC_LUONG", "{0:n0}");
xrt_Ngaydilam.DataBindings.Add("Text", DataSource, "NGAY_DI_LAM");
xrt_TongDiem.DataBindings.Add("Text", DataSource, "TONG_DIEM");
xrt_Email.DataBindings.Add("Text", DataSource, "EMAIL");
xrt_Didong.DataBindings.Add("Text", DataSource, "DI_DONG");
xrl_NgayBC.Text = "Ngày báo cáo: " + filter.ReportedDate.ToString().Remove(10);
xrtngayketxuat.Text = new ReportController().GetCityName(filter.SessionDepartment) + ", ngày " + DateTime.Now.Day + " tháng " + DateTime.Now.Month + " năm " + DateTime.Now.Year;
ReportController rpCtr = new ReportController();
if (!string.IsNullOrEmpty(filter.Title1))
{
xrl_footer1.Text = filter.Title1;
}
else
{
xrl_footer1.Text = rpCtr.GetTitleOfSignature(xrl_footer1.Text, filter.Title1);
}
if (!string.IsNullOrEmpty(filter.Title2))
{
xrl_footer2.Text = filter.Title2;
}
else
{
xrl_footer2.Text = rpCtr.GetTitleOfSignature(xrl_footer2.Text, filter.Title2);
}
if (!string.IsNullOrEmpty(filter.Title3))
{
xrl_footer3.Text = filter.Title3;
}
else
{
xrl_footer3.Text = rpCtr.GetTitleOfSignature(xrl_footer3.Text, filter.Title3);
}
if (!string.IsNullOrEmpty(filter.Name1))
{
xrl_ten1.Text = filter.Name1;
}
else
{
xrl_ten1.Text = rpCtr.GetCreatedReporterName(filter.SessionDepartment, filter.Reporter);
}
if (!string.IsNullOrEmpty(filter.Name2))
{
xrl_ten2.Text = filter.Name2;
}
else
{
xrl_ten2.Text = rpCtr.GetHeadAccountant(filter.SessionDepartment, filter.Name2);
}
if (!string.IsNullOrEmpty(filter.Name3))
{
xrl_ten3.Text = filter.Name3;
}
else
{
xrl_ten3.Text = rpCtr.GetHeadOfHRroom(filter.SessionDepartment, filter.Name3);
}
//tieu de
if (!string.IsNullOrEmpty(filter.ReportTitle))
{
xrl_TitleBC.Text = filter.ReportTitle;
}
}
private async Task <List <KycStatusLogRecord> > GetKycStatusLogRecords(DateTime startDate, DateTime endDate)
{
ReportFilter f = new ReportFilter();
f.DatePeriod = new DatePeriod();
f.DatePeriod.StartDate = startDate;
f.DatePeriod.EndDate = endDate;
IEnumerable <IKycStatuschangeItem> items = await _kycStatusService.GetRecordsForPeriodAsync(f);
if (items == null || items.Count() == 0)
{
return(new List <KycStatusLogRecord>());
}
IEnumerable <Partner> partners = await _partnersService.GetPartnersAsync();
Dictionary <string, string> partnersDict = new Dictionary <string, string>();
foreach (Partner p in partners)
{
partnersDict[p.PublicId] = p.Name;
}
Dictionary <string, ClientAccountInformationModel> clients = null;
clients = (await _clientAccountService.GetClientsByIdsAsync(items.Select(_ => _.ClientId).Distinct().ToArray())).ToDictionary(_ => _.Id, _ => _);
var auditLogEntities = items.Select(item =>
{
var status = (KycStatus)item.CurrentStatus;
var previousStatus = (KycStatus)item.PreviousStatus;
string kycOfficer;
if (item != null && item.Changer != null && item.Changer.StartsWith(_boChanger))
{
kycOfficer = item.Changer.Substring(_boChanger.Length);
}
else
{
return(null);
}
var partnerName = _lykkeWalletPartnerName;
ClientAccountInformationModel client;
if (clients.TryGetValue(item.ClientId, out client))
{
if (!String.IsNullOrWhiteSpace(client.PartnerId))
{
if (partnersDict.TryGetValue(client.PartnerId, out string name))
{
partnerName = name;
}
else
{
partnerName = null;
_log.WriteWarningAsync("GetKycStatusLogRecords", new { startDate, endDate }.ToJson(), $"Cannot find Partner with ID = {client.PartnerId}");
}
}
}
return(new KycStatusLogRecord(item.ClientId, status, previousStatus, item.CreatedTime, kycOfficer, partnerName));
}).Where(item => item != null).ToList();
return(auditLogEntities);
}
/// <summary>
/// Builds a collection of table rows from a collection of query rows
/// </summary>
/// <param name="tableDefinition">The table definition</param>
/// <param name="sectionType">The report section type</param>
/// <param name="filter">The report filter</param>
/// <param name="queryRows">The query rows</param>
/// <returns>A collection of table rows</returns>
private IEnumerable <TableRow> BuildTableRows
(
TableDefinition tableDefinition,
ReportSectionType sectionType,
ReportFilter filter,
IEnumerable <QueryRow> queryRows
)
{
var tableRows = new List <TableRow>();
var actionDefinition = tableDefinition.RowAction;
var columnDefinitions = GetColumnsDynamically
(
tableDefinition,
filter
);
foreach (var queryRow in queryRows)
{
var tableCells = new List <TableCell>();
foreach (var columnDefinition in columnDefinitions)
{
var value = ResolveColumnValue
(
columnDefinition,
queryRow
);
var action = default(ReportAction);
if (columnDefinition.CellAction != null)
{
action = columnDefinition.CellAction.Resolve
(
queryRow
);
}
var cell = CreateTableCell
(
columnDefinition,
value,
action
);
tableCells.Add(cell);
}
var importance = DataImportance.Default;
if (tableDefinition.RowImportanceRules.Any())
{
foreach (var rule in tableDefinition.RowImportanceRules)
{
var columnName = rule.ColumnName;
var candidateValue = queryRow[columnName].Value;
if (rule.Matches(candidateValue))
{
importance = rule.ImportanceOnMatch;
}
}
}
var tableRow = new TableRow
(
importance,
tableCells.ToArray()
);
if (tableDefinition.RowAction != null)
{
var action = actionDefinition.Resolve
(
queryRow
);
tableRow = tableRow.WithAction
(
action
);
}
tableRows.Add(tableRow);
}
if (false == tableDefinition.DisableSorting)
{
var sortingRules = filter.GetSortingRules
(
sectionType,
tableDefinition.Name
);
tableRows = SortRows(tableRows, sortingRules).ToList();
}
return(tableRows);
}
public virtual ActionResult ListData([ModelBinder(typeof(DataTablesBinder))] IDataTablesRequest request, ReportFilter reportFilter = null)
{
var tasks = this.GetTasks(request, reportFilter);
var rows = columns.ExtractRows(tasks.DecorateReport());
return Json(new DataTablesResponse(request.Draw, rows, tasks.TotalItems, tasks.TotalItems));
}
/// <summary>
/// Asynchronously generates a component from a report definition and filter
/// </summary>
/// <param name="definition">The component definition</param>
/// <param name="sectionType">The report section type</param>
/// <param name="filter">The report filter</param>
/// <returns>The report component generated</returns>
public override async Task <IReportComponent> GenerateAsync
(
IReportComponentDefinition definition,
ReportSectionType sectionType,
ReportFilter filter
)
{
Validate.IsNotNull(definition);
Validate.IsNotNull(filter);
var table = default(Table);
var tableDefinition = definition.As <TableDefinition>();
var query = tableDefinition.Query;
var defaultParameters = tableDefinition.DefaultParameterValues;
var queryTask = query.ExecuteAsync
(
filter,
defaultParameters.ToArray()
);
var results = await queryTask.ConfigureAwait
(
false
);
var columnsTask = GetColumnsDynamicallyAsync
(
tableDefinition,
filter
);
var columnDefinitions = await columnsTask.ConfigureAwait
(
false
);
if (results.HasMultipleGroupings)
{
var tableGroups = new List <TableGrouping>();
foreach (var queryGroup in results.Groupings)
{
var groupRows = BuildTableRows
(
tableDefinition,
sectionType,
filter,
queryGroup.Rows
);
var tableGroup = new TableGrouping
(
queryGroup.GroupingValues,
groupRows.ToArray()
);
if (groupRows.Any() && tableDefinition.HasTotals)
{
var totals = GenerateTotals
(
tableDefinition,
filter,
queryGroup.Rows
);
tableGroup.SetTotals(totals);
}
tableGroups.Add(tableGroup);
}
table = new Table
(
tableDefinition,
columnDefinitions,
tableGroups
);
}
else
{
var tableRows = BuildTableRows
(
tableDefinition,
sectionType,
filter,
results.AllRows
);
table = new Table
(
tableDefinition,
columnDefinitions,
tableRows
);
}
if (table.AllRows.Any() && tableDefinition.HasTotals)
{
var totals = GenerateTotals
(
tableDefinition,
filter,
results.AllRows
);
table.SetTotals(totals);
}
_columnValueCache.Clear();
return(table);
}
/// <summary>
/// Returns a set of casts with element information
/// </summary>
/// <param name="filter">curFilter</param>
/// <param name="reportFilter"> </param>
/// <returns></returns>
public CastScheduleData LoadCastSchedule( BedFilter filter, ReportFilter reportFilter )
{
if( filter == null || string.IsNullOrEmpty( filter.Factory ) || string.IsNullOrEmpty( filter.Project ) )
{
return null;
}
var query = new ImpactQuery()
{
Select =
{
ImpProductionCast.CastId,
ImpProductionCast.Description,
ImpProductionCast.StartDate,
ImpProductionCast.EndDate,
ImpProductionCast.Tolerance,
ImpProductionCast.ElementType,
ImpProductionCast.Style,
ImpProductionCast.Strandptn,
ImpProductionCast.CastStatus,
ImpProductionCast.CastType,
ImpProductionCast.Form,
ImpProductionCast.Shift,
Aggregate.Count( ImpProductionCastStrand.StrandPos ),
ImpProductionFormStd.Location,
ImpProductionFormStd.FormType,
ImpProductionFormStd.MaxLength,
ImpProductionFormStd.MaxWidth,
ImpProductionFormStd.MaxHeight,
ImpProductionFormStd.ElementType,
ImpModelPlanning.ElementId,
ImpModelGeometry.ElementMark,
ImpModelGeometry.Building,
ImpModelGeometry.FloorId,
ImpModelGeometry.Phase,
ImpModelPlanning.ErectionSequenceNo,
ImpModelPlanning.TransportId,
ImpModelPlanning.BedSequenceNo,
ImpModelPlanning.BedX,
ImpModelPlanning.BedY,
ImpModelPlanning.BedZ,
ImpModelPlanning.BedRotation,
ImpModelPlanning.ElementIdStatus,
ImpModelPlanning.ProductionDate,
ImpModelPlanning.PlannedProductionDate,
ImpElement.ElementLength,
ImpElement.ElementWidth,
ImpElement.ElementHeight,
ImpElement.ElementType,
ImpElement.GrossArea,
ImpElement.NetArea,
ImpElement.Volume,
ImpElement.Product,
ImpElement.Project,
ImpElement.AngleLeftSide,
ImpElement.AngleRightSide,
ImpElement.Mass,
ImpElement.Style,
ImpElement.Strandptn,
ImpElement.NbrOfStrands,
},
From = { ImpProductionCast.As( "CST" ) },
Join =
{
Join.Left( ImpProductionCastStrand.As( "STA" ),
ImpProductionCast.Factory.Equal( ImpProductionCastStrand.Factory ),
ImpProductionCast.Project.Equal( ImpProductionCastStrand.Project ),//Factory, Factory
ImpProductionCast.CastId.Equal( ImpProductionCastStrand.CastId ) ),
Join.Left( ImpProductionFormStd.As( "FRM" ),
ImpProductionCast.Factory.Equal( ImpProductionFormStd.Factory ),
ImpProductionCast.Project.Equal( ImpProductionFormStd.Project ),// Factory, Factory for productionCast & ProductionCastStrand
ImpProductionCast.Form.Equal( ImpProductionFormStd.Name ) ),
Join.Left( ImpModelPlanning.As( "MPL" ),
ImpProductionCast.Factory.Equal( ImpModelPlanning.Factory ),
ImpProductionCast.Project.Equal( ImpModelPlanning.Factory ),// Factory, Factory for productionCast & ProductionCastStrand
ImpProductionCast.CastId.Equal( ImpModelPlanning.CastId ) ),
Join.Left( ImpModelGeometry.As( "MGO" ),
ImpModelPlanning.Factory.Equal( ImpModelGeometry.Factory ),
ImpModelPlanning.Project.Equal( ImpModelGeometry.Project ),
ImpModelPlanning.ElementId.Equal( ImpModelGeometry.ElementId ) ),
Join.Left( ImpElement.As( "ELM" ),
ImpModelGeometry.Factory.Equal( ImpElement.Factory ),
ImpModelGeometry.Project.Equal( ImpElement.Project ),
ImpModelGeometry.ElementMark.Equal( ImpElement.ElementMark ) ),
},
Where = {
ImpProductionCast.Factory.Equal( filter.Factory ),
ImpProductionCast.Project.Equal( filter.Factory ), // Factory, Factory for productionCast & ProductionCastStrand
//ImpModelPlanning.CastId.GreaterThan( 0 ),
},
GroupBy =
{
ImpProductionCast.CastId,
ImpProductionCast.Description,
ImpProductionCast.StartDate,
ImpProductionCast.EndDate,
ImpProductionCast.Tolerance,
ImpProductionCast.ElementType,
ImpProductionCast.Style,
ImpProductionCast.Strandptn,
ImpProductionCast.CastStatus,
ImpProductionCast.CastType,
ImpProductionCast.Form,
ImpProductionCast.Shift,
ImpProductionFormStd.Location,
ImpProductionFormStd.FormType,
ImpProductionFormStd.MaxLength,
ImpProductionFormStd.MaxWidth,
ImpProductionFormStd.MaxHeight,
ImpProductionFormStd.ElementType,
ImpModelPlanning.ElementId,
ImpModelGeometry.ElementMark,
ImpModelGeometry.Building,
ImpModelGeometry.FloorId,
ImpModelGeometry.Phase,
ImpModelPlanning.ErectionSequenceNo,
ImpModelPlanning.TransportId,
ImpModelPlanning.BedSequenceNo,
ImpModelPlanning.BedX,
ImpModelPlanning.BedY,
ImpModelPlanning.BedZ,
ImpModelPlanning.BedRotation,
ImpModelPlanning.ElementIdStatus,
ImpModelPlanning.ProductionDate,
ImpModelPlanning.PlannedProductionDate,
ImpElement.ElementLength,
ImpElement.ElementWidth,
ImpElement.ElementHeight,
ImpElement.ElementType,
ImpElement.GrossArea,
ImpElement.NetArea,
ImpElement.Volume,
ImpElement.Product,
ImpElement.Project,
ImpElement.AngleLeftSide,
ImpElement.AngleRightSide,
ImpElement.Mass,
ImpElement.Style,
ImpElement.Strandptn,
ImpElement.NbrOfStrands,
},
OrderBy =
{
{ ImpElement.Project },
{ ImpProductionCast.StartDate, OrderBy.Descending },
{ ImpProductionCast.CastId },
},
};
var whereStatus = WhereGroup.Or( new Where[] { } );
if( filter.NoStatus )
{
whereStatus.Add( ImpProductionCast.CastStatus.Equal( CastStatus.NoStatus ) );
}
if( filter.Planned )
{
whereStatus.Add( ImpProductionCast.CastStatus.Equal( CastStatus.Planned ) );
}
if( filter.Produced )
{
whereStatus.Add( ImpProductionCast.CastStatus.Equal( CastStatus.Produced ) );
}
if( whereStatus.Count > 0 )
{
query.Where.Add( whereStatus );
}
if( filter.UseStartDateFrom )
{
query.Where.Add( ImpProductionCast.StartDate.GreaterThanOrEqual( filter.StartDateFrom ) );
}
if( filter.UseStartDateTo )
{
query.Where.Add( ImpProductionCast.StartDate.LessThanOrEqual( filter.StartDateTo ) );
}
if( filter.UseEndDateFrom )
{
query.Where.Add( ImpProductionCast.EndDate.GreaterThanOrEqual( filter.EndDateFrom ) );
}
if( filter.UseEndDateTo )
{
query.Where.Add( ImpProductionCast.EndDate.LessThanOrEqual( filter.EndDateTo ) );
}
if( filter.Shift != 0 )
{
query.Where.Add( ImpProductionCast.Shift.Equal( filter.Shift ) );
}
if( !string.IsNullOrEmpty(filter.Location) && !filter.Location.Equals( Filter.All ) )
{
query.Where.Add( ImpProductionFormStd.Location.Equal( filter.Location ) );
}
if( !filter.Bed.Equals( Filter.All ) )
{
query.Where.Add( ImpProductionCast.Form.Equal( filter.Bed ) );
}
if( !string.IsNullOrEmpty( filter.CastId ) )
{
query.Where.Add( ImpProductionCast.CastId.Like( filter.CastId ) );
}
if( reportFilter != null && reportFilter.Ranges.Count > 0 )
{
var list = new List<Where>();
foreach( var range in reportFilter.Ranges )
{
if( !string.IsNullOrEmpty( range.From ) && !string.IsNullOrEmpty( range.To ) )
{
list.Add( ImpProductionCast.CastId.Between( range.From, range.To ) );
}
}
if( list.Count > 0 )
{
query.Where.Add( WhereGroup.Or( list.ToArray() ) );
}
}
var statement = query.ToString();
var tmList = new List<RecProductionCast>();
var parser = new CastParser( tmList );
using( var database = new ImpactDatabase() )
{
var list = database.GetAll( statement, ParseSchedule );
foreach( var item in list )
{
item.Form.Factory = filter.Factory;
item.Cast.Factory = filter.Factory;
item.Form.Project = filter.Project;
item.Cast.Project = filter.Project;
if( null != item.Element )
{
item.Element.Factory = filter.Factory;
// Never set element.project to curFilter.project
// since we retrieve elmenets from different projects!
}
parser.Parse( item.Form, item.Cast, item.Element );
}
}
// Now load all the existing forms
var formSvc = new ProjectManager();
var productionFormStdData = formSvc.LoadProductionFormStd( new BedFilter( filter ) { Location = Filter.All } );
return new CastScheduleData( tmList, productionFormStdData );
}
/// <summary>
/// Generates the totals for a collection of query rows
/// </summary>
/// <param name="tableDefinition">The table definition</param>
/// <param name="filter">The report filter</param>
/// <param name="rows">The query rows</param>
/// <returns>The totals as table cells</returns>
private IEnumerable <TableCell> GenerateTotals
(
TableDefinition tableDefinition,
ReportFilter filter,
IEnumerable <QueryRow> rows
)
{
var cells = new List <TableCell>();
var columnDefinitions = GetColumnsDynamically
(
tableDefinition,
filter
);
foreach (var columnDefinition in columnDefinitions)
{
var cell = default(TableCell);
if (columnDefinition.HasTotal)
{
var total = default(double);
if (columnDefinition.IsDynamic)
{
var cellValues = _columnValueCache[columnDefinition.Name];
var numbers = new List <double>();
// Convert the cell values into their double equivalent
foreach (var value in cellValues)
{
if (value == null)
{
numbers.Add(0);
}
else
{
Double.TryParse
(
value.ToString(),
out double number
);
numbers.Add(number);
}
}
total = columnDefinition.TotalAggregator.Execute
(
numbers.ToArray()
);
}
else
{
total = columnDefinition.TotalAggregator.Execute
(
rows.ToArray()
);
}
var format = columnDefinition.TotalFormat;
if (format == null)
{
cell = CreateTableCell
(
columnDefinition,
total
);
}
else
{
var formattedTotal = String.Format
(
format,
total
);
cell = CreateTableCell
(
columnDefinition,
formattedTotal
);
}
}
else
{
cell = CreateTableCell
(
columnDefinition,
null
);
}
cells.Add(cell);
}
return(cells);
}
/// <summary>
/// Initializes the filter.
/// </summary>
/// <param name="reportFilter">The report filter.</param>
private static void InitializeFilter(ReportFilter reportFilter)
{
reportFilter.DateFrom = DateTimeHelper.RetrieveCurrentDate();
reportFilter.DateTo = reportFilter.DateFrom;
reportFilter.IsInactive = false;
reportFilter.IsExceeded = true;
reportFilter.IsMonthOrYearRoaster = true;
reportFilter.SelectedProject = -1;
reportFilter.SelectedDeveloper = -1;
reportFilter.SelectedProductivityType = 0;
reportFilter.WorkCategory = -1;
reportFilter.SelectedClient = -1;
reportFilter.ProjectIds = null;
reportFilter.ClientDependency = 0;
reportFilter.GroupByForDailyReport = GroupByForDeveloper;
reportFilter.Instances = 1;
reportFilter.SelectedRoleGroup = 0;
reportFilter.IsReportInPercentage = true;
reportFilter.IsReportInSummaryView = true;
reportFilter.DevloperName = null;
}
private void CreateControls(Control panel, EntityStructure entityStructure, List <DefaultValue> dsdefaults)
{
BindingData = new BindingSource[entityStructure.Fields.Count - 1];
int maxlabelsize = 0;
int maxDatasize = 0;
foreach (EntityField col in entityStructure.Fields)
{
int x = getTextSize(col.fieldname);
if (maxlabelsize < x)
{
maxlabelsize = x;
}
}
maxDatasize = this.Width - maxlabelsize - 20;
entityStructure.Filters.Clear();
List <string> FieldNames = new List <string>();
var starth = 25;
int startleft = maxlabelsize + 90;
int valuewidth = 100;
for (int i = 0; i < entityStructure.Fields.Count - 1; i++)
{
ReportFilter r = new ReportFilter();
r.FieldName = entityStructure.Fields[i].fieldname;
r.Operator = null;
r.FilterValue = null;
r.FilterValue1 = null;
r.valueType = entityStructure.Fields[i].fieldtype;
entityStructure.Filters.Add(r);
BindingData[i] = new BindingSource();
BindingData[i].DataSource = r;
FieldNames.Add(entityStructure.Fields[i].fieldname);
EntityField col = entityStructure.Fields[i];
try
{
DefaultValue coldefaults = dsdefaults.Where(o => o.propertyName == col.fieldname).FirstOrDefault();
if (coldefaults == null)
{
coldefaults = dsdefaults.Where(o => col.fieldname.Contains(o.propertyName)).FirstOrDefault();
}
string coltype = col.fieldtype;
RelationShipKeys FK = entityStructure.Relations.Where(f => f.EntityColumnID == col.fieldname).FirstOrDefault();
//----------------------
Label l = new Label
{
Top = starth,
Left = 10,
AutoSize = false,
BorderStyle = BorderStyle.FixedSingle,
Text = col.fieldname,
BackColor = Color.White,
ForeColor = Color.Red
};
l.Size = TextRenderer.MeasureText(col.fieldname, l.Font);
l.Height += 10;
l.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
l.Width = maxlabelsize;
//---------------------
ComboBox cbcondition = new ComboBox
{
Left = l.Left + l.Width + 10,
Top = starth
};
//string DisplayField = FK.EntityColumnID;
//cbcondition.DataSource = Visutil.controlEditor.GetDisplayLookup(ds.DatasourceName, FK.ParentEntityID, FK.ParentEntityColumnID);
//cbcondition.DisplayMember = DisplayField;
//cbcondition.ValueMember = FK.ParentEntityColumnID;
cbcondition.DataSource = AddFilterTypes();
cbcondition.DisplayMember = "FilterDisplay";
cbcondition.ValueMember = "FilterValue";
cbcondition.SelectedValueChanged += Cb_SelectedValueChanged;
cbcondition.Width = 50;
cbcondition.Height = l.Height;
// cbcondition.SelectedText
cbcondition.DataBindings.Add(new System.Windows.Forms.Binding("SelectedValue", BindingData[i], "Operator", true, DataSourceUpdateMode.OnPropertyChanged));
// cbcondition.Anchor = AnchorStyles.Top;
this.Controls.Add(cbcondition);
if (FK != null)
{
ComboBox cb = new ComboBox
{
Left = startleft,
Top = starth
};
string DisplayField = FK.EntityColumnID;
cb.DataSource = Visutil.controlEditor.GetDisplayLookup(ds.DatasourceName, FK.ParentEntityID, FK.ParentEntityColumnID);
cb.DisplayMember = DisplayField;
cb.ValueMember = FK.ParentEntityColumnID;
cb.Width = valuewidth;
cb.Height = l.Height;
cb.DataBindings.Add(new System.Windows.Forms.Binding("TEXT", BindingData[i], "FilterValue", true));
cb.SelectedValueChanged += Cb_SelectedValueChanged;
//cb.Anchor = AnchorStyles.Top;
this.Controls.Add(cb);
starth = l.Bottom + 1;
}
else
{
switch (coltype)
{
case "System.DateTime":
DateTimePicker dt = new DateTimePicker
{
Left = startleft,
Top = starth
};
dt.DataBindings.Add(new System.Windows.Forms.Binding("Value", BindingData[i], "FilterValue", true));
dt.Width = valuewidth;
dt.Height = l.Height;
dt.ValueChanged += Dt_ValueChanged;
// dt.Anchor = AnchorStyles.Top;
dt.Tag = i;
dt.Format = DateTimePickerFormat.Short;
this.Controls.Add(dt);
DateTimePicker dt1 = new DateTimePicker
{
Left = dt.Left + 10 + dt.Width,
Top = starth
};
dt1.DataBindings.Add(new System.Windows.Forms.Binding("Value", BindingData[i], "FilterValue1", true));
dt1.Width = valuewidth;
dt1.Height = l.Height;
dt1.Format = DateTimePickerFormat.Short;
dt1.ValueChanged += Dt_ValueChanged;
// dt.Anchor = AnchorStyles.Top;
dt1.Tag = i;
this.Controls.Add(dt1);
break;
case "System.TimeSpan":
TextBox t1 = new TextBox
{
Left = startleft,
Top = starth
};
t1.DataBindings.Add(new System.Windows.Forms.Binding("Text", BindingData[i], "FilterValue", true));
t1.TextAlign = HorizontalAlignment.Left;
t1.Width = valuewidth;
t1.Height = l.Height;
t1.Tag = i;
t1.TextChanged += T_TextChanged;
// t1.KeyPress += T_KeyPress;
// t1.Anchor = AnchorStyles.Top;
this.Controls.Add(t1);
break;
case "System.Boolean":
CheckBox ch1 = new CheckBox
{
Left = startleft,
Top = starth
};
ch1.DataBindings.Add(new System.Windows.Forms.Binding("CheckState", BindingData[i], "FilterValue", true));
ch1.Text = "";
ch1.Width = valuewidth;
ch1.Height = l.Height;
ch1.CheckStateChanged += Ch1_CheckStateChanged;;
// ch1.Anchor = AnchorStyles.Top;
ch1.Tag = i;
this.Controls.Add(ch1);
break;
case "System.Char":
MyCheckBox ch2 = new MyCheckBox
{
Left = startleft,
Top = starth
};
ch2.DataBindings.Add(new System.Windows.Forms.Binding("Checked", BindingData[i], "FilterValue", true));
ch2.Text = "";
ch2.Width = valuewidth;
ch2.Height = l.Height;
string[] v = coldefaults.propoertValue.Split(',');
if (coldefaults != null)
{
ch2.TrueValue = v[0].ToCharArray()[0];
ch2.FalseValue = v[1].ToCharArray()[0];
}
ch2.CheckStateChanged += Ch1_CheckStateChanged;;
// ch2.Anchor = AnchorStyles.Top;
ch2.Tag = i;
this.Controls.Add(ch2);
break;
case "System.Int16":
case "System.Int32":
case "System.Int64":
case "System.Decimal":
case "System.Double":
case "System.Single":
NumericUpDown t3 = new NumericUpDown();
t3.Left = startleft;
t3.Top = starth;
t3.DataBindings.Add(new System.Windows.Forms.Binding("Value", BindingData[i], "FilterValue", true));
t3.TextAlign = HorizontalAlignment.Left;
t3.Width = valuewidth;
t3.Height = l.Height;
t3.Tag = i;
t3.TextChanged += T_TextChanged;
//t.KeyPress += T_KeyPress;
if (entityStructure.PrimaryKeys.Where(x => x.fieldname == col.fieldname).FirstOrDefault() != null)
{
t3.Enabled = false;
}
this.Controls.Add(t3);
NumericUpDown t2 = new NumericUpDown();
t2.Left = t3.Left + t3.Width + 10;
t2.Top = starth;
t2.DataBindings.Add(new System.Windows.Forms.Binding("Value", BindingData[i], "FilterValue1", true));
t2.TextAlign = HorizontalAlignment.Left;
t2.Width = valuewidth;
t2.Height = l.Height;
t2.Tag = i;
t2.TextChanged += T_TextChanged;
//t.KeyPress += T_KeyPress;
if (entityStructure.PrimaryKeys.Where(x => x.fieldname == col.fieldname).FirstOrDefault() != null)
{
t2.Enabled = false;
}
// t.Anchor = AnchorStyles.Top;
this.Controls.Add(t2);
// t.Anchor = AnchorStyles.Top;
break;
case "System.String":
if (entityStructure.Fields.Where(p => p.fieldname == col.fieldname).FirstOrDefault().Size1 > 1)
{
t1 = new TextBox
{
Left = startleft,
Top = starth
};
t1.DataBindings.Add(new System.Windows.Forms.Binding("Text", BindingData[i], "FilterValue", true));
t1.TextAlign = HorizontalAlignment.Left;
t1.Width = valuewidth;
t1.Height = l.Height;
t1.TextChanged += T_TextChanged;
// t1.KeyPress += T_KeyPress;
if (entityStructure.PrimaryKeys.Any(x => x.fieldname == col.fieldname))
{
if (entityStructure.Relations.Any(x => x.EntityColumnID == col.fieldname))
{
t1.Enabled = false;
}
}
this.Controls.Add(t1);
t1.Tag = i;
// t1.Anchor = AnchorStyles.Top;
}
else
{
ch2 = new MyCheckBox
{
Left = startleft,
Top = starth
};
ch2.DataBindings.Add(new System.Windows.Forms.Binding("Checked", BindingData[i], "FilterValue", true));
ch2.Text = "";
ch2.Width = valuewidth;
ch2.Height = l.Height;
ch2.Tag = i;
if (coldefaults != null)
{
v = coldefaults.propoertValue.Split(',');
ch2.TrueValue = v[0].ToCharArray()[0];
ch2.FalseValue = v[1].ToCharArray()[0];
}
// ch2.CheckStateChanged += Ch1_CheckStateChanged; ;
this.Controls.Add(ch2);
// ch2.Anchor = AnchorStyles.Top;
}
break;
default:
TextBox t = new TextBox();
t.Left = startleft;
t.Top = starth;
t.DataBindings.Add(new System.Windows.Forms.Binding("Text", BindingData[i], "FilterValue", true));
t.TextAlign = HorizontalAlignment.Left;
t.Width = valuewidth;
t.Height = l.Height;
t.Tag = i;
t.TextChanged += T_TextChanged;
//t.KeyPress += T_KeyPress;
if (entityStructure.PrimaryKeys.Where(x => x.fieldname == col.fieldname).FirstOrDefault() != null)
{
t.Enabled = false;
}
// t.Anchor = AnchorStyles.Top;
this.Controls.Add(t);
break;
}
}
// l.Anchor = AnchorStyles.Top;
this.Controls.Add(l);
starth = l.Bottom + 1;
}
catch (Exception ex)
{
Logger.WriteLog($"Error in Loading View ({ex.Message}) ");
}
}
}
/// <summary>
/// Load
/// </summary>
/// <param name="reportFilter"></param>
/// <returns></returns>
public DrawingReportData Load( ReportFilter reportFilter )
{
var data = new DrawingReportData();
var query = new ImpactQuery()
{
Select =
{
ImpDrawing.Factory,
ImpDrawing.Project,
ImpDrawing.DrawingName,
ImpDrawing.DrawingType,
ImpDrawing.DesignedBy,
ImpDrawing.Status,
ImpDrawing.ApprovedDate,
ImpDrawing.CreatedDate,
ImpDrawing.Text6,
},
From = { ImpDrawing.As( "T1" ) },
Join =
{
Join.Left(
ImpElement.As( "T2" ),
ImpDrawing.Factory.Equal( ImpElement.Factory ),
ImpDrawing.Project.Equal( ImpElement.Project ),
ImpDrawing.DrawingName.Equal( ImpElement.DrawingName ) ),
},
Where =
{
ImpDrawing.Factory.Equal( reportFilter.Factory ),
ImpDrawing.Project.Equal( reportFilter.Project ),
},
};
if( reportFilter.Ranges.Count > 0 )
{
var list = new List<Where>();
foreach( var range in reportFilter.Ranges )
{
if( !string.IsNullOrEmpty( range.From ) && !string.IsNullOrEmpty( range.To ) )
{
list.Add( ImpDrawing.DrawingName.Between( range.From, range.To ) );
}
}
if( list.Count > 0 )
{
query.Where.Add( WhereGroup.Or( list.ToArray() ) );
}
}
var statement = query.ToString();
using( var database = new ImpactDatabase() )
{
data.Rows = database.GetAll( statement, column => new DrawingReportRow()
{
Factory = column[0].Cast<string>(),
Project = column[1].Cast<string>(),
DrawingName = column[2].Cast<string>(),
DrawingType = column[3].Cast<string>(),
DesignedBy = column[4].Cast<string>(),
Status = column[5].Cast<string>(),
ApprovedDate = column[6].Cast<DateTime?>(),
CreatedDate = column[7].Cast<DateTime?>(),
DrawingText6 = column[8].Cast<string>(),
} );
}
return data;
}
/// <summary>
/// Initializes the filter.
/// </summary>
/// <param name="reportFilter">The report filter.</param>
private static void InitializeFilter(ReportFilter reportFilter)
{
reportFilter.DateFrom = DateTimeHelper.RetrieveCurrentDate();
reportFilter.DateFromYear = DateTimeHelper.RetrieveCurrentDate();
reportFilter.DateTo = reportFilter.DateFrom;
reportFilter.DateToYear = reportFilter.DateFromYear;
reportFilter.DueDateTo = reportFilter.DateFrom.RetrieveWeekEndDate();
reportFilter.StartDateFrom = reportFilter.DateFrom.AddDays(-3);
reportFilter.StartDateTo = DateTimeHelper.RetrieveCurrentDate();
reportFilter.DateFromRelease = DateTimeHelper.RetrieveCurrentDate().AddDays(-7);
reportFilter.DateToRelease = DateTimeHelper.RetrieveCurrentDate().AddDays(7);
reportFilter.DateFromTeamReporting = DateTimeHelper.RetrieveCurrentDate().AddMonths(-6);
reportFilter.DateFromRoleProductivity = DateTimeHelper.RetrieveCurrentDate();
reportFilter.DateToRoleProductivity = DateTimeHelper.RetrieveCurrentDate().AddMonths(6);
reportFilter.IsInactive = false;
reportFilter.IsExceeded = true;
reportFilter.IsMonthOrYearRoaster = true;
reportFilter.IsMonthOrYearRoasterValidate = true;
reportFilter.IsHourlyOrByHeadcount = true;
reportFilter.SelectedProject = -1;
reportFilter.SelectedDeveloper = -1;
reportFilter.SelectedProductivityType = 0;
reportFilter.WorkCategory = -1;
reportFilter.SelectedClient = -1;
reportFilter.SelectedClientProject = -1;
reportFilter.ProjectIds = null;
reportFilter.ClientDependency = 0;
reportFilter.GroupByForDailyReport = GroupByForDeveloper;
reportFilter.Instances = 1;
reportFilter.SelectedRoleGroup = 0;
reportFilter.IsReportInPercentage = true;
reportFilter.IsReportInSummaryView = true;
reportFilter.DevloperName = null;
reportFilter.FeedbackStatus = Zero;
reportFilter.SelectedLeaveType = -1;
reportFilter.HaveTimesheetFilled = false;
reportFilter.IsCalibratedHours = false;
reportFilter.IsTeamViewOrProjectView = true;
reportFilter.Rework = 0;
}
