public static RepositoryItemLookUpEdit GetCotPLLookUp(
string IDField, string DisplayField,
DataTable DataLookup, string[] LookupVisibleFields,
string[] Captions, string ColumnField, bool AllowBlank,
params int[] Widths)
{
RepositoryItemLookUpEdit lookup = new RepositoryItemLookUpEdit();
if (AllowBlank)
{
DataRow row = DataLookup.NewRow();
row[IDField] = -1;
row[DisplayField] = "";
DataLookup.Rows.InsertAt(row, 0);
}
lookup.DataSource = DataLookup;
lookup.ValueMember = IDField;
lookup.DisplayMember = DisplayField;
lookup.ImmediatePopup = true;
lookup.ShowLines = true;
lookup.NullText = GlobalConst.NULL_TEXT;
int totalWidth = 0;
if (LookupVisibleFields != null)
{
for (int i = 0; i < LookupVisibleFields.Length; i++)
{
LookUpColumnInfo colLook = new LookUpColumnInfo();
colLook.FieldName = LookupVisibleFields[i];
colLook.Caption = Captions[i];
if (Widths != null && Widths.Length > i) colLook.Width = Widths[i];
else colLook.Width = 40;
totalWidth += colLook.Width;
lookup.Columns.Add(colLook);
}
}
lookup.PopupWidth = totalWidth;
lookup.TextEditStyle = TextEditStyles.Standard;
if (Widths == null && Widths.Length > 0) lookup.BestFit();
return lookup;
}
private static void AddDataSource(ref DevExpress.XtraEditors.LookUpEdit le, System.Data.DataTable dt)
{
le.Properties.Columns.Clear();
le.Properties.DataSource = dt;
const Int32 width = 125;
int i = 0;
foreach (DataColumn dc in dt.Columns)
{
if (++i > 2)
{
break;
}
LookUpColumnInfo luColumnInfo = new LookUpColumnInfo(dc.Caption, width);
le.Properties.Columns.Add(luColumnInfo);
}
if (dt.Columns.Count >= 2)
{
le.Properties.ValueMember = dt.Columns[0].Caption;
le.Properties.DisplayMember = dt.Columns[1].Caption;
// get the first rows
le.EditValue = dt.Rows[0][0].ToString();
}
else
{
le.Properties.ValueMember = dt.Columns[0].Caption;
le.Properties.DisplayMember = dt.Columns[0].Caption;
// get the first rows
le.EditValue = dt.Rows[0][0].ToString();//DataBindings.Add("EditValue", dt,dt.Columns[0].Caption);
}
}
public static void SetDataSource(this RepositoryItemLookUpEdit properties, object dataSource,
string valueMember, string displayMember, string fieldAndCaptionList = "")
{
properties.NullText = "";
properties.Columns.Clear();
if (fieldAndCaptionList.IsEmpty())
{
properties.ShowHeader = false;
fieldAndCaptionList = "{0}|{0}".FormatWith(displayMember);
}
var fieldArray = fieldAndCaptionList.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
for (int i = 0; i < fieldArray.Length; i++)
{
var list = fieldArray[i].Split(new char[] { '|' }, StringSplitOptions.RemoveEmptyEntries);
if (list.Length > 0)
{
var column = new LookUpColumnInfo(list[0], list.Length == 1 ? list[0] : list[1]);
column.Visible = true;
properties.Columns.Add(column);
}
}
properties.DataSource = dataSource;
properties.DisplayMember = displayMember;
properties.ValueMember = valueMember;
properties.BestFit();
}
/// <summary>
/// 绑定gridColumn校区
/// </summary>
/// <param name="col">gridColumn列</param>
public static void BindGridSchoolZone(this GridColumn col)
{
if (col == null || col.View.GridControl == null)
{
throw new ArgumentNullException("col");
}
var lk = new CSmartRepositoryItemLookupEdit();
lk.TextEditStyle = TextEditStyles.Standard;
var info = new LookUpColumnInfo("SchoolZoneCode", "编号");
lk.Columns.Add(info);
info = new LookUpColumnInfo("SchoolZoneName", "校区");
lk.Columns.Add(info);
var listIsValid = (List <SchoolZone>)ClientCache.GetAuto("SchoolZone", () => new SchoolZoneDao().GetList());
lk.DataSource = listIsValid;
lk.DisplayMember = "SchoolZoneName";
lk.ValueMember = "SchoolZoneID";
lk.NullText = "";
lk.ShowHeader = true;
lk.PopupWidth = 150;
col.View.GridControl.RepositoryItems.Add(lk);
col.ColumnEdit = lk;
}
/// <summary>
/// 绑定gridColumn职位
/// </summary>
/// <param name="col">gridColumn列</param>
/// <param name="bindType">类型</param>
public static void BindGridDuty(this GridColumn col)
{
if (col == null)
{
throw new ArgumentNullException("GridColumn is null");
}
if (col.View.GridControl == null)
{
throw new ArgumentNullException("GridColumn.View.GridControl is null!");
}
CSmartRepositoryItemLookupEdit lk = new CSmartRepositoryItemLookupEdit();
lk.TextEditStyle = TextEditStyles.Standard;
LookUpColumnInfo info = new LookUpColumnInfo("DutyCode", "编号");
lk.Columns.Add(info);
info = new LookUpColumnInfo("DutyName", "名称");
lk.Columns.Add(info);
info = new LookUpColumnInfo("MnemonicCode", "助记码");
lk.Columns.Add(info);
List <Duty> ListIsValid = (List <Duty>)ClientCache.GetAuto("Duty", () => new DutyDao().GetList());
lk.DataSource = ListIsValid;
lk.DisplayMember = "DutyName";
lk.ValueMember = "DutyID";
lk.NullText = "";
lk.ShowHeader = true;
lk.PopupWidth = 200;
col.View.GridControl.RepositoryItems.Add(lk);
col.ColumnEdit = lk;
}
private static void InitDropDown(LookUpEdit control, EntityList <ObsDef> items, Guid currentValue)
{
control.Properties.DataSource = null;
control.Properties.Columns.Clear();
control.Properties.DisplayMember = DisplayFieldName;
control.Properties.DataSource = items;
var lookUpColumnInfo = new LookUpColumnInfo(DisplayFieldName);
control.Properties.Columns.Add(lookUpColumnInfo);
control.Properties.DropDownRows = items.Count > 20 ? 20 : items.Count;
control.EditValue = null;
if (currentValue == Guid.Empty)
{
return;
}
foreach (var item in items)
{
if (item.OBD_GUID == currentValue)
{
control.EditValue = item;
break;
}
}
}
/// <summary>
/// 初始化页面控件
/// </summary>
protected override void InitUIControls()
{
this.cmbStateType.Properties.Columns.Clear();
LookUpColumnInfo columnInfo = new LookUpColumnInfo(EMS_EQUIPMENT_STATES_FIELDS.FIELD_EQUIPMENT_STATE_TYPE);
this.cmbStateType.Properties.Columns.Add(columnInfo);
this.cmbStateType.Properties.DisplayMember = EMS_EQUIPMENT_STATES_FIELDS.FIELD_EQUIPMENT_STATE_TYPE;
this.cmbStateType.Properties.ValueMember = EMS_EQUIPMENT_STATES_FIELDS.FIELD_EQUIPMENT_STATE_TYPE;
this.grdViewStates.Columns.Clear();
EMS_EQUIPMENT_STATES_FIELDS equipmentStatesFields = new EMS_EQUIPMENT_STATES_FIELDS();
int index = 0;
foreach (KeyValuePair <string, FieldProperties> field in equipmentStatesFields.FIELDS)
{
GridColumn column = new GridColumn();
column.Name = field.Key;
column.FieldName = field.Key;
column.Visible = true;
column.VisibleIndex = index++;
this.grdViewStates.Columns.Add(column);
}
}
private void CreateComboBoxEdit(p_int_artykul_pobierz art)
{
var do_list = DAO.p_int_dokument_pobierz(null);
cmbDoList = new LookUpEdit();
cmbDoList.Bounds = new Rectangle(lblArDoList.Location.X + lblArDoList.Width + 5, spinEditArCenaBr.Location.Y, 120, 20);
cmbDoList.Properties.DataSource = do_list;
cmbDoList.Properties.ValueMember = "do_id";
cmbDoList.Properties.DisplayMember = "do_nazwa";
cmbDoList.Properties.NullText = null;
cmbDoList.EditValue = null;
var LookUpColumnInfo = new LookUpColumnInfo("do_id", "do_id");
LookUpColumnInfo.Visible = false;
cmbDoList.Properties.Columns.Add(LookUpColumnInfo);
LookUpColumnInfo = new LookUpColumnInfo("do_nazwa", "Nazwa");
LookUpColumnInfo.Visible = true;
cmbDoList.Properties.Columns.Add(LookUpColumnInfo);
//zaznaczenie dokumentu, do którego należy artykul
if (art.nar_do_id != null)
{
cmbDoList.EditValue = art.nar_do_id;
}
this.Controls.Add(cmbDoList);
}
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 Get_Load()
{
var obrtm = new BRTypeReason();
var oltm = obrtm.Get_PSGN_SPLS_SVMC_TIPO_MOTI();
rilCOD_TIPO_MOTI.DataSource = oltm;
rilCOD_TIPO_MOTI.Columns.Clear();
var lkci = new LookUpColumnInfo("ALF_TIPO_MOTI", "Tipos de Motivo", 20);
rilCOD_TIPO_MOTI.Columns.Add(lkci);
rilCOD_TIPO_MOTI.DisplayMember = "ALF_TIPO_MOTI";
rilCOD_TIPO_MOTI.ValueMember = "COD_TIPO_MOTI";
var obr = new BRReason();
var olst = obr.Get_PSGN_SPLS_SVMC_MOTI(xfMain.SgIns.SESSION_COMP);
if (olst.Count == 0)
{
var obj = new BEReason() { IND_MNTN = 1, COD_USUA_CREA = xfMain.SgIns.SESSION_USER };
olst.Add(obj);
}
gdcGeneric.DataSource = olst;
BeginInvoke(new MethodInvoker(() =>
{
gdvGeneric.MoveLast();
gdvGeneric.FocusedColumn = gdvGeneric.VisibleColumns[1];
gdvGeneric.ShowEditor();
}));
}
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);
}
protected void InitLookupEditColumns()
{
VinaDbUtil vinaDbUtil = new VinaDbUtil();
string lookuptable = vinaDbUtil.GetPrimaryTableWhichForeignColumnReferenceTo(this.VinaDataSource, this.VinaDataMember);
GELookupColumnsController objLookupColumnsController = new GELookupColumnsController();
List <GELookupColumnsInfo> lookupColumns = objLookupColumnsController.GetLookupColumnByLookupTableName(lookuptable);
if (lookupColumns.Count() == 0)
{
return;
}
this.Properties.Columns.Clear();
this.Properties.BestFitMode = BestFitMode.None;
LookUpColumnInfo column = new LookUpColumnInfo();
lookupColumns.ForEach(o =>
{
column = new LookUpColumnInfo();
column.Caption = o.GELookupColumnCaption;
column.FieldName = o.GELookupColumnFieldName;
column.FormatType = string.IsNullOrWhiteSpace(o.GELookupColumnFormatType) ? FormatType.None : (FormatType)Enum.Parse(typeof(FormatType), o.GELookupColumnFormatType);
column.FormatString = o.GELookupColumnFormatString;
column.Width = o.GELookupColumnWidth;
this.Properties.Columns.Add(column);
this.Properties.PopupWidth += column.Width;
});
}
private void FrmPipeNodeStyle_Load(object sender, EventArgs e)
{
this._ds = DF3DPipeCreateApp.App.TemplateLib;
if (this._ds == null)
{
this.Enabled = false; return;
}
DataTable modelInfo = GetModelInfo();
if (modelInfo != null)
{
this.txtModelId.Properties.DataSource = modelInfo;
this.txtModelId.Properties.DisplayMember = "Name";
this.txtModelId.Properties.ValueMember = "ObjectId";
LookUpColumnInfo column = new LookUpColumnInfo("Name");
this.txtModelId.Properties.Columns.Add(column);
}
if (this._edit)
{
this.txtStyleName.Text = this._style.Name;
this.chkBlendPipe.Checked = this._style.IsBlendPipe;
this.chkFollowDia.Checked = this._style.IsFollowDia;
this.chkFollowDir.Checked = this._style.IsFollowDir;
this.chkFollowSurfH.Checked = this._style.IsFollowSurfH;
this.chkRotateZ.Checked = this._style.IsRotateZ;
this.chkStretchZ.Checked = this._style.IsStretchZ;
if (!string.IsNullOrEmpty(this._style.ModelId))
{
this.txtModelId.EditValue = this._style.ModelId;
}
this.picThumbnail.Image = this._style.Thumbnail;
}
}
private void loadComboBoxNVB(List <NhanVienBan> listNVB)
{
LookUpColumnInfo[] mField = new LookUpColumnInfo[]
{
new LookUpColumnInfo("Name", "Tên"),
};
loadComboBox(cmbNVBH, listNVB.Cast <object>().ToList(), "Name", "ID", mField);
}
///////////////////////////////////////////////////////////////////////////////////////////////
// Method(Private)
///////////////////////////////////////////////////////////////////////////////////////////////
#region :: CreateColumn :: LookUpColumn을 만듭니다.
/// <summary>
/// LookUpColumn을 만듭니다.
/// </summary>
/// <param name="fieldName">Field 명</param>
/// <param name="caption">Column Caption 명</param>
/// <param name="width">Column 너비</param>
/// <param name="align">Column 정렬</param>
/// <param name="visible">Column 숨김/보임</param>
/// <returns></returns>
/// <remarks>
/// 2008-12-17 최초생성 : 황준혁
/// 변경내역
///
/// </remarks>
private LookUpColumnInfo CreateColumn(string fieldName, string caption, int width, HorzAlignment align, bool visible)
{
LookUpColumnInfo column = new LookUpColumnInfo {
FieldName = fieldName, Caption = caption, Width = width, Alignment = align, Visible = visible
};
return(column);
}
private void loadComboBoxHTTT(List <HinhThucThanhToan> listHTT)
{
LookUpColumnInfo[] mField = new LookUpColumnInfo[]
{
new LookUpColumnInfo("Name", "Hình Thức"),
};
loadComboBox(cmbHTTT, listHTT.Cast <object>().ToList(), "Name", "ID", mField);
}
private void loadComboBoxDVMH(List <DonViMuaHang> listDVMH)
{
LookUpColumnInfo[] mField = new LookUpColumnInfo[]
{
new LookUpColumnInfo("Name", "Đơn vị"),
};
loadComboBox(cmbDV, listDVMH.Cast <object>().ToList(), "Name", "ID", mField);
}
public static void AddLookupEditColumn(
this BandedGridView gridView,
string fieldName,
string caption,
int width,
object itemSource,
string valueMember,
string displayMember,
bool isAllowEdit = true,
List <ColumnInfo> columns = null,
string nullText = "",
bool showHearder = false,
EventHandler editValueChanged = null)
{
RepositoryItemLookUpEdit itemCtrl = new RepositoryItemLookUpEdit
{
DataSource = itemSource,
DisplayMember = displayMember,
ValueMember = valueMember,
NullText = nullText,
ShowHeader = showHearder,
TextEditStyle = TextEditStyles.Standard,
AllowNullInput = DefaultBoolean.True
};
if (editValueChanged != null)
{
itemCtrl.EditValueChanged += editValueChanged;
}
if (columns != null)
{
foreach (var col in columns)
{
var colInfo = new LookUpColumnInfo
{
FieldName = col.FieldName,
Caption = col.Caption,
Visible = true,
};
if (col.Width > 0)
{
colInfo.Width = col.Width;
}
itemCtrl.Columns.Add(colInfo);
}
}
else
{
itemCtrl.Columns.Add(new LookUpColumnInfo(displayMember));
}
gridView.AddColumn(fieldName, caption, width, isAllowEdit, itemCtrl: itemCtrl);
}
/// <summary>
/// 生成DevLookUpEdit的显示下拉列表
/// </summary>
/// <param name="lookupEdit"></param>
/// <param name="table"></param>
static void AddLookupColumnInfo(LookUpEdit lookupEdit, KeyValuePair <string, string>[] fields)
{
lookupEdit.Properties.Columns.Clear();
for (int i = 0; i < fields.Length; i++)
{
KeyValuePair <string, string> field = fields[i];
LookUpColumnInfo luci = new LookUpColumnInfo(field.Key, field.Value, 100);
lookupEdit.Properties.Columns.Add(luci);
}
}
public static void AddLookupEditColumn(
this TreeList gridView,
string fieldName,
string caption,
int width,
object itemSource,
string valueMember,
string displayMember,
bool isAllowEdit = true,
List <ColumnInfo> columnNames = null,
string nullText = "",
bool showHearder = false,
EventHandler editValueChanged = null)
{
var itemCtrl = new RepositoryItemLookUpEdit
{
DataSource = itemSource,
DisplayMember = displayMember,
ValueMember = valueMember,
NullText = nullText,
ShowHeader = showHearder
};
if (editValueChanged != null)
{
itemCtrl.EditValueChanged += editValueChanged;
}
if (columnNames != null)
{
foreach (var col in columnNames)
{
var colInfo = new LookUpColumnInfo
{
FieldName = col.FieldName,
Caption = col.Caption,
Visible = true,
};
if (col.Width > 0)
{
colInfo.Width = col.Width;
}
itemCtrl.Columns.Add(colInfo);
}
}
else
{
itemCtrl.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo(displayMember));
}
gridView.AddColumn(fieldName, caption, width, isAllowEdit, itemCtrl: itemCtrl);
}
private void Get_Load()
{
var olstt = new List<BEStatus>();
olstt.Add(new BEStatus() { COD_ESTA = "AB", ALF_ESTA = "Abierto" });
olstt.Add(new BEStatus() { COD_ESTA = "CE", ALF_ESTA = "Cerrado" });
olstt.Add(new BEStatus() { COD_ESTA = "AN", ALF_ESTA = "Anulado" });
lkeIND_ESTA.Properties.DataSource = olstt;
lkeIND_ESTA.Properties.Columns.Clear();
var lkci = new LookUpColumnInfo("ALF_ESTA", "Estado", 20);
lkeIND_ESTA.Properties.Columns.Add(lkci);
lkeIND_ESTA.Properties.DisplayMember = "ALF_ESTA";
lkeIND_ESTA.Properties.ValueMember = "COD_ESTA";
}
private void FillInValueDropdown()
{
lookUpValue.Properties.DisplayMember = "Label";
lookUpValue.Properties.DataSource = _items;
var lookUpColumnInfo = new LookUpColumnInfo("Label");
lookUpValue.Properties.Columns.Add(lookUpColumnInfo);
int dropDownCount = _items.Count > 20 ? 20 : _items.Count;
lookUpValue.Properties.DropDownRows = dropDownCount;
lookUpValue.EditValue = null;
}
public void AddEmptyRow()
{
int newRowIndex = grid1.Rows.Count;
grid1.Rows.Insert(newRowIndex);
var lookupEditor = new LookupEditEditor(typeof(Guid));
LookUpColumnInfo selectedCol = (LookUpColumnInfo)((ComboBoxItem)cmbExerciseViewType.SelectedItem).Tag;
lookupEditor.Control.SetDisplayColumn(selectedCol);
grid1[newRowIndex, FromExerciseColumn] = new SourceGrid.Cells.Cell(null, lookupEditor);
SourceGrid.Cells.Views.Cell readOnlyView = new SourceGrid.Cells.Views.Cell();
grid1[newRowIndex, FromExerciseColumn].View = readOnlyView;
grid1[newRowIndex, FromExerciseColumn].View.ForeColor = ApplicationColors.FGNullText;
grid1[newRowIndex, FromExerciseColumn].AddController(mapperCtrl);
grid1[newRowIndex, FromExerciseColumn].Editor.NullDisplayString = StrengthTrainingEntryStrings.SelectExercise;
grid1[newRowIndex, FromExerciseColumn].Column.Width = 250;
readOnlyView = new SourceGrid.Cells.Views.Cell();
lookupEditor = new LookupEditEditor(typeof(Guid));
lookupEditor.Control.SetDisplayColumn(selectedCol);
grid1[newRowIndex, ToExerciseColumn] = new SourceGrid.Cells.Cell(null, lookupEditor);
readOnlyView = new SourceGrid.Cells.Views.Cell();
grid1[newRowIndex, ToExerciseColumn].View = readOnlyView;
grid1[newRowIndex, ToExerciseColumn].View.ForeColor = ApplicationColors.FGNullText;
grid1[newRowIndex, ToExerciseColumn].AddController(mapperCtrl);
grid1[newRowIndex, ToExerciseColumn].Editor.NullDisplayString = StrengthTrainingEntryStrings.SelectExercise;
grid1[newRowIndex, ToExerciseColumn].Column.Width = 250;
SourceGrid.Cells.Editors.ComboBox cbEditor = new SourceGrid.Cells.Editors.ComboBox(typeof(ComboBoxItem));
//cbEditor.StandardValues = Enum.GetValues(typeof(MapperEntryOperation));
foreach (MapperEntryOperation type in Enum.GetValues(typeof(MapperEntryOperation)))
{
cbEditor.Control.Items.Add(new ComboBoxItem(type, EnumLocalizer.Default.Translate(type)));
}
cbEditor.Control.DropDownStyle = ComboBoxStyle.DropDownList;
cbEditor.Control.SelectedIndex = 0;
readOnlyView = new SourceGrid.Cells.Views.Cell();
grid1[newRowIndex, OperationColumn] = new SourceGrid.Cells.Cell(null, cbEditor);
grid1[newRowIndex, OperationColumn].View = readOnlyView;
grid1[newRowIndex, OperationColumn].Column.Width = 80;
UpdateCellsReadOnlyMode(grid1.Rows[newRowIndex]);
}
private async void Form_edit_Load(object sender, EventArgs e)
{
lookUpEdit.Properties.DataSource = await _userCtr.GetUsers();
lookUpEdit.Properties.DisplayMember = "UserName";
lookUpEdit.Properties.ValueMember = "id";
LookUpColumnInfo col;
col = new LookUpColumnInfo("UserName", "User Name", 100);
col.SortOrder = DevExpress.Data.ColumnSortOrder.Ascending;
lookUpEdit.Properties.Columns.Add(col);
}
/// <summary>
/// 生成DevLookUpEdit的显示下拉列表
/// by xlb 2013-01-06
/// </summary>
/// <param name="lookupEdit"></param>
/// <param name="table"></param>
private void AddLookupColumnInfo(LookUpEdit lookupEdit, KeyValuePair <string, string>[] fields)
{
try
{
lookupEdit.Properties.Columns.Clear();
for (int i = 0; i < fields.Length; i++)
{
KeyValuePair <string, string> field = fields[i];
LookUpColumnInfo luci = new LookUpColumnInfo(field.Key, field.Value, 100);
lookupEdit.Properties.Columns.Add(luci);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static void BindSimpleCustomDataSource(DependencyObjectCollection colls, LookUpEdit lookUpEdit)
{
LookUpColumnInfo c1 = new LookUpColumnInfo("Value");
c1.Visible = false;
LookUpColumnInfo c2 = new LookUpColumnInfo("DisplayName");
lookUpEdit.Properties.Columns.Add(c1);
lookUpEdit.Properties.Columns.Add(c2);
lookUpEdit.Properties.DisplayMember = "DisplayName";
lookUpEdit.Properties.ValueMember = "Value";
lookUpEdit.Properties.NullText = string.Empty;
lookUpEdit.Properties.TextEditStyle = 0;
lookUpEdit.Properties.ShowHeader = false;
lookUpEdit.Properties.DataSource = colls;
}
public static RepositoryItemLookUpEdit GetCotPLLookUp(string IDField, string DisplayField, DataTable DataLookup, string[] LookupVisibleFields, string[] Captions, string ColumnField, bool AllowBlank, params int[] Widths)
{
RepositoryItemLookUpEdit edit = new RepositoryItemLookUpEdit();
if (AllowBlank)
{
DataRow row = DataLookup.NewRow();
row[IDField] = -1;
row[DisplayField] = "";
DataLookup.Rows.InsertAt(row, 0);
}
edit.DataSource = DataLookup;
edit.ValueMember = IDField;
edit.DisplayMember = DisplayField;
edit.ImmediatePopup = true;
edit.ShowLines = true;
//edit.NullText=GlobalConst.NULL_TEXT);
int num = 0;
if (LookupVisibleFields != null)
{
for (int i = 0; i < LookupVisibleFields.Length; i++)
{
LookUpColumnInfo info = new LookUpColumnInfo();
info.FieldName = LookupVisibleFields[i];
info.Caption = Captions[i];
if (Widths != null)
{
info.Width = Widths[i];
}
else
{
info.Width = 40;
}
num += info.Width;
edit.Columns.Add(info);
}
}
edit.PopupWidth = num;
edit.TextEditStyle = 0;
if (Widths == null)
{
edit.BestFit();
}
return(edit);
}
/// <summary>
/// 扩展方法，绑定数据源
/// </summary>
/// <typeparam name="T">数据源类型</typeparam>
/// <param name="lkp"></param>
/// <param name="ds">数据源</param>
/// <param name="valueMember">值field</param>
/// <param name="displayMember">显示field</param>
public static void ExtBindingDataSource <T>(this LookUpEdit lkp, List <T> ds, string valueMember, string displayMember)
{
lkp.Properties.DataSource = ds;
lkp.Properties.ValueMember = valueMember;
lkp.Properties.DisplayMember = displayMember;
lkp.Properties.ShowFooter = false;
lkp.Properties.ShowHeader = false;
lkp.Properties.NullText = "";
lkp.Properties.DropDownRows = ds.Count;
var colKey = new LookUpColumnInfo(valueMember, 0, "id");
colKey.Visible = false;
var colText = new LookUpColumnInfo(displayMember, 50, "name");
lkp.Properties.Columns.AddRange(new LookUpColumnInfo[] { colKey, colText });
lkp.Properties.PopupFormMinSize = new Size(50, 10);
lkp.Properties.PopupWidth = lkp.Width - 2;
}
protected RepositoryItemLookUpEdit InitRepositoryForConfigValues(IEnumerable enumerable)
{
RepositoryItemLookUpEdit itemLookUpEdit = new RepositoryItemLookUpEdit();
itemLookUpEdit.DataSource = enumerable;
itemLookUpEdit.ValueMember = "ADConfigKeyValue";
itemLookUpEdit.DisplayMember = "ADConfigText";
itemLookUpEdit.ShowHeader = false;
itemLookUpEdit.TextEditStyle = TextEditStyles.Standard;
itemLookUpEdit.NullText = String.Empty;
LookUpColumnInfo column = new LookUpColumnInfo();
column.FieldName = "ADConfigText";
column.Width = 100;
itemLookUpEdit.Columns.Add(column);
itemLookUpEdit.PopupWidth = column.Width;
return(itemLookUpEdit);
}
private void fillExerciseComboBox()
{
LookUpColumnInfo selectedCol = (LookUpColumnInfo)cmbExerciseColumns.SelectedItem;
colExercise.DisplayMember = selectedCol.FieldName;
List <LocalizedExercise> exercises = new List <LocalizedExercise>();
foreach (ExerciseDTO exercise in ObjectsReposidory.Exercises)
{
LocalizedExercise localizedExercise = new LocalizedExercise(exercise);
exercises.Add(localizedExercise);
}
ExerciseDTO ex = new ExerciseDTO(Guid.Empty);
ex.Name = "<Dodaj>";
//exercises.Add(ex);
colExercise.DataSource = exercises;
}
private void Init()
{
leNguoiQL.Properties.DataSource = BUS_NhanVien.LayNhanVienDonGian();
leNguoiQL.Properties.DisplayMember = "EMPLOYEE_Name";
leNguoiQL.Properties.ValueMember = "EMPLOYEE_ID";
LookUpColumnInfo col = new LookUpColumnInfo("EMPLOYEE_ID", "Mã");
LookUpColumnInfo col1 = new LookUpColumnInfo("EMPLOYEE_Name", "Tên");
leNguoiQL.Properties.Columns.Add(col1);
leNguoiQL.Properties.Columns.Add(col);
if (add == true)
{
phatSinhMa();
}
else
{
LoadDuLieuKho();
}
}
public void AddEmptyRow(int setNumber)
{
SerieCellValueChangedController serieCellValueChangedController = new SerieCellValueChangedController(this);
int newRowIndex = grid1.Rows.Count;
grid1.Rows.Insert(newRowIndex);
var lookupEditor = new LookupEditEditor(typeof(Guid));
LookUpColumnInfo selectedCol = (LookUpColumnInfo)cmbExerciseColumns.SelectedItem;
lookupEditor.Control.SetDisplayColumn(selectedCol);
grid1[newRowIndex, ExerciseColumnIndex] = new SourceGrid.Cells.Cell(null, lookupEditor);
SourceGrid.Cells.Views.Cell readOnlyView = new SourceGrid.Cells.Views.Cell();
grid1[newRowIndex, ExerciseColumnIndex].View = readOnlyView;
grid1[newRowIndex, ExerciseColumnIndex].View.ForeColor = ApplicationColors.FGNullText;
grid1[newRowIndex, ExerciseColumnIndex].AddController(exerciseCellController);
grid1[newRowIndex, ExerciseColumnIndex].Editor.NullDisplayString = StrengthTrainingEntryStrings.SelectExercise;
grid1[newRowIndex, ExerciseColumnIndex].Column.Width = 250;
grid1[newRowIndex, CommentColumnIndex] = new SourceGrid.Cells.Cell(null, new MemoExEditEditor());
readOnlyView = new SourceGrid.Cells.Views.Cell();
//grid1[newRowIndex, 1].AddController(ee);
grid1[newRowIndex, CommentColumnIndex].View = readOnlyView;
grid1[newRowIndex, CommentColumnIndex].AddController(CommentableCellController);
grid1[newRowIndex, CommentColumnIndex].Column.Width = 80;
//string SerieRepetitionMask = string.Format(@"[0-9]*x[0-9]*[\{0}]?[0-9]*",System.Globalization.CultureInfo.CurrentCulture.NumberFormat.NumberDecimalSeparator);
for (int i = 0; i < setNumber; i++)
{
//readOnlyView = new SourceGrid.Cells.Views.Cell();
var maskEditor = new SetEditor();
//maskEditor.MaskRegEx = SerieRepetitionMask;
grid1[newRowIndex, StandardColumnNumber + i] = new SourceGrid.Cells.Cell(null, maskEditor);
grid1[newRowIndex, StandardColumnNumber + i].AddController(serieCellValueChangedController);
grid1[newRowIndex, StandardColumnNumber + i].AddController(popupMenuController);
grid1[newRowIndex, StandardColumnNumber + i].View = new SetView();
}
UpdateCellsReadOnlyMode(grid1.Rows[newRowIndex]);
}
/// <summary>
/// 创建函数列表的datasource
/// 需要添加空白行
/// </summary>
/// <param name="pickListName"></param>
/// <param name="lookUpEdit"></param>
/// <returns></returns>
private DependencyObjectCollection GetFunDataSource(string pickListName, LookUpEdit lookUpEdit)
{
DependencyObjectCollection items = GetPickListDataource(pickListName, false);
LookUpColumnInfo c1 = new LookUpColumnInfo("Value");
c1.Visible = false;
LookUpColumnInfo c2 = new LookUpColumnInfo("DisplayName");
lookUpEdit.Properties.Columns.Add(c1);
lookUpEdit.Properties.Columns.Add(c2);
lookUpEdit.Properties.DataSource = items;
lookUpEdit.Properties.DisplayMember = "DisplayName";
lookUpEdit.Properties.ValueMember = "Value";
lookUpEdit.Properties.NullText = string.Empty;
lookUpEdit.Properties.TextEditStyle = 0;
lookUpEdit.Properties.ShowHeader = false;
return(items);
}
private void Get_Load()
{
var obral = new BRWarehouse();
var obrmo = new BRReason();
var olsal = obral.Get_PSGN_SPLS_SVMC_ALMA(xfMain.SgIns.SESSION_COMP);
var olsmo = obrmo.Get_PSGN_SPLS_SVMC_MOTI(xfMain.SgIns.SESSION_COMP);
lkeCOD_ALMA.Properties.DataSource = olsal;
lkeCOD_ALMA.Properties.Columns.Clear();
var lkci = new LookUpColumnInfo("ALF_ALMA", "Almacén", 20);
lkeCOD_ALMA.Properties.Columns.Add(lkci);
lkeCOD_ALMA.Properties.DisplayMember = "ALF_ALMA";
lkeCOD_ALMA.Properties.ValueMember = "COD_ALMA";
lkeCOD_MOTI.Properties.DataSource = olsmo;
lkeCOD_MOTI.Properties.Columns.Clear();
lkci = new LookUpColumnInfo("ALF_MOTI", "Motivo", 20);
lkeCOD_MOTI.Properties.Columns.Add(lkci);
lkeCOD_MOTI.Properties.DisplayMember = "ALF_MOTI";
lkeCOD_MOTI.Properties.ValueMember = "COD_MOTI";
}
protected virtual void InitObjectDataToLookupEdit()
{
VinaDbUtil vinaDbUtil = new VinaDbUtil();
if (string.IsNullOrEmpty(this.VinaDataMember))
{
return;
}
if (vinaDbUtil.IsForeignKey(this.VinaDataSource, this.VinaDataMember))
{
this.InitObjectDataFromLookupTable(vinaDbUtil.GetPrimaryTableWhichForeignColumnReferenceTo(this.VinaDataSource, this.VinaDataMember));
return;
}
string configValueGroup = this.VinaDataMember.Substring(2, this.VinaDataMember.Length - 2);
if (configValueGroup.EndsWith("PaymentMethodType"))
{
configValueGroup = "PaymentMethod";
}
IEnumerable configValues = Enumerable.Empty <ADConfigValuesInfo>();
if (!VinaUtil.ADConfigValueUtility.TryGetValue(configValueGroup, out configValues))
{
return;
}
this.Properties.ValueMember = "ADConfigKeyValue";
this.Properties.DisplayMember = "ADConfigText";
LookUpColumnInfo column = new LookUpColumnInfo();
column.FieldName = "ADConfigText";
column.Width = 100;
this.Properties.Columns.Add(column);
this.Properties.PopupWidth = column.Width;
this.Properties.ShowHeader = false;
this.Properties.DataSource = configValues;
}
/// <summary>
/// EVENTO LOAD DEL FORMULARIO
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void xfSalesCreditNote_Load(object sender, EventArgs e)
{
SESSION_USER = ((xfMain)MdiParent).SESSION_USER;
SESSION_PERF = ((xfMain)MdiParent).SESSION_PERF;
SESSION_COMP = ((xfMain)MdiParent).SESSION_COMP;
SESSION_IMPU = ((xfMain)MdiParent).SESSION_IMPU;
SESSION_PORC_IMPU = ((xfMain)MdiParent).SESSION_PORC_IMPU;
lblALF_IMPU.Text = SESSION_IMPU;
var obral = new BRWarehouse();
var olsal = obral.Get_PSGN_SPLS_SVMC_ALMA(SESSION_COMP);
lueCOD_ALMA.Properties.DataSource = olsal;
lueCOD_ALMA.Properties.Columns.Clear();
var lkci = new LookUpColumnInfo("ALF_ALMA", "Almacén", 20);
lueCOD_ALMA.Properties.Columns.Add(lkci);
lueCOD_ALMA.Properties.DisplayMember = "ALF_ALMA";
lueCOD_ALMA.Properties.ValueMember = "COD_ALMA";
//MONEDAS
var oBeMo = new BESVMC_MONE();
var oBrMo = new BRSVMC_MONE();
oBeMo.NUM_ACCI = 4;
oBeMo.COD_COMP = SESSION_COMP;
var oListMo = oBrMo.Get_SVPR_MONE_LIST(oBeMo);
lueCOD_MONE.Properties.DataSource = oListMo;
lueCOD_MONE.Properties.Columns.Clear();
lueCOD_MONE.Properties.Columns.Add(new LookUpColumnInfo("ALF_MONE", 100, "Moneda"));
lueCOD_MONE.Properties.DisplayMember = "ALF_MONE";
lueCOD_MONE.Properties.ValueMember = "COD_MONE";
gdcArticles.DataSource = oListArti;
gdcArticlesCompleted.DataSource = oListArtiCompleted;
gdcArticlesGroup.DataSource = oListArtiGroup;
gdcGroups.DataSource = oListGroup;
StateControl(true);
}
private void Get_Load()
{
stcControl.AppearanceReadOnly.BackColor = Color.FromArgb(255, 227, 239, 255);
SESSION_USER = ((xfMain)MdiParent).SESSION_USER;
SESSION_PERF = ((xfMain)MdiParent).SESSION_PERF;
SESSION_COMP = ((xfMain)MdiParent).SESSION_COMP;
InitializeCopy();
dteFEC_REGI.EditValue = DateTime.Now;
dteFEC_DOCU.EditValue = DateTime.Now;
dteFEC_ENTR.EditValue = DateTime.Now;
var obr = new BRPurchase();
var olcp = obr.Get_PSGN_SPLS_SVMC_COND_PAGO(SESSION_COMP);
var olmo = obr.Get_PSGN_SPLS_SVMC_MONE(SESSION_COMP);
lkeCOD_COND_PAGO.Properties.DataSource = olcp;
lkeCOD_COND_PAGO.Properties.Columns.Clear();
var lkci = new LookUpColumnInfo("ALF_COND_PAGO", "Condición de Pago", 20);
lkeCOD_COND_PAGO.Properties.Columns.Add(lkci);
lkeCOD_COND_PAGO.Properties.DisplayMember = "ALF_COND_PAGO";
lkeCOD_COND_PAGO.Properties.ValueMember = "COD_COND_PAGO";
lkeCOD_MONE.Properties.DataSource = olmo;
lkeCOD_MONE.Properties.Columns.Clear();
lkci = new LookUpColumnInfo("ALF_MONE", "Moneda", 20);
lkeCOD_MONE.Properties.Columns.Add(lkci);
lkeCOD_MONE.Properties.DisplayMember = "ALF_MONE";
lkeCOD_MONE.Properties.ValueMember = "COD_MONE";
lkeCOD_MONE.ItemIndex = 0;
var olstt = new List<BEStatus>();
olstt.Add(new BEStatus() { COD_ESTA = "AB", ALF_ESTA = "Abierto" });
olstt.Add(new BEStatus() { COD_ESTA = "CE", ALF_ESTA = "Cerrado" });
olstt.Add(new BEStatus() { COD_ESTA = "AN", ALF_ESTA = "Anulado" });
lkeIND_ESTA.Properties.DataSource = olstt;
lkeIND_ESTA.Properties.Columns.Clear();
lkci = new LookUpColumnInfo("ALF_ESTA", "Estado", 20);
lkeIND_ESTA.Properties.Columns.Add(lkci);
lkeIND_ESTA.Properties.DisplayMember = "ALF_ESTA";
lkeIND_ESTA.Properties.ValueMember = "COD_ESTA";
lkeIND_ESTA.ItemIndex = 0;
var obral = new BRWarehouse();
var olsal = obral.Get_PSGN_SPLS_SVMC_ALMA(SESSION_COMP);
lkeCOD_ALMA.Properties.DataSource = olsal;
lkeCOD_ALMA.Properties.Columns.Clear();
lkci = new LookUpColumnInfo("ALF_ALMA", "Almacén", 20);
lkeCOD_ALMA.Properties.Columns.Add(lkci);
lkeCOD_ALMA.Properties.DisplayMember = "ALF_ALMA";
lkeCOD_ALMA.Properties.ValueMember = "COD_ALMA";
gdcLines.DataSource = new List<BEDocumentLines>();
SetChangeMaskMoney(0);
StateControls(true);
if (docb != null)
Set_DocumentBase();
}
private void InitMe(ParticipantEntity pe)
{
this.cboPartType.Properties.DisplayMember = "Description";
this.cboPartType.Properties.ValueMember = "Type";
LookUpColumnInfo column = new LookUpColumnInfo("Description");
column.Caption = "参与者类型";
column.FieldName = "Description";
this.cboPartType.Properties.Columns.Clear();
this.cboPartType.Properties.Columns.Add(column);
this.cboPartType.Properties.DataSource = ParticipantTypeList.Get();
this.cboParticipantIDValue.EditValueChanged += delegate (object sender, EventArgs e) {
this.cboParticipantIDValue.Visible = true;
string editValue = (string) this.cboPartType.EditValue;
if (editValue != null)
{
if (!(editValue == "DEPT"))
{
if (editValue == "ROLE")
{
this.cboParticipantIDValue.Properties.DataSource = OGMService.Roles;
}
else if (editValue == "STAFF")
{
this.cboParticipantIDValue.Properties.DataSource = OGMService.Staffs;
}
else if (editValue == "ALL")
{
this.cboParticipantIDValue.EditValue = string.Empty;
this.cboParticipantIDValue.Properties.DataSource = null;
this.cboParticipantIDValue.Visible = false;
}
}
else
{
this.cboParticipantIDValue.Properties.DataSource = OGMService.Depts;
}
}
};
this.cboPartType.EditValue = pe.Type;
this.cboParticipantIDValue.Properties.DisplayMember = "Name";
this.cboParticipantIDValue.Properties.ValueMember = "Id";
column = new LookUpColumnInfo("Description");
column.Caption = "名称";
column.FieldName = "Name";
this.cboParticipantIDValue.Properties.Columns.Clear();
this.cboParticipantIDValue.Properties.Columns.Add(column);
this.cboParticipantIDValue.EditValue = pe.IdValue;
}
private void xfExpNationalization_Load(object sender, EventArgs e)
{
var obr = new BRPurchase();
var olst = obr.Get_PSCP_SPLS_SVMC_CNGN(SESSION_COMP);
rilConcept.DataSource = olst;
rilConcept.Columns.Clear();
var lkci = new LookUpColumnInfo("ALF_CONC_GANA", "Concepto", 20);
rilConcept.Columns.Add(lkci);
rilConcept.DisplayMember = "ALF_CONC_GANA";
rilConcept.ValueMember = "COD_CONC_GANA";
var olmo = obr.Get_PSGN_SPLS_SVMC_MONE(SESSION_COMP);
rilCOD_MONE.DataSource = olmo;
rilCOD_MONE.Columns.Clear();
lkci = new LookUpColumnInfo("ALF_MONE_SIMB", "Moneda", 20);
rilCOD_MONE.Columns.Add(lkci);
rilCOD_MONE.DisplayMember = "ALF_MONE_SIMB";
rilCOD_MONE.ValueMember = "COD_MONE";
if (olgn != null)
gdcExpens.DataSource = olgn;
}
private static void AddDataSource(ref DevExpress.XtraEditors.LookUpEdit le, System.Data.DataTable dt)
{
le.Properties.Columns.Clear();
le.Properties.DataSource = dt;
const Int32 width = 125;
int i = 0;
foreach (DataColumn dc in dt.Columns)
{
if (++i > 2)
break;
LookUpColumnInfo luColumnInfo = new LookUpColumnInfo(dc.Caption, width);
le.Properties.Columns.Add(luColumnInfo);
}
if (dt.Columns.Count >= 2)
{
le.Properties.ValueMember = dt.Columns[0].Caption;
le.Properties.DisplayMember = dt.Columns[1].Caption;
// get the first rows
le.EditValue = dt.Rows[0][0].ToString();
}
else
{
le.Properties.ValueMember = dt.Columns[0].Caption;
le.Properties.DisplayMember = dt.Columns[0].Caption;
// get the first rows
le.EditValue = dt.Rows[0][0].ToString();//DataBindings.Add("EditValue", dt,dt.Columns[0].Caption);
}
}
private void Get_Load()
{
SESSION_USER = ((xfMain)MdiParent).SESSION_USER;
SESSION_PERF = ((xfMain)MdiParent).SESSION_PERF;
SESSION_COMP = ((xfMain)MdiParent).SESSION_COMP;
var obral = new BRWarehouse();
var obrmo = new BRReason();
var olsal = obral.Get_PSGN_SPLS_SVMC_ALMA(SESSION_COMP);
var olsre = obral.Get_PSGN_SPLS_SVMC_SOCI_NEGO(SESSION_COMP);
var olsmo = obrmo.Get_PSGN_SPLS_SVMC_MOTI(SESSION_COMP);
lkeCOD_ALMA.Properties.DataSource = olsal;
lkeCOD_ALMA.Properties.Columns.Clear();
var lkci = new LookUpColumnInfo("ALF_ALMA", "Almacén Origen", 20);
lkeCOD_ALMA.Properties.Columns.Add(lkci);
lkeCOD_ALMA.Properties.DisplayMember = "ALF_ALMA";
lkeCOD_ALMA.Properties.ValueMember = "COD_ALMA";
lkeCOD_SOCI_NEGO_RESP.Properties.DataSource = olsre;
lkeCOD_SOCI_NEGO_RESP.Properties.Columns.Clear();
lkci = new LookUpColumnInfo("ALF_NOMB", "Responsable", 20);
lkeCOD_SOCI_NEGO_RESP.Properties.Columns.Add(lkci);
lkeCOD_SOCI_NEGO_RESP.Properties.DisplayMember = "ALF_NOMB";
lkeCOD_SOCI_NEGO_RESP.Properties.ValueMember = "COD_SOCI_NEGO";
lkeCOD_ALMA_DEST.Properties.DataSource = olsal;
lkeCOD_ALMA_DEST.Properties.Columns.Clear();
lkci = new LookUpColumnInfo("ALF_ALMA", "Almacén Destino", 20);
lkeCOD_ALMA_DEST.Properties.Columns.Add(lkci);
lkeCOD_ALMA_DEST.Properties.DisplayMember = "ALF_ALMA";
lkeCOD_ALMA_DEST.Properties.ValueMember = "COD_ALMA";
lkeCOD_SOCI_NEGO_RESP_DEST.Properties.DataSource = olsre;
lkeCOD_SOCI_NEGO_RESP_DEST.Properties.Columns.Clear();
lkci = new LookUpColumnInfo("ALF_NOMB", "Responsable", 20);
lkeCOD_SOCI_NEGO_RESP_DEST.Properties.Columns.Add(lkci);
lkeCOD_SOCI_NEGO_RESP_DEST.Properties.DisplayMember = "ALF_NOMB";
lkeCOD_SOCI_NEGO_RESP_DEST.Properties.ValueMember = "COD_SOCI_NEGO";
lkeCOD_MOTI.Properties.DataSource = olsmo;
lkeCOD_MOTI.Properties.Columns.Clear();
lkci = new LookUpColumnInfo("ALF_MOTI", "Motivo", 20);
lkeCOD_MOTI.Properties.Columns.Add(lkci);
lkeCOD_MOTI.Properties.DisplayMember = "ALF_MOTI";
lkeCOD_MOTI.Properties.ValueMember = "COD_MOTI";
var obj = new BETransferGoodsDetail() { COD_USUA_CREA = SESSION_USER };
var olst = new List<BETransferGoodsDetail>();
olst.Add(obj);
gdcDetail.DataSource = olst;
}
private void Get_Load()
{
SESSION_USER = ((xfMain)MdiParent).SESSION_USER;
SESSION_PERF = ((xfMain)MdiParent).SESSION_PERF;
SESSION_COMP = ((xfMain)MdiParent).SESSION_COMP;
var obral = new BRWarehouse();
var oBeM = new BEReason();
oBeM.COD_COMP = SESSION_COMP;
oBeM.COD_TIPO_MOTI = 2;
oBeM.NUM_ACCI = 4;
var obrmo = new BRSVMC_MOTI();
var olsal = obral.Get_PSGN_SPLS_SVMC_ALMA(SESSION_COMP);
var olsre = obral.Get_PSGN_SPLS_SVMC_SOCI_NEGO(SESSION_COMP);
var olsmo = obrmo.Get_SVPR_MOTI_LIST(oBeM);
lkeCOD_ALMA.Properties.DataSource = olsal;
lkeCOD_ALMA.Properties.Columns.Clear();
var lkci = new LookUpColumnInfo("ALF_ALMA", "Almacén", 20);
lkeCOD_ALMA.Properties.Columns.Add(lkci);
lkeCOD_ALMA.Properties.DisplayMember = "ALF_ALMA";
lkeCOD_ALMA.Properties.ValueMember = "COD_ALMA";
lkeCOD_SOCI_NEGO_RESP.Properties.DataSource = olsre;
lkeCOD_SOCI_NEGO_RESP.Properties.Columns.Clear();
lkci = new LookUpColumnInfo("ALF_NOMB", "Responsable", 20);
lkeCOD_SOCI_NEGO_RESP.Properties.Columns.Add(lkci);
lkeCOD_SOCI_NEGO_RESP.Properties.DisplayMember = "ALF_NOMB";
lkeCOD_SOCI_NEGO_RESP.Properties.ValueMember = "COD_SOCI_NEGO";
lkeCOD_MOTI.Properties.DataSource = olsmo;
lkeCOD_MOTI.Properties.Columns.Clear();
lkci = new LookUpColumnInfo("ALF_MOTI", "Motivo", 20);
lkeCOD_MOTI.Properties.Columns.Add(lkci);
lkeCOD_MOTI.Properties.DisplayMember = "ALF_MOTI";
lkeCOD_MOTI.Properties.ValueMember = "COD_MOTI";
var obj = new BEOutputGoodsDetail() { COD_USUA_CREA = SESSION_USER };
var olst = new List<BEOutputGoodsDetail>();
olst.Add(obj);
gdcDetail.DataSource = olst;
}
private void FrmEditProject_Load(object sender, EventArgs e)
{
SetData();
string q1 = "";
string q2 = "";
string q3 = "";
string q4 = "";
string q5 = "";
string q6 = "";
string q7 = "";
string q8 = "";
string q9 = "";
string q10 = "";
string q11 = "";
string q12 = "";
int t1 = 0;
PSP_PowerProValues_LangFang ppt = new PSP_PowerProValues_LangFang();
ppt.ID = poweruid;
ppt.Flag2 = flag;
PSP_PowerProValues_LangFang ps = Common.Services.BaseService.GetOneByKey<PSP_PowerProValues_LangFang>(ppt);
if (ps != null)
{
groupBox1.Text = ps.Title;
powerid = ps.Code;
t1 = ps.Flag;
// q1 = ps.L1;
// q2 = ps.L2;
q3 = ps.L3;
q4 = ps.L4;
q5 = ps.L5;
q6 = ps.L6;
q7 = ps.L7;
q8 = ps.L8;
q9 = ps.L9;
q10 = ps.L10.ToString();
q11 = ps.L11;
q12 = ps.L12.ToString();
}
LineInfo li22 = Common.Services.BaseService.GetOneByKey<LineInfo>(powerid);
if (li22 != null || t1==1)
{
isline = true;
}
substation sb = Common.Services.BaseService.GetOneByKey<substation>(powerid);
if (sb != null || t1 == 2)
{
isPower = true;
}
PowerProValues ppv = new PowerProValues();
ppv.TypeID = poweruid;
ppv.TypeID1 = flag;
IList<PowerProValues> listValues = Common.Services.BaseService.GetList<PowerProValues>("SelectPowerProValuesList", ppv);
PowerProYears pps = new PowerProYears();
pps.Flag = flag;
IList<PowerProYears> li = Common.Services.BaseService.GetList<PowerProYears>("SelectPowerProYearsListByFlag", pps);
lb=new Label[li.Count];
te=new TextEdit[li.Count];
int i=0;
//if (!isPower)
// {
////lt1.Text = "�豸����:";
////lt1.Location = new Point(52, 27 + 33 * i);
////groupBox1.Controls.Add(lt1);
////tt1 = new TextEdit();
////tt1.Location = new Point(157, 26 + 33 * i);
////tt1.Size = new Size(231, 21);
////tt1.TextChanged += new EventHandler(tt1_TextChanged);
////tt1.Properties.DisplayFormat.FormatString = "n4";
////tt1.Properties.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
////tt1.Properties.EditFormat.FormatString = "n4";
////tt1.Properties.EditFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
////tt1.Properties.Mask.EditMask = "#####0.####";
////tt1.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric;
////groupBox1.Controls.Add(tt1);
////i++;
////lt2.Text = "̨��:";
////lt2.Location = new Point(52, 27 + 33 * i);
////groupBox1.Controls.Add(lt2);
////tt2 = new TextEdit();
////tt2.Location = new Point(157, 26 + 33 * i);
////tt2.Size = new Size(231, 21);
////groupBox1.Controls.Add(tt2);
////i++;
// }
//if (!isline)
{
lt3.Text = "�� �� �� �� :";
lt3.Location = new Point(52, 27 + 33 * i);
groupBox1.Controls.Add(lt3);
// tt3 = new TextEdit();
cb0.Location = new Point(157, 26 + 33 * i);
cb0.Size = new Size(231, 21);
cb0.Properties.DisplayFormat.FormatString = "n0";
cb0.Properties.DisplayFormat.FormatType = DevExpress.Utils.FormatType.None;
cb0.Properties.EditFormat.FormatString = "n0";
cb0.Properties.EditFormat.FormatType = DevExpress.Utils.FormatType.None;
// cb0.Properties.Mask.EditMask = "########";
cb0.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.None;
groupBox1.Controls.Add(cb0);
i++;
lt4.Text = "�� ѹ �� �� :";
lt4.Location = new Point(52, 27 + 33 * i);
groupBox1.Controls.Add(lt4);
// tt4 = new TextEdit();
cb1.Location = new Point(157, 26 + 33 * i);
cb1.Size = new Size(231, 21);
cb1.Properties.DisplayFormat.FormatString = "n4";
cb1.Properties.DisplayFormat.FormatType = DevExpress.Utils.FormatType.None;
cb1.Properties.EditFormat.FormatString = "n4";
cb1.Properties.EditFormat.FormatType = DevExpress.Utils.FormatType.None;
// cb1.Properties.Mask.EditMask = "#####0.####";
cb1.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.None;
groupBox1.Controls.Add(cb1);
i++;
lt5.Text = "�� �� ̨ �� :";
lt5.Location = new Point(52, 27 + 33 * i);
groupBox1.Controls.Add(lt5);
// tt5 = new TextEdit();
cb2.Location = new Point(157, 26 + 33 * i);
cb2.Size = new Size(231, 21);
cb2.Properties.DisplayFormat.FormatString = "####.##";
cb2.Properties.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
cb2.Properties.EditFormat.FormatString = "####.##";
cb2.Properties.EditFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
// cb2.Properties.Mask.EditMask = "P2";
cb2.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric;
groupBox1.Controls.Add(cb2);
i++;
lt6.Text = "��̨������MVA��:";
lt6.Location = new Point(50, 27 + 33 * i);
lt6.Width = 105;
groupBox1.Controls.Add(lt6);
//tt6 = new TextEdit();
cb3.Location = new Point(157, 26 + 33 * i);
cb3.Size = new Size(231, 21);
cb3.Properties.DisplayFormat.FormatString = "n4";
cb3.Properties.DisplayFormat.FormatType = DevExpress.Utils.FormatType.None;
cb3.Properties.EditFormat.FormatString = "n4";
cb3.Properties.EditFormat.FormatType = DevExpress.Utils.FormatType.None;
// cb3.Properties.Mask.EditMask = "#####0.####";
cb3.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.None;
groupBox1.Controls.Add(cb3);
i++;
lt7.Text = "�� �� �� ʽ :";
lt7.Location = new Point(52, 27 + 33 * i);
groupBox1.Controls.Add(lt7);
//tt6 = new TextEdit();
cb4.Location = new Point(157, 26 + 33 * i);
cb4.Size = new Size(231, 21);
cb4.Properties.DisplayFormat.FormatString = "n4";
cb4.Properties.DisplayFormat.FormatType = DevExpress.Utils.FormatType.None;
cb4.Properties.EditFormat.FormatString = "n4";
cb4.Properties.EditFormat.FormatType = DevExpress.Utils.FormatType.None;
// cb4.Properties.Mask.EditMask = "#####0.####";
cb4.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.None;
groupBox1.Controls.Add(cb4);
i++;
lt8.Text = "��·���ȣ�KM��:";
lt8.Location = new Point(52, 27 + 33 * i);
groupBox1.Controls.Add(lt8);
//tt6 = new TextEdit();
tt4.Location = new Point(157, 26 + 33 * i);
tt4.Size = new Size(231, 21);
tt4.Properties.DisplayFormat.FormatString = "n4";
tt4.Properties.DisplayFormat.FormatType = DevExpress.Utils.FormatType.None;
tt4.Properties.EditFormat.FormatString = "n4";
tt4.Properties.EditFormat.FormatType = DevExpress.Utils.FormatType.None;
// tt4.Properties.Mask.EditMask = "#####0.####";
tt4.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.None;
groupBox1.Controls.Add(tt4);
i++;
lt9.Text = "�� �� �� �� :";
lt9.Location = new Point(52, 27 + 33 * i);
groupBox1.Controls.Add(lt9);
//tt6 = new TextEdit();
cb5.Location = new Point(157, 26 + 33 * i);
cb5.Size = new Size(231, 21);
cb5.Properties.DisplayFormat.FormatString = "n4";
cb5.Properties.DisplayFormat.FormatType = DevExpress.Utils.FormatType.None;
cb5.Properties.EditFormat.FormatString = "n4";
cb5.Properties.EditFormat.FormatType = DevExpress.Utils.FormatType.None;
// cb5.Properties.Mask.EditMask = "#####0.####";
cb5.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.None;
groupBox1.Controls.Add(cb5);
i++;
Project_Sum sum = new Project_Sum();
sum.S5 = islineflag;
sum.S1 = q4;
IList<Project_Sum> list = Services.BaseService.GetList<Project_Sum>("SelectProject_SumByS1andS5",sum);
upedit.Properties.DataSource = list;
LookUpColumnInfo a = new LookUpColumnInfo();
a.FieldName = "T3";
a.Caption = "������ʽ";
LookUpColumnInfo c = new LookUpColumnInfo();
c.FieldName = "T2";
c.Caption = "���߹�ģ";
LookUpColumnInfo b = new LookUpColumnInfo();
b.FieldName = "T1";
b.Caption = "����̨��������";
LookUpColumnInfo d = new LookUpColumnInfo();
d.Caption = "��̬Ͷ��";
d.FieldName = "Num";
LookUpColumnInfo nn = new LookUpColumnInfo();
nn.FieldName = "Name";
nn.Caption = "���";
LookUpColumnInfo f = new LookUpColumnInfo();
f.FieldName = "Type";
f.Caption = "����";
upedit.Properties.Columns.Add(f);
upedit.Properties.Columns.Add(nn);
upedit.Properties.Columns.Add(b);
upedit.Properties.Columns.Add(c);
upedit.Properties.Columns.Add(a);
upedit.Properties.Columns.Add(d);
upedit.Properties.DisplayMember = "Num";
//upedit.Properties.SearchMode = SearchMode.AutoComplete;
//upedit.Properties.AutoSearchColumnIndex = 5;
upedit.Properties.DropDownRows =5;
upedit.Properties.PopupWidth = 500;
upedit.Properties.ShowHeader = true;
lt10.Text = "Ͷ �� �� �� :";
lt10.Location = new Point(52, 27 + 33 * i);
groupBox1.Controls.Add(lt10);
upedit.Location = new Point(157, 26 + 33 * i);
upedit.Size = new Size(231, 21);
upedit.Properties.DisplayFormat.FormatString = "n4";
upedit.Properties.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
upedit.Properties.EditFormat.FormatString = "n4";
upedit.Properties.EditFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
upedit.Properties.Mask.EditMask = "###############0.####";
upedit.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric;
upedit.Properties.AllowNullInput=DevExpress.Utils.DefaultBoolean.True;
upedit.TextChanged += new EventHandler(upedit_TextChanged);
groupBox1.Controls.Add(upedit);
i++;
lt11.Text = "�� �� �� �� :";
lt11.Location = new Point(52, 27 + 33 * i);
groupBox1.Controls.Add(lt11);
//tt6 = new TextEdit();
tt6.Location = new Point(157, 26 + 33 * i);
tt6.Size = new Size(231, 21);
tt6.Properties.DisplayFormat.FormatString = "n4";
tt6.Properties.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
tt6.Properties.EditFormat.FormatString = "n4";
tt6.Properties.EditFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
tt6.Properties.Mask.EditMask = "###############0.####";
tt6.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric;
tt6.TextChanged += new EventHandler(tt6_TextChanged);
groupBox1.Controls.Add(tt6);
i++;
lt12.Text = "�� �� �� �� :";
lt12.Location = new Point(52, 27 + 33 * i);
groupBox1.Controls.Add(lt12);
//tt6 = new TextEdit();
tt5.Location = new Point(157, 26 + 33 * i);
tt5.Size = new Size(231, 21);
tt5.Properties.DisplayFormat.FormatString = "n4";
tt5.Properties.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
tt5.Properties.EditFormat.FormatString = "n4";
tt5.Properties.EditFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
tt5.Properties.Mask.EditMask = "###############0.####";
tt5.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric;
groupBox1.Controls.Add(tt5);
i++;
}
int j = 0;
foreach (PowerProYears ppy in li)
{
lb[j] = new Label();
lb[j].Name = "Label" + ppy.Year;
lb[j].Text = ppy.Year + ":";
lb[j].Location = new Point(52, 27 + 33 * i);
groupBox1.Controls.Add(lb[j]);
te[j] = new TextEdit();
te[j].Name = "Text" + ppy.Year;
te[j].Location = new Point(157, 26 + 33 * i);
te[j].Size = new Size(231, 21);
groupBox1.Controls.Add(te[j]);
foreach (PowerProValues ppy1 in listValues)
{
if (ppy.Year == ppy1.Year)
te[j].Text = ppy1.Value;
}
j++;
i++;
}
if (isline)
{
try
{
// cb5.Properties.Items.Contains(q9.ToString());
//tt1.Text = q3.ToString();
//tt2.Text = q4.ToString();
//if (li22 != null)
//{
// tt1.Text = li22.Length;
// tt2.Text = li22.LineType;
//}
}
catch { }
}
if (isPower)
{
try
{
////tt3.Text = q1.ToString();
//tt4.Text = q4.ToString();
//tt5.Text = q5.ToString();
//tt6.Text = q6.ToString();
//if (sb != null)
//{
// tt5.Text = sb.Number.ToString();
// tt4.Text = sb.ObligateField2;
// tt6.Text = sb.Burthen.ToString();
//}
}
catch { }
}
PSP_PowerProValues_LangFang pplf = new PSP_PowerProValues_LangFang();
pplf.Flag2 = flag;
IList<PSP_PowerProValues_LangFang> plfs = Common.Services.BaseService.GetList<PSP_PowerProValues_LangFang>("SelectPSP_PowerProValues_LangFangByFlag2OrderL3", pplf);
tt4.Text = q8.ToString();
tt5.Text = q10.ToString();
tt6.Text = q12.ToString();
if (plfs.Count == 0)
{
cb0.Text = "";
}
foreach (PSP_PowerProValues_LangFang pv in plfs)
{
if(pv.L3!=""&&pv.L3.Length>0)
cb0.Properties.Items.Add(pv.L3);
}
cb0.Text = q3.ToString();
cb1.Text = q4.ToString();
cb2.Text = q5.ToString();
cb3.Text = q6.ToString();
cb4.Text = q7.ToString();
cb5.Text = q9.ToString();
lookupedit = q11;
upedit.Properties.NullText = q11;
groupBox1.Size = new Size(434, 40+ 33 * i);
simpleButton1.Location = new Point(296, 60 + 33 * i);
simpleButton2.Location = new Point(389, 60 + 33 * i);
this.Size = new Size(490, 130 + 33 * i);
}
private void Get_Load()
{
SESSION_USER = ((xfMain)MdiParent).SESSION_USER;
SESSION_PERF = ((xfMain)MdiParent).SESSION_PERF;
SESSION_COMP = ((xfMain)MdiParent).SESSION_COMP;
var obrt = new BRTypeArticle();
var oltp = obrt.Get_PSGN_SPLS_SVMC_TIPO_ARTI(SESSION_COMP);
lkeCOD_TIPO_ARTI.Properties.DataSource = oltp;
lkeCOD_TIPO_ARTI.Properties.Columns.Clear();
var lkci = new LookUpColumnInfo("ALF_TIPO_ARTI", "Tipos de Artículo", 20);
lkeCOD_TIPO_ARTI.Properties.Columns.Add(lkci);
lkeCOD_TIPO_ARTI.Properties.DisplayMember = "ALF_TIPO_ARTI";
lkeCOD_TIPO_ARTI.Properties.ValueMember = "COD_TIPO_ARTI";
var obrm = new BRModelArticle();
var olmp = obrm.Get_PSGN_SPLS_SVMC_MODE_ARTI(SESSION_COMP);
lkeCOD_MODE_ARTI.Properties.DataSource = olmp;
lkeCOD_MODE_ARTI.Properties.Columns.Clear();
lkci = new LookUpColumnInfo("ALF_MODE_ARTI", "Modelos de Artículo", 20);
lkeCOD_MODE_ARTI.Properties.Columns.Add(lkci);
lkeCOD_MODE_ARTI.Properties.DisplayMember = "ALF_MODE_ARTI";
lkeCOD_MODE_ARTI.Properties.ValueMember = "COD_MODE_ARTI";
StateControls(true);
}
private void xfQuote_Load(object sender, EventArgs e)
{
SESSION_USER = ((xfMain)MdiParent).SESSION_USER;
SESSION_PERF = ((xfMain)MdiParent).SESSION_PERF;
SESSION_COMP = ((xfMain)MdiParent).SESSION_COMP;
SESSION_IMPU = ((xfMain)MdiParent).SESSION_IMPU;
SESSION_PORC_IMPU = ((xfMain)MdiParent).SESSION_PORC_IMPU;
lblALF_IMPU.Text = SESSION_IMPU;
//MONEDAS
var oBeMo = new BESVMC_MONE();
var oBrMo = new BRSVMC_MONE();
oBeMo.NUM_ACCI = 4;
oBeMo.COD_COMP = SESSION_COMP;
var oListMo = oBrMo.Get_SVPR_MONE_LIST(oBeMo);
lueCOD_MONE.Properties.DataSource = oListMo;
lueCOD_MONE.Properties.Columns.Clear();
lueCOD_MONE.Properties.Columns.Add(new LookUpColumnInfo("ALF_MONE", 100, "Moneda"));
lueCOD_MONE.Properties.DisplayMember = "ALF_MONE";
lueCOD_MONE.Properties.ValueMember = "COD_MONE";
//PROYECTOS
var oBePr = new BESVMC_PROY();
var oBrPr = new BRSVMC_PROY();
oBePr.NUM_ACCI = 5;
oBePr.COD_COMP = SESSION_COMP;
var oListPr = oBrPr.Get_SVPR_PROY_LIST(oBePr);
lueCOD_PROY.Properties.DataSource = oListPr;
lueCOD_PROY.Properties.Columns.Clear();
lueCOD_PROY.Properties.Columns.Add(new LookUpColumnInfo("ALF_PROY", 100, "Proyecto"));
lueCOD_PROY.Properties.DisplayMember = "ALF_PROY";
lueCOD_PROY.Properties.ValueMember = "COD_PROY";
//MOTIVOS
var oBeM = new BEReason();
oBeM.COD_COMP = SESSION_COMP;
oBeM.COD_TIPO_MOTI = 2;
oBeM.NUM_ACCI = 4;
var obrmo = new BRSVMC_MOTI();
var olsmo = obrmo.Get_SVPR_MOTI_LIST(oBeM);
lkeCOD_MOTI.Properties.DataSource = olsmo;
lkeCOD_MOTI.Properties.Columns.Clear();
var lkci = new LookUpColumnInfo("ALF_MOTI", "Motivo", 20);
lkeCOD_MOTI.Properties.Columns.Add(lkci);
lkeCOD_MOTI.Properties.DisplayMember = "ALF_MOTI";
lkeCOD_MOTI.Properties.ValueMember = "COD_MOTI";
//EJECUTIVO COMERCIAL
var oBeE = new BESVMC_SOCI_NEGO();
var oBrE = new BRSVMC_SOCI_NEGO();
oBeE.NUM_ACCI = 5;
oBeE.COD_COMP = SESSION_COMP;
var oListE = oBrE.Get_SVPR_SOCI_NEGO_LIST(oBeE);
lueCOD_EJEC_COME.Properties.DataSource = oListE;
lueCOD_EJEC_COME.Properties.Columns.Clear();
lueCOD_EJEC_COME.Properties.Columns.Add(new LookUpColumnInfo("ALF_NOMB", 100, "Ejecutivo comercial"));
lueCOD_EJEC_COME.Properties.DisplayMember = "ALF_NOMB";
lueCOD_EJEC_COME.Properties.ValueMember = "COD_SOCI_NEGO";
gdcArticles.DataSource = oListArti;
gdcArticlesGroup.DataSource = oListArtiGroup;
gdcGroups.DataSource = oListGroup;
StateControl(true);
}
private void Get_Load()
{
var obr = new BRWarehouse();
var olen = obr.Get_PSGN_SPLS_SVMC_SOCI_NEGO(SESSION_COMP);
rilCOD_SOCI_NEGO_ENCA.DataSource = olen;
rilCOD_SOCI_NEGO_ENCA.Columns.Clear();
var lkci = new LookUpColumnInfo("ALF_NOMB", "Encargados", 20);
rilCOD_SOCI_NEGO_ENCA.Columns.Add(lkci);
rilCOD_SOCI_NEGO_ENCA.DisplayMember = "ALF_NOMB";
rilCOD_SOCI_NEGO_ENCA.ValueMember = "COD_SOCI_NEGO";
var olst = obr.Get_PSGN_SPLS_SVMC_ALMA(SESSION_COMP);
if (olst.Count == 0)
{
var obj = new BEWarehouse() { IND_MNTN = 1, COD_USUA_CREA = SESSION_USER };
olst.Add(obj);
}
gdcGeneric.DataSource = olst;
BeginInvoke(new MethodInvoker(() =>
{
gdvGeneric.MoveLast();
gdvGeneric.FocusedColumn = gdvGeneric.VisibleColumns[1];
gdvGeneric.ShowEditor();
}));
}