protected static MySqlParameter[] GetParameters(UrsuserextInfo item) { return(new MySqlParameter[] { GetParameter("?ExtNumber", MySqlDbType.Int32, 11, item.ExtNumber), GetParameter("?ExtCHTInfo", MySqlDbType.Text, -1, item.ExtCHTInfo) }); }
public static UrsuserextInfo GetItem(int?ExtNumber) { if (ExtNumber == null) { return(null); } if (itemCacheTimeout <= 0) { return(dal.GetItem(ExtNumber)); } string key = string.Concat("DC2016_BLL_Ursuserext_", ExtNumber); string value = RedisHelper.Get(key); if (!string.IsNullOrEmpty(value)) { try { return(new UrsuserextInfo(value)); } catch { } } UrsuserextInfo item = dal.GetItem(ExtNumber); if (item == null) { return(null); } RedisHelper.Set(key, item.Stringify(), itemCacheTimeout); return(item); }
private static void RemoveCache(UrsuserextInfo item) { if (item == null) { return; } RedisHelper.Remove(string.Concat("DC2016_BLL_Ursuserext_", item.ExtNumber)); }
public static DC2016.DAL.Ursuserext.SqlUpdateBuild UpdateDiy(UrsuserextInfo item, int?ExtNumber) { if (itemCacheTimeout > 0) { RemoveCache(item != null ? item : GetItem(ExtNumber)); } return(new DC2016.DAL.Ursuserext.SqlUpdateBuild(item, ExtNumber)); }
public static int Update(UrsuserextInfo item) { if (itemCacheTimeout > 0) { RemoveCache(item); } return(dal.Update(item)); }
public static UrsuserextInfo Insert(UrsuserextInfo item) { item = dal.Insert(item); if (itemCacheTimeout > 0) { RemoveCache(item); } return(item); }
public static bool CreateUser(int number, string acct, int qq, string mobile, string idcard, string extinfo) { if (number < 10000) { return(false); } bool isexisted = Ursacct.IsExistNumber(number); UrsacctInfo acctInfo = new UrsacctInfo() { AcctNumber = number, AcctEMail = acct }; Ursacct.Insert(acctInfo); if (!isexisted) { //rc &= URSUserInfo.Create(Operator, ACCT_Number, USRI_QQ, USRI_Mobile, USRI_IDCard); UrsuserInfo userInfo = new UrsuserInfo() { UrsNumber = number, UrsQQ = qq, UrsMobile = mobile, UrsIDCard = idcard, UrsBirthDay = null, UrsTime = null }; Ursuser.Insert(userInfo); //rc &= URSUserExtInfo.Create(Operator, ACCT_Number, UEXT_CHTInfo); UrsuserextInfo userExtInfo = new UrsuserextInfo() { ExtNumber = number, ExtCHTInfo = extinfo }; Ursuserext.Insert(userExtInfo); } return(true); }
public SqlUpdateBuild(UrsuserextInfo item, int?ExtNumber) { _item = item; _where = SqlHelper.Addslashes("`ExtNumber` = {0}", ExtNumber); }
public int Update(UrsuserextInfo item) { return(new SqlUpdateBuild(null, item.ExtNumber) .SetExtCHTInfo(item.ExtCHTInfo).ExecuteNonQuery()); }
public UrsuserextInfo Insert(UrsuserextInfo item) { SqlHelper.ExecuteNonQuery(TSQL.Insert, GetParameters(item)); return(item); }