public List <Link> GetLink() { BLL.Cookie.TeUser U = GetCookie.GetUserCookie(); string condition = string.Format(@"[UserType]=1 and UserCode ='{0}' ", U.userCode); DataSet dataSet = UserManager.GetUserRoleInfoList(condition); string RoleCode = ""; for (int i = 0; i < dataSet.Tables[0].Rows.Count; i++) { RoleCode += "'" + dataSet.Tables[0].Rows[i]["RoleCode"].ToString() + "',"; } if (RoleCode != "") { RoleCode = RoleCode.Substring(0, RoleCode.Length - 1); StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT DISTINCT "); strSql.Append("[Code],[oaName],[link],[sort],[img],[State]"); strSql.Append(" FROM ViewRoleLink where "); strSql.Append(string.Format("RoleCode In ({0}) order by sort asc", RoleCode)); using (BLL.NETDISKDBEntities Db = new BLL.NETDISKDBEntities()) { DataSet Dt = SqlQueryForDataTatable1(Db.Database, strSql.ToString()); List <Link> result1 = List.ToList <Link>(Dt, 0); return(result1.ToList()); } } else { return(null); } }
public ActionResult Edit(BLL.Link L) { GetCookie.ExistCookie(); using (BLL.NETDISKDBEntities Db = new BLL.NETDISKDBEntities()) { try { var image = Request.Files["FileUpload1"]; if (image != null && image.ContentLength > 0) { string fileName = DateTime.Now.ToString("yyyyMMdd") + "-" + Path.GetFileName(image.FileName); string filePath = Path.Combine(Server.MapPath("~/Content/Img"), fileName); image.SaveAs(filePath); L.img = fileName; } DbEntityEntry <BLL.Link> entry = Db.Entry <BLL.Link>(L); entry.State = System.Data.Entity.EntityState.Modified; int re = Db.SaveChanges(); if (re > 0) { BLL.Log.UserLog.AddUserLog("修改系统成功", GetCookie.GetUserCookie().userName + " 成功修改 " + L.oaName + " 系统 "); } else { BLL.Log.UserLog.AddUserLog("修改系统失败", "数据修改失败!"); } } catch (Exception ex) { BLL.Log.UserLog.AddUserLog("修改系统失败", ex.Message); throw; } return(View("List")); } }
public ActionResult Add(BLL.Link L) { using (BLL.NETDISKDBEntities Db = new BLL.NETDISKDBEntities()) { try { var image = Request.Files["FileUpload1"]; if (image != null && image.ContentLength > 0) { string fileName = DateTime.Now.ToString("yyyyMMdd") + "-" + Path.GetFileName(image.FileName); string filePath = Path.Combine(Server.MapPath("~/Content/Img"), fileName); image.SaveAs(filePath); L.img = fileName; } L.State = 1; Db.Link.Add(L); int re = Db.SaveChanges(); if (re > 0) { BLL.Log.UserLog.AddUserLog("添加系统成功", GetCookie.GetUserCookie().userName + " 成功创建 " + L.oaName + " 系统 "); } else { BLL.Log.UserLog.AddUserLog("创建系统失败", "数据插入失败!"); } } catch (Exception ex) { BLL.Log.UserLog.AddUserLog("创建系统失败", ex.Message); throw; } return(View("List")); } }
public ActionResult Del(int code) { using (BLL.NETDISKDBEntities Db = new BLL.NETDISKDBEntities()) { try { BLL.Link L = new BLL.Link(); L.State = 0; L.Code = code; Db.Link.Attach(L); Db.Entry(L).Property(x => x.State).IsModified = true; string oaName = (from B in Db.Link where B.Code == code select B.oaName).ToList().FirstOrDefault(); int re = Db.SaveChanges(); if (re > 0) { BLL.Log.UserLog.AddUserLog("删除系统成功", GetCookie.GetUserCookie().userName + " 成功删除 " + oaName + " 系统 "); } else { BLL.Log.UserLog.AddUserLog("删除系统失败", "数据删除失败!"); } } catch (Exception ex) { BLL.Log.UserLog.AddUserLog("删除系统失败", ex.Message); throw; } return(View("List")); } }
public int GetUserLogCount() { int Count = 0; using (BLL.NETDISKDBEntities Db = new BLL.NETDISKDBEntities()) { Count = Db.UserLog.Count(); return(Count); } }
public int GetPostCount() { int Count = 0; using (BLL.NETDISKDBEntities Db = new BLL.NETDISKDBEntities()) { Count = Db.Link.Count(); return(Count); } }
public ActionResult Edit(int Code) { GetCookie.ExistCookie(); using (BLL.NETDISKDBEntities Db = new BLL.NETDISKDBEntities()) { var Model = (from B in Db.Link where B.Code == Code select B).ToList().FirstOrDefault(); return(View(Model)); } }
public ActionResult Redir(int Code) { //Cookie 验证 BLL.Cookie.TeUser U = GetCookie.GetUserCookie(); //获取数据 using (BLL.NETDISKDBEntities Db = new BLL.NETDISKDBEntities()) { var link = from b in Db.Link where b.Code == Code && b.State == 1 orderby b.sort select b; //假数据模式 //BLL.StringDb Db2 = new BLL.StringDb(); //List<BLL.StringDb.Link> linkDb = Db2.getLink(); //var link = from b in linkDb // where b.Code == Code // select b; foreach (var item in link) { string Url = ""; switch (Code) { case 12: Url = digital.getUrl(item.link, U.userCode, U.userType); return(Redirect("Http://" + Url)); case 2: Url = digital.GetDianUrl(item.link, U.userCode, U.userType); return(Redirect("Http://" + Url)); case 5: //Url = digital.GuangBo("user1", "111111"); return(Redirect("/VidoLogin/Login")); //return Redirect("Http://" + Url); default: break; } //其余直接跳转Url if (item.Code == Code) { return(Redirect("Http://" + item.link)); } } } return(Redirect("~/Home/Index")); }
protected void Application_Start() { System.Data.Entity.Database.SetInitializer <BLL.NETDISKDBEntities>(null); using (var dbcontext = new BLL.NETDISKDBEntities()) { var objectContext = ((IObjectContextAdapter)dbcontext).ObjectContext; var mappingCollection = (StorageMappingItemCollection)objectContext.MetadataWorkspace.GetItemCollection(DataSpace.CSSpace); mappingCollection.GenerateViews(new List <EdmSchemaError>()); } AreaRegistration.RegisterAllAreas(); FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters); RouteConfig.RegisterRoutes(RouteTable.Routes); BundleConfig.RegisterBundles(BundleTable.Bundles); }
public List <T> GetPostList <T>(int pageIndex, int pageSize, string strWhere, string TableName, string Order) { string wherestr = ""; if (!string.IsNullOrEmpty(strWhere)) { wherestr = " oaName like '%" + strWhere + "%' and "; } int startRow = (pageIndex - 1) * pageSize; StringBuilder strSql = new StringBuilder(); strSql.Append(" SELECT TOP " + pageSize + " * From (SELECT ROW_NUMBER() OVER (ORDER BY " + Order + " desc) AS RowNumber,* FROM " + TableName + " where " + wherestr + " State =1 ) as A "); strSql.Append("WHERE RowNumber > " + startRow + " ORDER BY RowNumber ASC "); using (BLL.NETDISKDBEntities Db = new BLL.NETDISKDBEntities()) { DbRawSqlQuery <T> query = Db.Database.SqlQuery <T>(strSql.ToString()); return(query.ToList()); } }