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