/// <summary>
/// 插入操作
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public int Insert(UserPlanEntity entity)
{
string sql = @"INSERT INTO [UserPlan]
([UserId]
,[Importance]
,[Tag]
,[Detail]
,[IsRemind]
,[PerRemind]
,[perRemindTime]
,[HappenTime]
,[UseTime]
,[CreateTime]
,[UpdateTime])
VALUES
(@UserId
,@IMPORTANCE
,@Tag
,@Detail
,@IsRemind
,@PerRemind
,@perRemindTime
,@HappenTime
,@UseTime
,GETDATE()
,GETDATE())";
return(Execute(OpenMsSqlConnection(), sql, entity));
}
public JsonResult Edit(UserPlanEntity entity)
{
//entity.UserId = Account.UserId;
var id = _upService.Update(entity);
var result = new { result = id };
return(Json(result));
}
public JsonResult Add(UserPlanEntity entity)
{
entity.UserId = Account.UserId;
int id = _upService.Insert(entity);
var result = new { result = (id > 0) };
return(Json(result));
}
/// <summary>
/// 更新操作
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public bool Update(UserPlanEntity entity)
{
string sql = @"UPDATE [UserPlan]
SET [Importance] = @IMPORTANCE
,[Tag] = @Tag
,[Detail] = @Detail
,[IsRemind] = @IsRemind
,[PerRemind] = @PerRemind
,[perRemindTime] = @perRemindTime
,[HappenTime] = @HappenTime
,[UseTime] = @UseTime
,[UpdateTime] = GETDATE()
WHERE Id = @Id";
return(Execute(OpenMsSqlConnection(), sql, entity) > 0);
}
public bool Update(UserPlanEntity entity)
{
return(_repository.Update(entity));
}
public int Insert(UserPlanEntity entity)
{
return(_repository.Insert(entity));
}