public BaseObject UpdateLink(LinksEntity link)
{
using (LinkLogic logic = new LinkLogic())
{
return(logic.UpdateLink(link));
}
}
public BaseObject InsertLink(LinksEntity link)
{
using (LinkLogic logic = new LinkLogic())
{
return(logic.InsertLink(link));
}
}
public BaseObject InsertLink(LinksEntity link)
{
BaseObject obj = new BaseObject();
if (_db.Connection.State != ConnectionState.Open)
{
_db.Connection.Open();
}
using (var tran = _db.Connection.BeginTransaction())
{
try
{
var lin = new Links()
{
Contact = link.Contact,
Description = link.Description,
Email = link.Email,
LinkCategoryID = link.LinkCategoryID,
LinkUrl = link.LinkUrl,
Name = link.Name,
PictureFile = link.PictureFile,
SortOrder = link.SortOrder,
DateCreated = DateTime.Now,
UpdateUser = link.UpdateUser
};
_db.Links.Add(lin);
_db.SaveChanges();
tran.Commit();
obj.Tag = 1;
obj.Message = "保存成功！";
}
catch (Exception e)
{
tran.Rollback();
obj.Tag = -1;
obj.Message = "保存失败！";
}
finally
{
tran.Dispose();
}
}
return(obj);
}
public int Save(LinksEntity data)
{
try
{
return(Connection.Db.Query <int>("spLinksSet",
new
{
ID = data.Id,
TitleLink = data.TitleLink,
Address = data.Address,
Image = data.Image,
Description = data.Description,
Active = data.Active,
}, commandType: CommandType.StoredProcedure).SingleOrDefault());
}
catch (Exception ex)
{
Tools.SaveLog.Save(ex);
return(-1);
}
}
public List <LinksEntity> Search(LinksEntity data)
{
try
{
return(Connection.Db.Query <LinksEntity>("spLinksSearch",
new
{
ID = data.Id,
TitleLink = "%" + data.TitleLink + "%",
Address = "%" + data.Address + "%",
Image = "%" + data.Image + "%",
Description = "%" + data.Description + "%",
Active = data.Active,
}, commandType: CommandType.StoredProcedure).ToList());
}
catch (Exception ex)
{
Tools.SaveLog.Save(ex);
return(new List <LinksEntity>());
}
}
public BaseObject UpdateLink(LinksEntity link)
{
BaseObject obj = new BaseObject();
var l = _db.Links.Find(link.ID);
if (l == null)
{
obj.Tag = -1;
obj.Message = "该记录不存在！";
return(obj);
}
try
{
l.Contact = link.Contact;
l.Description = link.Description;
l.Email = link.Email;
l.Name = link.Name;
l.LinkUrl = link.LinkUrl;
l.PictureFile = link.PictureFile;
l.SortOrder = link.SortOrder;
l.UpdateUser = link.UpdateUser;
l.DateCreated = DateTime.Now;
l.LinkCategoryID = link.LinkCategoryID;
_db.SaveChanges();
obj.Tag = 1;
}
catch (Exception)
{
obj.Tag = -1;
obj.Message = "修改失败！";
}
return(obj);
}
public ActionResult EditLinkJson(LinksEntity param)
{
var list = new Helpers.SystemHelper().UpdateLink(param);
return(Json(list));
}
public ActionResult AddLinkJson(LinksEntity param)
{
var list = new Helpers.SystemHelper().InsertLink(param);
return(Json(list));
}
