private void SetupFeaturesGrid()
{
featuresGrid.EnableFiltering = true;
featuresGrid.MasterTemplate.ShowFilteringRow = false;
featuresGrid.AllowAddNewRow = false;
featuresGrid.DataSource = dataSet.Tables["Issue"];
featuresGrid.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
featuresGrid.MasterTemplate.SelectLastAddedRow = true;
featuresGrid.Columns["ProjectId"].IsVisible = false;
featuresGrid.Columns["Type"].IsVisible = false;
featuresGrid.Columns["Description"].IsVisible = false;
featuresGrid.Columns["StepsToReproduce"].IsVisible = false;
featuresGrid.Columns["UserId"].IsVisible = false;
((GridViewDateTimeColumn)featuresGrid.Columns["Date"]).FormatString = "{0: dd/M/yyyy}";
GridViewComboBoxColumn comboCol = new GridViewComboBoxColumn();
comboCol.Name = "Owner";
comboCol.HeaderText = "Owner";
comboCol.DataSource = dataSet.Tables["User"];
comboCol.DisplayMember = "Name";
comboCol.ValueMember = "Id";
comboCol.FieldName = "UserId";
featuresGrid.Columns.Add(comboCol);
comboCol.MaxWidth = 70;
featuresGrid.Columns["Id"].MaxWidth = 20;
featuresGrid.Columns["Status"].MaxWidth = 80;
featuresGrid.Columns["Date"].MaxWidth = 70;
featuresGrid.Columns["Priority"].MaxWidth = 60;
featuresGrid.Columns["Title"].BestFit();
featuresGrid.FilterDescriptors.Clear();
FilterDescriptor filterByFeature = new FilterDescriptor();
filterByFeature.PropertyName = "Type";
filterByFeature.Operator = FilterOperator.IsEqualTo;
filterByFeature.Value = Type.Feature;
this.featuresGrid.FilterDescriptors.Add(filterByFeature);
}
private IEnumerable GetData()
{
if (Type == null)
{
return(null);
}
switch ((ColumnType)Type.Value)
{
case ColumnType.GridViewMultiColumnComboBoxColumn:
{
Description = "This is a demonstration of the GridViewMultiColumnComboBoxColumn.";
DescriptionHeader = "GridViewMultiColumnComboBoxColumn";
Columns.Clear();
List <Location> locations = new List <Location>();
for (int i = 0; i < 10; i++)
{
Location location = new Location();
location.ID = i;
location.CountryID = i;
location.Description = "Description" + i;
locations.Add(location);
}
List <Country> countries = new List <Country>();
for (int i = 0; i < 10; i++)
{
Country country = new Country();
country.ID = i;
country.Name = countryNames[i];
country.Capital = capitalNames[i];
country.Continent = continentNames[i];
countries.Add(country);
}
GridViewMultiColumnComboBoxColumn comboColumn = new GridViewMultiColumnComboBoxColumn();
comboColumn.Header = "Country ID & Name";
comboColumn.DataMemberBinding = new Binding("CountryID");
comboColumn.SelectedValuePath = "ID";
comboColumn.DisplayMemberPath = "Name";
comboColumn.ItemsSource = countries;
comboColumn.Width = new GridViewLength(1, GridViewLengthUnitType.Star);
comboColumn.DropDownWidth = 330;
comboColumn.DropDownHeight = 250;
Columns.Add(comboColumn);
GridViewDataColumn column = new GridViewDataColumn();
column.DataMemberBinding = new Binding("Description");
column.Width = new GridViewLength(1, GridViewLengthUnitType.Star);
Columns.Add(column);
return(locations);
}
case ColumnType.ComboBoxColumnBoundToString:
{
Description = "This is a demonstration of GridViewComboBoxColumn bound to a list of strings.";
DescriptionHeader = "ComboBoxColumn bound to string";
Columns.Clear();
List <Product> products = new List <Product>();
for (int i = 0; i < 10; i++)
{
Product product = new Product();
product.ID = i;
product.ProductName = String.Format("Product{0}", i);
products.Add(product);
}
GridViewComboBoxColumn column = new GridViewComboBoxColumn();
column.DataMemberBinding = new Binding("ProductName");
column.ItemsSource = from p in products
select p.ProductName;
column.Width = new GridViewLength(1, GridViewLengthUnitType.Star);
Columns.Add(column);
return(products);
}
case ColumnType.ComboBoxColumnBoundToObjectWithoutSelectedValueMemberPath:
{
Description = "This is a demonstration of GridViewComboBoxColumn bound to a list of objects without SelectedValueMemberPath set.";
DescriptionHeader = "ComboBoxColumn bound to Objects";
Columns.Clear();
List <Employee> employees = new List <Employee>();
for (int i = 0; i < 10; i++)
{
Employee employee = new Employee();
employee.Name = String.Format("Name{0}", i);
employees.Add(employee);
}
List <Position> positions = new List <Position>();
for (int i = 0; i < 10; i++)
{
Position position = new Position();
position.Description = String.Format("Description{0}", i);
position.Employee = employees[i];
positions.Add(position);
}
GridViewComboBoxColumn comboColumn = new GridViewComboBoxColumn();
comboColumn.DataMemberBinding = new Binding("Employee");
comboColumn.DisplayMemberPath = "Name";
comboColumn.ItemsSource = employees;
comboColumn.Width = new GridViewLength(1, GridViewLengthUnitType.Star);
Columns.Add(comboColumn);
GridViewDataColumn column = new GridViewDataColumn();
column.DataMemberBinding = new Binding("Description");
column.Width = new GridViewLength(1, GridViewLengthUnitType.Star);
Columns.Add(column);
return(positions);
}
case ColumnType.ComboBoxColumnBoundToEnum:
{
Description = "This is a demonstration of GridViewComboBoxColumn bound to a list of enum.";
DescriptionHeader = "ComboBoxColumn bound to Enum";
Columns.Clear();
List <Person> persons = new List <Person>();
Person person = new Person();
person.ID = 1;
person.Gender = Gender.Male;
persons.Add(person);
person = new Person();
person.ID = 2;
person.Gender = Gender.Female;
persons.Add(person);
List <Gender> AvailableGenders = new List <Gender>();
AvailableGenders.Add(Gender.Male);
AvailableGenders.Add(Gender.Female);
GridViewComboBoxColumn comboColumn = new GridViewComboBoxColumn();
comboColumn.DataMemberBinding = new Binding("Gender");
comboColumn.ItemsSource = AvailableGenders;
comboColumn.Width = new GridViewLength(1, GridViewLengthUnitType.Star);
Columns.Add(comboColumn);
return(persons);
}
case ColumnType.ComboBoxColumnBoundToObjectWithSelectedValueMemberPath:
{
Description = "This is a demonstration of GridViewComboBoxColumn bound to a list of objects with SelectedValueMemberPath set.";
DescriptionHeader = "ComboBoxColumn bound to Objects";
Columns.Clear();
List <Location> locations = new List <Location>();
for (int i = 0; i < 10; i++)
{
Location location = new Location();
location.ID = i;
location.CountryID = i;
locations.Add(location);
}
List <Country> countries = new List <Country>();
for (int i = 0; i < 10; i++)
{
Country country = new Country();
country.ID = i;
country.Name = countryNames[i];
countries.Add(country);
}
GridViewComboBoxColumn comboColumn = new GridViewComboBoxColumn();
comboColumn.DataMemberBinding = new Binding("CountryID");
comboColumn.SelectedValueMemberPath = "ID";
comboColumn.DisplayMemberPath = "Name";
comboColumn.ItemsSource = countries;
comboColumn.Width = new GridViewLength(1, GridViewLengthUnitType.Star);
Columns.Add(comboColumn);
return(locations);
}
}
return(null);
}
private void FormatChargesGrid()
{
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = "Id";
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = COLS.TransId;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = COLS.BookingId;
grdLister.Columns.Add(col);
GridViewDateTimeColumn colDt = new GridViewDateTimeColumn();
colDt.Name = "PickupDate";
colDt.ReadOnly = true;
col.ReadOnly = true;
colDt.HeaderText = "Pickup Date-Time";
grdLister.Columns.Add(colDt);
col = new GridViewTextBoxColumn();
col.ReadOnly = true;
col.HeaderText = "Job #";
col.Name = "RefNumber";
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.ReadOnly = true;
col.HeaderText = "Order No";
col.Name = "OrderNo";
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.ReadOnly = true;
col.HeaderText = "Booked By";
col.Name = COLS.BookedBy;
col.WrapText = true;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.HeaderText = "Pupil No";
col.Name = "PupilNo";
col.ReadOnly = true;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "Vehicle";
col.Name = "Vehicle";
col.ReadOnly = true;
grdLister.Columns.Add(col);
GridViewComboBoxColumn colCombo = new GridViewComboBoxColumn();
colCombo.Name = COLS.VehicleID;
colCombo.HeaderText = "Vehicle";
// colCombo.DataSource = General.GetQueryable<Fleet_VehicleType>(null).OrderBy(c => c.OrderNo).ToList();
// colCombo.DisplayMember = "VehicleType";
//// colCombo.ValueMember = "Id";
colCombo.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDownList;
colCombo.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
colCombo.DataType = typeof(int);
grdLister.Columns.Add(colCombo);
colCombo.IsVisible = false;
colCombo.ReadOnly = true;
col = new GridViewTextBoxColumn();
col.Name = COLS.Passenger;
col.HeaderText = "Passenger";
col.IsVisible = false;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Width = 900;
col.IsVisible = false;
col.ReadOnly = true;
col.WrapText = true;
col.Name = COLS.RemovalDescription;
col.HeaderText = "Description";
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "Pickup Point";
col.Name = "PickupPoint";
col.WrapText = true;
col.ReadOnly = true;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "Destination";
col.Name = "Destination";
col.WrapText = true;
col.ReadOnly = true;
grdLister.Columns.Add(col);
GridViewDecimalColumn colD = new GridViewDecimalColumn();
colD.DecimalPlaces = 2;
colD.Minimum = 0;
colD.HeaderText = "Charges";
colD.Name = "Charges";
colD.Maximum = 9999999;
colD.ReadOnly = true;
colD.FormatString = "{0:#,###0.00}";
colD.IsVisible = false;
grdLister.Columns.Add(colD);
colD = new GridViewDecimalColumn();
colD.DecimalPlaces = 2;
colD.Minimum = 0;
colD.HeaderText = "Fares";
colD.Name = "Fares";
colD.Maximum = 9999999;
colD.FormatString = "{0:#,###0.00}";
colD.ReadOnly = true;
colD.IsVisible = false;
grdLister.Columns.Add(colD);
colD = new GridViewDecimalColumn();
colD.DecimalPlaces = 2;
colD.Minimum = 0;
colD.HeaderText = "Parking";
colD.Name = "Parking";
colD.Maximum = 9999999;
colD.FormatString = "{0:#,###0.00}";
colD.IsVisible = false;
colD.ReadOnly = true;
grdLister.Columns.Add(colD);
colD = new GridViewDecimalColumn();
colD.DecimalPlaces = 2;
colD.Minimum = 0;
colD.HeaderText = "Waiting";
colD.Name = "Waiting";
colD.Maximum = 9999999;
colD.FormatString = "{0:#,###0.00}";
colD.IsVisible = false;
colD.ReadOnly = true;
grdLister.Columns.Add(colD);
colD = new GridViewDecimalColumn();
colD.DecimalPlaces = 2;
colD.Minimum = 0;
colD.HeaderText = "Extra Drop";
colD.Name = "ExtraDrop";
colD.Maximum = 9999999;
colD.FormatString = "{0:#,###0.00}";
colD.IsVisible = false;
colD.ReadOnly = true;
grdLister.Columns.Add(colD);
colD = new GridViewDecimalColumn();
colD.DecimalPlaces = 2;
colD.Minimum = 0;
colD.HeaderText = "Meet and Greet";
colD.Name = "MeetAndGreet";
colD.Maximum = 9999999;
colD.FormatString = "{0:#,###0.00}";
colD.IsVisible = false;
colD.ReadOnly = true;
grdLister.Columns.Add(colD);
colD = new GridViewDecimalColumn();
colD.DecimalPlaces = 2;
colD.Minimum = 0;
colD.HeaderText = "Congestion";
colD.Name = "CongtionCharge";
colD.Maximum = 9999999;
colD.FormatString = "{0:#,###0.00}";
colD.IsVisible = false;
colD.ReadOnly = true;
grdLister.Columns.Add(colD);
colD = new GridViewDecimalColumn();
colD.DecimalPlaces = 2;
colD.Minimum = 0;
colD.ReadOnly = true;
colD.HeaderText = "Total";
colD.Name = "Total";
colD.Maximum = 9999999;
colD.FormatString = "{0:#,###0.00}";
//colD.Expression = "Charges+Fares+Parking+Waiting+ExtraDrop+MeetAndGreet+CongtionCharge";
colD.Expression = "Fares";
colD.ReadOnly = true;
colD.IsVisible = false;
grdLister.Columns.Add(colD);
GridViewComboBoxColumn colPayment = new GridViewComboBoxColumn();
colPayment.Name = COLS.Payment_ID;
colPayment.HeaderText = "Status";
// colPayment.DataSource = General.GetQueryable<Invoice_PaymentType>(null).Where(c => c.Id == 1 || c.Id == 3).OrderBy(c => c.Id).ToList();
// colPayment.DisplayMember = "PaymentType";
// colPayment.ValueMember = "Id";
colPayment.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDownList;
colPayment.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
colPayment.DataType = typeof(int);
colPayment.IsVisible = false;
grdLister.Columns.Add(colPayment);
colPayment.ReadOnly = true;
(grdLister.Columns["PickUpDate"] as GridViewDateTimeColumn).CustomFormat = "dd/MM/yyyy HH:mm";
(grdLister.Columns["PickUpDate"] as GridViewDateTimeColumn).FormatString = "{0:dd/MM/yyyy HH:mm}";
grdLister.Columns["PickUpDate"].Width = 105;
grdLister.Columns["RefNumber"].Width = 40;
grdLister.Columns["Vehicle"].Width = 60;
grdLister.Columns[COLS.Passenger].Width = 60;
grdLister.Columns["PickUpPoint"].Width = 120;
grdLister.Columns["Destination"].Width = 120;
grdLister.Columns["Charges"].Width = 50;
grdLister.Columns["Parking"].Width = 45;
grdLister.Columns["Waiting"].Width = 50;
grdLister.Columns["ExtraDrop"].Width = 60;
grdLister.Columns["MeetAndGreet"].Width = 50;
grdLister.Columns["CongtionCharge"].Width = 60;
grdLister.Columns["Total"].Width = 45;
grdLister.Columns["OrderNo"].Width = 55;
grdLister.Columns["PickUpDate"].HeaderText = "Pickup Date-Time";
grdLister.Columns["RefNumber"].HeaderText = "Ref #";
grdLister.Columns["PickUpPoint"].HeaderText = "Pickup Point";
grdLister.Columns["ExtraDrop"].HeaderText = "Extra Drop";
grdLister.Columns["MeetAndGreet"].HeaderText = "M & G";
grdLister.Columns["CongtionCharge"].HeaderText = "Congestion";
grdLister.Columns["Payment_ID"].Width = 70;
//AddUpdateColumn(grdLister);
grdLister.AddDeleteColumn();
}
private GridViewDataColumn AppendNewColumn(string columnType, bool numberInTheHeader)
{
GridViewDataColumn newColumn = null;
switch (columnType)
{
case "Text":
newColumn = new GridViewTextBoxColumn();
newColumn.FieldName = "Text";
break;
case "NumericText":
newColumn = new GridViewMaskBoxColumn();
((GridViewMaskBoxColumn)newColumn).Mask = "f";
newColumn.TextAlignment = ContentAlignment.MiddleLeft;
newColumn.FieldName = "NumericText";
break;
case "Decimal":
newColumn = new GridViewDecimalColumn();
newColumn.TextAlignment = ContentAlignment.MiddleRight;
newColumn.FieldName = "Decimal";
break;
case "DateTime":
newColumn = new GridViewDateTimeColumn();
newColumn.FormatString = "{0:MM-dd-yyyy}";
newColumn.TextAlignment = ContentAlignment.MiddleRight;
newColumn.FieldName = "DateTime";
break;
case "Image":
newColumn = new GridViewImageColumn();
((GridViewImageColumn)newColumn).ImageLayout = ImageLayout.Center;
newColumn.Width = 40;
newColumn.FieldName = "Image";
break;
case "ComboBox":
newColumn = new GridViewComboBoxColumn();
((GridViewComboBoxColumn)newColumn).DataSource = this.comboItems;
newColumn.Width = 100;
newColumn.FieldName = "ComboBox";
break;
case "Command":
newColumn = new GridViewCommandColumn();
((GridViewCommandColumn)newColumn).TextAlignment = ContentAlignment.MiddleCenter;
newColumn.FieldName = "Command";
break;
case "CheckBox":
newColumn = new GridViewCheckBoxColumn();
newColumn.Width = 50;
newColumn.FieldName = "CheckBox";
break;
}
if (numberInTheHeader)
{
newColumn.HeaderText = (this.columnNum++).ToString() + " - " + columnType;
}
else
{
newColumn.HeaderText = columnType;
}
this.radGridView1.Columns.Add(newColumn);
return(newColumn);
}
public Form1()
{
InitializeComponent();
this.radGridView1.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
fullList = new BindingList <Food>();
fullList.Add(new Food(0, "Onion"));
fullList.Add(new Food(1, "Cucumber"));
fullList.Add(new Food(2, "Tomato"));
fullList.Add(new Food(3, "Peach"));
fullList.Add(new Food(4, "Banana"));
fullList.Add(new Food(5, "Grape"));
fruitsList = new BindingList <Food>();
fruitsList.Add(fullList[3]);
fruitsList.Add(fullList[4]);
fruitsList.Add(fullList[5]);
vegetablesList = new BindingList <Food>();
vegetablesList.Add(fullList[0]);
vegetablesList.Add(fullList[1]);
vegetablesList.Add(fullList[2]);
BindingList <FoodType> typesList = new BindingList <FoodType>();
typesList.Add(new FoodType(0, "Vegetables"));
typesList.Add(new FoodType(1, "Fruits"));
GridViewComboBoxColumn foodType = new GridViewComboBoxColumn();
foodType.FieldName = "FoodType";
this.radGridView1.Columns.Add(foodType);
foodType.DataSource = typesList;
foodType.Width = 100;
foodType.DisplayMember = "FoodTypeName";
foodType.ValueMember = "FoodTypeID";
GridViewComboBoxColumn food = new GridViewComboBoxColumn();
food.FieldName = "Food";
this.radGridView1.Columns.Add(food);
food.DataSource = fullList;
food.Width = 100;
food.DisplayMember = "FoodName";
food.ValueMember = "FoodID";
this.radGridView1.Rows.Add(new object[] { 0, 1 });
this.radGridView1.Rows.Add(new object[] { 1, 4 });
this.radGridView1.Rows.Add(new object[] { 1, 3 });
this.radGridView1.Rows.Add(new object[] { 0, 0 });
this.radGridView1.Rows.Add(new object[] { 0, 2 });
this.radGridView1.Rows.Add(new object[] { 0, 1 });
this.radGridView1.Rows.Add(new object[] { 1, 4 });
this.radGridView1.Rows.Add(new object[] { 1, 3 });
this.radGridView1.Rows.Add(new object[] { 0, 0 });
this.radGridView1.Rows.Add(new object[] { 0, 2 });
this.radGridView1.Rows.Add(new object[] { 0, 1 });
this.radGridView1.Rows.Add(new object[] { 1, 4 });
this.radGridView1.Rows.Add(new object[] { 1, 3 });
this.radGridView1.Rows.Add(new object[] { 0, 0 });
this.radGridView1.Rows.Add(new object[] { 0, 2 });
this.radGridView1.CellEditorInitialized += new Telerik.WinControls.UI.GridViewCellEventHandler(radGridView1_CellEditorInitialized);
this.radGridView1.CellValueChanged += new GridViewCellEventHandler(radGridView1_CellValueChanged);
}
private void fmScholarship_Load(object sender, EventArgs e)
{
ScholarshipServiceClient sService = new ScholarshipServiceClient();
// fee = new List<Fee>(sService.GetAllFees());
colFee = new GridViewComboBoxColumn("Fee");
colFee.HeaderText = "Fee";
colFee.FieldName = "FeeID";
colFee.ValueMember = "FeeID";
colFee.DisplayMember = "FeeDescription";
colFee.Width = 180;
// colFee.DataSource = fee;
gvScholarshipDetails.Columns.Add(colFee);
if (Op.Equals("edit"))
{
SetField();
SetScholarshipDiscountGrid();
}
if (Op.Equals("new"))
{
BindScholarshipDiscountGrid();
gvScholarshipDetails.Enabled = false;
}
}
private void dataschemaGridbinding()
{
object obj;
try
{
DataTable item = this.clsDSOBJ.fnGetTreDetailsSchema(this.ddlTableName.SelectedValue.ToString());
DataTable dataTable = this.clsDSOBJ.fnGetCalaculatedColMappingData(Common.iProjectID, Common.strTableName);
DataTable dataTable1 = this.clsDSOBJ.fnGetColMappingData(Common.iProjectID);
item.Columns.Add(new DataColumn("Table", typeof(string)));
item.Columns.Add(new DataColumn("Type", typeof(int)));
item.Columns.Add(new DataColumn("Required", typeof(bool)));
foreach (DataRow row in dataTable.Rows)
{
DataRow str = item.NewRow();
str["ColumnName"] = row["COLNAME"].ToString();
str["Table"] = "C";
DataRow dataRow = str;
if (row["COLDATATYPE"].ToString() == "NUMBER" || row["COLDATATYPE"].ToString() == "double")
{
obj = typeof(decimal);
}
else
{
obj = (row["COLDATATYPE"].ToString() == "DATE" ? typeof(DateTime) : typeof(string));
}
dataRow["DataType"] = obj;
item.Rows.Add(str);
}
for (int i = 0; i < item.Rows.Count; i++)
{
if (dataTable1.Rows.Count <= 0)
{
item.Rows[i]["Type"] = 5;
if (item.Rows[i]["Table"] != null && item.Rows[i]["Table"] != "C")
{
item.Rows[i]["Table"] = "M";
}
item.Rows[i]["Required"] = false;
}
else
{
DataRow[] dataRowArray = dataTable1.Select(string.Concat("COLNAME='", item.Rows[i][0].ToString(), "'"));
if ((int)dataRowArray.Length <= 0 || !(dataRowArray[0]["TABLENAME"].ToString().ToLower() == this.ddlTableName.SelectedValue.ToString().ToLower()))
{
item.Rows[i]["Type"] = 5;
if (item.Rows[i]["Table"].ToString() != "C")
{
item.Rows[i]["Table"] = "M";
}
item.Rows[i]["Required"] = false;
}
else
{
item.Rows[i]["Type"] = dataRowArray[0]["Type"];
item.Rows[i]["Required"] = dataRowArray[0]["ISREQUIRED"];
if (item.Rows[i]["Table"].ToString() != "C")
{
item.Rows[i]["Table"] = "M";
}
}
}
}
this.dataschemaGrid.DataSource = item;
GridViewComboBoxColumn gridViewComboBoxColumn = new GridViewComboBoxColumn()
{
HeaderText = "Type",
ValueMember = "TypeId",
DisplayMember = "Type",
FieldName = "Type",
DataSource = this.clsDSOBJ.fnCreateColTypes(),
Width = 200
};
if (this.dataschemaGrid.MasterTemplate.Columns.Contains("Type1"))
{
this.dataschemaGrid.MasterTemplate.Columns.Remove("Type1");
}
this.dataschemaGrid.MasterTemplate.Columns.Add(gridViewComboBoxColumn);
this.dataschemaGrid.Columns["ColumnName"].ReadOnly = true;
this.dataschemaGrid.Columns["DataType"].ReadOnly = true;
this.dataschemaGrid.Columns["Type"].ReadOnly = true;
this.dataschemaGrid.Columns["Type"].IsVisible = false;
this.dataschemaGrid.Columns["Table"].IsVisible = true;
this.dataschemaGrid.Columns[0].Width = 200;
this.dataschemaGrid.Columns["DataType"].Width = 300;
this.dataschemaGrid.Columns["Required"].Width = 50;
this.dataschemaGrid.Columns["Table"].Width = 30;
this.dataschemaGrid.Columns.Remove("NumericPrecision");
this.dataschemaGrid.Columns.Remove("NumericScale");
this.dataschemaGrid.Columns.Remove("ProviderType");
this.dataschemaGrid.Columns.Remove("IsLong");
this.dataschemaGrid.Columns.Remove("AllowDBNull");
this.dataschemaGrid.Columns.Remove("IsReadOnly");
this.dataschemaGrid.Columns.Remove("IsUnique");
this.dataschemaGrid.Columns.Remove("IsKey");
this.dataschemaGrid.Columns.Remove("IsAutoIncrement");
this.dataschemaGrid.Columns.Remove("IsRowVersion");
this.dataschemaGrid.Columns.Remove("ColumnMapping");
this.dataschemaGrid.Columns.Remove("AutoIncrementSeed");
this.dataschemaGrid.Columns.Remove("AutoIncrementStep");
this.dataschemaGrid.Columns.Remove("BaseCatalogName");
this.dataschemaGrid.Columns.Remove("BaseSchemaName");
this.dataschemaGrid.Columns.Remove("BaseTableName");
this.dataschemaGrid.Columns.Remove("BaseTableNameSpace");
this.dataschemaGrid.Columns.Remove("BaseColumnName");
this.dataschemaGrid.Columns.Remove("BaseColumnNameSpace");
this.dataschemaGrid.Columns.Remove("Expression");
this.dataschemaGrid.Columns.Remove("DefaultValue");
this.dataschemaGrid.Columns.Remove("ColumnOrdinal");
this.dataschemaGrid.Columns.Remove("ColumnSize");
this.dataschemaGrid.MasterTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
this.dataschemaGrid.CellValueChanged += new GridViewCellEventHandler(this.dataschemaGrid_CellValueChanged);
}
catch (Exception exception)
{
throw exception;
}
}
private void frmManageSubject_Load(object sender, EventArgs e)
{
LearningAreaServiceClient laService = new LearningAreaServiceClient();
GradeLevelServiceClient glService = new GradeLevelServiceClient();
gradeLevel = new List<GradeLevel>(glService.GetAllGradeLevels());
if (gradeLevel.Count < 1)
gvSubjects.Enabled = false;
colGradeLevel = new GridViewComboBoxColumn("GradeLevel");
//colGradeLevel
colGradeLevel.HeaderText = "Grade Level";
colGradeLevel.FieldName = "GradeLevel";
colGradeLevel.ValueMember = "GradeLev";
colGradeLevel.DisplayMember = "Description";
colGradeLevel.Width = 115;
colGradeLevel.DataSource = gradeLevel;
gvSubjects.Columns.Add(colGradeLevel);
if (Op.Equals("edit"))
{
SetFields();
SetSubjectGrid();
}
if (Op.Equals("new"))
{
BindSubjectGrid();
}
}
private void InitializeComponent()
{
GridViewComboBoxColumn viewComboBoxColumn1 = new GridViewComboBoxColumn();
GridViewTextBoxColumn viewTextBoxColumn1 = new GridViewTextBoxColumn();
GridViewTextBoxColumn viewTextBoxColumn2 = new GridViewTextBoxColumn();
GridViewTextBoxColumn viewTextBoxColumn3 = new GridViewTextBoxColumn();
GridViewTextBoxColumn viewTextBoxColumn4 = new GridViewTextBoxColumn();
GridViewTextBoxColumn viewTextBoxColumn5 = new GridViewTextBoxColumn();
GridViewComboBoxColumn viewComboBoxColumn2 = new GridViewComboBoxColumn();
GridViewTextBoxColumn viewTextBoxColumn6 = new GridViewTextBoxColumn();
GridViewTextBoxColumn viewTextBoxColumn7 = new GridViewTextBoxColumn();
GridViewTextBoxColumn viewTextBoxColumn8 = new GridViewTextBoxColumn();
GridViewTextBoxColumn viewTextBoxColumn9 = new GridViewTextBoxColumn();
GridViewTextBoxColumn viewTextBoxColumn10 = new GridViewTextBoxColumn();
GridViewDateTimeColumn viewDateTimeColumn = new GridViewDateTimeColumn();
ComponentResourceManager componentResourceManager = new ComponentResourceManager(typeof(frmWorkItems));
this.dgvWorkItems = new RadGridView();
this.TableLayoutPanel1 = new TableLayoutPanel();
this.btnStartInspection = new Button();
this.dgvWorkItems.BeginInit();
this.dgvWorkItems.MasterTemplate.BeginInit();
this.TableLayoutPanel1.SuspendLayout();
this.SuspendLayout();
this.dgvWorkItems.BackColor = SystemColors.Control;
this.TableLayoutPanel1.SetColumnSpan((Control)this.dgvWorkItems, 2);
this.dgvWorkItems.Cursor = Cursors.Default;
this.dgvWorkItems.Dock = DockStyle.Fill;
this.dgvWorkItems.Font = new Font("Segoe UI", 8.25f);
this.dgvWorkItems.ForeColor = SystemColors.ControlText;
this.dgvWorkItems.ImeMode = ImeMode.NoControl;
this.dgvWorkItems.Location = new Point(3, 3);
this.dgvWorkItems.MasterTemplate.AllowAddNewRow = false;
this.dgvWorkItems.MasterTemplate.AllowDragToGroup = false;
this.dgvWorkItems.MasterTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
viewComboBoxColumn1.FieldName = "Status";
viewComboBoxColumn1.HeaderText = "Status";
viewComboBoxColumn1.Name = "Status";
viewComboBoxColumn1.Width = 75;
viewTextBoxColumn1.FieldName = "FacilityDesc";
viewTextBoxColumn1.HeaderText = "Building";
viewTextBoxColumn1.Name = "Building";
viewTextBoxColumn1.ReadOnly = true;
viewTextBoxColumn1.Width = 76;
viewTextBoxColumn2.FieldName = "SYS_DESC";
viewTextBoxColumn2.HeaderText = "System";
viewTextBoxColumn2.Name = "System";
viewTextBoxColumn2.ReadOnly = true;
viewTextBoxColumn2.Width = 76;
viewTextBoxColumn3.FieldName = "COMP_DESC";
viewTextBoxColumn3.HeaderText = "Component";
viewTextBoxColumn3.Name = "Component";
viewTextBoxColumn3.ReadOnly = true;
viewTextBoxColumn3.Width = 82;
viewTextBoxColumn4.FieldName = "SectionDesc";
viewTextBoxColumn4.HeaderText = "Section";
viewTextBoxColumn4.Name = "Section";
viewTextBoxColumn4.ReadOnly = true;
viewTextBoxColumn4.Width = 76;
viewTextBoxColumn5.FieldName = "Activity_Name";
viewTextBoxColumn5.HeaderText = "Activity";
viewTextBoxColumn5.Name = "ActivityName";
viewTextBoxColumn5.ReadOnly = true;
viewTextBoxColumn5.Width = 76;
viewComboBoxColumn2.FieldName = "InspectionTypeLink";
viewComboBoxColumn2.HeaderText = "Inspection Type";
viewComboBoxColumn2.Name = "InspectionType";
viewComboBoxColumn2.ReadOnly = true;
viewComboBoxColumn2.Width = 101;
viewTextBoxColumn6.AllowGroup = false;
viewTextBoxColumn6.EnableExpressionEditor = false;
viewTextBoxColumn6.FieldName = "WorkItemId";
viewTextBoxColumn6.HeaderText = "WorkItemId";
viewTextBoxColumn6.IsVisible = false;
viewTextBoxColumn6.Name = "WorkItemId";
viewTextBoxColumn6.ReadOnly = true;
viewTextBoxColumn6.VisibleInColumnChooser = false;
viewTextBoxColumn6.Width = 67;
viewTextBoxColumn7.AllowGroup = false;
viewTextBoxColumn7.EnableExpressionEditor = false;
viewTextBoxColumn7.FieldName = "FiscalYear";
viewTextBoxColumn7.HeaderText = "Fiscal Year";
viewTextBoxColumn7.Name = "FiscalYear";
viewTextBoxColumn7.ReadOnly = true;
viewTextBoxColumn7.Width = 76;
viewTextBoxColumn8.AllowGroup = false;
viewTextBoxColumn8.EnableExpressionEditor = false;
viewTextBoxColumn8.FieldName = "CompletionYear";
viewTextBoxColumn8.HeaderText = "Completion Year";
viewTextBoxColumn8.Name = "CompletionYear";
viewTextBoxColumn8.ReadOnly = true;
viewTextBoxColumn8.Width = 106;
viewTextBoxColumn9.AllowGroup = false;
viewTextBoxColumn9.EnableExpressionEditor = false;
viewTextBoxColumn9.FieldName = "Description";
viewTextBoxColumn9.HeaderText = "Description";
viewTextBoxColumn9.Name = "Description";
viewTextBoxColumn9.ReadOnly = true;
viewTextBoxColumn9.Width = 79;
viewTextBoxColumn10.AllowGroup = false;
viewTextBoxColumn10.EnableExpressionEditor = false;
viewTextBoxColumn10.FieldName = "SectionLink";
viewTextBoxColumn10.HeaderText = "SectionLink";
viewTextBoxColumn10.IsVisible = false;
viewTextBoxColumn10.Name = "SectionLink";
viewTextBoxColumn10.ReadOnly = true;
viewTextBoxColumn10.VisibleInColumnChooser = false;
viewDateTimeColumn.DateTimeKind = DateTimeKind.Local;
viewDateTimeColumn.FieldName = "DateCompleted";
viewDateTimeColumn.HeaderText = "DateCompleted";
viewDateTimeColumn.Name = "DateCompleted";
viewDateTimeColumn.ReadOnly = true;
viewDateTimeColumn.Width = 169;
this.dgvWorkItems.MasterTemplate.Columns.AddRange((GridViewDataColumn)viewComboBoxColumn1, (GridViewDataColumn)viewTextBoxColumn1, (GridViewDataColumn)viewTextBoxColumn2, (GridViewDataColumn)viewTextBoxColumn3, (GridViewDataColumn)viewTextBoxColumn4, (GridViewDataColumn)viewTextBoxColumn5, (GridViewDataColumn)viewComboBoxColumn2, (GridViewDataColumn)viewTextBoxColumn6, (GridViewDataColumn)viewTextBoxColumn7, (GridViewDataColumn)viewTextBoxColumn8, (GridViewDataColumn)viewTextBoxColumn9, (GridViewDataColumn)viewTextBoxColumn10, (GridViewDataColumn)viewDateTimeColumn);
this.dgvWorkItems.MasterTemplate.EnableAlternatingRowColor = true;
this.dgvWorkItems.MasterTemplate.EnableFiltering = true;
this.dgvWorkItems.MasterTemplate.EnableGrouping = false;
this.dgvWorkItems.MasterTemplate.ShowHeaderCellButtons = true;
this.dgvWorkItems.Name = "dgvWorkItems";
this.dgvWorkItems.RightToLeft = RightToLeft.No;
this.dgvWorkItems.ShowGroupPanel = false;
this.dgvWorkItems.ShowHeaderCellButtons = true;
this.dgvWorkItems.Size = new Size(1002, 431);
this.dgvWorkItems.TabIndex = 0;
this.dgvWorkItems.Text = "RadGridView1";
this.TableLayoutPanel1.ColumnCount = 2;
this.TableLayoutPanel1.ColumnStyles.Add(new ColumnStyle(SizeType.Percent, 100f));
this.TableLayoutPanel1.ColumnStyles.Add(new ColumnStyle());
this.TableLayoutPanel1.Controls.Add((Control)this.dgvWorkItems, 0, 0);
this.TableLayoutPanel1.Controls.Add((Control)this.btnStartInspection, 1, 1);
this.TableLayoutPanel1.Dock = DockStyle.Fill;
this.TableLayoutPanel1.Location = new Point(0, 0);
this.TableLayoutPanel1.Name = "TableLayoutPanel1";
this.TableLayoutPanel1.RowCount = 2;
this.TableLayoutPanel1.RowStyles.Add(new RowStyle(SizeType.Percent, 100f));
this.TableLayoutPanel1.RowStyles.Add(new RowStyle());
this.TableLayoutPanel1.Size = new Size(1008, 466);
this.TableLayoutPanel1.TabIndex = 1;
this.btnStartInspection.Location = new Point(903, 440);
this.btnStartInspection.Name = "btnStartInspection";
this.btnStartInspection.Size = new Size(102, 23);
this.btnStartInspection.TabIndex = 1;
this.btnStartInspection.Text = "Start Inspection";
this.btnStartInspection.UseVisualStyleBackColor = true;
this.AutoScaleDimensions = new SizeF(6f, 13f);
this.AutoScaleMode = AutoScaleMode.Font;
this.ClientSize = new Size(1008, 466);
this.Controls.Add((Control)this.TableLayoutPanel1);
this.Icon = (Icon)componentResourceManager.GetObject("$this.Icon");
this.Name = nameof(frmWorkItems);
this.Text = "Work Items";
this.dgvWorkItems.MasterTemplate.EndInit();
this.dgvWorkItems.EndInit();
this.TableLayoutPanel1.ResumeLayout(false);
this.ResumeLayout(false);
}
public RadFrmUsersMaintenance()
{
InitializeComponent();
//GridViewComboBoxColumn LegalEntity1 = new GridViewComboBoxColumn("LegalEntity1");
////set the column data source - the possible column values
//LegalEntity1.DataSource = new String[] { "Business", "Individual" };
//LegalEntity1.ValueMember = "LegalEntity";
//LegalEntity1.DisplayMember = "LegalEntity";
////set the FieldName - the column will retrieve the value from "Phone" column in the data table
//LegalEntity1.FieldName = "LegalEntity";
////add the column to the grid
//radGridView1.Columns.Add(LegalEntity1);
//GridViewComboBoxColumn IsActive = new GridViewComboBoxColumn("IsActive");
////set the column data source - the possible column values
//IsActive.DataSource = new String[] { "Yes", "No" };
//IsActive.ValueMember = "IsActive";
//IsActive.DisplayMember = "IsActive";
////set the FieldName - the column will retrieve the value from "Phone" column in the data table
//IsActive.FieldName = "IsActive";
////add the column to the grid
//radGridView1.Columns.Add(IsActive);
bool hasRows = LoadUsers();
this.radGridView1.MasterTemplate.AutoGenerateColumns = false;
GridViewComboBoxColumn Name = new GridViewComboBoxColumn("Name");
//set the column data source - the possible column values
Name.DataSource = DSusers.Tables["dtUsers"];
Name.ValueMember = "Name";
Name.DisplayMember = "Name";
//set the FieldName - the column will retrieve the value from "Phone" column in the data table
Name.FieldName = "Name";
//add the column to the grid
radGridView1.Columns.Add(Name);
//this.radGridView1.DataSource = DSusers.Tables["tbUsers"];
//create the combo box column
GridViewComboBoxColumn comboColumn = new GridViewComboBoxColumn("IsTxmMsgActive");
//set the column data source - the possible column values
comboColumn.DataSource = new String[] { "Yes", "No" };
//set the FieldName - the column will retrieve the value from "Phone" column in the data table
comboColumn.FieldName = "IsTxmMsgActive";
//add the column to the grid
radGridView1.Columns.Add(comboColumn);
//GridViewComboBoxColumn IsTxmMsgActive = new GridViewComboBoxColumn("IsTxmMsgActive");
////set the column data source - the possible column values
//IsTxmMsgActive.DataSource = new String[] { "Yes", "No" };
//IsTxmMsgActive.ValueMember = "IsTxmMsgActive";
//IsTxmMsgActive.DisplayMember = "IsTxmMsgActive";
////set the FieldName - the column will retrieve the value from "Phone" column in the data table
//IsTxmMsgActive.FieldName = "IsTxmMsgActive";
//IsTxmMsgActive.GetLookupValue("IsTxmMsgActive");
////add the column to the grid
//radGridView1.Columns.Add(IsTxmMsgActive);
//GridViewComboBoxColumn IsActive = new GridViewComboBoxColumn("IsActive");
////set the column data source - the possible column values
//IsActive.DataSource = new String[] { "Yes", "No" };
//IsActive.ValueMember = "IsActive";
//IsActive.DisplayMember = "IsActive";
////set the FieldName - the column will retrieve the value from "Phone" column in the data table
//IsActive.FieldName = "IsActive";
////add the column to the grid
//radGridView1.Columns.Add(IsActive);
}
private void OrderNewForm_Load(object sender, EventArgs e)
{
var source = new BindingSource();
source.Add(new ЗаказПокупателяТаблЧасть());
this.radGridView1.DataSource = source;
this.radGridView1.Columns[0].IsVisible = false;
this.radGridView1.Columns[1].Width = 80;
var kolColumn = (GridViewDecimalColumn) this.radGridView1.Columns[1];
kolColumn.Minimum = 0;
kolColumn.Maximum = 100;
this.radGridView1.Columns[2].Width = 80;
this.radGridView1.Columns[3].Width = 120;
this.radGridView1.Columns[3].HeaderText = "Цена продажная";
var cenaProdagnaya = (GridViewDecimalColumn) this.radGridView1.Columns[3];
cenaProdagnaya.Minimum = 0;
cenaProdagnaya.Maximum = 9999999999999;
this.radGridView1.Columns[4].Width = 120;
this.radGridView1.Columns[4].HeaderText = "Сумма продажная";
var summaProdagnayaColumn = (GridViewDecimalColumn) this.radGridView1.Columns[4];
summaProdagnayaColumn.Minimum = 0;
summaProdagnayaColumn.Maximum = 9999999999999;
this.radGridView1.Columns[5].Width = 100;
this.radGridView1.Columns[5].HeaderText = "% скидки";
var procentSkidkiColumn = (GridViewDecimalColumn) this.radGridView1.Columns[5];
procentSkidkiColumn.Minimum = 0;
procentSkidkiColumn.Maximum = 100;
this.radGridView1.Columns[6].Width = 110;
this.radGridView1.Columns[6].HeaderText = "Сумма скидки";
var summaSkidkiColumn = (GridViewDecimalColumn) this.radGridView1.Columns[6];
summaSkidkiColumn.Minimum = 0;
summaSkidkiColumn.Maximum = 9999999999999;
this.radGridView1.Columns[7].Width = 110;
this.radGridView1.Columns[7].HeaderText = "Ставка НДС";
var stavkaNdsColumn = (GridViewDecimalColumn) this.radGridView1.Columns[7];
stavkaNdsColumn.Minimum = 0;
stavkaNdsColumn.Maximum = 9999999999999;
this.radGridView1.Columns[8].Width = 110;
this.radGridView1.Columns[8].HeaderText = "Сумма НДС";
var summaNdsColumn = (GridViewDecimalColumn) this.radGridView1.Columns[8];
summaNdsColumn.Minimum = 0;
summaNdsColumn.Maximum = 9999999999999;
this.radGridView1.Columns[9].Width = 150;
this.radGridView1.Columns[9].HeaderText = "Сумма всего";
var summaVsegoColumns = (GridViewDecimalColumn) this.radGridView1.Columns[9];
summaVsegoColumns.Minimum = 0;
summaVsegoColumns.Maximum = 9999999999999;
this.radGridView1.Columns[10].Width = 100;
this.radGridView1.Columns[10].HeaderText = "Скидка на товар";
var skidkaNaTovarColumns = (GridViewDecimalColumn) this.radGridView1.Columns[10];
skidkaNaTovarColumns.Minimum = 0;
skidkaNaTovarColumns.Maximum = 9999999999999;
this.radGridView1.Columns[11].Width = 100;
this.radGridView1.Columns[12].Width = 100;
this.radGridView1.Columns[12].HeaderText = "Срок поставки";
this.radGridView1.Columns[13].IsVisible = false;
this.radGridView1.Columns[14].IsVisible = false;
this.radGridView1.Columns[15].IsVisible = false;
this.radGridView1.Columns[2].IsVisible = false;
this.db.ЕдиницыИзмерения.Load();
comboColumnEZ = new GridViewComboBoxColumn(radGridView1.Columns[2].Name);
comboColumnEZ.DataSource = this.db.ЕдиницыИзмерения.Local.ToBindingList();
comboColumnEZ.Width = 100;
comboColumnEZ.ValueMember = "id";
comboColumnEZ.DisplayMember = "Наименование";
comboColumnEZ.FieldName = radGridView1.Columns[2].Name;
this.radGridView1.Columns.Add(comboColumnEZ);
radGridView1.Columns.Move(16, 2);
this.radGridView1.Columns[12].IsVisible = false;
this.db.Контрагенты.Load();
var peopleOrg = this.db.Контрагенты.ToList();
var peopleKontr = this.db.Контрагенты.ToList();
var peoplePostav = this.db.Контрагенты.ToList();
comboColumnPostav = new GridViewComboBoxColumn(radGridView1.Columns[12].Name);
comboColumnPostav.DataSource = peoplePostav;
comboColumnPostav.Width = 100;
comboColumnPostav.ValueMember = "id";
comboColumnPostav.DisplayMember = "Наименование";
comboColumnPostav.FieldName = radGridView1.Columns[12].Name;
this.radGridView1.Columns.Add(comboColumnPostav);
radGridView1.Columns.Move(17, 12);
this.radMultiColumnComboBoxKontragent.DataSource = peopleKontr;
this.radMultiColumnComboBoxKontragent.SelectedIndex = -1;
this.radMultiColumnComboBoxKontragent.DisplayMember = "Наименование";
this.radMultiColumnComboBoxKontragent.ValueMember = "id";
this.radMultiColumnComboBoxOrg.DataSource = peopleOrg;
this.radMultiColumnComboBoxOrg.SelectedIndex = -1;
this.radMultiColumnComboBoxOrg.DisplayMember = "Наименование";
this.radMultiColumnComboBoxOrg.ValueMember = "id";
this.db.Автомобили.Load();
this.radMultiColumnComboBoxAuto.DataSource = this.db.Автомобили.Local.ToBindingList();
this.radMultiColumnComboBoxAuto.SelectedIndex = -1;
this.radMultiColumnComboBoxAuto.DisplayMember = "Наименование";
this.radMultiColumnComboBoxAuto.ValueMember = "id";
this.db.ДоговорыВзаиморасчетов.Load();
this.radMultiColumnComboBoxDogovor.DataSource = this.db.ДоговорыВзаиморасчетов.Local.ToBindingList();
this.radMultiColumnComboBoxDogovor.SelectedIndex = -1;
this.radMultiColumnComboBoxDogovor.DisplayMember = "Наименование";
this.radMultiColumnComboBoxDogovor.ValueMember = "id";
this.db.Валюты.Load();
this.radMultiColumnComboBoxValuta.DataSource = this.db.Валюты.Local.ToBindingList();
this.radMultiColumnComboBoxValuta.SelectedIndex = -1;
this.radMultiColumnComboBoxValuta.DisplayMember = "Наименование";
this.radMultiColumnComboBoxValuta.ValueMember = "id";
this.db.ТипыЦен.Load();
this.radMultiColumnComboBoxTipCen.DataSource = this.db.ТипыЦен.Local.ToBindingList();
this.radMultiColumnComboBoxTipCen.SelectedIndex = -1;
this.radMultiColumnComboBoxTipCen.DisplayMember = "Наименование";
this.radMultiColumnComboBoxTipCen.ValueMember = "id";
this.db.ТипЗаказа.Load();
this.radMultiColumnComboBoxTipZakaza.DataSource = this.db.ТипЗаказа.Local.ToBindingList();
this.radMultiColumnComboBoxTipZakaza.SelectedIndex = -1;
this.radMultiColumnComboBoxTipZakaza.DisplayMember = "Наименование";
this.radMultiColumnComboBoxTipZakaza.ValueMember = "id";
if (indexProsmotr == 1) {
LoadDataZakaz();
DisableControls(this);
}
if (indexEdit == 1) {
LoadDataZakaz();
}
}
private void BindGrid()
{
this.employeesTableAdapter.Fill(this.nwindDataSet.Employees);
this.radGridView1.MasterTemplate.AutoGenerateColumns = false;
radGridView1.DataSource = this.nwindDataSet.Employees;
GridViewDecimalColumn decimalColumn = new GridViewDecimalColumn();
decimalColumn.FieldName = "EmployeeID";
decimalColumn.Name = "EmployeeID";
decimalColumn.HeaderText = "Decimal";
decimalColumn.DecimalPlaces = 0;
decimalColumn.Width = 100;
decimalColumn.IsVisible = false;
this.radGridView1.Columns.Add(decimalColumn);
GridViewTextBoxColumn textBoxColumn = new GridViewTextBoxColumn();
textBoxColumn.FieldName = "LastName";
textBoxColumn.Name = "LastName";
textBoxColumn.HeaderText = "Text";
textBoxColumn.Width = 100;
textBoxColumn.IsVisible = false;
this.radGridView1.Columns.Add(textBoxColumn);
GridViewImageColumn imageColumn = new GridViewImageColumn();
imageColumn.FieldName = "Photo";
imageColumn.Name = "Photo";
imageColumn.HeaderText = "Image";
imageColumn.ImageLayout = ImageLayout.Zoom;
imageColumn.Width = 54;
this.radGridView1.Columns.Add(imageColumn);
GridViewComboBoxColumn lookUpColumn = new GridViewComboBoxColumn();
lookUpColumn.FieldName = "TitleOfCourtesy";
lookUpColumn.Name = "LookUp";
lookUpColumn.HeaderText = "LookUp";
lookUpColumn.DataSource = new string[] { "Mr.", "Mrs.", "Dr.", "Ms." };
lookUpColumn.Width = 100;
lookUpColumn.IsVisible = false;
this.radGridView1.Columns.Add(lookUpColumn);
GridViewMaskBoxColumn maskBoxColumn = new GridViewMaskBoxColumn();
maskBoxColumn.FieldName = "HomePhone";
maskBoxColumn.Name = "MaskBox";
maskBoxColumn.HeaderText = "MaskBox";
maskBoxColumn.MaskType = MaskType.Standard;
maskBoxColumn.Mask = "(###) ###-####";
maskBoxColumn.Width = 200;
maskBoxColumn.IsVisible = false;
this.radGridView1.Columns.Add(maskBoxColumn);
GridViewHyperlinkColumn hyperlinkColumn = new GridViewHyperlinkColumn("Hyperlink");
hyperlinkColumn.ReadOnly = true;
hyperlinkColumn.Width = 200;
this.radGridView1.Columns.Add(hyperlinkColumn);
GridViewColorColumn colorColumn = new GridViewColorColumn("Color");
colorColumn.Width = 100;
this.radGridView1.Columns.Add(colorColumn);
GridViewCalculatorColumn calculatorColumn = new GridViewCalculatorColumn("Calculator");
calculatorColumn.Width = 80;
this.radGridView1.Columns.Add(calculatorColumn);
GridViewBrowseColumn browseColumn = new GridViewBrowseColumn("Browse");
browseColumn.Width = 180;
this.radGridView1.Columns.Add(browseColumn);
GridViewCheckBoxColumn checkBoxColumn = new GridViewCheckBoxColumn();
checkBoxColumn.HeaderText = "CheckBox";
checkBoxColumn.Name = "CheckBox";
checkBoxColumn.Width = 100;
checkBoxColumn.IsVisible = false;
this.radGridView1.Columns.Add(checkBoxColumn);
GridViewDataColumn commandColumn = new GridViewTextBoxColumn();
commandColumn.HeaderText = "Custom";
commandColumn.Name = "ProgressBar";
commandColumn.DataType = typeof(int);
commandColumn.ReadOnly = true;
commandColumn.Width = 100;
this.radGridView1.Columns.Add(commandColumn);
this.PopulateUnboundColumns();
}
private void FormatSurchargeRateOnPlotsGrid()
{
grdSurchargeRateonPlots.ShowGroupPanel = false;
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = COL_SURCHARGERATES.ID;
grdSurchargeRateonPlots.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = COL_SURCHARGERATES.POLICYID;
grdSurchargeRateonPlots.Columns.Add(col);
GridViewComboBoxColumn colCombo = new GridViewComboBoxColumn();
colCombo.Width = 160;
colCombo.Name = COL_SURCHARGERATES.PlotId;
colCombo.HeaderText = "Plot Name";
// colCombo.DataSource = Program.dtCombos.Tables[2].Copy();
colCombo.DataSource = General.GetQueryable <Gen_Zone>(null).OrderBy(c => c.OrderNo).Select(args => new
{
ZoneName = args.OrderNo + ". " + args.ZoneName,
args.Id
}).ToList();
colCombo.DisplayMember = "ZoneName";
colCombo.ValueMember = "Id";
colCombo.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDown;
colCombo.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
colCombo.ReadOnly = false;
grdSurchargeRateonPlots.Columns.Add(colCombo);
GridViewCheckBoxColumn colChk = new GridViewCheckBoxColumn();
colChk.HeaderText = "Amount Wise";
colChk.Width = 110;
colChk.Name = COL_SURCHARGERATES.AMOUNTWISE;
grdSurchargeRateonPlots.Columns.Add(colChk);
GridViewDecimalColumn col2 = new GridViewDecimalColumn();
col2.HeaderText = "Percentage (%)";
col2.Width = 110;
col2.Maximum = 100;
col2.Name = COL_SURCHARGERATES.PERCENTAGE;
grdSurchargeRateonPlots.Columns.Add(col2);
col2 = new GridViewDecimalColumn();
col2.HeaderText = "Amount (£)";
col2.Width = 110;
col2.Maximum = 100000;
col2.Name = COL_SURCHARGERATES.AMOUNT;
grdSurchargeRateonPlots.Columns.Add(col2);
UI.GridFunctions.AddDeleteColumn(grdSurchargeRateonPlots);
grdSurchargeRateonPlots.ShowGroupPanel = false;
grdSurchargeRateonPlots.AddNewRowPosition = SystemRowPosition.Bottom;
grdSurchargeRateonPlots.CellBeginEdit += new GridViewCellCancelEventHandler(grdSurchargeRates_CellBeginEdit);
grdSurchargeRateonPlots.CellEndEdit += GrdSurchargeRates_CellEndEdit;
}
private void FormatGrid()
{
grdZones.AllowAddNewRow = false;
grdZones.ShowGroupPanel = false;
// grdZones.AutoCellFormatting = true;
grdZones.ShowRowHeaderColumn = false;
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = "Id";
grdZones.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = "IsUpdated";
grdZones.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "Plot #";
col.Name = "PlotNo";
col.ReadOnly = true;
col.Width = 60;
col.IsPinned = true;
grdZones.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "Plot Name";
col.Name = "Plot";
col.ReadOnly = true;
col.Width = 230;
col.IsPinned = true;
grdZones.Columns.Add(col);
var zoneList = AppVars.BLData.GetAll <Gen_Zone>(c => c.MinLatitude != null).OrderBy(c => c.OrderNo).Select(args => new { Id = args.Id, ZoneName = args.OrderNo + "." + args.ZoneName + " (" + args.ShortName + ")" }).ToList();
GridViewComboBoxColumn colCombo = new GridViewComboBoxColumn();
colCombo.Name = "BackupPlot1";
//colCombo.DataSource = General.GetGeneralList<Gen_SysPolicyDocumentsList>(null);
colCombo.DataSource = zoneList;
colCombo.HeaderText = "BackupPlot 1";
colCombo.DisplayMember = "ZoneName";
colCombo.ValueMember = "Id";
// colCombo.NullValue = "Select";
colCombo.Width = 205;
colCombo.ReadOnly = false;
colCombo.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDown;
colCombo.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
grdZones.Columns.Add(colCombo);
colCombo = new GridViewComboBoxColumn();
colCombo.Name = "BackupPlot2";
colCombo.DataSource = zoneList.ToList();
// colCombo.DataSource = AppVars.BLData.GetAll<Gen_Zone>(c => c.MinLatitude != null).OrderBy(c => c.OrderNo).Select(args => new { Id = args.Id, ZoneName =args.OrderNo + "."+ args.ZoneName + " (" + args.ShortName + ")" }).ToList();
colCombo.HeaderText = "BackupPlot 2";
colCombo.DisplayMember = "ZoneName";
colCombo.ValueMember = "Id";
colCombo.Width = 205;
colCombo.ReadOnly = false;
colCombo.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDown;
colCombo.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
grdZones.Columns.Add(colCombo);
colCombo = new GridViewComboBoxColumn();
colCombo.Name = "BackupPlot3";
// colCombo.DataSource = AppVars.BLData.GetAll<Gen_Zone>(c => c.MinLatitude != null).OrderBy(c => c.OrderNo).Select(args => new { Id = args.Id, ZoneName = args.OrderNo + "." + args.ZoneName + " (" + args.ShortName + ")" }).ToList();
colCombo.DataSource = zoneList.ToList();
colCombo.HeaderText = "BackupPlot 3";
colCombo.DisplayMember = "ZoneName";
colCombo.ValueMember = "Id";
colCombo.Width = 200;
colCombo.ReadOnly = false;
colCombo.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDown;
colCombo.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
grdZones.Columns.Add(colCombo);
colCombo = new GridViewComboBoxColumn();
colCombo.Name = "BackupPlot4";
// colCombo.DataSource = AppVars.BLData.GetAll<Gen_Zone>(c => c.MinLatitude != null).OrderBy(c => c.OrderNo).Select(args => new { Id = args.Id, ZoneName = args.OrderNo + "." + args.ZoneName + " (" + args.ShortName + ")" }).ToList();
colCombo.DataSource = zoneList.ToList();
colCombo.HeaderText = "BackupPlot 4";
colCombo.DisplayMember = "ZoneName";
colCombo.ValueMember = "Id";
colCombo.Width = 200;
colCombo.ReadOnly = false;
colCombo.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDown;
colCombo.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
grdZones.Columns.Add(colCombo);
colCombo = new GridViewComboBoxColumn();
colCombo.Name = "BackupPlot5";
// colCombo.DataSource = AppVars.BLData.GetAll<Gen_Zone>(c => c.MinLatitude != null).OrderBy(c => c.OrderNo).Select(args => new { Id = args.Id, ZoneName = args.OrderNo + "." + args.ZoneName + " (" + args.ShortName + ")" }).ToList();
colCombo.DataSource = zoneList.ToList();
colCombo.HeaderText = "BackupPlot 5";
colCombo.DisplayMember = "ZoneName";
colCombo.ValueMember = "Id";
colCombo.Width = 200;
colCombo.ReadOnly = false;
colCombo.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDown;
colCombo.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
grdZones.Columns.Add(colCombo);
colCombo = new GridViewComboBoxColumn();
colCombo.Name = "BackupPlot6";
// colCombo.DataSource = AppVars.BLData.GetAll<Gen_Zone>(c => c.MinLatitude != null).OrderBy(c => c.OrderNo).Select(args => new { Id = args.Id, ZoneName = args.OrderNo + "." + args.ZoneName + " (" + args.ShortName + ")" }).ToList();
colCombo.DataSource = zoneList.ToList();
colCombo.HeaderText = "BackupPlot 6";
colCombo.DisplayMember = "ZoneName";
colCombo.ValueMember = "Id";
colCombo.Width = 200;
colCombo.ReadOnly = false;
colCombo.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDown;
colCombo.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
grdZones.Columns.Add(colCombo);
colCombo = new GridViewComboBoxColumn();
colCombo.Name = "BackupPlot7";
// colCombo.DataSource = AppVars.BLData.GetAll<Gen_Zone>(c => c.MinLatitude != null).OrderBy(c => c.OrderNo).Select(args => new { Id = args.Id, ZoneName = args.OrderNo + "." + args.ZoneName + " (" + args.ShortName + ")" }).ToList();
colCombo.DataSource = zoneList.ToList();
colCombo.HeaderText = "BackupPlot 7";
colCombo.DisplayMember = "ZoneName";
colCombo.ValueMember = "Id";
colCombo.Width = 200;
colCombo.ReadOnly = false;
colCombo.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDown;
colCombo.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
grdZones.Columns.Add(colCombo);
colCombo = new GridViewComboBoxColumn();
colCombo.Name = "BackupPlot8";
// colCombo.DataSource = AppVars.BLData.GetAll<Gen_Zone>(c => c.MinLatitude != null).OrderBy(c => c.OrderNo).Select(args => new { Id = args.Id, ZoneName = args.OrderNo + "." + args.ZoneName + " (" + args.ShortName + ")" }).ToList();
colCombo.DataSource = zoneList.ToList();
colCombo.HeaderText = "BackupPlot 8";
colCombo.DisplayMember = "ZoneName";
colCombo.ValueMember = "Id";
colCombo.Width = 200;
colCombo.ReadOnly = false;
colCombo.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDown;
colCombo.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
grdZones.Columns.Add(colCombo);
colCombo = new GridViewComboBoxColumn();
colCombo.Name = "BackupPlot9";
// colCombo.DataSource = AppVars.BLData.GetAll<Gen_Zone>(c => c.MinLatitude != null).OrderBy(c => c.OrderNo).Select(args => new { Id = args.Id, ZoneName = args.OrderNo + "." + args.ZoneName + " (" + args.ShortName + ")" }).ToList();
colCombo.DataSource = zoneList.ToList();
colCombo.HeaderText = "BackupPlot 9";
colCombo.DisplayMember = "ZoneName";
colCombo.ValueMember = "Id";
colCombo.Width = 200;
colCombo.ReadOnly = false;
colCombo.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDown;
colCombo.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
grdZones.Columns.Add(colCombo);
colCombo = new GridViewComboBoxColumn();
colCombo.Name = "BackupPlot10";
// colCombo.DataSource = AppVars.BLData.GetAll<Gen_Zone>(c => c.MinLatitude != null).OrderBy(c => c.OrderNo).Select(args => new { Id = args.Id, ZoneName = args.OrderNo + "." + args.ZoneName + " (" + args.ShortName + ")" }).ToList();
colCombo.DataSource = zoneList.ToList();
colCombo.HeaderText = "BackupPlot 10";
colCombo.DisplayMember = "ZoneName";
colCombo.ValueMember = "Id";
colCombo.Width = 200;
colCombo.ReadOnly = false;
colCombo.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDown;
colCombo.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
grdZones.Columns.Add(colCombo);
colCombo = new GridViewComboBoxColumn();
colCombo.Name = "BackupPlot11";
// colCombo.DataSource = AppVars.BLData.GetAll<Gen_Zone>(c => c.MinLatitude != null).OrderBy(c => c.OrderNo).Select(args => new { Id = args.Id, ZoneName = args.OrderNo + "." + args.ZoneName + " (" + args.ShortName + ")" }).ToList();
colCombo.DataSource = zoneList.ToList();
colCombo.HeaderText = "BackupPlot 11";
colCombo.DisplayMember = "ZoneName";
colCombo.ValueMember = "Id";
colCombo.Width = 200;
colCombo.ReadOnly = false;
colCombo.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDown;
colCombo.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
grdZones.Columns.Add(colCombo);
colCombo = new GridViewComboBoxColumn();
colCombo.Name = "BackupPlot12";
// colCombo.DataSource = AppVars.BLData.GetAll<Gen_Zone>(c => c.MinLatitude != null).OrderBy(c => c.OrderNo).Select(args => new { Id = args.Id, ZoneName = args.OrderNo + "." + args.ZoneName + " (" + args.ShortName + ")" }).ToList();
colCombo.DataSource = zoneList.ToList();
colCombo.HeaderText = "BackupPlot 12";
colCombo.DisplayMember = "ZoneName";
colCombo.ValueMember = "Id";
colCombo.Width = 200;
colCombo.ReadOnly = false;
colCombo.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDown;
colCombo.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
grdZones.Columns.Add(colCombo);
colCombo = new GridViewComboBoxColumn();
colCombo.Name = "BackupPlot13";
// colCombo.DataSource = AppVars.BLData.GetAll<Gen_Zone>(c => c.MinLatitude != null).OrderBy(c => c.OrderNo).Select(args => new { Id = args.Id, ZoneName = args.OrderNo + "." + args.ZoneName + " (" + args.ShortName + ")" }).ToList();
colCombo.DataSource = zoneList.ToList();
colCombo.HeaderText = "BackupPlot 13";
colCombo.DisplayMember = "ZoneName";
colCombo.ValueMember = "Id";
colCombo.Width = 200;
colCombo.ReadOnly = false;
colCombo.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDown;
colCombo.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
grdZones.Columns.Add(colCombo);
colCombo = new GridViewComboBoxColumn();
colCombo.Name = "BackupPlot14";
// colCombo.DataSource = AppVars.BLData.GetAll<Gen_Zone>(c => c.MinLatitude != null).OrderBy(c => c.OrderNo).Select(args => new { Id = args.Id, ZoneName = args.OrderNo + "." + args.ZoneName + " (" + args.ShortName + ")" }).ToList();
colCombo.DataSource = zoneList.ToList();
colCombo.HeaderText = "BackupPlot 14";
colCombo.DisplayMember = "ZoneName";
colCombo.ValueMember = "Id";
colCombo.Width = 200;
colCombo.ReadOnly = false;
colCombo.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDown;
colCombo.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
grdZones.Columns.Add(colCombo);
colCombo = new GridViewComboBoxColumn();
colCombo.Name = "BackupPlot15";
// colCombo.DataSource = AppVars.BLData.GetAll<Gen_Zone>(c => c.MinLatitude != null).OrderBy(c => c.OrderNo).Select(args => new { Id = args.Id, ZoneName = args.OrderNo + "." + args.ZoneName + " (" + args.ShortName + ")" }).ToList();
colCombo.DataSource = zoneList.ToList();
colCombo.HeaderText = "BackupPlot 15";
colCombo.DisplayMember = "ZoneName";
colCombo.ValueMember = "Id";
colCombo.Width = 200;
colCombo.ReadOnly = false;
colCombo.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDown;
colCombo.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
grdZones.Columns.Add(colCombo);
colCombo = new GridViewComboBoxColumn();
colCombo.Name = "BackupPlot16";
// colCombo.DataSource = AppVars.BLData.GetAll<Gen_Zone>(c => c.MinLatitude != null).OrderBy(c => c.OrderNo).Select(args => new { Id = args.Id, ZoneName = args.OrderNo + "." + args.ZoneName + " (" + args.ShortName + ")" }).ToList();
colCombo.DataSource = zoneList.ToList();
colCombo.HeaderText = "BackupPlot 16";
colCombo.DisplayMember = "ZoneName";
colCombo.ValueMember = "Id";
colCombo.Width = 200;
colCombo.ReadOnly = false;
colCombo.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDown;
colCombo.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
grdZones.Columns.Add(colCombo);
colCombo = new GridViewComboBoxColumn();
colCombo.Name = "BackupPlot17";
// colCombo.DataSource = AppVars.BLData.GetAll<Gen_Zone>(c => c.MinLatitude != null).OrderBy(c => c.OrderNo).Select(args => new { Id = args.Id, ZoneName = args.OrderNo + "." + args.ZoneName + " (" + args.ShortName + ")" }).ToList();
colCombo.DataSource = zoneList.ToList();
colCombo.HeaderText = "BackupPlot 17";
colCombo.DisplayMember = "ZoneName";
colCombo.ValueMember = "Id";
colCombo.Width = 200;
colCombo.ReadOnly = false;
colCombo.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDown;
colCombo.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
grdZones.Columns.Add(colCombo);
colCombo = new GridViewComboBoxColumn();
colCombo.Name = "BackupPlot18";
// colCombo.DataSource = AppVars.BLData.GetAll<Gen_Zone>(c => c.MinLatitude != null).OrderBy(c => c.OrderNo).Select(args => new { Id = args.Id, ZoneName = args.OrderNo + "." + args.ZoneName + " (" + args.ShortName + ")" }).ToList();
colCombo.DataSource = zoneList.ToList();
colCombo.HeaderText = "BackupPlot 18";
colCombo.DisplayMember = "ZoneName";
colCombo.ValueMember = "Id";
colCombo.Width = 200;
colCombo.ReadOnly = false;
colCombo.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDown;
colCombo.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
grdZones.Columns.Add(colCombo);
colCombo = new GridViewComboBoxColumn();
colCombo.Name = "BackupPlot19";
// colCombo.DataSource = AppVars.BLData.GetAll<Gen_Zone>(c => c.MinLatitude != null).OrderBy(c => c.OrderNo).Select(args => new { Id = args.Id, ZoneName = args.OrderNo + "." + args.ZoneName + " (" + args.ShortName + ")" }).ToList();
colCombo.DataSource = zoneList.ToList();
colCombo.HeaderText = "BackupPlot 19";
colCombo.DisplayMember = "ZoneName";
colCombo.ValueMember = "Id";
colCombo.Width = 200;
colCombo.ReadOnly = false;
colCombo.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDown;
colCombo.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
grdZones.Columns.Add(colCombo);
colCombo = new GridViewComboBoxColumn();
colCombo.Name = "BackupPlot20";
// colCombo.DataSource = AppVars.BLData.GetAll<Gen_Zone>(c => c.MinLatitude != null).OrderBy(c => c.OrderNo).Select(args => new { Id = args.Id, ZoneName = args.OrderNo + "." + args.ZoneName + " (" + args.ShortName + ")" }).ToList();
colCombo.DataSource = zoneList.ToList();
colCombo.HeaderText = "BackupPlot 20";
colCombo.DisplayMember = "ZoneName";
colCombo.ValueMember = "Id";
colCombo.Width = 200;
colCombo.ReadOnly = false;
colCombo.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDown;
colCombo.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
grdZones.Columns.Add(colCombo);
col = new GridViewTextBoxColumn();
col.HeaderText = "Entrance Message";
col.Name = "PlotMessage";
col.ReadOnly = false;
col.Width = 150;
grdZones.Columns.Add(col);
GridViewDecimalColumn colLimit = new GridViewDecimalColumn();
colLimit.HeaderText = "Limit";
colLimit.Name = "Limit";
colLimit.ReadOnly = false;
colLimit.Width = 70;
colLimit.Maximum = 1000;
colLimit.Minimum = -1;
colLimit.DecimalPlaces = 0;
grdZones.Columns.Add(colLimit);
col = new GridViewTextBoxColumn();
col.HeaderText = "OverLimit Message";
col.Name = "OverLimitMessage";
col.ReadOnly = false;
col.Width = 150;
grdZones.Columns.Add(col);
GridViewDateTimeColumn colDate = new GridViewDateTimeColumn();
colDate.HeaderText = "Flashing Time";
colDate.Name = "FlashingHour";
colDate.Width = 130;
colDate.ReadOnly = false;
colDate.CustomFormat = "HH:mm";
colDate.FormatString = "{0:HH:mm}";
grdZones.Columns.Add(colDate);
colDate = new GridViewDateTimeColumn();
colDate.HeaderText = "Job Due";
colDate.Name = "JobDue";
colDate.Width = 100;
colDate.ReadOnly = false;
colDate.CustomFormat = "HH:mm";
colDate.FormatString = "{0:HH:mm}";
grdZones.Columns.Add(colDate);
GridViewCheckBoxColumn colChk1 = new GridViewCheckBoxColumn();
colChk1.HeaderText = "Out of Town";
colChk1.Name = "outoftown";
colChk1.ReadOnly = false;
colChk1.Width = 120;
grdZones.Columns.Add(colChk1);
GridViewCheckBoxColumn colChk = new GridViewCheckBoxColumn();
colChk.HeaderText = "AutoDespatch";
colChk.Name = "AutoDespatch";
colChk.ReadOnly = false;
colChk.Width = 120;
grdZones.Columns.Add(colChk);
colChk = new GridViewCheckBoxColumn();
colChk.HeaderText = "Bidding";
colChk.Name = "Bidding";
colChk.ReadOnly = false;
colChk.Width = 80;
grdZones.Columns.Add(colChk);
GridViewDecimalColumn colRadius = new GridViewDecimalColumn();
colRadius.HeaderText = "Radius";
colRadius.Name = "Radius";
colRadius.ReadOnly = false;
colRadius.Width = 80;
colRadius.Maximum = 1000;
colRadius.Minimum = 0;
colRadius.DecimalPlaces = 0;
grdZones.Columns.Add(colRadius);
grdZones.ViewCellFormatting += new CellFormattingEventHandler(grdLister_ViewCellFormatting);
}
private IEnumerable GetData()
{
if (Type == null)
return null;
switch ((BindingType)Type.Value)
{
case BindingType.SimpleBindingToString:
{
Description = "This is a demonstration of GridViewComboBoxColumn binding to strings";
DescriptionHeader = "Simple Binding to Strings";
Columns.Clear();
List<Product> products = new List<Product>();
for (int i = 0; i < 10; i++)
{
Product product = new Product();
product.ID = i;
product.ProductName = String.Format("Product{0}", i);
products.Add(product);
}
GridViewComboBoxColumn column = new GridViewComboBoxColumn();
column.DataMemberBinding = new Binding("ProductName");
column.ItemsSource = from p in products
select p.ProductName;
column.Width = new GridViewLength(1, GridViewLengthUnitType.Star);
Columns.Add(column);
return products;
}
case BindingType.SimpleBindingToObject:
{
Description = "This is a demonstration of GridViewComboBoxColumn simple binding to objects";
DescriptionHeader = "Simple Binding to Objects";
Columns.Clear();
List<Employee> employees = new List<Employee>();
for (int i = 0; i < 10; i++)
{
Employee employee = new Employee();
employee.Name = String.Format("Name{0}", i);
employees.Add(employee);
}
List<Position> positions = new List<Position>();
for (int i = 0; i < 10; i++)
{
Position position = new Position();
position.Description = String.Format("Description{0}", i);
position.Employee = employees[i];
positions.Add(position);
}
GridViewComboBoxColumn comboColumn = new GridViewComboBoxColumn();
comboColumn.DataMemberBinding = new Binding("Employee");
comboColumn.DisplayMemberPath = "Name";
comboColumn.ItemsSource = employees;
comboColumn.Width = new GridViewLength(1, GridViewLengthUnitType.Star);
Columns.Add(comboColumn);
GridViewDataColumn column = new GridViewDataColumn();
column.DataMemberBinding = new Binding("Description");
column.Width = new GridViewLength(1, GridViewLengthUnitType.Star);
Columns.Add(column);
return positions;
}
case BindingType.SimpleBindingToEnum:
{
Description = "This is a demonstration of GridViewComboBoxColumn binding to enum";
DescriptionHeader = "Binding to Enum";
Columns.Clear();
List<Person> persons = new List<Person>();
Person person = new Person();
person.ID = 1;
person.Gender = Gender.Male;
persons.Add(person);
person = new Person();
person.ID = 2;
person.Gender = Gender.Female;
persons.Add(person);
List<Gender> AvailableGenders = new List<Gender>();
AvailableGenders.Add(Gender.Male);
AvailableGenders.Add(Gender.Female);
GridViewComboBoxColumn comboColumn = new GridViewComboBoxColumn();
comboColumn.DataMemberBinding = new Binding("Gender");
comboColumn.ItemsSource = AvailableGenders;
comboColumn.Width = new GridViewLength(1, GridViewLengthUnitType.Star);
Columns.Add(comboColumn);
return persons;
}
case BindingType.ClassicBindingToObject:
{
Description = "This is a demonstration of GridViewComboBoxColumn classic binding to objects";
DescriptionHeader = "Classic Binding to Objects";
Columns.Clear();
List<Location> locations = new List<Location>();
for (int i = 0; i < 10; i++)
{
Location location = new Location();
location.ID = i;
location.CountryID = i;
locations.Add(location);
}
List<Country> countries = new List<Country>();
for (int i = 0; i < 10; i++)
{
Country country = new Country();
country.ID = i;
country.Name = countryNames[i];
countries.Add(country);
}
GridViewComboBoxColumn comboColumn = new GridViewComboBoxColumn();
comboColumn.DataMemberBinding = new Binding("CountryID");
comboColumn.SelectedValueMemberPath = "ID";
comboColumn.DisplayMemberPath = "Name";
comboColumn.ItemsSource = countries;
comboColumn.Width = new GridViewLength(1, GridViewLengthUnitType.Star);
Columns.Add(comboColumn);
return locations;
}
case BindingType.MultiColumnComboBox:
{
Description = "This is a demonstration of how the ItemTemplate property of the column may be used to provide multicolumn layout for the lookup items";
DescriptionHeader = "MultiColumn ComboBox";
Columns.Clear();
List<Location> locations = new List<Location>();
for (int i = 0; i < 10; i++)
{
Location location = new Location();
location.ID = i;
location.CountryID = i;
locations.Add(location);
}
List<Country> countries = new List<Country>();
for (int i = 0; i < 10; i++)
{
Country country = new Country();
country.ID = i;
country.Name = countryNames[i];
countries.Add(country);
}
GridViewComboBoxColumn comboColumn = new GridViewComboBoxColumn();
comboColumn.Header = "Country ID & Name";
comboColumn.DataMemberBinding = new Binding("CountryID");
comboColumn.SelectedValueMemberPath = "ID";
comboColumn.DisplayMemberPath = "Name";
comboColumn.ItemsSource = countries;
comboColumn.ItemTemplate = ComboTemplate;
comboColumn.Width = new GridViewLength(1, GridViewLengthUnitType.Star);
Columns.Add(comboColumn);
return locations;
}
}
return null;
}
private void InitMaterialCostGridView()
{
this.gvMaterialCost.AddNewRowPosition = SystemRowPosition.Top;
this.gvMaterialCost.EnableFiltering = true;
this.gvMaterialCost.AllowAddNewRow = true;
this.gvMaterialCost.AllowSearchRow = true;
this.gvMaterialCost.AutoGenerateColumns = false;
//var lst = bll.Select<QuoLayer>();
//var dLst = new List<ComboboxItemModel>();
//foreach (var i in lst)
//{
// dLst.Add(new ComboboxItemModel { DisplayMember=i.LayerName,ValueMember=i.Id});
//}
GridViewComboBoxColumn c1 = new GridViewComboBoxColumn();
c1.DataSource = cmbLayer;
c1.HeaderText = "层数";
c1.Name = "LayerId";
c1.FieldName = "LayerId";
c1.ValueMember = "ValueMember";
c1.DisplayMember = "DisplayMember";
c1.FilteringMode = GridViewFilteringMode.DisplayMember;
c1.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
c1.Width = 80;
this.gvMaterialCost.Columns.Add(c1);
GridViewComboBoxColumn c2 = new GridViewComboBoxColumn();
c2.DataSource = cmbMaterial;
c2.HeaderText = "物料名称";
c2.Name = "MaterialId";
c2.FieldName = "MaterialId";
c2.ValueMember = "ValueMember";
c2.DisplayMember = "DisplayMember";
c2.FilteringMode = GridViewFilteringMode.DisplayMember;
c2.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
c2.Width = 100;
c2.WrapText = true;
this.gvMaterialCost.Columns.Add(c2);
GridViewTextBoxColumn c3 = new GridViewTextBoxColumn();
c3.HeaderText = "价格";
c3.Name = "Cost";
c3.FieldName = "Cost";
c3.Width = 80;
this.gvMaterialCost.Columns.Add(c3);
GridViewTextBoxColumn c4 = new GridViewTextBoxColumn();
c4.HeaderText = "备注";
c4.Name = "Remark";
c4.FieldName = "Remark";
c4.Width = 100;
c4.WrapText = true;
this.gvMaterialCost.Columns.Add(c4);
this.gvMaterialCost.UserDeletingRow += (s, e) => {
if (RadMessageBox.Show(this, "确认删除所选行？", "", MessageBoxButtons.YesNo, RadMessageIcon.Question) == DialogResult.No)
{
e.Cancel = true;
return;
}
if (e.Rows != null && e.Rows.Count() > 0)
{
delIds.Clear();
foreach (var row in e.Rows)
{
var tmp = row.DataBoundItem as QuoMaterialCost;
if (tmp != null && tmp.Id > 0)
{
delIds.Add(tmp.Id);
}
}
}
};
this.gvMaterialCost.UserDeletedRow += (s, e) => {
if (delIds != null && delIds.Count > 0)
{
Task.Factory.StartNew(() => {
bll.Delete <QuoMaterialCost>(delIds);
}).ContinueWith(t => {
if (t.IsFaulted)
{
syncContext.Post((state) => {
LoadMaterialCostData();
}, null);
}
});
}
};
this.gvMaterialCost.UserAddedRow += (s, e) => {
var tmp = e.Row.DataBoundItem as QuoMaterialCost;
if (tmp != null)
{
Task.Factory.StartNew <QuoMaterialCost>(() => {
return(bll.Insert(tmp));
}).ContinueWith(t => {
if (!t.IsFaulted)
{
syncContext.Post((state) => {
LoadMaterialCostData();
}, null);
}
});
}
};
this.gvMaterialCost.CellValueChanged += (s, e) => {
var cur = e.Row.DataBoundItem as QuoMaterialCost;
Task.Factory.StartNew(() =>
{
bll.Update <QuoMaterialCost>(cur.Id, e.Column.FieldName, e.Value);
}).ContinueWith(t => {
if (!t.IsFaulted)
{
syncContext.Post((state) => {
LoadMaterialCostData();
}, null);
}
});
};
//验证
this.gvMaterialCost.CellValidating += (s, e) => {
GridViewDataColumn column = e.Column as GridViewDataColumn;
if ((e.Row is GridViewNewRowInfo || e.Row is GridViewDataRowInfo) && column != null && column.Name == "LayerId")//
{
if (e.Value == null || ((int)e.Value) <= 0)
{
e.Cancel = true;
e.Row.ErrorText = "Validation error!";
//((GridViewDataRowInfo)e.Row).ErrorText = "Validation error!";
}
else
{
((GridViewDataRowInfo)e.Row).ErrorText = string.Empty;
}
}
if ((e.Row is GridViewNewRowInfo || e.Row is GridViewDataRowInfo) && column != null && column.Name == "MaterialId")//
{
if (e.Value == null || ((int)e.Value) <= 0)
{
e.Cancel = true;
e.Row.ErrorText = "Validation error!";
//((GridViewDataRowInfo)e.Row).ErrorText = "Validation error!";
}
else
{
e.Row.ErrorText = string.Empty;
}
}
};
////initialize default values for the new row
//this.gvMaterialCost.DefaultValuesNeeded += (s, e) => {
// var currentMaterial = this.gvMaterial.CurrentRow.DataBoundItem as QuoMaterial;
// e.Row.Cells["MaterialId"].Value = currentMaterial.Id;
//};
//initialize default values for the data row
//this.gvMaterialCost.CellEditorInitialized += (s, e) => {
// if (e.Row is GridViewDataRowInfo)
// {
// if (e.Column.Name == "ContactName")
// {
// e.ActiveEditor.Value = "Default Value";
// }
// }
//};
this.gvMaterialCost.CellFormatting += (s, e) => {
//if (e.Row is GridViewDataRowInfo && e.Column.Name == "LayerId" && e.Row.Cells["LayerId"].Value == null)
//{
// e.Row.Cells["LayerId"].Value = (e.Row.DataBoundItem as QuoMaterialCost).LayerId;
//}
};
}
private void frmManageSubject_Load(object sender, EventArgs e)
{
ILearningAreaService laService = new LearningAreaService();
IGradeLevelService glService = new GradeLevelService();
gradeLevel = new List<GradeLevel>(glService.GetAllGradeLevels());
colGradeLevel = new GridViewComboBoxColumn("GradeLevel");
colGradeLevel.HeaderText = "Grade Level";
colGradeLevel.FieldName = "GradeLevel";
colGradeLevel.ValueMember = "GradeLev";
colGradeLevel.DisplayMember = "Description";
colGradeLevel.Width = 110;
colGradeLevel.DataSource = gradeLevel;
gvSubjects.Columns.Add(colGradeLevel);
if (Op.Equals("edit"))
{
SetFields();
SetSubjectGrid();
this.Size = new Size(812, 571);
}
if (Op.Equals("new"))
{
BindSubjectGrid();
gvSubjects.Enabled = false;
btnSave.Enabled = false;
this.Size = new Size(812, 209);
}
}
private void FormatGrid()
{
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.Name = COLS.ID;
col.IsVisible = false;
grdBookings.Columns.Add(col);
GridViewDateTimeColumn colDate = new GridViewDateTimeColumn();
colDate.Name = "PickupDateTime";
colDate.WrapText = true;
colDate.HeaderText = "Pickup Date-Time";
colDate.Width = 140;
colDate.FieldName = "Pickup Time";
colDate.CustomFormat = "dd/MM/yyyy HH:mm";
colDate.FormatString = "{0:dd/MM/yyyy HH:mm}";
grdBookings.Columns.Add(colDate);
GridViewComboBoxColumn colCombo = new GridViewComboBoxColumn();
colCombo.Name = "VehicleType";
colCombo.HeaderText = "Vehicle";
colCombo.FieldName = "Vehicle Class";
colCombo.DataSource = General.GetQueryable <Fleet_VehicleType>(null).OrderBy(c => c.OrderNo).ToList();
colCombo.DisplayMember = "VehicleType";
colCombo.ValueMember = "Id";
colCombo.Width = 80;
colCombo.WrapText = true;
grdBookings.Columns.Add(colCombo);
col = new GridViewTextBoxColumn();
col.Name = "PhoneNo";
col.HeaderText = "Phone No";
col.Width = 120;
col.WrapText = true;
col.FieldName = "Phone";
grdBookings.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = "Passenger";
col.HeaderText = "Passenger";
col.FieldName = "Passenger Name";
col.WrapText = true;
col.Width = 100;
grdBookings.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = "From";
col.HeaderText = "Pickup Point";
col.FieldName = "0";
col.WrapText = true;
col.Width = 130;
grdBookings.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = "To";
col.WrapText = true;
col.HeaderText = "Destination";
col.Width = 130;
col.FieldName = "1";
grdBookings.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = "Notes";
col.WrapText = true;
col.FieldName = "Driver Notes";
col.HeaderText = "Notes";
col.Width = 120;
grdBookings.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = "Account";
col.HeaderText = "Account";
col.FieldName = "Booking Account";
col.WrapText = true;
col.Width = 120;
grdBookings.Columns.Add(col);
//GridViewDecimalColumn colDec = new GridViewDecimalColumn();
//colDec.Name = "Fare";
//colDec.FieldName = "Pricing";
//colDec.DecimalPlaces = 2;
//colDec.Minimum = 0;
//colDec.Maximum = 999999;
//colDec.HeaderText = "Fare";
//colDec.Width = 60;
//grdBookings.Columns.Add(colDec);
//col = new GridViewTextBoxColumn();
//col.Name = "PaymentType";
//col.WrapText = true;
//col.FieldName = "Card";
//col.HeaderText = "Payment";
//col.Width = 100;
//grdBookings.Columns.Add(col);
ConditionalFormattingObject objSave = new ConditionalFormattingObject();
objSave.ApplyToRow = true;
objSave.RowBackColor = Color.LightGreen;
objSave.ConditionType = ConditionTypes.Greater;
objSave.TValue1 = "0";
grdBookings.Columns[COLS.ID].ConditionalFormattingObjectList.Add(objSave);
ConditionalFormattingObject objError = new ConditionalFormattingObject();
objError.ApplyToRow = true;
objError.RowBackColor = Color.Pink;
objError.ConditionType = ConditionTypes.Equal;
objError.TValue1 = "0";
grdBookings.Columns[COLS.ID].ConditionalFormattingObjectList.Add(objError);
grdBookings.AddDeleteColumn();
grdBookings.Columns["btnDelete"].PinPosition = PinnedColumnPosition.Right;
grdBookings.Columns["btnDelete"].IsPinned = true;
grdBookings.Columns["btnDelete"].Width = 70;
grdBookings.CommandCellClick += new CommandCellClickEventHandler(grdBookings_CommandCellClick);
}
private void Form1_Load(object sender, EventArgs e)
{
RadGridLocalizationProvider.CurrentProvider = new MyRuRadGridLocalizationProvider();
this.db.Автомобили.Load();
this.radGridView1.DataSource = this.db.Автомобили.Local.ToBindingList();
this.radGridView1.Columns[0].Width = 30;
this.radGridView1.Columns[0].HeaderText = "№";
this.radGridView1.Columns[0].ReadOnly = true;
this.radGridView1.Columns[1].Width = 100;
this.radGridView1.Columns[2].Width = 100;
this.radGridView1.Columns[3].Width = 150;
this.radGridView1.Columns[4].Width = 100;
this.radGridView1.Columns[5].Width = 150;
this.radGridView1.Columns[6].Width = 150;
this.radGridView1.Columns[7].Width = 150;
this.radGridView1.Columns[8].Width = 150;
this.radGridView1.Columns[9].IsVisible = false;
this.db.Цвет.Load();
comboColumn = new GridViewComboBoxColumn(radGridView1.Columns[9].Name);
comboColumn.DataSource = this.db.Цвет.Local.ToBindingList();
comboColumn.Width = 100;
comboColumn.ValueMember = "id";
comboColumn.DisplayMember = "Наименование";
comboColumn.FieldName = radGridView1.Columns[9].Name;
this.radGridView1.Columns.Add(comboColumn);
radGridView1.Columns.Move(25, 9);
this.radGridView1.Columns[11].IsVisible = false;
this.radGridView1.Columns[11].Width = 100;
this.radGridView1.Columns[12].Width = 80;
this.radGridView1.Columns[13].Width = 80;
this.radGridView1.Columns[14].Width = 80;
this.radGridView1.Columns[15].HeaderText = "Нач.Гарантии";
this.radGridView1.Columns[15].Width = 80;
this.radGridView1.Columns[16].HeaderText = "Валюта";
this.db.Валюты.Load();
comboColumnVal = new GridViewComboBoxColumn(radGridView1.Columns[16].Name);
comboColumnVal.DataSource = this.db.Валюты.Local.ToBindingList();
comboColumnVal.Width = 100;
comboColumnVal.ValueMember = "id";
comboColumnVal.DisplayMember = "Наименование";
comboColumnVal.FieldName = radGridView1.Columns[16].Name;
this.radGridView1.Columns.Add(comboColumnVal);
radGridView1.Columns.Move(oldIndex: 26, newIndex: 16);
this.radGridView1.Columns[17].IsVisible = false;
this.radGridView1.Columns[18].Width = 80;
this.radGridView1.Columns[18].HeaderText = "Кон.Гарантии";
this.radGridView1.Columns[19].Width = 80;
this.radGridView1.Columns[19].HeaderText = "Ориг.VIN";
this.radGridView1.Columns[20].HeaderText = "Дата Регистр.";
this.radGridView1.Columns[20].Width = 80;
radGridView1.Columns[21].IsVisible = false;
radGridView1.Columns[22].IsVisible = false;
radGridView1.Columns[23].IsVisible = false;
radGridView1.Columns[24].IsVisible = false;
radGridView1.Columns[25].IsVisible = false;
radGridView1.Columns[26].IsVisible = false;
//добавление связанной таблицы Тип Салона
var Salon = new GridViewTemplate();
this.db.ТипСалона.Load();
Salon.DataSource = this.db.ТипСалона.Local.ToBindingList();
Salon.Caption = "Тип Салона";
Salon.Columns[1].Width = 200;
Salon.Columns[0].IsVisible = false;
Salon.Columns[2].IsVisible = false;
Salon.Columns[3].IsVisible = false;
this.radGridView1.MasterTemplate.Templates.Add(Salon);
GridViewRelation relationSalon = new GridViewRelation(this.radGridView1.MasterTemplate);
relationSalon.ChildTemplate = Salon;
relationSalon.RelationName = "Тип Салона";
relationSalon.ParentColumnNames.Add("id");
relationSalon.ChildColumnNames.Add("ID_Авто");
this.radGridView1.Relations.Add(relationSalon);
//добавление связанной таблицы Тип Комплектации
GridViewTemplate complect = new GridViewTemplate();
this.db.ВариантыКомплектации.Load();
complect.DataSource = this.db.ВариантыКомплектации.Local.ToBindingList();
complect.Caption = "Варианты комплектации";
complect.Columns[0].IsVisible = false;
complect.Columns[7].IsVisible = false;
complect.Columns[8].IsVisible = false;
complect.Columns[9].IsVisible = false;
complect.Columns[10].IsVisible = false;
complect.Columns[11].IsVisible = false;
complect.Columns[2].Width = 200;
complect.Columns[3].Width = 100;
complect.Columns[4].Width = 100;
complect.Columns[5].Width = 100;
complect.Columns[6].Width = 200;
this.radGridView1.MasterTemplate.Templates.Add(complect);
GridViewRelation relationcomplect = new GridViewRelation(this.radGridView1.MasterTemplate);
relationcomplect.ChildTemplate = complect;
relationcomplect.RelationName = "Варианты комплектации";
relationcomplect.ParentColumnNames.Add("id");
relationcomplect.ChildColumnNames.Add("ID_Авто");
this.radGridView1.Relations.Add(relationcomplect);
//добавление связанной таблицы ТипКузова
GridViewTemplate Kuzov = new GridViewTemplate();
this.db.ТипКузова.Load();
Kuzov.DataSource = this.db.ТипКузова.Local.ToBindingList();
Kuzov.Caption = "Тип Кузова";
Kuzov.Columns[1].Width = 200;
Kuzov.Columns[0].IsVisible = false;
Kuzov.Columns[2].IsVisible = false;
Kuzov.Columns[3].IsVisible = false;
Kuzov.Columns[4].IsVisible = false;
complect.Templates.Add(Kuzov);
GridViewRelation relationKuzov = new GridViewRelation(complect);
relationKuzov.ChildTemplate = Kuzov;
relationKuzov.RelationName = "Тип Кузова";
relationKuzov.ParentColumnNames.Add("id");
relationKuzov.ParentColumnNames.Add("id_Авто");
relationKuzov.ChildColumnNames.Add("ID_Комплект");
relationKuzov.ChildColumnNames.Add("id_Авто");
this.radGridView1.Relations.Add(relationKuzov);
//добавление связанной таблицы ТипКПП
GridViewTemplate template = new GridViewTemplate();
this.db.ТипКПП.Load();
template.DataSource = this.db.ТипКПП.Local.ToBindingList();
template.Caption = "Тип КПП";
template.Columns[0].IsVisible = false;
template.Columns[2].IsVisible = false;
template.Columns[1].Width = 200;
template.Columns[3].IsVisible = false;
template.Columns[4].IsVisible = false;
complect.Templates.Add(template);
GridViewRelation relation = new GridViewRelation(complect);
relation.ChildTemplate = template;
relation.RelationName = "Тип КПП";
relation.ParentColumnNames.Add("id");
relation.ParentColumnNames.Add("id_Авто");
relation.ChildColumnNames.Add("ID_Комплект");
relation.ChildColumnNames.Add("id_Авто");
this.radGridView1.Relations.Add(relation);
//типы двигателей
var dvig_komplect = new GridViewTemplate();
this.db.ТипыДвигателей.Load();
dvig_komplect.DataSource = this.db.ТипыДвигателей.Local.ToBindingList();
dvig_komplect.Caption = "Типы Двигателя";
complect.Templates.Add(dvig_komplect);
dvig_komplect.Columns[1].Width = 200;
dvig_komplect.Columns[2].Width = 200;
dvig_komplect.Columns[0].IsVisible = false;
dvig_komplect.Columns[3].IsVisible = false;
dvig_komplect.Columns[4].IsVisible = false;
dvig_komplect.Columns[5].IsVisible = false;
GridViewRelation relationdvig_com = new GridViewRelation(complect);
relationdvig_com.ChildTemplate = dvig_komplect;
relationdvig_com.RelationName = "Тип Двигателя";
relationdvig_com.ParentColumnNames.Add("id");
relationdvig_com.ParentColumnNames.Add("id_Авто");
relationdvig_com.ChildColumnNames.Add("ID_Комплект");
relationdvig_com.ChildColumnNames.Add("id_Авто");
this.radGridView1.Relations.Add(relationdvig_com);
//
}
private void FormatGrid()
{
grdAddresses.Font = new Font("Tahoma", 10);
grdAddresses.AllowAddNewRow = false;
grdAddresses.ShowGroupPanel = false;
// grdZones.AutoCellFormatting = true;
grdAddresses.ShowRowHeaderColumn = false;
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = "Id";
grdAddresses.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = "FullAddress";
col.HeaderText = "FullAddress";
col.IsVisible = false;
grdAddresses.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Width = 450;
col.HeaderText = "Street";
col.Name = "Street";
col.ReadOnly = false;
grdAddresses.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Width = 100;
col.Name = "PostCode";
col.ReadOnly = false;
col.HeaderText = "Post Code";
grdAddresses.Columns.Add(col);
GridViewComboBoxColumn colCombo = new GridViewComboBoxColumn();
colCombo.Name = "Zone";
//colCombo.DataSource = General.GetGeneralList<Gen_SysPolicyDocumentsList>(null);
colCombo.DataSource = listofZones;
colCombo.HeaderText = "Plot";
colCombo.DisplayMember = "ZoneName";
colCombo.ValueMember = "Id";
// colCombo.NullValue = "Select";
colCombo.Width = 200;
colCombo.ReadOnly = false;
colCombo.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDown;
colCombo.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
grdAddresses.Columns.Add(colCombo);
col = new GridViewTextBoxColumn();
col.Name = "OldZoneId";
col.IsVisible = false;
grdAddresses.Columns.Add(col);
GridFunctions.SetFilter(grdAddresses);
grdAddresses.Columns["Zone"].ReadOnly = false;
grdAddresses.AllowEditRow = true;
AddEditColumn(grdAddresses);
AddDeleteColumn(grdAddresses);
grdAddresses.CommandCellClick += new CommandCellClickEventHandler(grdAddresses_CommandCellClick);
}
