public Activity ConvertToActivityObject(SqlDataReader reader) { Activity activity =new Activity(); activity.ActivityType = reader["ActivityType"].DBToString(); activity.Adress = reader["Adress"].DBToString(); activity.ContentStyle = reader["ContentStyle"].DBToString(); activity.ContentText = reader["ContentText"].DBToString(); activity.CreatedTime = reader["CreatedTime"].DBToDateTime(); activity.Description = reader["Description"].DBToString(); activity.EndTime = reader["EndTime"].DBToDateTime(); activity.HoldBy = reader["HoldBy"].DBToString(); activity.Id = reader["Id"].DBToInt32(); activity.ImageUrl = reader["ImageUrl"].DBToString(); activity.Jingdu = reader["Jingdu"].DBToString(); activity.Keywords = reader["Keywords"].DBToString(); activity.LastUpdatedTime = reader["LastUpdatedTime"].DBToDateTime(); activity.Link = reader["Link"].DBToString(); activity.StartTime = reader["StartTime"].DBToDateTime(); activity.State = reader["State"].DBToInt32(); activity.Title = reader["Title"].DBToString(); activity.UserId = reader["UserId"].DBToInt32(); activity.ViewCount = reader["ViewCount"].DBToInt32(); activity.Weidu = reader["Weidu"].DBToString(); activity.LocationId = reader["LocationId"].DBToString(); activity.UserName = reader["UserName"].DBToString(); activity.IsFromMobile = reader["IsFromMobile"].DBToBoolean(); return activity; }
/// <summary> /// 发布活动。 /// </summary> /// <param name="activity"></param> /// <returns></returns> public bool CreateOrUpdateActivity(SqlConnection conn, Activity activity) { SqlParameter[] parameters = { new SqlParameter(column_activityId, activity.Id), new SqlParameter("@ActivityType", activity.ActivityType), new SqlParameter("@Adress", activity.Adress), new SqlParameter("@ContentStyle", activity.ContentStyle), new SqlParameter("@ContentText", activity.ContentText), new SqlParameter("@Description", activity.Description), new SqlParameter("@EndTime", activity.EndTime), new SqlParameter("@HoldBy", activity.HoldBy), new SqlParameter("@ImageUrl", activity.ImageUrl), new SqlParameter("@Jingdu", activity.Jingdu), new SqlParameter("@Weidu", activity.Weidu), new SqlParameter("@Keywords", activity.Keywords), new SqlParameter("@Link", activity.Link), new SqlParameter("@StartTime", activity.StartTime), new SqlParameter("@State", activity.State), new SqlParameter("@Title", activity.Title), new SqlParameter("@UserId", activity.UserId), new SqlParameter("@ViewCount", activity.ViewCount ?? 0), new SqlParameter("@LocationId", activity.LocationId), new SqlParameter("@CreatedTime", DateTime.Now), new SqlParameter("@LastUpdatedTime", DateTime.Now), new SqlParameter("@IsFromMobile", activity.IsFromMobile) }; DBHelper.CheckSqlSpParameter(parameters); return DBHelper.RunNonQueryProcedure(conn, SP_CreateOrUpdateActivity, parameters) > 0; }
public ActionResult ShareActivity(Activity activity) { ShareActivityViewModel model = new ShareActivityViewModel(); model.ActivityTypes = (new ActivityTypeManager()).GetAllActivityTypes(); if (!IsUserLogin) { model.ErrorMsg = "未登录或登录超时"; model.ErrorCode = "401"; } else { try { if (string.IsNullOrEmpty(activity.Title) || string.IsNullOrEmpty(activity.Description) || string.IsNullOrEmpty(activity.Adress)) { model.ErrorMsg = "标题或内容不能为空"; model.ErrorCode = "400"; } else { ActivityService service = new ActivityService(); activity.UserId = UserInfo.UserId; activity.LocationId = Request.Form["LocationId[]"]; activity.State = 3; activity.IsFromMobile = true; //activity.Description = Witbird.SHTS.Web.Public.StaticUtility.FilterSensitivewords(activity.Description); activity.ContentStyle = activity.Description; activity.ContentText = activity.Description; service.CreateOrUpdateActivity(activity); model.ErrorMsg = "发布成功!"; model.ErrorCode = "200"; return RedirectToAction("Index", "Activity", new { Area = "Mobile" }); } } catch (Exception e) { LogService.Log("ShareActivity 出错了!", e.ToString()); } } model.Activity = activity; return View(model); }
/// <summary> /// 创建或者跟新 /// </summary> /// <param name="id"></param> /// <returns></returns> public bool CreateOrUpdateActivity(Activity activity) { bool result = false; var conn = DBHelper.GetSqlConnection(); try { conn.Open(); result = activityDao.CreateOrUpdateActivity(conn, activity); } catch (Exception e) { LogService.Log("CreateOrUpdateActivity失败--" + e.Message, e.ToString()); } finally { conn.Close(); } return result; }
/// <summary> /// 更新activity 狀態 /// </summary> /// <param name="activity"></param> /// <returns></returns> public bool UpdateActivityStatu(SqlConnection conn, Activity activity) { SqlParameter[] parameters = { new SqlParameter(column_activityId, activity.Id), new SqlParameter("@State", activity.State) }; DBHelper.CheckSqlSpParameter(parameters); return DBHelper.RunNonQueryProcedure(conn, sp_UpdateActivityStatu, parameters) > 0; }