private void sLook_NameEN_CloseUp(object sender, DevExpress.XtraEditors.Controls.CloseUpEventArgs e)
{
if (e.CloseMode == PopupCloseMode.Normal)
{
string _nameVN = "";
string _nameJP = "";
string _group1 = "";
string _group2 = "";
string _classifyID = "1";
string _classifyDesc = "LK";
//Get index
SearchLookUpEdit editor = sender as SearchLookUpEdit;
int index = editor.Properties.GetIndexByKeyValue(editor.EditValue);
//Set value to variables
_nameVN = Convert.ToString(editor.Properties.View.GetFocusedRowCellValue("NameVN"));
_nameJP = Convert.ToString(editor.Properties.View.GetFocusedRowCellValue("NameJP"));
_group1 = Convert.ToString(editor.Properties.View.GetFocusedRowCellValue("Group1"));
_group2 = Convert.ToString(editor.Properties.View.GetFocusedRowCellValue("Group2"));
_classifyID = Convert.ToString(editor.Properties.View.GetFocusedRowCellValue("ClassifyID"));
_classifyDesc = Convert.ToString(editor.Properties.View.GetFocusedRowCellValue("ClassifyDesc"));
//Set value to column NameVN, NameJP
txt_NameVN.EditValue = _nameVN;
txt_NameJP.EditValue = _nameJP;
sLook_Group1.EditValue = _group1;
sLook_Group2.EditValue = _group2;
look_ClassifyID.EditValue = _classifyID;
txt_ClassifyDesc.EditValue = _classifyDesc;
}
}
void GetAccountsUponToFilterType(string value, SearchLookUpEdit item)
{
/*
* Ledger ==>> Get All Acounts
* Customer ==>> Get Customer Only
* Vendor ==>> Get Vendor Only
* Bank ==>> Get Bank Only
*/
item.Properties.DataSource = null;
item.Properties.View.Columns.Clear();
item.EditValue = null;
if (value == AccountsManager.AccountFilterationTypes.Ledger.ToString())
{
item.Properties.DataSource = CreateCustomTable(accManager.CreateTable());
item.Properties.DisplayMember = item.Properties.ValueMember = AccountsManager.AccountDetails.accCode.ToString();
}
else if (value == AccountsManager.AccountFilterationTypes.Customer.ToString())
{
item.Properties.DataSource = CreateCustomTable(new CustomerManager().CreateTable());
item.Properties.DisplayMember = item.Properties.ValueMember = CustomerManager.CustomerDetails.CustomerCode.ToString();
}
else if (value == AccountsManager.AccountFilterationTypes.Vendor.ToString())
{
item.Properties.DataSource = CreateCustomTable(new VendorManager().CreateTable());
item.Properties.DisplayMember = item.Properties.ValueMember = VendorManager.VendorDetails.VendorCode.ToString();
}
else if (value == AccountsManager.AccountFilterationTypes.Bank.ToString())
{
}
}
//
//SearchLookUpEdit
//
public static void DataSearchLookUpEdit(SearchLookUpEdit sLookUpEdit, string sqlConnection, string disMember, string valMember) //string colNameDis, string colNameVal)
{
sLookUpEdit.Properties.DataSource = GetData(sqlConnection);
sLookUpEdit.Properties.DisplayMember = disMember;
sLookUpEdit.Properties.ValueMember = valMember;
sLookUpEdit.Properties.BestFitMode = BestFitMode.BestFitResizePopup;
}
private void repo_sLookUp_NameEN_CloseUp(object sender, CloseUpEventArgs e)
{
if (e.CloseMode == PopupCloseMode.Normal)
{
string _nameEN = "";
string _nameVN = "";
string _nameJP = "";
string _maker = "";
string _model = "";
//Get index
SearchLookUpEdit editor = sender as SearchLookUpEdit;
int index = editor.Properties.GetIndexByKeyValue(editor.EditValue);
//Set value to variables
_nameEN = Convert.ToString(editor.Properties.View.GetFocusedRowCellValue("NameEN"));
_nameVN = Convert.ToString(editor.Properties.View.GetFocusedRowCellValue("NameVN"));
_nameJP = Convert.ToString(editor.Properties.View.GetFocusedRowCellValue("NameJP"));
_maker = Convert.ToString(editor.Properties.View.GetFocusedRowCellValue("Maker"));
_model = Convert.ToString(editor.Properties.View.GetFocusedRowCellValue("Model"));
//Set value to column NameEN,NameVN, NameJP, Maker, Model
gridView.SetRowCellValue(gridView.FocusedRowHandle, "NameEN", _nameEN);
gridView.SetRowCellValue(gridView.FocusedRowHandle, "NameVN", _nameVN);
gridView.SetRowCellValue(gridView.FocusedRowHandle, "NameJP", _nameJP);
gridView.SetRowCellValue(gridView.FocusedRowHandle, "Maker", _maker);
gridView.SetRowCellValue(gridView.FocusedRowHandle, "Model", _model);
}
}
private void searchLookUpEdit_Closed(object sender, DevExpress.XtraEditors.Controls.ClosedEventArgs e)
{
SearchLookUpEdit searchLookUpEdit = sender as SearchLookUpEdit;
var view = searchLookUpEdit.Properties.View;
int[] selectedRows = view.GetSelectedRows();
if (selectedRows.Length > 0)
{
string sValues = "";
for (int iRow = 0; iRow < selectedRows.Length; iRow++)
{
if (iRow == 0)
{
sValues = view.GetRowCellValue(selectedRows[iRow], "ROWINDEX").ToString();
}
else
{
sValues += "," + view.GetRowCellValue(selectedRows[iRow], "ROWINDEX").ToString();
}
}
searchLookUpEdit.EditValue = sValues;
}
else
{
searchLookUpEdit.EditValue = null;
}
}
public LayoutControlItem CreateSearchFindItem(string captain, string prop,
object data, string display_name = "Value", string value_name = "Id", bool is_readonly = false)
{
LayoutControlItem item = new LayoutControlItem();
DevExpress.XtraGrid.Views.Grid.GridView searchLookUpEdit1View = new DevExpress.XtraGrid.Views.Grid.GridView();
searchLookUpEdit1View.FocusRectStyle = DevExpress.XtraGrid.Views.Grid.DrawFocusRectStyle.RowFocus;
searchLookUpEdit1View.Name = "searchLookUpEdit1View";
searchLookUpEdit1View.OptionsSelection.EnableAppearanceFocusedCell = false;
searchLookUpEdit1View.OptionsView.EnableAppearanceEvenRow = true;
searchLookUpEdit1View.OptionsView.ShowAutoFilterRow = true;
searchLookUpEdit1View.OptionsView.ShowGroupPanel = false;
searchLookUpEdit1View.OptionsView.ColumnAutoWidth = false;
SearchLookUpEdit textEdit = new SearchLookUpEdit();
textEdit.DataBindings.Add("EditValue", bindingSource, prop);
textEdit.Properties.PopupFilterMode = DevExpress.XtraEditors.PopupFilterMode.Contains;
textEdit.Properties.DataSource = data;
textEdit.Properties.DisplayMember = display_name;
textEdit.Properties.ValueMember = value_name;
textEdit.Properties.ReadOnly = is_readonly;
textEdit.Properties.NullValuePrompt = captain;
textEdit.Properties.NullValuePromptShowForEmptyValue = true;
textEdit.Properties.ShowNullValuePromptWhenFocused = true;
textEdit.Properties.View = searchLookUpEdit1View;
item.Control = textEdit;
item.Text = captain;
return(item);
}
public static void popupslu <C>(object sender, EventArgs e, SearchLookUpEdit slUpEdit)
{
try
{
var popupControl = sender as IPopupControl;
var button = new SimpleButton
{
Image = Resources.add_16x16,
Text = "Edit",
BorderStyle = BorderStyles.NoBorder
};
button.Click += btnclick <C>;
button.Location = new Point(5, popupControl.PopupWindow.Height - button.Height - 5);
popupControl.PopupWindow.Controls.Add(button);
button.BringToFront();
var edit = sender as SearchLookUpEdit;
var popupForm = edit.GetPopupEditForm();
popupForm.KeyPreview = true;
popupForm.KeyUp -= txt_KeyUp;
popupForm.KeyUp += txt_KeyUp;
//slUpEdit.Properties.DataSource = Biencucbo.Table;
//Biencucbo.Table = null;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
public static void Format(this SearchLookUpEdit slokMain, bool showHeader = true)
{
slokMain.Properties.ShowAddNewButton = false;
slokMain.Properties.ShowClearButton = false;
slokMain.Properties.ShowFooter = false;
slokMain.Properties.NullValuePrompt = slokMain.Properties.NullText = "";
}
private void repositoryItemSearchLookUpEdit2_EditValueChanged(object sender, EventArgs e)
{
SearchLookUpEdit editor = gridView1.ActiveEditor as SearchLookUpEdit;
int index = editor.Properties.GetIndexByKeyValue(editor.EditValue);
DataTable dataTable = editor.Properties.DataSource as DataTable;
if (dataTable != null)
{
DataRow row = dataTable.Rows[index];
if (dtTable.AsEnumerable().Count(a => a["ServiceId"].ToString() == row["ServiceId"].ToString()) > 0)
{
Int64 vch = Convert.ToInt64(gridView1.GetRowCellValue(gridView1.RowCount - 1, "VchNo"));
dtTable.Rows.RemoveAt(gridView1.GetFocusedDataSourceRowIndex());
dtTable.Rows.Add();
gridView1.SetRowCellValue(gridView1.RowCount - 1, "VchNo", vch);
return;
}
gridView1.SetFocusedRowCellValue("Description", row["Description"]);
gridView1.SetFocusedRowCellValue("Rate", row["rate"]);
gridView1.SetFocusedRowCellValue("ServiceId", row["ServiceId"]);
gridView1.SetFocusedRowCellValue("Qty", 1);
}
int rowIndex = gridView1.GetFocusedDataSourceRowIndex();
if (rowIndex == gridView1.RowCount - 1)
{
gridView1.SetFocusedRowCellValue("serviceDate", dateTimePicker1.Value);
Int64 vch = Convert.ToInt64(gridView1.GetRowCellValue(gridView1.RowCount - 1, "VchNo"));
gridView1.SetRowCellValue(gridView1.RowCount - 1, "VchNo", vch);
DataRow rows = dtTable.NewRow();
dtTable.Rows.Add(rows);
gridView1.SetRowCellValue(gridView1.RowCount - 1, "VchNo", vch + 1);
}
}
private void rpsMathang_EditValueChanged(object sender, EventArgs e)
{
SearchLookUpEdit edit = (SearchLookUpEdit)sender;
IList list = edit.Properties.DataSource as IList;
if (string.IsNullOrEmpty(((DevExpress.XtraEditors.TextEdit)(edit)).Text))
{
return;
}
ArticleEntity art = (ArticleEntity)edit.Properties.View.GetFocusedRow();
if (art != null)
{
ArticleRelationEntity obj = (ArticleRelationEntity)gvArticleRelation.GetFocusedRow();
if (obj != null)
{
obj.ArticleId = art.ArticleId;
obj.ArticleNo = art.ArticleNo;
obj.Description = art.Description;
obj.Unit = art.Unit;
obj.CategoryId = art.CategoryId;
}
gvArticleRelation.UpdateCurrentRow();
}
}
public setSearchLookUpEdit(SearchLookUpEdit lueDes, StringBuilder sqlSource, string DisplayMember = "", string ValueMember = "")
{
this._sqlSource = sqlSource;
this._lueDes = lueDes;
this._DisplayMember = DisplayMember;
this._ValueMember = ValueMember;
}
public static void CargarSearchLookUpEdit(SearchLookUpEdit slue, object dataSource, List <BESearchLookUpEdit> lstSLUE)
{
//var bindingList = new BindingList<object>(dataSource);
BindingSource bs = new BindingSource();
bs.DataSource = dataSource;
slue.Properties.DataSource = null;
slue.Properties.ValueMember = lstSLUE[0].fieldName;
slue.Properties.DisplayMember = lstSLUE[1].fieldName;
slue.Properties.PopulateViewColumns();
foreach (var item in lstSLUE)
{
slue.Properties.View.Columns.Add(new GridColumn {
Caption = item.caption, FieldName = item.fieldName, Visible = false
});
}
slue.Properties.View.Columns[1].Visible = true;
slue.Properties.DataSource = bs;
//slue..Columns[0].Visible = false;
//slue.Properties.DataSource = dataSource;
//lue.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard;
//lue.Properties.PopupFilterMode = DevExpress.XtraEditors.PopupFilterMode.Contains;
}
public ListaParaParametrosGeneralesPopup(List <Entidades.Configuracion> prioridades)
{
InitializeComponent();
var layoutControl = new LayoutControl
{
Name = "Layout",
Dock = DockStyle.Fill
};
var searchLookUpBand = new SearchLookUpEdit
{
Name = "Listado"
,
Properties =
{
ValueMember = "PARAM_NAME",
DisplayMember = "TEXT_VALUE",
DataSource = prioridades
},
};
var column = searchLookUpBand.Properties.View.Columns.AddField("TEXT_VALUE");
column.Caption = @"Descripción";
column.Visible = true;
layoutControl.AddItem(string.Empty, searchLookUpBand).TextVisible = false;
Controls.Add(layoutControl);
}
private void OnProjectChange(object sender, EventArgs <Guid> e)
{
SearchLookUpEdit ownerIdLookUpEdit = sender as SearchLookUpEdit;
if (ownerIdLookUpEdit == null)
{
return;
}
Guid projectId = e.Data;
var projectMemberList = _objectSpace.GetObjects("ProjectMember", new BinaryOperator("ProjectId", projectId), null);
var userIds = new List <object>();
foreach (var projectObj in projectMemberList)
{
var projectMember = ConvertData.Convert <Katrin.Domain.Impl.ProjectMember>(projectObj);
userIds.Add(projectMember.MemberId);
}
if (userIds.Count > 0)
{
ownerIdLookUpEdit.ReLoadData(new InOperator("UserId", userIds), "User");
}
else
{
ownerIdLookUpEdit.ReLoadData(null, "User");
}
}
/// <summary>
/// SetBestFitPopupSearchLookUpEdit
/// </summary>
/// <param name="searchLookUpEdit"></param>
/// <param name="CheckBoxWidth"></param>
public static void SetBestFitPopupSearchLookUpEdit(this SearchLookUpEdit searchLookUpEdit, int CheckBoxWidth = 0)
{
searchLookUpEdit.Properties.Popup += (sender, e) =>
{
try
{
DevExpress.XtraEditors.SearchLookUpEdit currentLook = (DevExpress.XtraEditors.SearchLookUpEdit)sender;
currentLook.Properties.View.OptionsView.ColumnAutoWidth = false;
currentLook.Properties.View.BestFitColumns();
currentLook.Properties.View.HorzScrollVisibility = DevExpress.XtraGrid.Views.Base.ScrollVisibility.Never;
DevExpress.XtraEditors.Popup.PopupSearchLookUpEditForm currentPopup = (currentLook as DevExpress.Utils.Win.IPopupControl).PopupWindow as DevExpress.XtraEditors.Popup.PopupSearchLookUpEditForm;
//currentPopup.Size = new System.Drawing.Size(currentPopup.Width + 20, currentPopup.Height);
//currentPopup.Size = new System.Drawing.Size(slEdit.Width, currentPopup.Height);
int iColumnWidth = 0;
int iColCount = currentLook.Properties.View.Columns.Count;
for (int i = 0; i < iColCount; i++)
{
if (currentLook.Properties.View.Columns[i].Visible == true)
{
iColumnWidth += currentLook.Properties.View.Columns[i].Width;
}
}
if (iColumnWidth > 0 && currentPopup.Size.Width < (iColumnWidth + 47 + CheckBoxWidth))
{
currentPopup.Size = new System.Drawing.Size(iColumnWidth + 47 + CheckBoxWidth, currentPopup.Height);
}
}
catch { }
};
}
/// <summary>
///Điền thông tin NV
/// </summary>
private void SLook_MSNV_CloseUp(object sender, CloseUpEventArgs e)
{
try
{
if (e.CloseMode == PopupCloseMode.Normal)
{
string _MSNV = "";
string _name = "";
string _dept = "";
string _position = "";
//Get index
SearchLookUpEdit editor = sender as SearchLookUpEdit;
//Set value variables
_MSNV = Convert.ToString(editor.Properties.View.GetFocusedRowCellValue("MSNV"));
_name = Convert.ToString(editor.Properties.View.GetFocusedRowCellValue("Name"));
_dept = Convert.ToString(editor.Properties.View.GetFocusedRowCellValue("DepartID"));
_position = Convert.ToString(editor.Properties.View.GetFocusedRowCellValue("PositionID"));
//Set value to column
gridView.SetRowCellValue(gridView.FocusedRowHandle, "MSNV", _MSNV);
gridView.SetRowCellValue(gridView.FocusedRowHandle, "Name", _name);
gridView.SetRowCellValue(gridView.FocusedRowHandle, "DepartID", _dept);
gridView.SetRowCellValue(gridView.FocusedRowHandle, "PositionID", _position);
}
}
catch (Exception ex)
{
MessageBox.Show("Lỗi: " + ex.Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public virtual void CheckEditor(SearchLookUpEdit editor)
{
if (editor.EditValue.GetInt() <= 0)
{
ErrorProvider.SetError(editor, "Bitte einen gültigen Wert angeben", ErrorType.Warning);
}
}
private void searchSanPham_CloseUp(object sender, DevExpress.XtraEditors.Controls.CloseUpEventArgs e)
{
int focus = dgvDetails.FocusedRowHandle;
if (focus >= 0)
{
SearchLookUpEdit edit = sender as SearchLookUpEdit;
if (e.AcceptValue)
{
ProductSelect row = (edit.Properties.GetRowByKeyValue(e.Value) as ProductSelect);
dgvDetails.SetFocusedRowCellValue("ProductCode", row.ProductCode.ToString());
dgvDetails.SetFocusedRowCellValue("ID", row.ID.ToString());
dgvDetails.SetFocusedRowCellValue("ProductName", row.ProductName.ToString());
dgvDetails.SetFocusedRowCellValue("Price", row.Price.ToString());
focus = dgv_Main.FocusedRowHandle;
if (focus >= 0)
{
dgv_Main.SetFocusedRowCellValue("TongTien", listdetails.Sum(o => o.ThanhTien));
dgv_Main.BestFitColumns(true);
}
dgvDetails.BestFitColumns(true);
}
}
}
/// <summary>
///Điền thông tin NameVN, NameJP, Maker, Model
/// </summary>
private void SLook_ItemCode_CloseUp(object sender, CloseUpEventArgs e)
{
_DetailTable.Clear();
gridControl.DataSource = _DetailTable;
bsiRecordsCount.Caption = gridView.RowCount.ToString() + " of " + _DetailTable.Rows.Count + " records";
try
{
if (e.CloseMode == PopupCloseMode.Normal)
{
string _itemCode = "";
string _nameEN = "";
string _nameVN = "";
string _nameJP = "";
string _maker = "";
string _unit = "";
string _classifyID = "";
//Get index
SearchLookUpEdit editor = sender as SearchLookUpEdit;
//Set value variables
_itemCode = Convert.ToString(editor.Properties.View.GetFocusedRowCellValue("ItemCode"));
_nameEN = Convert.ToString(editor.Properties.View.GetFocusedRowCellValue("NameEN"));
_nameVN = Convert.ToString(editor.Properties.View.GetFocusedRowCellValue("NameVN"));
_nameJP = Convert.ToString(editor.Properties.View.GetFocusedRowCellValue("NameJP"));
_maker = Convert.ToString(editor.Properties.View.GetFocusedRowCellValue("Maker"));
_unit = Convert.ToString(editor.Properties.View.GetFocusedRowCellValue("Unit"));
_classifyID = Convert.ToString(editor.Properties.View.GetFocusedRowCellValue("ClassifyID"));
try
{
DataTable _tempTable = new DataTable();
_tempTable = M0013_DAO.GetInfo_M0013_Item(_itemCode);
if (_tempTable.Rows.Count > 0)
{
MessageBox.Show("Mã LK/Pin/Dầu " + _itemCode + " đang có chứng từ cập nhật master chưa xác nhận!",
"Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
sLookUp_ItemCode.Focus();
}
else
{ //Set value to Text edit
sLookUp_ItemCode.Text = _itemCode;
txt_NameEN.Text = _nameEN;
txt_NameVN.Text = _nameVN;
txt_NameJP.Text = _nameJP;
txt_Maker.Text = _maker;
txt_Unit.Text = _unit;
txt_Classify.Text = _classifyID;
}
}
catch (Exception ex)
{
MessageBox.Show("Lỗi: " + ex.Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
catch (Exception ex)
{
MessageBox.Show("Lỗi: " + ex.Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void CargarLookEditDevExpress_Generico(SearchLookUpEdit LookEdit, DataTable Data_Table, string DisplayMember, string valuemember)
{
try
{
LookEdit.Properties.DataSource = Data_Table;
LookEdit.Properties.DisplayMember = DisplayMember.ToUpper();
LookEdit.Properties.ValueMember = valuemember.ToUpper();
LookEdit.Properties.View.Columns.Clear();
foreach (DataColumn colum in Data_Table.Columns)
{
if ((colum.ColumnName != valuemember.ToUpper()))
{
LookEdit.Properties.View.Columns.AddField(colum.ColumnName).Visible = true;
}
}
if ((Data_Table.Rows.Count > 0))
{
LookEdit.EditValue = Data_Table.Rows[0][valuemember];
LookEdit.Properties.ShowClearButton = false;
}
else
{
LookEdit.EditValue = 0;
}
//LookEdit.Properties.View.GetRow(LookEdit.Properties.GetIndexByKeyValue(Data_Table.Rows(0)(valuemember.ToString).ToString))
}
catch (Exception ex)
{
//MsgBox("Error: " & vbCrLf & ex.Message)
DevExpress.XtraEditors.XtraMessageBox.Show("Error: " + "\n" + ex.Message, "Mensaje", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void cmbNominaTipo_EditValueChanged(object sender, EventArgs e)
{
try
{
SearchLookUpEdit lookup = sender as SearchLookUpEdit;
BindingManagerBase bm = BindingContext[lookup.Properties.DataSource];
if (lookup.EditValue != null)
{
_idNominaTipo = Convert.ToInt32(lookup.EditValue);
oListRo_Nomina_Tipoliqui_Info = oRo_Nomina_Tipoliqui_Bus.Get_List_Nomina_Tipoliqui_x_Nomina_Tipo(param.IdEmpresa, _idNominaTipo);
cmbNominaTipoLiqui.DataSource = oListRo_Nomina_Tipoliqui_Info;
//CARGA LOS EMPLEADOS DE LA NOMINA SELECCIONADA
if (barEmpleado.Visibility == BarItemVisibility.Always)
{
oListRo_Empleado_Info = oRo_Empleado_Bus.Get_List_Empleado_x_Nomina(_idEmpresa, _idNominaTipo);
cmbEmpleado.DataSource = oListRo_Empleado_Info;
}
}
}
catch (Exception ex)
{
string NameMetodo = System.Reflection.MethodBase.GetCurrentMethod().Name;
MessageBox.Show(NameMetodo + " - " + ex.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
Log_Error_bus.Log_Error(ex.ToString());
}
}
public static void dien_dl_vao_SearchLookup(string SQL, SearchLookUpEdit cmb, string m_field, string m_values)
{
Connection.ConnectSQLSERVER();
// string SQL = "SELECT * FROM nha_cc ORDER BY hieu_luc";
try
{
using (SqlDataAdapter m = new SqlDataAdapter(SQL, Connection.conn))
{
DataTable mc = new DataTable();
mc.Clear();
m.Fill(mc);
m.Dispose();
cmb.Properties.DataSource = mc;
cmb.Properties.DisplayMember = m_field;
cmb.Properties.ValueMember = m_values;
// cmb.Properties.Columns
}
}
catch (Exception ex)
{
MessageBox.Show("Lỗi:" + ex.Message);
}
finally
{
Connection.DisconnectData();
}
}
private void repo_sLookUp_LineCode_CloseUp(object sender, CloseUpEventArgs e)
{
if (e.CloseMode == PopupCloseMode.Normal)
{
string _orgLineEN = "";
string _orgProcessCode = "";
string _orgGroupLineACC = "";
string _orgUsingDept = "";
//Get index
SearchLookUpEdit editor = sender as SearchLookUpEdit;
//Set value variables
_orgLineEN = Convert.ToString(editor.Properties.View.GetFocusedRowCellValue("LineEN"));
_orgProcessCode = Convert.ToString(editor.Properties.View.GetFocusedRowCellValue("ProcessCode"));
_orgGroupLineACC = Convert.ToString(editor.Properties.View.GetFocusedRowCellValue("GroupLineACC"));
_orgUsingDept = Convert.ToString(editor.Properties.View.GetFocusedRowCellValue("UsingDept"));
//Set value to column OrgLineEN, OrgProcessCode, OrgGroupLineACC, OrgUsingDept
gridView.SetRowCellValue(gridView.FocusedRowHandle, "OrgLineEN", _orgLineEN);
gridView.SetRowCellValue(gridView.FocusedRowHandle, "OrgProcessCode", _orgProcessCode);
gridView.SetRowCellValue(gridView.FocusedRowHandle, "OrgGroupLineACC", _orgGroupLineACC);
gridView.SetRowCellValue(gridView.FocusedRowHandle, "OrgUsingDept", _orgUsingDept);
}
}
public CambiarPrioridadDeTareaPopup(List <string> prioridades)
{
InitializeComponent();
Prioridades = prioridades;
var lc = new LayoutControl
{
Name = "Layout",
Dock = DockStyle.Fill
};
var seBanda = new SearchLookUpEdit
{
Name = "Prioridad"
,
Properties =
{
DataSource = Prioridades
}
};
lc.AddItem(string.Empty, seBanda).TextVisible = false;
Controls.Add(lc);
}
//Hiển thị thông tin MMTB khi chọn lên gridView
private void Repo_sLookUp_Code_CloseUp(object sender, DevExpress.XtraEditors.Controls.CloseUpEventArgs e)
{
if (e.CloseMode == PopupCloseMode.Normal)
{
string _code = "";
string _ACCcode = "";
string _nameEN = "";
string _nameVN = "";
string _nameJP = "";
string _maker = "";
string _model = "";
string _series = "";
string _orgCountry = "";
DateTime _proDate = DateTime.Now;
int _Lifetime = 0;
decimal _netValue = 0;
DateTime _startDeprDate = DateTime.Now;
DateTime _endDeprDate = DateTime.Now;
//Get index
SearchLookUpEdit editor = sender as SearchLookUpEdit;
int index = editor.Properties.GetIndexByKeyValue(editor.EditValue);
//Set value to variables
_code = Convert.ToString(editor.Properties.View.GetFocusedRowCellValue("Code"));
_ACCcode = Convert.ToString(editor.Properties.View.GetFocusedRowCellValue("ACCcode"));
_nameEN = Convert.ToString(editor.Properties.View.GetFocusedRowCellValue("NameEN"));
_nameVN = Convert.ToString(editor.Properties.View.GetFocusedRowCellValue("NameVN"));
_nameJP = Convert.ToString(editor.Properties.View.GetFocusedRowCellValue("NameJP"));
_maker = Convert.ToString(editor.Properties.View.GetFocusedRowCellValue("Maker"));
_model = Convert.ToString(editor.Properties.View.GetFocusedRowCellValue("Model"));
_series = Convert.ToString(editor.Properties.View.GetFocusedRowCellValue("Series"));
_orgCountry = Convert.ToString(editor.Properties.View.GetFocusedRowCellValue("OrgCountry"));
if (editor.Properties.View.GetFocusedRowCellValue("ProDate") != null)
{
_proDate = Convert.ToDateTime(editor.Properties.View.GetFocusedRowCellValue("ProDate"));
}
_Lifetime = Convert.ToInt32(editor.Properties.View.GetFocusedRowCellValue("Lifetime"));
_netValue = Convert.ToDecimal(editor.Properties.View.GetFocusedRowCellValue("NetValue_Disposal"));
_startDeprDate = Convert.ToDateTime(editor.Properties.View.GetFocusedRowCellValue("StartDeprDate"));
_endDeprDate = Convert.ToDateTime(editor.Properties.View.GetFocusedRowCellValue("EndDeprDate"));
//Set value to column ACCcode, NameEN, NameVN, Maker, Model...
gridView.SetRowCellValue(gridView.FocusedRowHandle, "Code", _code);
gridView.SetRowCellValue(gridView.FocusedRowHandle, "ACCcode", _ACCcode);
gridView.SetRowCellValue(gridView.FocusedRowHandle, "NameEN", _nameEN);
gridView.SetRowCellValue(gridView.FocusedRowHandle, "NameVN", _nameVN);
gridView.SetRowCellValue(gridView.FocusedRowHandle, "NameJP", _nameJP);
gridView.SetRowCellValue(gridView.FocusedRowHandle, "Maker", _maker);
gridView.SetRowCellValue(gridView.FocusedRowHandle, "Model", _model);
gridView.SetRowCellValue(gridView.FocusedRowHandle, "Series", _series);
gridView.SetRowCellValue(gridView.FocusedRowHandle, "OrgCountry", _orgCountry);
gridView.SetRowCellValue(gridView.FocusedRowHandle, "ProDate", _proDate);
gridView.SetRowCellValue(gridView.FocusedRowHandle, "Lifetime", _Lifetime);
gridView.SetRowCellValue(gridView.FocusedRowHandle, "NetValue_Disposal", _netValue);
gridView.SetRowCellValue(gridView.FocusedRowHandle, "StartDeprDate", _startDeprDate);
gridView.SetRowCellValue(gridView.FocusedRowHandle, "EndDeprDate", _endDeprDate);
}
}
public void LayDSHocSinh(DataGridView dataGridView, SearchLookUpEdit searchLookUpEdit)
{
string query = "LayDanhSachHocSinh";
DataSet dataSet = connection.FillDataSet(query, CommandType.StoredProcedure);
dataGridView.DataSource = dataSet.Tables[0];
searchLookUpEdit.Properties.DataSource = dataSet.Tables[0];
}
private void CompanyID_SearchLookUpEdit_Popup(object sender, EventArgs e)
{
SearchLookUpEdit edit = sender.CastTo <SearchLookUpEdit>();
var popupForm = edit.GetPopupEditForm();
popupForm.KeyPreview = true;
popupForm.KeyPress += PopupForm_KeyPress;
}
private static void LookUpEdit_Popup(object sender, System.EventArgs e)
{
SearchLookUpEdit edit = sender.CastTo <SearchLookUpEdit>();
var popupForm = edit.GetPopupEditForm();
popupForm.KeyPreview = true;
popupForm.KeyPress += PopupForm_KeyPress;
}
/// <summary>
/// 初始化SearchLookUpEdit
/// </summary>
/// <param name="control">SearchLookUpEdit</param>
/// <param name="list">MemberSelect集合</param>
public static void InitSearchLookUpEdit(SearchLookUpEdit control, List <LookUpMember> list)
{
control.Properties.DataSource = list;
control.Properties.DisplayMember = "name";
control.Properties.ValueMember = "id";
control.Properties.PopulateViewColumns();
GridFormat(control.Properties.View);
}
public static void BindCountry(SearchLookUpEdit p_DrpID)
{
string sql = "Select Code,CompanyName,CompanyNameEn FROM Data_CompanyList WHERE 1=1";
DataTable dt = SysUtils.Fill(sql);
LoadSearch(p_DrpID, dt, "CompanyName", "CompanyNameEn", string.Empty);
SetSLKGrid(p_DrpID.Properties.View, new string[] { "CompanyName", "CompanyNameEn" }, new string[] { "国家", "国家英文" }, new bool[] { true, true });
}
internal void ImplementarSeleccionMultipleDeUnaLista(SearchLookUpEdit lista, ObjetoParaGuardarEnVista objeto)
{
var vista = lista.Properties.View;
lista.CustomDisplayText += UiLista_CustomDisplayText;
objeto.NombreDelControlDeLista = lista.Name;
ImplementarSeleccionMultipleDeUnaVista(vista, objeto);
}
