private void cbTeam_SelectedIndexChanged(object sender, EventArgs e) { try { string sqlText1 = string.Empty; int teamId = int.Parse(this.cbTeam.SelectedValue()); if (teamId > 0) { sqlText1 = $@"SELECT InvestorCode,InvestorName FROM TeamMember WHERE IsDeleted =0 AND TeamId = {teamId} ORDER BY InvestorName "; } else { sqlText1 = $@"SELECT InvestorCode,InvestorName FROM TeamMember WHERE IsDeleted =0 ORDER BY InvestorName "; } var ds = SqlHelper.ExecuteDataset(AppConfig._ConnString, CommandType.Text, sqlText1); if (ds == null || ds.Tables.Count == 0) { return; } List <ComboBoxItemModel> investorInfos = new List <ComboBoxItemModel>(); var allInvestor = new ComboBoxItemModel { Text = "全部人员", Value = "All" }; investorInfos.Add(allInvestor); investorInfos.AddRange(ds.Tables[0].AsEnumerable() .Select(x => new ComboBoxItemModel { Text = x.Field <string>("InvestorName"), Value = x.Field <string>("InvestorCode"), })); luInvestor.Initialize(investorInfos, "Value", "Text"); if (LoginInfo.CurrentUser.IsAdmin) { luInvestor.EditValue = "All"; } else { luInvestor.ReadOnly = true; luInvestor.EditValue = LoginInfo.CurrentUser.UserCode; } } catch (Exception ex) { DXMessage.ShowError(ex.Message); } }
private void BindSearchInfo() { //截至交易日 string sqlText1 = $@"SELECT MAX(TradeDate) FROM DSTradeTypeProfit"; var maxDate = SqlHelper.ExecuteScalar(AppConfig._ConnString, CommandType.Text, sqlText1); if (maxDate == null) { this.deEnd.EditValue = DateTime.Now.Date; } else { this.deEnd.EditValue = maxDate; } //投资小组 string sqlText2 = @" SELECT TeamId,TeamName FROM TeamInfo WHERE IsDeleted = 0 ORDER BY TeamId "; var ds = SqlHelper.ExecuteDataset(AppConfig._ConnString, CommandType.Text, sqlText2); if (ds == null || ds.Tables.Count == 0) { return; } List <ComboBoxItemModel> teamInfos = new List <ComboBoxItemModel>(); var allTeam = new ComboBoxItemModel { Text = "全部小组", Value = "-1" }; teamInfos.Add(allTeam); teamInfos.AddRange(ds.Tables[0].AsEnumerable() .Select(x => new ComboBoxItemModel { Text = x.Field <string>("TeamName"), Value = x.Field <int>("TeamId").ToString(), })); this.cbDepartment.Initialize(teamInfos, displayAdditionalItem: false); this.cbDepartment.DefaultSelected("-1"); //导出类型 this.rgFileType.SelectedIndex = 0; //保存路径 this.txtSavePath.Text = Environment.GetFolderPath(Environment.SpecialFolder.Desktop); }
/// <summary> /// Initialize ComboBoxEdit /// </summary> /// <param name="comboBox"></param> /// <param name="source"></param> /// <param name="displayAdditionalItem"></param> /// <param name="additionalItemText"></param> /// <param name="additionalItemValue"></param> public static void Initialize(this ComboBoxEdit comboBox, IList <ComboBoxItemModel> source, bool displayAdditionalItem = false, string additionalItemText = " 全部 ", string additionalItemValue = "0") { var count = source.Count; if (displayAdditionalItem) { var allSelect = new ComboBoxItemModel { Text = additionalItemText, Value = additionalItemValue, }; comboBox.Properties.Items.Add(allSelect); count += 1; } comboBox.Properties.Items.AddRange(source.ToList()); comboBox.Properties.NullText = "请选择..."; comboBox.Properties.DropDownRows = count; comboBox.Properties.TextEditStyle = TextEditStyles.DisableTextEditor; }
public void AllDataReadFailedOnLoad() { global_flag_Unusable = true; flagNoClientiNumere_bool = true; ComboBoxItemModel CBIModel = new ComboBoxItemModel(); CBIModel.Text = "---"; CBIModel.Value = 1; comboBoxClient.Items.Add(CBIModel); comboBoxClient.SelectedIndex = 0; comboBoxNrInmatriculare.Items.Add(CBIModel); comboBoxNrInmatriculare.SelectedIndex = 0; MessageBox.Show("Datele necesare nu exista in baza de date!\nContacteaza administrator!", "Datele necesare nu exista!", MessageBoxButtons.OK, MessageBoxIcon.Error); }
private void gridViewTypes_SelectionChanged(object sender, DevExpress.Data.SelectionChangedEventArgs e) { if (gridViewTypes.SelectedRowsCount == 0) { return; } var typeId = gridViewTypes.GetRowCellValue(gridViewTypes.GetSelectedRows()[0], "Id").ToString(); this.cbType.DefaultSelected(typeId); ComboBoxItemModel typeData = new ComboBoxItemModel { Text = gridViewTypes.GetRowCellValue(gridViewTypes.GetSelectedRows()[0], "Name").ToString(), Value = gridViewTypes.GetRowCellValue(gridViewTypes.GetSelectedRows()[0], "Id").ToString() }; this.cbType.SelectedItem = typeData; BindDictionaryInfo(int.Parse(typeData.Value)); }
/// <summary> /// Перезагрузка списка пользователей. /// </summary> void ReloadUsers(Action actionOnComplited) { SaveStartTask(ct => ClientCore.Instance.DataStore.GetUsers().ToList(), users => { _authModel.Users.Clear(); foreach (var user in users) { var item = new ComboBoxItemModel { Title = string.Format("{0} ({1})", user.LoginName, user.FirstName), Value = user.LoginName }; _authModel.Users.Add(item); } if (actionOnComplited != null) { actionOnComplited(); } //if }, (exception, isCanceled, isFaulted) => _authModel.ErrorText = "Ошибка получения пользователей"); }
private void BindSearchInfo() { this.deStart.Properties.AllowNullInput = DefaultBoolean.False; this.deEnd.Properties.AllowNullInput = DefaultBoolean.False; deStart.EditValue = "2017/08/04"; deEnd.EditValue = DateTime.Now; string sqlText1 = $@"SELECT TeamId,TeamName FROM TeamInfo WHERE IsDeleted = 0 ORDER BY TeamName "; var ds = SqlHelper.ExecuteDataset(AppConfig._ConnString, CommandType.Text, sqlText1); if (ds == null || ds.Tables.Count == 0) { return; } List <ComboBoxItemModel> teamInfos = new List <ComboBoxItemModel>(); var allTeam = new ComboBoxItemModel { Text = "全部小组", Value = "-1" }; teamInfos.Add(allTeam); teamInfos.AddRange(ds.Tables[0].AsEnumerable() .Select(x => new ComboBoxItemModel { Text = x.Field <string>("TeamName"), Value = x.Field <int>("TeamId").ToString(), })); this.cbTeam.Initialize(teamInfos, displayAdditionalItem: false); string defaultTeam = string.Empty; if (!LoginInfo.CurrentUser.IsAdmin) { string sqlText2 = $@"SELECT TeamId FROM TeamMember WHERE InvestorCode = '{LoginInfo.CurrentUser.UserCode}'"; var obj = SqlHelper.ExecuteScalar(AppConfig._ConnString, CommandType.Text, sqlText2); if (obj != null) { defaultTeam = obj.ToString(); } else { btnSearch.Enabled = false; return; } cbTeam.ReadOnly = true; } else { defaultTeam = "-1"; } this.cbTeam.DefaultSelected(defaultTeam); this.bandedGridView1.SetLayout(showAutoFilterRow: true, showCheckBoxRowSelect: false, setAlternateRowColor: false, rowIndicatorWidth: 1); this.bandedGridView1.SetColumnHeaderAppearance(); this.bandedGridView1.OptionsView.EnableAppearanceEvenRow = false; this.bandedGridView1.OptionsView.EnableAppearanceOddRow = false; this.ActiveControl = this.btnSearch; }
/// <summary> /// 绑定查询信息 /// </summary> private void BindSearchInfo() { //股票 var stocks = _stockService.GetAllStocks(showDeleted: true) .Select(x => new StockInfoModel { Id = x.Id, Code = x.Code, FullCode = x.FullCode, Name = x.Name, DisplayMember = x.FullCode + " - " + x.Name, } ).ToList(); var allStockModel = new StockInfoModel { Id = 0, FullCode = "000000", Name = "全部", DisplayMember = "000000 - 全部", }; stocks.Add(allStockModel); stocks = stocks.OrderBy(x => x.FullCode).ToList(); luStock.Initialize(stocks, "FullCode", "DisplayMember", enableSearch: true); //账户 BindAccount(); //数据类型 var dataTypes = new List <ComboBoxItemModel>(); var entrustModel = new ComboBoxItemModel { Text = "当日委托", Value = "1", }; dataTypes.Add(entrustModel); var dailyModel = new ComboBoxItemModel { Text = "当日成交", Value = "3", }; dataTypes.Add(dailyModel); var deliveryModel = new ComboBoxItemModel { Text = "交割单", Value = "2", }; dataTypes.Add(deliveryModel); var virtualModel = new ComboBoxItemModel { Text = "虚拟交易", Value = "77", }; dataTypes.Add(virtualModel); var stockTransferModel = new ComboBoxItemModel { Text = "股票转移", Value = "88", }; dataTypes.Add(stockTransferModel); var oldSystemModel = new ComboBoxItemModel { Text = "旧系统", Value = "99", }; dataTypes.Add(oldSystemModel); this.cbDataType.Initialize(dataTypes, displayAdditionalItem: true); //交易类别 var tradeTypes = _dictionaryService.GetDictionaryInfoByTypeId((int)EnumLibrary.DictionaryType.TradeType) .Select(x => new ComboBoxItemModel { Text = x.Name, Value = x.Code.ToString(), }).ToList(); cbTradeType.Initialize(tradeTypes, displayAdditionalItem: true); var allUserModel = new UserInfo { Code = string.Empty, Name = "全部", }; var dealers = _userService.GetAllOperators(showDeleted: true); dealers.Add(allUserModel); dealers = dealers.OrderBy(x => x.Code).ToList(); //受益人 luBeneficiary.Initialize(dealers, "Code", "Name", showHeader: true, enableSearch: true); var admins = _userService.GetAllAdmins(showDeleted: true); var importors = new List <UserInfo>(); importors.AddRange(dealers); importors.AddRange(admins); importors = importors.Distinct().OrderBy(x => x.Code).ToList(); //导入人 luImport.Initialize(importors, "Code", "Name", showHeader: true, enableSearch: true); }