Esempio n. 1
0
        private void LL()
        {
            string sSql = "select * from PPT where Str=@Str order by Taxis asc";

            IDataParameter[] dp =
            {
                DbHelp.Def.AddParam("@Str", str),
            };

            DbHelpParam param = new DbHelpParam(sSql, dp);

            dtPPT = cac.GetDataTable("pptlist_" + str, param);
        }
Esempio n. 2
0
        public DataTable GetDataTable(string pName, DbHelpParam pParam)
        {
            string sKey = this.prefix + pName;
            object o    = instance.GetCacheData(sKey);

            if (o == null)
            {
                DataTable dt = DbHelp.GetDataTable(pParam);
                Fn.SetDataTablePrimary(dt);
                instance.Add(sKey, dt, TimeOut);
                return(dt);
            }
            else
            {
                return((DataTable)o);
            }
        }