/// <summary> /// 一次性获取多个软件的一次性用户 /// </summary> /// <param name="ids"></param> /// <param name="channelid"></param> /// <returns></returns> public List <Sjqd_StatUsersByOneTime> GetSjqd_AllSoftsOneTimeUsers(string ids) { string key = BuildCacheKey("GetSjqd_StatUsersByOneTime", ids); List <Sjqd_StatUsersByOneTime> list = CacheHelper.Get <List <Sjqd_StatUsersByOneTime> >(key); if (list == null) { if (string.IsNullOrEmpty(ids.Trim())) { return(new List <Sjqd_StatUsersByOneTime>()); } string cmdText = string.Format(@" select SoftID,Platform,ChannelID,UserCount from Sjqd_StatUsersByOneTime where softid in({0}) and channelid=0 ", ids); list = new List <Sjqd_StatUsersByOneTime>(); using (IDataReader read = SqlHelper.ExecuteReader(statdbConn, CommandType.Text, cmdText)) { while (read.Read()) { Sjqd_StatUsersByOneTime onetimeuser = new Sjqd_StatUsersByOneTime(); if (read["SoftID"] != null && read["SoftID"] != DBNull.Value) { onetimeuser.SoftID = Convert.ToInt32(read["SoftID"]); } if (read["Platform"] != null && read["Platform"] != DBNull.Value) { onetimeuser.Platform = Convert.ToInt32(read["Platform"]); } if (read["channelid"] != null && read["channelid"] != DBNull.Value) { onetimeuser.ChannelID = Convert.ToInt32(read["channelid"]); } if (read["UserCount"] != null && read["UserCount"] != DBNull.Value) { onetimeuser.UserCount = Convert.ToInt32(read["UserCount"]); } list.Add(onetimeuser); } } if (list.Count > 0) { CacheHelper.Set <List <Sjqd_StatUsersByOneTime> >(key, list, CacheTimeOption.TenMinutes); } } return(list); }
/// <summary> /// 根据软件ID 平台获取一次性用户 /// </summary> /// <param name="soft"></param> /// <param name="platform"></param> /// <param name="channelid"></param> /// <returns></returns> public List <Sjqd_StatUsersByOneTime> GetSjqd_StatUsersByOneTime(int soft, int platform, int channelid) { string key = BuildCacheKey("GetSjqd_StatUsersByOneTime", soft, platform, channelid); List <Sjqd_StatUsersByOneTime> list = CacheHelper.Get <List <Sjqd_StatUsersByOneTime> >(key); if (list == null) { string cmdText = @" select SoftID,Platform,ChannelID,UserCount from Sjqd_StatUsersByOneTime where softid=@SoftID and Platform=@Platform and channelid=@channelid "; SqlParameter[] param = new SqlParameter[] { new SqlParameter() { ParameterName = "@channelid", SqlDbType = System.Data.SqlDbType.Int, Size = 4, Value = channelid }, new SqlParameter() { ParameterName = "@SoftID", SqlDbType = System.Data.SqlDbType.Int, Size = 4, Value = soft }, new SqlParameter() { ParameterName = "@Platform", SqlDbType = System.Data.SqlDbType.TinyInt, Size = 1, Value = platform } }; list = new List <Sjqd_StatUsersByOneTime>(); using (IDataReader read = SqlHelper.ExecuteReader(statdbConn, CommandType.Text, cmdText, param)) { while (read.Read()) { Sjqd_StatUsersByOneTime onetimeuser = new Sjqd_StatUsersByOneTime(); if (read["SoftID"] != null && read["SoftID"] != DBNull.Value) { onetimeuser.SoftID = Convert.ToInt32(read["SoftID"]); } if (read["Platform"] != null && read["Platform"] != DBNull.Value) { onetimeuser.Platform = Convert.ToInt32(read["Platform"]); } if (read["channelid"] != null && read["channelid"] != DBNull.Value) { onetimeuser.ChannelID = Convert.ToInt32(read["channelid"]); } if (read["UserCount"] != null && read["UserCount"] != DBNull.Value) { onetimeuser.UserCount = Convert.ToInt32(read["UserCount"]); } list.Add(onetimeuser); } } if (list.Count > 0) { CacheHelper.Set <List <Sjqd_StatUsersByOneTime> >(key, list, CacheTimeOption.TenMinutes); } } return(list); }