Exemplo n.º 1
0
        protected void TryClearCach(string exe)
        {
            if (Instance == null)
            {
                return;
            }

            long id = Convert.ToInt64(Instance.Eval(keyName));

            string cachKey;

            if (CachResult(out cachKey))
            {
                var list = (List <T>)MemCach.GetCach(cachKey);
                if (list != null && list.Count > 0)
                {
                    this._selSql = string.Empty;
                    var oldorderbyList = orderByList;
                    var oldselPara     = selPara;
                    orderByList = new List <DBOrderby>();
                    var obj = LockHerper.GetLocker("loadall_" + this.tabName);

                    try
                    {
                        switch (exe)
                        {
                        case "add":
                        {
                            var t = this.WhereEq(keyName, id).ExecuteEntity();
                            if (t != null)
                            {
                                lock (obj)
                                {
                                    list.Add(t);
                                }
                            }
                            break;
                        }

                        case "del":
                        {
                            var t = list.Find(p => Convert.ToInt64(p.Eval(keyName)) == id);
                            if (t != null)
                            {
                                lock (obj)
                                {
                                    list.Remove(t);
                                }
                            }
                            break;
                        }

                        case "update":
                        {
                            var t    = list.Find(p => Convert.ToInt64(p.Eval(keyName)) == id);
                            var newt = this.WhereEq(keyName, id).ExecuteEntity();
                            if (t != null)
                            {
                                lock (obj)
                                {
                                    t = newt;
                                }
                            }
                            else
                            {
                                lock (obj)
                                {
                                    list.Add(newt);
                                }
                            }

                            break;
                        }
                        }
                    }
                    finally
                    {
                        orderByList = oldorderbyList;
                        selPara     = oldselPara;
                        _selSql     = string.Empty;
                    }
                }
                //MemCach.RemoveCachItem(cachKey);
            }
        }
Exemplo n.º 2
0
        public List <T> ExecuteList()
        {
            string cachKey;
            bool   cach = CachResult(out cachKey);

            if (cach)
            {
                object o = MemCach.GetCach(cachKey);
                if (o != null)
                {
                    return((List <T>)o);
                }
                else
                {
                    var obj = LockHerper.GetLocker("loadall_" + this.tabName);
                    lock (obj)
                    {
                        o = MemCach.GetCach(cachKey);
                        if (o != null)
                        {
                            return((List <T>)o);
                        }

                        var alllist = LoadAll();
                        MemCach.AddCach(cachKey, alllist, 1000);

                        return(alllist);
                    }
                }
            }

            List <T> result = new List <T>();

            Database DB = DatabaseFactory.CreateDatabase(database);

            StringBuilder sb = new StringBuilder();

            selPara.ForEach(s =>
            {
                string[] sus = s.First.Split('$');
                if (s.Second.Trim().Equals("in"))
                {
                    sb.AppendFormat(" And {0}{1}({2})", sus[0], s.Second, s.Thrid);
                }
                else
                {
                    sb.AppendFormat(" And {0}{1}@{0}{2}", sus[0], s.Second, (sus.Length > 1 ? sus[1] : ""));
                }
            });

            if (orderByList != null && orderByList.Count > 0)
            {
                sb.AppendLine(" order by ");
                foreach (var orderby in orderByList)
                {
                    sb.AppendFormat("{0} {1},", orderby.OrderbyColumnName, orderby.OrderbyDirection.ToString());
                }
                sb.Remove(sb.Length - 1, 1);
            }
            DbCommand cmd = DB.GetSqlStringCommand(string.Format(SelSql, sb.ToString()));

            selPara.ForEach(s =>
            {
                if (s.Second.Trim().Equals("in"))
                {
                    return;
                }

                DbParameter para   = cmd.CreateParameter();
                para.DbType        = GetDbType(s.Thrid.GetType());
                string[] sus       = s.First.Split('$');
                para.ParameterName = "@" + sus[0] + (sus.Length > 1 ? sus[1] : "");
                para.Value         = s.Thrid;

                cmd.Parameters.Add(para);
            });

            var ds = DB.ExecuteDataSet(cmd);

            if (ds.Tables.Count > 0)
            {
                Action <T, object>[] funs = null;
                var table0 = ds.Tables[0];
                for (int i = 0; i < table0.Rows.Count; i++)
                {
                    result.Add(ParseDataRow(table0.Rows[i], ref funs));
                }
                //result = table0.AsEnumerable().Select(p => ParseDataRow(p,ref funs)).ToList();
            }

            ////这里可以优化下,采用断线对象
            //using (IDataReader dr = DB.ExecuteReader(cmd))
            //{
            //    List<string> cols = null;
            //    while (dr.Read())
            //    {
            //        T t = ParseDataReader(dr,ref cols);
            //        result.Add(t);
            //    }
            //}

            return(result);
        }