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