public ActionResult ActivityLook(int ID) { ActivityIntroductionModel activity = new ActivityIntroductionModel(); activity = new FAQManager().GetActivityIntroductionById(ID); return(View(activity)); }
/// <summary> /// 新增活动信息 /// </summary> /// <param name="activity"></param> /// <param name="Type"></param> public int AddOrUpActivityIntroduction(ActivityIntroductionModel activity, string Type) { try { return(DalActivityIntroduction.AddOrUpActivityIntroduction(activity, Type)); } catch (Exception innerEx) { throw innerEx; } }
public ActionResult AddActivityIntroduction(int ID) { ActivityIntroductionModel activity = new ActivityIntroductionModel(); if (ID > 0) { activity = new FAQManager().GetActivityIntroductionById(ID); } if (activity == null) { activity = new ActivityIntroductionModel(); } return(View(activity)); }
/// <summary> /// 修改/新增活动信息 /// </summary> /// <param name="activityName"></param> /// <param name="orderChannel"></param> /// <param name="startTime"></param> /// <param name="endTime"></param> /// <param name="activityContent"></param> /// <param name="ID"></param> /// <returns></returns> public ActionResult AddOrUpdateActivityIntroduction(string activityName, string orderChannel, string startTime, string endTime, string activityContent, int ID) { ActivityIntroductionModel activity = new ActivityIntroductionModel(); activity.ID = ID; activity.ActivityName = System.Web.HttpUtility.UrlDecode(activityName); activity.ActivityChannel = System.Web.HttpUtility.UrlDecode(orderChannel); activity.ActivityContent = System.Web.HttpUtility.UrlDecode(activityContent); activity.StartTime = Convert.ToDateTime(startTime); activity.EndTime = Convert.ToDateTime(endTime); activity.CreateUser = User.Identity.Name; int returnVal = new FAQManager().AddOrUpActivityIntroduction(activity, ""); return(Json(returnVal)); }
/// <summary> /// 新增活动信息 /// </summary> /// <param name="Pay"></param> /// <param name="Qd"></param> /// <param name="Type"></param> public static int AddOrUpActivityIntroduction(ActivityIntroductionModel activity, string Type) { var listPar = new List <SqlParameter>(); listPar.Add(new SqlParameter("@ActivityName", activity.ActivityName)); listPar.Add(new SqlParameter("@ActivityChannel", activity.ActivityChannel)); listPar.Add(new SqlParameter("@StartTime", activity.StartTime)); listPar.Add(new SqlParameter("@EndTime", activity.EndTime)); listPar.Add(new SqlParameter("@ActivityContent", activity.ActivityContent)); string sSql = @""; if (activity.ID == 0) //新增 { listPar.Add(new SqlParameter("@CreateUser", activity.CreateUser)); sSql = @"INSERT INTO dbo.tbl_ActivityIntroduction ( ActivityName , ActivityChannel , StartTime , EndTime , ActivityContent , CreateUser ) VALUES ( @ActivityName , @ActivityChannel , @StartTime , @EndTime , @ActivityContent , @CreateUser ) "; } else { listPar.Add(new SqlParameter("@ID", activity.ID)); sSql = @"UPDATE dbo.tbl_ActivityIntroduction SET ActivityName = @ActivityName ,ActivityChannel = @ActivityChannel ,StartTime = @StartTime ,EndTime = @EndTime ,ActivityContent = @ActivityContent WHERE ID = @ID"; } return(DbHelper.ExecuteNonQuery(sSql, CommandType.Text, listPar.ToArray())); }
public static ActivityIntroductionModel GetActivityIntroductionById(SqlConnection connection, int ID) { ActivityIntroductionModel activity = null; string sSql = @"SELECT ID , ActivityName , ActivityChannel , StartTime , EndTime , ActivityContent , CreateTime , CreateUser , Shorder , Status FROM dbo.tbl_ActivityIntroduction AS act WITH ( NOLOCK ) where ID = @ID"; SqlParameter[] parameters = { new SqlParameter("@ID", ID) }; using (var reader = SqlHelper.ExecuteReader(connection, CommandType.Text, sSql, parameters)) { while (reader.Read()) { activity = new ActivityIntroductionModel(); activity.ID = reader.GetTuhuValue <int>(0); activity.ActivityName = reader.GetTuhuString(1); activity.ActivityChannel = reader.GetTuhuString(2); activity.StartTime = reader.GetTuhuValue <DateTime>(3); activity.EndTime = reader.GetTuhuValue <DateTime>(4); activity.ActivityContent = reader.GetTuhuString(5); } } return(activity); }