// simple validation
bool validationIsOk(CustomerLike interest)
{
if (interest.CustomerIdILike == 0 || interest.CustomerIdLiked == 0)
{
return(false);
}
return(true);
}
/// <summary>
/// 获取用户喜欢列表
/// </summary>
/// <param name="id">用户ID</param>
/// <returns></returns>
public List <CustomerLike> GetCustomLike(int id)
{
int outTime = CacheHelper.Instance.CacheOutTime;
CustomerLike model = new CustomerLike();
model.cid = id;
var ListModel = CustomerLikeOper.Instance.Select(model);
return(ListModel);
}
// GET /api/CustomersInterest/1
public IHttpActionResult GetCustomerInterest(long id)
{
CustomerLike interest = m_db.Likes.SingleOrDefault(cus => cus.Id == id);
if (interest == null)
{
return(NotFound());
}
return(Ok(interest));
}
/// <summary>
/// 获取用户喜欢文章列表
/// </summary>
/// <param name="Userid">用户ID</param>
/// <returns></returns>
public List <CustomerLike> GetCustomLikeArticleList(int Userid)
{
int outTime = CacheHelper.Instance.CacheOutTime;
CustomerLike model = new CustomerLike();
model.cid = Userid;
model.type = UserLikeTypeVariable.ArticleLike;
var ListModel = CustomerLikeOper.Instance.Select(model);
return(ListModel);
}
public IHttpActionResult CreateCustomersInterest1(CustomerLike interest)
{
if (!validationIsOk(interest))
{
return(BadRequest());
}
//CustomersInterest CusInterest = m_db.CustomersInterest.Find(interest.Id);
m_db.Likes.Add(interest);
m_db.SaveChanges();
return(StatusCode(HttpStatusCode.NoContent));
}
/// <summary>
/// 获取用户喜欢餐厅
/// </summary>
/// <param name="Userid">用户Id</param>
/// <param name="RestId">餐厅Id</param>
/// <returns></returns>
public CustomerLike GetCustomLikeRest(int Userid, int RestId)
{
int outTime = CacheHelper.Instance.CacheOutTime;
CustomerLike model = new CustomerLike();
model.cid = Userid;
model.lid = RestId;
model.type = UserLikeTypeVariable.RestLike;
var Model = CustomerLikeOper.Instance.Select(model).FirstOrDefault();
return(Model);
}
public IHttpActionResult DeleteCustomersInterest(long id)
{
CustomerLike interest = m_db.Likes.Find(id);
if (interest == null)
{
return(NotFound());
}
m_db.Likes.Remove(interest);
m_db.SaveChanges();
return(Ok(interest));
}
/// <summary>
/// 设置用户喜欢餐厅
/// </summary>
/// <param name="Userid">用户Id</param>
/// <param name="RestId">餐厅Id</param>
/// <returns></returns>
public bool InsertCustomLikeRest(int Userid, int RestId)
{
int outTime = CacheHelper.Instance.CacheOutTime;
CustomerLike model = new CustomerLike();
model.cid = Userid;
model.lid = RestId;
model.type = UserLikeTypeVariable.RestLike;
var ListModel = CustomerLikeOper.Instance.Select(model).FirstOrDefault();
if (ListModel == null)
{
return(CustomerLikeOper.Instance.Insert(model));
}
return(false);
}
public IHttpActionResult UpdateCustomersInterest(CustomerLike interest)
{
if (!validationIsOk(interest))
{
return(BadRequest());
}
CustomerLike CusInterest = m_db.Likes.Find(interest.Id);
if (CusInterest == null)
{
return(NotFound());
}
CusInterest.CustomerIdLiked = interest.CustomerIdLiked;
CusInterest.CustomerIdILike = interest.CustomerIdILike;
m_db.SaveChanges();
return(StatusCode(HttpStatusCode.NoContent));
}
public ResultJson CustomerLikeOrNot(CustomLikeRequest request)
{
ResultJson result = new ResultJson();
CustomerLike customerLike = new CustomerLike();
customerLike.cid = request.UserId;
customerLike.lid = request.OtherId;
customerLike.type = request.Type_Like.ToLower();
bool result1 = false, result2 = false;
if (request.Opertion.ToLower() == Enum_Opertion.Delete.Enum_GetString())
{
result1 = CustomerLikeOper.Instance.DeleteByModel(customerLike);
if (result1)
{
result.HttpCode = 200;
result.Message = Enum_Message.DataDeleteSuccessMessage.Enum_GetString();
}
else
{
result.HttpCode = 300;
result.Message = Enum_Message.NoMoreDataMessage.Enum_GetString();
}
}
else if (request.Opertion.ToLower() == Enum_Opertion.Insert.Enum_GetString())
{
if (request.Type_Like.ToLower() == UserLikeTypeVariable.FoodLike || request.Type_Like.ToLower() == UserLikeTypeVariable.FoodUnLike)
{
customerLike.type = null;
var customer_like = CustomerLikeOper.Instance.Select(customerLike).Where(p => p.type.ToLower() == UserLikeTypeVariable.FoodLike || p.type.ToLower() == UserLikeTypeVariable.FoodUnLike).FirstOrDefault();
if (customer_like != null)
{
customer_like.type = request.Type_Like.ToLower();
result2 = CustomerLikeOper.Instance.Update(customer_like);
}
else
{
customerLike.type = request.Type_Like.ToLower();
result2 = CustomerLikeOper.Instance.Insert(customerLike);
}
}
else if (request.Type_Like.ToLower() == UserLikeTypeVariable.RestLike || request.Type_Like.ToLower() == UserLikeTypeVariable.ArticleLike)
{
var customer_like_list = CustomerLikeOper.Instance.Select(customerLike);
if (customer_like_list.Count != 0)
{
result.HttpCode = 300;
result.Message = Enum_Message.DataExitMessage.Enum_GetString();
return(result);
}
else
{
result2 = CustomerLikeOper.Instance.Insert(customerLike);
}
}
if (result2)
{
result.HttpCode = 200;
result.Message = Enum_Message.DataInsertSuccessMessage.Enum_GetString();
}
else
{
result.HttpCode = 300;
result.Message = Enum_Message.NoMoreDataMessage.Enum_GetString();
}
}
return(result);
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="customerlike"></param>
/// <param name="pageSize">页面大小</param>
/// <param name="pageNo">页面编号</param>
/// <returns>对象列表</returns>
public List <CustomerLike> SelectByPage(CustomerLike customerlike, int pageSize, int pageNo)
{
StringBuilder sql = new StringBuilder("Select Top ").Append(pageSize).Append(" ");
if (!customerlike.Field.IsNullOrEmpty())
{
sql.Append(customerlike.Field);
}
else
{
sql.Append("*");
}
sql.Append(" from CustomerLike ");
StringBuilder part1 = new StringBuilder();
StringBuilder part2 = new StringBuilder();
StringBuilder strBuliderPage = new StringBuilder();
var parm = new DynamicParameters();
bool flag = true;
if (!customerlike.id.IsNullOrEmpty())
{
if (flag)
{
part1.Append("id = @id");
flag = false;
}
else
{
part1.Append(" and id = @id");
}
parm.Add("id", customerlike.id);
}
if (!customerlike.cid.IsNullOrEmpty())
{
if (flag)
{
part1.Append("cid = @cid");
flag = false;
}
else
{
part1.Append(" and cid = @cid");
}
parm.Add("cid", customerlike.cid);
}
if (!customerlike.type.IsNullOrEmpty())
{
if (flag)
{
part1.Append("type = @type");
flag = false;
}
else
{
part1.Append(" and type = @type");
}
parm.Add("type", customerlike.type);
}
if (!customerlike.lid.IsNullOrEmpty())
{
if (flag)
{
part1.Append("lid = @lid");
flag = false;
}
else
{
part1.Append(" and lid = @lid");
}
parm.Add("lid", customerlike.lid);
}
if (!flag)
{
strBuliderPage.Append(" and");
}
strBuliderPage.Append(" id not in (").Append("Select Top ").Append(pageSize * (pageNo - 1)).Append(" id from CustomerLike ");
if (!customerlike.GroupBy.IsNullOrEmpty())
{
strBuliderPage.Append(" Group By ").Append(customerlike.GroupBy).Append(" ");
flag = false;
}
if (!customerlike.OrderBy.IsNullOrEmpty())
{
strBuliderPage.Append(" Order By ").Append(customerlike.OrderBy).Append(" ");
flag = false;
}
strBuliderPage.Append(" )");
if (!flag)
{
sql.Append(" where ");
}
sql.Append(part1).Append(strBuliderPage).Append(part1);
if (!customerlike.GroupBy.IsNullOrEmpty())
{
part2.Append(" Group By ").Append(customerlike.GroupBy).Append(" ");
}
if (!customerlike.OrderBy.IsNullOrEmpty())
{
part2.Append(" Order By ").Append(customerlike.OrderBy).Append(" ");
}
sql.Append(part2);
using (var conn = new SqlConnection(ConnString))
{
conn.Open();
var r = (List <CustomerLike>)conn.Query <CustomerLike>(sql.ToString(), parm);
conn.Close();
if (r == null)
{
r = new List <CustomerLike>();
}
return(r);
}
}
/// <summary>
/// 插入
/// </summary>
/// <param name="customerlike"></param>
/// <returns>是否成功</returns>
public bool Insert(CustomerLike customerlike)
{
StringBuilder sql = new StringBuilder("insert into CustomerLike ");
StringBuilder part1 = new StringBuilder();
StringBuilder part2 = new StringBuilder();
var parm = new DynamicParameters();
bool flag = true;
if (!customerlike.cid.IsNullOrEmpty())
{
if (flag)
{
part1.Append("cid");
part2.Append("@cid");
flag = false;
}
else
{
part1.Append(",cid");
part2.Append(",@cid");
}
parm.Add("cid", customerlike.cid);
}
if (!customerlike.type.IsNullOrEmpty())
{
if (flag)
{
part1.Append("type");
part2.Append("@type");
flag = false;
}
else
{
part1.Append(",type");
part2.Append(",@type");
}
parm.Add("type", customerlike.type);
}
if (!customerlike.lid.IsNullOrEmpty())
{
if (flag)
{
part1.Append("lid");
part2.Append("@lid");
flag = false;
}
else
{
part1.Append(",lid");
part2.Append(",@lid");
}
parm.Add("lid", customerlike.lid);
}
sql.Append("(").Append(part1).Append(") values(").Append(part2).Append(")");
using (var conn = new SqlConnection(ConnString))
{
conn.Open();
var r = conn.Execute(sql.ToString(), parm);
conn.Close();
return(r > 0);
}
}
/// <summary>
/// 删除
/// <summary>
/// <param name="Id"></param>
/// <returns>是否成功</returns>
public bool DeleteByModel(CustomerLike customerlike)
{
StringBuilder sql = new StringBuilder("Delete from CustomerLike ");
StringBuilder part1 = new StringBuilder();
var parm = new DynamicParameters();
bool flag = true;
if (!customerlike.id.IsNullOrEmpty())
{
if (flag)
{
part1.Append("id = @id");
flag = false;
}
else
{
part1.Append(" and id = @id");
}
parm.Add("id", customerlike.id);
}
if (!customerlike.cid.IsNullOrEmpty())
{
if (flag)
{
part1.Append("cid = @cid");
flag = false;
}
else
{
part1.Append(" and cid = @cid");
}
parm.Add("cid", customerlike.cid);
}
if (!customerlike.type.IsNullOrEmpty())
{
if (flag)
{
part1.Append("type = @type");
flag = false;
}
else
{
part1.Append(" and type = @type");
}
parm.Add("type", customerlike.type);
}
if (!customerlike.lid.IsNullOrEmpty())
{
if (flag)
{
part1.Append("lid = @lid");
flag = false;
}
else
{
part1.Append(" and lid = @lid");
}
parm.Add("lid", customerlike.lid);
}
if (flag)
{
return(false);
}
sql.Append(" where ");
sql.Append(part1);
using (var conn = new SqlConnection(ConnString))
{
conn.Open();
var r = conn.Execute(sql.ToString(), parm);
conn.Close();
return(r > 0);
}
}
