Esempio n. 1
0
        public static DataTable GetListLogAction(string strWhere, int PageSize, int StartRow)
        {
            if (strWhere == null)
            {
                strWhere = "";
            }
            string    channel = System.Configuration.ConfigurationManager.AppSettings["channel"];
            DataTable dt;

            using (Channel_LogDB objDB = new Channel_LogDB())
            {
                dt = (DataTable)objDB.CallStoredProcedure("GetListLogAction", new object[] { channel, strWhere, StartRow, PageSize }, new string[] { "@channel", "@strWhere", "@StartIndex", "@PageSize" }, true);
            }
            return(dt);
        }
Esempio n. 2
0
        public static int GetListLogActionCount(string strWhere)
        {
            if (strWhere == null)
            {
                strWhere = "";
            }

            string    channel = System.Configuration.ConfigurationManager.AppSettings["channel"];
            DataTable dt;

            using (Channel_LogDB objDB = new Channel_LogDB())
            {
                dt = (DataTable)objDB.CallStoredProcedure("GetListLogActionCount", new object[] { channel, strWhere }, new string[] { "@channel", "@strWhere" }, true);
            }

            return(Convert.ToInt32(dt.Rows[0][0]));
        }