コード例 #1
0
ファイル: index.aspx.cs プロジェクト: wmbeers/ga-tia
        private RegionTotals GetData(string prjAccount, ProlianceController prj, ProlianceConnection conn)
        {
            RegionTotals rtrn = null;

            rtrn = HttpContext.Current.Cache.Get(prjAccount + "cacheKey") as RegionTotals;
            if (rtrn == null)
            {
                rtrn = new RegionTotals();
                DataSet data = prj.GetPreProjectList(conn, prjAccount);
                if (data.Tables != null && data.Tables.Count > 0)
                {
                    //rtrn.TotalRevenueCollected = 0;
                    //int val = int.MinValue;
                    //foreach (DataRow row in data.Tables[0].Rows)
                    //{
                    //    string textVal = row["SmallProjectDocument_ApproximateValueText"] as string;
                    //    if (!string.IsNullOrEmpty(textVal))
                    //    {
                    //        textVal = textVal.Replace("$", string.Empty).Replace(",", string.Empty);
                    //        MatchCollection mc = Regex.Matches(textVal, "\\d+");
                    //        if (mc.Count > 0)
                    //        {
                    //            if (int.TryParse(mc[0].Value, out val))
                    //                rtrn.TotalRevenueCollected += val;
                    //        }
                    //    }
                    //}

                    string appVal = null;

                    DataSet ds = prj.GetProjectApproxValues(conn, prjAccount);
                    if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
                    {
                        appVal = ds.Tables[0].Rows[0]["ProjectDocument_ProjectApproximateValueText"] as string;
                    }

                    if (!string.IsNullOrEmpty(appVal))
                    {
                        appVal = appVal.Replace("$", string.Empty).Replace(",", string.Empty);
                        MatchCollection mc = Regex.Matches(appVal, "\\d+");
                        if (mc.Count > 0)
                        {
                            int val = int.MinValue;
                            if (int.TryParse(mc[0].Value, out val))
                                rtrn.TotalRevenueCollected = val;
                        }
                    }

                    rtrn.ApproximateRevenueCollected = appVal;
                    rtrn.TotalProjects = data.Tables[0].Rows.Count;
                    rtrn.ProjectAccount = prjAccount;
                }

                HttpContext.Current.Cache.Add(prjAccount + "cacheKey", rtrn, null, DateTime.Now.AddMinutes(5), System.Web.Caching.Cache.NoSlidingExpiration, System.Web.Caching.CacheItemPriority.Default, null);
            }

            return rtrn;
        }
コード例 #2
0
ファイル: regions.aspx.cs プロジェクト: wmbeers/ga-tia
        private void ProcessProject(string prjAccount, ProlianceController prj, ProlianceConnection conn, Literal revenue, Literal projects)
        {
            string appVal = null;

            DataSet ds = prj.GetProjectApproxValues(conn, prjAccount);
            if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
            {
                appVal = ds.Tables[0].Rows[0]["ProjectDocument_ProjectApproximateValueText"] as string;
            }

            FillData(prjAccount, prj, conn, revenue, projects, appVal);
        }