public int Insert(FeatureUserInfo model) { model.Id = Guid.NewGuid(); _db.FeatureUsers.Insert(model); return(1); }
public void DoFeatureUser(Guid userId, Guid featureId, string typeName, bool isSingle) { SqlParameter[] parms = { new SqlParameter("@UserId", userId), new SqlParameter("@TypeName", SqlDbType.NVarChar, 20) }; parms[1].Value = typeName; var bll = new FeatureUser(); var list = bll.GetList("and UserId = @UserId and TypeName = @TypeName ", parms); var isExist = false; foreach (var item in list) { if (!item.FeatureId.Equals(featureId)) { if (isSingle) { bll.Delete(userId, item.FeatureId); } } else { isExist = true; } } if (!isExist) { var fuInfo = new FeatureUserInfo(userId, featureId, typeName, DateTime.Now); bll.Insert(fuInfo); } }
public FeatureUserInfo GetModel(Guid userId, Guid featureId) { FeatureUserInfo model = null; StringBuilder sb = new StringBuilder(300); sb.Append(@"select top 1 UserId,FeatureId,TypeName,LastUpdatedDate from FeatureUser where UserId = @UserId and FeatureId = @FeatureId " ); SqlParameter[] parms = { new SqlParameter("@UserId", SqlDbType.UniqueIdentifier), new SqlParameter("@FeatureId", SqlDbType.UniqueIdentifier) }; parms[0].Value = userId; parms[1].Value = featureId; using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.AfdDbConnString, CommandType.Text, sb.ToString(), parms)) { if (reader != null) { if (reader.Read()) { model = new FeatureUserInfo(); model.UserId = reader.GetGuid(0); model.FeatureId = reader.GetGuid(1); model.TypeName = reader.GetString(2); model.LastUpdatedDate = reader.GetDateTime(3); } } } return(model); }
public IList <FeatureUserInfo> GetList() { StringBuilder sb = new StringBuilder(300); sb.Append(@"select UserId,FeatureId,TypeName,LastUpdatedDate from FeatureUser order by LastUpdatedDate desc " ); IList <FeatureUserInfo> list = new List <FeatureUserInfo>(); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.AfdDbConnString, CommandType.Text, sb.ToString())) { if (reader != null && reader.HasRows) { while (reader.Read()) { FeatureUserInfo model = new FeatureUserInfo(); model.UserId = reader.GetGuid(0); model.FeatureId = reader.GetGuid(1); model.TypeName = reader.GetString(2); model.LastUpdatedDate = reader.GetDateTime(3); list.Add(model); } } } return(list); }
public IList <FeatureUserInfo> GetList(string sqlWhere, params SqlParameter[] cmdParms) { StringBuilder sb = new StringBuilder(500); sb.Append(@"select UserId,FeatureId,TypeName,LastUpdatedDate from FeatureUser "); if (!string.IsNullOrEmpty(sqlWhere)) { sb.AppendFormat(" where 1=1 {0} ", sqlWhere); } sb.Append("order by LastUpdatedDate desc "); IList <FeatureUserInfo> list = new List <FeatureUserInfo>(); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.AfdDbConnString, CommandType.Text, sb.ToString(), cmdParms)) { if (reader != null && reader.HasRows) { while (reader.Read()) { FeatureUserInfo model = new FeatureUserInfo(); model.UserId = reader.GetGuid(0); model.FeatureId = reader.GetGuid(1); model.TypeName = reader.GetString(2); model.LastUpdatedDate = reader.GetDateTime(3); list.Add(model); } } } return(list); }
public IList <FeatureUserInfo> GetList(int pageIndex, int pageSize, out int totalRecords, string sqlWhere, params SqlParameter[] cmdParms) { StringBuilder sb = new StringBuilder(500); sb.Append(@"select count(*) from FeatureUser "); if (!string.IsNullOrEmpty(sqlWhere)) { sb.AppendFormat(" where 1=1 {0} ", sqlWhere); } totalRecords = (int)SqlHelper.ExecuteScalar(SqlHelper.AfdDbConnString, CommandType.Text, sb.ToString(), cmdParms); if (totalRecords == 0) { return(new List <FeatureUserInfo>()); } sb.Clear(); int startIndex = (pageIndex - 1) * pageSize + 1; int endIndex = pageIndex * pageSize; sb.Append(@"select * from(select row_number() over(order by LastUpdatedDate desc) as RowNumber, UserId,FeatureId,TypeName,LastUpdatedDate from FeatureUser " ); if (!string.IsNullOrEmpty(sqlWhere)) { sb.AppendFormat(" where 1=1 {0} ", sqlWhere); } sb.AppendFormat(@")as objTable where RowNumber between {0} and {1} ", startIndex, endIndex); IList <FeatureUserInfo> list = new List <FeatureUserInfo>(); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.AfdDbConnString, CommandType.Text, sb.ToString(), cmdParms)) { if (reader != null && reader.HasRows) { while (reader.Read()) { FeatureUserInfo model = new FeatureUserInfo(); model.UserId = reader.GetGuid(1); model.FeatureId = reader.GetGuid(2); model.TypeName = reader.GetString(3); model.LastUpdatedDate = reader.GetDateTime(4); list.Add(model); } } } return(list); }
public ResResultModel GetFeatureUserInfo(string username, string typeName) { try { var bll = new FeatureUser(); var fuInfo = bll.GetModel(SecurityService.GetUserId(username), typeName); if (fuInfo == null) { fuInfo = new FeatureUserInfo(); } return(ResResult.Response(true, "", JsonConvert.SerializeObject(fuInfo))); } catch (Exception ex) { return(ResResult.Response(false, ex.Message, "")); } }
private void GetFeatureUserInfo(HttpContext context) { var userId = Guid.Parse(Membership.GetUser(context.Request.Form["UserName"]).ProviderUserKey.ToString()); var typeName = context.Request.Form["TypeName"]; var bll = new FeatureUser(); FeatureUserInfo fuInfo = bll.GetModel(userId, typeName); if (fuInfo != null) { context.Response.Write(ResResult.ResJsonString(true, "", JsonConvert.SerializeObject(fuInfo))); } else { context.Response.Write(ResResult.ResJsonString(true, "", "{}")); } }
public IList <FeatureUserInfo> GetList(string sqlWhere, params SqlParameter[] cmdParms) { FeatureUserInfo model = ConvertToModel.ToModel <FeatureUserInfo>(cmdParms); IEnumerable <FeatureUserInfo> datas = _db.FeatureUsers.FindAll(); if (!model.UserId.Equals(Guid.Empty)) { datas = datas.Where(m => m.UserId.Equals(model.UserId)); } if (!string.IsNullOrEmpty(model.TypeName)) { datas = datas.Where(m => m.TypeName.Equals(model.TypeName)); } return(datas.ToList()); }
public FeatureUserInfo GetModel(Guid userId, string typeName) { FeatureUserInfo model = null; var sb = new StringBuilder(300); sb.AppendFormat(@"select top 1 fu.UserId,fu.FeatureId,fu.TypeName ,sm.Coded,sm.Named,sm.SiteLogo,sm.SiteTitle,sm.CultureName from FeatureUser fu left join {0}SiteMulti sm on sm.Id = fu.FeatureId where UserId = @UserId and TypeName = @TypeName " , GlobalConfig.AspnetDb); SqlParameter[] parms = { new SqlParameter("@UserId", SqlDbType.UniqueIdentifier), new SqlParameter("@TypeName", SqlDbType.NVarChar, 20) }; parms[0].Value = userId; parms[1].Value = typeName; using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.TygaSoftDbConnString, CommandType.Text, sb.ToString(), parms)) { if (reader != null) { if (reader.Read()) { model = new FeatureUserInfo(); model.UserId = reader.GetGuid(0); model.FeatureId = reader.GetGuid(1); model.TypeName = reader.GetString(2); model.SiteCode = reader.IsDBNull(3) ? "" : reader.GetString(3); model.SiteName = reader.IsDBNull(4) ? "" : reader.GetString(4); model.SiteLogo = reader.IsDBNull(5) ? "" : reader.GetString(5); model.SiteTitle = reader.IsDBNull(6) ? "" : reader.GetString(6); model.CultureName = reader.IsDBNull(7) ? "" : reader.GetString(7); } } } return(model); }
public int Update(FeatureUserInfo model) { StringBuilder sb = new StringBuilder(500); sb.Append(@"update FeatureUser set TypeName = @TypeName,LastUpdatedDate = @LastUpdatedDate where UserId = @UserId and FeatureId = @FeatureId " ); SqlParameter[] parms = { new SqlParameter("@UserId", SqlDbType.UniqueIdentifier), new SqlParameter("@FeatureId", SqlDbType.UniqueIdentifier), new SqlParameter("@TypeName", SqlDbType.NVarChar,20), new SqlParameter("@LastUpdatedDate", SqlDbType.DateTime) }; parms[0].Value = model.UserId; parms[1].Value = model.FeatureId; parms[2].Value = model.TypeName; parms[3].Value = model.LastUpdatedDate; return(SqlHelper.ExecuteNonQuery(SqlHelper.AfdDbConnString, CommandType.Text, sb.ToString(), parms)); }
public int Insert(FeatureUserInfo model) { StringBuilder sb = new StringBuilder(300); sb.Append(@"insert into FeatureUser (UserId,FeatureId,TypeName,LastUpdatedDate) values (@UserId,@FeatureId,@TypeName,@LastUpdatedDate) " ); SqlParameter[] parms = { new SqlParameter("@UserId", SqlDbType.UniqueIdentifier), new SqlParameter("@FeatureId", SqlDbType.UniqueIdentifier), new SqlParameter("@TypeName", SqlDbType.NVarChar,20), new SqlParameter("@LastUpdatedDate", SqlDbType.DateTime) }; parms[0].Value = model.UserId; parms[1].Value = model.FeatureId; parms[2].Value = model.TypeName; parms[3].Value = model.LastUpdatedDate; return(SqlHelper.ExecuteNonQuery(SqlHelper.AfdDbConnString, CommandType.Text, sb.ToString(), parms)); }
public int Update(FeatureUserInfo model) { throw new NotImplementedException(); }
public int Update(FeatureUserInfo model) { return(dal.Update(model)); }
public int Insert(FeatureUserInfo model) { return(dal.Insert(model)); }