/// <summary>
/// Заповнюємо перелік вхідних об'єктів
/// </summary>
private void FillToObjects()
{
StaffStructureObjectsLogic objects = new StaffStructureObjectsLogic(manager);
BindingList <StructureObjectView> objectsView = objects.GetHeirarchyView();
//ToObjectCB.ValueMember = "ID";
//ToObjectCB.DisplayMember = "Name";
//FromObjectCB.ValueMember = "ID";
//FromObjectCB.DisplayMember = "Name";
//foreach (StructureObjectView ov in objectsView)
//{
// ToObjectCB.Items.Add(ov);
// FromObjectCB.Items.Add(ov);
//}
ToObjectLUE.Properties.DataSource = objectsView;
ToObjectLUE.Properties.DisplayMember = "Name";
ToObjectLUE.Properties.ValueMember = "ID";
LookUpColumnInfoCollection coll = ToObjectLUE.Properties.Columns;
coll.Add(new LookUpColumnInfo("Name", 0, "Назва"));
ToObjectLUE.Properties.BestFitMode = BestFitMode.BestFitResizePopup;
//ToObjectLUE.Properties.SearchMode = SearchMode.AutoFilter;
ToObjectLUE.Properties.AutoSearchColumnIndex = 1;
FromObjectLUE.Properties.DataSource = objectsView;
FromObjectLUE.Properties.DisplayMember = "Name";
FromObjectLUE.Properties.ValueMember = "ID";
LookUpColumnInfoCollection coll1 = FromObjectLUE.Properties.Columns;
coll1.Add(new LookUpColumnInfo("Name", 0, "Назва"));
FromObjectLUE.Properties.BestFitMode = BestFitMode.BestFitResizePopup;
//FromObjectLUE.Properties.SearchMode = SearchMode.AutoFilter;
FromObjectLUE.Properties.AutoSearchColumnIndex = 1;
}
/// <summary>
/// Заповнюємо перелік бригад
/// </summary>
private void FillTeams()
{
int structureObjectID = -1;
if (FromObjectLUE.EditValue != null)
{
structureObjectID = Convert.ToInt32(FromObjectLUE.EditValue);
}
StaffTeamsLogic teamsLogic = new StaffTeamsLogic(manager);
if (structureObjectID != -1)
{
TeamsLUE.Properties.DataSource = teamsLogic.GetByStructureObject(structureObjectID);
}
else
{
TeamsLUE.Properties.DataSource = teamsLogic.GetAll();
}
TeamsLUE.Properties.DisplayMember = "Name";
TeamsLUE.Properties.ValueMember = "ID";
LookUpColumnInfoCollection coll = TeamsLUE.Properties.Columns;
coll.Add(new LookUpColumnInfo("Name", 0, "Назва"));
TeamsLUE.Properties.BestFitMode = BestFitMode.BestFitResizePopup;
TeamsLUE.Properties.SearchMode = SearchMode.AutoFilter;
TeamsLUE.Properties.AutoSearchColumnIndex = 1;
}
private void BindPage()
{
//System.Security.Principal.WindowsIdentity wi = System.Security.Principal.WindowsIdentity.GetCurrent();
ACMSLogic.StockInventory.SearchInventory si = new ACMSLogic.StockInventory.SearchInventory();
this.lookUpEdit1.Properties.DataSource = si.SearchItemCode();
//this.lookUpEdit1.Properties.SearchMode = SearchMode.AutoComplete;
this.lookUpEdit1.Properties.ValueMember = "strProductCode";
this.lookUpEdit1.Properties.DisplayMember = "strProductCode";
//add two columns in the dropdown
LookUpColumnInfoCollection coll = lookUpEdit1.Properties.Columns;
//a column to display values of the ProductID field
coll.Add(new LookUpColumnInfo("strProductCode", "Item Code", 100));
//a column to display values of the ProductName field
//set column widths according to their contents
lookUpEdit1.Properties.BestFit();
//specify the total dropdown width
lookUpEdit1.Properties.PopupWidth = 100;
}
private void clients()
{
lookUpEdit1.Properties.DataSource = null;
DataTable Allclients = new DataTable();
Allclients = fun.get_clients();
lookUpEdit1.Properties.DataSource = Allclients;
LookUpColumnInfo info;
lookUpEdit1.Properties.ValueMember = "code_clt";
lookUpEdit1.Properties.DisplayMember = "raison_soc";
lookUpEdit1.Properties.PopulateColumns();
LookUpColumnInfoCollection coll = lookUpEdit1.Properties.Columns;
info = new LookUpColumnInfo("code_clt", 0);
info.Caption = "Code client";
coll.Add(info);
info = new LookUpColumnInfo("raison_soc", 0);
info.Caption = "Raison sociale";
coll.Add(info);
info = new LookUpColumnInfo("responsbale", 0);
info.Caption = "Responsable";
coll.Add(info);
}
public void CargarLookEditDevExpress_Generico(RepositoryItemLookUpEdit LookEdit, DataTable Data_Table, string DisplayMember, string valuemember, string Captions)
{
try
{
LookEdit.DataSource = null;
LookEdit.DataSource = Data_Table;
LookEdit.DisplayMember = DisplayMember.ToUpper();
LookEdit.ValueMember = valuemember.ToUpper();
LookEdit.Columns.Clear();
LookUpColumnInfoCollection coll = LookEdit.Columns;
// A column to display the ProductID field's values.
string[] newline = Captions.Split(',');
int index = 0;
int indexc = 0;
foreach (DataColumn colum in Data_Table.Columns)
{
if ((colum.ColumnName != valuemember.ToUpper()))
{
indexc = coll.Add(new LookUpColumnInfo(colum.ColumnName, 0));
LookEdit.Columns[indexc].Caption = newline[index].Trim();
index += 1;
}
}
LookEdit.BestFitMode = BestFitMode.BestFitResizePopup;
LookEdit.SearchMode = SearchMode.AutoFilter;
LookEdit.AutoSearchColumnIndex = 0;
LookEdit.CaseSensitiveSearch = false;
}
catch (Exception ex)
{
//MsgBox("Error: " & vbCrLf & ex.Message)
DevExpress.XtraEditors.XtraMessageBox.Show("Error: " + "\n" + ex.Message, "Mensaje", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}//end method SetLookUpEdit
private void LoadCountries()
{
try {
// Get table data
BUS.QuocGiaBUS bus = new BUS.QuocGiaBUS();
DataTable countries = bus.GetAll();
countries.TableName = "Countries";
// Create BindingSource
DataSet ds = new DataSet();
ds.Tables.Add(countries);
BindingSource binding = new BindingSource(ds, "Countries");
// Add binding data source to LookUpEdit
textBoxCountry.DataBindings.Add("EditValue", binding, "MA_QUOC_GIA");
textBoxCountry.Properties.DataSource = binding;
// Set ValueMember and DisplayMember
textBoxCountry.Properties.DisplayMember = "TEN_QUOC_GIA";
textBoxCountry.Properties.ValueMember = "MA_QUOC_GIA";
LookUpColumnInfoCollection cols = textBoxCountry.Properties.Columns;
cols.Add(new LookUpColumnInfo("TEN_QUOC_GIA", "Quốc Gia", 0));
textBoxCountry.EditValue = 0;
}//end try
catch (Exception ex) {
MessageBox.Show(ex.Message, "Thông báo lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
} //end catch
} //end method LoadCountries
private void BindPage()
{
ACMSLogic.StockInventory.SearchInventory si = new ACMSLogic.StockInventory.SearchInventory();
this.lookUpEdit1.Properties.DataSource = si.SearchItemDescription();
//this.lookUpEdit1.Properties.SearchMode = SearchMode.AutoComplete;
this.lookUpEdit1.Properties.ValueMember = "strDescription";
this.lookUpEdit1.Properties.DisplayMember = "strDescription";
this.lookUpEdit1.EditValue = "Select Description";
this.lookUpEdit1.Text = "Select Description";
//add two columns in the dropdown
LookUpColumnInfoCollection coll = lookUpEdit1.Properties.Columns;
//a column to display values of the ProductID field
coll.Add(new LookUpColumnInfo("strDescription", "Item Description", 100));
//a column to display values of the ProductName field
//set column widths according to their contents
//lookUpEdit1.Properties.BestFit();
//specify the total dropdown width
lookUpEdit1.Properties.PopupWidth = 300;
}
public void CargarCentroCosto()
{
Service.CentroCosto CC = new Service.CentroCosto();
if (MyStuff.UsaWCF == true)
{
DS_CentroCosto = objWCF.Ayuda_CentroCosto("000000");
}
else
{
DS_CentroCosto = CC.Ayuda_CentroCosto("000000");
}
lueCentroCosto.Properties.DataSource = DS_CentroCosto.Tables[0];
lueCentroCosto.Properties.DisplayMember = "vNomCeCo";
lueCentroCosto.Properties.ValueMember = "CodigoCeCo";
LookUpColumnInfoCollection coll = lueCentroCosto.Properties.Columns;
coll.Add(new LookUpColumnInfo("CodigoCeCo", "Codigo"));
coll.Add(new LookUpColumnInfo("vNomCeCo", "Nombre Centro Costo"));
lueCentroCosto.Properties.Columns[0].Visible = false;
lueCentroCosto.Properties.AutoSearchColumnIndex = 2;
lueCentroCosto.Properties.NullText = "";
}
void LoadPlanningScreenData()
{
rpgSelection.Enabled = true;
rpgShow.Enabled = true;
rpgSave.Enabled = false;
_clsTrammingPlanningData.theData.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
DataTable dtProdMonth = _clsTrammingPlanningData.GetProdMonth();
foreach (DataRow r in dtProdMonth.Rows)
{
prodMonth = r["Prodmonth"].ToString();
luePlanningProdMonth.EditValue = TProductionGlobal.ProdMonthAsDate(prodMonth.ToString());;
}
DataTable dtSections = _clsTrammingPlanningData.GetSections(TProductionGlobal.ProdMonthAsString(Convert.ToDateTime(luePlanningProdMonth.EditValue.ToString())));
rPlanningSections.DataSource = dtSections;
rPlanningSections.ValueMember = "SectionID";
rPlanningSections.DisplayMember = "Name";
gvTrammingPlanning.PostEditor();
LookUpColumnInfoCollection collXC = LookupXC.Columns;
collXC.Add(new LookUpColumnInfo("XC", 0));
LookUpColumnInfoCollection coll = LookupBoxHole.Columns;
coll.Add(new LookUpColumnInfo("BH", 0));
}
protected override void AssignColumns(LookUpColumnInfoCollection source)
{
if (source.Count > 0)
{
base.AssignColumns(source);
}
}
}//end method BookingControls
private void LoadCountry()
{
// Get table data
DataTable types = new DataTable();
BUS.LoaiPhongBUS bus = new BUS.LoaiPhongBUS();
types = bus.GetAll();
// Create BindingSource
DataSet ds = types.DataSet;
BindingSource binding = new BindingSource(ds, "Table");
// Add binding data source to LookUpEdit
textBoxRoomType.DataBindings.Add("EditValue", binding, "MA_LOAI_PHONG");
textBoxRoomType.Properties.DataSource = binding;
// Set ValueMember and DisplayMember
textBoxRoomType.Properties.DisplayMember = "TEN_LOAI_PHONG";
textBoxRoomType.Properties.ValueMember = "MA_LOAI_PHONG";
LookUpColumnInfoCollection cols = textBoxRoomType.Properties.Columns;
cols.Add(new LookUpColumnInfo("TEN_LOAI_PHONG", "Loại Phòng", 0));
cols.Add(new LookUpColumnInfo("SO_GIUONG", "Số Giường", 0));
cols.Add(new LookUpColumnInfo("GIA_THAM_KHAO", "Đơn Giá", 0));
// Let LookUpEdit control automically chooses the best size for columns and popup window
textBoxRoomType.Properties.BestFitMode = BestFitMode.BestFitResizePopup;
}//end method LoadComboBox
private void SetControlsLookUpEditProductList()
{
var sqlConn = new SqlConn(DbConnectionString());
var sett = Properties.Settings.Default;
int factoryId = sett.Factory;
string customerId = lookUpEdit_Customer.EditValue.ToString();
string sqlQuery = "SELECT * FROM v_ButcherLabelsProductList WHERE IdCustomer=" + customerId + " AND IdFactory=" + factoryId + "";
var dt = new DataTable();
dt = SqlDataTable.GetDatatable(sqlConn.GetSqlConnection(), sqlQuery);
lookUpEdit_Product.Enabled = true;
lblColorLabel.Text = string.Empty;
var control = lookUpEdit_Product.Properties;
control.DataSource = null;
control.DataSource = dt;
control.DisplayMember = "Description";
control.ValueMember = "ProdCode";
control.AppearanceDropDown.FontSizeDelta = 10;
control.AppearanceDropDownHeader.FontSizeDelta = 10;
LookUpColumnInfoCollection columns = control.Columns;
columns.Clear();
columns.Add(new LookUpColumnInfo("ProdCode", 150, "Code"));
columns.Add(new LookUpColumnInfo("Description", 400, "Description"));
columns.Add(new LookUpColumnInfo("CustomerName", 120, "Customer"));
columns.Add(new LookUpColumnInfo("LabelType", 100, "Label"));
}
private void pieces()
{
//get All stock
lookstock.Properties.DataSource = null;
DataTable Allclients = new DataTable();
Allclients = fun.get_stock();
lookstock.Properties.ValueMember = "code_piece";
lookstock.Properties.DisplayMember = "libelle_piece";
lookstock.Properties.DataSource = Allclients;
lookstock.Properties.PopulateColumns();
LookUpColumnInfoCollection coll = lookstock.Properties.Columns;
LookUpColumnInfo info;
info = new LookUpColumnInfo("code_piece", 0);
info.Caption = "Code Produit";
coll.Add(info);
info = new LookUpColumnInfo("libelle_piece", 0);
info.Caption = "Libellé Produit";
coll.Add(info);
info = new LookUpColumnInfo("quantite_piece", 0);
info.Caption = "Qantité Disponible";
coll.Add(info);
info = new LookUpColumnInfo("puv", 0);
info.Caption = "Prix Unitaire de Vente";
coll.Add(info);
}
private void LoadProductList()
{
this.repositoryItemLookUpEdit1.Columns.AddRange(new DevExpress.XtraEditors.Controls.LookUpColumnInfo[] {
new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strItemCode", "Product Code", 20, DevExpress.Utils.FormatType.None, "", true, DevExpress.Utils.HorzAlignment.Default, DevExpress.Data.ColumnSortOrder.None)
});
ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest();
this.repositoryItemLookUpEdit1.DataSource = stockRequest.GetProductByBranch(this.terminalUser.Branch.Id); //pr.GetProductByBranch(this.lkBranchTo.EditValue.ToString());
this.repositoryItemLookUpEdit1.DisplayMember = "strItemCode";
this.repositoryItemLookUpEdit1.ValueMember = "strItemCode";
this.repositoryItemLookUpEdit1.NullText = "Select Product";
LookUpColumnInfoCollection col2 = repositoryItemLookUpEdit1.Columns;
//a column to display values of the ProductID field
//a column to display values of the ProductName field
//col2.Add(new LookUpColumnInfo("Id","Product Code",20));
col2.Add(new LookUpColumnInfo("strBrand", "Brand", 50));
col2.Add(new LookUpColumnInfo("strDescription", "Description", 50));
col2.Add(new LookUpColumnInfo("strStyle", "Style", 50));
col2.Add(new LookUpColumnInfo("strColor", "Color", 50));
col2.Add(new LookUpColumnInfo("strSize", "Size", 50));
col2.Add(new LookUpColumnInfo("nQuantity", "Quantity", 50));
lkBranchTo.Properties.AutoSearchColumnIndex = 0;
repositoryItemLookUpEdit1.BestFit();
repositoryItemLookUpEdit1.PopupWidth = 600;
}
public SPKEditorForm(SPKEditorModel model)
{
InitializeComponent();
_presenter = new SPKEditorPresenter(this, model);
//_availableMechanic = new List<string>();
_today = DateTime.Today;
dtpDueDate.EditValue = _today;
valCategory.SetIconAlignment(lookUpCategory, System.Windows.Forms.ErrorIconAlignment.MiddleRight);
valVehicle.SetIconAlignment(LookUpVehicle, System.Windows.Forms.ErrorIconAlignment.MiddleRight);
valDueDate.SetIconAlignment(dtpDueDate, System.Windows.Forms.ErrorIconAlignment.MiddleRight);
this.Load += SPKEditorForm_Load;
gvSparepart.PopupMenuShowing += gvSparepart_PopupMenuShowing;
gvSparepart.FocusedRowChanged += gvSparepart_FocusedRowChanged;
gvVehicleWheel.PopupMenuShowing += gvVehicleWheel_PopupMenuShowing;
gvVehicleWheel.FocusedRowChanged += gvVehicleWheel_FocusedRowChanged;
SPKSparepartList = new List <SPKDetailSparepartViewModel>();
SPKSparepartDetailList = new List <SPKDetailSparepartDetailViewModel>();
RemovedWHeelDetailList = new List <SpecialSparepartDetailViewModel>();
this.TotalSparepartPrice = 0;
this.ContractWorkFee = 0;
this.CostEstimation = 0;
txtContractWorkFee.Enabled = false;
txtContractor.Enabled = false;
splitContainerMain.Panel2.Enabled = false;
gridVehicleWheel.Enabled = false;
ckeIsReturnRequired.Enabled = false;
lookUpSerialNumber.Enabled = false;
txtTotalSparepartPrice.ReadOnly = true;
//column setting for lookup specialSparepart in grid
LookUpColumnInfoCollection wheelDetailColl = lookupWheelDetailGv.Columns;
wheelDetailColl.Add(new LookUpColumnInfo("SerialNumber", 0, "Nomor Seri"));
lookupWheelDetailGv.BestFitMode = BestFitMode.BestFitResizePopup;
lookupWheelDetailGv.SearchMode = SearchMode.AutoComplete;
lookupWheelDetailGv.AutoSearchColumnIndex = 1;
LookUpColumnInfoCollection SparepartWheelColl = lookUpSparepartWheelGv.Columns;
SparepartWheelColl.Add(new LookUpColumnInfo("Name", 0, "Jenis Ban"));
lookUpSparepartWheelGv.BestFitMode = BestFitMode.BestFitResizePopup;
lookUpSparepartWheelGv.SearchMode = SearchMode.AutoComplete;
lookUpSparepartWheelGv.AutoSearchColumnIndex = 1;
//Vehicle wheel handler
ckeIsUsedWheelRetrieved.CheckedChanged += ckeIsUsedWheelRetrieved_CheckedChanged;
gvVehicleWheel.ShowingEditor += gvVehicleWheel_ShowingEditor;
lookupWheelDetailGv.EditValueChanged += lookupWheelDetailGv_EditValueChanged;
lookupWheelDetailGv.EditValueChanging += lookupWheelDetailGv_EditValueChanging;
}
private void BindPage()
{
this.dateEdit1.Properties.Enabled = false;
this.dateEdit1.EditValue = DateTime.Today.ToShortDateString();
//Rp.StockRequestRepository srr = new Rp.StockRequestRepository();
//IList listBranchTo = srr.GetListByDomainAndExcludeById(typeof(Branch),this.terminalUser.Branch.Id);
ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest();
this.lkBranchTo.Properties.DataSource = stockRequest.GetListByDomainAndExcludeById(this.terminalUser.Branch.Id);
//this.lkBranchTo.Properties.DataSource = listBranchTo;
//this.lkBranchTo.Properties.ValueMember = "Id";
//this.lkBranchTo.Properties.DisplayMember = "StrBranchName";
this.lkBranchTo.Properties.ValueMember = "strBranchCode";
this.lkBranchTo.Properties.DisplayMember = "strBranchName";
this.lkBranchTo.EditValue = "Select Branch";
this.lkBranchTo.Text = "Select Branch";
//add two columns in the dropdown
LookUpColumnInfoCollection coll = lkBranchTo.Properties.Columns;
//a column to display values of the ProductID field
// coll.Add(new LookUpColumnInfo("Id","Branch Code",2));
// //a column to display values of the ProductName field
// coll.Add(new LookUpColumnInfo("StrBranchName","Branch Name",50));
coll.Add(new LookUpColumnInfo("strBranchCode", "Branch Code", 2));
//a column to display values of the ProductName field
coll.Add(new LookUpColumnInfo("strBranchName", "Branch Name", 50));
//set column widths according to their contents
lkBranchTo.Properties.BestFit();
//specify the total dropdown width
lkBranchTo.Properties.PopupWidth = 300;
//enable auto completion search mode
//lkBranchTo.Properties.SearchMode = SearchMode.AutoComplete;
//the column against which to perform the search
lkBranchTo.Properties.AutoSearchColumnIndex = 0;
if (this.gridView1.DataRowCount == 0)
{
DataRow dr = dt.NewRow();
dr["strItemCode"] = "Select Product";
dr["nQuantity"] = "0";
dt.Rows.Add(dr);
this.gridControl1.DataSource = dt;
}
}
private void ucExpression_Load(object sender, EventArgs e)
{
LookUpColumnInfoCollection coll = lookUpEdit1.Properties.Columns;
// A column to display the ProductID field's values.
coll.Add(new LookUpColumnInfo("TEXT", 0));
lookUpEdit1.Properties.SearchMode = SearchMode.AutoComplete;
LoadData();
}
//
//ComboBoxEdit
//
public static void LoadComboxinXtg(RepositoryItemLookUpEdit rILookUpEdit, DataTable dataTable, string disMember, string valMember, string colNameVal, string colNameDis)
{
rILookUpEdit.DataSource = dataTable;
rILookUpEdit.DisplayMember = disMember;
rILookUpEdit.ValueMember = valMember;
LookUpColumnInfoCollection lookUpColl = rILookUpEdit.Columns;
lookUpColl.Add(new LookUpColumnInfo(valMember, 0, colNameVal));
lookUpColl.Add(new LookUpColumnInfo(disMember, 0, colNameDis));
rILookUpEdit.BestFitMode = BestFitMode.BestFitResizePopup;
}
//
// LookUpEdit
//
public static void DataLookUpEdit(LookUpEdit lookUpEdit, string sqlConnection, string disMember, string valMember, string colNameVal, string colNameDis)
{
lookUpEdit.Properties.DataSource = GetData(sqlConnection);
lookUpEdit.Properties.DisplayMember = disMember; //Trường Muốn Hiển Thị Trên control
lookUpEdit.Properties.ValueMember = valMember; //Thông tin EditValue ẩn trên control
LookUpColumnInfoCollection lookUpColl = lookUpEdit.Properties.Columns;
lookUpColl.Add(new LookUpColumnInfo(valMember, 0, colNameVal));
lookUpColl.Add(new LookUpColumnInfo(disMember, 0, colNameDis));
lookUpEdit.Properties.BestFitMode = BestFitMode.BestFitResizePopup;
}
private void TpCredito()
{
var Conexion = new LiderEntities();
var Registros = from p in Conexion.FORMAPAGOes.Where(x => x.contado != true) select new { Codigo = p.FormaPago1, Descripcion = p.Descripcion };
TipoCredito.Properties.DataSource = Registros.ToList();
TipoCredito.Properties.DisplayMember = "Descripcion";
TipoCredito.Properties.ValueMember = "Codigo";
LookUpColumnInfoCollection columna = TipoCredito.Properties.Columns;
columna.Add(new LookUpColumnInfo("Descripcion", 0));
}
/// <summary>
/// 获取字典分类明细库
/// </summary>
/// <param name="lookUp">下拉框控件名</param>
/// <param name="?">下拉框内容类别</param>
public static void GetDictionarydetail(LookUpEdit lookUp, string Type, string CategoryID)
{
SqlParameter[] sqlParam = new SqlParameter[]
{
new SqlParameter("@FrmType", SqlDbType.VarChar),
new SqlParameter("@PatNoOfHis", SqlDbType.VarChar),
new SqlParameter("@CategoryID", SqlDbType.VarChar)
};
sqlParam[0].Value = Type;
sqlParam[1].Value = "0";
sqlParam[2].Value = CategoryID;
DataTable frmDateTable = sql_Helper.ExecuteDataTable("usp_RedactPatientInfoFrm", sqlParam, CommandType.StoredProcedure);
lookUp.Properties.Columns.Clear();
lookUp.Properties.DataSource = frmDateTable;
lookUp.Properties.DisplayMember = "Name";
lookUp.Properties.ValueMember = "DetailID";
lookUp.Properties.ShowHeader = false;
lookUp.Properties.ShowFooter = false;
LookUpColumnInfoCollection coll = lookUp.Properties.Columns;
//coll.Add(new LookUpColumnInfo("CategoryID"));
//coll.Add(new LookUpColumnInfo("DetailID"));
//coll.Add(new LookUpColumnInfo("Name"));
//coll.Add(new LookUpColumnInfo("Py"));
//coll.Add(new LookUpColumnInfo("Wb"));
coll.Add(new LookUpColumnInfo("CATEGORYID"));
coll.Add(new LookUpColumnInfo("DETAILID"));
coll.Add(new LookUpColumnInfo("NAME"));
coll.Add(new LookUpColumnInfo("PY"));
coll.Add(new LookUpColumnInfo("WB"));
//lookUp.Properties.Columns["Name"].Visible = true;
//lookUp.Properties.Columns["CategoryID"].Visible = false;
//lookUp.Properties.Columns["DetailID"].Visible = false;
//lookUp.Properties.Columns["Py"].Visible = false;
//lookUp.Properties.Columns["Wb"].Visible = false;
lookUp.Properties.Columns["NAME"].Visible = true;
lookUp.Properties.Columns["CATEGORYID"].Visible = false;
lookUp.Properties.Columns["DETAILID"].Visible = false;
lookUp.Properties.Columns["PY"].Visible = false;
lookUp.Properties.Columns["WB"].Visible = false;
lookUp.Properties.BestFit();
lookUp.Properties.SearchMode = DevExpress.XtraEditors.Controls.SearchMode.AutoComplete;
lookUp.Properties.AutoSearchColumnIndex = 2 | 3;
}
/// <summary>
/// заповнення можливих типів документів
/// </summary>
private void FillDocumentTypes()
{
DocumentTypesLogic types = new DocumentTypesLogic(manager);
DocumentTypeLUE.Properties.DataSource = types.GetAll();
DocumentTypeLUE.Properties.DisplayMember = "Name";
DocumentTypeLUE.Properties.ValueMember = "ID";
LookUpColumnInfoCollection coll = DocumentTypeLUE.Properties.Columns;
coll.Add(new LookUpColumnInfo("Name", 0, "Назва"));
DocumentTypeLUE.Properties.BestFitMode = BestFitMode.BestFitResizePopup;
DocumentTypeLUE.Properties.SearchMode = SearchMode.AutoFilter;
DocumentTypeLUE.Properties.AutoSearchColumnIndex = 1;
}
protected override ResultStatus Open()
{
base.Open();
#region 處理下拉選單
dwSbrkno.Properties.DataSource = daoABRK.ListAll2();
dwSbrkno.Properties.ValueMember = "ABRK_NO";
dwSbrkno.Properties.DisplayMember = "CP_DISPLAY";
dwSbrkno.Properties.ShowHeader = false;
dwSbrkno.Properties.ShowFooter = false;
dwSbrkno.Properties.NullText = "";
dwSbrkno.Properties.SearchMode = SearchMode.OnlyInPopup;
dwSbrkno.Properties.TextEditStyle = TextEditStyles.Standard;
//讓下拉選單只剩單一欄位
LookUpColumnInfoCollection singleCol = dwSbrkno.Properties.Columns;
singleCol.Add(new LookUpColumnInfo("CP_DISPLAY"));
dwSbrkno.Properties.BestFitMode = BestFitMode.BestFitResizePopup;
dwEbrkno.Properties.DataSource = daoABRK.ListAll2();
dwEbrkno.Properties.ValueMember = "ABRK_NO";
dwEbrkno.Properties.DisplayMember = "CP_DISPLAY";
dwEbrkno.Properties.ShowHeader = false;
dwEbrkno.Properties.ShowFooter = false;
dwEbrkno.Properties.NullText = "";
dwEbrkno.Properties.SearchMode = SearchMode.OnlyInPopup;
dwEbrkno.Properties.TextEditStyle = TextEditStyles.Standard;
//讓下拉選單只剩單一欄位
LookUpColumnInfoCollection singleCol2 = dwEbrkno.Properties.Columns;
singleCol2.Add(new LookUpColumnInfo("CP_DISPLAY"));
dwEbrkno.Properties.BestFitMode = BestFitMode.BestFitResizePopup;
dwProdCond.Properties.DataSource = dao56010.dw_prod_cond();
dwProdCond.Properties.ValueMember = "PARAM_KEY";
dwProdCond.Properties.DisplayMember = "CP_DISPLAY";
dwProdCond.Properties.ShowHeader = false;
dwProdCond.Properties.ShowFooter = false;
dwProdCond.Properties.NullText = "";
dwProdCond.Properties.SearchMode = SearchMode.OnlyInPopup;
dwProdCond.Properties.TextEditStyle = TextEditStyles.Standard;
//讓下拉選單只剩單一欄位
LookUpColumnInfoCollection singleCol3 = dwProdCond.Properties.Columns;
singleCol3.Add(new LookUpColumnInfo("CP_DISPLAY"));
dwProdCond.Properties.BestFitMode = BestFitMode.BestFitResizePopup;
dwProdCond.EditValue = "全部";
#endregion
return(ResultStatus.Success);
}
private void Form1_Load(object sender, EventArgs e)
{
lookUpEditHints1.Properties.DataSource = FillTable();
lookUpEditHints1.Properties.DisplayMember = "Customer";
lookUpEditHints1.Properties.DescriptionField = "Description";
lookUpEditHints1.BeforeShowingTooltip += new EventHandler(lookUpEditHints1_BeforeShowingTooltip);
// LookUpEdit customization: adding two columns from DataSource
// and making one of them invisible
LookUpColumnInfoCollection coll = lookUpEditHints1.Properties.Columns;
coll.Add(new LookUpColumnInfo("Customer"));
coll.Add(new LookUpColumnInfo("Description"));
lookUpEditHints1.Properties.Columns["Description"].Visible = false;
}
public VehicleEditorForm(VehicleEditorModel model)
{
InitializeComponent();
_presenter = new VehicleEditorPresenter(this, model);
// set validation alignment
FieldsValidator.SetIconAlignment(lookUpCustomer, System.Windows.Forms.ErrorIconAlignment.MiddleRight);
FieldsValidator.SetIconAlignment(lookUpBrand, System.Windows.Forms.ErrorIconAlignment.MiddleRight);
FieldsValidator.SetIconAlignment(lookUpType, System.Windows.Forms.ErrorIconAlignment.MiddleRight);
FieldsValidator.SetIconAlignment(txtYearOfPurchase, System.Windows.Forms.ErrorIconAlignment.MiddleRight);
FieldsValidator.SetIconAlignment(txtLicenseNumber, System.Windows.Forms.ErrorIconAlignment.MiddleRight);
FieldsValidator.SetIconAlignment(txtCode, System.Windows.Forms.ErrorIconAlignment.MiddleRight);
ValidateExpireDate.SetIconAlignment(dtpExpirationDate, System.Windows.Forms.ErrorIconAlignment.MiddleRight);
this.Load += VehicleEditorForm_Load;
//lookupWheelDetailGv.EditValueChanged += lookupWheelDetailGv_EditValueChanged;
gvVehicleWheel.PopupMenuShowing += gvVehicleWheel_PopupMenuShowing;
gvVehicleWheel.FocusedRowChanged += gvVehicleWheel_FocusedRowChanged;
////collumn setting for lookup specialSparepart in grid
//LookUpColumnInfoCollection coll = lookupWheelDetailGv.Columns;
//coll.Add(new LookUpColumnInfo("SerialNumber", 0, "Nomor Seri"));
////coll.Add(new LookUpColumnInfo("SparepartName", 0, "Sparepart"));
//lookupWheelDetailGv.BestFitMode = BestFitMode.BestFitResizePopup;
//lookupWheelDetailGv.SearchMode = SearchMode.AutoComplete;
//lookupWheelDetailGv.AutoSearchColumnIndex = 1;
//collumn setting for lookup specialSparepart in grid
_repoItemLookUpEdit = new RepositoryItemLookUpEdit();
_repoItemLookUpEdit.DisplayMember = "SerialNumber";
_repoItemLookUpEdit.ValueMember = "SerialNumber";
LookUpColumnInfoCollection coll = _repoItemLookUpEdit.Columns;
coll.Add(new LookUpColumnInfo("SerialNumber", 0, "Nomor Seri"));
//coll.Add(new LookUpColumnInfo("SparepartName", 0, "Sparepart"));
_repoItemLookUpEdit.BestFitMode = BestFitMode.BestFitResizePopup;
_repoItemLookUpEdit.SearchMode = SearchMode.AutoComplete;
_repoItemLookUpEdit.AutoSearchColumnIndex = 1;
_repoItemLookUpEdit.NullValuePromptShowForEmptyValue = false;
_repoItemLookUpEdit.EditValueChanged += _repoItemLookUpEdit_EditValueChanged;
lookUpCustomer.EditValueChanged += lookUpCustomer_EditValueChanged;
gvVehicleWheel.CustomRowCellEditForEditing += gvVehicleWheel_CustomRowCellEditForEditing;
}
private void SetControlsLookUpEdit(LookUpEdit control, DataTable dataTable, string displayMember, string valueMember,
string caption)
{
var _control = control.Properties;
_control.DataSource = null;
_control.DataSource = dataTable;
_control.DisplayMember = displayMember;
_control.ValueMember = valueMember;
_control.AppearanceDropDown.FontSizeDelta = 12;
_control.AppearanceDropDownHeader.FontSizeDelta = 12;
LookUpColumnInfoCollection column = _control.Columns;
column.Clear();
column.Add(new LookUpColumnInfo(displayMember, caption));
}
public void InitForm()
{
LookUpColumnInfoCollection cols = cmbSampleName.Properties.Columns;
cols.Add(new LookUpColumnInfo("SampleName", 0));
cols.Add(new LookUpColumnInfo("Description_" + MIS.Utility.MyLanguage.Language, 0));
cmbSampleName.Properties.BestFitMode = BestFitMode.BestFitResizePopup;
cmbSampleName.Properties.SearchMode = SearchMode.AutoComplete;
cmbSampleName.Properties.AutoSearchColumnIndex = 1;
LookUpColumnInfoCollection coll = cmbMaterial.Properties.Columns;
coll.Add(new LookUpColumnInfo("LOT_NO", 0));
coll.Add(new LookUpColumnInfo("Description_" + MIS.Utility.MyLanguage.Language, 0));
cmbMaterial.Properties.BestFitMode = BestFitMode.BestFitResizePopup;
cmbMaterial.Properties.SearchMode = SearchMode.AutoComplete;
cmbMaterial.Properties.AutoSearchColumnIndex = 1;
}
public FormCameraCapture()
{
InitializeComponent();
var devs = new FilterInfoCollection(FilterCategory.VideoInputDevice); //获取摄像头列表
_camera = new VideoCaptureDevice(devs[0].MonikerString); //实例化设备控制类(我选了第1个)
var cameraSetupList = new List <CameraSetup>();
int index = 0;
foreach (var resolution in _camera.VideoCapabilities)
{
var cameraSetup = new CameraSetup
{
AverageFrameRate = resolution.AverageFrameRate.ToString(),
BitCount = resolution.BitCount.ToString(),
MaximumFrameRate = resolution.MaximumFrameRate.ToString(),
Height = resolution.FrameSize.Height.ToString(),
Width = resolution.FrameSize.Width.ToString(),
Index = index
};
cameraSetup.Value = string.Format("{0}_{1}_{2}_{3}_{4}", cameraSetup.AverageFrameRate,
cameraSetup.BitCount, cameraSetup.MaximumFrameRate, cameraSetup.Height,
cameraSetup.Width);
cameraSetupList.Add(cameraSetup);
index++;
}
lupSetup.Properties.DataSource = cameraSetupList;
lupSetup.Properties.Columns.Clear();
LookUpColumnInfoCollection coll = lupSetup.Properties.Columns;
coll.Add(new LookUpColumnInfo("AverageFrameRate", "AverageFrameRate", 0));
coll.Add(new LookUpColumnInfo("BitCount", "BitCount", 1));
coll.Add(new LookUpColumnInfo("MaximumFrameRate", "MaximumFrameRate", 2));
coll.Add(new LookUpColumnInfo("Height", "Height", 3));
coll.Add(new LookUpColumnInfo("Width", "Width", 4));
lupSetup.Properties.DisplayMember = "Value";
lupSetup.Properties.ValueMember = "Index";
lupSetup.Properties.BestFit();
btnStop.Enabled = false;
}
/// <summary>
/// 获取地区信息
/// </summary>
/// <param name="lookUp">下拉框控件名</param>
/// <param name="CategoryID">下拉框内容类别</param>
public static void GetAreas(LookUpEdit lookUp, string Type, string CategoryID)
{
SqlParameter[] sqlParam = new SqlParameter[]
{
new SqlParameter("@FrmType", SqlDbType.VarChar),
new SqlParameter("@NoOfInpat", SqlDbType.VarChar),
new SqlParameter("@CategoryID", SqlDbType.VarChar)
};
sqlParam[0].Value = Type;
sqlParam[1].Value = "0";
sqlParam[2].Value = CategoryID;
DataTable frmDateTable = sql_Helper.ExecuteDataTable("usp_RedactPatientInfoFrm", sqlParam, CommandType.StoredProcedure);
m_app.PublicMethod.ConvertDataSourceUpper(frmDateTable);
lookUp.Properties.Columns.Clear();
lookUp.Properties.DataSource = frmDateTable;
lookUp.Properties.DisplayMember = "NAME";
lookUp.Properties.ValueMember = "ID";
lookUp.Properties.ShowHeader = false;
lookUp.Properties.ShowFooter = false;
LookUpColumnInfoCollection coll = lookUp.Properties.Columns;
coll.Add(new LookUpColumnInfo("PARENTID"));
coll.Add(new LookUpColumnInfo("ID"));
coll.Add(new LookUpColumnInfo("NAME"));
coll.Add(new LookUpColumnInfo("PY"));
coll.Add(new LookUpColumnInfo("WB"));
lookUp.Properties.Columns["NAME"].Visible = true;
lookUp.Properties.Columns["PARENTID"].Visible = false;
lookUp.Properties.Columns["ID"].Visible = false;
lookUp.Properties.Columns["PY"].Visible = false;
lookUp.Properties.Columns["WB"].Visible = false;
lookUp.Properties.BestFit();
lookUp.Properties.SearchMode = DevExpress.XtraEditors.Controls.SearchMode.AutoComplete;
lookUp.Properties.AutoSearchColumnIndex = 2 | 3;
//m_app.PublicMethod.ConvertLookUpEditDataSourceUpper(lookUp);
}
private void InitLookUpEdit()
{
SampleLoad = report.GetQCReport("Q_Samples", new string[] { "Query" }, new object[] { "" }).Tables[0];
LookUpColumnInfoCollection cols = cmbMaterial.Properties.Columns;
cols.Add(new LookUpColumnInfo("LOT_NO", 0));
cols.Add(new LookUpColumnInfo("Description_" + MIS.Utility.MyLanguage.Language, 0));
cmbMaterial.Properties.BestFitMode = BestFitMode.BestFitResizePopup;
cmbMaterial.Properties.SearchMode = SearchMode.AutoComplete;
cmbMaterial.Properties.AutoSearchColumnIndex = 1;
cols = cmbSampleName.Properties.Columns;
cols.Add(new LookUpColumnInfo("SampleName", 0));
cols.Add(new LookUpColumnInfo("Description_" + MIS.Utility.MyLanguage.Language, 0));
cmbSampleName.Properties.BestFitMode = BestFitMode.BestFitResizePopup;
cmbSampleName.Properties.SearchMode = SearchMode.AutoComplete;
cmbSampleName.Properties.AutoSearchColumnIndex = 1;
}
