public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
string result = "1";
try
{
string type = context.Request.QueryString["type"].ToString();
int id = context.Request.QueryString["id"].ToString().ToInt();
UserCollectionBll ucbll = new UserCollectionBll();
//用户末登录 返回 0 result=0;
if (type == "add")
{
//用户登录 id
if (Cookie.Get("AdminInfo") != null)
{
HttpCookie cookie = Cookie.Get("AdminInfo");
int userid = HttpUtility.UrlDecode(cookie.Values["AdminId"]).ToInt();
UserCollection model = new UserCollection();
model.UserId = userid;
model.AddTime = DateTime.Now;
model.Productid = id;
if (!ucbll.Add(model).ResultStatus.Success)
result = "-1";
}
else
{
//末登录
result = "-2";
}
}
else
{
//用户登录 id
if (Cookie.Get("AdminInfo") != null)
{
HttpCookie cookie = Cookie.Get("AdminInfo");
int userid = HttpUtility.UrlDecode(cookie.Values["AdminId"]).ToInt();
if (!ucbll.DeleteList(" userid=" + userid + " and productid=" + id).ResultStatus.Success)
result = "-1";
}
else
{
//末登录
result = "-2";
}
}
}
catch
{
result = "-1";
}
context.Response.Write(result);
}
/// <summary>
/// 添加一条记录
/// </summary>
public int Add(UserCollection entity, IDbTransaction tran)
{
string sql = @"insert into [UserCollection]
([productid], [addTime], [userId])
values
(@productid, @addTime, @userId)";
object param = new
{
productid = entity.Productid,
addTime = entity.AddTime,
userId = entity.UserId
};
int count = tran.Connection.Execute(sql, param, tran);
return count;
}
/// <summary>
/// 添加一条记录
/// </summary>
public int Add(UserCollection entity)
{
string sql = @"insert into [UserCollection]
([productid], [addTime], [userId])
values
(@productid, @addTime, @userId)";
object param = new
{
productid = entity.Productid,
addTime = entity.AddTime,
userId = entity.UserId
};
using (IDbConnection conn = OpenConnection())
{
int count = conn.Execute(sql, param);
return count;
}
}
/// <summary>
/// 添加一条记录 返回自增ID
/// </summary>
public int AddAndReturn(UserCollection entity)
{
string sql = @"insert into [UserCollection]
([productid], [addTime], [userId])
values
(@productid, @addTime, @userId)";
object param = new
{
productid = entity.Productid,
addTime = entity.AddTime,
userId = entity.UserId
};
using (IDbConnection conn = OpenConnection())
{
int row = conn.Execute(sql, entity);
if (row > 0)
return conn.Query<UserCollection>("SELECT @@IDENTITY AS Id").Single<UserCollection>().Id;
else
return -1;
}
}
/// <summary>
/// 添加一条记录
/// </summary>
public ResultSet Add(UserCollection entity)
{
Func<UserCollection, ResultStatus> validate = (_entity) =>
{
return new ResultStatus();
};
Func<UserCollection, ResultStatus> op = (_entity) =>
{
int ret = new UserCollectionDal().Add(entity);
if (ret > 0)
return new ResultStatus();
else
return new ResultStatus()
{
Success = false,
Code = StatusCollection.AddFailed.Code,
Description = StatusCollection.AddFailed.Description
};
};
return HandleBusiness(entity, op, validate);
}
public int Update(UserCollection entity)
{
//GetUpdateSql2
string sql = @"update [UserCollection] set productid=@productid, addTime=@addTime, userId=@userId where id=@id ";
object param = new
{
id = entity.Id,
productid = entity.Productid,
addTime = entity.AddTime,
userId = entity.UserId
};
using (IDbConnection conn = OpenConnection())
{
int count = conn.Execute(sql, param);
return count;
}
}
/// <summary>
/// 添加一条记录 返回自增ID
/// </summary>
public int AddAndReturn(UserCollection entity)
{
return new UserCollectionDal().AddAndReturn(entity);
}
