protected void btnDownload_Click(object sender, EventArgs e) { if (CommonStatistic.IsRun) { lError.Visible = true; lError.Text = Resource.Admin_Restrict_Action_In_demo; return; } var paging = new SqlPaging { TableName = "[Order].[Order]" }; paging.AddField(new Field { Name = "*" }); if (chkStatus.Checked) { paging.AddField(new Field { Name = "OrderStatusID", NotInQuery = true, Filter = new EqualFieldFilter { ParamName = "@OrderStatusID", Value = ddlStatus.SelectedValue } }); } if (chkDate.Checked) { var filter = new DateTimeRangeFieldFilter { ParamName = "@RDate" }; var dateFrom = txtDateFrom.Text.TryParseDateTime(); if (dateFrom != DateTime.MinValue) filter.From = dateFrom; var dateTo = txtDateTo.Text.TryParseDateTime(); if (dateTo != DateTime.MinValue) filter.To = dateTo.AddDays(1) ; paging.AddField(new Field { Name = "OrderDate", NotInQuery = true, Filter = filter }); } var ordersCount = paging.TotalRowsCount; if (ordersCount == 0) return; CommonStatistic.Init(); CommonStatistic.IsRun = true; CommonStatistic.CurrentProcess = Request.Url.PathAndQuery; CommonStatistic.CurrentProcessName = Resource.Admin_ExportOrdersExcel_DownloadOrders; CommonStatistic.TotalRow = ordersCount; linkCancel.Visible = true; OutDiv.Visible = true; btnDownload.Visible = false; pnSearch.Visible = false; try { // Directory if (!Directory.Exists(_strFilePath)) Directory.CreateDirectory(_strFilePath); var tr = new Thread(Save); CommonStatistic.ThreadImport = tr; tr.Start(paging); } catch (Exception ex) { //Debug.LogError(ex, sender, e); Debug.LogError(ex); lError.Text = ex.Message; lError.Visible = true; CommonStatistic.IsRun = false; } }
protected void btnFilter_Click(object sender, EventArgs e) { if (ddSelect.SelectedIndex != 0) { if (ddSelect.SelectedIndex == 2) { if (_selectionFilter != null) { _selectionFilter.IncludeValues = !_selectionFilter.IncludeValues; } else { _selectionFilter = null; } } _paging.Fields["ID"].Filter = _selectionFilter; } else { _paging.Fields["ID"].Filter = null; } //----Firstname filter if (!string.IsNullOrEmpty(txtSearchFirstName.Text)) { var nfilter = new CompareFieldFilter { Expression = txtSearchFirstName.Text, ParamName = "@firstname" }; _paging.Fields["Firstname"].Filter = nfilter; } else { _paging.Fields["Firstname"].Filter = null; } //----lastname filter if (!string.IsNullOrEmpty(txtSearchLastname.Text)) { var nfilter = new CompareFieldFilter { Expression = txtSearchLastname.Text, ParamName = "@lastname" }; _paging.Fields["Lastname"].Filter = nfilter; } else { _paging.Fields["Lastname"].Filter = null; } //----email filter if (!string.IsNullOrEmpty(txtSearchEmail.Text)) { var nfilter = new CompareFieldFilter { Expression = txtSearchEmail.Text, ParamName = "@email" }; _paging.Fields["Email"].Filter = nfilter; } else { _paging.Fields["Email"].Filter = null; } //----RegDate filter if (!string.IsNullOrEmpty(txtDateFrom.Text) || !string.IsNullOrEmpty(txtDateTo.Text)) { var nfilter = new DateTimeRangeFieldFilter(); try { nfilter.From = DateTime.Parse(txtDateFrom.Text); } catch (Exception) { nfilter.From = DateTime.Parse("01.01.1900"); } try { nfilter.To = DateTime.Parse(txtDateTo.Text); } catch (Exception) { nfilter.To = DateTime.MaxValue; } nfilter.ParamName = "@RegistrationDateTime"; _paging.Fields["RegistrationDateTime"].Filter = nfilter; } else { _paging.Fields["RegistrationDateTime"].Filter = null; } _paging.Fields["CustomerGroupId"].Filter = ddlCustomerGroup.SelectedValue != "0" ? new EqualFieldFilter { ParamName = "@CustomerGroupId", Value = ddlCustomerGroup.SelectedValue } : null; _paging.Fields["PriceType"].Filter = ddlPriceTypes.SelectedValue != "0" ? new EqualFieldFilter { ParamName = "@PriceType", Value = ddlPriceTypes.SelectedValue } : null; pageNumberer.CurrentPageIndex = 1; _paging.CurrentPageIndex = 1; }
protected void btnFilter_Click(object sender, EventArgs e) { //-----Selection filter if (ddSelect.SelectedIndex != 0) { if (ddSelect.SelectedIndex == 2) { if (_selectionFilter != null) { _selectionFilter.IncludeValues = !_selectionFilter.IncludeValues; } else { _selectionFilter = null; } } _paging.Fields["ID"].Filter = _selectionFilter; } else { _paging.Fields["ID"].Filter = _selectionFilter; } //----FirstName filter if (!string.IsNullOrEmpty(txtFirstName.Text)) { var nfilter = new CompareFieldFilter { Expression = txtFirstName.Text, ParamName = "@FirstName" }; _paging.Fields["FirstName"].Filter = nfilter; } else { _paging.Fields["FirstName"].Filter = null; } //----Login filter //if (!string.IsNullOrEmpty(txtLogin.Text)) //{ // var nfilter = new CompareFieldFilter { Expression = txtLogin.Text, ParamName = "@Login" }; // _paging.Fields["Login"].Filter = nfilter; //} //else //{ // _paging.Fields["Login"].Filter = null; //} //---LastName if (!string.IsNullOrEmpty(txtLastName.Text)) { var nfilter = new CompareFieldFilter { Expression = txtLastName.Text, ParamName = "@LastName" }; _paging.Fields["LastName"].Filter = nfilter; } else { _paging.Fields["LastName"].Filter = null; } //---Email Filter if (!string.IsNullOrEmpty(txtEmail.Text)) { var nfilter = new CompareFieldFilter { Expression = txtEmail.Text, ParamName = "@Email" }; _paging.Fields["Email"].Filter = nfilter; } else { _paging.Fields["Email"].Filter = null; } //----Subscribed4News if (subscribed4News.SelectedIndex != 0) { var beforeFilter = new EqualFieldFilter { ParamName = "@Subscribed4News" }; if (subscribed4News.SelectedIndex == 1) { beforeFilter.Value = "1"; } if (subscribed4News.SelectedIndex == 2) { beforeFilter.Value = "0"; } _paging.Fields["Subscribed4News"].Filter = beforeFilter; } else { _paging.Fields["Subscribed4News"].Filter = null; } var dfilter = new DateTimeRangeFieldFilter { ParamName = "@RegistrationDateTime" }; if (!string.IsNullOrEmpty(txtDateFrom.Text)) { DateTime? d = null; try { d = DateTime.Parse(txtDateFrom.Text); } catch (Exception) { } if (d.HasValue) { var dt = new DateTime(d.Value.Year, d.Value.Month, d.Value.Day, 0, 0, 0, 0); dfilter.From = dt; } } if (!string.IsNullOrEmpty(txtDateTo.Text)) { DateTime? d = null; try { d = DateTime.Parse(txtDateTo.Text); } catch (Exception) { } if (d.HasValue) { var dt = new DateTime(d.Value.Year, d.Value.Month, d.Value.Day, 23, 59, 59, 99); dfilter.To = dt; } } if (dfilter.From.HasValue || dfilter.To.HasValue) { _paging.Fields["RegistrationDateTime"].Filter = dfilter; } else { _paging.Fields["RegistrationDateTime"].Filter = null; } pageNumberer.CurrentPageIndex = 1; }
protected void btnFilter_Click(object sender, EventArgs e) { //-----Selection filter if (ddSelect.SelectedIndex != 0) { if (ddSelect.SelectedIndex == 2) { if (_selectionFilter != null) { _selectionFilter.IncludeValues = !_selectionFilter.IncludeValues; } else { _selectionFilter = null; } } _paging.Fields["ID"].Filter = _selectionFilter; } else { _paging.Fields["ID"].Filter = null; } //----Email filter _paging.Fields["Email"].Filter = !string.IsNullOrEmpty(txtEmail.Text) ? new CompareFieldFilter { ParamName = "@Email", Expression = txtEmail.Text } : null; //-- productName _paging.Fields["Name"].Filter = !string.IsNullOrEmpty(txtName.Text) ? new CompareFieldFilter { ParamName = "@Name", Expression = txtName.Text } : null; //----Text filter _paging.Fields["[Text]"].Filter = !string.IsNullOrEmpty(txtText.Text) ? new CompareFieldFilter { ParamName = "@Text", Expression = txtText.Text } : null; //----Checked filter _paging.Fields["Checked"].Filter = ddlChecked.SelectedValue != "-1" ? new EqualFieldFilter { ParamName = "@Checked", Value = ddlChecked.SelectedValue } : null; //---AddDate filter var dfilter = new DateTimeRangeFieldFilter { ParamName = "@dateRewiews" }; if (!string.IsNullOrEmpty(txtDateFrom.Text)) { DateTime? d = default(DateTime?); try { d = DateTime.Parse(txtDateFrom.Text); } catch (Exception ex) { //Debug.LogError(ex, sender, e); Debug.LogError(ex); } if (d.HasValue) { var dt = new DateTime(d.Value.Year, d.Value.Month, d.Value.Day, 0, 0, 0, 0); dfilter.From = dt; } } if (!string.IsNullOrEmpty(txtDateTo.Text)) { DateTime? d = default(DateTime?); try { d = DateTime.Parse(txtDateTo.Text); } catch (Exception ex) { //Debug.LogError(ex, sender, e); Debug.LogError(ex); } if (d.HasValue) { var dt = new DateTime(d.Value.Year, d.Value.Month, d.Value.Day, 23, 59, 59, 99); dfilter.To = dt; } } if (dfilter.From.HasValue | dfilter.To.HasValue) { _paging.Fields["AddDate"].Filter = dfilter; } else { _paging.Fields["AddDate"].Filter = null; } }
protected void btnFilter_Click(object sender, EventArgs e) { //-----Selection filter if (ddSelect.SelectedIndex != 0) { if (ddSelect.SelectedIndex == 2) { if (_selectionFilter != null) { _selectionFilter.IncludeValues = !_selectionFilter.IncludeValues; } else { _selectionFilter = null; } } _paging.Fields["ID"].Filter = _selectionFilter; } else { _paging.Fields["ID"].Filter = _selectionFilter; } //----ActivateDate filter if (!string.IsNullOrEmpty(txtMessageText.Text)) { var nfilter = new CompareFieldFilter { Expression = txtMessageText.Text, ParamName = "@MessageText" }; _paging.Fields["MessageText"].Filter = nfilter; } else { _paging.Fields["MessageText"].Filter = null; } //---OrderDate filter var dfilter = new DateTimeRangeFieldFilter { ParamName = "@AddDate" }; if (!string.IsNullOrEmpty(txtDateFrom.Text)) { DateTime? d = null; try { d = DateTime.Parse(txtDateFrom.Text); } catch (Exception) { } if (d.HasValue) { var dt = new DateTime(d.Value.Year, d.Value.Month, d.Value.Day, 0, 0, 0, 0); dfilter.From = dt; } } if (!string.IsNullOrEmpty(txtDateTo.Text)) { DateTime? d = null; try { d = DateTime.Parse(txtDateTo.Text); } catch (Exception) { } if (d.HasValue) { var dt = new DateTime(d.Value.Year, d.Value.Month, d.Value.Day, 23, 59, 59, 99); dfilter.To = dt; } } if (dfilter.From.HasValue || dfilter.To.HasValue) { _paging.Fields["AddDate"].Filter = dfilter; } else { _paging.Fields["AddDate"].Filter = null; } pageNumberer.CurrentPageIndex = 1; }