public SmsBlackphoneInfo GetInfo(int id) { using (SelectAction action = new SelectAction(this.Entity)) { action.SqlWhere(SmsBlackphoneInfo.Columns.ID, id); return(action.QueryEntity <SmsBlackphoneInfo>()); } }
/// <summary> /// 查询一个实体 /// </summary> /// <returns></returns> public cms_user SelectDemo() { using (SelectAction action = new SelectAction(Entity)) { action.SqlWhere(cms_user.Columns.username, "wang", RelationEnum.LikeLeft); return(action.QueryEntity <cms_user>()); } }
public SmsContentfilterkeyInfo GetInfo(int id) { using (SelectAction action = new SelectAction(this.Entity)) { action.SqlWhere(SmsContentfilterkeyInfo.Columns.ID, id); return(action.QueryEntity <SmsContentfilterkeyInfo>()); } }
public cms_user SelectDemo1() { using (SelectAction action = new SelectAction(Entity)) { action.Cast <cms_user>() .Where(user1 => user1.username == "wangjun"); return(action.QueryEntity <cms_user>()); } }
/// <summary> /// 获取账号的基本信息 /// </summary> /// <param name="username"></param> /// <param name="password"></param> /// <returns></returns> public SmsAccountInfo GetAccountInfo(string username, string password) { using (SelectAction action = new SelectAction(Entity)) { action.SqlWhere(SmsAccountInfo.Columns.Account, username); action.SqlWhere(SmsAccountInfo.Columns.Password, md5.Encrypt(password)); return(action.QueryEntity <SmsAccountInfo>()); } }
public users getModel(string username, string pwd) { using (SelectAction action = new SelectAction(this.Entity)) { action.SqlWhere(users.Columns.username, username); if (!string.IsNullOrEmpty(pwd)) { action.SqlWhere(users.Columns.password, pwd); } return(action.QueryEntity <users>()); } }
/// <summary> /// 获取账号的基本信息 /// </summary> /// <param name="username"></param> /// <param name="password"></param> /// <returns></returns> public SmsAddrecordInfo GetAccountInfo(string username, string password) { using (SelectAction action = new SelectAction(Entity)) { action.SqlClomns = "_Sms_AddRecord.*"; { //添加视图的关联关系 List <QueryField> field = new List <QueryField>(); field.Add(new QueryField() { FiledName = SmsAddrecordInfo.Columns.AccountID, Condition = ConditionEnum.And, Value = SmsAccountInfo.Columns.ID }); action.AddJoin(ViewJoinEnum.leftjoin, "SmsAccountInfo", "Sms_AddRecord", field); } action.SqlWhere(SmsAccountInfo.Columns.Account, username); action.SqlWhere(SmsAccountInfo.Columns.Password, password); action.SqlOrderBy("_Sms_AddRecord." + SmsAddrecordInfo.Columns.CreateTime, OrderByEnum.Desc); return(action.QueryEntity <SmsAddrecordInfo>()); } }
public SmsEnterpriseCfgInfo GetModelWithKey(string cfgkey, int enterpriseId) { string key = "enterprise_" + cfgkey + enterpriseId; SmsEnterpriseCfgInfo getCacheValue = CacheHelper.Cache.Get <SmsEnterpriseCfgInfo>(key); if (getCacheValue == null) { using (SelectAction action = new SelectAction(this.Entity)) { action.SqlWhere(SmsEnterpriseCfgInfo.Columns.CfgKey, cfgkey); SmsEnterpriseCfgInfo info = action.QueryEntity <SmsEnterpriseCfgInfo>(); if (info != null) { CacheHelper.Cache.Set(key, info); return(info); } } } else { return(getCacheValue); } return(null); }