private void SetTabFocus(DevExpress.XtraTab.XtraTabPage pg)
{
if (pg.Name == "tabpagegrid")
{
frmDevBBShow frmbb = (pg.Controls[0] as frmDevBBShow);
frmbb.Activate();
frmbb.Focus();
}
else
{
frmDevPivotShow frmpivot = (pg.Controls[0] as frmDevPivotShow);
frmpivot.Activate();
frmpivot.Focus();
}
}
private void frmDevQryShow_Load(object sender, EventArgs e)
{
//defaultLookAndFeel1.LookAndFeel.Style = DevExpress.UserSkins.GSSkins;
//SkinManager.Default.RegisterSkin(new SkinBlobXmlCreator("Coffee", "SkinData.", typeof(BonusSkins).Assembly, null));
//defaultLookAndFeel1.LookAndFeel.SkinName = "Office 2007 Silver";
//defaultLookAndFeel1.LookAndFeel.SkinName = "The Asphalt World";
//defaultLookAndFeel1.LookAndFeel.SkinName = "Office 2013";
// UserLookAndFeel.Default.SetSkinStyle("Office 2013");
frmBBShow = new frmDevBBShow();
frmBBShow.Text = "查询--" + this.PsTitle;
frmBBShow.ProcessID = this.ProcessID;
frmBBShow.PsTitle = PsTitle;
frmBBShow.PsID = PsID;
frmBBShow.PsYear = PsYear;
frmBBShow.PsJEJD = PsJEJD;
frmBBShow.PsSLJD = PsSLJD;
frmBBShow.PsTitleTable = PsTitleTable;
frmBBShow.PsSelect = PsSelect;
frmBBShow.PsSubTitle = PsSubTitle;
frmBBShow.PsDWBH = PsDWBH;
frmBBShow.PsUsr = PsUsr;
frmBBShow.IsPivot = IsPivot;
frmBBShow.OrderKey = this.OrderKey;
frmBBShow.LinkQryID = this.LinkQryID;
frmBBShow.IsRepeatDown = this.IsRepeatDown;
frmBBShow.IsUseLocal = this.IsUseLocal;
frmBBShow.TopLevel = false;
frmBBShow.Location = new Point(0, 0);
frmBBShow.TopMost = false;
frmBBShow.ControlBox = false;
frmBBShow.Parent = this.tabpagegrid;
frmBBShow.OpenStyle = this.OpenStyle;
frmBBShow.Dock = DockStyle.Fill;
frmBBShow.MainForm = this;
frmBBShow.IsSql = this.IsSql;
frmBBShow.ParamArr = this.ParamArr;
frmBBShow.ValueArr = this.ValueArr;
frmBBShow.QryParam = this.QryParam;
frmBBShow.QryValue = this.QryValue;
frmBBShow.Show();
}
//public static void Main()
//{
// ThreadDemo demo = new ThreadDemo(1000);
// demo.Action();
//}
public WebSvrThreadGetData(string psprocessID, long psPgnum, string psSql, string psOrderKey, WsGetDataClient.WSGetData psMgr, frmDevBBShow psFrmshow)
{
processID = psprocessID;
pgnum = psPgnum;
sql = psSql;
strOrderKey = psOrderKey;
mgr = psMgr;
frmshow = psFrmshow;
string dbtype = mgr.getDBType(processID);
string vssql = "";
if (dbtype == "ora")
{
vssql = "select * from ( {0} )z1 where rownum>{1} and rownum<={2} ";
}
else
{
if (string.IsNullOrEmpty(strOrderKey))
{
throw new Exception("数据量过大，请联系开发人员调用异步加载方式！");
}
vssql = @"select top {1} * from
( select top {2} * from ({0}) z1 order by {3}) z2
order by {3} desc ";
}
threads = new Thread[pgnum];
for (int m = 0; m < pgnum; m++)
{
long longs = m * WebSvrGetData.pgNum;
long longe = (m + 1) * WebSvrGetData.pgNum;
if (dbtype == "ora")
{
sql = string.Format(vssql, sql, longs + "", longe + "");
}
else
{
sql = string.Format(vssql, sql, WebSvrGetData.pgNum, longe + "", strOrderKey);
}
threads[m] = new Thread(new ParameterizedThreadStart(getData));
threads[m].Start(sql);
}
OnNumberClear += new EventHandler(ThreadDemo_OnNumberClear);
}
