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