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);
}
