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);
}
