private void LoadReport(string path, List <ViewLateComer> _Employee)
{
string DateToFor = "";
if (DateFrom.Date.ToString("d") == DateTo.ToString("d"))
{
DateToFor = "Date : " + DateFrom.Date.ToString("d");
}
else
{
DateToFor = "From : " + DateFrom.Date.ToString("d") + " To: " + DateTo.Date.ToString("d");
}
string _Header = "Late In Report";
this.ReportViewer1.LocalReport.DisplayName = "LateIn Report";
ReportViewer1.ProcessingMode = ProcessingMode.Local;
ReportViewer1.LocalReport.ReportPath = Server.MapPath(path);
System.Security.PermissionSet sec = new System.Security.PermissionSet(System.Security.Permissions.PermissionState.Unrestricted);
ReportViewer1.LocalReport.SetBasePermissionsForSandboxAppDomain(sec);
IEnumerable <ViewLateComer> ie;
ie = _Employee.AsQueryable();
ReportDataSource datasource1 = new ReportDataSource("DataSet1", ie);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(datasource1);
ReportParameter rp = new ReportParameter("Date", DateToFor, false);
ReportParameter rp1 = new ReportParameter("Header", _Header, false);
this.ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { rp, rp1 });
ReportViewer1.LocalReport.Refresh();
}
/// <summary>
/// 取得查詢結果資料
/// </summary>
/// <param name="vCreate_Date_From">入庫日期(起)</param>
/// <param name="vCreate_Date_To">入庫日期(迄)</param>
/// <param name="vTrea_Register_Id">金庫登記簿單號</param>
/// <returns></returns>
public List <TreasuryRegisterSearch> GetSearchList(string vCreate_Date_From, string vCreate_Date_To, string vTrea_Register_Id)
{
var result = new List <TreasuryRegisterSearch>();
DateTime DateFrom, DateTo;
DateTime.TryParse(vCreate_Date_From, out DateFrom);
if (DateTime.TryParse(vCreate_Date_To, out DateTo))
{
DateTo = DateTo.DateToLatestTime();
}
using (TreasuryDBEntities db = new TreasuryDBEntities())
{
var _Open_Trea_Type = db.SYS_CODE.AsNoTracking().Where(x => x.CODE_TYPE == "OPEN_TREA_TYPE").ToList();
var _Regi_Status = db.SYS_CODE.AsNoTracking().Where(x => x.CODE_TYPE == "FORM_STATUS").ToList();
result = GetSearchModel(db.TREA_OPEN_REC.AsNoTracking()
.Where(x => x.CREATE_DT >= DateFrom, !vCreate_Date_From.IsNullOrWhiteSpace())
.Where(x => x.CREATE_DT <= DateTo, !vCreate_Date_To.IsNullOrWhiteSpace())
.Where(x => x.TREA_REGISTER_ID == vTrea_Register_Id, !vTrea_Register_Id.IsNullOrWhiteSpace())
.AsEnumerable()
, _Open_Trea_Type, _Regi_Status).ToList();
}
return(result);
}
private void pageHeader_Format(object sender, EventArgs e)
{
lblWarehouse.Text = Warehouse.ToString();
lblWBServiceProvider.Text = WBServiceProvider.ToString();
lblFromDate.Text = DateFrom.ToString();
lblToDate.Text = DateTo.ToString();
}
private void btnOK_Click(object sender, EventArgs e)
{
if (this.CompanyID.GetCheckedValues().Length == 0)
{
Mess.Info("Please select at least one company!");
CompanyID.ShowPopup();
return;
}
if (this.LocationID.GetCheckedValues().Length == 0)
{
Mess.Info("Please select at least one location!");
LocationID.ShowPopup();
return;
}
if (DateFrom.EditValue == null || DateFrom.DateTime == DateTime.MinValue)
{
Mess.Info("Please select a Period From!");
DateFrom.ShowPopup();
return;
}
if (DateTo.EditValue == null || DateTo.DateTime == DateTime.MinValue)
{
Mess.Info("Please select a Period To!");
DateTo.ShowPopup();
return;
}
this.DialogResult = System.Windows.Forms.DialogResult.Yes;
this.Close();
}
public void onSaveClick()
{
if (Todo == null || mContentPage == null)
{
return;
}
Todo.From = DateFrom.Add(TimeFrom);
Todo.To = DateTo.Add(TimeTo);
if (Todo.From.CompareTo(Todo.To) > 0 ||
String.IsNullOrEmpty(Todo.Title))
{
mContentPage.DisplayAlert("Warning",
"1.Please enter \"Title\"\n" +
"2.Time To > Date From", "OK");
return;
}
App.Database.SaveItemAsync(Todo);
if (Todo.IsDone == true)
{
DependencyService.Get <IAlarm>().CancelAlarm(Todo);
}
else
{
DependencyService.Get <IAlarm>().SetAlarm(Todo);
}
mContentPage.Navigation.PopAsync();
}
public DataSet Select()
{
Command = CommandBuilder(@"select pi.id, pi.title, pi.datetime, pi.image,
p.name as product from ProductImage as pi
left join Product as p on pi.productId=p.id where pi.id>0");
if (!string.IsNullOrEmpty(Title))
{
Command.CommandText += " and pi.title like @title";
Command.Parameters.AddWithValue("@title", "%" + Title + "%");
}
if (ProductId > 0)
{
Command.CommandText += " and p.id like @product";
Command.Parameters.AddWithValue("@product", ProductId);
}
if (DateSearch)
{
Command.CommandText += " and pi.datetime between @date1 and @Date2";
Command.Parameters.AddWithValue("@date1", DateFrom.ToShortDateString());
Command.Parameters.AddWithValue("@date2", DateTo.ToShortDateString());
}
return(ExecuteDS(Command));
}
public override string ToString(bool shortVariant, Pullenti.Morph.MorphLang lang = null, int lev = 0)
{
if (IsRelative && !shortVariant)
{
StringBuilder res = new StringBuilder();
res.Append(this.ToString(true, lang, lev));
Pullenti.Ner.Date.Internal.DateRelHelper.AppendToString2(this, res);
return(res.ToString());
}
string fr = (DateFrom == null ? null : DateFrom._ToString(shortVariant, lang, lev, 1));
string to = (DateTo == null ? null : DateTo._ToString(shortVariant, lang, lev, 2));
if (fr != null && to != null)
{
return(string.Format("{0} {1}", fr, (DateTo.Century > 0 && DateTo.Year == 0 ? to : to.ToLower())));
}
if (fr != null)
{
return(fr.ToString());
}
if (to != null)
{
return(to);
}
return(string.Format("{0} ? по ?", (lang.IsUa ? 'з' : 'с')));
}
private string BuildSubtitle()
{
string dateFormat = "dd.MM.yyyy HH:mm";
StringBuilder text = new StringBuilder("Период: ");
text.Append(DateFrom.ToString(dateFormat) + " - ");
text.Append(DateTo.ToString(dateFormat));
text.Append(", подразделение: ");
text.Append(SelectedUnit.Name);
if (LicensePlate.Trim().Length > 0)
{
text.Append(", номер т/с: ");
text.Append(LicensePlate.Trim());
}
if (Cargo.Trim().Length > 0)
{
text.Append(", груз: ");
text.Append(Cargo.Trim());
}
return(text.ToString());
}
public IEnumerable <ValidationResult> Validate(string instanceName, bool isRequired = false)
{
var result = new List <ValidationResult>();
if (DateFrom.YearMax == DateTime.Now.Year)
{
result.AddRange(DateFrom.ValidatePastDate($"{instanceName}.{nameof(DateFrom)}", true));
}
else
{
result.AddRange(DateFrom.Validate($"{instanceName}.{nameof(DateFrom)}", true));
}
if (DateTo.YearMax == DateTime.Now.Year)
{
result.AddRange(DateTo.ValidatePastDate($"{instanceName}.{nameof(DateTo)}", DateToRequired));
}
else
{
result.AddRange(DateTo.Validate($"{instanceName}.{nameof(DateTo)}", DateToRequired));
}
if ((DateToRequired || !DateTo.IsEmpty()) && (DateTo.ToDate() < DateFrom.ToDate()))
{
result.Add(new ValidationResult(string.Empty, new[] { $"{instanceName}.{nameof(DateTo)}" }));
}
return(result);
}
public override bool CanBeEquals(Pullenti.Ner.Referent obj, Pullenti.Ner.Core.ReferentsEqualType typ)
{
DateRangeReferent dr = obj as DateRangeReferent;
if (dr == null)
{
return(false);
}
if (DateFrom != null)
{
if (!DateFrom.CanBeEquals(dr.DateFrom, typ))
{
return(false);
}
}
else if (dr.DateFrom != null)
{
return(false);
}
if (DateTo != null)
{
if (!DateTo.CanBeEquals(dr.DateTo, typ))
{
return(false);
}
}
else if (dr.DateTo != null)
{
return(false);
}
return(true);
}
//implemented methods
public override void InputFormFields()
{
if (Data.TestWindowName != null)
{
TestWindowName.Wait(5).SendKeys(Data.TestWindowName);
}
if (Data.Subject != null)
{
SubjectSelect.Wait(3).SelectByText(Data.Subject);
}
if (Data.GradeLow != null)
{
GradeFromSelect.Wait(5);
GradeFromSelect.Wait(5).SelectByText(Data.GradeLow);
}
if (Data.GradeHigh != null)
{
GradeToSelect.Wait(5);
GradeToSelect.Wait(5).SelectByText(Data.GradeHigh);
}
if (Data.DateFrom != null)
{
DateFrom.Wait(5).SendKeys(Data.DateFrom);
}
if (Data.DateTo != null)
{
DateTo.Wait(5).SendKeys(Data.DateTo);
}
}
public DataSet Select()
{
Command = CommandBuilder(@"select L.id, L.name, L.contact, L.contactPerson, L.email, L.password, h.name as head,
L.description, L.address, ct.name as city, cn.name as country, l2.name as employee, L.createDate
from Ledger as L
left join Head as h on L.headId = h.id
left join ledger as l2 on l.employeeId = l2.id
left join City as ct on L.cityid = ct.id
left join country as cn on ct.countryId = cn.id where l.id>0");
if (!string.IsNullOrEmpty(Search))
{
Command.CommandText += " and (l.name like @search or l.contact like @search or l.contactPerson like @search or l.email like @search or l.description like @search or l.address like @search)";
Command.Parameters.AddWithValue("@search", "%" + Search + "%");
}
if (HeadId > 0)
{
Command.CommandText += " and (h.id like @head)";
Command.Parameters.AddWithValue("@head", "%" + HeadId + "%");
}
if (DateSearch)
{
Command.CommandText += " and l.createDate between @date1 and @Date2";
Command.Parameters.AddWithValue("@date1", DateFrom.ToShortDateString());
Command.Parameters.AddWithValue("@date2", DateTo.ToShortDateString());
}
return(ExecuteDS(Command));
}
public BaseChartWeekRequestModels()
{
//DateFrom = CommonHelper.GetFirstDayOfWeek();
//DateTo = DateFrom.AddDays(6);
DateTo = DateTime.Now.AddDays(-1);
DateFrom = DateTo.AddDays(-6);
}
private void pageHeader_Format(object sender, EventArgs e)
{
lblWarehouse.Text = Warehouse.ToString();
lblShed.Text = Shed.ToString();
lblLIC.Text = LIC.ToString();
lblFromDate.Text = DateFrom.ToString();
lblToDate.Text = DateTo.ToString();
}
public XmlElement ToXmlElement(XmlHelper helper)
{
var xmlElement = helper.CreateElement(nameof(MonthYearPeriodModel).Replace("Model", string.Empty));
xmlElement.AppendChild(helper.CreateElement(nameof(DateFrom), DateFrom.ToXmlElement(helper)));
xmlElement.AppendChild(helper.CreateElement(nameof(DateTo), DateTo.ToXmlElement(helper)));
return(xmlElement);
}
private void SaveDateSession()
{
List <string> list = Session["ReportSession"] as List <string>;
list[0] = DateFrom.ToString("yyyy-MM-dd");
list[1] = DateTo.ToString("yyyy-MM-dd");
Session["ReportSession"] = list;
}
//implemented methods
public override void ClearForm()
{
TestWindowName.Clear();
SubjectSelect.Wait(3).SelectByText("All subjects");
GradeFromSelect.Wait(5).SelectByText("");
GradeToSelect.Wait(5).SelectByText("");
DateFrom.Clear();
DateTo.Clear();
}
public IDictionary <string, string> ToQueryStrings()
{
return(new Dictionary <string, string>()
{
{ "to", DateTo.ToString("yyyy-MM-dd") },
{ "from", DateFrom.ToString("yyyy-MM-dd") },
{ "page", Page?.ToString() },
{ "size", Size?.ToString() },
});
}
private string CreateDateString()
{
return(IsValid
? string.Join("", new List <string> {
"1", DateFrom.ToSortString(), ((int)DateType).ToString(), DateTo.ToSortString()
})
: string.Join("", new List <string> {
"2", DatePhrase
}));
}
public override string ToString()
{
return($"[Type={Type}, " +
$"DateFrom={DateFrom.ToString(CultureInfo.CurrentCulture)}, " +
$"DateTo={DateTo.ToString(CultureInfo.CurrentCulture)}, " +
$"Span={Span.ToString()}, " +
$"HasTime={HasTime}, " +
$"StartIndex={StartIndex}, " +
$"EndIndex={EndIndex}]");
}
public override string ToString()
{
StringBuilder sb = new StringBuilder();
sb.AppendLine($"{EmpID}");
sb.AppendLine($"{ProjectID}");
sb.AppendLine($"{DateFrom.ToString("yyyy-MM-dd")}");
sb.AppendLine($"{DateTo.ToString("yyyy-MM-dd")}");
return(sb.ToString());
}
public override string ToString()
{
return(string.Format(
"{0} - {1} {2} {3} {4} {5}",
DateFrom.ToString("MMM d yyyy", CultureInfo.InvariantCulture),
DateTo.ToString("MMM d yyyy", CultureInfo.InvariantCulture),
RegistrationNo,
Name,
SourceID,
InternalID
));
} // ToString
public SummarizedData()
{
ExecuteCommand = new[]
{
AccessToken.Select(v => !string.IsNullOrWhiteSpace(v)),
DateFrom.Select(v => !string.IsNullOrWhiteSpace(v)),
DateTo.Select(v => !string.IsNullOrWhiteSpace(v)),
}
.CombineLatestValuesAreAllTrue()
.ToReactiveCommand(false)
.AddTo(Disposable);
}
public override int GetHashCode()
{
unchecked
{
var hashCode = (int)DateType;
hashCode = (hashCode * 397) ^ (DateFrom?.GetHashCode() ?? 0);
hashCode = (hashCode * 397) ^ (DateTo?.GetHashCode() ?? 0);
hashCode = (hashCode * 397) ^ (DatePhrase?.GetHashCode() ?? 0);
hashCode = (hashCode * 397) ^ IsValid.GetHashCode();
hashCode = (hashCode * 397) ^ SortDate;
return(hashCode);
}
}
private PDFCell GetPeriodPDFCell()
{
var dateFormat = new GetDateFormat().GetDateFormaDotNetById(DateFormatId);
var pdfCell = new PDFCell
{
NameDefault = "PeriodName",
NameDisplay = "Period: ",
Value = DateFrom.ToString(dateFormat) + " - " + DateTo.ToString(dateFormat),
};
return(pdfCell);
}
public override IDAOFilter GetFilter()
{
IDataAccess da = SysAuditDat.ClassDataAccessor;
IDAOFilter f = da.NewFilter();
f.AddWhere(new FilterDateFromTo(SysAuditColumns.Dt, DateFrom, DateTo.AddDays(1)));
if (!string.IsNullOrEmpty(Tbl))
{
Tbl = "%" + Tbl + "%";
f.AddWhere(new FilterString(SysAuditColumns.Tbl, Tbl, true));
}
if (ID != 0)
{
//f.AddWhere(new FilterID(SysAuditColumns.TblID, ID));
f.AddWhere(new FilterCustom(string.Format("OpContent.value('/*[1]/@id', 'int') = {0}", ID)));
}
if (!string.IsNullOrEmpty(User))
{
User = "******" + User + "%";
f.AddWhere(new FilterString(SysAuditColumns.Usr, User, true));
}
if (!string.IsNullOrEmpty(Host))
{
Host = "%" + Host + "%";
f.AddWhere(new FilterString(SysAuditColumns.ClientHost, Host, true));
}
if (!string.IsNullOrEmpty(Application))
{
Application = "%" + Application + "%";
f.AddWhere(new FilterString(SysAuditColumns.ClientApplication, Application, true));
}
if (!string.IsNullOrEmpty(Server))
{
Server = "%" + Server + "%";
f.AddWhere(new FilterString(SysAuditColumns.Srv, Server, true));
}
if (!string.IsNullOrEmpty(Base))
{
Base = "%" + Base + "%";
f.AddWhere(new FilterString(SysAuditColumns.Db, Base, true));
}
return(f);
}
public void NormalizeValues()
{
CourtOrganizationId = CourtOrganizationId.EmptyToNull();
DocumentDirectionId = DocumentDirectionId.EmptyToNull();
DocumentKindId = DocumentKindId.EmptyToNull();
DocumentGroupId = DocumentGroupId.EmptyToNull();
DocumentTypeId = DocumentTypeId.EmptyToNull();
DocumentNumber = DocumentNumber.EmptyToNull();
DocumentYear = DocumentYear.EmptyToNull();
DateTo = DateTo.MakeEndDate();
PersonName = PersonName.EmptyToNull();
PersonUIC = PersonUIC.EmptyToNull();
PersonRoleId = PersonRoleId.EmptyToNull();
}
private void BeginSearch()
{
try
{
string txtFrom = dateFrom.SelectedDate.ToString("yyyy-MM-dd");
string txtTo = DateTo.SelectedDate.AddDays(1).ToString("yyyy-MM-dd");
if (dateFrom.SelectedDate.Year == 9999)
{
//errlable.Text = "开始时间日期格式错误";
dateFrom.Focus();
return;
}
if (dateFrom.SelectedDate.Year == 9999)
{
//errlable.Text = "截止时间日期格式错误";
DateTo.Focus();
return;
}
if (dateFrom.SelectedDate > DateTime.Today)
{
dateFrom.SelectedDate = DateTime.Today;
return;
}
if (DateTo.SelectedDate > DateTime.Today)
{
DateTo.SelectedDate = DateTime.Today;
DateTo.Focus();
return;
}
if (dateFrom.SelectedDate > DateTo.SelectedDate)
{
errlable.Text = "开始时间不能大于截止时间";
dateFrom.Focus();
return;
}
FullQuery(txtFrom, txtTo);
CaculatePageCount();
GridView1.PagerSettings.LastPageText = ViewState["pageCount"].ToString();
BindGrid();
}
catch
{
errlable.Text = "";
}
}
public async Task <decimal> CalculateFinalPriceAsync()
{
if (_carType == null || _settings == null)
{
using (var db = new CarRentalDatabase())
{
_carType = _carType ?? await db.CarTypes.FirstOrDefaultAsync(x => x.Id == CarTypeId);
_settings = _settings ?? await db.Settings.FirstOrDefaultAsync();
}
}
var days = (int)Math.Ceiling(DateTo.Subtract(DateFrom).TotalDays) + 1;
var mileage = FinalMileage - InitialMileage;
return(_carType.DayMultiplier * days * _settings.DayPrice
+ _carType.KilometerMultiplier * mileage * _settings.KilometerPrice);
}
public async Task <IActionResult> OnGetAsync()
{
var isAuthorize =
User.IsInRole(Constants.AdministratorRole) ||
User.IsInRole(Constants.ManagerRole);
if (!isAuthorize)
{
return(new ChallengeResult());
}
DateTo = DateTime.Today;
DateFrom = DateTo.AddYears(-1);
IncomeStatement = await GetIncomeStatementsListAsync();
return(Page());
}
