public ActionResult Add(string Name, int LinkType, int Sort, string WebUrl) { AjaxResponse <FriendLink> obj = new AjaxResponse <FriendLink>(); if (string.IsNullOrEmpty(Name)) { obj.ErrorMessage = "标题不能为空"; return(Json(obj)); } if (Name.Length > 15) { obj.ErrorMessage = "标题不能超过15个字"; return(Json(obj)); } //保证Name唯一,先查询一下是不是有这个Name var temp = FriendLinkService.PageLoad(a => a.LinkName == Name).FirstOrDefault(); if (temp != null) { obj.ErrorMessage = "该标题已经存在!"; return(Json(obj)); } FriendLink FriendLink = new FriendLink { LinkName = Name, LinkType = (LinkTypeEnum)LinkType, Sort = Sort, WebUrl = WebUrl, Status = StatusEnum.Normal }; obj.IsSuccess = FriendLinkService.AddModel(FriendLink); return(Json(obj)); }
public List <FriendLink> GetModelList(string loginName) { StringBuilder strSql = new StringBuilder(); strSql.Append("select Linkid,Linkname,Linkurl,loginName,linkdate from FriendLink "); strSql.Append(" where loginName=@loginName order by Linkid desc"); SqlParameter[] parameters = { new SqlParameter("@loginName", SqlDbType.VarChar, 50) }; parameters[0].Value = loginName; List <FriendLink> list = new List <FriendLink>(); DataSet ds = DBHelper.Query(strSql.ToString(), parameters); foreach (DataRow row in ds.Tables[0].Rows) { FriendLink model = new FriendLink(); if (row["Linkid"].ToString() != "") { model.Linkid = int.Parse(row["Linkid"].ToString()); } model.Linkname = row["Linkname"].ToString(); model.Linkurl = row["Linkurl"].ToString(); model.loginName = row["loginName"].ToString(); if (row["linkdate"].ToString() != "") { model.linkdate = row["linkdate"].ToString(); } list.Add(model); } return(list); }
public async Task <bool> AddEntityAsync(FriendLink t) { return(await Task.Run(() => { return _repository.Add(t); })); }
public static int InsertFriendLink(SqlConnection conn, FriendLink model) { const string sql1 = @"SELECT COUNT(0) FROM [Gungnir].[dbo].[tb_FriendLink] WITH ( NOLOCK ) WHERE FriendlinkName = @FriendlinkName "; var sqlParam1 = new SqlParameter[] { new SqlParameter("@FriendlinkName", model.FriendLinkName) }; int count = (int)SqlHelper.ExecuteScalar(conn, CommandType.Text, sql1, sqlParam1); if (count > 0) { return(-1); } const string sql = @"INSERT INTO [Gungnir].[dbo].[tb_FriendLink] (FriendlinkName, Link, position) VALUES ( @FriendlinkName, -- FriendlinkName - varchar(50) @Link, -- Link - varchar(500) @position ); SELECT @@IDENTITY"; var sqlParam = new SqlParameter[] { new SqlParameter("@FriendlinkName", model.FriendLinkName), new SqlParameter("@Link", model.Link), new SqlParameter("@position", model.Position) }; return(Convert.ToInt32(SqlHelper.ExecuteScalar(conn, CommandType.Text, sql, sqlParam))); }
/// <summary> /// 新增友链 /// </summary> /// <param name="dto"></param> /// <returns></returns> public async Task <ActionOutput <string> > InsertFriendLink(FriendLinkDto dto) { using (var uow = UnitOfWorkManager.Begin()) { var output = new ActionOutput <string>(); var friendLink = new FriendLink { Id = GenerateGuid(), Title = dto.Title, LinkUrl = dto.LinkUrl }; var result = await _friendLinkRepository.InsertAsync(friendLink); await uow.CompleteAsync(); if (result.IsNull()) { output.AddError("新增友链出错了~~~"); } else { output.Result = "success"; } return(output); } }
/// <summary> /// 作用:更改友情链接 /// 参数:实体对象 /// 作者:颜品庄 /// 2011-05-09 /// </summary> public int Update(FriendLink model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update FriendLink set "); strSql.Append("Linkname=@Linkname,"); strSql.Append("Linkurl=@Linkurl,"); strSql.Append("loginName=@loginName,"); strSql.Append("linkdate=@linkdate"); strSql.Append(" where Linkid=@Linkid "); SqlParameter[] parameters = { new SqlParameter("@Linkid", SqlDbType.Int, 4), new SqlParameter("@Linkname", SqlDbType.NVarChar, 100), new SqlParameter("@Linkurl", SqlDbType.NVarChar, 200), new SqlParameter("@loginName", SqlDbType.VarChar, 50), new SqlParameter("@linkdate", SqlDbType.DateTime) }; parameters[0].Value = model.Linkid; parameters[1].Value = model.Linkname; parameters[2].Value = model.Linkurl; parameters[3].Value = model.loginName; parameters[4].Value = model.linkdate; return(DBHelper.ExecuteCommand(strSql.ToString(), parameters)); }
/// <summary> /// 作用:添加友情链接 /// 参数:实体对象 /// 作者:颜品庄 /// 2011-05-09 /// </summary> public int Add(FriendLink model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into FriendLink("); strSql.Append("Linkname,Linkurl,loginName,linkdate)"); strSql.Append(" values ("); strSql.Append("@Linkname,@Linkurl,@loginName,@linkdate)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Linkname", SqlDbType.NVarChar, 100), new SqlParameter("@Linkurl", SqlDbType.NVarChar, 200), new SqlParameter("@loginName", SqlDbType.VarChar, 50), new SqlParameter("@linkdate", SqlDbType.DateTime) }; parameters[0].Value = model.Linkname; parameters[1].Value = model.Linkurl; parameters[2].Value = model.loginName; parameters[3].Value = model.linkdate; object obj = DBHelper.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
public FriendLink GetModel(int Linkid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Linkid,Linkname,Linkurl,loginName,linkdate from FriendLink "); strSql.Append(" where Linkid=@Linkid "); SqlParameter[] parameters = { new SqlParameter("@Linkid", SqlDbType.Int, 4) }; parameters[0].Value = Linkid; FriendLink model = new FriendLink(); DataSet ds = DBHelper.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["Linkid"].ToString() != "") { model.Linkid = int.Parse(ds.Tables[0].Rows[0]["Linkid"].ToString()); } model.Linkname = ds.Tables[0].Rows[0]["Linkname"].ToString(); model.Linkurl = ds.Tables[0].Rows[0]["Linkurl"].ToString(); model.loginName = ds.Tables[0].Rows[0]["loginName"].ToString(); if (ds.Tables[0].Rows[0]["linkdate"].ToString() != "") { model.linkdate = ds.Tables[0].Rows[0]["linkdate"].ToString(); } return(model); } else { return(null); } }
/// <summary> /// 添加 /// </summary> /// <param name="model"></param> /// <returns></returns> public virtual bool AddFriendLink(FriendLink model) { model.FriendLinkId = SeqGuid.NewGuid(); model.IsEnabled = true; model.CreateDate = DateTime.Now; Da.Add <Guid, FriendLink>(model); return(true); }
/// <summary> /// 修改友情链接页面 /// </summary> /// <param name="id"></param> /// <returns></returns> public ActionResult Update(int Id = 0) { FriendLink model = FriendLinkService.FindModel(Id); if (model == null)//查不到就让他添加(防恶意篡改ID) { return(RedirectToAction("Add")); } return(View(model)); }
public int Delete(FriendLink model) { string sql = "delete from FriendLink where Id = @Id"; SqlParameter[] param = { new SqlParameter("@Id", model.Id) }; return(SqlHelper.ExecuteNonQuery(sql, param)); }
public int Add(FriendLink model) { string sql = "insert into FriendLink(Title,Link,IsShow) values(@Title,@Link,@IsShow)"; SqlParameter[] param = { new SqlParameter("@Title", model.Title), new SqlParameter("@Link", model.Link), new SqlParameter("@IsShow", model.IsShow) }; return(SqlHelper.ExecuteNonQuery(sql, param)); }
/// <summary> /// 通过条件查询 /// </summary> /// <param name="WhereString">查询条件</param> /// <returns>FriendLink实体类对象</returns> public List <FriendLink> SelectByWhere(string WhereString) { SqlParameter[] param = new SqlParameter[] { new SqlParameter("@where", WhereString) }; List <FriendLink> list = new List <FriendLink>(); FriendLink model = null; using (SqlDataReader dr = DBHelper.RunProcedure("FriendLink_SelectByWhere", param)) { while (dr.Read()) { model = new FriendLink(); model.LinkId = Convert.ToInt32(dr["LinkId"]); if (DBNull.Value != dr["LinkName"]) { model.LinkName = dr["LinkName"].ToString(); } if (DBNull.Value != dr["Image"]) { model.Image = dr["Image"].ToString(); } if (DBNull.Value != dr["LinkHref"]) { model.LinkHref = dr["LinkHref"].ToString(); } if (DBNull.Value != dr["LinkType"]) { model.LinkType = Convert.ToInt32(dr["LinkType"]); } if (DBNull.Value != dr["OrderIndex"]) { model.OrderIndex = Convert.ToInt32(dr["OrderIndex"]); } if (DBNull.Value != dr["PlatformId"]) { model.PlatformId = Convert.ToInt32(dr["PlatformId"]); } if (DBNull.Value != dr["IsDelete"]) { model.IsDelete = Convert.ToBoolean(dr["IsDelete"]); } if (DBNull.Value != dr["IsShow"]) { model.IsShow = Convert.ToBoolean(dr["IsShow"]); } list.Add(model); } } return(list); }
public string GetFriendLinkParam(FriendLink param) { StringBuilder sb = new StringBuilder(); if (!string.IsNullOrEmpty(param.LinkName)) { sb.AppendFormat(" where IsDelete=0 and LinkName like '%{0}%' ", Utils.SqlSafe(param.LinkName)); } return(sb.ToString()); }
public int Edit(FriendLink model) { string sql = "update FriendLink set Title=@Title,Link=@Link,IsShow=@IsShow where Id = @Id"; SqlParameter[] param = { new SqlParameter("@Title", model.Title), new SqlParameter("@Link", model.Link), new SqlParameter("@IsShow", model.IsShow), new SqlParameter("@Id", model.Id) }; return(SqlHelper.ExecuteNonQuery(sql, param)); }
public List <FriendLink> GetFriendLinkListByTitle(string title) { string sql = "select * from FriendLink where Title like '%" + title + "%'"; var dt = SqlHelper.Query(sql, null); var list = new List <FriendLink>(); foreach (DataRow dr in dt.Rows) { FriendLink f = FillData(dr); list.Add(f); } return(list); }
public List <FriendLink> GetFriendLinkList() { string sql = "select * from FriendLink"; var dt = SqlHelper.Query(sql, null); var list = new List <FriendLink>(); foreach (DataRow dr in dt.Rows) { FriendLink f = FillData(dr); list.Add(f); } return(list); }
/// <summary> /// 通过Id查询 /// </summary> /// <param name="Id">主键Id</param> /// <returns>FriendLink实体类对象</returns> public FriendLink SelectById(int Id) { SqlParameter[] param = new SqlParameter[] { new SqlParameter("@LinkId", Id) }; FriendLink model = new FriendLink(); using (SqlDataReader dr = DBHelper.RunProcedure("FriendLink_SelectById", param)) { if (dr.Read()) { model.LinkId = Convert.ToInt32(dr["LinkId"]); if (DBNull.Value != dr["LinkName"]) { model.LinkName = dr["LinkName"].ToString(); } if (DBNull.Value != dr["Image"]) { model.Image = dr["Image"].ToString(); } if (DBNull.Value != dr["LinkHref"]) { model.LinkHref = dr["LinkHref"].ToString(); } if (DBNull.Value != dr["LinkType"]) { model.LinkType = Convert.ToInt32(dr["LinkType"]); } if (DBNull.Value != dr["OrderIndex"]) { model.OrderIndex = Convert.ToInt32(dr["OrderIndex"]); } if (DBNull.Value != dr["PlatformId"]) { model.PlatformId = Convert.ToInt32(dr["PlatformId"]); } if (DBNull.Value != dr["IsDelete"]) { model.IsDelete = Convert.ToBoolean(dr["IsDelete"]); } if (DBNull.Value != dr["IsShow"]) { model.IsShow = Convert.ToBoolean(dr["IsShow"]); } } } return(model); }
public ActionResult Add(FriendLink fl) { //前端验证是否有错误 if (ModelState.IsValid) { db.FriendLink.Add(fl); db.SaveChanges(); } else { return(View(fl)); } return(RedirectToAction("Article")); }
/// <summary> /// 增加 /// </summary> /// <param name="FriendLink">FriendLink实体对象</param> /// <returns>int值,返回自增ID</returns> public int AddReturnId(FriendLink model) { SqlParameter[] param = new SqlParameter[] { new SqlParameter("@LinkName", model.LinkName), new SqlParameter("@Image", model.Image), new SqlParameter("@LinkHref", model.LinkHref), new SqlParameter("@LinkType", model.LinkType), new SqlParameter("@OrderIndex", model.OrderIndex), new SqlParameter("@PlatformId", model.PlatformId), new SqlParameter("@IsDelete", model.IsDelete), new SqlParameter("@IsShow", model.IsShow) }; return(Convert.ToInt32(DBHelper.ExecuteScalar("FriendLink_AddReturnId", param))); }
public ActionResult Edit(FriendLink fl) { //前端验证是否有错误 if (ModelState.IsValid) { db.Entry(fl).State = EntityState.Modified; db.SaveChanges(); } else { return(View(fl)); } return(RedirectToAction("Article")); }
/// <summary> /// 增加 /// </summary> /// <param name="FriendLink">FriendLink实体对象</param> /// <returns>bool值,判断是否操作成功</returns> public bool Add(FriendLink model) { SqlParameter[] param = new SqlParameter[] { new SqlParameter("@LinkName", model.LinkName), new SqlParameter("@Image", model.Image), new SqlParameter("@LinkHref", model.LinkHref), new SqlParameter("@LinkType", model.LinkType), new SqlParameter("@OrderIndex", model.OrderIndex), new SqlParameter("@PlatformId", model.PlatformId), new SqlParameter("@IsDelete", model.IsDelete), new SqlParameter("@IsShow", model.IsShow) }; return(DBHelper.ExecuteNonQuery("FriendLink_Add", param)); }
public async Task <Response <string> > InsertFriendLinkAsync(FriendLinkDto dto) { var response = new Response <string>(); var friendLink = new FriendLink { Title = dto.Title, LinkUrl = dto.LinkUrl }; await _context.FriendLinks.AddAsync(friendLink); await _context.SaveChangesAsync(); response.Result = "新增成功"; return(response); }
public async Task <ActionResult> AddFriendLink(FriendLink param) { string str; int Code; param.Friendlink = System.Web.HttpUtility.HtmlEncode(param.Friendlink); param.FriendlinkImage = System.Web.HttpUtility.HtmlEncode(param.FriendlinkImage); param.FriendlinkIntroduce = System.Web.HttpUtility.HtmlEncode(param.FriendlinkIntroduce); param.FriendlinkTitle = System.Web.HttpUtility.HtmlEncode(param.FriendlinkTitle); param.FriendlinkCreateTime = DateTime.Now; param.IsShow = 0; Code = await friendLinkSerivce.AddEntityAsync(param) ? 200 : 500; str = Code == 200 ? "申请成功" : "申请失败"; return(Ok(new { code = Code, msg = str })); }
void BindLinks() { int id = 0; try { id = int.Parse(Request.QueryString["id"]); lnk = FriendLinks.FriendLinkGet(id); txtTitle.Text = lnk.Title; txtLink.Text = lnk.Url; ddlRank.SelectedIndex = lnk.Rank - 1; } catch (Exception ex) { throw new HHException(ExceptionType.NoMasterError, ex.Message); } }
public static bool UpdateFriendLink(SqlConnection conn, FriendLink model) { const string sql = @"UPDATE [Gungnir].[dbo].[tb_FriendLink] SET FriendlinkName = @FriendlinkName, Link = @Link, position = @position WHERE Fid=@Fid"; var sqlParam = new SqlParameter[] { new SqlParameter("@Fid", model.Fid), new SqlParameter("@FriendlinkName", model.FriendLinkName), new SqlParameter("@Link", model.Link), new SqlParameter("@position", model.Position) }; return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlParam) > 0); }
public int InsertFriendLink(FriendLink model) { try { return(handler.InsertFriendLink(model)); } catch (TuhuBizException) { throw; } catch (Exception ex) { var exception = new DownloadAppException(1, "InsertFriendLink", ex); Logger.Log(Level.Error, exception, "InsertFriendLink"); throw ex; } }
public void TestModelCreation() { Assert.DoesNotThrow(() => { var dt = new DegreeTag { Degree = 996, DisplayName = ".NET", Id = 251, NormalizedName = "dot-net" }; var mm = new Menu { DisplayOrder = 404, Icon = "icon", Id = Guid.NewGuid(), IsOpenInNewTab = false, Title = ".NET Rocks", Url = "https://dot.net" }; var cat = new Category { DisplayName = "dname", Id = Guid.Empty, Note = "note", RouteName = "route" }; var fl = new FriendLink { Id = Guid.Empty, LinkUrl = "https://996.icu", Title = "996 ICU" }; var arch = new Archive(2020, 9, 1); JsonSerializer.Serialize(dt); JsonSerializer.Serialize(mm); JsonSerializer.Serialize(cat); JsonSerializer.Serialize(arch); JsonSerializer.Serialize(fl); }); }
public JsonResult Update(FriendLink model) { bool result = DownloadAppManager.UpdateFriendLink(model); if (result) { var oprLog = new OprLog { ObjectID = model.Fid, ObjectType = "Friendlink", AfterValue = model.FriendLinkName + ", " + model.Link, Author = HttpContext.User.Identity.Name, Operation = "更改友情链接" }; new OprLogManager().AddOprLog(oprLog); } return(Json(result)); }
/// <summary> /// 获取友链通过sql语句 /// </summary> /// <param name="sql"></param> /// <returns></returns> private static List <FriendLink> GetLinkBySql(string sql) { List <FriendLink> list = new List <FriendLink>(); DataTable table = SSMS.GetDataSet(sql); foreach (DataRow row in table.Rows) { FriendLink friendlink = new FriendLink(); friendlink.Lid = (int)row["lid"]; friendlink.Ltitle = (string)row["ltitle"]; friendlink.Lhref = (string)row["lhref"]; friendlink.FLtime = (DateTime)row["fltime"]; friendlink.Luid = (int)row["luid"]; list.Add(friendlink); } return(list); }