private void Savebutton_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(UserNametextBox.Text) || string.IsNullOrEmpty(PasstextBox.Text)) { Hepsa.Core.Common.MessageBox.ErrorMessage("لطفا نام کاربری و رمز عبور را وارد کنید"); return; } else { //Password_nvc = Hepsa.Core.Common.Security.MD5(PasstextBox.Text); HPS.BLL.SettingsBLL.BLLSetting_T SettingEntity = new HPS.BLL.SettingsBLL.BLLSetting_T(); HPS.BLL.SettingsBLL.BLLSetting_TFactory SettingFactory = new HPS.BLL.SettingsBLL.BLLSetting_TFactory(); HPS.BLL.SettingsBLL.BLLSetting_TKeys SettingKey = new HPS.BLL.SettingsBLL.BLLSetting_TKeys(); SettingKey.SettingID_int = 1005; SettingEntity = SettingFactory.GetBy(SettingKey); SettingEntity.Value_nvc = UserNametextBox.Text; SettingFactory.Update(SettingEntity, SettingKey); SettingKey.SettingID_int = 1006; SettingEntity = SettingFactory.GetBy(SettingKey); SettingEntity.Value_nvc = PasstextBox.Text; SettingFactory.Update(SettingEntity, SettingKey); //SettingEntity.Value_nvc = Hepsa.Core.Common.Security.MD5(NewPasstextBox.Text); Hepsa.Core.Common.MessageBox.InformationMessage("رمز عبور جدید ثبت شد"); this.Close(); } }
private void okbutton_Click(object sender, EventArgs e) { String Pass = string.Empty; string UserName = string.Empty; HPS.BLL.SettingsBLL.BLLSetting_TFactory SettingFactory = new HPS.BLL.SettingsBLL.BLLSetting_TFactory(); HPS.BLL.SettingsBLL.BLLSetting_TKeys SettingKey = new HPS.BLL.SettingsBLL.BLLSetting_TKeys(); HPS.BLL.SettingsBLL.BLLSetting_T SettingEntity = new HPS.BLL.SettingsBLL.BLLSetting_T(); SettingKey.SettingID_int = 1005; SettingEntity = SettingFactory.GetBy(SettingKey); UserName = SettingEntity.Value_nvc; SettingKey.SettingID_int = 1006; SettingEntity = SettingFactory.GetBy(SettingKey); Pass = SettingEntity.Value_nvc; if (UserName_nvctextBox.Text == UserName && PasswordtextBox.Text == Pass) { this._True_bit = true; this.Close(); } else { this._True_bit = false; Hepsa.Core.Common.MessageBox.ErrorMessage("نام کاربری و رمز عبور اشتباه می باشد"); } }
private void ShowButton_Click(object sender, EventArgs e) { string Condition = string.Empty; Condition = "LadeAssignment_T.Date_nvc>='" + FromDatefaDatePicker.Text + "' AND LadeAssignment_T.Date_nvc<='" + ToDatefaDatePicker.Text + "'"; if (CompanyID_intComboBox.SelectedValue != null && (int)CompanyID_intComboBox.SelectedValue != 0) { Condition += " AND LadeAssignment_T.CompanyID_int=" + Convert.ToInt32(CompanyID_intComboBox.SelectedValue); } HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory LadeAssignmentFactory = new HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory(); CompanyAllLadeAssignmentedstiReport.Dictionary.Synchronize(); CompanyAllLadeAssignmentedstiReport.Dictionary.Databases.Clear(); CompanyAllLadeAssignmentedstiReport.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("Connection", Hepsa.Core.Common.ConnectionString.ConnectionString)); CompanyAllLadeAssignmentedstiReport.Compile(); CompanyAllLadeAssignmentedstiReport["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(); CompanyAllLadeAssignmentedstiReport["FromDate_vc"] = FromDatefaDatePicker.Text; CompanyAllLadeAssignmentedstiReport["ToDate_vc"] = ToDatefaDatePicker.Text; CompanyAllLadeAssignmentedstiReport["Date_vc"] = PortPlaceFactory.ServerJalaliDate + " " + PortPlaceFactory.ServerTime;; CompanyAllLadeAssignmentedstiReport["UserName_vc"] = HPS.Common.CurrentUser.user.UserName_nvc; CompanyAllLadeAssignmentedstiReport["@Condition"] = Condition; CompanyAllLadeAssignmentedstiReport.Render(); this.stiViewerControl1.Report = CompanyAllLadeAssignmentedstiReport; }
private void PrintCanceledButton_Click(object sender, EventArgs e) { try { HPS.BLL.TrafficBLL.BLLTraffic_TFactory TrafficFactory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory(); string Condition = string.Empty; AllCanceledTurnstiReport.Dictionary.Synchronize(); AllCanceledTurnstiReport.Dictionary.Databases.Clear(); AllCanceledTurnstiReport.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("Connection", Hepsa.Core.Common.ConnectionString.ConnectionString)); AllCanceledTurnstiReport.Compile(); AllCanceledTurnstiReport["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(); AllCanceledTurnstiReport["@FromDate_nvc"] = FromDatefaDatePicker.Text; AllCanceledTurnstiReport["@ToDate_nvc"] = ToDatefaDatePicker.Text; AllCanceledTurnstiReport["@FromTime_nvc"] = FromTimeTextBox.Text; AllCanceledTurnstiReport["@ToTime_nvc"] = ToTimeTextBox.Text; AllCanceledTurnstiReport["fromdate_vc"] = FromDatefaDatePicker.Text; AllCanceledTurnstiReport["todate_vc"] = ToDatefaDatePicker.Text; AllCanceledTurnstiReport["date_vc"] = PortPlaceFactory.ServerJalaliDate + " " + PortPlaceFactory.ServerTime;; AllCanceledTurnstiReport["UserName_vc"] = HPS.Common.CurrentUser.user.UserName_nvc; AllCanceledTurnstiReport.Render(); AllCanceledTurnstiReport.Show(); } catch (Exception ex) { Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message); } }
private void LoadTurnManagement() { try { if (_TurnStatus == 1) //return { HPS.BLL.SettingsBLL.BLLSetting_TFactory SettingFactory = new HPS.BLL.SettingsBLL.BLLSetting_TFactory(); HPS.BLL.SettingsBLL.BLLSetting_T SettingEntity = new HPS.BLL.SettingsBLL.BLLSetting_T(); HPS.BLL.SettingsBLL.BLLSetting_TKeys SettingKey = new HPS.BLL.SettingsBLL.BLLSetting_TKeys(); DateTime NowDate = DateTime.Parse((new Hepsa.Core.Common.MyDateTime(SettingFactory.ServerJalaliDate)).MyDate.ToString("yyyy/MM/dd") + " " + SettingFactory.ServerTime); DateTime SubtractedTime = NowDate.Subtract(new TimeSpan(Convert.ToInt32(SettingEntity.Value_nvc), 0, 0)); SettingKey.SettingID_int = 1001; SettingEntity = SettingFactory.GetBy(SettingKey); HPS.BLL.TurnManagementBLL.BLLTurnManagement_TFactory TurnManagementFactory = new HPS.BLL.TurnManagementBLL.BLLTurnManagement_TFactory(); DataTable TurnManagementDataTable = new DataTable(); TurnManagementFactory.GetAllWithTrafficForReturnTurn(SettingFactory.ServerJalaliDate, SubtractedTime.ToString("HH:mm"), null, null, string.Empty, string.Empty, string.Empty, string.Empty, ref TurnManagementDataTable); this.TurnManagementGridView.DataSource = TurnManagementDataTable; } else //cancel { CanceledTurnFromLadbilltoolStripButton.Visible = false; HPS.BLL.TurnManagementBLL.BLLTurnManagement_TFactory TurnManagementFactory = new HPS.BLL.TurnManagementBLL.BLLTurnManagement_TFactory(); DataTable TurnManagementDataTable = new DataTable(); TurnManagementFactory.GetAllWithTrafficForCancelTurn(null, null, string.Empty, string.Empty, string.Empty, string.Empty, ref TurnManagementDataTable); this.TurnManagementGridView.DataSource = TurnManagementDataTable; } } catch (System.Exception ex) { throw ex; } }
private void ShowButton_Click(object sender, EventArgs e) { try { if (FromDatefaDatePicker.IsNull) { throw new ApplicationException("از تاریخ خالی است"); } else if (ToDatefaDatePicker.IsNull) { 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); } //HPS.Reports.ReportDoc.LastTurnNumberAndRemaindCountByLaderTypeReport report = new HPS.Reports.ReportDoc.LastTurnNumberAndRemaindCountByLaderTypeReport(FromDatefaDatePicker.Text, ToDatefaDatePicker.Text); //report.Document.Printer.PrinterName = string.Empty; //viewer1.Document = report.Document; //report.Run(); LastTurnNumberAndRemaindCountByLaderTypeReport.Dictionary.Synchronize(); LastTurnNumberAndRemaindCountByLaderTypeReport.Dictionary.Databases.Clear(); LastTurnNumberAndRemaindCountByLaderTypeReport.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("Connection", Hepsa.Core.Common.ConnectionString.ConnectionString)); LastTurnNumberAndRemaindCountByLaderTypeReport.Compile(); LastTurnNumberAndRemaindCountByLaderTypeReport["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(); LastTurnNumberAndRemaindCountByLaderTypeReport["fromdate_vc"] = FromDatefaDatePicker.Text; LastTurnNumberAndRemaindCountByLaderTypeReport["todate_vc"] = ToDatefaDatePicker.Text; LastTurnNumberAndRemaindCountByLaderTypeReport["date_vc"] = PortPlaceFactory.ServerJalaliDate + " " + PortPlaceFactory.ServerTime;; LastTurnNumberAndRemaindCountByLaderTypeReport["UserName_vc"] = HPS.Common.CurrentUser.user.UserName_nvc; LastTurnNumberAndRemaindCountByLaderTypeReport["@FromDate_nvc"] = FromDatefaDatePicker.Text; LastTurnNumberAndRemaindCountByLaderTypeReport["@ToDate_nvc"] = ToDatefaDatePicker.Text; LastTurnNumberAndRemaindCountByLaderTypeReport.Render(); this.stiViewerControl1.Report = LastTurnNumberAndRemaindCountByLaderTypeReport; } catch (Exception ex) { Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message); } }
private Int32 CancelTimeExpiredTurns(string Date_nvc, string LaderTypeID_nvc) { HPS.BLL.SettingsBLL.BLLSetting_TFactory SettingFactory = new HPS.BLL.SettingsBLL.BLLSetting_TFactory(); HPS.BLL.SettingsBLL.BLLSetting_T SettingEntity = new HPS.BLL.SettingsBLL.BLLSetting_T(); HPS.BLL.SettingsBLL.BLLSetting_TKeys SettingKey = new HPS.BLL.SettingsBLL.BLLSetting_TKeys(); SettingKey.SettingID_int = 1008; SettingEntity = SettingFactory.GetBy(SettingKey); int Canceledrowcount = -1; if (string.IsNullOrEmpty(LaderTypeID_nvc) && string.IsNullOrEmpty(Date_nvc)) { Canceledrowcount = DoCancelOperation(string.Empty, string.Empty); } else { Canceledrowcount = DoCancelOperation(Date_nvc, LaderTypeID_nvc); } return(Canceledrowcount); }
private void LoadSetting() { try { if (Hepsa.Core.Common.CurrentUser.User.UserName_nvc != "admin" && Hepsa.Core.Common.CurrentUser.User.UserName_nvc != "backup") { if (tabControl1.TabPages.Count > 1) { tabControl1.TabPages.Remove(tabControl1.TabPages[1]); tabControl1.TabPages.Remove(tabControl1.TabPages[1]); } } HPS.BLL.SettingsBLL.BLLSetting_TFactory SettingFactory = new HPS.BLL.SettingsBLL.BLLSetting_TFactory(); DataTable SettingDataTable = new DataTable(); SettingFactory.GetAllFormated(ref SettingDataTable); this.SettingDataGrid.AutoGenerateColumns = false; this.SettingDataGrid.DataSource = SettingDataTable; } catch (Exception ex) { Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message); } }
private void PrintstripButton_Click(object sender, EventArgs e) { try { LadeAssignmentInfoGridView.Visible = false; SumPanel.Visible = false; if (FromDatefaDatePicker.IsNull) { throw new ApplicationException("از تاریخ خالی است"); } else if (ToDatefaDatePicker.IsNull) { throw new ApplicationException("تا تاریخ خالی است"); } string CompanyCodeList_nvc = string.Empty; foreach (Janus.Windows.GridEX.GridEXRow itm in companyGrid.GetCheckedRows()) { CompanyCodeList_nvc += itm.Cells["CompanyCode_nvc"].Value.ToString() + ","; } if (CompanyCodeList_nvc.EndsWith(",")) { CompanyCodeList_nvc = CompanyCodeList_nvc.Remove(CompanyCodeList_nvc.Length - 1); } string LaderTypeCodeList_nvc = string.Empty; foreach (Janus.Windows.GridEX.GridEXRow itm in laderTypeGrid.GetCheckedRows()) { LaderTypeCodeList_nvc += itm.Cells["LaderTypeCode_nvc"].Value.ToString() + ","; } if (LaderTypeCodeList_nvc.EndsWith(",")) { LaderTypeCodeList_nvc = LaderTypeCodeList_nvc.Remove(LaderTypeCodeList_nvc.Length - 1); } //HPS.Reports.ReportDoc.UseLadBillVSLadeCountReport rpt = new HPS.Reports.ReportDoc.UseLadBillVSLadeCountReport(FromDatefaDatePicker.Text, ToDatefaDatePicker.Text, CompanyCodeList_nvc, LaderTypeCodeList_nvc, ((DataTable)LadeAssignmentInfoGridView.DataSource).DefaultView); //rpt.Document.Printer.PrinterName = string.Empty; //viewer1.Document = rpt.Document; //rpt.Run(); UseLadBillVSLadeCountReportstiReport.Dictionary.Synchronize(); UseLadBillVSLadeCountReportstiReport.Dictionary.Databases.Clear(); UseLadBillVSLadeCountReportstiReport.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("Connection", Hepsa.Core.Common.ConnectionString.ConnectionString)); UseLadBillVSLadeCountReportstiReport.Compile(); UseLadBillVSLadeCountReportstiReport["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(); //مقدار دهی متغیرها UseLadBillVSLadeCountReportstiReport["fromDate_nvc"] = FromDatefaDatePicker.Text; UseLadBillVSLadeCountReportstiReport["toDate_nvc"] = ToDatefaDatePicker.Text; UseLadBillVSLadeCountReportstiReport["date_vc"] = PortPlaceFactory.ServerJalaliDate + " " + PortPlaceFactory.ServerTime;; UseLadBillVSLadeCountReportstiReport["userName_nvc"] = HPS.Common.CurrentUser.user.UserName_nvc; UseLadBillVSLadeCountReportstiReport.Render(); UseLadBillVSLadeCountReportstiReport.Show(); } catch (Exception ex) { } }
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) { try { HPS.BLL.LadBillCreditBLL.BLLLadBillCredit_TFactory LadBillFactory = new HPS.BLL.LadBillCreditBLL.BLLLadBillCredit_TFactory(); DataTable LadBillCreditDataTable = new DataTable(); if (FromDatefaDatePicker.IsNull) { throw new ApplicationException("از تاریخ خالی است"); } else if (ToDatefaDatePicker.IsNull) { throw new ApplicationException("تا تاریخ خالی است"); } Hepsa.Core.Validation.DateRule <string> FromDateValidator = new Hepsa.Core.Validation.DateRule <string>("FromDate", "از تاریخ", null, null); if (FromDateValidator.Validate(Hepsa.Core.Common.PersentationController.GetEntityValue(FromDatefaDatePicker.Text, TypeCode.String).ToString()) == false) { throw new ApplicationException(FromDateValidator.Description); } Hepsa.Core.Validation.DateRule <string> ToDateValidator = new Hepsa.Core.Validation.DateRule <string>("ToDate", "تا تاریخ", null, null); if (ToDateValidator.Validate(Hepsa.Core.Common.PersentationController.GetEntityValue(ToDatefaDatePicker.Text, TypeCode.String).ToString()) == false) { throw new ApplicationException(ToDateValidator.Description); } ///Select Company and LaderType object[] CompanyList = new object[300]; string CompanyList_nvc = string.Empty; int index = 0; CompanyList = CompanyID_intcheckedComboBox.CheckedValues; if (CompanyList != null) { foreach (object obj in CompanyList) { CompanyList_nvc = string.Format("{0},{1}", CompanyList_nvc, CompanyList[index].ToString()); index += 1; } CompanyList_nvc = CompanyList_nvc.Substring(1, CompanyList_nvc.Length - 1); } object[] LaderTypeList = new object[300]; string LaderTypeList_nvc = string.Empty; 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); } string OrderColumns_nvc = string.Empty; if (Order1ComboBox.SelectedIndex != 0) { OrderColumns_nvc = ((DataRowView)Order1ComboBox.SelectedItem)["ColumnName"].ToString(); } if (Order2ComboBox.SelectedIndex != 0) { OrderColumns_nvc += " , " + ((DataRowView)Order2ComboBox.SelectedItem)["ColumnName"].ToString(); } if (Order3ComboBox.SelectedIndex != 0) { OrderColumns_nvc += " , " + ((DataRowView)Order3ComboBox.SelectedItem)["ColumnName"].ToString(); } if (Order4ComboBox.SelectedIndex != 0) { OrderColumns_nvc += " , " + ((DataRowView)Order4ComboBox.SelectedItem)["ColumnName"].ToString(); } if (Order5ComboBox.SelectedIndex != 0) { OrderColumns_nvc += " , " + ((DataRowView)Order5ComboBox.SelectedItem)["ColumnName"].ToString(); } if (OrderColumns_nvc.EndsWith(" , ")) { OrderColumns_nvc = OrderColumns_nvc.Remove(OrderColumns_nvc.Length - 2, 2); } ///Call Report //HPS.Reports.ReportDoc.LadBillCreditReport rpt = new HPS.Reports.ReportDoc.LadBillCreditReport(this.FromDatefaDatePicker.Text, this.ToDatefaDatePicker.Text, CompanyList_nvc, LaderTypeList_nvc, OrderColumns_nvc, this.NumberPlate_nvcTextBox.Text, this.SerialPlate_nvcTextBox.Text, this.CarCardNumber_nvcTextBox.Text, this.DriverCardNumber_nvcTextBox.Text); //viewer1.Document = rpt.Document; //rpt.Document.Printer.PrinterName = string.Empty; //rpt.Run(); string condition = string.Empty; condition = "LadBillCredit_T.Date_nvc>='" + FromDatefaDatePicker.Text + "' AND LadBillCredit_T.Date_nvc<='" + ToDatefaDatePicker.Text + "' AND Canceled_bit=0 "; if (!string.IsNullOrEmpty(CompanyList_nvc)) { condition += " AND LadeAssignment_T.CompanyID_int IN ( " + CompanyList_nvc + " ) "; } if (!string.IsNullOrEmpty(LaderTypeList_nvc)) { condition += " AND Traffic_T.LaderTypeID_int IN ( " + LaderTypeList_nvc + " ) "; } if (!string.IsNullOrEmpty(NumberPlate_nvcTextBox.Text) && (!string.IsNullOrEmpty(SerialPlate_nvcTextBox.Text))) { condition += " AND Traffic_T.NumberPlate_nvc = '" + NumberPlate_nvcTextBox.Text + "' AND Traffic_T.SerialPlate_nvc =" + SerialPlate_nvcTextBox.Text; } if (!string.IsNullOrEmpty(CarCardNumber_nvcTextBox.Text)) { condition += " AND Traffic_T.CarCardNumber_nvc = " + CarCardNumber_nvcTextBox.Text; } if (!string.IsNullOrEmpty(DriverCardNumber_nvcTextBox.Text)) { condition += " AND Traffic_T.DriverCardNumber_nvc = " + DriverCardNumber_nvcTextBox.Text; } if (!string.IsNullOrEmpty(Days_intTextBox.Text)) { // تعداد روز هایی که راندگان در صف مانده اند // روز های انتظار condition += " AND datediff(day,dbo.ShamsiToMiladi(Traffic_T.Date_nvc),dbo.ShamsiToMiladi(LadBillCredit_T.Date_nvc)) <= " + Days_intTextBox.Text; } if (!string.IsNullOrEmpty(OrderColumns_nvc)) { condition += " ORDER BY " + OrderColumns_nvc; } else { condition += " ORDER BY LadBillCreditID_int "; } LadBillCreditReportstiReport.Dictionary.Synchronize(); LadBillCreditReportstiReport.Dictionary.Databases.Clear(); LadBillCreditReportstiReport.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("Connection", Hepsa.Core.Common.ConnectionString.ConnectionString)); LadBillCreditReportstiReport.Compile(); LadBillCreditReportstiReport["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(); LadBillCreditReportstiReport["FromDate_vc"] = FromDatefaDatePicker.Text; LadBillCreditReportstiReport["ToDate_vc"] = ToDatefaDatePicker.Text; LadBillCreditReportstiReport["FromTime_vc"] = FromDatefaDatePicker.Text; LadBillCreditReportstiReport["ToTime_vc"] = ToDatefaDatePicker.Text; LadBillCreditReportstiReport["Date_vc"] = PortPlaceFactory.ServerJalaliDate + " " + PortPlaceFactory.ServerTime;; LadBillCreditReportstiReport["UserName_vc"] = HPS.Common.CurrentUser.user.UserName_nvc; LadBillCreditReportstiReport["@fromdate_nvc"] = FromDatefaDatePicker.Text; LadBillCreditReportstiReport["@todate_nvc"] = ToDatefaDatePicker.Text; LadBillCreditReportstiReport["@fromtime_nvc"] = FromDatefaDatePicker.Text; LadBillCreditReportstiReport["@totime_nvc"] = ToDatefaDatePicker.Text; LadBillCreditReportstiReport["@Condition"] = condition; LadBillCreditReportstiReport.Render(); stiViewerControl1.Report = LadBillCreditReportstiReport; } catch (Exception ex) { Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message); } }
private Int32 DoCancelOperation(string Date_nvc, string LaderTypeID_nvc) { string CancelDate = string.Empty; if (string.IsNullOrEmpty(Date_nvc)) { HPS.BLL.SettingsBLL.BLLSetting_TFactory SettingFactory = new HPS.BLL.SettingsBLL.BLLSetting_TFactory(); HPS.BLL.SettingsBLL.BLLSetting_T SettingEntity = new HPS.BLL.SettingsBLL.BLLSetting_T(); HPS.BLL.SettingsBLL.BLLSetting_TKeys SettingKey = new HPS.BLL.SettingsBLL.BLLSetting_TKeys(); SettingKey.SettingID_int = 1003; SettingEntity = SettingFactory.GetBy(SettingKey); Hepsa.Core.Common.MyDateTime CurrentDate = new Hepsa.Core.Common.MyDateTime(SettingFactory.ServerJalaliDate); string CancelTime = SettingFactory.ServerTime; string CurrentDateTime = CurrentDate.MyDate.ToString("yyyy/MM/dd") + " " + CancelTime; DateTime SubtractedDate = DateTime.Parse(CurrentDateTime); SubtractedDate = SubtractedDate.AddHours(-Int32.Parse(SettingEntity.Value_nvc)); CancelDate = new Hepsa.Core.Common.MyDateTime(SubtractedDate).ConvertToPersianShortDate(); } else { CancelDate = Date_nvc; } HPS.BLL.TurnCancelCommentBLL.BLLTurnCancelComment_TFactory TurnCancelCommentFactory = new HPS.BLL.TurnCancelCommentBLL.BLLTurnCancelComment_TFactory(); HPS.BLL.TurnCancelCommentBLL.BLLTurnCancelComment_T TurnCancelCommentEntity = new HPS.BLL.TurnCancelCommentBLL.BLLTurnCancelComment_T(); HPS.BLL.TurnCancelCommentBLL.BLLTurnCancelComment_TKeys TurnCancelCommentKey = new HPS.BLL.TurnCancelCommentBLL.BLLTurnCancelComment_TKeys(); TurnCancelCommentKey.TurnCancelCommentID_int = 40; TurnCancelCommentEntity = TurnCancelCommentFactory.GetBy(TurnCancelCommentKey); HPS.BLL.TurnManagementBLL.BLLTurnManagement_TFactory TurnManagementFactory = new HPS.BLL.TurnManagementBLL.BLLTurnManagement_TFactory(); HPS.BLL.TrafficBLL.BLLTraffic_TFactory TrafficFactory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory(); DataTable AcceptedTurnsWithoutLadBillDataTable = new DataTable(); if (string.IsNullOrEmpty(LaderTypeID_nvc)) { TrafficFactory.SelectInTurnAcceptedForDelete(CancelDate, string.Empty, AcceptedTurnsWithoutLadBillDataTable); } else { TrafficFactory.SelectInTurnAcceptedForDelete(CancelDate, LaderTypeID_nvc, AcceptedTurnsWithoutLadBillDataTable); } int rowcount = -1; if (AcceptedTurnsWithoutLadBillDataTable != null && AcceptedTurnsWithoutLadBillDataTable.Rows.Count > 0) { rowcount = AcceptedTurnsWithoutLadBillDataTable.Rows.Count; foreach (DataRow row in AcceptedTurnsWithoutLadBillDataTable.Rows) { HPS.BLL.TurnManagementBLL.BLLTurnManagement_T TurnManagementEntity = new HPS.BLL.TurnManagementBLL.BLLTurnManagement_T(); TurnManagementEntity.TurnCancelCommantID_int = TurnCancelCommentEntity.TurnCancelCommentID_int; TurnManagementEntity.TurnCancelCommment_nvc = TurnCancelCommentEntity.TurnCancelComment_nvc; TurnManagementEntity.Return_bit = false; TurnManagementEntity.Date_nvc = TurnManagementFactory.ServerJalaliDate; TurnManagementEntity.Time_nvc = TurnManagementFactory.ServerTime; TurnManagementEntity.UserName_nvc = HPS.Common.CurrentUser.user.UserName_nvc; TurnManagementEntity.TrafficID_bint = Convert.ToInt64(row["TrafficID_bint"]); TurnManagementFactory.BeginProc(); TurnManagementFactory.Insert(TurnManagementEntity); TurnManagementFactory.CommitProc(); } } return(rowcount); }
private void PrintButton_Click(object sender, EventArgs e) { try { bool isCanceldedLadBill = (bool)LadBillWithTrafficGridView.CurrentRow.Cells["colCanceled_bit"].Value; //if (WithProductionYear == true && !FromDatefaDatePicker.IsNull && !ToDatefaDatePicker.IsNull) //{ if (isCanceldedLadBill && HPS.Common.CurrentUser.user.UserGroupID_int != 1) { throw new ApplicationException("این مجوز باطل شده و امکان چاپ ندارد"); } HPS.BLL.LadBillCreditBLL.BLLLadBillCredit_TFactory LadBillFactory = new HPS.BLL.LadBillCreditBLL.BLLLadBillCredit_TFactory(); string condition = string.Empty; if (!string.IsNullOrEmpty(ToDatefaDatePicker.Text) && !string.IsNullOrEmpty(FromDatefaDatePicker.Text)) { condition = string.Format(" LadBillCredit_T.Date_nvc>='{0}' And LadBillCredit_T.Date_nvc<='{1}'", FromDatefaDatePicker.Text, ToDatefaDatePicker.Text); } if (!string.IsNullOrEmpty(LadBillCrediteID_binttextBox.Text)) { condition += string.Format(" OR LadBillCredit_T.LadBillCreditID_int='{0}'", LadBillCrediteID_binttextBox.Text); } if (!string.IsNullOrEmpty(AcceptedTurnNumber_binttextBox.Text)) { condition += string.Format(" OR Traffic_T.AcceptedTurnNumber_bint='{0}'", AcceptedTurnNumber_binttextBox.Text); } if (!string.IsNullOrEmpty(DriverCardNumber_nvctextBox.Text)) { condition += string.Format(" OR Driver_T.DriverCardNumber_nvc='{0}'", DriverCardNumber_nvctextBox.Text); } if (!string.IsNullOrEmpty(NationalCode_inttextBox.Text)) { condition += string.Format(" OR Driver_T.NationalCode_int='{0}'", NationalCode_inttextBox.Text); } if (!string.IsNullOrEmpty(DriverLastName_nvctextBox.Text)) { condition += string.Format(" OR Driver_T.LastName_nvc='{0}'", DriverLastName_nvctextBox.Text); } if (!string.IsNullOrEmpty(CarSerialnumbertextBox.Text) && !string.IsNullOrEmpty(NumberPlate_nvctextBox.Text)) { condition += string.Format(" OR Car_T.NumberPlate_nvc='{0}' And Car_T.SerialPlate_nvc = '{1}'", NumberPlate_nvctextBox.Text, CarSerialnumbertextBox.Text); } LadBillCreditReportstiReport.Dictionary.Synchronize(); LadBillCreditReportstiReport.Dictionary.Databases.Clear(); LadBillCreditReportstiReport.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("Connection", Hepsa.Core.Common.ConnectionString.ConnectionString)); LadBillCreditReportstiReport.Compile(); HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory PortPlaceFactory = new HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory(); LadBillCreditReportstiReport["organ"] = new HPS.BLL.SettingsBLL.BLLSetting_TFactory().GetBy(new BLL.SettingsBLL.BLLSetting_TKeys() { SettingID_int = 1029 }).Value_nvc.ToString(); LadBillCreditReportstiReport["FromDate_vc"] = FromDatefaDatePicker.Text; LadBillCreditReportstiReport["ToDate_vc"] = ToDatefaDatePicker.Text; LadBillCreditReportstiReport["FromTime_vc"] = FromDatefaDatePicker.Text; LadBillCreditReportstiReport["ToTime_vc"] = ToDatefaDatePicker.Text; LadBillCreditReportstiReport["Date_vc"] = PortPlaceFactory.ServerJalaliDate + " " + PortPlaceFactory.ServerTime;; LadBillCreditReportstiReport["UserName_vc"] = HPS.Common.CurrentUser.user.UserName_nvc; LadBillCreditReportstiReport["@fromdate_nvc"] = FromDatefaDatePicker.Text; LadBillCreditReportstiReport["@todate_nvc"] = ToDatefaDatePicker.Text; LadBillCreditReportstiReport["@fromtime_nvc"] = FromDatefaDatePicker.Text; LadBillCreditReportstiReport["@totime_nvc"] = ToDatefaDatePicker.Text; LadBillCreditReportstiReport["@Condition"] = condition; LadBillCreditReportstiReport.Render(); LadBillWithTrafficGridView.Visible = false; stiViewerControl1.Visible = true; stiViewerControl1.Report = LadBillCreditReportstiReport; //} //else //{ // HPS.Reports.Forms.LadBillCreditReporForm frm = new LadBillCreditReporForm(); // frm.ShowDialog(); //} } 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 Sendbutton_Click(object sender, EventArgs e) { DataTable SelectedDriver = new DataTable(); SelectedDriver = (DataTable)this.DriversdataGridView.DataSource; if (SelectedDriver != null) { DataRow[] DriverRow = SelectedDriver.Select("Checked_bit = 'True'"); if (DriverRow != null && DriverRow.Length > 0) { HPS.Present.SMS.LogintoSmsSystemForm frm = new LogintoSmsSystemForm(); frm.ShowDialog(); if (frm.True_bit) { System.IO.FileStream source = new System.IO.FileStream(@"index.html", System.IO.FileMode.Open, System.IO.FileAccess.Read); WebBrowser webBrowser1 = new WebBrowser(); webBrowser1.DocumentStream = source; string sourceText = string.Empty; using (StreamReader sourceReader = new StreamReader(source)) { sourceText = sourceReader.ReadToEnd(); } String Pass = string.Empty; string UserName = string.Empty; HPS.BLL.SettingsBLL.BLLSetting_TFactory SettingFactory = new HPS.BLL.SettingsBLL.BLLSetting_TFactory(); HPS.BLL.SettingsBLL.BLLSetting_TKeys SettingKey = new HPS.BLL.SettingsBLL.BLLSetting_TKeys(); HPS.BLL.SettingsBLL.BLLSetting_T SettingEntity = new HPS.BLL.SettingsBLL.BLLSetting_T(); SettingKey.SettingID_int = 1005; SettingEntity = SettingFactory.GetBy(SettingKey); UserName = SettingEntity.Value_nvc; SettingKey.SettingID_int = 1006; SettingEntity = SettingFactory.GetBy(SettingKey); Pass = SettingEntity.Value_nvc; sourceText = string.Format(sourceText, UserName, Pass); webBrowser1.Document.Write(sourceText); var htmlElements = webBrowser1.Document.GetElementById("btnSubmit"); hdoc = webBrowser1.Document; StringBuilder MessegeText = new StringBuilder(); string MobileList; MobileList = string.Empty; foreach (DataRow rw in DriverRow) { MobileList = string.Format("{0},{1}", MobileList, rw["DriverMobileNumber_nvc"].ToString()); } if (MobileList.Length > 0) { if (MobileList.Substring(0, 1) == ",") { MobileList = MobileList.Substring(1, MobileList.Length - 1); } } DataTable SelectedNews = new DataTable(); SelectedNews = (DataTable)this.NewsdataGridView.DataSource; DataRow[] NewsRow = SelectedNews.Select("Checked_bit = 'True'"); foreach (DataRow rw in NewsRow) { MessegeText.AppendLine(String.Format("{0}:{1}", rw["Title_nvc"].ToString(), rw["News_nvc"].ToString())); } hdoc.GetElementById("mobilenumber").SetAttribute("value", MobileList); hdoc.GetElementById("message").SetAttribute("value", MessegeText.ToString()); hdoc.GetElementById("btnSubmit").InvokeMember("click"); } else { return; } } else { Hepsa.Core.Common.MessageBox.ErrorMessage(HPS.Exceptions.ExceptionCs.DriverIsNotChosen); } } }
private void ShowButton_Click(object sender, EventArgs e) { HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory PortPlaceFactory = new HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory(); if (_TrafficType == 1) { //IranianOutTrafiicstiReport string Turn = string.Empty; ////////////// //HPS.Reports.ReportDoc.IranianOutTrafficReport rpt = new HPS.Reports.ReportDoc.IranianOutTrafficReport(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(); IranianOutTrafiicstiReport.Dictionary.Synchronize(); IranianOutTrafiicstiReport.Dictionary.Databases.Clear(); IranianOutTrafiicstiReport.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("Connection", Hepsa.Core.Common.ConnectionString.ConnectionString)); IranianOutTrafiicstiReport.Compile(); IranianOutTrafiicstiReport["organ"] = new HPS.BLL.SettingsBLL.BLLSetting_TFactory().GetBy(new BLL.SettingsBLL.BLLSetting_TKeys() { SettingID_int = 1029 }).Value_nvc.ToString(); IranianOutTrafiicstiReport["fromdate_vc"] = FromDatefaDatePicker.Text; IranianOutTrafiicstiReport["todate_vc"] = ToDatefaDatePicker.Text; IranianOutTrafiicstiReport["date_vc"] = PortPlaceFactory.ServerJalaliDate + " " + PortPlaceFactory.ServerTime;; IranianOutTrafiicstiReport["UserName_vc"] = HPS.Common.CurrentUser.user.UserName_nvc; IranianOutTrafiicstiReport["fromTrafficNumber"] = FromTrafficNumbertxt.Text; IranianOutTrafiicstiReport["toTrafficNumber"] = ToTrafficNumbertxt.Text; IranianOutTrafiicstiReport["FromTime_vc"] = FromTimeTextBox.Text; IranianOutTrafiicstiReport["ToTime_vc"] = ToTimeTextBox.Text; if (string.IsNullOrEmpty(FromDatefaDatePicker.Text)) { IranianOutTrafiicstiReport["@FromDateTime_nvc"] = DBNull.Value; } else { IranianOutTrafiicstiReport["@FromDateTime_nvc"] = FromDatefaDatePicker.Text + ' ' + FromTimeTextBox.Text; } if (string.IsNullOrEmpty(ToDatefaDatePicker.Text)) { IranianOutTrafiicstiReport["@ToDateTime_nvc"] = DBNull.Value; } else { IranianOutTrafiicstiReport["@ToDateTime_nvc"] = ToDatefaDatePicker.Text + ' ' + ToTimeTextBox.Text; } if (string.IsNullOrEmpty(FromTrafficNumbertxt.Text)) { IranianOutTrafiicstiReport["@FromTrafficNumber_nvc"] = DBNull.Value; } else { IranianOutTrafiicstiReport["@FromTrafficNumber_nvc"] = FromTrafficNumbertxt.Text; } if (string.IsNullOrEmpty(ToTrafficNumbertxt.Text)) { IranianOutTrafiicstiReport["@ToTrafficNumber_nvc"] = DBNull.Value; } else { IranianOutTrafiicstiReport["@ToTrafficNumber_nvc"] = ToTrafficNumbertxt.Text; } if (LaderPivotGroupID_intComboBox.SelectedValue == null) { IranianOutTrafiicstiReport["@LaderPivotGroupID_nvc"] = DBNull.Value; } else { IranianOutTrafiicstiReport["@LaderPivotGroupID_nvc"] = LaderPivotGroupID_intComboBox.SelectedValue; } if (LaderTypeID_intComboBox.SelectedValue == null) { IranianOutTrafiicstiReport["@LaderTypeID_nvc"] = DBNull.Value; } else { IranianOutTrafiicstiReport["@LaderTypeID_nvc"] = LaderTypeID_intComboBox.SelectedValue; } if (ServicescomboBox.SelectedValue == null) { IranianOutTrafiicstiReport["@ServiceID_nvc"] = DBNull.Value; } else { IranianOutTrafiicstiReport["@ServiceID_nvc"] = ServicescomboBox.SelectedValue; } IranianOutTrafiicstiReport["@TrafficTypeID_nvc"] = 1; IranianOutTrafiicstiReport["@TrafficInbit_nvc"] = DBNull.Value; IranianOutTrafiicstiReport["@TrafficOutbit_nvc"] = 1; IranianOutTrafiicstiReport["@TurnAccepted_nvc"] = Turn; if (LaderPivotGroupID_intComboBox.SelectedValue != null) { if (Convert.ToInt32(LaderPivotGroupID_intComboBox.SelectedValue) == 1) { IranianOutTrafiicstiReport["LaderTypeHeadertxt"] = "(دو محور)"; } else if (Convert.ToInt32(LaderPivotGroupID_intComboBox.SelectedValue) == 2) { IranianOutTrafiicstiReport["LaderTypeHeadertxt"] = "(سه محور به بالا)"; } } else { IranianOutTrafiicstiReport["LaderTypeHeadertxt"] = "(تمامی کامیون ها)"; } if (LaderTypeID_intComboBox.SelectedValue != null) { IranianOutTrafiicstiReport["LaderTypeHeadertxt"] = (string)Hepsa.Core.Common.PersentationController.GetComboBoxDisplayMember(this.LaderTypeID_intComboBox); } IranianOutTrafiicstiReport.Render(); this.stiViewerControl1.Report = IranianOutTrafiicstiReport; } if (_TrafficType == 2) { //HPS.Reports.ReportDoc.ForeignOutTrafficReport rpt = new HPS.Reports.ReportDoc.ForeignOutTrafficReport(FromDatefaDatePicker.Text, ToDatefaDatePicker.Text, FromTimeTextBox.Text, ToTimeTextBox.Text, FromTrafficNumbertxt.Text, ToTrafficNumbertxt.Text); //rpt.Document.Printer.PrinterName = string.Empty; //viewer1.Document = rpt.Document; //rpt.Run(); 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(FromTrafficNumbertxt.Text) && string.IsNullOrEmpty(ToTrafficNumbertxt.Text)) && (string.IsNullOrEmpty(FromTimeTextBox.Text) && string.IsNullOrEmpty(ToTime))) { Condition = "(T.In_bit='False') 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='False') 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='False') 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='False') 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 + "')"; } ForeignOutTrafficstiReport.Dictionary.Synchronize(); ForeignOutTrafficstiReport.Dictionary.Databases.Clear(); ForeignOutTrafficstiReport.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("Connection", Hepsa.Core.Common.ConnectionString.ConnectionString)); ForeignOutTrafficstiReport.Compile(); ForeignOutTrafficstiReport["organ"] = new HPS.BLL.SettingsBLL.BLLSetting_TFactory().GetBy(new BLL.SettingsBLL.BLLSetting_TKeys() { SettingID_int = 1029 }).Value_nvc.ToString(); ForeignOutTrafficstiReport["fromdate_vc"] = FromDatefaDatePicker.Text; ForeignOutTrafficstiReport["todate_vc"] = ToDatefaDatePicker.Text; ForeignOutTrafficstiReport["date_vc"] = PortPlaceFactory.ServerJalaliDate + " " + PortPlaceFactory.ServerTime;; ForeignOutTrafficstiReport["UserName_vc"] = HPS.Common.CurrentUser.user.UserName_nvc; ForeignOutTrafficstiReport["fromTrafficNumber"] = FromTrafficNumbertxt.Text; ForeignOutTrafficstiReport["toTrafficNumber"] = ToTrafficNumbertxt.Text; ForeignOutTrafficstiReport["FromTime_vc"] = FromTimeTextBox.Text; ForeignOutTrafficstiReport["ToTime_vc"] = ToTimeTextBox.Text; ForeignOutTrafficstiReport["@Condition"] = Condition; ForeignOutTrafficstiReport.Render(); this.stiViewerControl1.Report = ForeignOutTrafficstiReport; } if (_TrafficType == 0) { // HPS.Reports.ReportDoc.OtherOutReport rpt = new HPS.Reports.ReportDoc.OtherOutReport(FromDatefaDatePicker.Text, ToDatefaDatePicker.Text, FromTimeTextBox.Text, ToTimeTextBox.Text, FromTrafficNumbertxt.Text, ToTrafficNumbertxt.Text); // rpt.Document.Printer.PrinterName = string.Empty; // viewer1.Document = rpt.Document; // rpt.Run(); 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='False') AND (T.TrafficTypeID_int<>'1') 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='False') AND (T.TrafficTypeID_int<>'1') 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='False') AND (T.TrafficTypeID_int<>'1') 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='False') AND (T.TrafficTypeID_int<>'1') 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 + "')"; //} if (!(string.IsNullOrEmpty(FromTrafficNumber) && string.IsNullOrEmpty(ToTrafficNumber)) && (string.IsNullOrEmpty(FromTime) && string.IsNullOrEmpty(ToTime))) { Condition = "(T.In_bit='False') AND (T.TrafficTypeID_int<>'1') 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='False') AND (T.TrafficTypeID_int<>'1') 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='False') AND (T.TrafficTypeID_int<>'1') 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='False') AND (T.TrafficTypeID_int<>'1') 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 + "')"; } OtherOutTrafficStiReport.Dictionary.Synchronize(); OtherOutTrafficStiReport.Dictionary.Databases.Clear(); OtherOutTrafficStiReport.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("Connection", Hepsa.Core.Common.ConnectionString.ConnectionString)); OtherOutTrafficStiReport.Compile(); OtherOutTrafficStiReport["organ"] = new HPS.BLL.SettingsBLL.BLLSetting_TFactory().GetBy(new BLL.SettingsBLL.BLLSetting_TKeys() { SettingID_int = 1029 }).Value_nvc.ToString(); OtherOutTrafficStiReport["fromdate_vc"] = FromDatefaDatePicker.Text; OtherOutTrafficStiReport["todate_vc"] = ToDatefaDatePicker.Text; OtherOutTrafficStiReport["date_vc"] = PortPlaceFactory.ServerJalaliDate + " " + PortPlaceFactory.ServerTime;; OtherOutTrafficStiReport["UserName_vc"] = HPS.Common.CurrentUser.user.UserName_nvc; OtherOutTrafficStiReport["fromTrafficNumber"] = FromTrafficNumbertxt.Text; OtherOutTrafficStiReport["toTrafficNumber"] = ToTrafficNumbertxt.Text; OtherOutTrafficStiReport["FromTime_vc"] = FromTimeTextBox.Text; OtherOutTrafficStiReport["ToTime_vc"] = ToTimeTextBox.Text; OtherOutTrafficStiReport["@Condition"] = Condition; OtherOutTrafficStiReport.Render(); this.stiViewerControl1.Report = OtherOutTrafficStiReport; } }
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) { 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 StimulViewer_Load(object sender, EventArgs e) { //try //{ if (_Traffic_bit == false && _Othercar_bit == false) { AcceptedTurnstiReport.Dictionary.Synchronize(); AcceptedTurnstiReport.Dictionary.Databases.Clear(); AcceptedTurnstiReport.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("Connection", Hepsa.Core.Common.ConnectionString.ConnectionString)); AcceptedTurnstiReport.Compile(); AcceptedTurnstiReport["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(); HPS.BLL.BillMessageBLL.BLLBillMessage_TFactory BillFactory = new HPS.BLL.BillMessageBLL.BLLBillMessage_TFactory(); if (TrafficEntity.BillMessageID_int == 0 || TrafficEntity.BillMessageID_int == null) { } else { string Billcondition = "[BillMessage_T].[BillMessageID_int]=" + TrafficEntity.BillMessageID_int; List <HPS.BLL.BillMessageBLL.BLLBillMessage_T> BillLst = BillFactory.GetAllByCondition(Billcondition); if (BillLst != null) { AcceptedTurnstiReport["Messagetxt"] = BillLst[0].Message_nvc; AcceptedTurnstiReport["Message_bit"] = true; } else { AcceptedTurnstiReport["Message_bit"] = false; } } NumericTextBox txt = new NumericTextBox(); txt.DigitsInGroup = 3; if (TrafficEntity.Price_dec != null) { txt.Text = TrafficEntity.Price_dec.ToString(); AcceptedTurnstiReport["Price_nvc"] = " مبلغ دریافت شده هنگام ورود " + txt.Text + " ريال می باشد"; } if (TrafficEntity.Price_dec != null) { AcceptedTurnstiReport["PricewithOutTax_nvc"] = (TrafficEntity.Price_dec - TrafficEntity.PriceTax_dec).ToString(); } if (!string.IsNullOrEmpty(TrafficEntity.AcceptedTurnComment_nvc)) { if (TrafficEntity.Area_bit) { AcceptedTurnstiReport["Comment_nvc"] = "توضيحات : " + TrafficEntity.AcceptedTurnComment_nvc;// +" حومه"; } else { AcceptedTurnstiReport["Comment_nvc"] = "توضيحات : " + TrafficEntity.AcceptedTurnComment_nvc; } } else { //if (TrafficEntity.Area_bit) //{ // AcceptedTurnstiReport["Comment_nvc"] = "حومه"; //} } if (TrafficEntity.TurnPrinted_bit == true) { AcceptedTurnstiReport["PrintedAgain_nvc"] = "المثنی"; } else { AcceptedTurnstiReport["PrintedAgain_nvc"] = ""; } HPS.BLL.PlateCityBLL.BLLPlateCity_TFactory PlatecityFactory = new HPS.BLL.PlateCityBLL.BLLPlateCity_TFactory(); HPS.BLL.PlateCityBLL.BLLPlateCity_TKeys Platecitykey = new HPS.BLL.PlateCityBLL.BLLPlateCity_TKeys(); Platecitykey.PlateCityID_int = TrafficEntity.PlateCityID_int; HPS.BLL.PlateCityBLL.BLLPlateCity_T PlateCityEntity = new HPS.BLL.PlateCityBLL.BLLPlateCity_T(); PlateCityEntity = PlatecityFactory.GetBy(Platecitykey); if (PlateCityEntity != null) { AcceptedTurnstiReport["Number_nvc"] = "شماره پلاک : " + Hepsa.Core.Common.PersentationController.CorrectNumberPlate(TrafficEntity.NumberPlate_nvc) + " - " + PlateCityEntity.PlateCity_nvc + " " + TrafficEntity.SerialPlate_nvc; } else { AcceptedTurnstiReport["Number_nvc"] = "شماره پلاک : " + Hepsa.Core.Common.PersentationController.CorrectNumberPlate(TrafficEntity.NumberPlate_nvc) + " - " + TrafficEntity.SerialPlate_nvc; } if (TrafficEntity.LadeReturn_bit == true) { AcceptedTurnstiReport["TurnNumber"] = "برگشت از بار"; } else { if (TrafficEntity.AcceptedTurnNumber_bint.HasValue) { AcceptedTurnstiReport["TurnNumber"] = "شماره نوبت : " + TrafficEntity.AcceptedTurnNumber_bint.ToString(); } else { AcceptedTurnstiReport["TurnNumber"] = "شماره نوبت رزرو : " + TrafficEntity.TurnNumber_bint.ToString(); } } AcceptedTurnstiReport["TrafficNumber"] = " شماره قبض پارکینگ: " + TrafficEntity.TrafficNumber_bint.ToString(); AcceptedTurnstiReport["InDate_vc"] = TrafficEntity.Date_nvc; AcceptedTurnstiReport["InTime_vc"] = TrafficEntity.Time_nvc; AcceptedTurnstiReport["Time_vc"] = PortPlaceFactory.ServerTime; AcceptedTurnstiReport["Date_vc"] = PortPlaceFactory.ServerJalaliDate; AcceptedTurnstiReport["username_nvc"] = HPS.Common.CurrentUser.user.UserName_nvc; HPS.BLL.LaderTypeBLL.BLLLaderType_TFactory laderTypeFactory = new HPS.BLL.LaderTypeBLL.BLLLaderType_TFactory(); string LaderTypecondition = "[LaderType_T].[LaderTypeID_int]='" + TrafficEntity.LaderTypeID_int + "'"; AcceptedTurnstiReport["@TrafficID_bint"] = TrafficEntity.TrafficID_bint; AcceptedTurnstiReport["@Condition"] = LaderTypecondition; AcceptedTurnstiReport.Render(); Properties.Settings s = new HPS.Properties.Settings(); System.Drawing.Printing.PrinterSettings PrinterSetting = new System.Drawing.Printing.PrinterSettings(); if (string.IsNullOrEmpty(s.PrinterName)) { AcceptedTurnstiReport.Print(true); } else { PrinterSetting.PrinterName = s.PrinterName; AcceptedTurnstiReport.Print(false, PrinterSetting); } this.Close(); } else if (_Traffic_bit == true && _Othercar_bit == false) { TrafficstiReport.Dictionary.Synchronize(); TrafficstiReport.Dictionary.Databases.Clear(); TrafficstiReport.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("Connection", Hepsa.Core.Common.ConnectionString.ConnectionString)); TrafficstiReport.Compile(); TrafficstiReport["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(); HPS.BLL.BillMessageBLL.BLLBillMessage_TFactory BillFactory = new HPS.BLL.BillMessageBLL.BLLBillMessage_TFactory(); if (TrafficEntity.BillMessageID_int == 0 || TrafficEntity.BillMessageID_int == null) { } else { string Billcondition = "[BillMessage_T].[BillMessageID_int]=" + TrafficEntity.BillMessageID_int; List <HPS.BLL.BillMessageBLL.BLLBillMessage_T> BillLst = BillFactory.GetAllByCondition(Billcondition); if (BillLst != null) { TrafficstiReport["Messagetxt"] = BillLst[0].Message_nvc; TrafficstiReport["Message_bit"] = true; } else { TrafficstiReport["Message_bit"] = false; } } NumericTextBox txt = new NumericTextBox(); txt.DigitsInGroup = 3; if (TrafficEntity.Price_dec != null) { txt.Text = TrafficEntity.Price_dec.ToString(); TrafficstiReport["Price_nvc"] = " مبلغ دریافت شده هنگام ورود " + txt.Text + " ريال می باشد"; } if (!string.IsNullOrEmpty(TrafficEntity.AcceptedTurnComment_nvc)) { if (TrafficEntity.Area_bit) { TrafficstiReport["Comment_nvc"] = "توضيحات : " + TrafficEntity.AcceptedTurnComment_nvc;// +" حومه"; } else { TrafficstiReport["Comment_nvc"] = "توضيحات : " + TrafficEntity.AcceptedTurnComment_nvc; } } else { //if (TrafficEntity.Area_bit) //{ // TrafficstiReport["Comment_nvc"] = "حومه"; //} } if (TrafficEntity.TurnPrinted_bit == true) { TrafficstiReport["PrintedAgain_nvc"] = "المثنی"; } else { TrafficstiReport["PrintedAgain_nvc"] = ""; } HPS.BLL.PlateCityBLL.BLLPlateCity_TFactory PlatecityFactory = new HPS.BLL.PlateCityBLL.BLLPlateCity_TFactory(); HPS.BLL.PlateCityBLL.BLLPlateCity_TKeys Platecitykey = new HPS.BLL.PlateCityBLL.BLLPlateCity_TKeys(); Platecitykey.PlateCityID_int = TrafficEntity.PlateCityID_int; HPS.BLL.PlateCityBLL.BLLPlateCity_T PlateCityEntity = new HPS.BLL.PlateCityBLL.BLLPlateCity_T(); PlateCityEntity = PlatecityFactory.GetBy(Platecitykey); if (PlateCityEntity != null) { TrafficstiReport["Number_nvc"] = "شماره پلاک : " + Hepsa.Core.Common.PersentationController.CorrectNumberPlate(TrafficEntity.NumberPlate_nvc) + " - " + PlateCityEntity.PlateCity_nvc + " " + TrafficEntity.SerialPlate_nvc; } else { TrafficstiReport["Number_nvc"] = "شماره پلاک : " + Hepsa.Core.Common.PersentationController.CorrectNumberPlate(TrafficEntity.NumberPlate_nvc) + " - " + TrafficEntity.SerialPlate_nvc; } if (TrafficEntity.ServiceID_int == 2) { if (TrafficEntity.TurnAccepted_bit == true) { //نوبت تأیید شده داره TrafficstiReport["TurnNumber"] = "شماره نوبت : " + Convert.ToString(TrafficEntity.AcceptedTurnNumber_bint); //AcceptedDate2TextBox.Text = TrafficEntityrpt.TurnDate_nvc; //AcceptedTime2TextBox.Text = TrafficEntityrpt.TurnTime_nvc; //TurnNumber2txt.Text = TrafficEntityrpt.AcceptedTurnNumber_bint.ToString(); } else { //نوبت تأیید شده ندارد TrafficstiReport["TurnNumber"] = "شماره نوبت رزرو : " + Convert.ToString(TrafficEntity.TurnNumber_bint); } } else { // (عدم نمایش نوبت (مراجعه به غیر از نوبت TrafficstiReport["TurnNumber"] = ""; } TrafficstiReport["TrafficNumber"] = "شماره قبض پارکینگ : " + TrafficEntity.TrafficNumber_bint.ToString(); HPS.BLL.SettingsBLL.BLLSetting_TFactory settingsFactory = new HPS.BLL.SettingsBLL.BLLSetting_TFactory(); HPS.BLL.SettingsBLL.BLLSetting_T SettingEntity = new HPS.BLL.SettingsBLL.BLLSetting_T(); HPS.BLL.SettingsBLL.BLLSetting_TKeys SettingKey = new HPS.BLL.SettingsBLL.BLLSetting_TKeys(); SettingKey.SettingID_int = 1002; SettingEntity = settingsFactory.GetBy(SettingKey); if (TrafficEntity.ServiceID_int == 2) { TrafficstiReport["TAllowableHour"] = SettingEntity.Value_nvc; //TrafficEntityrpt.AllowableHour_int.ToString(); } else { TrafficstiReport["TAllowableHour"] = TrafficEntity.AllowableHour_int.ToString(); } HPS.BLL.ServicesBLL.BLLServices_TFactory servicesFactory = new HPS.BLL.ServicesBLL.BLLServices_TFactory(); HPS.BLL.ServicesBLL.BLLServices_TKeys ServicesKey = new HPS.BLL.ServicesBLL.BLLServices_TKeys(); ServicesKey.ServicesID_int = TrafficEntity.ServiceID_int; HPS.BLL.ServicesBLL.BLLServices_T ServicesEntity = new HPS.BLL.ServicesBLL.BLLServices_T(); ServicesEntity = servicesFactory.GetBy(ServicesKey); TrafficstiReport["system_nvc"] = " قبض مراجعه به : " + ServicesEntity.ServicesType_nvc; if (TrafficEntity.WithLade_bit == true) { TrafficstiReport["WithLade_nvc"] = "وضعیت : " + "با بار" + "(" + TrafficEntity.Comment_nvc + ") "; } else { TrafficstiReport["WithLade_nvc"] = "وضعیت : " + "بدون بار"; } if (TrafficEntity.TurnHour_int != null) { TrafficstiReport["TurnNumberAllert_nvc"] = " شماره نوبت شما رزرو می باشد لطفاً تا " + TrafficEntity.TurnHour_int.ToString() + " ساعت نسبت به تأیید آن اقدام نمایید"; } TrafficstiReport["InDate_vc"] = TrafficEntity.Date_nvc; TrafficstiReport["InTime_vc"] = TrafficEntity.Time_nvc; TrafficstiReport["Time_vc"] = PortPlaceFactory.ServerTime; TrafficstiReport["Date_vc"] = PortPlaceFactory.ServerJalaliDate; TrafficstiReport["username_nvc"] = HPS.Common.CurrentUser.user.UserName_nvc; HPS.BLL.LaderTypeBLL.BLLLaderType_TFactory laderTypeFactory = new HPS.BLL.LaderTypeBLL.BLLLaderType_TFactory(); string LaderTypecondition = "[LaderType_T].[LaderTypeID_int]='" + TrafficEntity.LaderTypeID_int + "'"; TrafficstiReport["@TrafficID_bint"] = TrafficEntity.TrafficID_bint; TrafficstiReport["@Condition"] = LaderTypecondition; TrafficstiReport.Render(); Properties.Settings s = new HPS.Properties.Settings(); System.Drawing.Printing.PrinterSettings PrinterSetting = new System.Drawing.Printing.PrinterSettings(); if (string.IsNullOrEmpty(s.PrinterName)) { TrafficstiReport.Print(true); } else { PrinterSetting.PrinterName = s.PrinterName; TrafficstiReport.Print(false, PrinterSetting); } this.Close(); } //سواری وغیره else if (_Traffic_bit == false && _Othercar_bit == true) { //HPS.BLL.TrafficBLL.BLLTraffic_T TrafficEntityrpt = new HPS.BLL.TrafficBLL.BLLTraffic_T(); OtherCarstiReport.Dictionary.Synchronize(); OtherCarstiReport.Dictionary.Databases.Clear(); OtherCarstiReport.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("Connection", Hepsa.Core.Common.ConnectionString.ConnectionString)); OtherCarstiReport.Compile(); OtherCarstiReport["organ"] = new HPS.BLL.SettingsBLL.BLLSetting_TFactory().GetBy(new BLL.SettingsBLL.BLLSetting_TKeys() { SettingID_int = 1029 }).Value_nvc.ToString(); OtherCarstiReport["DateTextBox"] = TrafficEntity.Date_nvc; OtherCarstiReport["TimeTextBox"] = TrafficEntity.Time_nvc; OtherCarstiReport["TrafficNumbertxt"] = TrafficEntity.TrafficNumber_bint.ToString(); OtherCarstiReport["Servicestxt"] = " مراجعه به : " + TrafficEntity.Services_nvc; OtherCarstiReport["CarTypetxt"] = "نوع وسیله : " + TrafficEntity.System_nvc; HPS.BLL.PlateCityBLL.BLLPlateCity_TFactory PlateCityFactory = new HPS.BLL.PlateCityBLL.BLLPlateCity_TFactory(); HPS.BLL.PlateCityBLL.BLLPlateCity_T PlatecityEntity = new HPS.BLL.PlateCityBLL.BLLPlateCity_T(); HPS.BLL.PlateCityBLL.BLLPlateCity_TKeys PlateCityKey = new HPS.BLL.PlateCityBLL.BLLPlateCity_TKeys(); PlateCityKey.PlateCityID_int = TrafficEntity.PlateCityID_int; PlatecityEntity = PlateCityFactory.GetBy(PlateCityKey); OtherCarstiReport["NumberPlatetxt"] = "شماره پلاک : " + Hepsa.Core.Common.PersentationController.CorrectNumberPlate(TrafficEntity.NumberPlate_nvc) + " - " + PlatecityEntity.PlateCity_nvc + " " + TrafficEntity.SerialPlate_nvc; HPS.BLL.BillMessageBLL.BLLBillMessage_TFactory BillFactory = new HPS.BLL.BillMessageBLL.BLLBillMessage_TFactory(); if (TrafficEntity.BillMessageID_int == 0 || TrafficEntity.BillMessageID_int == null) { OtherCarstiReport["Messagetxt"] = ""; } else { string Billcondition = "[BillMessage_T].[BillMessageID_int]=" + TrafficEntity.BillMessageID_int; List <HPS.BLL.BillMessageBLL.BLLBillMessage_T> BillLst = BillFactory.GetAllByCondition(Billcondition); if (BillLst != null) { OtherCarstiReport["Messagetxt"] = BillLst[0].Message_nvc; } else { OtherCarstiReport["Messagetxt"] = ""; } } NumericTextBox txt = new NumericTextBox(); txt.DigitsInGroup = 3; if (TrafficEntity.Price_dec != null) { txt.Text = TrafficEntity.Price_dec.ToString(); OtherCarstiReport["Pricetxt"] = " مبلغ دریافتی هنگام ورود " + txt.Text + " ريال می باشد"; } OtherCarstiReport["AllowableHourtxt"] = TrafficEntity.AllowableHour_int.ToString(); OtherCarstiReport["ExtraHourtxt"] = TrafficEntity.ExtraHour_int.ToString(); txt.Text = TrafficEntity.Fee_dec.ToString(); OtherCarstiReport["Feetxt"] = txt.Text; txt.Text = TrafficEntity.ExtraHourFee_dec.ToString(); OtherCarstiReport["ExtraHourFeetxt"] = txt.Text; OtherCarstiReport["UserNametxt"] = TrafficEntity.UserName_nvc; OtherCarstiReport["TrafficNumberbarcode"] = TrafficEntity.TrafficNumber_bint.ToString(); if (TrafficEntity.Printed_bit == true) { OtherCarstiReport["txtPrintedAgain"] = "المثنی"; } else { OtherCarstiReport["txtPrintedAgain"] = ""; } //DriverName_nvc OtherCarstiReport["DriverName_nvc"] = "نام راننده : " + TrafficEntity.FirstName_nvc + " " + TrafficEntity.LastName_nvc; OtherCarstiReport["Fee_dec"] = TrafficEntity.Fee_dec.ToString(); OtherCarstiReport["PriceTax_dec"] = TrafficEntity.PriceTax_dec.ToString(); OtherCarstiReport.Render(); Properties.Settings s = new HPS.Properties.Settings(); System.Drawing.Printing.PrinterSettings PrinterSetting = new System.Drawing.Printing.PrinterSettings(); if (string.IsNullOrEmpty(s.PrinterName)) { OtherCarstiReport.Print(true); } else { PrinterSetting.PrinterName = s.PrinterName; OtherCarstiReport.Print(false, PrinterSetting); } this.Close(); } //خارجی else if (_Traffic_bit == true && _Othercar_bit == true) { //HPS.BLL.TrafficBLL.BLLTraffic_T TrafficEntityrpt = new HPS.BLL.TrafficBLL.BLLTraffic_T(); ForeignCarstiReport.Dictionary.Synchronize(); ForeignCarstiReport.Dictionary.Databases.Clear(); ForeignCarstiReport.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("Connection", Hepsa.Core.Common.ConnectionString.ConnectionString)); ForeignCarstiReport.Compile(); ForeignCarstiReport["organ"] = new HPS.BLL.SettingsBLL.BLLSetting_TFactory().GetBy(new BLL.SettingsBLL.BLLSetting_TKeys() { SettingID_int = 1029 }).Value_nvc.ToString(); ForeignCarstiReport["DateTextBox"] = TrafficEntity.Date_nvc; ForeignCarstiReport["TimeTextBox"] = TrafficEntity.Time_nvc; ForeignCarstiReport["TrafficNumbertxt"] = TrafficEntity.TrafficNumber_bint.ToString(); ForeignCarstiReport["DriverNametxt"] = " نام راننده : " + TrafficEntity.FirstName_nvc + " " + TrafficEntity.LastName_nvc; HPS.BLL.LaderTypeBLL.BLLLaderType_TFactory laderTypeFactory = new HPS.BLL.LaderTypeBLL.BLLLaderType_TFactory(); string LaderTypecondition = "[LaderType_T].[LaderTypeID_int]='" + TrafficEntity.LaderTypeID_int + "'"; List <HPS.BLL.LaderTypeBLL.BLLLaderType_T> LaderTypeLst = laderTypeFactory.GetAllByCondition(LaderTypecondition); if (LaderTypeLst != null) { ForeignCarstiReport["CarTypetxt"] = "نوع وسيله : " + TrafficEntity.System_nvc + "- " + LaderTypeLst[0].LaderType_nvc; } if (!string.IsNullOrEmpty(TrafficEntity.SerialPlate_nvc)) { ForeignCarstiReport["NumberPlatetxt"] = "شماره پلاک : " + Hepsa.Core.Common.PersentationController.CorrectNumberPlate(TrafficEntity.NumberPlate_nvc) + " - " + TrafficEntity.SerialPlate_nvc; } else { ForeignCarstiReport["NumberPlatetxt"] = "شماره پلاک : " + Hepsa.Core.Common.PersentationController.CorrectNumberPlate(TrafficEntity.NumberPlate_nvc); } if (TrafficEntity.WithLade_bit == true) { ForeignCarstiReport["WithLadetxt"] = "وضعیت : " + "با بار" + "(" + TrafficEntity.Comment_nvc + ") "; } else { ForeignCarstiReport["WithLadetxt"] = "وضعیت : " + "بدون بار"; } NumericTextBox txt = new NumericTextBox(); txt.DigitsInGroup = 3; if (TrafficEntity.Price_dec != null) { txt.Text = TrafficEntity.Price_dec.ToString(); ForeignCarstiReport["Pricetxt"] = " مبلغ دریافتی هنگام ورود " + txt.Text + " ريال می باشد"; } ForeignCarstiReport["AllowableHourtxt"] = TrafficEntity.AllowableHour_int.ToString(); ForeignCarstiReport["ExtraHourtxt"] = TrafficEntity.ExtraHour_int.ToString(); txt.Text = TrafficEntity.Fee_dec.ToString(); ForeignCarstiReport["Feetxt"] = txt.Text; txt.Text = TrafficEntity.ExtraHourFee_dec.ToString(); ForeignCarstiReport["ExtraHourFeetxt"] = txt.Text; ForeignCarstiReport["UserNametxt"] = TrafficEntity.UserName_nvc; ForeignCarstiReport["TrafficNumberbarcode"] = TrafficEntity.TrafficNumber_bint.ToString(); if (TrafficEntity.Printed_bit == true) { ForeignCarstiReport["txtPrintedAgain"] = "المثنی"; } else { ForeignCarstiReport["txtPrintedAgain"] = ""; } ForeignCarstiReport["Fee_dec"] = TrafficEntity.Fee_dec.ToString(); ForeignCarstiReport["PriceTax_dec"] = TrafficEntity.PriceTax_dec.ToString(); ForeignCarstiReport.Render(); Properties.Settings s = new HPS.Properties.Settings(); System.Drawing.Printing.PrinterSettings PrinterSetting = new System.Drawing.Printing.PrinterSettings(); if (string.IsNullOrEmpty(s.PrinterName)) { ForeignCarstiReport.Print(true); } else { PrinterSetting.PrinterName = s.PrinterName; ForeignCarstiReport.Print(false, PrinterSetting); } this.Close(); } else if (_type == "dublicateTurns") { BLL.TrafficBLL.BLLTraffic_TFactory trafficFactory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory(); DataTable duplicateTurnDataTable = new DataTable(); trafficFactory.DuplicateTurnsReport(duplicateTurnDataTable); stiViewerControl1.Report = _sti; DuplicateTurnsReport.Dictionary.Synchronize(); DuplicateTurnsReport.Dictionary.Databases.Clear(); DuplicateTurnsReport.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("Connection", Hepsa.Core.Common.ConnectionString.ConnectionString)); DuplicateTurnsReport.Compile(); DuplicateTurnsReport["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(); DuplicateTurnsReport["date_vc"] = PortPlaceFactory.ServerJalaliDate + " " + PortPlaceFactory.ServerTime;; DuplicateTurnsReport["userName_vc"] = HPS.Common.CurrentUser.user.UserName_nvc; DuplicateTurnsReport.Render(); DuplicateTurnsReport.Show(); } else if (_again == 1) { HPS.BLL.LadBillCreditBLL.BLLLadBillCredit_TFactory LadBillCreditFactory = new HPS.BLL.LadBillCreditBLL.BLLLadBillCredit_TFactory(); HPS.BLL.LadBillCreditBLL.BLLLadBillCredit_TKeys LadBillKey = new HPS.BLL.LadBillCreditBLL.BLLLadBillCredit_TKeys(); LadBillKey.LadBillCreditID_int = _LadBIillCreditID; DataTable LadBillLadeAssignmentDataTable = new DataTable(); LadBillCreditFactory.GetAllLadeAssignment(LadBillKey, ref LadBillLadeAssignmentDataTable); Stimulsoft.Report.StiReport LadBillReportstiReport = new Stimulsoft.Report.StiReport(); LadBillReportstiReport.Load(Application.StartupPath + "\\LadBillCredit.mrt"); LadBillReportstiReport.Dictionary.Synchronize(); LadBillReportstiReport.Dictionary.Databases.Clear(); LadBillReportstiReport.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("Connection", Hepsa.Core.Common.ConnectionString.ConnectionString)); LadBillReportstiReport.Compile(); LadBillReportstiReport["organ"] = new HPS.BLL.SettingsBLL.BLLSetting_TFactory().GetBy(new BLL.SettingsBLL.BLLSetting_TKeys() { SettingID_int = 1029 }).Value_nvc.ToString(); if (!string.IsNullOrEmpty(LadBillLadeAssignmentDataTable.Rows[0]["DriverCardNumber_nvc"].ToString())) { LadBillReportstiReport["DriverCardNumber_vc"] = " کارت هوشمند راننده: " + LadBillLadeAssignmentDataTable.Rows[0]["DriverCardNumber_nvc"].ToString(); } else { LadBillReportstiReport["DriverCardNumber_vc"] = " کارت هوشمند راننده:فاقد كارت "; } if (!string.IsNullOrEmpty(LadBillLadeAssignmentDataTable.Rows[0]["CarCardNumber_nvc"].ToString())) { LadBillReportstiReport["CarCardNumber_vc"] = " کارت هوشمند کامیون : " + LadBillLadeAssignmentDataTable.Rows[0]["CarCardNumber_nvc"].ToString(); } else { LadBillReportstiReport["CarCardNumber_vc"] = " کارت هوشمند کامیون :فاقد كارت "; } LadBillReportstiReport["MobileNumber_vc"] = string.Format("موبایل راننده: {0}", LadBillLadeAssignmentDataTable.Rows[0]["DriverMobileNumber_nvc"].ToString()); LadBillReportstiReport["Company_nvc"] = LadBillLadeAssignmentDataTable.Rows[0]["CompanyID_intCompany_nvc"].ToString() + "(" + LadBillLadeAssignmentDataTable.Rows[0]["CompanyCode_nvc"].ToString() + ")" + "(" + LadBillLadeAssignmentDataTable.Rows[0]["Phone_nvc"].ToString() + ")"; //Cmp_nvc LadBillReportstiReport["LaderType_nvc"] = LadBillLadeAssignmentDataTable.Rows[0]["LaderTypeID_intLaderType_nvc"].ToString(); LadBillReportstiReport["Boxing_nvc"] = LadBillLadeAssignmentDataTable.Rows[0]["BoxingID_intBoxingType_nvc"].ToString(); //LaderType LadBillReportstiReport["PlateNumber_nvc"] = Hepsa.Core.Common.PersentationController.CorrectNumberPlate(LadBillLadeAssignmentDataTable.Rows[0]["NumberPlate_nvc"].ToString()) + " - " + LadBillLadeAssignmentDataTable.Rows[0]["PlateCity_nvc"].ToString() + LadBillLadeAssignmentDataTable.Rows[0]["SerialPlate_nvc"].ToString(); //Plaque LadBillReportstiReport["DriverName_nvc"] = LadBillLadeAssignmentDataTable.Rows[0]["DriverName"].ToString(); //Driver LadBillReportstiReport["LicenceNumber_bint"] = (LadBillLadeAssignmentDataTable.Rows[0]["licenceNumber_int"] != DBNull.Value?Convert.ToInt64(LadBillLadeAssignmentDataTable.Rows[0]["licenceNumber_int"]):0); //LicenceNumber LadBillReportstiReport["LicenceCity_nvc"] = LadBillLadeAssignmentDataTable.Rows[0]["LicenceCityID_intCity_nvc"].ToString(); //LicenceCity LadBillReportstiReport["Good_nvc"] = LadBillLadeAssignmentDataTable.Rows[0]["GoodID_intGood_nvc"].ToString(); //Good LadBillReportstiReport["Date_vc"] = LadBillLadeAssignmentDataTable.Rows[0]["LadingDate_nvc"].ToString(); // LadBillReportstiReport["Destination_nvc"] = LadBillLadeAssignmentDataTable.Rows[0]["CityID_intCity_nvc"].ToString() + "-" + LadBillLadeAssignmentDataTable.Rows[0]["Address_nvc"].ToString(); LadBillReportstiReport["PortajeFee_dec"] = LadBillLadeAssignmentDataTable.Rows[0]["PortageFee_dec"].ToString(); LadBillReportstiReport["AssignmentComment_nvc"] = LadBillLadeAssignmentDataTable.Rows[0]["AssignmentComment_nvc"].ToString(); LadBillReportstiReport["Date_vc"] = LadBillLadeAssignmentDataTable.Rows[0]["LadBillDate"].ToString(); LadBillReportstiReport["Time_vc"] = LadBillLadeAssignmentDataTable.Rows[0]["LadBillTime"].ToString(); LadBillReportstiReport["TurnNumber_bint"] = Convert.ToInt64(LadBillLadeAssignmentDataTable.Rows[0]["AcceptedTurnNumber_bint"]); LadBillReportstiReport["LadBillNumber_bint"] = Convert.ToInt64(LadBillLadeAssignmentDataTable.Rows[0]["LadBillCreditID_int"]); LadBillReportstiReport["UserName_nvc"] = LadBillLadeAssignmentDataTable.Rows[0]["LadBillUser"].ToString(); LadBillReportstiReport["PortPlace_nvc"] = LadBillLadeAssignmentDataTable.Rows[0]["PortPlaceID_intPortPlaces_nvc"].ToString(); LadBillReportstiReport["MinWeight_nvc"] = "از وزن: " + LadBillLadeAssignmentDataTable.Rows[0]["MinWeight_dec"]; LadBillReportstiReport["MaxWeight_nvc"] = "تا وزن: " + LadBillLadeAssignmentDataTable.Rows[0]["MaxWeight_dec"]; LadBillReportstiReport["TrafficNumber_bint"] = Convert.ToInt64(LadBillLadeAssignmentDataTable.Rows[0]["TrafficNumber_bint"]); LadBillReportstiReport["System_nvc"] = LadBillLadeAssignmentDataTable.Rows[0]["System_nvc"].ToString(); HPS.BLL.BillMessageBLL.BLLBillMessage_TFactory BillMessage_TFactory = new HPS.BLL.BillMessageBLL.BLLBillMessage_TFactory(); List <HPS.BLL.BillMessageBLL.BLLBillMessage_T> BillMessage_TList = new List <HPS.BLL.BillMessageBLL.BLLBillMessage_T>(); string Condition = string.Format("TrafficType_T.TrafficTypeID_int=9 AND [BillMessage_T].StartDate_nvc<='{0}' AND [BillMessage_T].[EndDate_nvc]>='{0}' ", BillMessage_TFactory.ServerJalaliDate); BillMessage_TList = BillMessage_TFactory.GetAllByCondition(Condition); if (BillMessage_TList != null && BillMessage_TList.Count > 0) { LadBillReportstiReport["BillMessage_nvc"] = BillMessage_TList[0].Message_nvc; } if (_again != 1) { if (LadBillLadeAssignmentDataTable.Rows[0]["LadeDate"].ToString().CompareTo(LadBillCreditFactory.ServerJalaliDate) < 0) { LadBillReportstiReport["Remained_bit"] = true; } else { LadBillReportstiReport["Remained_bit"] = false; } } if (_again == 1) { LadBillReportstiReport["Again_bit"] = true; LadBillReportstiReport["AgainPrintDate_vc"] = LadBillCreditFactory.ServerJalaliDate; LadBillReportstiReport["AgainPrintTime_vc"] = LadBillCreditFactory.ServerTime; LadBillReportstiReport["AgainPrintUser_vnc"] = HPS.Common.CurrentUser.user.UserName_nvc; } LadBillReportstiReport.Render(); Properties.Settings s = new HPS.Properties.Settings(); System.Drawing.Printing.PrinterSettings PrinterSetting = new System.Drawing.Printing.PrinterSettings(); if (string.IsNullOrEmpty(s.PrinterName)) { LadBillReportstiReport.PrinterSettings.Copies = 3; LadBillReportstiReport.Print(true); } else { LadBillReportstiReport.PrinterSettings.Copies = 3; PrinterSetting.PrinterName = s.PrinterName; LadBillReportstiReport.Print(false, PrinterSetting); } } else { stiViewerControl1.Report = _sti; } this.Close(); }
public AcceptedTurnReport(HPS.BLL.TrafficBLL.BLLTraffic_T TrafficEntityrpt) { // // Required for Windows Form Designer support // InitializeComponent(); HPS.BLL.TrafficBLL.BLLTraffic_TFactory TrafficFactory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory(); HPS.BLL.TrafficBLL.BLLTraffic_TKeys TrafficKey = new HPS.BLL.TrafficBLL.BLLTraffic_TKeys(); //HPS.BLL.TrafficBLL.BLLTraffic_T TrafficEntityrpt = new HPS.BLL.TrafficBLL.BLLTraffic_T(); //TrafficKey.TrafficID_bint = TrafficID_bint; //TrafficEntityrpt = TrafficFactory.GetBy(TrafficKey); AcceptedDateTextBox.Text = TrafficEntityrpt.TurnDate_nvc; AcceptedTimeTextBox.Text = TrafficEntityrpt.TurnTime_nvc; InDateTextBox.Text = TrafficEntityrpt.Date_nvc; InTimeTextBox.Text = TrafficEntityrpt.Time_nvc; InDatetext2Box.Text = TrafficEntityrpt.Date_nvc; InTimetext2Box.Text = TrafficEntityrpt.Time_nvc; DateTextBox.Text = TrafficFactory.ServerJalaliDate; TimeTextBox.Text = TrafficFactory.ServerTime; if (TrafficEntityrpt.AcceptedTurnNumber_bint.HasValue) { TurnNumber2txt.Text = "شماره نوبت : " + TrafficEntityrpt.AcceptedTurnNumber_bint.ToString(); TurnNumbertxt.Text = "شماره نوبت : " + TrafficEntityrpt.AcceptedTurnNumber_bint.ToString(); } else { TurnNumber2txt.Text = "شماره نوبت رزرو : " + TrafficEntityrpt.TurnNumber_bint.ToString(); TurnNumbertxt.Text = "شماره نوبت رزرو : " + TrafficEntityrpt.TurnNumber_bint.ToString(); } TrafficNumbertxt.Text = "شماره قبض : " + TrafficEntityrpt.TrafficNumber_bint.ToString(); TrafficNumber2txt.Text = "شماره قبض : " + TrafficEntityrpt.TrafficNumber_bint.ToString(); DriverNametxt.Text = " نام راننده : " + TrafficEntityrpt.FirstName_nvc + " " + TrafficEntityrpt.LastName_nvc; DriverName2txt.Text = " نام راننده : " + TrafficEntityrpt.FirstName_nvc + " " + TrafficEntityrpt.LastName_nvc; HPS.BLL.LaderTypeBLL.BLLLaderType_TFactory laderTypeFactory = new HPS.BLL.LaderTypeBLL.BLLLaderType_TFactory(); string LaderTypecondition = "[LaderType_T].[LaderTypeID_int]='" + TrafficEntityrpt.LaderTypeID_int + "'"; List <HPS.BLL.LaderTypeBLL.BLLLaderType_T> LaderTypeLst = laderTypeFactory.GetAllByCondition(LaderTypecondition); if (LaderTypeLst != null) { CarTypetxt.Text = "نوع وسیله : " + TrafficEntityrpt.System_nvc + "- " + LaderTypeLst[0].LaderType_nvc; //+ "- کد:" + LaderTypeLst[0].LaderTypeID_int.ToString() ; CarType2txt.Text = "نوع وسیله : " + TrafficEntityrpt.System_nvc + "- " + LaderTypeLst[0].LaderType_nvc; } HPS.BLL.PlateCityBLL.BLLPlateCity_TFactory PlatecityFactory = new HPS.BLL.PlateCityBLL.BLLPlateCity_TFactory(); HPS.BLL.PlateCityBLL.BLLPlateCity_TKeys Platecitykey = new HPS.BLL.PlateCityBLL.BLLPlateCity_TKeys(); Platecitykey.PlateCityID_int = TrafficEntityrpt.PlateCityID_int; HPS.BLL.PlateCityBLL.BLLPlateCity_T PlateCityEntity = new HPS.BLL.PlateCityBLL.BLLPlateCity_T(); PlateCityEntity = PlatecityFactory.GetBy(Platecitykey); if (PlateCityEntity != null) { NumberPlatetxt.Text = "شماره پلاک : " + Hepsa.Core.Common.PersentationController.CorrectNumberPlate(TrafficEntityrpt.NumberPlate_nvc) + " - " + PlateCityEntity.PlateCity_nvc + " " + TrafficEntityrpt.SerialPlate_nvc; NumberPlate2txt.Text = "شماره پلاک : " + Hepsa.Core.Common.PersentationController.CorrectNumberPlate(TrafficEntityrpt.NumberPlate_nvc) + " - " + PlateCityEntity.PlateCity_nvc + " " + TrafficEntityrpt.SerialPlate_nvc; } else { NumberPlatetxt.Text = "شماره پلاک : " + Hepsa.Core.Common.PersentationController.CorrectNumberPlate(TrafficEntityrpt.NumberPlate_nvc) + " - " + TrafficEntityrpt.SerialPlate_nvc; NumberPlate2txt.Text = "شماره پلاک : " + Hepsa.Core.Common.PersentationController.CorrectNumberPlate(TrafficEntityrpt.NumberPlate_nvc) + " - " + TrafficEntityrpt.SerialPlate_nvc; } DriverCardNumbertxt.Text = "شماره كارت راننده :" + TrafficEntityrpt.DriverCardNumber_nvc; CarCardNumbertxt.Text = "شماره كارت كاميون :" + TrafficEntityrpt.CarCardNumber_nvc; HPS.BLL.BillMessageBLL.BLLBillMessage_TFactory BillFactory = new HPS.BLL.BillMessageBLL.BLLBillMessage_TFactory(); if (TrafficEntityrpt.BillMessageID_int == 0 || TrafficEntityrpt.BillMessageID_int == null) { } else { string Billcondition = "[BillMessage_T].[BillMessageID_int]=" + TrafficEntityrpt.BillMessageID_int; List <HPS.BLL.BillMessageBLL.BLLBillMessage_T> BillLst = BillFactory.GetAllByCondition(Billcondition); if (BillLst != null) { Messagetxt.Text = BillLst[0].Message_nvc; } } HamrahanSystem.TextBox.NumericTextBox txt = new HamrahanSystem.TextBox.NumericTextBox(); txt.DigitsInGroup = 3; if (TrafficEntityrpt.Price_dec != null) { txt.Text = TrafficEntityrpt.Price_dec.ToString(); Pricetxt.Text = " مبلغ دریافت شده هنگام ورود " + txt.Text + " ريال می باشد"; } UserNametxt.Text = HPS.Common.CurrentUser.user.UserName_nvc; if (!string.IsNullOrEmpty(TrafficEntityrpt.AcceptedTurnComment_nvc)) { if (TrafficEntityrpt.Area_bit) { Commenttxt.Text = "توضيحات : " + TrafficEntityrpt.AcceptedTurnComment_nvc + " حومه"; } else { Commenttxt.Text = "توضيحات : " + TrafficEntityrpt.AcceptedTurnComment_nvc; } } else { if (TrafficEntityrpt.Area_bit) { Commenttxt.Text = "حومه"; } } TrafficNumberbarcode.Text = TrafficEntityrpt.TrafficNumber_bint.ToString(); TrafficNumber_intbarcode.Text = TrafficEntityrpt.TrafficNumber_bint.ToString(); //if (!TrafficEntityrpt.DriverOffline_bit) //{ // OfflineReadtxt.Text = "آنلاین"; //} //else //{ // OfflineReadtxt.Text = "آفلاین"; //} ////////////// HPS.BLL.SettingsBLL.BLLSetting_TFactory settingsFactory = new HPS.BLL.SettingsBLL.BLLSetting_TFactory(); HPS.BLL.SettingsBLL.BLLSetting_T SettingEntity = new HPS.BLL.SettingsBLL.BLLSetting_T(); HPS.BLL.SettingsBLL.BLLSetting_TKeys SettingKey = new HPS.BLL.SettingsBLL.BLLSetting_TKeys(); SettingKey.SettingID_int = 1002; SettingEntity = settingsFactory.GetBy(SettingKey); AllowableHourtxt.Text = SettingEntity.Value_nvc; //TrafficEntityrpt.AllowableHour_int.ToString(); Feetxt.Text = txt.Text; ExtraHourtxt.Text = TrafficEntityrpt.ExtraHour_int.ToString(); //if (TrafficEntityrpt.WithFlat_bit==true) //{ //txt.Text = TrafficEntityrpt.ExtraHourFee_dec.ToString(); //} ExtraHourFeetxt.Text = TrafficEntityrpt.ExtraHourFee_dec.ToString(); ////////////// if (TrafficEntityrpt.TurnPrinted_bit == true) { this.txtPrintedAgain.Visible = true; UserNametxt.Text = Hepsa.Core.Common.CurrentUser.User.UserName_nvc; } else { this.txtPrintedAgain.Visible = false; try { TrafficKey.TrafficID_bint = TrafficEntityrpt.TrafficID_bint; TrafficEntityrpt.TurnPrinted_bit = true; TrafficFactory.BeginProc(); TrafficFactory.Update(TrafficEntityrpt, TrafficKey); TrafficFactory.CommitProc(); } catch (Exception ex) { TrafficFactory.RollBackProc(); throw ex; } } }
private void PrintstripButton_Click(object sender, EventArgs e) { CarAllTrafficfoGridView.Visible = false; stiViewerControl1.Visible = true; string TrafficCondition = string.Empty; if (!string.IsNullOrEmpty(NumberPlate_nvcTextBox.Text) && !string.IsNullOrEmpty(SerialPlate_nvcTextBox.Text)) { TrafficCondition += string.Format(" T.NumberPlate_nvc='{0}' AND T.SerialPlate_nvc='{1}' ", NumberPlate_nvcTextBox.Text, SerialPlate_nvcTextBox.Text); if (!string.IsNullOrEmpty(CarCardNumber_nvcTextBox.Text)) { TrafficCondition += string.Format(" AND T.CarCardNumber_nvc={0} ", CarCardNumber_nvcTextBox.Text); } } else if (!string.IsNullOrEmpty(CarCardNumber_nvcTextBox.Text)) { TrafficCondition += string.Format(" T.CarCardNumber_nvc={0} ", CarCardNumber_nvcTextBox.Text); } if (!FromDatefaDatePicker.IsNull && !ToDatefaDatePicker.IsNull) { TrafficCondition += string.Format(" AND T.Date_nvc>='{0}' AND T.Date_nvc<='{1}' ", FromDatefaDatePicker.Text, ToDatefaDatePicker.Text); } CarAllTrafficstiReport.Dictionary.Synchronize(); CarAllTrafficstiReport.Dictionary.Databases.Clear(); CarAllTrafficstiReport.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("Connection", Hepsa.Core.Common.ConnectionString.ConnectionString)); CarAllTrafficstiReport.Compile(); //مقدار دهی متغیرها //stiReport1["fromDate_nvc"] = 1393 / 01 / 20;//FromDatefaDatePicker.Text; CarAllTrafficstiReport["organ"] = new HPS.BLL.SettingsBLL.BLLSetting_TFactory().GetBy(new BLL.SettingsBLL.BLLSetting_TKeys() { SettingID_int = 1029 }).Value_nvc.ToString(); if (FromDatefaDatePicker.IsNull) { CarAllTrafficstiReport["fromDate_nvc"] = string.Empty; } else { CarAllTrafficstiReport["fromDate_nvc"] = FromDatefaDatePicker.Text; } if (ToDatefaDatePicker.IsNull) { CarAllTrafficstiReport["toDate_nvc"] = string.Empty; } else { CarAllTrafficstiReport["toDate_nvc"] = ToDatefaDatePicker.Text; } HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory PortPlaceFactory = new HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory(); CarAllTrafficstiReport["date_vc"] = PortPlaceFactory.ServerJalaliDate + " " + PortPlaceFactory.ServerTime; CarAllTrafficstiReport["userName_nvc"] = HPS.Common.CurrentUser.user.UserName_nvc; CarAllTrafficstiReport["@Condition"] = TrafficCondition; CarAllTrafficstiReport.Render(); stiViewerControl1.Report = CarAllTrafficstiReport; }
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 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); } }
public TrafficReport(HPS.BLL.TrafficBLL.BLLTraffic_T TrafficEntity) { // // Required for Windows Form Designer support // InitializeComponent(); this.TrafficEntityrpt = TrafficEntity; InDateTextBox.Text = TrafficEntityrpt.Date_nvc; InTimeTextBox.Text = TrafficEntityrpt.Time_nvc; //InDatetext2Box.Text = TrafficEntityrpt.Date_nvc; //InTimetext2Box.Text = TrafficEntityrpt.Time_nvc; TrafficNumbertxt.Text = "شماره قبض : " + TrafficEntityrpt.TrafficNumber_bint.ToString(); //TrafficNumber2txt.Text = TrafficEntityrpt.TrafficNumber_bint.ToString(); //DriverName2txt.Text = " نام راننده : " + TrafficEntityrpt.FirstName_nvc + " " + TrafficEntityrpt.LastName_nvc; if (TrafficEntityrpt.ServiceID_int == 2) { if (TrafficEntityrpt.TurnAccepted_bit == true) { //نوبت تأیید شده داره TurnNumbertxt.Text = "شماره نوبت : " + Convert.ToString(TrafficEntityrpt.AcceptedTurnNumber_bint); //AcceptedDate2TextBox.Text = TrafficEntityrpt.TurnDate_nvc; //AcceptedTime2TextBox.Text = TrafficEntityrpt.TurnTime_nvc; //TurnNumber2txt.Text = TrafficEntityrpt.AcceptedTurnNumber_bint.ToString(); } else { //نوبت تأیید شده ندارد TurnNumbertxt.Text = "شماره نوبت رزرو : " + Convert.ToString(TrafficEntityrpt.TurnNumber_bint); } } else { // (عدم نمایش نوبت (مراجعه به غیر از نوبت TurnNumbertxt.Visible = false; TurnNumberAllerttxt.Visible = false; } //DriverCardNumber2txt.Text = "شماره كارت راننده :" + TrafficEntityrpt.DriverCardNumber_nvc; //CarCardNumber2txt.Text = "شماره كارت كاميون :" + TrafficEntityrpt.CarCardNumber_nvc; HPS.BLL.ServicesBLL.BLLServices_TFactory servicesFactory = new HPS.BLL.ServicesBLL.BLLServices_TFactory(); HPS.BLL.ServicesBLL.BLLServices_TKeys ServicesKey = new HPS.BLL.ServicesBLL.BLLServices_TKeys(); ServicesKey.ServicesID_int = TrafficEntity.ServiceID_int; DateTextBox.Text = servicesFactory.ServerJalaliDate; TimeTextBox.Text = servicesFactory.ServerTime; HPS.BLL.ServicesBLL.BLLServices_T ServicesEntity = new HPS.BLL.ServicesBLL.BLLServices_T(); ServicesEntity = servicesFactory.GetBy(ServicesKey); Servicestxt.Text = " قبض مراجعه به : " + ServicesEntity.ServicesType_nvc; DriverNametxt.Text = " نام راننده : " + TrafficEntityrpt.FirstName_nvc + " " + TrafficEntityrpt.LastName_nvc; HPS.BLL.LaderTypeBLL.BLLLaderType_TFactory laderTypeFactory = new HPS.BLL.LaderTypeBLL.BLLLaderType_TFactory(); string LaderTypecondition = "[LaderType_T].[LaderTypeID_int]='" + TrafficEntityrpt.LaderTypeID_int + "'"; List <HPS.BLL.LaderTypeBLL.BLLLaderType_T> LaderTypeLst = laderTypeFactory.GetAllByCondition(LaderTypecondition); if (LaderTypeLst != null) { CarTypetxt.Text = "نوع وسیله : " + TrafficEntityrpt.System_nvc + "- " + LaderTypeLst[0].LaderType_nvc; //CarType2txt.Text = "نوع وسیله : " + TrafficEntityrpt.System_nvc + "- " + LaderTypeLst[0].LaderType_nvc; //+ "- کد:" + LaderTypeLst[0].LaderTypeID_int.ToString() ; } HPS.BLL.PlateCityBLL.BLLPlateCity_TFactory PlatecityFactory = new HPS.BLL.PlateCityBLL.BLLPlateCity_TFactory(); HPS.BLL.PlateCityBLL.BLLPlateCity_TKeys Platecitykey = new HPS.BLL.PlateCityBLL.BLLPlateCity_TKeys(); Platecitykey.PlateCityID_int = TrafficEntityrpt.PlateCityID_int; HPS.BLL.PlateCityBLL.BLLPlateCity_T PlateCityEntity = new HPS.BLL.PlateCityBLL.BLLPlateCity_T(); PlateCityEntity = PlatecityFactory.GetBy(Platecitykey); if (PlateCityEntity != null) { NumberPlatetxt.Text = "شماره پلاک : " + Hepsa.Core.Common.PersentationController.CorrectNumberPlate(TrafficEntityrpt.NumberPlate_nvc) + " - " + PlateCityEntity.PlateCity_nvc + " " + TrafficEntityrpt.SerialPlate_nvc; //NumberPlate2txt.Text = "شماره پلاک : " + Hepsa.Core.Common.PersentationController.CorrectNumberPlate(TrafficEntityrpt.NumberPlate_nvc) + " - " + PlateCityEntity.PlateCity_nvc + " " + TrafficEntityrpt.SerialPlate_nvc; } else { NumberPlatetxt.Text = "شماره پلاک : " + Hepsa.Core.Common.PersentationController.CorrectNumberPlate(TrafficEntityrpt.NumberPlate_nvc) + " - " + TrafficEntityrpt.SerialPlate_nvc; //NumberPlate2txt.Text = "شماره پلاک : " + Hepsa.Core.Common.PersentationController.CorrectNumberPlate(TrafficEntityrpt.NumberPlate_nvc) + " - " + TrafficEntityrpt.SerialPlate_nvc; } if (TrafficEntityrpt.WithLade_bit == true) { WithLadetxt.Text = "وضعیت : " + "با بار" + "(" + TrafficEntityrpt.Comment_nvc + ") "; } else { WithLadetxt.Text = "وضعیت : " + "بدون بار"; } HPS.BLL.BillMessageBLL.BLLBillMessage_TFactory BillFactory = new HPS.BLL.BillMessageBLL.BLLBillMessage_TFactory(); if (TrafficEntityrpt.BillMessageID_int == 0 || TrafficEntityrpt.BillMessageID_int == null) { } else { string Billcondition = "[BillMessage_T].[BillMessageID_int]=" + TrafficEntityrpt.BillMessageID_int; List <HPS.BLL.BillMessageBLL.BLLBillMessage_T> BillLst = BillFactory.GetAllByCondition(Billcondition); if (BillLst != null) { Messagetxt.Text = BillLst[0].Message_nvc; } } HamrahanSystem.TextBox.NumericTextBox txt = new HamrahanSystem.TextBox.NumericTextBox(); txt.DigitsInGroup = 3; if (TrafficEntityrpt.Price_dec != null) { txt.Text = TrafficEntityrpt.Price_dec.ToString(); Pricetxt.Text = " مبلغ دریافتی هنگام ورود " + txt.Text + " ريا ل می باشد"; } HPS.BLL.SettingsBLL.BLLSetting_TFactory settingsFactory = new HPS.BLL.SettingsBLL.BLLSetting_TFactory(); HPS.BLL.SettingsBLL.BLLSetting_T SettingEntity = new HPS.BLL.SettingsBLL.BLLSetting_T(); HPS.BLL.SettingsBLL.BLLSetting_TKeys SettingKey = new HPS.BLL.SettingsBLL.BLLSetting_TKeys(); SettingKey.SettingID_int = 1002; SettingEntity = settingsFactory.GetBy(SettingKey); if (TrafficEntityrpt.ServiceID_int == 2) { AllowableHourtxt.Text = SettingEntity.Value_nvc; //TrafficEntityrpt.AllowableHour_int.ToString(); } else { AllowableHourtxt.Text = TrafficEntityrpt.AllowableHour_int.ToString(); } txt.Text = TrafficEntityrpt.Fee_dec.ToString(); Feetxt.Text = txt.Text; ExtraHourtxt.Text = TrafficEntityrpt.ExtraHour_int.ToString(); //if (TrafficEntityrpt.WithFlat_bit==true) //{ //txt.Text = TrafficEntityrpt.ExtraHourFee_dec.ToString(); //} txt.Text = TrafficEntityrpt.ExtraHourFee_dec.ToString(); ExtraHourFeetxt.Text = txt.Text; UserNametxt.Text = TrafficEntityrpt.UserName_nvc; TrafficNumberbarcode.Text = TrafficEntityrpt.TrafficNumber_bint.ToString(); if (TrafficEntityrpt.TurnHour_int != null) { TurnNumberAllerttxt.Text = " شماره نوبت شما رزرو می باشد لطفاً تا " + TrafficEntityrpt.TurnHour_int.ToString() + " ساعت نسبت به تأیید آن اقدام نمایید"; } if (TrafficEntityrpt.Printed_bit == true) { this.txtPrintedAgain.Visible = true; } else { this.txtPrintedAgain.Visible = false; HPS.BLL.TrafficBLL.BLLTraffic_TFactory TrafficFactory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory(); try { HPS.BLL.TrafficBLL.BLLTraffic_TKeys TrafficKey = new HPS.BLL.TrafficBLL.BLLTraffic_TKeys(); TrafficKey.TrafficID_bint = TrafficEntityrpt.TrafficID_bint; TrafficEntityrpt.Printed_bit = true; TrafficFactory.BeginProc(); TrafficFactory.Update(TrafficEntityrpt, TrafficKey); TrafficFactory.CommitProc(); } catch (Exception ex) { TrafficFactory.RollBackProc(); throw ex; } } }
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 Search() { try { TurnManagementGridView.DataSource = null; DataTable TrafficDataTable = new DataTable(); HPS.BLL.TrafficBLL.BLLTraffic_TFactory TrafficFactory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory(); string Condition = string.Empty; if (_TurnStatus == 1)//return { HPS.BLL.SettingsBLL.BLLSetting_TFactory SettingFactory = new HPS.BLL.SettingsBLL.BLLSetting_TFactory(); HPS.BLL.SettingsBLL.BLLSetting_T SettingEntity = new HPS.BLL.SettingsBLL.BLLSetting_T(); HPS.BLL.SettingsBLL.BLLSetting_TKeys SettingKey = new HPS.BLL.SettingsBLL.BLLSetting_TKeys(); SettingKey.SettingID_int = 1001; SettingEntity = SettingFactory.GetBy(SettingKey); DateTime NowDate = DateTime.Parse((new Hepsa.Core.Common.MyDateTime(SettingFactory.ServerJalaliDate)).MyDate.ToString("yyyy/MM/dd") + " " + SettingFactory.ServerTime); DateTime SubtractedTime = NowDate.Subtract(new TimeSpan(Convert.ToInt32(SettingEntity.Value_nvc), 0, 0)); HPS.BLL.TurnManagementBLL.BLLTurnManagement_TFactory TurnManagementFactory = new HPS.BLL.TurnManagementBLL.BLLTurnManagement_TFactory(); DataTable TurnManagementDataTable = new DataTable(); if (!string.IsNullOrEmpty(TrafficNumberTextBox.Text)) { TurnManagementFactory.GetAllWithTrafficForReturnTurn(SettingFactory.ServerJalaliDate, SubtractedTime.ToString("HH:mm"), Int64.Parse(TrafficNumberTextBox.Text), null, string.Empty, string.Empty, string.Empty, string.Empty, ref TurnManagementDataTable); } else if (!string.IsNullOrEmpty(AcceptedTurnNumberTextBox.Text)) { TurnManagementFactory.GetAllWithTrafficForReturnTurn(SettingFactory.ServerJalaliDate, SubtractedTime.ToString("HH:mm"), null, Int64.Parse(AcceptedTurnNumberTextBox.Text), string.Empty, string.Empty, string.Empty, string.Empty, ref TurnManagementDataTable); } else if (!string.IsNullOrEmpty(NumberPlate_nvcTextBox.Text) && !string.IsNullOrEmpty(SerialPlate_nvcTextBox.Text)) { TurnManagementFactory.GetAllWithTrafficForReturnTurn(SettingFactory.ServerJalaliDate, SubtractedTime.ToString("HH:mm"), null, null, NumberPlate_nvcTextBox.Text, SerialPlate_nvcTextBox.Text, string.Empty, string.Empty, ref TurnManagementDataTable); } else if (!string.IsNullOrEmpty(FromDate_nvcTextBox.Text) && !string.IsNullOrEmpty(ToDate_nvcTextBox.Text)) { TurnManagementFactory.GetAllWithTrafficForReturnTurn(SettingFactory.ServerJalaliDate, SubtractedTime.ToString("HH:mm"), null, null, string.Empty, string.Empty, FromDate_nvcTextBox.Text, ToDate_nvcTextBox.Text, ref TurnManagementDataTable); } this.TurnManagementGridView.DataSource = TurnManagementDataTable; } else//cancel { CanceledTurnFromLadbilltoolStripButton.Visible = false; this.Text = "لیست نوبت ها برای ابطال"; HPS.BLL.TurnManagementBLL.BLLTurnManagement_TFactory TurnManagementFactory = new HPS.BLL.TurnManagementBLL.BLLTurnManagement_TFactory(); DataTable TurnManagementDataTable = new DataTable(); if (!string.IsNullOrEmpty(TrafficNumberTextBox.Text)) { TurnManagementFactory.GetAllWithTrafficForCancelTurn(Int64.Parse(TrafficNumberTextBox.Text), null, string.Empty, string.Empty, string.Empty, string.Empty, ref TurnManagementDataTable); } else if (!string.IsNullOrEmpty(AcceptedTurnNumberTextBox.Text)) { TurnManagementFactory.GetAllWithTrafficForCancelTurn(null, Int64.Parse(AcceptedTurnNumberTextBox.Text), string.Empty, string.Empty, string.Empty, string.Empty, ref TurnManagementDataTable); } else if (!string.IsNullOrEmpty(NumberPlate_nvcTextBox.Text) && !string.IsNullOrEmpty(SerialPlate_nvcTextBox.Text)) { TurnManagementFactory.GetAllWithTrafficForCancelTurn(null, null, NumberPlate_nvcTextBox.Text, SerialPlate_nvcTextBox.Text, string.Empty, string.Empty, ref TurnManagementDataTable); } else if (!string.IsNullOrEmpty(FromDate_nvcTextBox.Text) && !string.IsNullOrEmpty(ToDate_nvcTextBox.Text)) { TurnManagementFactory.GetAllWithTrafficForCancelTurn(null, null, string.Empty, string.Empty, FromDate_nvcTextBox.Text, ToDate_nvcTextBox.Text, ref TurnManagementDataTable); } this.TurnManagementGridView.DataSource = TurnManagementDataTable; } } catch (System.Exception ex) { Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message); } }
private void PrintStripButton_Click(object sender, EventArgs e) { //try //{ // if (FromDatefaDatePicker.IsNull) // { // throw new ApplicationException("از تاریخ خالی است"); // } // else if (ToDatefaDatePicker.IsNull) // { // 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); // HPS.Reports.ReportDoc.AllAcceptedTurnReport rpt=null; // if (WithProductionYear == true) // { // rpt = new HPS.Reports.ReportDoc.AllAcceptedTurnReport(FromDatefaDatePicker.Text, ToDatefaDatePicker.Text,true); // rpt.Document.Printer.PrinterName = string.Empty; // rpt.Run(); // } // else // { // rpt = new HPS.Reports.ReportDoc.AllAcceptedTurnReport(FromDatefaDatePicker.Text, ToDatefaDatePicker.Text, false); // rpt.Document.Printer.PrinterName = string.Empty; // rpt.Run(); // } // Properties.Settings s = new HPS.Properties.Settings(); // if (string.IsNullOrEmpty(s.PrinterName)) // { // rpt.Document.Print(true, true, true); // } // else // { // rpt.Document.Printer.PrinterName = s.PrinterName; // rpt.Document.Print(false, true, true); // } //} //catch (Exception ex) //{ // Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message); //} try { if (FromDatefaDatePicker.IsNull) { throw new ApplicationException("از تاریخ خالی است"); } else if (ToDatefaDatePicker.IsNull) { 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); } HPS.BLL.TrafficBLL.BLLTraffic_TFactory TrafficFactory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory(); string Condition = string.Empty; if (WithProductionYear == true) { Condition = " [T1].[TurnAccepted_bit]='true' AND [T1].[TrafficTypeID_int]=1 AND (T1.TurnDate_nvc>='" + FromDatefaDatePicker.Text + "') AND (T1.TurnDate_nvc<='" + ToDatefaDatePicker.Text + "') AND T1.ProductionYear_int IS NOT NULL"; } else { Condition = " [T1].[TurnAccepted_bit]='true' AND [T1].[TrafficTypeID_int]=1 AND (T1.TurnDate_nvc>='" + FromDatefaDatePicker.Text + "') AND (T1.TurnDate_nvc<='" + ToDatefaDatePicker.Text + "')"; } AllAcceptedTurnstiReport.Dictionary.Synchronize(); AllAcceptedTurnstiReport.Dictionary.Databases.Clear(); AllAcceptedTurnstiReport.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("Connection", Hepsa.Core.Common.ConnectionString.ConnectionString)); AllAcceptedTurnstiReport.Compile(); AllAcceptedTurnstiReport["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(); AllAcceptedTurnstiReport["fromdate_vc"] = FromDatefaDatePicker.Text; AllAcceptedTurnstiReport["todate_vc"] = ToDatefaDatePicker.Text; AllAcceptedTurnstiReport["date_vc"] = PortPlaceFactory.ServerJalaliDate + " " + PortPlaceFactory.ServerTime;; AllAcceptedTurnstiReport["UserName_vc"] = HPS.Common.CurrentUser.user.UserName_nvc; AllAcceptedTurnstiReport["fromTrafficNumber"] = TrafficNumber_binttextBox.Text; AllAcceptedTurnstiReport["@condition_nvc"] = Condition; AllAcceptedTurnstiReport.Render(); stiViewerControl1.Report = AllAcceptedTurnstiReport; stiViewerControl1.Visible = true; TrafficGridView.Visible = false; } catch (Exception ex) { Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message); } }
public IranianInNotOutTrafficReport(string FromDate, string ToDate, int TrafficType, int?PivotGroupID, int?ServicesID) { // // Required for Windows Form Designer support // InitializeComponent(); FromDatetxt.Text = FromDate; ToDatetxt.Text = ToDate; HPS.BLL.TrafficBLL.BLLTraffic_TFactory TrafficFactory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory(); DataTable TrafficDataTable = new DataTable(); string Condition = string.Empty; if (ServicesID.HasValue) { if (PivotGroupID.HasValue) { Condition = String.Format("(T1.TrafficTypeID_int='1') AND (T1.Date_nvc>='{0}') AND (T1.Date_nvc<='{1}') AND (LaderPivotGroup_T.LaderPivotGroupID_int={2}) AND (T1.ServiceID_int={3})", FromDate, ToDate, PivotGroupID, ServicesID); } else { Condition = String.Format("(T1.TrafficTypeID_int='1') AND (T1.Date_nvc>='{0}') AND (T1.Date_nvc<='{1}') AND (T1.ServiceID_int={2})", FromDate, ToDate, ServicesID); } } else { if (PivotGroupID.HasValue) { Condition = String.Format("(T1.TrafficTypeID_int='1') AND (T1.Date_nvc>='{0}') AND (T1.Date_nvc<='{1}') AND (LaderPivotGroup_T.LaderPivotGroupID_int={2})", FromDate, ToDate, PivotGroupID); } else { Condition = String.Format("(T1.TrafficTypeID_int='1') AND (T1.Date_nvc>='{0}') AND (T1.Date_nvc<='{1}')", FromDate, ToDate); } } TrafficFactory.GetAllByConditionAllInTrafficNotTemporaryOut(Condition, ref TrafficDataTable); TrafficDataTable.Columns.Add(new DataColumn("AllPayment_dec", typeof(decimal))); TrafficDataTable.Columns.Add(new DataColumn("Remained_dec", typeof(decimal))); HPS.BLL.LaderTypeBLL.BLLLaderType_TFactory LaderTypeFactory = new HPS.BLL.LaderTypeBLL.BLLLaderType_TFactory(); HPS.BLL.LaderTypeBLL.BLLLaderType_TKeys LaderTypeKey = new HPS.BLL.LaderTypeBLL.BLLLaderType_TKeys(); string stopFeeCondition = string.Empty; var stopFeeFactory = new BLL.StopFeeBLL.BLLStopFee_TFactory(); BLL.StopFeeBLL.BLLStopFee_T oldStopFeeEntity = null; BLL.StopFeeBLL.BLLStopFee_TKeys stopFeeKey = null; BLL.LaderTypeBLL.BLLLaderType_T laderTypeEntity = null; HPS.BLL.LadBillCreditBLL.BLLLadBillCredit_TFactory LadBillFactory = new HPS.BLL.LadBillCreditBLL.BLLLadBillCredit_TFactory(); DataTable TrafficInWithladBillDataTable = null; DataTable TrafficInDatatable = null; HPS.BLL.SettingsBLL.BLLSetting_TFactory settingsFactory = new HPS.BLL.SettingsBLL.BLLSetting_TFactory(); HPS.BLL.SettingsBLL.BLLSetting_TKeys SettingKey = null; HPS.BLL.SettingsBLL.BLLSetting_T TurnHourSettingEntity = null; HPS.BLL.SettingsBLL.BLLSetting_T SettingEntity = null; foreach (DataRow row in TrafficDataTable.Rows) { DataTable LaderTypeDataTable = new DataTable(); try { oldStopFeeEntity = new BLL.StopFeeBLL.BLLStopFee_T(); stopFeeKey = new BLL.StopFeeBLL.BLLStopFee_TKeys(); stopFeeKey.StopFeeID_int = Convert.ToInt32(row["StopFeeID_int"]); oldStopFeeEntity = stopFeeFactory.GetBy(stopFeeKey); if ((Int32)row["TrafficTypeID_int"] == 1) { laderTypeEntity = new BLL.LaderTypeBLL.BLLLaderType_T(); LaderTypeKey.LaderTypeID_int = Convert.ToInt32(row["LaderTypeID_int"]); laderTypeEntity = LaderTypeFactory.GetBy(LaderTypeKey); stopFeeCondition = string.Format(" StartDate_nvc>'{0}' AND StopFee_T.TrafficTypeID_int={1} AND StopFee_T.ServicesID_int={2} AND StopFee_T.LaderPivotGroupID_int={3}", oldStopFeeEntity.EndDate_nvc, Convert.ToInt32(row["TrafficTypeID_int"]), Convert.ToInt32(row["ServiceID_int"]), laderTypeEntity.LaderPivotGroupID_int); } else { stopFeeCondition = string.Format(" StartDate_nvc>'{0}' AND StopFee_T.TrafficTypeID_int={1}", oldStopFeeEntity.StartDate_nvc, Convert.ToInt32(row["TrafficTypeID_int"])); } var newStopFeeTable = new DataTable(); stopFeeFactory.GetAllByCondition(stopFeeCondition, ref newStopFeeTable); Hepsa.Core.Common.MyDateTime InDateTime = new Hepsa.Core.Common.MyDateTime(row["Date_nvc"].ToString()); Hepsa.Core.Common.MyDateTime OutDateTime = new Hepsa.Core.Common.MyDateTime(TrafficFactory.ServerJalaliDate); string InDate = InDateTime.MyDate.ToString("yyyy/MM/dd"); //+ " " + InTime_nvcTextBox.Text; string OutDate = OutDateTime.MyDate.ToString("yyyy/MM/dd"); // + " " + Time_nvcTextBox.Text; if (InDate.Length == 16) { InDate += ":00"; } else if (InDate.Length > 19) { InDate = InDate.Substring(0, 19); } if (OutDate.Length == 16) { OutDate += ":00"; } else if (OutDate.Length > 19) { OutDate = OutDate.Substring(0, 19); } decimal Price = Convert.ToDecimal(row["Fee_dec"]); if (Convert.ToInt32(row["ServiceID_int"]) == 2) { Price = row["Fee_dec"] != null?Convert.ToInt32(row["Fee_dec"]) : 0; } string incondition = "Traffic_T.TrafficNumber_bint='" + row["TrafficNumber_bint"].ToString() + "'"; Condition = string.Format("Traffic_T.TurnNumber_bint='{0}' And Traffic_T.TrafficNumber_bint<>{1}", row["TurnNumber_bint"], row["TrafficNumber_bint"].ToString()); TrafficInWithladBillDataTable = new DataTable(); LadBillFactory.GetAllWithTrafficLadBillCreditByConditon(incondition, ref TrafficInWithladBillDataTable); TrafficInDatatable = new DataTable(); TrafficFactory.GetAllByCondition(Condition, ref TrafficInDatatable); SettingKey = new HPS.BLL.SettingsBLL.BLLSetting_TKeys(); SettingKey.SettingID_int = 1002; TurnHourSettingEntity = settingsFactory.GetBy(SettingKey); if (TrafficInDatatable.Rows.Count > 0) { DateTime TrafficDate = DateTime.Parse((new Hepsa.Core.Common.MyDateTime(TrafficInDatatable.Rows[0]["Date_nvc"].ToString())).MyDate.ToString("yyyy/MM/dd") + " " + TrafficInDatatable.Rows[0]["Time_nvc"].ToString()); Int32 Allowablehour = Convert.ToInt32(TurnHourSettingEntity.Value_nvc); if (TrafficFactory.ServerDate <= TrafficDate.AddHours(Allowablehour)) { if (TrafficInWithladBillDataTable.Rows.Count == 0) { Price = 0; } } } decimal Balanced = 0; TimeSpan ts = new TimeSpan(); if (newStopFeeTable != null && newStopFeeTable.Rows.Count > 0) { //Hepsa.Core.Common.MyDateTime stopFeeMiladiEndDate_nvc = new Hepsa.Core.Common.MyDateTime(newStopFeeTable.Rows[0]["EndDate_nvc"].ToString()); //string stopFeeEndDate_nvc = stopFeeMiladiEndDate_nvc.MyDate.ToString("yyyy/MM/dd"); Hepsa.Core.Common.MyDateTime stopFeeMiladiEndDate_nvc = new Hepsa.Core.Common.MyDateTime(oldStopFeeEntity.EndDate_nvc); string stopFeeEndDate_nvc = stopFeeMiladiEndDate_nvc.MyDate.ToString("yyyy/MM/dd"); ts = DateTime.Parse(stopFeeEndDate_nvc).Subtract(DateTime.Parse(InDate)); if (Convert.ToBoolean(row["TurnAccepted_bit"]) == true) { double ExtraHour = ts.TotalHours; SettingEntity = new HPS.BLL.SettingsBLL.BLLSetting_T(); SettingKey.SettingID_int = 1002; SettingEntity = settingsFactory.GetBy(SettingKey); ExtraHour -= Convert.ToDouble(SettingEntity.Value_nvc); if (ExtraHour > 0) { ///محاسبه مازاد بر اساس قیمت قبلی از ورود تا شروع قیمت جدید int days = (int)(ExtraHour / Convert.ToInt32(row["ExtraHour_int"])); Price += Math.Floor(((decimal)(days)) * Convert.ToDecimal(row["ExtraHourFee_dec"])); } Hepsa.Core.Common.MyDateTime stopFeeMiladiStartDate_nvc = new Hepsa.Core.Common.MyDateTime(newStopFeeTable.Rows[0]["StartDate_nvc"].ToString()); string newStopFeeStartDate_nvc = stopFeeMiladiStartDate_nvc.MyDate.ToString("yyyy/MM/dd"); TimeSpan ExtaTS = DateTime.Parse(newStopFeeStartDate_nvc).Subtract(DateTime.Parse(InDate)); double ExtraExtraHour = ExtaTS.TotalHours; if (ExtraExtraHour < Convert.ToDouble(SettingEntity.Value_nvc)) { ///محاسبه مازاد از شروع تاریخ قیمت جدید تا تاریخ خروج if (ExtraHour >= 0) { ts = DateTime.Parse(OutDate).AddDays(1).Subtract(DateTime.Parse(InDate)); } else { ts = DateTime.Parse(OutDate).Subtract(DateTime.Parse(InDate)); } ExtraHour = ts.TotalHours - Convert.ToDouble(SettingEntity.Value_nvc); if (ExtraHour >= 0) { Int32 days = Convert.ToInt32((ExtraHour / Convert.ToInt32(newStopFeeTable.Rows[0]["ExtraHour_int"]))); Price += Math.Floor((Convert.ToDecimal((days)) * Convert.ToDecimal(newStopFeeTable.Rows[0]["ExtraHourFee_dec"]))); } } else { ///محاسبه مازاد از شروع تاریخ قیمت جدید تا تاریخ خروج //Hepsa.Core.Common.MyDateTime stopFeeMiladiStartDate_nvc = new Hepsa.Core.Common.MyDateTime(newStopFeeTable.Rows[0]["StartDate_nvc"].ToString()); //string newStopFeeStartDate_nvc = stopFeeMiladiStartDate_nvc.MyDate.ToString("yyyy/MM/dd"); //ts = DateTime.Parse(OutDate).AddDays(1).Subtract(DateTime.Parse(newStopFeeStartDate_nvc)); if (ExtraHour > 0) { ts = DateTime.Parse(OutDate).AddDays(1).Subtract(DateTime.Parse(newStopFeeStartDate_nvc)); } else { ts = DateTime.Parse(OutDate).Subtract(DateTime.Parse(newStopFeeStartDate_nvc)); } ExtraHour = ts.TotalHours; if (ExtraHour > 0) { Int32 days = Convert.ToInt32((ExtraHour / Convert.ToInt32(newStopFeeTable.Rows[0]["ExtraHour_int"]))); Price += Math.Floor((Convert.ToDecimal((days)) * Convert.ToDecimal(newStopFeeTable.Rows[0]["ExtraHourFee_dec"]))); } } } else { if (Convert.ToDecimal(row["ExtraHourFee_dec"]) != 0) { ///محاسبه مازاد بر اساس قیمت قبلی از ورود تا شروع قیمت جدید double ExtraHour = ts.TotalHours - Convert.ToDouble(row["AllowableHour_int"]); int days = Convert.ToInt32((ExtraHour / Convert.ToInt32(row["ExtraHour_int"]))); Price += Math.Floor(((decimal)(days)) * Convert.ToDecimal(row["ExtraHourFee_dec"])); ///محاسبه مازاد از شروع تاریخ قیمت جدید تا تاریخ خروج Hepsa.Core.Common.MyDateTime stopFeeMiladiStartDate_nvc = new Hepsa.Core.Common.MyDateTime(newStopFeeTable.Rows[0]["StartDate_nvc"].ToString()); string newStopFeeStartDate_nvc = stopFeeMiladiStartDate_nvc.MyDate.ToString("yyyy/MM/dd"); ts = DateTime.Parse(OutDate).AddDays(1).Subtract(DateTime.Parse(newStopFeeStartDate_nvc)); ExtraHour = ts.TotalHours; days = (int)(ExtraHour / (int)newStopFeeTable.Rows[0]["ExtraHour_int"]); Price += Math.Floor(((decimal)(days)) * Convert.ToDecimal(newStopFeeTable.Rows[0]["ExtraHourFee_dec"])); } } } else { ts = DateTime.Parse(OutDate).Subtract(DateTime.Parse(InDate)); if (ts.TotalHours > Convert.ToInt32(row["AllowableHour_int"])) { if (Convert.ToBoolean(row["TurnAccepted_bit"]) == true) { double ExtraHour = ts.TotalHours; SettingEntity = new BLL.SettingsBLL.BLLSetting_T(); SettingKey.SettingID_int = 1002; SettingEntity = settingsFactory.GetBy(SettingKey); ExtraHour -= Convert.ToDouble(SettingEntity.Value_nvc); if (ExtraHour > 0) { int days = (int)(ExtraHour / Convert.ToInt32(row["ExtraHour_int"])); Price += Math.Floor(((decimal)(days)) * Convert.ToDecimal(row["ExtraHourFee_dec"])); } //else //{ // Price = 0; //} } else { if (Convert.ToDecimal(row["ExtraHourFee_dec"]) != 0) { double ExtraHour = ts.TotalHours - Convert.ToDouble(row["AllowableHour_int"]); int days = (int)(ExtraHour / Convert.ToInt32(row["ExtraHour_int"])); Price += Math.Floor(((decimal)(days)) * Convert.ToDecimal(row["ExtraHourFee_dec"])); } } } } row["AllPayment_dec"] = Convert.ToString(Price);//+ Balanced if (Price == Balanced) { row["Remained_dec"] = "0"; } else { row["Remained_dec"] = Price - Convert.ToDecimal(row["Price_dec"]);// } if ((Price - Balanced) < 0) { row["Remained_dec"] = Convert.ToDecimal(row["Price_dec"]); } } catch (Exception ex) { Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message); } } //AllPayment_dec DataSource = TrafficDataTable; Datetxt.DataField = "Date_nvc"; Timetxt.DataField = "Time_nvc"; TurnNumbertxt.DataField = "TurnNumber_bint"; TrafficNumbertxt.DataField = "TrafficNumber_bint"; NumberPlateTextBox.DataField = "NumberPlate_nvc"; PlateCitytxt.DataField = "PlateCityID_intPlateCity_nvc"; SerialPlateTextBox.DataField = "SerialPlate_nvc"; CarCardNumbertxt.DataField = "CarCardNumber_nvc"; DriverCardNumbertxt.DataField = "DriverCardNumber_nvc"; Pricetxt.DataField = "Price_dec"; Usertxt.DataField = "UserName_nvc"; LastNametxt.DataField = "FullName_nvc"; TurnAcceptedchk.DataField = "TurnAccepted_bit"; ServiceType_nvctxt.DataField = "ServiceID_intServiceType_nvc"; DriverCardNumbertxt.DataField = "DriverInfraction_nvc"; CarInfractiontxt.DataField = "CarInfraction_nvc"; payment_dectxt.DataField = "AllPayment_dec"; remained_dectxt.DataField = "Remained_dec"; DateTextBox.Text = TrafficFactory.ServerJalaliDate; TimeTextBox.Text = TrafficFactory.ServerTime; UserNameTextBox.Text = HPS.Common.CurrentUser.user.UserName_nvc; decimal?AllPrice = (from row in TrafficDataTable.AsEnumerable() select(decimal?) row["Price_dec"]).Sum(); AllPricetxt.Text = AllPrice.HasValue ? AllPrice.ToString() : "0"; decimal?AllPayment_dec = (from row in TrafficDataTable.AsEnumerable() select(decimal?) row["AllPayment_dec"]).Sum(); allPayment_dectxt.Text = AllPayment_dec.HasValue ? AllPayment_dec.ToString() : "0"; decimal?AllRemained_dec = (from row in TrafficDataTable.AsEnumerable() select(decimal?) row["Remained_dec"]).Sum(); allRemained_dectxt.Text = AllRemained_dec.HasValue ? AllRemained_dec.ToString() : "0"; }
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.InServiceTypeWithPivoteReport rpt = new HPS.Reports.ReportDoc.InServiceTypeWithPivoteReport(FromDatefaDatePicker.Text, FromTimeTextBox.Text, ToDatefaDatePicker.Text, ToTimeTextBox.Text); //viewer1.Document = rpt.Document; //rpt.Document.Printer.PrinterName = string.Empty; //rpt.Run(); HPS.BLL.TrafficBLL.BLLTraffic_TFactory TrafficFactory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory(); InServiceTypeWithPivotestiReport.Dictionary.Synchronize(); InServiceTypeWithPivotestiReport.Dictionary.Databases.Clear(); InServiceTypeWithPivotestiReport.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("Connection", Hepsa.Core.Common.ConnectionString.ConnectionString)); InServiceTypeWithPivotestiReport.Compile(); HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory PortPlaceFactory = new HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory(); InServiceTypeWithPivotestiReport["organ"] = new HPS.BLL.SettingsBLL.BLLSetting_TFactory().GetBy(new BLL.SettingsBLL.BLLSetting_TKeys() { SettingID_int = 1029 }).Value_nvc.ToString(); InServiceTypeWithPivotestiReport["@FromDate_nvc"] = FromDatefaDatePicker.Text; InServiceTypeWithPivotestiReport["@FromTime_nvc"] = FromTimeTextBox.Text; InServiceTypeWithPivotestiReport["@ToDate_nvc"] = ToDatefaDatePicker.Text; InServiceTypeWithPivotestiReport["@ToTime_nvc"] = ToTimeTextBox.Text; InServiceTypeWithPivotestiReport["fromdate_vc"] = FromDatefaDatePicker.Text; InServiceTypeWithPivotestiReport["todate_vc"] = ToDatefaDatePicker.Text; InServiceTypeWithPivotestiReport["date_vc"] = PortPlaceFactory.ServerJalaliDate + " " + PortPlaceFactory.ServerTime;; InServiceTypeWithPivotestiReport["UserName_vc"] = HPS.Common.CurrentUser.user.UserName_nvc; InServiceTypeWithPivotestiReport["FromTime_vc"] = FromTimeTextBox.Text; InServiceTypeWithPivotestiReport["ToTime_vc"] = ToTimeTextBox.Text; InServiceTypeWithPivotestiReport.Render(); this.stiViewerControl1.Report = InServiceTypeWithPivotestiReport; } 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); } }