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