コード例 #1
0
        private void FillCombo()
        {
            HPS.BLL.LaderTypeBLL.BLLLaderType_TFactory LaderTypeFactory = new HPS.BLL.LaderTypeBLL.BLLLaderType_TFactory();
            DataTable LaderTypeDataTable = new DataTable();

            LaderTypeFactory.GetAll(ref LaderTypeDataTable);
            this.LaderTypecheckedComboBox.DropDownDataSource    = LaderTypeDataTable;
            this.LaderTypecheckedComboBox.DropDownDataMember    = "LaderType_T";
            this.LaderTypecheckedComboBox.DropDownDisplayMember = HPS.BLL.LaderTypeBLL.BLLLaderType_T.LaderType_TField.LaderType_nvc.ToString();
            this.LaderTypecheckedComboBox.DropDownValueMember   = HPS.BLL.LaderTypeBLL.BLLLaderType_T.LaderType_TField.LaderTypeID_int.ToString();
            LaderTypecheckedComboBox.RetrieveStructure();
            LaderTypecheckedComboBox.DropDownList.Columns[1].Visible = false;
            LaderTypecheckedComboBox.DropDownList.Columns[2].Visible = false;
            LaderTypecheckedComboBox.DropDownList.Columns[4].Visible = false;
            LaderTypecheckedComboBox.DropDownList.Columns[5].Visible = false;
            LaderTypecheckedComboBox.DropDownList.Columns[6].Visible = false;
            LaderTypecheckedComboBox.DropDownList.Columns[7].Visible = false;
            LaderTypecheckedComboBox.DropDownList.Columns[8].Visible = false;
            LaderTypecheckedComboBox.DropDownList.Columns[9].Visible = false;
            LaderTypecheckedComboBox.DropDownList.Columns[3].Caption = "نوع بارگیر";
            LaderTypecheckedComboBox.DropDownList.Columns[3].Width   = 300;


            this.FromDatefaDatePicker.SelectedDateTime = FarsiLibrary.Utils.PersianDateConverter.ToGregorianDateTime(LaderTypeFactory.ServerJalaliDate);
            this.ToDatefaDatePicker.SelectedDateTime   = FarsiLibrary.Utils.PersianDateConverter.ToGregorianDateTime(LaderTypeFactory.ServerJalaliDate);
        }
コード例 #2
0
        private void GroupTrafficReportForm_Load(object sender, EventArgs e)
        {
            HPS.BLL.LaderTypeBLL.BLLLaderType_TFactory LaderTypeFactory = new HPS.BLL.LaderTypeBLL.BLLLaderType_TFactory();
            DataTable LaderTypeDataTable = new DataTable();

            LaderTypeFactory.GetAll(ref LaderTypeDataTable);
            this.LaderTypecheckedComboBox.DropDownDataSource    = LaderTypeDataTable;
            this.LaderTypecheckedComboBox.DropDownDataMember    = "LaderType_T";
            this.LaderTypecheckedComboBox.DropDownDisplayMember = HPS.BLL.LaderTypeBLL.BLLLaderType_T.LaderType_TField.LaderType_nvc.ToString();
            this.LaderTypecheckedComboBox.DropDownValueMember   = HPS.BLL.LaderTypeBLL.BLLLaderType_T.LaderType_TField.LaderTypeID_int.ToString();
            LaderTypecheckedComboBox.RetrieveStructure();
            LaderTypecheckedComboBox.DropDownList.Columns[1].Visible  = false;
            LaderTypecheckedComboBox.DropDownList.Columns[2].Visible  = false;
            LaderTypecheckedComboBox.DropDownList.Columns[4].Visible  = false;
            LaderTypecheckedComboBox.DropDownList.Columns[5].Visible  = false;
            LaderTypecheckedComboBox.DropDownList.Columns[6].Visible  = false;
            LaderTypecheckedComboBox.DropDownList.Columns[7].Visible  = false;
            LaderTypecheckedComboBox.DropDownList.Columns[8].Visible  = false;
            LaderTypecheckedComboBox.DropDownList.Columns[9].Visible  = false;
            LaderTypecheckedComboBox.DropDownList.Columns[3].Caption  = "نوع بارگیر";
            LaderTypecheckedComboBox.DropDownList.Columns[10].Caption = "تعداد محور";
            LaderTypecheckedComboBox.DropDownList.Columns[3].Width    = 300;

            HPS.BLL.ServicesBLL.BLLServices_TFactory ServicesFactory = new HPS.BLL.ServicesBLL.BLLServices_TFactory();
            DataTable ServicesDataTable = new DataTable();
            string    condition         = "[Services_T].[Activie_bit]='true'";

            ServicesFactory.GetAllByCondition(condition, ref ServicesDataTable);
            ServicescheckedComboBox.DropDownDataSource    = ServicesDataTable;
            ServicescheckedComboBox.DropDownDataMember    = "";
            ServicescheckedComboBox.DropDownDisplayMember = HPS.BLL.ServicesBLL.BLLServices_T.Services_TField.ServicesType_nvc.ToString();
            ServicescheckedComboBox.DropDownValueMember   = HPS.BLL.ServicesBLL.BLLServices_T.Services_TField.ServicesID_int.ToString();
            ServicescheckedComboBox.RetrieveStructure();
            ServicescheckedComboBox.DropDownList.Columns[1].Visible = false;
            ServicescheckedComboBox.DropDownList.Columns[3].Visible = false;
            ServicescheckedComboBox.DropDownList.Columns[2].Caption = "نوع مراجعه";
            ServicescheckedComboBox.DropDownList.Columns[2].Width   = 300;

            this.FromDatefaDatePicker.SelectedDateTime = FarsiLibrary.Utils.PersianDateConverter.ToGregorianDateTime(LaderTypeFactory.ServerJalaliDate);
            this.ToDatefaDatePicker.SelectedDateTime   = FarsiLibrary.Utils.PersianDateConverter.ToGregorianDateTime(LaderTypeFactory.ServerJalaliDate);
        }
コード例 #3
0
 private void ExistsLaderyTypeButton_Click(object sender, EventArgs e)
 {
     try
     {
         HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory LadeAssignmentFactory = new HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory();
         DataTable LaderTypeReportTable = new DataTable();
         LadeAssignmentFactory.SelectLaderTypeCountWithDateReport(FromDatefaDatePicker.Text, FromTimeTextBox.Text, ToDatefaDatePicker.Text, ToTimeTextBox.Text, string.Empty, ref LaderTypeReportTable);
         DataTable dt = new DataTable();
         dt = LaderTypeReportTable.DefaultView.ToTable(true, "Ladertype_nvc", "LaderTypeID_int");
         this.LaderTypecheckedComboBox.DropDownDataSource    = null;
         this.LaderTypecheckedComboBox.DropDownDataSource    = dt;
         this.LaderTypecheckedComboBox.DropDownDataMember    = "LaderType_T";
         this.LaderTypecheckedComboBox.DropDownDisplayMember = HPS.BLL.LaderTypeBLL.BLLLaderType_T.LaderType_TField.LaderType_nvc.ToString();
         this.LaderTypecheckedComboBox.DropDownValueMember   = HPS.BLL.LaderTypeBLL.BLLLaderType_T.LaderType_TField.LaderTypeID_int.ToString();
         LaderTypecheckedComboBox.RetrieveStructure();
         LaderTypecheckedComboBox.DropDownList.Columns[2].Visible = false;
         LaderTypecheckedComboBox.DropDownList.Columns[1].Caption = "نوع بارگیر";
         LaderTypecheckedComboBox.DropDownList.Columns[1].Width   = 300;
     }
     catch (Exception ex)
     {
         Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message);
     }
 }
コード例 #4
0
        private void FillCombo()
        {
            HPS.BLL.LaderTypeBLL.BLLLaderType_TFactory LaderTypeID_intFactory = new HPS.BLL.LaderTypeBLL.BLLLaderType_TFactory();
            DataTable LaderTypeID_intDataTable = new DataTable();
            string    laderCondition           = "[LaderType_T].[Active_bit]='true'";

            LaderTypeID_intFactory.GetAllByCondition(laderCondition, ref LaderTypeID_intDataTable);
            this.LaderTypecheckedComboBox.DropDownDataSource    = LaderTypeID_intDataTable;
            this.LaderTypecheckedComboBox.DropDownDataMember    = "LaderType_T";
            this.LaderTypecheckedComboBox.DropDownDisplayMember = HPS.BLL.LaderTypeBLL.BLLLaderType_T.LaderType_TField.LaderType_nvc.ToString();
            this.LaderTypecheckedComboBox.DropDownValueMember   = HPS.BLL.LaderTypeBLL.BLLLaderType_T.LaderType_TField.LaderTypeID_int.ToString();
            LaderTypecheckedComboBox.RetrieveStructure();
            LaderTypecheckedComboBox.DropDownList.Columns[1].Visible  = false;
            LaderTypecheckedComboBox.DropDownList.Columns[2].Visible  = false;
            LaderTypecheckedComboBox.DropDownList.Columns[4].Visible  = false;
            LaderTypecheckedComboBox.DropDownList.Columns[3].Caption  = "بارگیر";
            LaderTypecheckedComboBox.DropDownList.Columns[3].Width    = 300;
            LaderTypecheckedComboBox.DropDownList.Columns[5].Visible  = false;
            LaderTypecheckedComboBox.DropDownList.Columns[6].Visible  = false;
            LaderTypecheckedComboBox.DropDownList.Columns[7].Visible  = false;
            LaderTypecheckedComboBox.DropDownList.Columns[8].Visible  = false;
            LaderTypecheckedComboBox.DropDownList.Columns[9].Visible  = false;
            LaderTypecheckedComboBox.DropDownList.Columns[10].Visible = false;
        }
コード例 #5
0
        private void FillCombo()
        {
            try
            {
                HPS.BLL.LaderTypeBLL.BLLLaderType_TFactory LaderTypeID_intFactory = new HPS.BLL.LaderTypeBLL.BLLLaderType_TFactory();
                DataTable LaderTypeID_intDataTable = new DataTable();
                string    laderCondition           = "[LaderType_T].[Active_bit]='true'";
                LaderTypeID_intFactory.GetAllByCondition(laderCondition, ref LaderTypeID_intDataTable);
                this.LaderTypecheckedComboBox.DropDownDataSource    = LaderTypeID_intDataTable;
                this.LaderTypecheckedComboBox.DropDownDataMember    = "LaderType_T";
                this.LaderTypecheckedComboBox.DropDownDisplayMember = HPS.BLL.LaderTypeBLL.BLLLaderType_T.LaderType_TField.LaderType_nvc.ToString();
                this.LaderTypecheckedComboBox.DropDownValueMember   = HPS.BLL.LaderTypeBLL.BLLLaderType_T.LaderType_TField.LaderTypeID_int.ToString();
                LaderTypecheckedComboBox.RetrieveStructure();
                LaderTypecheckedComboBox.DropDownList.Columns[1].Visible  = false;
                LaderTypecheckedComboBox.DropDownList.Columns[2].Visible  = false;
                LaderTypecheckedComboBox.DropDownList.Columns[4].Visible  = false;
                LaderTypecheckedComboBox.DropDownList.Columns[3].Caption  = "بارگیر";
                LaderTypecheckedComboBox.DropDownList.Columns[3].Width    = 300;
                LaderTypecheckedComboBox.DropDownList.Columns[5].Visible  = false;
                LaderTypecheckedComboBox.DropDownList.Columns[6].Visible  = false;
                LaderTypecheckedComboBox.DropDownList.Columns[7].Visible  = false;
                LaderTypecheckedComboBox.DropDownList.Columns[8].Visible  = false;
                LaderTypecheckedComboBox.DropDownList.Columns[9].Visible  = false;
                LaderTypecheckedComboBox.DropDownList.Columns[10].Visible = false;


                HPS.BLL.CompanyBLL.BLLCompany_TFactory CompanyID_intFactory = new HPS.BLL.CompanyBLL.BLLCompany_TFactory();
                DataTable CompanyID_intDataTable = new DataTable();
                string    CompanyCondition       = "[Company_T].[Active_bit]='true'";
                CompanyID_intFactory.GetAllByCondition(CompanyCondition, ref CompanyID_intDataTable);
                DataRow Companydr = CompanyID_intDataTable.NewRow();
                //Companydr["CompanyID_int"] = 0;
                //CompanyID_intDataTable.Rows.InsertAt(Companydr, 0);
                this.CompanyID_intcheckedComboBox.DropDownDataSource    = CompanyID_intDataTable;
                this.CompanyID_intcheckedComboBox.DropDownDataMember    = "Company_T";
                this.CompanyID_intcheckedComboBox.DropDownDisplayMember = HPS.BLL.CompanyBLL.BLLCompany_T.Company_TField.Company_nvc.ToString();
                this.CompanyID_intcheckedComboBox.DropDownValueMember   = HPS.BLL.CompanyBLL.BLLCompany_T.Company_TField.CompanyID_int.ToString();
                CompanyID_intcheckedComboBox.RetrieveStructure();
                CompanyID_intcheckedComboBox.DropDownList.Columns[1].Visible  = false;
                CompanyID_intcheckedComboBox.DropDownList.Columns[2].Visible  = false;
                CompanyID_intcheckedComboBox.DropDownList.Columns[4].Visible  = false;
                CompanyID_intcheckedComboBox.DropDownList.Columns[3].Caption  = "شرکت";
                CompanyID_intcheckedComboBox.DropDownList.Columns[3].Width    = 300;
                CompanyID_intcheckedComboBox.DropDownList.Columns[5].Visible  = false;
                CompanyID_intcheckedComboBox.DropDownList.Columns[6].Visible  = false;
                CompanyID_intcheckedComboBox.DropDownList.Columns[7].Visible  = false;
                CompanyID_intcheckedComboBox.DropDownList.Columns[8].Visible  = false;
                CompanyID_intcheckedComboBox.DropDownList.Columns[9].Visible  = false;
                CompanyID_intcheckedComboBox.DropDownList.Columns[10].Visible = false;
                CompanyID_intcheckedComboBox.DropDownList.Columns[11].Visible = false;
                CompanyID_intcheckedComboBox.DropDownList.Columns[12].Visible = false;
                CompanyID_intcheckedComboBox.DropDownList.Columns[13].Visible = false;
                CompanyID_intcheckedComboBox.DropDownList.Columns[14].Visible = false;
                CompanyID_intcheckedComboBox.DropDownList.Columns[15].Visible = false;
                CompanyID_intcheckedComboBox.DropDownList.Columns[16].Visible = false;
                CompanyID_intcheckedComboBox.DropDownList.Columns[17].Visible = false;
                CompanyID_intcheckedComboBox.DropDownList.Columns[18].Visible = false;


                HPS.BLL.LadBillCreditBLL.BLLLadBillCredit_TFactory LadBillCreditFactory = new HPS.BLL.LadBillCreditBLL.BLLLadBillCredit_TFactory();
                DataTable LadbillOrder1Table = new DataTable();
                LadBillCreditFactory.SelectLadBillCreditOrderColumn(LadbillOrder1Table);
                DataRow emptyRow1 = LadbillOrder1Table.NewRow();
                LadbillOrder1Table.Rows.InsertAt(emptyRow1, 0);
                this.Order1ComboBox.DisplayMember = "PropertyValue";
                this.Order1ComboBox.ValueMember   = "ColumnName";
                this.Order1ComboBox.DataSource    = LadbillOrder1Table;
                this.Order1ComboBox.SelectedIndex = 0;

                DataTable LadbillOrder2Table = new DataTable();
                LadBillCreditFactory.SelectLadBillCreditOrderColumn(LadbillOrder2Table);
                DataRow emptyRow2 = LadbillOrder2Table.NewRow();
                LadbillOrder2Table.Rows.InsertAt(emptyRow2, 0);
                this.Order2ComboBox.DisplayMember = "PropertyValue";
                this.Order2ComboBox.ValueMember   = "ColumnName";
                this.Order2ComboBox.DataSource    = LadbillOrder2Table;
                this.Order2ComboBox.SelectedIndex = 0;

                DataTable LadbillOrder3Table = new DataTable();
                LadBillCreditFactory.SelectLadBillCreditOrderColumn(LadbillOrder3Table);
                DataRow emptyRow3 = LadbillOrder3Table.NewRow();
                LadbillOrder3Table.Rows.InsertAt(emptyRow3, 0);
                this.Order3ComboBox.DisplayMember = "PropertyValue";
                this.Order3ComboBox.ValueMember   = "ColumnName";
                this.Order3ComboBox.DataSource    = LadbillOrder3Table;
                this.Order3ComboBox.SelectedIndex = 0;

                DataTable LadbillOrder4Table = new DataTable();
                LadBillCreditFactory.SelectLadBillCreditOrderColumn(LadbillOrder4Table);
                DataRow emptyRow4 = LadbillOrder4Table.NewRow();
                LadbillOrder4Table.Rows.InsertAt(emptyRow4, 0);
                this.Order4ComboBox.DisplayMember = "PropertyValue";
                this.Order4ComboBox.ValueMember   = "ColumnName";
                this.Order4ComboBox.DataSource    = LadbillOrder4Table;
                this.Order4ComboBox.SelectedIndex = 0;

                DataTable LadbillOrder5Table = new DataTable();
                LadBillCreditFactory.SelectLadBillCreditOrderColumn(LadbillOrder5Table);
                DataRow emptyRow5 = LadbillOrder5Table.NewRow();
                LadbillOrder5Table.Rows.InsertAt(emptyRow5, 0);
                this.Order5ComboBox.DisplayMember = "PropertyValue";
                this.Order5ComboBox.ValueMember   = "ColumnName";
                this.Order5ComboBox.DataSource    = LadbillOrder5Table;
                this.Order5ComboBox.SelectedIndex = 0;

                HPS.BLL.TrafficBLL.BLLTraffic_TFactory Factory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory();
                this.FromDatefaDatePicker.SelectedDateTime = FarsiLibrary.Utils.PersianDateConverter.ToGregorianDateTime(Factory.ServerJalaliDate);
                this.ToDatefaDatePicker.SelectedDateTime   = FarsiLibrary.Utils.PersianDateConverter.ToGregorianDateTime(Factory.ServerJalaliDate);
            }
            catch (Exception ex)
            {
                Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message);
            }
        }