コード例 #1
0
        public static WeChatInfo GetWeChatInfoByProjectName(string projectName)
        {
            string sql = string.Format("select * from {0}(nolock) where ProjectName=@ProjectName", TableName);

            return(DBAccess.GetEntityFirstOrDefault <WeChatInfo>(sql, ConfigSetting.EeeYoocompany, new { ProjectName = projectName }));
        }
コード例 #2
0
ファイル: AccountDBOperate.cs プロジェクト: shenbo1/company
        public static Account LoginByMobileOrEmail(string name)
        {
            string sql = "select * from Account (nolock) where IsDeleted=0 and ( Email=@name or Mobile=@name);";

            return(DBAccess.GetEntityFirstOrDefault <Account>(sql, new { name = name }));
        }