Beispiel #1
0
        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();
            }
        }
Beispiel #2
0
        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("نام کاربری و رمز عبور اشتباه می باشد");
            }
        }
Beispiel #3
0
        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;
        }
Beispiel #4
0
        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);
            }
        }
Beispiel #5
0
        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;
            }
        }
Beispiel #6
0
        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);
            }
        }
Beispiel #7
0
        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);
        }
Beispiel #8
0
 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);
     }
 }
Beispiel #9
0
        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)
            {
            }
        }
Beispiel #10
0
        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);
            }
        }
Beispiel #11
0
        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);
            }
        }
Beispiel #12
0
        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);
        }
Beispiel #13
0
        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);
            }
        }
Beispiel #14
0
        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);
            }
        }
Beispiel #15
0
        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);
                }
            }
        }
Beispiel #16
0
        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;
            }
        }
Beispiel #17
0
        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);
            }
        }
Beispiel #18
0
        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);
            }
        }
Beispiel #19
0
        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();
        }
Beispiel #20
0
        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;
                }
            }
        }
Beispiel #21
0
        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;
        }
Beispiel #22
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.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);
            }
        }
Beispiel #23
0
        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);
            }
        }
Beispiel #24
0
        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;
                }
            }
        }
Beispiel #25
0
        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);
            }
        }
Beispiel #26
0
        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);
            }
        }
Beispiel #27
0
        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);
            }
        }
Beispiel #28
0
        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";
        }
Beispiel #29
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);
            }
        }
Beispiel #30
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.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);
            }
        }