private void gridUsers_CellBeginEdit(object sender, GridViewCellCancelEventArgs e)
{
if (this.gridUsers.CurrentColumn is GridViewMultiComboBoxColumn)
{
if (!maNhanVienColumnAdded)
{
maNhanVienColumnAdded = true;
GridViewMultiComboBoxColumn column = this.gridUsers.CurrentColumn as GridViewMultiComboBoxColumn;
RadMultiColumnComboBoxElement editor = (RadMultiColumnComboBoxElement)this.gridUsers.ActiveEditor;
FilterDescriptor descriptorCode = new FilterDescriptor("FirstName", FilterOperator.StartsWith, string.Empty);
editor.EditorControl.FilterDescriptors.Add(descriptorCode);
editor.AutoFilter = true;
editor.EditorControl.MasterTemplate.AutoGenerateColumns = false;
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.FieldName = "Employee_ID";
editor.EditorControl.Columns.Add(col);//new GridViewTextBoxColumn("Employee_ID"));
editor.EditorControl.Columns.Add(new GridViewTextBoxColumn("FirstName"));
editor.EditorControl.Columns.Add(new GridViewTextBoxColumn("LastName"));
col = new GridViewTextBoxColumn("FullName");
editor.EditorControl.Columns.Add(col);
col.Expression = "FirstName + ' ' + LastName";
editor.EditorControl.Columns.Add(new GridViewTextBoxColumn("Birthday"));
editor.AutoSizeDropDownToBestFit = true;
}
}
}
private void DefaultItem()
{
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
cboModelName.AutoCompleteMode = AutoCompleteMode.Append;
cboModelName.DisplayMember = "ModelName";
cboModelName.ValueMember = "ModelName";
cboModelName.DataSource = db.tb_Models.Where(s => s.ModelActive == true).ToList();
cboModelName.SelectedIndex = 0;
try
{
GridViewMultiComboBoxColumn col = (GridViewMultiComboBoxColumn)radGridView1.Columns["CodeNo"];
col.DataSource = (from ix in db.tb_Items.Where(s => s.Status.Equals("Active")) select new { ix.CodeNo, ix.ItemDescription }).ToList();
col.DisplayMember = "CodeNo";
col.ValueMember = "CodeNo";
col.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDown;
col.FilteringMode = GridViewFilteringMode.DisplayMember;
// col.AutoSizeMode = BestFitColumnMode.DisplayedDataCells;
}
catch { }
//col.TextAlignment = ContentAlignment.MiddleCenter;
//col.Name = "CodeNo";
//this.radGridView1.Columns.Add(col);
this.radGridView1.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
this.radGridView1.CellEditorInitialized += radGridView1_CellEditorInitialized;
}
}
private void LoadDefault()
{
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
GridViewMultiComboBoxColumn Uom = (GridViewMultiComboBoxColumn)radGridView1.Columns["UserID"];
Uom.DataSource = (from ix in db.tb_Users.Where(s => s.Status == true)
select new { ix.UserID, ix.UserName }).ToList();
Uom.DisplayMember = "UserID";
Uom.DropDownStyle = RadDropDownStyle.DropDown;
}
}
private void AddCommboboxex()
{
GridViewMultiComboBoxColumn column = this.gridUsers.Columns["FullName"] as GridViewMultiComboBoxColumn;
column.DataSource = EQ_MainForm.dbContext.Employees.Where(e => e.Active == true).ToList <Employee>();
column.DisplayMember = "FullName";
column.ValueMember = "Employee_ID";
GridViewComboBoxColumn column1 = this.gridUsers.Columns["DeptID"] as GridViewComboBoxColumn;
column1.DataSource = EQ_MainForm.dbContext.Departments.Where(d => d.Active == true).ToList <Department>();
column1.DisplayMember = "DeptName";
column1.ValueMember = "DeptID";
}
private void Default()
{
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
//cboVendor.AutoCompleteMode = AutoCompleteMode.Append;
//cboVendor.DisplayMember = "VendorName";
//cboVendor.ValueMember = "VendorNo";
//cboVendor.DataSource = (from ix in db.tb_Vendors.Where(s => s.Active == true)
// select new { ix.VendorNo,ix.VendorName,ix.CRRNCY }).ToList();
//cboVendor.SelectedIndex = 0;
try
{
GridViewMultiComboBoxColumn col = (GridViewMultiComboBoxColumn)radGridView1.Columns["VatType"];
col.DataSource = (from ix in db.mh_VATTypes.Where(s => Convert.ToBoolean(s.Active.Equals(true)))
select new { ix.VatType }).ToList();
col.DisplayMember = "VatType";
col.ValueMember = "VatType";
col.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDown;
col.FilteringMode = GridViewFilteringMode.DisplayMember;
col.AutoSizeMode = BestFitColumnMode.DisplayedDataCells;
col.TextAlignment = ContentAlignment.MiddleCenter;
col.DropDownStyle = RadDropDownStyle.DropDownList;
}
catch { }
try
{
GridViewMultiComboBoxColumn col = (GridViewMultiComboBoxColumn)radGridView1.Columns["VatGroup"];
col.DataSource = (from ix in db.mh_VatGroups.Where(s => Convert.ToBoolean(s.Active.Equals(true)))
select new { ix.Value }).ToList();
col.DisplayMember = "Value";
col.ValueMember = "Value";
col.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDown;
col.FilteringMode = GridViewFilteringMode.DisplayMember;
col.AutoSizeMode = BestFitColumnMode.DisplayedDataCells;
col.TextAlignment = ContentAlignment.MiddleCenter;
col.DropDownStyle = RadDropDownStyle.DropDownList;
}
catch { }
}
}
private void Form1_Load(object sender, EventArgs e)
{
dtSrc = new DataTable();
DataColumn dc = dtSrc.Columns.Add("Text");
dtSrc.Rows.Add("ComboBox Text");
dtSrc.Rows.Add("Long ComboBox Text");
dtSrc.Rows.Add("Longer ComboBox Text");
dtSrc.Rows.Add("Really Longer ComboBox Text");
dtSrc.Rows.Add("Exceptionally Longer ComboBox Text");
dtSrc.Rows.Add("A ghastly amount of textual information that is to be used for the dropdown as ComboBox Text");
// ComboBox in Grid
GridViewComboBoxColumn cbCol = new GridViewComboBoxColumn();
cbCol.Name = "cbCol";
cbCol.HeaderText = "CB";
cbCol.DataSource = dtSrc;
cbCol.DisplayMember = "Text";
cbCol.Width = 150;
this.radGridView1.Columns.Add(cbCol);
// MultiComboBox in Grid
GridViewMultiComboBoxColumn mcbCol = new GridViewMultiComboBoxColumn();
mcbCol.Name = "mcbCol";
mcbCol.HeaderText = "MCB";
mcbCol.DataSource = dtSrc;
mcbCol.DisplayMember = "Text";
mcbCol.Width = 150;
this.radGridView1.Columns.Add(mcbCol);
// TextBox in Grid
GridViewTextBoxColumn txtCol = new GridViewTextBoxColumn();
txtCol.Name = "txtCol";
txtCol.HeaderText = "TXT";
txtCol.Width = 400;
this.radGridView1.Columns.Add(txtCol);
}
private void Set_FindData()
{
if (TypePart == "All" || TypePart == "")
{
ddlTypePart.Items.Add("");
ddlTypePart.Items.Add("FG");
ddlTypePart.Items.Add("WIP");
ddlTypePart.Items.Add("RM");
ddlTypePart.Items.Add("Other");
ddlTypePart.Text = "";
}
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
try
{
GridViewMultiComboBoxColumn col = (GridViewMultiComboBoxColumn)dgvData.Columns["Location"];
col.DataSource = (from ix in db.mh_Locations.Where(s => Convert.ToBoolean(s.Active.Equals(true)))
select new { ix.Code }).ToList();
col.DisplayMember = "Code";
col.ValueMember = "Code";
col.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDown;
col.FilteringMode = GridViewFilteringMode.DisplayMember;
col.AutoSizeMode = BestFitColumnMode.DisplayedDataCells;
col.TextAlignment = ContentAlignment.MiddleCenter;
col.DropDownStyle = RadDropDownStyle.DropDownList;
}
catch { }
}
//else if (TypePart == "WIP-RM")
//{
// ddlTypePart.Items.Add("WIP");
// ddlTypePart.Items.Add("RM");
// ddlTypePart.Text = "RM";
//}
//else if (TypePart == "FG-WIP")
//{
// ddlTypePart.Items.Add("FG");
// ddlTypePart.Items.Add("WIP");
// ddlTypePart.Text = "FG";
//}
//else if (TypePart == "FG")
//{
// ddlTypePart.Items.Add("FG");
// ddlTypePart.Text = "FG";
//}
//else if (TypePart == "WIP")
//{
// ddlTypePart.Items.Add("WIP");
// ddlTypePart.Text = "WIP";
//}
//else if (TypePart == "RM")
//{
// ddlTypePart.Items.Add("RM");
// ddlTypePart.Text = "RM";
//}
//if(screen==2)
//{
// radButtonElement1.Text = "เพิ่มรายการ";
// radRibbonBarGroup1.Text = "Add Part";
//}
//if (screen == 3)
//{
// radButtonElement1.Text = "เลือกรายการ";
// radRibbonBarGroup1.Text = "Select Part";
//}
}
