Beispiel #1
0
        internal string SetRequestId(StuGLSearch stuGLSearch)
        {
            CheckData = true;
            //stuGLSearch = new CglMethod().GetMethodSN(stuGLSearch);
            //StuGLSearch stuGLSearchTemp = stuGLSearch;
            //stuGLSearchTemp = new CglMethod().GetSearchMethodSN(stuGLSearchTemp);
            //stuGLSearchTemp = new CglMethod().GetSecFieldSN(stuGLSearchTemp);
            int idhash = string.Format(InvariantCulture, "{0}{1}", Environment.MachineName, DateTime.Now.ToString(InvariantCulture)).GetHashCode();

            //stuGLSearch.LngTotalSN,
            //stuGLSearch.LngMethodSN,
            //stuGLSearch.LngSearchMethodSN,
            //stuGLSearch.LngSecFieldSN,
            //stuGLSearch.InDisplayPeriod,
            //stuGLSearch.HistoryTestPeriods,
            //stuGLSearch.InFreqDnaLength,
            //stuGLSearch.InTargetTestPeriods,
            //stuGLSearch.InFieldPeriodLimit

            return(string.Format(InvariantCulture, "{0}{1}_{2}",
                                 stuGLSearch.LottoType.ToString(),
                                 new CglData().GetCurrentDataDics(stuGLSearch)["lngDateSN"],
                                 idhash
                                 ));
        }
 private void DeleteTable(StuGLSearch stuGLSearch)
 {
     CheckData = true;
     using (SqlCommand sqlCommand = new SqlCommand())
     {
         sqlCommand.Connection  = new SqlConnection(new CglData().SetDataBase(stuGLSearch.LottoType, stuGLSearch.DataBaseType));
         sqlCommand.CommandText = "SELECT * FROM @tableName ";
         sqlCommand.Parameters.AddWithValue("tableName", stuGLSearch.StrCompares);
         using (SqlDataAdapter sdaDelTable = new SqlDataAdapter(sqlCommand))
         {
             using (DataTable dtDelTable = new DataTable())
             {
                 dtDelTable.Locale = InvariantCulture;
                 sdaDelTable.Fill(dtDelTable);
                 if (dtDelTable.Rows.Count > 0)
                 {
                     for (int i = 0; i < dtDelTable.Rows.Count; i++)
                     {
                         dtDelTable.Rows[i].Delete();
                     }
                 }
                 sdaDelTable.Update(dtDelTable);
             }
         }
     }
 }
Beispiel #3
0
        private void OpenPage(StuGLSearch stuGLSearch, string action, string requestId, string urlFileName, string windowName)
        {
            string strScript;
            string strUrl = string.Format(InvariantCulture, "http://{0}/Pages/{1}?action={2}&id={3}", Request.Url.Authority, urlFileName, action, requestId);

            if (stuGLSearch.ShowStaticHtml)
            {
                List <int> lstCurrentNums = (List <int>) new CglData().GetDataNumsLst(stuGLSearch);
                #region Check File
                string strFileName         = lstCurrentNums.Sum().Equals(0) ? string.Format(InvariantCulture, "{0}{1}Temp.html", action, requestId) : string.Format(InvariantCulture, "{0}{1}.html", action, requestId);
                string strCurrentDirectory = Server.MapPath("~");
                string strHtmlDirectory    = System.IO.Path.Combine(strCurrentDirectory, "html");
                if (!lstCurrentNums.Sum().Equals(0))
                {
                    DeleteTempFile(strHtmlDirectory, action, requestId);
                }
                #endregion Check File

                #region Creat static HTML file
                if (!new CglFunc().FileExist(strHtmlDirectory, strFileName) || stuGLSearch.Recalculate)
                {
                    string strFilePathName = Path.Combine(strHtmlDirectory, strFileName);
                    new GalaxyApp().CreatStaticHtml(new Uri(strUrl, UriKind.Absolute), strFilePathName, 3000000);
                }
                #endregion Creat static HTML file

                strUrl = string.Format(InvariantCulture, "http://{0}/html/{1}", Request.Url.Authority, strFileName);
            }
            strScript = string.Format(InvariantCulture, "window.open('{0}','{1}');", strUrl, windowName);
            ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", strScript, true);
            //Response.Write(string.Format(InvariantCulture, "<script language='javascript'>{0}</script>", strScript));
        }
        private void SetupViewState()
        {
            _action    = Request["action"] ?? (string)Session["action"] ?? (string)ViewState["action"] ?? string.Empty;
            _requestId = Request["id"] ?? (string)Session["id"] ?? (string)ViewState["id"] ?? string.Empty;
            if (ViewState["action"] == null)
            {
                ViewState.Add("action", _action);
            }
            if (ViewState["id"] == null)
            {
                ViewState.Add("id", _requestId);
            }
            FreqActiveChart01ID = _action + _requestId;

            if (ViewState[FreqActiveChart01ID + "_gstuSearch"] == null)
            {
                if (!string.IsNullOrEmpty(_action) && !string.IsNullOrEmpty(_requestId) && Session[FreqActiveChart01ID] != null)
                {
                    ViewState.Add(FreqActiveChart01ID + "_gstuSearch", (StuGLSearch)Session[FreqActiveChart01ID]);
                }
            }
            GlstuSearch = (StuGLSearch)ViewState[FreqActiveChart01ID + "_gstuSearch"];

            Session.Remove("action");
            Session.Remove("id");
            Session.Remove("UrlFileName");
        }
Beispiel #5
0
#pragma warning disable CA1707 // Identifiers should not contain underscores
        protected void Page_Load(object sender, EventArgs e)
#pragma warning restore CA1707 // Identifiers should not contain underscores
        {
            SetupViewState();
            if (ViewState["_gstuSearch"] == null)
            {
                Response.Write("<script language='javascript'>window.close();</script>");
            }
            else
            {
                _gstuSearch = (StuGLSearch)ViewState["_gstuSearch"];
                if (ViewState["title"] == null)
                {
                    ViewState.Add("title", string.Format(InvariantCulture, "{0}:{1}", "活性總表", new CglDBData().SetTitleString(_gstuSearch)));
                }
                if (ViewState["CurrentData"] == null)
                {
                    ViewState.Add("CurrentData", new CglFunc().CDicTOTable(new CglData().GetCurrentDataDics(_gstuSearch)));
                }
                if (ViewState["_dicNumcssclass"] == null)
                {
                    ViewState.Add("_dicNumcssclass", new GalaxyApp().GetNumcssclass(_gstuSearch));
                }
                if (ViewState["_dicFreqActive"] == null)
                {
                    _gstuSearch.InDisplayPeriod = (_gstuSearch.InDisplayPeriod < _gstuSearch.InSearchLimit) ? _gstuSearch.InSearchLimit : _gstuSearch.InDisplayPeriod;
                    ViewState.Add("_dicFreqActive", new CglFreq().GetFreqActiveDic(_gstuSearch));
                }

                _dicNumcssclass = (Dictionary <string, string>)ViewState["_dicNumcssclass"];
                _dicFreqActive  = (Dictionary <string, DataTable>)ViewState["_dicFreqActive"];
                ShowResult(_gstuSearch);
            }
            CurrentSearchOrderID = string.Empty;
        }
Beispiel #6
0
        private void UpdatelstDelete(StuGLSearch stuGLSearch)
        {
            XDocument xDoc;
            string    strFilePath = System.IO.Path.Combine(strHtmlDirectory, strFnDeletexml);

            if (!(bool)new CglFunc().FileExist(strHtmlDirectory, strFnDeletexml))
            {
                xDoc = new XDocument(new XDeclaration("1.0", "utf-8", "true"));
                xDoc.AddFirst(new XElement("Data"));
                xDoc.Element("Data").Add(new XElement("Delete", ""));
                xDoc.Element("Data").Add(new XElement("NotDelete", ""));
                xDoc.Element("Data").Add(new XElement("DataRowsLimit", stuGLSearch.InDataRowsLimit));
                xDoc.Element("Data").Add(new XElement("command", ""));
                xDoc.Save(strFilePath);
            }
            xDoc = XDocument.Load(strFilePath);
            string strDelete = xDoc.Root.Element("Delete").Value;

            strDelete = new CglFunc().GetTestNum(strDelete);
            //if (strDelete.Length > 0) { lstDelete = strDelete.Split(',').ToList(); } else { lstDelete = new List<string>(); }
            LstDelete = (strDelete.Length > 0) ? strDelete.Split(',').ToList() : new List <string>();

            string strNotDelete = xDoc.Root.Element("NotDelete").Value;

            strNotDelete = new CglFunc().GetTestNum(strNotDelete);
            //if (strNotDelete.Length > 0) { lstNotDelete = strNotDelete.Split(',').ToList(); } else { lstNotDelete = new List<string>(); }
            LstNotDelete = (strNotDelete.Length > 0) ? strNotDelete.Split(',').ToList() : new List <string>();

            intDataRowsLimit = int.Parse(xDoc.Root.Element("DataRowsLimit").Value, InvariantCulture);
        }
Beispiel #7
0
        private void Setddl()
        {
            if (ddlFreq.Items.Count == 0)
            {
                if (GlobalStuSearch.FieldMode)
                {
                    ddlFreq.Items.Add(new ListItem(new CglFunc().ConvertFieldNameId(GlobalStuSearch.StrCompares), GlobalStuSearch.StrCompares));
                }
                else
                {
                    ddlFreq.Items.Add(new ListItem(new CglFunc().ConvertFieldNameId("gen"), "gen"));
                }
                if (GlobalStuSearch.NextNumsMode)
                {
                    StuGLSearch stuSearchTemp = GlobalStuSearch;
                    ddlNexts.Visible = true;
                    ddlNexts.Items.Clear();
                    ddlNexts.Items.Add(new ListItem(new CglFunc().ConvertFieldNameId("gen"), "gen"));

                    if (ddlFreq.SelectedValue == "gen")
                    {
                        stuSearchTemp.FieldMode = false;
                    }
                    //stuSearchTemp = new CglSearch().InitSearch(stuSearchTemp);
                    List <string> NextNums = stuSearchTemp.StrNextNumT.Split(separator: ';').ToList();
                    foreach (string Nums in NextNums)
                    {
                        ddlNexts.Items.Add(new ListItem(new CglFunc().ConvertFieldNameId(Nums), Nums));
                    }
                }
            }
        }
Beispiel #8
0
 private void OpenFieldPage(StuGLSearch stuGLSearch, string action, string fileName, string windowName, string LocalIP, string LocalBrowserType)
 {
     Session["action"]      = action;
     Session["UrlFileName"] = fileName;
     foreach (string field in new CglValidFields().GetValidFieldsLst(stuGLSearch))
     {
         if (stuGLSearch.StrCompares != field)
         {
             StuGLSearch stuSearchTemp = stuGLSearch;
             stuSearchTemp.FieldMode    = field != "gen";
             stuSearchTemp.StrCompares  = field;
             stuSearchTemp.SearchFileds = false;
             //stuSearchTemp = new CglSearch().InitSearch(stuSearchTemp);
             //stuSearchTemp = new CglMethod().GetMethodSN(stuSearchTemp);
             string RequestId = SetRequestId(stuSearchTemp);
             Session[action + RequestId] = stuSearchTemp;
             //SetDicSession(stuSearchTemp, action, RequestId);
             if (stuGLSearch.SearchOrder)
             {
                 SetSearchOrder(stuSearchTemp, action, RequestId, fileName, LocalIP, LocalBrowserType);
             }
             else
             {
                 OpenPage(stuSearchTemp, Request.Url.Authority, action, fileName, windowName);
             }
         }
     }
 }
Beispiel #9
0
#pragma warning disable CA1707 // Identifiers should not contain underscores
        protected void Page_Load(object sender, EventArgs e)
#pragma warning restore CA1707 // Identifiers should not contain underscores
        {
            LocalBrowserType = Request.Browser.Type;
            LocalIP          = Dns.GetHostEntry(Dns.GetHostName()).AddressList[1].ToString();

            if (!IsPostBack)
            {
                SetupViewState();
            }
            if (_gstuSearch.LottoType == TargetTable.None || _gstuSearch.LngTotalSN == 0)
            {
                Response.Write("<script language='javascript'>window.close();</script>");
            }
            else
            {
                _gstuSearch    = (StuGLSearch)ViewState["_gstuSearch"];
                dicNumcssclass = new GalaxyApp().GetNumcssclass(_gstuSearch);
                //dicCurrentNums = new CglData().GetCurrentDataNums(gstuSearch);
                if (ViewState["title"] == null)
                {
                    ViewState.Add("title", string.Format(InvariantCulture, "{0}:{1}", "百分比活性表", new CglDBData().SetTitleString(_gstuSearch)));
                }
                Page.Title = ViewState["title"].ToString();
                ShowResult(_gstuSearch);
            }
            CurrentSearchOrderID = string.Empty;
        }
Beispiel #10
0
        private void OpenPageMuti(StuGLSearch stuGLSearch, string action, string fileName, string windowName, string LocalIP, string LocalBrowserType)
        {
            Session["action"] = action;
            //Session["action"] = action;
            Session["UrlFileName"] = fileName;
            //stuGLSearch = new CglSearch().InitSearch(stuGLSearch);
            if (stuGLSearch.InTestPeriods > 1)
            {
                DataTable dtProcess = new CglFreqProcess().GetFreqProcAlls(stuGLSearch, CglDBFreq.TableName.QryFreqProcess01, SortOrder.Descending, stuGLSearch.InTestPeriods - 1);

                foreach (DataRow drRow in dtProcess.Rows)
                {
                    StuGLSearch stuSearchTemp = stuGLSearch;
                    stuSearchTemp.LngTotalSN    = long.Parse(drRow["lngTotalSN"].ToString(), InvariantCulture);
                    stuSearchTemp.InTestPeriods = 1;
                    Session["id"] = SetRequestId(stuSearchTemp);
                    Session[action + SetRequestId(stuSearchTemp)] = stuSearchTemp;
                    if (stuGLSearch.SearchOrder)
                    {
                        SetSearchOrder(stuSearchTemp, action, SetRequestId(stuSearchTemp), fileName, LocalIP, LocalBrowserType);
                    }
                    else
                    {
                        OpenPage(stuSearchTemp, Request.Url.Authority, action, fileName, windowName);
                    }
                }
            }
        }
Beispiel #11
0
        private void ShowTitle()
        {
            StuGLSearch stuSearchTemp = GlobalStuSearch;

            if (ViewState["title"] == null)
            {
                ViewState.Add("title", new CglDBData().SetTitleString(stuSearchTemp));
            }
            Page.Title    = (string)ViewState["title"];
            lblTitle.Text = (string)ViewState["title"];

            if (ddlNexts.SelectedValue != "gen")
            {
                stuSearchTemp.StrNextNums = ddlNexts.SelectedValue;
            }
            // if (ViewState["lblMethod"] == null) { ViewState.Add("lblMethod", string.Format(InvariantCulture, "{0}:{1}", "頻率總表", new CglMethod().SetMethodString(stuSearch))); }
            lblMethod.Text = string.Format(InvariantCulture, "{0}:{1}", "頻率總表", new CglMethod().SetMethodString(stuSearchTemp));


            if (ViewState["lblSearchMethod"] == null)
            {
                ViewState.Add("lblSearchMethod", new CglMethod().SetSearchMethodString(stuSearchTemp));
            }
            lblSearchMethod.Text = (string)ViewState["lblSearchMethod"];

            //顯示當前資料
            if (ViewState["CurrentData"] == null)
            {
                ViewState.Add("CurrentData", new CglFunc().CDicTOTable(new CglData().GetCurrentDataDics(stuSearchTemp)));
            }
            GridView gvCurrentData = new GalaxyApp().CreatGridView("gvCurrentData", "gltable ", (DataTable)ViewState["CurrentData"], true, true);

            gvCurrentData.DataBind();
            pnlCurrentData.Controls.Add(gvCurrentData);
        }
Beispiel #12
0
        //private string _action;
        //private string _id;

#pragma warning disable CA1707 // Identifiers should not contain underscores
        protected void Page_Load(object sender, EventArgs e)
#pragma warning restore CA1707 // Identifiers should not contain underscores
        {
            SetupViewState();
            if (ViewState["_gstuSearch"] == null)
            {
                Response.Write("<script language='javascript'>window.close();</script>");
            }
            else
            {
                //if (ViewState["_stuGLSearch"] == null) { ViewState.Add("_stuGLSearch", (StuGLSearch)Session[Action + RequestId]); }
                _stuGLSearch = (StuGLSearch)ViewState["_gstuSearch"];
                if (ViewState["Title"] == null)
                {
                    ViewState.Add("Title", string.Format(InvariantCulture, "{0} 資料更新", new CglDataSet(_stuGLSearch.LottoType).LottoDescription));
                }
                Page.Title    = (string)ViewState["Title"];
                lblTitle.Text = (string)ViewState["Title"];
                if (ViewState["tbData"] == null)
                {
                    switch (_stuGLSearch.LottoType)
                    {
                    case TargetTable.DataPurple:
                        DataTable dtPurpleDate = new CglPurple().PurpleDate.Rows.Count > 1000 ? new CglPurple().PurpleDate.Rows.Cast <DataRow>().Take(1000).CopyToDataTable() : new CglPurple().PurpleDate;
                        DtCsvFile = new CglPurple().GetPurple(dtPurpleDate);
                        for (int rowindex = 0; rowindex < DtCsvFile.Rows.Count; rowindex++)
                        {
                            for (int strp = 1; strp <= 12; strp++)
                            {
                                if (DtCsvFile.Rows[rowindex][string.Format(InvariantCulture, "strp{0:d2}", strp)].ToString().Length >= 4)
                                {
                                    DtCsvFile.Rows[rowindex][string.Format(InvariantCulture, "strp{0:d2}", strp)] = DtCsvFile.Rows[rowindex][string.Format(InvariantCulture, "strp{0:d2}", strp)].ToString().Substring(0, 4);
                                }
                            }
                        }
                        break;

                    case TargetTable.DateWC:
                        DtCsvFile = new CglFunc().GetDateWC();
                        break;

                    default:
                        DtCsvFile = new CglFunc().ReadCsvFile(_stuGLSearch.LottoType, Server.MapPath("../csv"));
                        break;
                    }

                    ViewState.Add("tbData", DtCsvFile);
                    new CglFunc().UpdateDataSilent(_stuGLSearch.LottoType, DtCsvFile);
                }
                if (ViewState["sort"] == null)
                {
                    ViewState.Add("sort", "");
                }

                ShowDetail();
            }
        }
Beispiel #13
0
        private void StartThread01(StuGLSearch stuGLSearchTemp)
        {
            SetSearchOrder(stuGLSearchTemp, _action, _requestId, _UrlFileName, LocalIP, LocalBrowserType);
            if (stuGLSearchTemp.InTestPeriods > 1)
            {
                OpenPageMuti(stuGLSearchTemp, _action, _UrlFileName, "_blank", LocalIP, LocalBrowserType);
            }

            if (stuGLSearchTemp.SearchFileds)
            {
                OpenFieldPage(stuGLSearchTemp, _action, _UrlFileName, "_blank", LocalIP, LocalBrowserType);
            }
        }
Beispiel #14
0
        private void ShowResult(StuGLSearch stuGLSearch)
        {
            Page.Title           = (string)ViewState["title"];
            lblTitle.Text        = (string)ViewState["title"];
            lblMethod.Text       = new CglMethod().SetMethodString(stuGLSearch);
            lblSearchMethod.Text = new CglMethod().SetSearchMethodString(stuGLSearch);

            // 當期資料
            GridView gvCurrentData = new GalaxyApp().CreatGridView("gvCurrentData", "gltable ", (DataTable)ViewState["CurrentData"], true, true);

            gvCurrentData.DataBind();
            pnlCurrentData.Controls.Add(gvCurrentData);

            SetddlFreq();
            ShowDetail(ddlFreq.SelectedValue);
        }
Beispiel #15
0
        private void ShowFreqProcess(StuGLSearch stuSearchTemp)
        {
            dtlProcess.Visible = true;
            DataTable DtFreqProcess = new CglFreqProcess().GetFreqProcs(stuSearchTemp, CglDBFreq.TableName.QryFreqProcess, SortOrder.Descending);

            if (DtFreqProcess.Columns.Contains("lngFreqProcessSN"))
            {
                DtFreqProcess.Columns.Remove("lngFreqProcessSN");
            }
            if (DtFreqProcess.Columns.Contains("lngFreqSN"))
            {
                DtFreqProcess.Columns.Remove("lngFreqSN");
            }
            gvFreqProcess.DataSource = new CglFunc().CTableShow(DtFreqProcess).DefaultView;
            if (gvFreqProcess.Columns.Count == 0)
            {
                for (int ColumnIndex = 0; ColumnIndex < DtFreqProcess.Columns.Count; ColumnIndex++)
                {
                    BoundField bfCell = new BoundField()
                    {
                        DataField      = DtFreqProcess.Columns[ColumnIndex].ColumnName,
                        HeaderText     = new CglFunc().ConvertFieldNameId(DtFreqProcess.Columns[ColumnIndex].ColumnName, 1),
                        SortExpression = DtFreqProcess.Columns[ColumnIndex].ColumnName,
                    };
                    gvFreqProcess.Columns.Add(bfCell);
                }
            }
            #region Set Columns of DataGrid gvProcess
            foreach (BoundField dcColumn in gvFreqProcess.Columns)
            {
                string strColumnName = dcColumn.SortExpression;
                if ((strColumnName.Substring(0, 4) != "lngL" && strColumnName.Substring(0, 4) != "lngM") || strColumnName == "lngMethodSN")
                {
                    dcColumn.HeaderStyle.CssClass = strColumnName;
                    dcColumn.ItemStyle.CssClass   = strColumnName;
                }

                if (strColumnName.Substring(0, 4) == "lngL" || strColumnName.Substring(0, 4) == "lngS")
                {
                    dcColumn.HeaderStyle.CssClass = strColumnName;
                    dcColumn.DataFormatString     = "{0:d2}";
                }
            }
            #endregion
            gvFreqProcess.RowDataBound += GvFreqProcess_RowDataBound;
            gvFreqProcess.DataBind();
        }
        private StuGLSearch SetCompareString(StuGLSearch stuSearch00)
        {
            StuGLSearch   stuReturn  = stuSearch00;
            List <string> lstCompare = new List <string>();

            //stuReturn.StrCompares = string.Empty;
            #region FieldMode

            if (stuReturn.FieldMode)
            {
                if (cmbCompare01.SelectedValue != "none")
                {
                    lstCompare.Add(cmbCompare01.SelectedValue);
                }
                if (cmbCompare02.SelectedValue != "none")
                {
                    lstCompare.Add(cmbCompare02.SelectedValue);
                }
                if (cmbCompare03.SelectedValue != "none")
                {
                    lstCompare.Add(cmbCompare03.SelectedValue);
                }
                if (cmbCompare04.SelectedValue != "none")
                {
                    lstCompare.Add(cmbCompare04.SelectedValue);
                }
                if (cmbCompare05.SelectedValue != "none")
                {
                    lstCompare.Add(cmbCompare05.SelectedValue);
                }
            }
            #endregion FieldMode

            if (lstCompare.Count > 0)
            {
                lstCompare.Sort();
                stuReturn.StrCompares = string.Join("#", lstCompare.Distinct());
                stuReturn             = new CglMethod().SetComparesDetail(stuReturn);
            }
            else
            {
                stuReturn.StrCompares       = "gen";
                stuReturn.StrComparesDetail = "none";
            }
            return(stuReturn);
        }
        private void StartThread01(StuGLSearch _gstuSearch)
        {
            if (localAction == Properties.Resources.SessionsFreqActiveHT01 || localAction == Properties.Resources.SessionsFreqActiveHT01P)
            {
                StuGLSearch stuGLSearchTemp = _gstuSearch;
                stuGLSearchTemp.FilterRange    = true;
                stuGLSearchTemp.StrFilterRange = "1";
                stuGLSearchTemp.SglFilterMin   = 0;
                stuGLSearchTemp.SglFilterMax   = 0;
                SetSearchOrder(stuGLSearchTemp, localAction, SetRequestId(stuGLSearchTemp), AspFileName, LocalIP, LocalBrowserType);

                stuGLSearchTemp.FilterRange    = true;
                stuGLSearchTemp.StrFilterRange = "1#2";
                stuGLSearchTemp.SglFilterMin   = 0;
                stuGLSearchTemp.SglFilterMax   = 0;
                SetSearchOrder(stuGLSearchTemp, localAction, SetRequestId(stuGLSearchTemp), AspFileName, LocalIP, LocalBrowserType);

                stuGLSearchTemp.FilterRange    = true;
                stuGLSearchTemp.StrFilterRange = "2#3";
                stuGLSearchTemp.SglFilterMin   = 0;
                stuGLSearchTemp.SglFilterMax   = 0;
                SetSearchOrder(stuGLSearchTemp, localAction, SetRequestId(stuGLSearchTemp), AspFileName, LocalIP, LocalBrowserType);

                stuGLSearchTemp.FilterRange    = true;
                stuGLSearchTemp.StrFilterRange = "none";
                stuGLSearchTemp.SglFilterMin   = 1;
                stuGLSearchTemp.SglFilterMax   = 1000;
                SetSearchOrder(stuGLSearchTemp, localAction, SetRequestId(stuGLSearchTemp), AspFileName, LocalIP, LocalBrowserType);
            }
            if (localAction == Properties.Resources.SessionsDataB || localAction == Properties.Resources.SessionsDataN)
            {
                List <string> Fields = (List <string>) new CglValidFields().GetValidFieldsLst(_gstuSearch);
                foreach (string field in Fields)
                {
                    StuGLSearch stuGLSearchTemp = _gstuSearch;
                    stuGLSearchTemp.FieldMode   = field != "gen";
                    stuGLSearchTemp.StrCompares = field != "gen" ? field : "gen";
                    stuGLSearchTemp             = new CglSearch().InitSearch(stuGLSearchTemp);
                    stuGLSearchTemp             = new CglMethod().GetMethodSN(stuGLSearchTemp);
                    stuGLSearchTemp             = new CglMethod().GetSearchMethodSN(stuGLSearchTemp);
                    stuGLSearchTemp             = new CglMethod().GetSecFieldSN(stuGLSearchTemp);
                    SetSearchOrder(stuGLSearchTemp, localAction, SetRequestId(stuGLSearchTemp), AspFileName, LocalIP, LocalBrowserType);
                }
            }
        }
Beispiel #18
0
        //private string KeySearchOrder { get; set; }

        //private Dictionary<string, DataSet> _dicFreqDataSet;

#pragma warning disable CA1707 // Identifiers should not contain underscores
        protected void Page_Load(object sender, EventArgs e)
#pragma warning restore CA1707 // Identifiers should not contain underscores
        {
            LocalBrowserType = Request.Browser.Type;
            LocalIP          = Dns.GetHostEntry(Dns.GetHostName()).AddressList[1].ToString();
            //KeySearchOrder = string.Format(InvariantCulture, "{0}#{1}#dtSearchOrder", LocalIP, LocalBrowserType);

            if (Session["SearchOption"] == null)
            {
                Response.Write("<script language='javascript'>window.close();</script>");
            }
            else
            {
                StuGLSearch stuGLSearchTemp = (StuGLSearch)Session["SearchOption"];
                _action      = stuGLSearchTemp.Action;
                _UrlFileName = stuGLSearchTemp.PageFileName;
                if (_action == Properties.Resources.SessionsFreqActiveHT01P)
                {
                    stuGLSearchTemp.LngTotalSN += 1;
                }
                //stuGLSearchTemp = new CglSearch().InitSearch(stuGLSearchTemp);
                //stuGLSearchTemp = new CglMethod().GetMethodSN(stuGLSearchTemp);
                //stuGLSearchTemp = new CglMethod().GetSearchMethodSN(stuGLSearchTemp);
                _requestId = SetRequestId(stuGLSearchTemp);
                Session[_action + _requestId] = stuGLSearchTemp;

                if (Session[_action + _requestId] == null || string.IsNullOrEmpty(_action) || string.IsNullOrEmpty(_requestId) || string.IsNullOrEmpty(_UrlFileName))
                {
                    Response.Write("<script language='javascript'>window.close();</script>");
                }
                else
                {
                    if (stuGLSearchTemp.SearchOrder)
                    {
                        Thread Thread01 = new Thread(() => { StartThread01(stuGLSearchTemp); });
                        Thread01.Start();
                        Response.Write("<script language='javascript'>window.close();</script>");
                    }
                    else
                    {
                        OpenPage(stuGLSearchTemp, _action, _requestId, _UrlFileName, "_self");
                    }
                }
            }
        }
Beispiel #19
0
        private void SetupViewState()
        {
            string uid = Request["uid"] ?? (string)base.Session["uid"] ?? (string)base.ViewState["uid"] ?? string.Empty;

            if (ViewState["uid"] == null)
            {
                base.ViewState.Add("uid", uid);
            }

            if (ViewState["GlobalStuSearch"] == null)
            {
                if (!string.IsNullOrEmpty(uid) && base.Session[uid] != null)
                {
                    ViewState.Add("GlobalStuSearch", (StuGLSearch)Session[uid]);
                }
            }
            GlobalStuSearch = (StuGLSearch)ViewState["GlobalStuSearch"];
        }
Beispiel #20
0
#pragma warning disable CA1707 // Identifiers should not contain underscores
        protected void Page_Load(object sender, EventArgs e)
#pragma warning restore CA1707 // Identifiers should not contain underscores
        {
            SetupViewState();
            GlstuSearch = (StuGLSearch)ViewState["_gstuSearch"];
            if (GlstuSearch.LottoType == TargetTable.None || GlstuSearch.LngTotalSN == 0)
            {
                Response.Write("<script language='javascript'>window.close();</script>");
            }
            else
            {
                if (!IsPostBack)
                {
                    if (ViewState["title"] == null)
                    {
                        ViewState.Add("title", string.Format(InvariantCulture, "{0}:{1}", "活性總表圖", new CglDBData().SetTitleString(GlstuSearch)));
                    }
                    if (ViewState["CurrentNums"] == null)
                    {
                        ViewState["CurrentNums"] = new CglData().GetDataNumsDici(GlstuSearch);
                    }
                    if (ViewState["CurrentData"] == null)
                    {
                        ViewState["CurrentData"] = new CglFunc().CDicTOTable(new CglData().GetCurrentDataDics(GlstuSearch));
                    }
                    if (ViewState["FreqActive"] == null)
                    {
                        StuGLSearch stuGLSearchTemp = GlstuSearch;
                        stuGLSearchTemp.ShowProcess     = ShowProcess.Visible;
                        stuGLSearchTemp.InDisplayPeriod = (stuGLSearchTemp.InDisplayPeriod < stuGLSearchTemp.InSearchLimit) ? stuGLSearchTemp.InSearchLimit : stuGLSearchTemp.InDisplayPeriod;
                        ViewState.Add("FreqActive", new CglFreq().GetFreqActiveDic(stuGLSearchTemp));
                    }
                }
                //_dicCurrentNums = (Dictionary<string, int>)ViewState["CurrentNums"];
                _dicNumcssclass = new GalaxyApp().GetNumcssclass(GlstuSearch);
                dtCurrentData   = (DataTable)ViewState["CurrentData"];
                _dicFreqActive  = (Dictionary <string, DataTable>)ViewState["FreqActive"];
                Page.Title      = ViewState["title"].ToString();
                SetddlNums();
                ShowResult(GlstuSearch);
            }
            CurrentSearchOrderID = string.Empty;
        }
Beispiel #21
0
#pragma warning disable CA1707 // Identifiers should not contain underscores
        protected void Page_Load(object sender, EventArgs e)
#pragma warning restore CA1707 // Identifiers should not contain underscores
        {
            SetupViewState();
            if (ViewState["_gstuSearch"] == null)
            {
                Response.Write("<script language='javascript'>window.close();</script>");
            }
            else
            {
                GlobalStuSearch = (StuGLSearch)ViewState["_gstuSearch"];
                if (ViewState["MissAll"] == null)
                {
                    ViewState.Add("MissAll", new CglMissAll().GetMissAll00Dic(GlobalStuSearch, CglMissAll.TableName.QryMissAll0001, SortOrder.Descending));
                }
                if (ViewState["title"] == null)
                {
                    ViewState.Add("title", string.Format(InvariantCulture, "{0}:{1}", "遺漏總表", new CglDBData().SetTitleString(GlobalStuSearch)));
                }
                if (ViewState["CurrentData"] == null)
                {
                    ViewState.Add("CurrentData", new CglFunc().CDicTOTable(new CglData().GetCurrentDataDics(GlobalStuSearch)));
                }
                if (ViewState["CurrentNums"] == null)
                {
                    ViewState.Add("CurrentNums", new CglData().GetDataNumsDici(GlobalStuSearch));
                }
                _dicCurrentNums = (Dictionary <string, int>)ViewState["CurrentNums"];
                if (ViewState["lblMethod"] == null)
                {
                    ViewState.Add("lblMethod", new CglMethod().SetMethodString(GlobalStuSearch));
                }
                if (ViewState["lblSearchMethod"] == null)
                {
                    ViewState.Add("lblSearchMethod", new CglMethod().SetSearchMethodString(GlobalStuSearch));
                }

                _dicMissAll = (Dictionary <string, object>)ViewState["MissAll"];
                ShowResult(GlobalStuSearch);
            }
            ResetSearchOrder(_action + _requestId);
        }
Beispiel #22
0
        internal static void SetFrtSearchOrder(StuGLSearch stuGLSearch, string action, string requestId, string FileName, string LocalIP, string LocalBrowserType)
        {
            if (FileName == null)
            {
                throw new ArgumentNullException(nameof(FileName));
            }
            if (!string.IsNullOrEmpty(action) && !string.IsNullOrEmpty(requestId) && !string.IsNullOrEmpty(FileName))
            {
                if (((DataSet)ServerOption[string.Format(InvariantCulture, "{0}#{1}#dtFrtSearchOrder", LocalIP, LocalBrowserType)]).Tables["FrtSearchOrder"] == null ||
                    ((DataSet)ServerOption[string.Format(InvariantCulture, "{0}#{1}#dtFrtSearchOrder", LocalIP, LocalBrowserType)]).Tables["FrtSearchOrder"].Columns.Count == 0)
                {
                    ((DataSet)ServerOption[string.Format(InvariantCulture, "{0}#{1}#dtFrtSearchOrder", LocalIP, LocalBrowserType)]).Tables.Add(CreatFrtSearchOrderDT());
                }
                using (DataTable DtFrtSearchOrder = ((DataSet)ServerOption[string.Format(InvariantCulture, "{0}#{1}#dtFrtSearchOrder", LocalIP, LocalBrowserType)]).Tables["FrtSearchOrder"])
                {
                    if (DtFrtSearchOrder.Rows.Count == 0 ||
                        DtFrtSearchOrder.Rows.Count > 0 &&
                        DtFrtSearchOrder.Select(string.Format(InvariantCulture, "[ActionID] = '{0}'", action + requestId)).Length == 0)
                    {
                        DataRow drRow = DtFrtSearchOrder.NewRow();
                        drRow["ActionID"]          = action + requestId;
                        drRow["Action"]            = action;
                        drRow["requestId"]         = requestId;
                        drRow["urlFileName"]       = FileName;
                        drRow["lngMethodSN"]       = stuGLSearch.LngMethodSN;
                        drRow["lngSearchMethodSN"] = stuGLSearch.LngSearchMethodSN;
                        drRow["lngSecFieldSN"]     = stuGLSearch.LngSecFieldSN;
                        DtFrtSearchOrder.Rows.Add(drRow);
                        //stuGLSearch.SearchOrder = false

                        if (!dicFrtSearchOrder.ContainsKey(action + requestId))
                        {
                            dicFrtSearchOrder.Add(action + requestId, stuGLSearch);
                        }
                        else
                        {
                            dicFrtSearchOrder[action + requestId] = stuGLSearch;
                        }
                    }
                }
            }
        }
Beispiel #23
0
        //MultiView mlViews = new MultiView();

#pragma warning disable CA1707 // Identifiers should not contain underscores
        protected void Page_Load(object sender, EventArgs e)
#pragma warning restore CA1707 // Identifiers should not contain underscores
        {
            SetupViewState();
            if (_gstuSearch.LottoType == TargetTable.None || _gstuSearch.LngTotalSN == 0)
            {
                Response.Write("<script language='javascript'>window.close();</script>");
            }
            else
            {
                _gstuSearch = (StuGLSearch)ViewState["_gstuSearch"];
                if (ViewState["title"] == null)
                {
                    ViewState.Add("title", string.Format(InvariantCulture, "{0}:{1}", "遺漏數字振盪表", new CglDBData().SetTitleString(_gstuSearch)));
                }
                Page.Title = ViewState["title"].ToString();
                ShowResult();
            }
            CurrentSearchOrderID = string.Empty;
        }
Beispiel #24
0
        //-----------------------------------------------------------------------------

        protected void DdlFreq_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (ddlNexts.Visible)
            {
                StuGLSearch stuSearchTemp = GlobalStuSearch;
                ddlNexts.Items.Clear();
                ddlNexts.Items.Add(new ListItem(new CglFunc().ConvertFieldNameId("gen"), "gen"));

                if (ddlFreq.SelectedValue == "gen")
                {
                    stuSearchTemp.FieldMode = false;
                }
                //stuSearchTemp = new CglSearch().InitSearch(stuSearchTemp);
                List <string> NextNums = stuSearchTemp.StrNextNumT.Split(separator: ';').ToList();
                foreach (string Nums in NextNums)
                {
                    ddlNexts.Items.Add(new ListItem(new CglFunc().ConvertFieldNameId(Nums), Nums));
                }
            }
        }
Beispiel #25
0
 internal static void SetSearchOrder(StuGLSearch stuGLSearch, string action, string requestId, string FileName, string LocalIP, string LocalBrowserType)
 {
     if (FileName == null)
     {
         throw new ArgumentNullException(nameof(FileName));
     }
     if (!string.IsNullOrEmpty(action) && !string.IsNullOrEmpty(requestId) && !string.IsNullOrEmpty(FileName))
     {
         string keySearchOrder = string.Format(InvariantCulture, "{0}#{1}#dtSearchOrder", LocalIP, LocalBrowserType);
         if (!ServerOption.ContainsKey(keySearchOrder))
         {
             ServerOption.Add(keySearchOrder, CreatSearchOrderDT());
         }
         using (DataTable DtSearchOrder = (DataTable)ServerOption[keySearchOrder])
         {
             if (DtSearchOrder.Rows.Count == 0 || DtSearchOrder.Rows.Count > 0 && DtSearchOrder.Rows.Find(action + requestId) == null)
             {
                 DataRow drRow = DtSearchOrder.NewRow();
                 drRow["ActionID"]       = action + requestId;
                 drRow["Action"]         = action;
                 drRow["requestId"]      = requestId;
                 drRow["urlFileName"]    = FileName;
                 drRow["strFilterRange"] = stuGLSearch.StrFilterRange;
                 drRow["sglFilterMin"]   = stuGLSearch.SglFilterMin;
                 drRow["sglFilterMax"]   = stuGLSearch.SglFilterMax;
                 ((DataTable)ServerOption[keySearchOrder]).Rows.Add(drRow);
                 //stuGLSearch.SearchOrder = false;
                 if (!dicSearchOrder.ContainsKey(action + requestId))
                 {
                     dicSearchOrder.Add(action + requestId, stuGLSearch);
                 }
                 else
                 {
                     dicSearchOrder[action + requestId] = stuGLSearch;
                 }
             }
         }
     }
 }
        //private string KeySearchOrder { get; set; }
        //private Dictionary<string, DataSet> _dicFreqDataSet;

#pragma warning disable CA1707 // Identifiers should not contain underscores
        protected void Page_Load(object sender, EventArgs e)
#pragma warning restore CA1707 // Identifiers should not contain underscores
        {
            LocalBrowserType = Request.Browser.Type;
            LocalIP          = Dns.GetHostEntry(Dns.GetHostName()).AddressList[1].ToString();
            //KeySearchOrder = string.Format(InvariantCulture, "{0}#{1}#dtSearchOrder", LocalIP, LocalBrowserType);

            if (Session["SearchOption"] == null)
            {
                Response.Write("<script language='javascript'>window.close();</script>");
            }
            else
            {
                StuGLSearch stuGLSearchTemp = (StuGLSearch)Session["SearchOption"];
                stuGLSearchTemp = new CglSearch().InitSearch(stuGLSearchTemp);
                stuGLSearchTemp = new CglMethod().GetMethodSN(stuGLSearchTemp);
                stuGLSearchTemp = new CglMethod().GetSearchMethodSN(stuGLSearchTemp);
                localAction     = stuGLSearchTemp.Action;
                AspFileName     = stuGLSearchTemp.PageFileName;
                localRequestID  = SetRequestId(stuGLSearchTemp);
                Session[localAction + localRequestID] = stuGLSearchTemp;
                if (Session[localAction + localRequestID] == null || string.IsNullOrEmpty(localAction) || string.IsNullOrEmpty(localRequestID) || string.IsNullOrEmpty(AspFileName))
                {
                    Response.Write("<script language='javascript'>window.close();</script>");
                }
                else
                {
                    Thread01 = new Thread(() => { StartThread01(stuGLSearchTemp); })
                    {
                        Name = "ShortCut01"
                    };
                    Thread01.Start();


                    Response.Write("<script language='javascript'>window.close();</script>");
                }
            }
        }
Beispiel #27
0
#pragma warning disable CA1707 // Identifiers should not contain underscores
        protected void Page_Load(object sender, EventArgs e)
#pragma warning restore CA1707 // Identifiers should not contain underscores
        {
            SetupViewState();
            if (ViewState["_gstuSearch"] == null)
            {
                Response.Write("<script language='javascript'>window.close();</script>");
            }
            else
            {
                _gstuSearch = (StuGLSearch)ViewState["_gstuSearch"];
                if (!IsPostBack)
                {
                    Session.Remove(ShowAllID + "dtShowAll");
                }
                if (ViewState["Title"] == null)
                {
                    ViewState.Add("Title", new CglDataSet(_gstuSearch.LottoType).LottoDescription);
                }

                ShowAllData();
            }
        }
Beispiel #28
0
#pragma warning disable CA1707 // Identifiers should not contain underscores
        protected void Page_Load(object sender, EventArgs e)
#pragma warning restore CA1707 // Identifiers should not contain underscores
        {
            SetupViewState();
            if (ViewState["_gstuSearch"] == null)
            {
                Response.Write("<script language='javascript'>window.close();</script>");
            }
            else
            {
                _gstuSearch = (StuGLSearch)ViewState["_gstuSearch"];
                if (!IsPostBack)
                {
                    if (ViewState["title"] == null)
                    {
                        ViewState.Add("title", string.Format(InvariantCulture, "{0}:{1}", "頻率組總表", new CglDBData().SetTitleString(_gstuSearch)));
                    }
                    if (ViewState["CurrentData"] == null)
                    {
                        ViewState.Add("CurrentData", new CglFunc().CDicTOTable(new CglData().GetCurrentDataDics(_gstuSearch)));
                    }
                    if (ViewState["_lstCurrentNums"] == null)
                    {
                        ViewState.Add("_lstCurrentNums", (List <int>) new CglData().GetDataNumsLst(_gstuSearch));
                    }
                    if (ViewState["FreqSetDS"] == null)
                    {
                        StuGLSearch stuGLSearch = _gstuSearch;
                        stuGLSearch.StrFreqSet = "gen#strDayFive#strDayTwelve#strDayNine";
                        ViewState.Add("FreqSetDS", new CglFreqSet().GetFreqSetDS(stuGLSearch));
                    }
                }
                _lstCurrentNums = (List <int>)ViewState["_lstCurrentNums"];
                ShowResult();
            }
            CurrentSearchOrderID = string.Empty;
        }
        private Dictionary <int, string> ConvertToDicDelNum_Hit(StuGLSearch stuSearch00, Dictionary <string, string> dicDelNum_All)
        {
            Dictionary <int, string> dicDelNumHit = new Dictionary <int, string>();
            List <int> lstCurrentNums             = (List <int>) new CglData().GetDataNumsLst(stuSearch00);

            foreach (var item in dicDelNum_All)
            {
                foreach (var num in item.Value.Split(',').ToArray())
                {
                    if (lstCurrentNums.Contains(int.Parse(num, InvariantCulture)))
                    {
                        if (dicDelNumHit.ContainsKey(int.Parse(num, InvariantCulture)))
                        {
                            dicDelNumHit[int.Parse(num, InvariantCulture)] += "," + item.Key;
                        }
                        else
                        {
                            dicDelNumHit.Add(int.Parse(num, InvariantCulture), item.Key);
                        }
                    }
                }
            }
            return(dicDelNumHit);
        }
Beispiel #30
0
        private void ShowFreq(StuGLSearch stuSearchTemp)
        {
            Dictionary <string, string> _dicNumcssclass = (Dictionary <string, string>)ViewState["_dicNumcssclass"];

            stuSearchTemp.FieldMode    = ddlFreq.SelectedValue != "gen";
            stuSearchTemp.NextNumsMode = ddlNexts.Visible && ddlNexts.SelectedValue != "gen";
            stuSearchTemp.StrNextNums  = stuSearchTemp.NextNumsMode ? ddlNexts.SelectedValue : "none";

            DataTable DtFreqView = new CglFreq().GetFreq(stuSearchTemp);

            lblFreq.Text      = string.Format(InvariantCulture, "{0} ({1}期)", new CglFunc().ConvertFieldNameId(ddlFreq.SelectedValue), DtFreqView.Rows[0]["intRows"]);
            DtFreqView        = new CglFunc().SortFreq(stuSearchTemp, DtFreqView);
            gvFreq.DataSource = DtFreqView.DefaultView;
            if (gvFreq.Columns.Count == 0)
            {
                for (int ColumnIndex = 0; ColumnIndex < DtFreqView.Columns.Count; ColumnIndex++)
                {
                    BoundField bfCell = new BoundField()
                    {
                        DataField      = DtFreqView.Columns[ColumnIndex].ColumnName,
                        HeaderText     = new CglFunc().ConvertFieldNameId(DtFreqView.Columns[ColumnIndex].ColumnName, 1),
                        SortExpression = DtFreqView.Columns[ColumnIndex].ColumnName,
                    };
                    gvFreq.Columns.Add(bfCell);
                }
                foreach (DataControlField dcColumn in gvFreq.Columns)
                {
                    string strColumnName = dcColumn.SortExpression;
                    if (_dicNumcssclass.Keys.Contains(strColumnName.Substring(4)))
                    {
                        dcColumn.HeaderStyle.CssClass = _dicNumcssclass[strColumnName.Substring(4)];
                    }
                }
            }
            gvFreq.DataBind();
        }