コード例 #1
0
ファイル: AccountDBOperate.cs プロジェクト: shenbo1/company
        public static bool GetAccountByMobile(string mobile, int role)
        {
            string sql = "select COUNT(0) from Account (nolock) where IsDeleted=0 and Mobile=@mobile and Role=@role;";

            return(DBAccess.ExecuteSql <int>(sql, new { mobile = mobile, role = role }) > 0);
        }
コード例 #2
0
ファイル: AccountDBOperate.cs プロジェクト: shenbo1/company
        public static bool GetAccountByEmail(string email, int role)
        {
            string sql = "select COUNT(0) from Account (nolock) where IsDeleted=0 and Email=@email and Role=@role;";

            return(DBAccess.ExecuteSql <int>(sql, new { email = email, role = role }) > 0);
        }