private void ShowButton_Click(object sender, EventArgs e) { try { if (FromDatefaDatePicker.IsNull) { throw new ApplicationException("از تاریخ خالی است"); } else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox))) { throw new ApplicationException("از ساعت خالی است"); } else if (ToDatefaDatePicker.IsNull) { throw new ApplicationException("تا تاریخ خالی است"); } else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox))) { throw new ApplicationException("تا ساعت خالی است"); } Hepsa.Core.Validation.DateRule <string> FromDateValidator = new Hepsa.Core.Validation.DateRule <string>("FromDate", "از تاریخ", null, null); if (FromDateValidator.Validate(FromDatefaDatePicker.Text) == false) { throw new ApplicationException(FromDateValidator.Description); } Hepsa.Core.Validation.DateRule <string> ToDateValidator = new Hepsa.Core.Validation.DateRule <string>("ToDate", "تا تاریخ", null, null); if (ToDateValidator.Validate(ToDatefaDatePicker.Text) == false) { throw new ApplicationException(ToDateValidator.Description); } Hepsa.Core.Validation.TimeRule <string> FromTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("FromTime", "از ساعت", null, null); if (FromTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox)) == false) { throw new ApplicationException(FromTimeValidator.Description); } Hepsa.Core.Validation.TimeRule <string> ToTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("ToTime", "تا ساعت", null, null); if (ToTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox)) == false) { throw new ApplicationException(ToTimeValidator.Description); } DataTable CanceledTurnsTable = new DataTable(); HPS.BLL.TrafficBLL.BLLTraffic_TFactory TrafficFactory = new BLL.TrafficBLL.BLLTraffic_TFactory(); TrafficFactory.SelectCanceledTurns(FromDatefaDatePicker.Text, ToDatefaDatePicker.Text, FromTimeTextBox.Text, ToTimeTextBox.Text, CanceledTurnsTable); CanceledTurnsGridView.DataSource = CanceledTurnsTable; //AllCanceledTurnstiReport.Show(); } catch (Exception ex) { Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message); } }
private void ShowButton_Click(object sender, EventArgs e) { try { if (FromDatefaDatePicker.IsNull) { throw new ApplicationException("از تاریخ خالی است"); } else if (ToDatefaDatePicker.IsNull) { throw new ApplicationException("تا تاریخ خالی است"); } else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox))) { throw new ApplicationException("از ساعت خالی است"); } else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox))) { throw new ApplicationException("تا ساعت خالی است"); } Hepsa.Core.Validation.DateRule <string> FromDateValidator = new Hepsa.Core.Validation.DateRule <string>("FromDate", "از تاریخ", null, null); if (FromDateValidator.Validate(FromDatefaDatePicker.Text) == false) { throw new ApplicationException(FromDateValidator.Description); } Hepsa.Core.Validation.DateRule <string> ToDateValidator = new Hepsa.Core.Validation.DateRule <string>("ToDate", "تا تاریخ", null, null); if (ToDateValidator.Validate(ToDatefaDatePicker.Text) == false) { throw new ApplicationException(ToDateValidator.Description); } Hepsa.Core.Validation.TimeRule <string> FromTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("FromTime", "از ساعت", null, null); if (FromTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox)) == false) { throw new ApplicationException(FromTimeValidator.Description); } Hepsa.Core.Validation.TimeRule <string> ToTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("ToTime", "تا ساعت", null, null); if (ToTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox)) == false) { throw new ApplicationException(ToTimeValidator.Description); } //HPS.Reports.ReportDoc.ServicesCountPriceReprt rpt = new HPS.Reports.ReportDoc.ServicesCountPriceReprt(FromDatefaDatePicker.Text, FromTimeTextBox.Text, ToDatefaDatePicker.Text, ToTimeTextBox.Text); //rpt.Document.Printer.PrinterName = string.Empty; //viewer1.Document = rpt.Document; //rpt.Run(); } catch (Exception ex) { Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message); } }
private void ShowButton_Click(object sender, EventArgs e) { try { if (FromDatefaDatePicker.IsNull) { throw new ApplicationException("از تاریخ خالی است"); } else if (ToDatefaDatePicker.IsNull) { throw new ApplicationException("تا تاریخ خالی است"); } else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox))) { throw new ApplicationException("از ساعت خالی است"); } else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox))) { throw new ApplicationException("تا ساعت خالی است"); } Hepsa.Core.Validation.DateRule <string> FromDateValidator = new Hepsa.Core.Validation.DateRule <string>("FromDate", "از تاریخ", null, null); if (FromDateValidator.Validate(FromDatefaDatePicker.Text) == false) { throw new ApplicationException(FromDateValidator.Description); } Hepsa.Core.Validation.DateRule <string> ToDateValidator = new Hepsa.Core.Validation.DateRule <string>("ToDate", "تا تاریخ", null, null); if (ToDateValidator.Validate(ToDatefaDatePicker.Text) == false) { throw new ApplicationException(ToDateValidator.Description); } Hepsa.Core.Validation.TimeRule <string> FromTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("FromTime", "از ساعت", null, null); if (FromTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox)) == false) { throw new ApplicationException(FromTimeValidator.Description); } Hepsa.Core.Validation.TimeRule <string> ToTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("ToTime", "تا ساعت", null, null); if (ToTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox)) == false) { throw new ApplicationException(ToTimeValidator.Description); } HPS.BLL.TrafficBLL.BLLTraffic_TFactory plateNumberFatory = new BLL.TrafficBLL.BLLTraffic_TFactory(); DataTable trafficPicturesTable = new DataTable(); plateNumberFatory.SelectTypeandLasteIn(FromDatefaDatePicker.Text, ToDatefaDatePicker.Text, FromTimeTextBox.Text, ToTimeTextBox.Text, trafficPicturesTable); TypeandLastInGrid.DataSource = trafficPicturesTable; } catch (Exception ex) { Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message); } }
private void ShowButton_Click(object sender, EventArgs e) { try { if (FromDatefaDatePicker.IsNull) { throw new ApplicationException("از تاریخ خالی است"); } else if (ToDatefaDatePicker.IsNull) { throw new ApplicationException("تا تاریخ خالی است"); } else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox))) { throw new ApplicationException("از ساعت خالی است"); } else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox))) { throw new ApplicationException("تا ساعت خالی است"); } Hepsa.Core.Validation.TimeRule <string> FromTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("FromTime", "از ساعت", null, null); if (FromTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox)) == false) { throw new ApplicationException(FromTimeValidator.Description); } Hepsa.Core.Validation.TimeRule <string> ToTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("ToTime", "تا ساعت", null, null); if (ToTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox)) == false) { throw new ApplicationException(ToTimeValidator.Description); } LoadOnlineCardChecking(); } catch (Exception ex) { Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message); } }
private void ShowButton_Click(object sender, EventArgs e) { try { if (FromDatefaDatePicker.IsNull) { throw new ApplicationException("از تاریخ خالی است"); } else if (ToDatefaDatePicker.IsNull) { throw new ApplicationException("تا تاریخ خالی است"); } else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox))) { throw new ApplicationException("از ساعت خالی است"); } else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox))) { throw new ApplicationException("تا ساعت خالی است"); } Hepsa.Core.Validation.DateRule <string> FromDateValidator = new Hepsa.Core.Validation.DateRule <string>("FromDate", "از تاریخ", null, null); if (FromDateValidator.Validate(FromDatefaDatePicker.Text) == false) { throw new ApplicationException(FromDateValidator.Description); } Hepsa.Core.Validation.DateRule <string> ToDateValidator = new Hepsa.Core.Validation.DateRule <string>("ToDate", "تا تاریخ", null, null); if (ToDateValidator.Validate(ToDatefaDatePicker.Text) == false) { throw new ApplicationException(ToDateValidator.Description); } Hepsa.Core.Validation.TimeRule <string> FromTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("FromTime", "از ساعت", null, null); if (FromTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox)) == false) { throw new ApplicationException(FromTimeValidator.Description); } Hepsa.Core.Validation.TimeRule <string> ToTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("ToTime", "تا ساعت", null, null); if (ToTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox)) == false) { throw new ApplicationException(ToTimeValidator.Description); } //HPS.Reports.ReportDoc.AllLaderTypeTurnReport rpt = new HPS.Reports.ReportDoc.AllLaderTypeTurnReport(FromDatefaDatePicker.Text, FromTimeTextBox.Text, ToDatefaDatePicker.Text, ToTimeTextBox.Text); //rpt.Document.Printer.PrinterName = string.Empty; //viewer1.Document = rpt.Document; //rpt.Run(); HPS.BLL.TrafficBLL.BLLTraffic_TFactory TrafficFactory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory(); AllLaderTypeTurnstiReport.Dictionary.Synchronize(); AllLaderTypeTurnstiReport.Dictionary.Databases.Clear(); AllLaderTypeTurnstiReport.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("Connection", Hepsa.Core.Common.ConnectionString.ConnectionString)); AllLaderTypeTurnstiReport.Compile(); AllLaderTypeTurnstiReport["organ"] = new HPS.BLL.SettingsBLL.BLLSetting_TFactory().GetBy(new BLL.SettingsBLL.BLLSetting_TKeys() { SettingID_int = 1029 }).Value_nvc.ToString(); HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory PortPlaceFactory = new HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory(); AllLaderTypeTurnstiReport["@FromDate_nvc"] = FromDatefaDatePicker.Text; AllLaderTypeTurnstiReport["@FromTime_nvc"] = FromTimeTextBox.Text; AllLaderTypeTurnstiReport["@ToDate_nvc"] = ToDatefaDatePicker.Text; AllLaderTypeTurnstiReport["@ToTime_nvc"] = ToTimeTextBox.Text; AllLaderTypeTurnstiReport["fromdate_vc"] = FromDatefaDatePicker.Text; AllLaderTypeTurnstiReport["todate_vc"] = ToDatefaDatePicker.Text; AllLaderTypeTurnstiReport["date_vc"] = PortPlaceFactory.ServerJalaliDate + " " + PortPlaceFactory.ServerTime;; AllLaderTypeTurnstiReport["UserName_vc"] = HPS.Common.CurrentUser.user.UserName_nvc; AllLaderTypeTurnstiReport["FromTime_vc"] = FromTimeTextBox.Text; AllLaderTypeTurnstiReport["ToTime_vc"] = ToTimeTextBox.Text; AllLaderTypeTurnstiReport.Render(); this.stiViewerControl1.Report = AllLaderTypeTurnstiReport; } catch (Exception ex) { Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message); } }
private void ChartShowButton_Click(object sender, EventArgs e) { try { ExistsLaderTypeGridView.Visible = false; if (FromDatefaDatePicker.IsNull) { throw new ApplicationException("از تاریخ خالی است"); } else if (ToDatefaDatePicker.IsNull) { throw new ApplicationException("تا تاریخ خالی است"); } else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox))) { throw new ApplicationException("از ساعت خالی است"); } else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox))) { throw new ApplicationException("تا ساعت خالی است"); } Hepsa.Core.Validation.DateRule <string> FromDateValidator = new Hepsa.Core.Validation.DateRule <string>("FromDate", "از تاریخ", null, null); if (FromDateValidator.Validate(FromDatefaDatePicker.Text) == false) { throw new ApplicationException(FromDateValidator.Description); } Hepsa.Core.Validation.DateRule <string> ToDateValidator = new Hepsa.Core.Validation.DateRule <string>("ToDate", "تا تاریخ", null, null); if (ToDateValidator.Validate(ToDatefaDatePicker.Text) == false) { throw new ApplicationException(ToDateValidator.Description); } Hepsa.Core.Validation.TimeRule <string> FromTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("FromTime", "از ساعت", null, null); if (FromTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox)) == false) { throw new ApplicationException(FromTimeValidator.Description); } Hepsa.Core.Validation.TimeRule <string> ToTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("ToTime", "تا ساعت", null, null); if (ToTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox)) == false) { throw new ApplicationException(ToTimeValidator.Description); } object[] LaderTypeList = new object[100]; string LaderTypeList_nvc = string.Empty; int index = 0; LaderTypeList = LaderTypecheckedComboBox.CheckedValues; if (LaderTypeList != null) { foreach (object obj in LaderTypeList) { LaderTypeList_nvc = string.Format("{0},{1}", LaderTypeList_nvc, LaderTypeList[index].ToString()); index += 1; } LaderTypeList_nvc = LaderTypeList_nvc.Substring(1, LaderTypeList_nvc.Length - 1); } if (string.IsNullOrEmpty(LaderTypeList_nvc)) { throw new ApplicationException("نوع بارگیر انتخاب نشده است"); } if (LaderTypecheckedComboBox.CheckedValues.Length > 1) { throw new ApplicationException("یک بارگیر را انتخاب کنید"); } //HPS.Reports.ReportDoc.LaderTypeCountChart rpt = new HPS.Reports.ReportDoc.LaderTypeCountChart(FromDatefaDatePicker.Text, FromTimeTextBox.Text, ToDatefaDatePicker.Text, ToTimeTextBox.Text, LaderTypeList_nvc); //rpt.Document.Printer.PrinterName = string.Empty; //viewer1.Document = rpt.Document; //rpt.Run(); LaderTypeCountChartstiReport.Dictionary.Synchronize(); LaderTypeCountChartstiReport.Dictionary.Databases.Clear(); LaderTypeCountChartstiReport.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("Connection", Hepsa.Core.Common.ConnectionString.ConnectionString)); LaderTypeCountChartstiReport.Compile(); LaderTypeCountChartstiReport["organ"] = new HPS.BLL.SettingsBLL.BLLSetting_TFactory().GetBy(new BLL.SettingsBLL.BLLSetting_TKeys() { SettingID_int = 1029 }).Value_nvc.ToString(); HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory PortPlaceFactory = new HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory(); LaderTypeCountChartstiReport["fromDate_nvc"] = FromDatefaDatePicker.Text; LaderTypeCountChartstiReport["toDate_nvc"] = ToDatefaDatePicker.Text; LaderTypeCountChartstiReport["fromTime_nvc"] = FromTimeTextBox.Text; LaderTypeCountChartstiReport["toTime_nvc"] = ToTimeTextBox.Text; LaderTypeCountChartstiReport["date_vc"] = PortPlaceFactory.ServerJalaliDate + " " + PortPlaceFactory.ServerTime;; LaderTypeCountChartstiReport["userName_nvc"] = HPS.Common.CurrentUser.user.UserName_nvc; LaderTypeCountChartstiReport["@fromdate_nvc"] = FromDatefaDatePicker.Text; LaderTypeCountChartstiReport["@todate_nvc"] = ToDatefaDatePicker.Text; LaderTypeCountChartstiReport["@fromtime_nvc"] = FromTimeTextBox.Text; LaderTypeCountChartstiReport["@totime_nvc"] = ToTimeTextBox.Text; LaderTypeCountChartstiReport["@LaderTypeList"] = LaderTypeList_nvc; LaderTypeCountChartstiReport.Render(); //this.stiViewerControl1.Report = LaderTypeCountChartstiReport; LaderTypeCountChartstiReport.Show(); } catch (Exception ex) { Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message); } }
private void ShowButton_Click(object sender, EventArgs e) { try { ExistsLaderTypeGridView.Visible = false; if (FromDatefaDatePicker.IsNull) { throw new ApplicationException("از تاریخ خالی است"); } else if (ToDatefaDatePicker.IsNull) { throw new ApplicationException("تا تاریخ خالی است"); } else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox))) { throw new ApplicationException("از ساعت خالی است"); } else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox))) { throw new ApplicationException("تا ساعت خالی است"); } Hepsa.Core.Validation.DateRule <string> FromDateValidator = new Hepsa.Core.Validation.DateRule <string>("FromDate", "از تاریخ", null, null); if (FromDateValidator.Validate(FromDatefaDatePicker.Text) == false) { throw new ApplicationException(FromDateValidator.Description); } Hepsa.Core.Validation.DateRule <string> ToDateValidator = new Hepsa.Core.Validation.DateRule <string>("ToDate", "تا تاریخ", null, null); if (ToDateValidator.Validate(ToDatefaDatePicker.Text) == false) { throw new ApplicationException(ToDateValidator.Description); } Hepsa.Core.Validation.TimeRule <string> FromTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("FromTime", "از ساعت", null, null); if (FromTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox)) == false) { throw new ApplicationException(FromTimeValidator.Description); } Hepsa.Core.Validation.TimeRule <string> ToTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("ToTime", "تا ساعت", null, null); if (ToTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox)) == false) { throw new ApplicationException(ToTimeValidator.Description); } object[] LaderTypeList = new object[100]; string LaderTypeList_nvc = string.Empty; int index = 0; LaderTypeList = LaderTypecheckedComboBox.CheckedValues; if (LaderTypeList != null) { foreach (object obj in LaderTypeList) { LaderTypeList_nvc = string.Format("{0},{1}", LaderTypeList_nvc, LaderTypeList[index].ToString()); index += 1; } LaderTypeList_nvc = LaderTypeList_nvc.Substring(1, LaderTypeList_nvc.Length - 1); } //HPS.Reports.ReportDoc.LaderTypeCountReport rpt = new HPS.Reports.ReportDoc.LaderTypeCountReport(FromDatefaDatePicker.Text, FromTimeTextBox.Text, ToDatefaDatePicker.Text, ToTimeTextBox.Text, LaderTypeList_nvc); //rpt.Document.Printer.PrinterName = string.Empty; //viewer1.Document = rpt.Document; //rpt.Run(); //پر کردن دیتا تیبل //HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory LadeAssignmentFactory = new HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory(); //DataTable LaderTypeReportTable = new DataTable(); //DataSet LaderTypeDataSet = new DataSet(); //LadeAssignmentFactory.SelectLaderTypeCountReport(FromDatefaDatePicker.Text, FromTimeTextBox.Text, ToDatefaDatePicker.Text, ToTimeTextBox .Text, LaderTypeList_nvc, ref LaderTypeReportTable); ////اضافه کردن ستون جدید به جدول //if (LaderTypeReportTable != null && LaderTypeReportTable.Rows.Count > 0) //{ // LaderTypeReportTable.Columns.Add("RemainedPercent"); // foreach (DataRow row in LaderTypeReportTable.Rows) // { // double RemainedPercent = (Convert.ToDouble(row["RemainderCar_int"]) * 100) / Convert.ToDouble(row["CarCount_int"]); // row["RemainedPercent"] = RemainedPercent.ToString("0.##"); // } //} //Int64? AllLadeAssignmentcount = (from row in LaderTypeReportTable.AsEnumerable() select (Int32)row["CarCount_int"]).Sum(); //Int64? AllLadBillcountRecords = (from row in LaderTypeReportTable.AsEnumerable() select (Int32)row["LadBill"]).Sum(); //Int64? allcanceledByCompany = (from row in LaderTypeReportTable.AsEnumerable() select (Int32)row["CanceledByCompany"]).Sum(); //Int64? allcanceledByLadBillCanceled = (from row in LaderTypeReportTable.AsEnumerable() select (Int32)row["CanceledByLadBillCanceled"]).Sum(); ////AllRemainderCounttxt.Text = (Convert.ToInt64(AllLadeAssignmentcount) - Convert.ToInt64(AllLadBillcountRecords) - Convert.ToInt64(allcanceledByCompany) - Convert.ToInt64(allcanceledByLadBillCanceled)).ToString(); //Allremaindercount.HasValue ? Allremaindercount.ToString() : "0"; //AllRemainedPercenttxt.Text = ((Convert.ToDouble(AllRemainderCounttxt.Text)) * 100 / (Convert.ToDouble(AllLadeAssignmentCountxt.Text))).ToString("0.##"); //اضافه کردن دیتاتیبل به دیتا ست //LaderTypeDataSet.Tables.Add(LaderTypeReportTable.Copy()); //کدهای استیمیول LederTypeCountReportstiReport.Dictionary.Synchronize(); LederTypeCountReportstiReport.Dictionary.Databases.Clear(); LederTypeCountReportstiReport.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("Connection", Hepsa.Core.Common.ConnectionString.ConnectionString)); LederTypeCountReportstiReport.Compile(); LederTypeCountReportstiReport["organ"] = new HPS.BLL.SettingsBLL.BLLSetting_TFactory().GetBy(new BLL.SettingsBLL.BLLSetting_TKeys() { SettingID_int = 1029 }).Value_nvc.ToString(); HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory PortPlaceFactory = new HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory(); //مقدار دهی متغیرها LederTypeCountReportstiReport["fromDate_nvc"] = FromDatefaDatePicker.Text; LederTypeCountReportstiReport["fromTime_nvc"] = FromTimeTextBox.Text; LederTypeCountReportstiReport["toTime_nvc"] = ToTimeTextBox.Text; LederTypeCountReportstiReport["toDate_nvc"] = ToDatefaDatePicker.Text; LederTypeCountReportstiReport["date_vc"] = PortPlaceFactory.ServerJalaliDate + " " + PortPlaceFactory.ServerTime;; LederTypeCountReportstiReport["userName_nvc"] = HPS.Common.CurrentUser.user.UserName_nvc; LederTypeCountReportstiReport["@fromdate_nvc"] = FromDatefaDatePicker.Text; LederTypeCountReportstiReport["@fromtime_nvc"] = FromTimeTextBox.Text; LederTypeCountReportstiReport["@totime_nvc"] = ToTimeTextBox.Text; LederTypeCountReportstiReport["@todate_nvc"] = ToDatefaDatePicker.Text; if (!(LaderTypeList_nvc == "")) { LederTypeCountReportstiReport["@LaderTypeList"] = LaderTypeList_nvc; } //LederTypeCountReportstiReport["@CompanyID_int"] = FromDatefaDatePicker.Text; //LederTypeCountReportstiReport["@GoodIDList_nvc"] = FromTimeTextBox.Text; //LederTypeCountReportstiReport["@DestinationCityIDList_nvc"] = ToTimeTextBox.Text; //LederTypeCountReportstiReport["@PortPlaceIDList_nvc"] = ToDatefaDatePicker.Text; //LederTypeCountReportstiReport["@OrderColumns_nvc"] = LaderTypeList_nvc; LederTypeCountReportstiReport.Render(); //LederTypeCountReportstiReport.Show(); stiViewerControl1.Report = LederTypeCountReportstiReport; } catch (Exception ex) { Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message); } }
private void ShowButton_Click(object sender, EventArgs e) { try { if (FromDatefaDatePicker.IsNull) { throw new ApplicationException("از تاریخ خالی است"); } else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox))) { throw new ApplicationException("از ساعت خالی است"); } else if (ToDatefaDatePicker.IsNull) { throw new ApplicationException("تا تاریخ خالی است"); } else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox))) { throw new ApplicationException("تا ساعت خالی است"); } Hepsa.Core.Validation.DateRule <string> FromDateValidator = new Hepsa.Core.Validation.DateRule <string>("FromDate", "از تاریخ", null, null); if (FromDateValidator.Validate(FromDatefaDatePicker.Text) == false) { throw new ApplicationException(FromDateValidator.Description); } Hepsa.Core.Validation.DateRule <string> ToDateValidator = new Hepsa.Core.Validation.DateRule <string>("ToDate", "تا تاریخ", null, null); if (ToDateValidator.Validate(ToDatefaDatePicker.Text) == false) { throw new ApplicationException(ToDateValidator.Description); } Hepsa.Core.Validation.TimeRule <string> FromTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("FromTime", "از ساعت", null, null); if (FromTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox)) == false) { throw new ApplicationException(FromTimeValidator.Description); } Hepsa.Core.Validation.TimeRule <string> ToTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("ToTime", "تا ساعت", null, null); if (ToTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox)) == false) { throw new ApplicationException(ToTimeValidator.Description); } string CompanyList_nvc = string.Empty; foreach (Janus.Windows.GridEX.GridEXRow itm in companyGrid.GetCheckedRows()) { CompanyList_nvc += itm.Cells["CompanyID_int"].Value.ToString() + ","; } if (CompanyList_nvc.EndsWith(",")) { CompanyList_nvc = CompanyList_nvc.Remove(CompanyList_nvc.Length - 1); } companyGrid.UnCheckAllRecords(); string LaderTypeList_nvc = string.Empty; foreach (Janus.Windows.GridEX.GridEXRow itm in laderTypeGrid.GetCheckedRows()) { LaderTypeList_nvc += itm.Cells["LaderTypeID_int"].Value.ToString() + ","; } if (LaderTypeList_nvc.EndsWith(",")) { LaderTypeList_nvc = LaderTypeList_nvc.Remove(LaderTypeList_nvc.Length - 1); } laderTypeGrid.UnCheckAllRecords(); string GoodList_nvc = string.Empty; foreach (Janus.Windows.GridEX.GridEXRow itm in goodGrid.GetCheckedRows()) { GoodList_nvc += itm.Cells["GoodID_int"].Value.ToString() + ","; } if (GoodList_nvc.EndsWith(",")) { GoodList_nvc = GoodList_nvc.Remove(GoodList_nvc.Length - 1); } goodGrid.UnCheckAllRecords(); string PortPlaceList_nvc = string.Empty; foreach (Janus.Windows.GridEX.GridEXRow itm in portPlaceGrid.GetCheckedRows()) { PortPlaceList_nvc += itm.Cells["PortPlacesID_int"].Value.ToString() + ","; } if (PortPlaceList_nvc.EndsWith(",")) { PortPlaceList_nvc = PortPlaceList_nvc.Remove(PortPlaceList_nvc.Length - 1); } portPlaceGrid.UnCheckAllRecords(); string DestinationCityList_nvc = string.Empty; foreach (Janus.Windows.GridEX.GridEXRow itm in destinationCityGrid.GetCheckedRows()) { DestinationCityList_nvc += itm.Cells["CityID_int"].Value.ToString() + ","; } if (DestinationCityList_nvc.EndsWith(",")) { DestinationCityList_nvc = DestinationCityList_nvc.Remove(DestinationCityList_nvc.Length - 1); } destinationCityGrid.UnCheckAllRecords(); //HPS.Reports.ReportDoc.CompanyLadeAssignmentDetailReport rpt = new HPS.Reports.ReportDoc.CompanyLadeAssignmentDetailReport(FromDatefaDatePicker.Text, FromTimeTextBox.Text, ToDatefaDatePicker.Text, ToTimeTextBox.Text, LaderTypeList_nvc, CompanyList_nvc, GoodList_nvc, DestinationCityList_nvc, PortPlaceList_nvc); //viewer1.Document = rpt.Document; //rpt.Document.Printer.PrinterName = string.Empty; //rpt.Run(); CompanyLadeAssignmentDetailReportstiReport.Dictionary.Synchronize(); CompanyLadeAssignmentDetailReportstiReport.Dictionary.Databases.Clear(); CompanyLadeAssignmentDetailReportstiReport.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("Connection", Hepsa.Core.Common.ConnectionString.ConnectionString)); CompanyLadeAssignmentDetailReportstiReport.Compile(); HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory PortPlaceFactory = new HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory(); CompanyLadeAssignmentDetailReportstiReport["organ"] = new HPS.BLL.SettingsBLL.BLLSetting_TFactory().GetBy(new BLL.SettingsBLL.BLLSetting_TKeys() { SettingID_int = 1029 }).Value_nvc.ToString(); CompanyLadeAssignmentDetailReportstiReport["FromDate_vc"] = FromDatefaDatePicker.Text; CompanyLadeAssignmentDetailReportstiReport["ToDate_vc"] = ToDatefaDatePicker.Text; CompanyLadeAssignmentDetailReportstiReport["FromTime_vc"] = FromTimeTextBox.Text; CompanyLadeAssignmentDetailReportstiReport["ToTime_vc"] = ToTimeTextBox.Text; CompanyLadeAssignmentDetailReportstiReport["Date_vc"] = PortPlaceFactory.ServerJalaliDate + " " + PortPlaceFactory.ServerTime;; CompanyLadeAssignmentDetailReportstiReport["UserName_vc"] = HPS.Common.CurrentUser.user.UserName_nvc; CompanyLadeAssignmentDetailReportstiReport["@fromdate_nvc"] = FromDatefaDatePicker.Text; CompanyLadeAssignmentDetailReportstiReport["@todate_nvc"] = ToDatefaDatePicker.Text; CompanyLadeAssignmentDetailReportstiReport["@fromtime_nvc"] = FromTimeTextBox.Text; CompanyLadeAssignmentDetailReportstiReport["@totime_nvc"] = ToTimeTextBox.Text; if (string.IsNullOrEmpty(LaderTypeList_nvc)) { CompanyLadeAssignmentDetailReportstiReport["@LaderTypeID_int"] = DBNull.Value; } else { CompanyLadeAssignmentDetailReportstiReport["@LaderTypeID_int"] = LaderTypeList_nvc; } if (string.IsNullOrEmpty(CompanyList_nvc)) { CompanyLadeAssignmentDetailReportstiReport["@CompanyID_int"] = DBNull.Value; } else { CompanyLadeAssignmentDetailReportstiReport["@CompanyID_int"] = CompanyList_nvc; } if (string.IsNullOrEmpty(GoodList_nvc)) { CompanyLadeAssignmentDetailReportstiReport["@GoodIDList_nvc"] = DBNull.Value; } else { CompanyLadeAssignmentDetailReportstiReport["@GoodIDList_nvc"] = GoodList_nvc; } if (string.IsNullOrEmpty(DestinationCityList_nvc)) { CompanyLadeAssignmentDetailReportstiReport["@DestinationCityIDList_nvc"] = DBNull.Value; } else { CompanyLadeAssignmentDetailReportstiReport["@DestinationCityIDList_nvc"] = DestinationCityList_nvc; } if (string.IsNullOrEmpty(PortPlaceList_nvc)) { CompanyLadeAssignmentDetailReportstiReport["@PortPlaceIDList_nvc"] = DBNull.Value; } else { CompanyLadeAssignmentDetailReportstiReport["@PortPlaceIDList_nvc"] = PortPlaceList_nvc; } CompanyLadeAssignmentDetailReportstiReport["@OrderColumns_nvc"] = DBNull.Value; CompanyLadeAssignmentDetailReportstiReport.Render(); this.stiViewerControl1.Report = CompanyLadeAssignmentDetailReportstiReport; } catch (Exception ex) { Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message); } }
private void ShowButton_Click(object sender, EventArgs e) { Hepsa.Core.BLL.BLLAction_TFactory ActionFactory = new Hepsa.Core.BLL.BLLAction_TFactory(); try { //ExistsLaderTypeGridView.Visible = false; if (FromDatefaDatePicker.IsNull) { throw new ApplicationException("از تاریخ خالی است"); } else if (ToDatefaDatePicker.IsNull) { throw new ApplicationException("تا تاریخ خالی است"); } else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox))) { throw new ApplicationException("از ساعت خالی است"); } else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox))) { throw new ApplicationException("تا ساعت خالی است"); } Hepsa.Core.Validation.DateRule <string> FromDateValidator = new Hepsa.Core.Validation.DateRule <string>("FromDate", "از تاریخ", null, null); if (FromDateValidator.Validate(FromDatefaDatePicker.Text) == false) { throw new ApplicationException(FromDateValidator.Description); } Hepsa.Core.Validation.DateRule <string> ToDateValidator = new Hepsa.Core.Validation.DateRule <string>("ToDate", "تا تاریخ", null, null); if (ToDateValidator.Validate(ToDatefaDatePicker.Text) == false) { throw new ApplicationException(ToDateValidator.Description); } Hepsa.Core.Validation.TimeRule <string> FromTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("FromTime", "از ساعت", null, null); if (FromTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox)) == false) { throw new ApplicationException(FromTimeValidator.Description); } Hepsa.Core.Validation.TimeRule <string> ToTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("ToTime", "تا ساعت", null, null); if (ToTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox)) == false) { throw new ApplicationException(ToTimeValidator.Description); } InCountstiReport.Dictionary.Synchronize(); InCountstiReport.Dictionary.Databases.Clear(); InCountstiReport.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("Connection", Hepsa.Core.Common.ConnectionString.ConnectionString)); InCountstiReport.Compile(); InCountstiReport["organ"] = new HPS.BLL.SettingsBLL.BLLSetting_TFactory().GetBy(new BLL.SettingsBLL.BLLSetting_TKeys() { SettingID_int = 1029 }).Value_nvc.ToString(); InCountstiReport["fromdate"] = FromDatefaDatePicker.Text; InCountstiReport["todate"] = ToDatefaDatePicker.Text; InCountstiReport["fromtime_nvc"] = FromTimeTextBox.Text; InCountstiReport["totime_nvc"] = ToTimeTextBox.Text; InCountstiReport["date"] = ActionFactory.ServerJalaliDate; InCountstiReport["UserName"] = HPS.Common.CurrentUser.user.UserName_nvc; InCountstiReport["@FromDate_nvc"] = FromDatefaDatePicker.Text; InCountstiReport["@ToDate_nvc"] = ToDatefaDatePicker.Text; InCountstiReport["@fromtime_nvc"] = FromTimeTextBox.Text; InCountstiReport["@totime_nvc"] = ToTimeTextBox.Text; InCountstiReport.Render(); InCountstiViewerControl.Report = InCountstiReport; } catch (Exception ex) { Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message); } }
private void ShowButton_Click(object sender, EventArgs e) { BLL.TrafficBLL.BLLTraffic_TFactory factory = new BLL.TrafficBLL.BLLTraffic_TFactory(); DT.DataTable dt; try { if (FromDatefaDatePicker.IsNull) { throw new ApplicationException("از تاریخ خالی است"); } else if (ToDatefaDatePicker.IsNull) { throw new ApplicationException("تا تاریخ خالی است"); } else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox))) { throw new ApplicationException("از ساعت خالی است"); } else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox))) { throw new ApplicationException("تا ساعت خالی است"); } Hepsa.Core.Validation.TimeRule <string> FromTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("FromTime", "از ساعت", null, null); if (FromTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox)) == false) { throw new ApplicationException(FromTimeValidator.Description); } Hepsa.Core.Validation.TimeRule <string> ToTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("ToTime", "تا ساعت", null, null); if (ToTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox)) == false) { throw new ApplicationException(ToTimeValidator.Description); } Hepsa.Core.Validation.DateRule <string> FromDateValidator = new Hepsa.Core.Validation.DateRule <string>("FromDate", "از تاریخ", null, null); if (FromDateValidator.Validate(FromDatefaDatePicker.Text) == false) { throw new ApplicationException(FromDateValidator.Description); } Hepsa.Core.Validation.DateRule <string> ToDateValidator = new Hepsa.Core.Validation.DateRule <string>("ToDate", "تا تاریخ", null, null); if (ToDateValidator.Validate(ToDatefaDatePicker.Text) == false) { throw new ApplicationException(ToDateValidator.Description); } if (_TrafficType == 1) { string Turn = string.Empty; if (TurnAcceptedradioButton.Checked == true) { Turn = "Traffic_T.TurnAccepted_bit=1 "; } else if (AllTurnradioButton.Checked == true) { Turn = "Traffic_T.TurnAccepted_bit IS NULL"; } if (!string.IsNullOrEmpty(Turn)) { Turn += " AND "; } Turn += " Traffic_T.TrafficNumber_bint NOT IN (SELECT trafficNumber_bint FROM Traffic_T WHERE Traffic_T.Out_bit = 1 AND (Traffic_T.Date_nvc + ' ' + Traffic_T.Time_nvc >= '" + FromDatefaDatePicker.Text + " " + ToDatefaDatePicker.Text + "') AND (Traffic_T.Date_nvc + ' ' + Traffic_T.Time_nvc <='" + FromDatefaDatePicker.Text + " " + ToDatefaDatePicker.Text + "') ) AND Traffic_T.TrafficNumber_bint NOT IN (SELECT trafficNumber_bint FROM Traffic_T WHERE Traffic_T.TemporaryOut_bit = 1 AND (Traffic_T.Date_nvc + ' ' + Traffic_T.Time_nvc >= '" + FromDatefaDatePicker.Text + " " + ToDatefaDatePicker.Text + "') AND (Traffic_T.Date_nvc + ' ' + Traffic_T.Time_nvc <='" + FromDatefaDatePicker.Text + " " + ToDatefaDatePicker.Text + "')) AND "; //HPS.Reports.ReportDoc.IranianInTrafficReport rpt = new HPS.Reports.ReportDoc.IranianInTrafficReport(FromDatefaDatePicker.Text, ToDatefaDatePicker.Text, "1", FromTimeTextBox.Text, ToTimeTextBox.Text, FromTrafficNumbertxt.Text, ToTrafficNumbertxt.Text, // Convert.ToString(LaderPivotGroupID_intComboBox.SelectedValue), Convert.ToString(LaderTypeID_intComboBox.SelectedValue), Convert.ToString(ServicescomboBox.SelectedValue), Turn); //rpt.Document.Printer.PrinterName = string.Empty; //viewer1.Document = rpt.Document; //rpt.Run(); IranianInTrafficstiReport.Dictionary.Synchronize(); IranianInTrafficstiReport.Dictionary.Databases.Clear(); IranianInTrafficstiReport.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("Connection", Hepsa.Core.Common.ConnectionString.ConnectionString)); IranianInTrafficstiReport.Compile(); IranianInTrafficstiReport["organ"] = new HPS.BLL.SettingsBLL.BLLSetting_TFactory().GetBy(new BLL.SettingsBLL.BLLSetting_TKeys() { SettingID_int = 1029 }).Value_nvc.ToString(); HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory PortPlaceFactory = new HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory(); IranianInTrafficstiReport["fromdate_vc"] = FromDatefaDatePicker.Text; IranianInTrafficstiReport["todate_vc"] = ToDatefaDatePicker.Text; IranianInTrafficstiReport["date_vc"] = PortPlaceFactory.ServerJalaliDate + " " + PortPlaceFactory.ServerTime;; IranianInTrafficstiReport["UserName_vc"] = HPS.Common.CurrentUser.user.UserName_nvc; IranianInTrafficstiReport["fromTrafficNumber"] = FromTrafficNumbertxt.Text; IranianInTrafficstiReport["toTrafficNumber"] = ToTrafficNumbertxt.Text; IranianInTrafficstiReport["FromTime_vc"] = FromTimeTextBox.Text; IranianInTrafficstiReport["ToTime_vc"] = ToTimeTextBox.Text; if (string.IsNullOrEmpty(FromDatefaDatePicker.Text)) { IranianInTrafficstiReport["@FromDateTime_nvc"] = DBNull.Value; } else { IranianInTrafficstiReport["@FromDateTime_nvc"] = FromDatefaDatePicker.Text + ' ' + FromTimeTextBox.Text; } if (string.IsNullOrEmpty(ToDatefaDatePicker.Text)) { IranianInTrafficstiReport["@ToDateTime_nvc"] = DBNull.Value; } else { IranianInTrafficstiReport["@ToDateTime_nvc"] = ToDatefaDatePicker.Text + ' ' + ToTimeTextBox.Text; } if (string.IsNullOrEmpty(FromTrafficNumbertxt.Text)) { IranianInTrafficstiReport["@FromTrafficNumber_nvc"] = DBNull.Value; } else { IranianInTrafficstiReport["@FromTrafficNumber_nvc"] = FromTrafficNumbertxt.Text; } if (string.IsNullOrEmpty(ToTrafficNumbertxt.Text)) { IranianInTrafficstiReport["@ToTrafficNumber_nvc"] = DBNull.Value; } else { IranianInTrafficstiReport["@ToTrafficNumber_nvc"] = ToTrafficNumbertxt.Text; } if (LaderPivotGroupID_intComboBox.SelectedValue == null) { IranianInTrafficstiReport["@LaderPivotGroupID_nvc"] = DBNull.Value; } else { IranianInTrafficstiReport["@LaderPivotGroupID_nvc"] = LaderPivotGroupID_intComboBox.SelectedValue; } //@LaderTypeID_nvc if (LaderTypeID_intComboBox.SelectedValue == null) { IranianInTrafficstiReport["@LaderTypeID_nvc"] = DBNull.Value; } else { IranianInTrafficstiReport["@LaderTypeID_nvc"] = LaderTypeID_intComboBox.SelectedValue; } //@ServiceID_nvc if (ServicescomboBox.SelectedValue == null) { IranianInTrafficstiReport["@ServiceID_nvc"] = DBNull.Value; } else { IranianInTrafficstiReport["@ServiceID_nvc"] = ServicescomboBox.SelectedValue; } // @TrafficTypeID_nvc , IranianInTrafficstiReport["@TrafficTypeID_nvc"] = 1; IranianInTrafficstiReport["@TrafficInbit_nvc"] = 1; IranianInTrafficstiReport["@TrafficOutbit_nvc"] = DBNull.Value; IranianInTrafficstiReport["@TurnAccepted_nvc"] = Turn; if (LaderPivotGroupID_intComboBox.SelectedValue != null) { if (Convert.ToInt32(LaderPivotGroupID_intComboBox.SelectedValue) == 1) { IranianInTrafficstiReport["PivotGrouptxt"] = "(دو محور)"; } else if (Convert.ToInt32(LaderPivotGroupID_intComboBox.SelectedValue) == 2) { IranianInTrafficstiReport["PivotGrouptxt"] = "(سه محور به بالا)"; } } else { IranianInTrafficstiReport["PivotGrouptxt"] = "(تمامی کامیون ها)"; } if (LaderTypeID_intComboBox.SelectedValue != null) { IranianInTrafficstiReport["PivotGrouptxt"] = (string)Hepsa.Core.Common.PersentationController.GetComboBoxDisplayMember(this.LaderTypeID_intComboBox); } IranianInTrafficstiReport.Render(); stiViewerControl1.Report = IranianInTrafficstiReport; dt = new DT.DataTable(); ExportExcelDt = new System.Data.DataTable(); factory.ReportSelectByFieds( IranianInTrafficstiReport["@FromDateTime_nvc"], IranianInTrafficstiReport["@ToDateTime_nvc"], IranianInTrafficstiReport["@FromTrafficNumber_nvc"], IranianInTrafficstiReport["@ToTrafficNumber_nvc"], IranianInTrafficstiReport["@LaderPivotGroupID_nvc"], IranianInTrafficstiReport["@LaderTypeID_nvc"], IranianInTrafficstiReport["@TrafficTypeID_nvc"], IranianInTrafficstiReport["@TrafficInbit_nvc"], IranianInTrafficstiReport["@TrafficOutbit_nvc"], IranianInTrafficstiReport["@ServiceID_nvc"], Turn, ref dt); Dictionary <string, string> Columns = new Dictionary <string, string>(); Columns.Add("TrafficNumber_bint", "شماره قبض"); Columns.Add("TurnNumber_bint", "شماره نوبت"); Columns.Add("DriverCardNumber_nvc", "شماره کارت راننده "); Columns.Add("carCardNumber_nvc", "شماره کارت ناوگان"); Columns.Add("FirstName_nvc", "نام راننده"); Columns.Add("LastName_nvc", "نام خانوادگی راننده"); Columns.Add("NumberPlate_nvc", "شماره پلاک"); Columns.Add("UserName_nvc", "کاربر"); Columns.Add("Date_nvc", "تاریخ ورود"); Columns.Add("Time_nvc", "زمان ورود"); Columns.Add("EditUserName_nvc", "کاربر تایید کننده"); Columns.Add("TurnDate_nvc", "ترایخ نوبت"); Columns.Add("TurnTime_nvc", "زمان نوبت"); Columns.Add("PriceNoTax_dec", "مبلغ"); Columns.Add("PriceTax_dec", "ارزش افزوده"); Columns.Add("Price_dec", "مبلغ دریافتی"); Columns.Add("WithLade_bit", "با بار"); Columns.Add("ServiceID_intServiceType_nvc", "مراجعه به"); foreach (var col in Columns) { ExportExcelDt.Columns.Add(col.Value, col.Key.EndsWith("_bit") ? typeof(bool) : typeof(string)); } DataRow dr; for (int i = 0; i <= dt.Rows.Count - 1; i++) { dr = ExportExcelDt.NewRow(); for (int j = 0; j < Columns.Count; j++) { dr[j] = dt.Rows[i][Columns.Keys.ElementAt(j)]; } ExportExcelDt.Rows.Add(dr); } //gridControl1.DataSource = dt; //gridView1.Columns.Clear(); ////gridView1.PopulateColumns(); //GridColumn column; //int x = 0; //foreach (DataColumn i in dt.Columns) //{ // x++; // if (x == 6) // break; // column = new GridColumn() { FieldName = i.ColumnName,Width = 200,MinWidth = 200,MaxWidth = 200}; // Columns.Add(); //} //gridView1.PopulateColumns(Columns); //gridView1.RefreshData(); //foreach (GridColumn clm in gridView1.Columns) //{ // clm.Width = clm.MinWidth = clm.MaxWidth = 200; //} } if (_TrafficType == 2) { //HPS.Reports.ReportDoc.ForeignInTrafficReport rpt = new HPS.Reports.ReportDoc.ForeignInTrafficReport(FromDatefaDatePicker.Text, ToDatefaDatePicker.Text, 2, FromTimeTextBox.Text, ToTimeTextBox.Text, FromTrafficNumbertxt.Text, ToTrafficNumbertxt.Text); //rpt.Document.Printer.PrinterName = string.Empty; //viewer1.Document = rpt.Document; //rpt.Run(); HPS.BLL.TrafficBLL.BLLTraffic_TFactory TrafficFactory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory(); DT.DataTable TrafficDataTable = new DT.DataTable(); string Condition = string.Empty; string FromTime = FromTimeTextBox.Text; string ToTime = ToTimeTextBox.Text; string FromTrafficNumber = FromTrafficNumbertxt.Text; string ToTrafficNumber = ToTrafficNumbertxt.Text; string FromDate = FromDatefaDatePicker.Text; string ToDate = ToDatefaDatePicker.Text; if (!(string.IsNullOrEmpty(FromTrafficNumber) && string.IsNullOrEmpty(ToTrafficNumber)) && (string.IsNullOrEmpty(FromTime) && string.IsNullOrEmpty(ToTime))) { Condition = "(T.In_bit='True') AND (T.TrafficTypeID_int='2') AND (T.Date_nvc>='" + FromDate + "') AND (T.Date_nvc<='" + ToDate + "') AND (T.TrafficNumber_bint>='" + FromTrafficNumber + "') AND (T.TrafficNumber_bint<='" + ToTrafficNumber + "')"; } else if (string.IsNullOrEmpty(FromTime) && string.IsNullOrEmpty(ToTime) && (string.IsNullOrEmpty(FromTrafficNumber) && string.IsNullOrEmpty(ToTrafficNumber))) { Condition = "(T.In_bit='True') AND (T.TrafficTypeID_int='2') AND (T.Date_nvc>='" + FromDate + "') AND (T.Date_nvc<='" + ToDate + "')"; } else if (!(string.IsNullOrEmpty(FromTime) && string.IsNullOrEmpty(ToTime)) && string.IsNullOrEmpty(FromTrafficNumber) && string.IsNullOrEmpty(ToTrafficNumber)) { Condition = "(T.In_bit='True') AND (T.TrafficTypeID_int='2') AND (T.Date_nvc+ ' ' +T.Time_nvc>='" + FromDate + ' ' + FromTime + "' ) AND (T.Date_nvc + ' ' + T.Time_nvc<='" + ToDate + ' ' + ToTime + "')"; } else if (!((string.IsNullOrEmpty(FromTime) && string.IsNullOrEmpty(ToTime)) && string.IsNullOrEmpty(FromTrafficNumber) && string.IsNullOrEmpty(ToTrafficNumber))) { Condition = "(T.In_bit='True') AND (T.TrafficTypeID_int='2') AND (T.Date_nvc + ' ' + T.Time_nvc>='" + FromDate + ' ' + FromTime + "' ) AND (T.Date_nvc + ' ' + T.Time_nvc<='" + ToDate + ' ' + ToTime + "') AND (T.TrafficNumber_bint>='" + FromTrafficNumber + "') AND (T.TrafficNumber_bint<='" + ToTrafficNumber + "')"; } dt = new DT.DataTable(); ExportExcelDt = new System.Data.DataTable(); ForeignInTrafficReportStiReport.Dictionary.Synchronize(); ForeignInTrafficReportStiReport.Dictionary.Databases.Clear(); ForeignInTrafficReportStiReport.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("Connection", Hepsa.Core.Common.ConnectionString.ConnectionString)); ForeignInTrafficReportStiReport.Compile(); ForeignInTrafficReportStiReport["organ"] = new HPS.BLL.SettingsBLL.BLLSetting_TFactory().GetBy(new BLL.SettingsBLL.BLLSetting_TKeys() { SettingID_int = 1029 }).Value_nvc.ToString(); HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory PortPlaceFactory = new HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory(); ForeignInTrafficReportStiReport["@Condition"] = Condition; ForeignInTrafficReportStiReport["fromdate_vc"] = FromDatefaDatePicker.Text; ForeignInTrafficReportStiReport["todate_vc"] = ToDatefaDatePicker.Text; ForeignInTrafficReportStiReport["date_vc"] = PortPlaceFactory.ServerJalaliDate + " " + PortPlaceFactory.ServerTime;; ForeignInTrafficReportStiReport["UserName_vc"] = HPS.Common.CurrentUser.user.UserName_nvc; ForeignInTrafficReportStiReport["fromTrafficNumber"] = FromTrafficNumbertxt.Text; ForeignInTrafficReportStiReport["toTrafficNumber"] = ToTrafficNumbertxt.Text; ForeignInTrafficReportStiReport["FromTime_vc"] = FromTimeTextBox.Text; ForeignInTrafficReportStiReport["ToTime_vc"] = ToTimeTextBox.Text; ForeignInTrafficReportStiReport.Render(); stiViewerControl1.Report = ForeignInTrafficReportStiReport; factory.GetAllByConditionAllTraffic(Condition, ref dt); Dictionary <string, string> Columns = new Dictionary <string, string>(); Columns.Add("TrafficNumber_bint", "شماره قبض"); //Columns.Add("TurnNumber_bint", "شماره نوبت"); //Columns.Add("DriverCardNumber_nvc", "شماره کارت راننده "); //Columns.Add("carCardNumber_nvc", "شماره کارت ناوگان"); Columns.Add("FirstName_nvc", "نام راننده"); Columns.Add("LastName_nvc", "نام خانوادگی راننده"); Columns.Add("NumberPlate_nvc", "شماره پلاک"); Columns.Add("UserName_nvc", "کاربر"); Columns.Add("Date_nvc", "تاریخ ورود"); Columns.Add("Time_nvc", "زمان ورود"); Columns.Add("EditUserName_nvc", "کاربر تایید کننده"); //Columns.Add("TurnDate_nvc", "تاریخ نوبت"); //Columns.Add("TurnTime_nvc", "زمان نوبت"); Columns.Add("PriceNoTax_dec", "مبلغ"); Columns.Add("PriceTax_dec", "ارزش افزوده"); Columns.Add("Price_dec", "مبلغ دریافتی"); Columns.Add("WithLade_bit", "با بار"); Columns.Add("ServiceID_intServiceType_nvc", "مراجعه به"); foreach (var col in Columns) { ExportExcelDt.Columns.Add(col.Value, col.Key.EndsWith("_bit") ? typeof(bool) : typeof(string)); } DataRow dr; for (int i = 0; i <= dt.Rows.Count - 1; i++) { dr = ExportExcelDt.NewRow(); for (int j = 0; j < Columns.Count; j++) { dr[j] = dt.Rows[i][Columns.Keys.ElementAt(j)]; } ExportExcelDt.Rows.Add(dr); } } if (_TrafficType == 0) { string turn = string.Empty; turn = " Traffic_T.TrafficNumber_bint NOT IN (SELECT trafficNumber_bint FROM Traffic_T WHERE Traffic_T.Out_bit = 1 AND (Traffic_T.Date_nvc + ' ' + Traffic_T.Time_nvc >= '" + FromDatefaDatePicker.Text + " " + ToDatefaDatePicker.Text + "') AND (Traffic_T.Date_nvc + ' ' + Traffic_T.Time_nvc <='" + FromDatefaDatePicker.Text + " " + ToDatefaDatePicker.Text + "')) AND Traffic_T.TrafficNumber_bint NOT IN (SELECT trafficNumber_bint FROM Traffic_T WHERE Traffic_T.TemporaryOut_bit = 1 AND (Traffic_T.Date_nvc + ' ' + Traffic_T.Time_nvc >= '" + FromDatefaDatePicker.Text + " " + ToDatefaDatePicker.Text + "') AND (Traffic_T.Date_nvc + ' ' + Traffic_T.Time_nvc <='" + FromDatefaDatePicker.Text + " " + ToDatefaDatePicker.Text + "')) AND "; //HPS.Reports.ReportDoc.OtherInReport rpt = new HPS.Reports.ReportDoc.OtherInReport(FromDatefaDatePicker.Text, ToDatefaDatePicker.Text, FromTimeTextBox.Text, // ToTimeTextBox.Text, FromTrafficNumbertxt.Text, ToTrafficNumbertxt.Text, Convert.ToString(TrafficTypeID_intComboBox.SelectedValue), Convert.ToString(ServicescomboBox.SelectedValue), turn); //rpt.Document.Printer.PrinterName = string.Empty; //viewer1.Document = rpt.Document; //rpt.Run(); OtherInTrafficStiReport.Dictionary.Synchronize(); OtherInTrafficStiReport.Dictionary.Databases.Clear(); OtherInTrafficStiReport.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("Connection", Hepsa.Core.Common.ConnectionString.ConnectionString)); OtherInTrafficStiReport.Compile(); OtherInTrafficStiReport["organ"] = new HPS.BLL.SettingsBLL.BLLSetting_TFactory().GetBy(new BLL.SettingsBLL.BLLSetting_TKeys() { SettingID_int = 1029 }).Value_nvc.ToString(); HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory PortPlaceFactory = new HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory(); OtherInTrafficStiReport["@FromDateTime_nvc"] = FromDatefaDatePicker.Text + ' ' + FromTimeTextBox.Text; OtherInTrafficStiReport["@ToDateTime_nvc"] = ToDatefaDatePicker.Text + ' ' + ToTimeTextBox.Text; if (string.IsNullOrEmpty(FromTrafficNumbertxt.Text)) { OtherInTrafficStiReport["@FromTrafficNumber_nvc"] = DBNull.Value; } else { OtherInTrafficStiReport["@FromTrafficNumber_nvc"] = FromTrafficNumbertxt.Text; } if (string.IsNullOrEmpty(ToTrafficNumbertxt.Text)) { OtherInTrafficStiReport["@ToTrafficNumber_nvc"] = DBNull.Value; } else { OtherInTrafficStiReport["@ToTrafficNumber_nvc"] = ToTrafficNumbertxt.Text; } OtherInTrafficStiReport["@LaderPivotGroupID_nvc"] = DBNull.Value; OtherInTrafficStiReport["@LaderTypeID_nvc"] = DBNull.Value; OtherInTrafficStiReport["@TrafficTypeID_nvc"] = Convert.ToString(TrafficTypeID_intComboBox.SelectedValue); OtherInTrafficStiReport["@TrafficInbit_nvc"] = "1"; OtherInTrafficStiReport["@TrafficOutbit_nvc"] = DBNull.Value; if (string.IsNullOrEmpty(Convert.ToString(ServicescomboBox.SelectedValue))) { OtherInTrafficStiReport["@ServiceID_nvc"] = DBNull.Value; } else { OtherInTrafficStiReport["@ServiceID_nvc"] = Convert.ToString(ServicescomboBox.SelectedValue); } OtherInTrafficStiReport["@TurnAccepted_nvc"] = turn; OtherInTrafficStiReport["fromdate_vc"] = FromDatefaDatePicker.Text; OtherInTrafficStiReport["todate_vc"] = ToDatefaDatePicker.Text; OtherInTrafficStiReport["date_vc"] = PortPlaceFactory.ServerJalaliDate + " " + PortPlaceFactory.ServerTime;; OtherInTrafficStiReport["UserName_vc"] = HPS.Common.CurrentUser.user.UserName_nvc; OtherInTrafficStiReport["FromTime_vc"] = FromTimeTextBox.Text; OtherInTrafficStiReport["ToTime_vc"] = ToTimeTextBox.Text; OtherInTrafficStiReport.Render(); stiViewerControl1.Report = OtherInTrafficStiReport; dt = new DT.DataTable(); ExportExcelDt = new System.Data.DataTable(); factory.ReportSelectByFieds( OtherInTrafficStiReport["@FromDateTime_nvc"], OtherInTrafficStiReport["@ToDateTime_nvc"], OtherInTrafficStiReport["@FromTrafficNumber_nvc"], OtherInTrafficStiReport["@ToTrafficNumber_nvc"], OtherInTrafficStiReport["@LaderPivotGroupID_nvc"], OtherInTrafficStiReport["@LaderTypeID_nvc"], OtherInTrafficStiReport["@TrafficTypeID_nvc"], OtherInTrafficStiReport["@TrafficInbit_nvc"], OtherInTrafficStiReport["@TrafficOutbit_nvc"], OtherInTrafficStiReport["@ServiceID_nvc"], "", ref dt); Dictionary <string, string> Columns = new Dictionary <string, string>(); Columns.Add("TrafficNumber_bint", "شماره قبض"); //Columns.Add("TurnNumber_bint", "شماره نوبت"); //Columns.Add("DriverCardNumber_nvc", "شماره کارت راننده "); //Columns.Add("carCardNumber_nvc", "شماره کارت ناوگان"); Columns.Add("FirstName_nvc", "نام راننده"); Columns.Add("LastName_nvc", "نام خانوادگی راننده"); Columns.Add("NumberPlate_nvc", "شماره پلاک"); Columns.Add("UserName_nvc", "کاربر"); Columns.Add("Date_nvc", "تاریخ ورود"); Columns.Add("Time_nvc", "زمان ورود"); // Columns.Add("EditUserName_nvc", "کاربر تایید کننده"); //Columns.Add("TurnDate_nvc", "تاریخ نوبت"); //Columns.Add("TurnTime_nvc", "زمان نوبت"); Columns.Add("PriceNoTax_dec", "مبلغ"); Columns.Add("PriceTax_dec", "ارزش افزوده"); Columns.Add("Price_dec", "مبلغ دریافتی"); // Columns.Add("WithLade_bit", "با بار"); Columns.Add("ServiceID_intServiceType_nvc", "مراجعه به"); foreach (var col in Columns) { ExportExcelDt.Columns.Add(col.Value, col.Key.EndsWith("_bit") ? typeof(bool) : typeof(string)); } DataRow dr; for (int i = 0; i <= dt.Rows.Count - 1; i++) { dr = ExportExcelDt.NewRow(); for (int j = 0; j < Columns.Count; j++) { dr[j] = dt.Rows[i][Columns.Keys.ElementAt(j)]; } ExportExcelDt.Rows.Add(dr); } } } catch (Exception ex) { Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message); } }
private void uiButton1_Click(object sender, EventArgs e) { try { if ((FromDatefaDatePicker.IsNull) && (string.IsNullOrEmpty(FromTrafficNumbertxt.Text) || string.IsNullOrEmpty(ToTrafficNumbertxt.Text))) { throw new ApplicationException("از تاریخ خالی است"); } else if ((ToDatefaDatePicker.IsNull && (string.IsNullOrEmpty(FromTrafficNumbertxt.Text) || string.IsNullOrEmpty(ToTrafficNumbertxt.Text)))) { throw new ApplicationException("تا تاریخ خالی است"); } else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox))) { throw new ApplicationException("از ساعت خالی است"); } else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox))) { throw new ApplicationException("تا ساعت خالی است"); } Hepsa.Core.Validation.DateRule <string> FromDateValidator = new Hepsa.Core.Validation.DateRule <string>("FromDate", "از تاریخ", null, null); if (FromDateValidator.Validate(FromDatefaDatePicker.Text) == false) { throw new ApplicationException(FromDateValidator.Description); } Hepsa.Core.Validation.DateRule <string> ToDateValidator = new Hepsa.Core.Validation.DateRule <string>("ToDate", "تا تاریخ", null, null); if (ToDateValidator.Validate(ToDatefaDatePicker.Text) == false) { throw new ApplicationException(ToDateValidator.Description); } Hepsa.Core.Validation.TimeRule <string> FromTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("FromTime", "از ساعت", null, null); if (FromTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox)) == false) { throw new ApplicationException(FromTimeValidator.Description); } Hepsa.Core.Validation.TimeRule <string> ToTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("ToTime", "تا ساعت", null, null); if (ToTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox)) == false) { throw new ApplicationException(ToTimeValidator.Description); } object[] LaderTypeList = new object[100]; string LaderTypeList_nvc = string.Empty; int index = 0; LaderTypeList = LaderTypecheckedComboBox.CheckedValues; if (LaderTypeList != null) { foreach (object obj in LaderTypeList) { LaderTypeList_nvc = string.Format("{0},{1}", LaderTypeList_nvc, LaderTypeList[index].ToString()); index += 1; } LaderTypeList_nvc = LaderTypeList_nvc.Substring(1, LaderTypeList_nvc.Length - 1); } object[] ServiceList = new object[100]; string ServiceList_nvc = string.Empty; int Serviceindex = 0; ServiceList = this.ServicescheckedComboBox.CheckedValues; if (ServiceList != null) { foreach (object obj in ServiceList) { ServiceList_nvc = string.Format("{0},{1}", ServiceList_nvc, ServiceList[Serviceindex].ToString()); Serviceindex += 1; } ServiceList_nvc = ServiceList_nvc.Substring(1, ServiceList_nvc.Length - 1); } GroupTrafficstiReport.Dictionary.Synchronize(); GroupTrafficstiReport.Dictionary.Databases.Clear(); GroupTrafficstiReport.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("Connection", Hepsa.Core.Common.ConnectionString.ConnectionString)); GroupTrafficstiReport.Compile(); GroupTrafficstiReport["organ"] = new HPS.BLL.SettingsBLL.BLLSetting_TFactory().GetBy(new BLL.SettingsBLL.BLLSetting_TKeys() { SettingID_int = 1029 }).Value_nvc.ToString(); HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory PortPlaceFactory = new HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory(); GroupTrafficstiReport["fromdate_vc"] = FromDatefaDatePicker.Text; GroupTrafficstiReport["todate_vc"] = ToDatefaDatePicker.Text; GroupTrafficstiReport["fromtime_nvc"] = FromTimeTextBox.Text; GroupTrafficstiReport["totime_nvc"] = ToTimeTextBox.Text; GroupTrafficstiReport["date_vc"] = PortPlaceFactory.ServerJalaliDate; GroupTrafficstiReport["UserName_vc"] = HPS.Common.CurrentUser.user.UserName_nvc; GroupTrafficstiReport["fromTrafficNumber"] = FromTrafficNumbertxt.Text; GroupTrafficstiReport["toTrafficNumber"] = ToTrafficNumbertxt.Text; if (string.IsNullOrEmpty(FromDatefaDatePicker.Text)) { GroupTrafficstiReport["@FromDateTime_nvc"] = DBNull.Value; } else { GroupTrafficstiReport["@FromDateTime_nvc"] = FromDatefaDatePicker.Text + ' ' + FromTimeTextBox.Text; } if (string.IsNullOrEmpty(ToDatefaDatePicker.Text)) { GroupTrafficstiReport["@ToDateTime_nvc"] = DBNull.Value; } else { GroupTrafficstiReport["@ToDateTime_nvc"] = ToDatefaDatePicker.Text + ' ' + ToTimeTextBox.Text; } if (string.IsNullOrEmpty(LaderTypeList_nvc)) { GroupTrafficstiReport["@LaderTypeID_nvc"] = DBNull.Value; } else { GroupTrafficstiReport["@LaderTypeID_nvc"] = Convert.ToString(LaderTypeList_nvc); } if (InTrafficradioButton.Checked) { GroupTrafficstiReport["@TrafficInbit_nvc"] = 1; GroupTrafficstiReport["@TrafficOutbit_nvc"] = DBNull.Value; GroupTrafficstiReport["TrafficType"] = "ورودی"; } else if (OutTrafficradioButton.Checked) { GroupTrafficstiReport["@TrafficInbit_nvc"] = DBNull.Value; GroupTrafficstiReport["@TrafficOutbit_nvc"] = 1; GroupTrafficstiReport["TrafficType"] = "خروجی"; } else { MessageBox.Show("نوع تردد ورودی یا خروجی بایستی انتخاب شود"); } if (string.IsNullOrEmpty(ServiceList_nvc)) { GroupTrafficstiReport["@ServiceID_nvc"] = DBNull.Value; } else { GroupTrafficstiReport["@ServiceID_nvc"] = Convert.ToString(ServiceList_nvc); } if (string.IsNullOrEmpty(FromTrafficNumbertxt.Text)) { GroupTrafficstiReport["@FromTrafficNumber_nvc"] = DBNull.Value; } else { GroupTrafficstiReport["@FromTrafficNumber_nvc"] = FromTrafficNumbertxt.Text; } if (string.IsNullOrEmpty(ToTrafficNumbertxt.Text)) { GroupTrafficstiReport["@ToTrafficNumber_nvc"] = DBNull.Value; } else { GroupTrafficstiReport["@ToTrafficNumber_nvc"] = ToTrafficNumbertxt.Text; } GroupTrafficstiReport.Render(); stiViewerControl1.Report = GroupTrafficstiReport; } catch (Exception ex) { Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message); } }
private void ShowButton_Click(object sender, EventArgs e) { try { if (FromDatefaDatePicker.IsNull) { throw new ApplicationException("از تاریخ خالی است"); } else if (ToDatefaDatePicker.IsNull) { throw new ApplicationException("تا تاریخ خالی است"); } else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox))) { throw new ApplicationException("از ساعت خالی است"); } else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox))) { throw new ApplicationException("تا ساعت خالی است"); } Hepsa.Core.Validation.TimeRule <string> FromTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("FromTime", "از ساعت", null, null); if (FromTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox)) == false) { throw new ApplicationException(FromTimeValidator.Description); } Hepsa.Core.Validation.TimeRule <string> ToTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("ToTime", "تا ساعت", null, null); if (ToTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox)) == false) { throw new ApplicationException(ToTimeValidator.Description); } object[] LaderTypeList = new object[100]; string LaderTypeList_nvc = string.Empty; int index = 0; LaderTypeList = LaderTypecheckedComboBox.CheckedValues; if (LaderTypeList != null) { foreach (object obj in LaderTypeList) { LaderTypeList_nvc = string.Format("{0},{1}", LaderTypeList_nvc, LaderTypeList[index].ToString()); index += 1; } LaderTypeList_nvc = LaderTypeList_nvc.Substring(1, LaderTypeList_nvc.Length - 1); } HPS.BLL.TrafficBLL.BLLTraffic_TFactory TrafficFactory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory(); CarLadeBillstiReport.Dictionary.Synchronize(); CarLadeBillstiReport.Dictionary.Databases.Clear(); CarLadeBillstiReport.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("Connection", Hepsa.Core.Common.ConnectionString.ConnectionString)); CarLadeBillstiReport.Compile(); CarLadeBillstiReport["organ"] = new HPS.BLL.SettingsBLL.BLLSetting_TFactory().GetBy(new BLL.SettingsBLL.BLLSetting_TKeys() { SettingID_int = 1029 }).Value_nvc.ToString(); CarLadeBillstiReport["date_vc"] = TrafficFactory.ServerJalaliDate + " " + TrafficFactory.ServerTime; CarLadeBillstiReport["UserName_vc"] = HPS.Common.CurrentUser.user.UserName_nvc; CarLadeBillstiReport["fromdate_vc"] = FromDatefaDatePicker.Text; CarLadeBillstiReport["todate_vc"] = ToDatefaDatePicker.Text; CarLadeBillstiReport["fromTime_vc"] = FromTimeTextBox.Text; CarLadeBillstiReport["toTime_vc"] = ToTimeTextBox.Text; CarLadeBillstiReport["@FromDate_nvc"] = FromDatefaDatePicker.Text; CarLadeBillstiReport["@ToDate_nvc"] = ToDatefaDatePicker.Text; CarLadeBillstiReport["@FromTime_nvc"] = FromTimeTextBox.Text; CarLadeBillstiReport["@ToTime_nvc"] = ToTimeTextBox.Text; if (string.IsNullOrEmpty(LaderTypeList_nvc)) { CarLadeBillstiReport["@LaderTypeID_nvc"] = DBNull.Value; } else { CarLadeBillstiReport["@LaderTypeID_nvc"] = Convert.ToString(LaderTypeList_nvc); } if (string.IsNullOrEmpty(CarSerialnumbertextBox.Text)) { CarLadeBillstiReport["@SerialPlate_nvc"] = DBNull.Value; } else { CarLadeBillstiReport["@SerialPlate_nvc"] = CarSerialnumbertextBox.Text; } if (string.IsNullOrEmpty(NumberPlate_nvctextBox.Text)) { CarLadeBillstiReport["@NumberPlate_nvc"] = DBNull.Value; } else { CarLadeBillstiReport["@NumberPlate_nvc"] = NumberPlate_nvctextBox.Text; } //@CarCardNumber_nvc if (string.IsNullOrEmpty(CarCardNumber_nvctextBox.Text)) { CarLadeBillstiReport["@CarCardNumber_nvc"] = DBNull.Value; } else { CarLadeBillstiReport["@CarCardNumber_nvc"] = CarCardNumber_nvctextBox.Text; } CarLadeBillstiReport.Render(); stiViewerControl1.Report = CarLadeBillstiReport; } catch (Exception ex) { Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message); } }
private void ShowWithChartButton_Click(object sender, EventArgs e) { try { if (FromDatefaDatePicker.IsNull) { throw new ApplicationException("از تاریخ خالی است"); } else if (ToDatefaDatePicker.IsNull) { throw new ApplicationException("تا تاریخ خالی است"); } else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox))) { throw new ApplicationException("از ساعت خالی است"); } else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox))) { throw new ApplicationException("تا ساعت خالی است"); } Hepsa.Core.Validation.TimeRule <string> FromTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("FromTime", "از ساعت", null, null); if (FromTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox)) == false) { throw new ApplicationException(FromTimeValidator.Description); } Hepsa.Core.Validation.TimeRule <string> ToTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("ToTime", "تا ساعت", null, null); if (ToTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox)) == false) { throw new ApplicationException(ToTimeValidator.Description); } if (LaderTypeID_intComboBox.SelectedIndex != -1) { //HPS.Reports.ReportDoc.AllInInfoByDateChartReport rpt = new HPS.Reports.ReportDoc.AllInInfoByDateChartReport(FromDatefaDatePicker.Text, FromTimeTextBox.Text, ToDatefaDatePicker.Text, ToTimeTextBox.Text, Convert.ToInt32(LaderTypeID_intComboBox.SelectedValue), LaderTypeID_intComboBox.Text); //rpt.Document.Printer.PrinterName = string.Empty; //viewer1.Document = rpt.Document; //rpt.Run(); AllInInfoByDateChartReportstiReport.Dictionary.Synchronize(); AllInInfoByDateChartReportstiReport.Dictionary.Databases.Clear(); AllInInfoByDateChartReportstiReport.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("Connection", Hepsa.Core.Common.ConnectionString.ConnectionString)); AllInInfoByDateChartReportstiReport.Compile(); HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory PortPlaceFactory = new HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory(); AllInInfoByDateChartReportstiReport["fromDate_nvc"] = FromDatefaDatePicker.Text; AllInInfoByDateChartReportstiReport["toDate_nvc"] = ToDatefaDatePicker.Text; AllInInfoByDateChartReportstiReport["fromTime_nvc"] = FromTimeTextBox.Text; AllInInfoByDateChartReportstiReport["toTime_nvc"] = ToTimeTextBox.Text; AllInInfoByDateChartReportstiReport["date_vc"] = PortPlaceFactory.ServerJalaliDate + " " + PortPlaceFactory.ServerTime; AllInInfoByDateChartReportstiReport["userName_nvc"] = HPS.Common.CurrentUser.user.UserName_nvc; AllInInfoByDateChartReportstiReport["@fromdate_nvc"] = FromDatefaDatePicker.Text; AllInInfoByDateChartReportstiReport["@todate_nvc"] = ToDatefaDatePicker.Text; AllInInfoByDateChartReportstiReport["@fromtime_nvc"] = FromTimeTextBox.Text; AllInInfoByDateChartReportstiReport["@totime_nvc"] = ToTimeTextBox.Text; AllInInfoByDateChartReportstiReport["@LaderTypeList"] = Convert.ToInt32(LaderTypeID_intComboBox.SelectedValue); AllInInfoByDateChartReportstiReport["@FromDate_nvc"] = FromDatefaDatePicker.Text; AllInInfoByDateChartReportstiReport["@ToDate_nvc"] = ToDatefaDatePicker.Text; AllInInfoByDateChartReportstiReport["@FromTime_nvc"] = FromTimeTextBox.Text; AllInInfoByDateChartReportstiReport["@ToTime_nvc"] = ToTimeTextBox.Text; AllInInfoByDateChartReportstiReport["@LaderTypeID_int"] = Convert.ToInt32(LaderTypeID_intComboBox.SelectedValue); AllInInfoByDateChartReportstiReport.Render(); AllInInfoByDateChartReportstiReport.Show(); } else { throw new ApplicationException("نوع بارگیر را انتخاب نمایید"); } } catch (Exception ex) { Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message); } }
private void ShowButton_Click(object sender, EventArgs e) { try { if (FromDatefaDatePicker.IsNull) { throw new ApplicationException("از تاریخ خالی است"); } else if (ToDatefaDatePicker.IsNull) { throw new ApplicationException("تا تاریخ خالی است"); } else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox))) { throw new ApplicationException("از ساعت خالی است"); } else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox))) { throw new ApplicationException("تا ساعت خالی است"); } Hepsa.Core.Validation.TimeRule <string> FromTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("FromTime", "از ساعت", null, null); if (FromTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox)) == false) { throw new ApplicationException(FromTimeValidator.Description); } Hepsa.Core.Validation.TimeRule <string> ToTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("ToTime", "تا ساعت", null, null); if (ToTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox)) == false) { throw new ApplicationException(ToTimeValidator.Description); } //// HPS.BLL.TrafficBLL.BLLTraffic_TFactory TrafficFactory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory(); DataTable AllDataTable = new DataTable(); DataTable LadeAssignmentTable = new DataTable(); TrafficFactory.TurnAndLadeAssignmentInfoByLaderTypeReport(FromDatefaDatePicker.Text, FromTimeTextBox.Text, ToDatefaDatePicker.Text, ToTimeTextBox.Text, null, ref AllDataTable); TrafficFactory.LadeAssignmentInfoByLaderType(FromDatefaDatePicker.Text, FromTimeTextBox.Text, ToDatefaDatePicker.Text, ToTimeTextBox.Text, null, ref LadeAssignmentTable); DataRow[] dr = null; foreach (DataRow row in AllDataTable.Rows) { dr = LadeAssignmentTable.Select(string.Format(" LaderTypeID_int={0} ", row["LaderTypeID_int"])); if (dr != null && dr.Length > 0) { row["Canceled_int"] = dr[0][2]; row["CarCount_int"] = dr[0][3]; row["ladBillCount_int"] = dr[0][4]; row["LadeRemainedCount_int"] = dr[0][5]; row["RemainedPercent_flt"] = dr[0][6]; } else { var ladeset = new HashSet <int>(AllDataTable.AsEnumerable().Select(p => Convert.ToInt32(p["LaderTypeID_int"]))); var ladeResult = LadeAssignmentTable.AsEnumerable().Where(i => !ladeset.Contains(Convert.ToInt32(i["LaderTypeID_int"]))).ToList(); for (int i = 0; i < ladeResult.Count; i++) { row["LaderTypeID_int"] = ladeResult[i]["LaderTypeID_int"]; row["LaderType_nvc"] = ladeResult[i]["LaderType_nvc"]; row["CarCount_int"] = ladeResult[i]["CarCount_int"]; row["ladBillCount_int"] = ladeResult[i]["ladBillCount_int"]; row["LadeRemainedCount_int"] = ladeResult[i]["LadeRemainedCount_int"]; row["RemainedPercent_flt"] = ladeResult[i]["RemainedPercent_flt"]; row["TurnRemainedCount_int"] = 0; AllDataTable.Rows.Add(row); } } } Int64? AllRemainedCountRecords = (from row in AllDataTable.AsEnumerable() select Convert.ToInt32(row["LadeRemainedCount_int"])).Sum(); string AllLadeRemaindedCounttxt = AllRemainedCountRecords.HasValue ? AllRemainedCountRecords.ToString() : "0"; Int64? AllRequestCountRecords = (from row in AllDataTable.AsEnumerable() select Convert.ToInt32(row["CarCount_int"])).Sum(); string AllRequesttxt = AllRequestCountRecords.HasValue ? AllRequestCountRecords.ToString() : "0"; Int64? AllLadBillCountRecords = (from row in AllDataTable.AsEnumerable() select Convert.ToInt32(row["LadBillCount_int"])).Sum(); string AllLadBillxt = AllLadBillCountRecords.HasValue ? AllLadBillCountRecords.ToString() : "0"; string AllRemainedPercentTxt = ""; if (Convert.ToInt32(AllRequesttxt) != 0) { AllRemainedPercentTxt = (Convert.ToDouble(AllLadeRemaindedCounttxt) * 100 / Convert.ToDouble(AllRequesttxt)).ToString("0.##"); } else { AllRemainedPercentTxt = "0"; } DataSet MyDataset = new DataSet(); MyDataset.Tables.Add(AllDataTable); AllInfoByDatestiReport.Dictionary.Synchronize(); AllInfoByDatestiReport.Dictionary.Databases.Clear(); AllInfoByDatestiReport.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("Connection", Hepsa.Core.Common.ConnectionString.ConnectionString)); AllInfoByDatestiReport.RegData(MyDataset); AllInfoByDatestiReport.Compile(); AllInfoByDatestiReport["organ"] = new HPS.BLL.SettingsBLL.BLLSetting_TFactory().GetBy(new BLL.SettingsBLL.BLLSetting_TKeys() { SettingID_int = 1029 }).Value_nvc.ToString(); AllInfoByDatestiReport["date_vc"] = TrafficFactory.ServerJalaliDate + " " + TrafficFactory.ServerTime; AllInfoByDatestiReport["UserName_vc"] = HPS.Common.CurrentUser.user.UserName_nvc; AllInfoByDatestiReport["AllRemainedPercentTxt"] = AllRemainedPercentTxt; AllInfoByDatestiReport["fromdate_vc"] = FromDatefaDatePicker.Text; AllInfoByDatestiReport["todate_vc"] = ToDatefaDatePicker.Text; AllInfoByDatestiReport["fromTime_vc"] = FromTimeTextBox.Text; AllInfoByDatestiReport["toTime_vc"] = ToTimeTextBox.Text; AllInfoByDatestiReport.Render(); stiViewerControl1.Report = AllInfoByDatestiReport; //// //HPS.Reports.ReportDoc.AllInfoByDateReport rpt = new HPS.Reports.ReportDoc.AllInfoByDateReport(FromDatefaDatePicker.Text, FromTimeTextBox.Text, ToDatefaDatePicker.Text, ToTimeTextBox.Text); //rpt.Document.Printer.PrinterName = string.Empty; //viewer1.Document = rpt.Document; //rpt.Run(); } catch (Exception ex) { Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message); } }
private void ShowButton_Click(object sender, EventArgs e) { try { if (FromDatefaDatePicker.IsNull) { throw new ApplicationException("از تاریخ خالی است"); } else if (ToDatefaDatePicker.IsNull) { throw new ApplicationException("تا تاریخ خالی است"); } else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox))) { throw new ApplicationException("از ساعت خالی است"); } else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox))) { throw new ApplicationException("تا ساعت خالی است"); } Hepsa.Core.Validation.DateRule <string> FromDateValidator = new Hepsa.Core.Validation.DateRule <string>("FromDate", "از تاریخ", null, null); if (FromDateValidator.Validate(FromDatefaDatePicker.Text) == false) { throw new ApplicationException(FromDateValidator.Description); } Hepsa.Core.Validation.DateRule <string> ToDateValidator = new Hepsa.Core.Validation.DateRule <string>("ToDate", "تا تاریخ", null, null); if (ToDateValidator.Validate(ToDatefaDatePicker.Text) == false) { throw new ApplicationException(ToDateValidator.Description); } Hepsa.Core.Validation.TimeRule <string> FromTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("FromTime", "از ساعت", null, null); if (FromTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox)) == false) { throw new ApplicationException(FromTimeValidator.Description); } Hepsa.Core.Validation.TimeRule <string> ToTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("ToTime", "تا ساعت", null, null); if (ToTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox)) == false) { throw new ApplicationException(ToTimeValidator.Description); } object[] PortPlaceList = new object[100]; string PortPlaceList_nvc = string.Empty; int index = 0; PortPlaceList = portPlacecheckedComboBox.CheckedValues; if (PortPlaceList != null) { foreach (object obj in PortPlaceList) { PortPlaceList_nvc = string.Format("{0},{1}", PortPlaceList_nvc, PortPlaceList[index].ToString()); index += 1; } PortPlaceList_nvc = PortPlaceList_nvc.Substring(1, PortPlaceList_nvc.Length - 1); } PortPlacestiReport.Dictionary.Synchronize(); PortPlacestiReport.Dictionary.Databases.Clear(); PortPlacestiReport.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("Connection", Hepsa.Core.Common.ConnectionString.ConnectionString)); PortPlacestiReport.Compile(); PortPlacestiReport["organ"] = new HPS.BLL.SettingsBLL.BLLSetting_TFactory().GetBy(new BLL.SettingsBLL.BLLSetting_TKeys() { SettingID_int = 1029 }).Value_nvc.ToString(); HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory PortPlaceFactory = new HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory(); PortPlacestiReport["fromdate_vc"] = FromDatefaDatePicker.Text; PortPlacestiReport["todate_vc"] = ToDatefaDatePicker.Text; PortPlacestiReport["fromtime_nvc"] = FromTimeTextBox.Text; PortPlacestiReport["totime_nvc"] = ToTimeTextBox.Text; PortPlacestiReport["date_vc"] = PortPlaceFactory.ServerJalaliDate; PortPlacestiReport["UserName_vc"] = HPS.Common.CurrentUser.user.UserName_nvc; PortPlacestiReport["@fromdate_nvc"] = FromDatefaDatePicker.Text; PortPlacestiReport["@fromtime_nvc"] = FromTimeTextBox.Text; PortPlacestiReport["@todate_nvc"] = ToDatefaDatePicker.Text; PortPlacestiReport["@totime_nvc"] = ToTimeTextBox.Text; if (PortPlaceList_nvc == string.Empty) { PortPlacestiReport["@PortPlaceList"] = DBNull.Value; } else { PortPlacestiReport["@PortPlaceList"] = PortPlaceList_nvc; } PortPlacestiReport.Render(); stiViewerControl1.Report = PortPlacestiReport; } catch (Exception ex) { Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message); } }
private void ShowButton_Click(object sender, EventArgs e) { try { if (FromDatefaDatePicker.IsNull) { throw new ApplicationException("از تاریخ خالی است"); } else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox))) { throw new ApplicationException("از ساعت خالی است"); } else if (ToDatefaDatePicker.IsNull) { throw new ApplicationException("تا تاریخ خالی است"); } else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox))) { throw new ApplicationException("تا ساعت خالی است"); } Hepsa.Core.Validation.DateRule <string> FromDateValidator = new Hepsa.Core.Validation.DateRule <string>("FromDate", "از تاریخ", null, null); if (FromDateValidator.Validate(FromDatefaDatePicker.Text) == false) { throw new ApplicationException(FromDateValidator.Description); } Hepsa.Core.Validation.DateRule <string> ToDateValidator = new Hepsa.Core.Validation.DateRule <string>("ToDate", "تا تاریخ", null, null); if (ToDateValidator.Validate(ToDatefaDatePicker.Text) == false) { throw new ApplicationException(ToDateValidator.Description); } Hepsa.Core.Validation.TimeRule <string> FromTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("FromTime", "از ساعت", null, null); if (FromTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox)) == false) { throw new ApplicationException(FromTimeValidator.Description); } Hepsa.Core.Validation.TimeRule <string> ToTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("ToTime", "تا ساعت", null, null); if (ToTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox)) == false) { throw new ApplicationException(ToTimeValidator.Description); } string CompanyList_nvc = string.Empty; foreach (Janus.Windows.GridEX.GridEXRow itm in companyGrid.GetCheckedRows()) { CompanyList_nvc += itm.Cells["CompanyID_int"].Value.ToString() + ","; } if (CompanyList_nvc.EndsWith(",")) { CompanyList_nvc = CompanyList_nvc.Remove(CompanyList_nvc.Length - 1); } companyGrid.UnCheckAllRecords(); string LaderTypeList_nvc = string.Empty; foreach (Janus.Windows.GridEX.GridEXRow itm in laderTypeGrid.GetCheckedRows()) { LaderTypeList_nvc += itm.Cells["LaderTypeID_int"].Value.ToString() + ","; } if (LaderTypeList_nvc.EndsWith(",")) { LaderTypeList_nvc = LaderTypeList_nvc.Remove(LaderTypeList_nvc.Length - 1); } laderTypeGrid.UnCheckAllRecords(); //////create Order list string OrderColumns_nvc = string.Empty; OrderColumns_nvc = " T1.LadeDate_nvc "; bool justRemained = false; if (JustRemainedCheckBox.Checked) { justRemained = true; } string GoodList_nvc = string.Empty; foreach (Janus.Windows.GridEX.GridEXRow itm in goodGrid.GetCheckedRows()) { GoodList_nvc += itm.Cells["GoodID_int"].Value.ToString() + ","; } if (GoodList_nvc.EndsWith(",")) { GoodList_nvc = GoodList_nvc.Remove(GoodList_nvc.Length - 1); } goodGrid.UnCheckAllRecords(); string PortPlaceList_nvc = string.Empty; foreach (Janus.Windows.GridEX.GridEXRow itm in portPlaceGrid.GetCheckedRows()) { PortPlaceList_nvc += itm.Cells["PortPlacesID_int"].Value.ToString() + ","; } if (PortPlaceList_nvc.EndsWith(",")) { PortPlaceList_nvc = PortPlaceList_nvc.Remove(PortPlaceList_nvc.Length - 1); } portPlaceGrid.UnCheckAllRecords(); string DestinationCityList_nvc = string.Empty; foreach (Janus.Windows.GridEX.GridEXRow itm in destinationCityGrid.GetCheckedRows()) { DestinationCityList_nvc += itm.Cells["CityID_int"].Value.ToString() + ","; } if (DestinationCityList_nvc.EndsWith(",")) { DestinationCityList_nvc = DestinationCityList_nvc.Remove(DestinationCityList_nvc.Length - 1); } destinationCityGrid.UnCheckAllRecords(); //////////////////////////////////////// //HPS.Reports.ReportDoc.CompanyRemanedLadBillWithDateReport rpt = new HPS.Reports.ReportDoc.CompanyRemanedLadBillWithDateReport(FromDatefaDatePicker.Text, FromTimeTextBox.Text, ToDatefaDatePicker.Text, ToTimeTextBox.Text, LaderTypeList_nvc, CompanyList_nvc, OrderColumns_nvc, justRemained, GoodList_nvc, DestinationCityList_nvc, PortPlaceList_nvc); //viewer1.Document = rpt.Document; //rpt.Document.Printer.PrinterName = string.Empty; //rpt.Run(); HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory LadeAssignmenFactory = new HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory(); DataTable LaderTypeReportTable = new DataTable(); DataSet LaderTypeDataset = new DataSet(); LadeAssignmenFactory.SelectCompanyLadeAssignmentDetail(FromDatefaDatePicker.Text, FromTimeTextBox.Text, ToDatefaDatePicker.Text, ToTimeTextBox.Text, LaderTypeList_nvc, CompanyList_nvc, GoodList_nvc, DestinationCityList_nvc, PortPlaceList_nvc, OrderColumns_nvc, ref LaderTypeReportTable); DataTable dt = null; if (JustRemainedCheckBox.Checked) { LaderTypeReportTable.DefaultView.RowFilter = "RemainderCount_int <>0"; dt = LaderTypeReportTable.DefaultView.ToTable(); } else if (JustCanceledCheckBox.Checked) { LaderTypeReportTable.DefaultView.RowFilter = "CanceledByCompany <>0 OR CanceledByLadBillCanceled<>0"; dt = LaderTypeReportTable.DefaultView.ToTable(); } else { dt = LaderTypeReportTable; } dt.Columns.Add("RemainedPercent"); foreach (DataRow row in dt.Rows) { double RemainedPercent = (Convert.ToDouble(row["RemainderCount_int"]) * 100) / (Convert.ToDouble(row["CarCount_int"])); row["RemainedPercent"] = RemainedPercent.ToString("0.##"); } LaderTypeDataset.Tables.Add(dt.Copy()); CompanyRemanedLadBillStiReport.Dictionary.Synchronize(); CompanyRemanedLadBillStiReport.Dictionary.Databases.Clear(); CompanyRemanedLadBillStiReport.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("Connection", Hepsa.Core.Common.ConnectionString.ConnectionString)); CompanyRemanedLadBillStiReport.RegData(LaderTypeDataset); CompanyRemanedLadBillStiReport.Compile(); CompanyRemanedLadBillStiReport["organ"] = new HPS.BLL.SettingsBLL.BLLSetting_TFactory().GetBy(new BLL.SettingsBLL.BLLSetting_TKeys() { SettingID_int = 1029 }).Value_nvc.ToString(); HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory PortPlaceFactory = new HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory(); CompanyRemanedLadBillStiReport["fromDate_nvc"] = FromDatefaDatePicker.Text; CompanyRemanedLadBillStiReport["fromTime_nvc"] = FromTimeTextBox.Text; CompanyRemanedLadBillStiReport["toTime_nvc"] = ToTimeTextBox.Text; CompanyRemanedLadBillStiReport["toDate_nvc"] = ToDatefaDatePicker.Text; CompanyRemanedLadBillStiReport["date_vc"] = PortPlaceFactory.ServerJalaliDate + " " + PortPlaceFactory.ServerTime;; CompanyRemanedLadBillStiReport["UserName_vc"] = HPS.Common.CurrentUser.user.UserName_nvc; if (JustRemainedCheckBox.Checked) { CompanyRemanedLadBillStiReport["title_nvc"] = "بارهای جامانده شرکت های حمل و نقل"; } else if (JustCanceledCheckBox.Checked) { CompanyRemanedLadBillStiReport["title_nvc"] = "بارهای ابطالی شرکت های حمل و نقل"; } else { CompanyRemanedLadBillStiReport["title_nvc"] = "بارهای درخواستی و جامانده شرکت های حمل و نقل"; } // //CompanyRemanedLadBillStiReport["@fromdate_nvc"] = FromDatefaDatePicker.Text; //CompanyRemanedLadBillStiReport["@fromtime_nvc"] = FromTimeTextBox.Text; //CompanyRemanedLadBillStiReport["@totime_nvc"] = ToTimeTextBox.Text; //CompanyRemanedLadBillStiReport["@todate_nvc"] = ToDatefaDatePicker.Text; //if (string.IsNullOrEmpty(LaderTypeList_nvc)) // CompanyRemanedLadBillStiReport["@LaderTypeID_int"] = DBNull.Value; //else // CompanyRemanedLadBillStiReport["@LaderTypeID_int"] = LaderTypeList_nvc; //if (string.IsNullOrEmpty(CompanyList_nvc)) // CompanyRemanedLadBillStiReport["@CompanyID_int"] = DBNull.Value; //else // CompanyRemanedLadBillStiReport["@CompanyID_int"] = CompanyList_nvc; //if (string.IsNullOrEmpty(GoodList_nvc)) // CompanyRemanedLadBillStiReport["@GoodIDList_nvc"] = DBNull.Value; //else // CompanyRemanedLadBillStiReport["@GoodIDList_nvc"] = GoodList_nvc; //if (string.IsNullOrEmpty(DestinationCityList_nvc)) // CompanyRemanedLadBillStiReport["@DestinationCityIDList_nvc"] = DBNull.Value; //else // CompanyRemanedLadBillStiReport["@DestinationCityIDList_nvc"] = DestinationCityList_nvc; //if (string.IsNullOrEmpty(PortPlaceList_nvc)) // CompanyRemanedLadBillStiReport["@PortPlaceIDList_nvc"] = DBNull.Value; //else // CompanyRemanedLadBillStiReport["@PortPlaceIDList_nvc"] = PortPlaceList_nvc; //if (string.IsNullOrEmpty(OrderColumns_nvc)) // CompanyRemanedLadBillStiReport["@OrderColumns_nvc"] = DBNull.Value; //else // CompanyRemanedLadBillStiReport["@OrderColumns_nvc"] = OrderColumns_nvc; CompanyRemanedLadBillStiReport.Render(); stiViewerControl1.Report = CompanyRemanedLadBillStiReport; } catch (Exception ex) { Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message); } }