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);
}
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);
}
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);
}
}
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;
}
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);
}
}