public int SaveCusLink(CusLink cusLink)
{
int result = 0;
using (IDbConnection conn = SqlHelpers.CreateDbConnection(_connection))
{
if (cusLink.Id > 0)
{
cusLink.Updatedate = DateTime.Now;
result = conn.Execute("update cuslink set " +
"title=@Title," +
"url=@Url," +
"catid=@Catid," +
"linktype=@LinkType," +
"updatedate=@Updatedate where id=@Id", cusLink);
}
else
{
cusLink.Adddate = DateTime.Now;
result = conn.Execute("INSERT INTO cuslink(title,url,status,catid,linktype,adddate)" +
"values(@Title,@Url,@Status,@Catid,@LinkType,@Adddate)", cusLink);
}
}
return(result);
}
public int SaveCusLink(CusLink cusLink)
{
var item = _mapper.Map <CusLinkProto>(cusLink);
var result = _client.SaveCusLink(item);
return(result.Result);
}
public CusLink GetCusLink(string id, string fields = "*")
{
var cusLink = new CusLink();
using (IDbConnection conn = SqlHelpers.CreateDbConnection(_connection))
{
string sql = string.Format("SELECT {0} FROM cuslink WHERE Id = @Id", fields);
cusLink = conn.QueryFirstOrDefault <CusLink>(sql, new { Id = id });
}
return(cusLink);
}
public JsonResult SaveCusLink(CusLink cusLink)
{
var linkCat = _linkService.GetLinkCat(cusLink.Catid);
if (linkCat == null)
{
return(Json(new { result = 0 }));
}
else
{
cusLink.LinkType = linkCat.Catname;
int result = _cusLinkService.SaveCusLink(cusLink);
return(Json(new { result }));
}
}
