private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
EmpIDCbxe.Properties.Items.Clear();
ExchangeTablePage.PageVisible = true; //显示交接班页面
xtraTabControl1.SelectedTabPageIndex = 0; //切换到交接班页面
UserIDLableC.Text = IOHelper.userId;
UserNameLableC.Text = IOHelper.uerName;
if (IOHelper.userRoot)
{
UserRootLbl.Text = "管理员";
}
else
{
UserRootLbl.Text = "标准用户";
}
ExchangeClass readid = new ExchangeClass();
if (read.Count == 0)
{
read.AddRange(ExchangeClass.ReadOneColumns("员工编号"));
}
foreach (string item in read)
{
EmpIDCbxe.Properties.Items.Add(item);
}
EmpIDCbxe.Reset();
EmpPswTxtE.Reset();
}
/// <summary>
/// 换班
/// </summary>
private void ExchangeUser()
{
LoginClass Relogin = new LoginClass();
IOHelper rewrite = new IOHelper();
if (Relogin.JudgeUser(EmpIDCbxe.Text, EmpPswTxtE.Text, DBHelper.SerName))
{
rewrite.WriteConfig(DBHelper.SerName, EmpIDCbxe.Text, EmpPswTxtE.Text, IOHelper.PswChk);
rewrite.RemenberUser(EmpIDCbxe.Text);
ExchangeClass.RemenberRoot();
xtraTabControl1.CloseButtonClick(sender, e);
UserNamebarStaticItem.Caption = "当前用户：" + EmpNameLableC.Text;
}
}
public void OnSQLUpdated(object sender, EventArgs e)
{
var queryBuilder = QueryBuilderStore.Get("QueryAnalysis");
var data = new ExchangeClass();
data.Statistics = GetQueryStatistic(queryBuilder.QueryStatistics);
data.SubQueries = DumpSubQueries(queryBuilder);
data.QueryStructure = DumpQueryStructureInfo(queryBuilder.ActiveSubQuery);
data.UnionSubQuery = new UnionSubQueryExchangeClass();
data.UnionSubQuery.SelectedExpressions = DumpSelectedExpressionsInfoFromUnionSubQuery(queryBuilder.ActiveUnionSubQuery);
data.UnionSubQuery.DataSources = DumpDataSourcesInfoFromUnionSubQuery(queryBuilder.ActiveUnionSubQuery);
;
data.UnionSubQuery.Links = DumpLinksInfoFromUnionSubQuery(queryBuilder.ActiveUnionSubQuery);
data.UnionSubQuery.Where = GetWhereInfo(queryBuilder.ActiveUnionSubQuery);
queryBuilder.ExchangeData = data;
}
public void QueryBuilderControl1_OnSQLUpdated(object sender, EventArgs e, ClientData clientdata)
{
QueryBuilder queryBuilder = QueryBuilderControl1.QueryBuilder;
if (queryBuilder == null)
{
return;
}
var data = new ExchangeClass();
data.Statistics = GetQueryStatistic(queryBuilder.QueryStatistics);
data.SubQueries = DumpSubQueries(queryBuilder);
data.QueryStructure = DumpQueryStructureInfo(queryBuilder.ActiveSubQuery);
data.UnionSubQuery = new UnionSubQueryExchangeClass();
data.UnionSubQuery.SelectedExpressions = DumpSelectedExpressionsInfoFromUnionSubQuery(queryBuilder.ActiveSubQuery.ActiveUnionSubquery);
data.UnionSubQuery.DataSources = DumpDataSourcesInfoFromUnionSubQuery(queryBuilder.ActiveSubQuery.ActiveUnionSubquery);
;
data.UnionSubQuery.Links = DumpLinksInfoFromUnionSubQuery(queryBuilder.ActiveSubQuery.ActiveUnionSubquery);
data.UnionSubQuery.Where = GetWhereInfo(queryBuilder.ActiveSubQuery.ActiveUnionSubquery);
// data.UnionSubQuery.Where
SessionStore.Current.Exchange.Data = data;
}
