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); }
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); } }