Пример #1
0
        public DataTable Get_Usuario(int UserID, int PerfilID, string EmpresaID, string Usuario)
        {
            CD_Helper objDL = new CD_Helper(AppSettings.GetConnectionString);
            DataTable dt;

            dt = objDL.Get_Usuario(UserID, PerfilID, EmpresaID, Usuario);
            return(dt);
        }
Пример #2
0
        public DataTable Get_UsersMenu(int UserID)
        {
            CD_Helper objDL = new CD_Helper(AppSettings.GetConnectionString);
            DataTable value;

            value = objDL.Get_UsersMenu(UserID);
            return(value);
        }
Пример #3
0
        public object ExecuteScalar(string sql)
        {
            CD_Helper objDL = new CD_Helper(AppSettings.GetConnectionString);
            object    value = null;

            value = objDL.ExecuteScalar(sql);
            return(value);
        }
Пример #4
0
        public DataTable GetSqlStringCommand(string connection, string sql)
        {
            CD_Helper objDL = new CD_Helper(connection);
            DataTable dt    = null;

            dt = objDL.GetDataSetSqlStringCommand(sql).Tables[0];
            return(dt);
        }
Пример #5
0
        public DataSet GetDataSetSqlStringCommand(string sql)
        {
            CD_Helper objDL = new CD_Helper(AppSettings.GetConnectionString);
            DataSet   dt    = null;

            dt = objDL.GetDataSetSqlStringCommand(sql);
            return(dt);
        }
Пример #6
0
        public void SendMail(string Subject, string Mensaje, string To)
        {
            CD_Helper objDL = new CD_Helper(AppSettings.GetConnectionString);

            objDL.SendMail(Subject, Mensaje, To);
        }