public ActionResult AjaxVideoNewsEdit(VideoNewsParameter param)
{
var result = new JsonNetResult();
var r = new GeneralResponse();
try
{
if (param.Forever)
{
param.VideoNews.EndDate = new System.DateTime(9999, 12, 31, 23, 59, 59);
}
param.VideoNews.StartDate = TimeZoneInfo.ConvertTimeToUtc(param.VideoNews.StartDate,
Section.Get.Common.TimeZone);
param.VideoNews.EndDate = TimeZoneInfo.ConvertTimeToUtc(param.VideoNews.EndDate,
Section.Get.Common.TimeZone);
r.Code = (0L < param.VideoNews.VideoNewsId
? VideoNewsTableProvider.Update(param)
: VideoNewsTableProvider.Create(param)).ToString(Section.Get.Common.Culture);
//通知Master更新快取
// MasterServer.GetInstance().RefreshGameAnnouncements();
}
catch (Exception ex)
{
Log.Error(ex.Message, ex);
r.Code = "-11" + ex.Message;
}
result.Data = r;
return(result);
}
public ActionResult AjaxVideoNewsDeleteFile(VideoNewsParameter param)
{
var result = new JsonNetResult();
Io.DeleteFile(HttpContext.Server.MapPath($"~{param.VideoNews.ImgPath}"));
result.Data = new { Ststus = "OK" };
return(result);
}
/// <summary>
///
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public ActionResult VideoNews(VideoNewsParameter param)
{
param.KeyWord = HttpUtility.UrlDecode(param.KeyWord);
return(View(
new InternalDataTransferToView
{
List = VideoNewsTableProvider.List(param),
Data = param
}));
}
public ActionResult VideoNewsEdit(VideoNewsParameter param)
{
if (0L < param.VideoNews.VideoNewsId)
{
param.VideoNews.Fill(VideoNewsTableProvider.Detail(param));
}
return(View(new InternalDataTransferToView {
Data = param
}));
}
public static int Delete(VideoNewsParameter param)
{
using (var db = new MsSql(DbName.Official))
{
return(db.Write(CommandType.Text, " DELETE FROM [dbo].[VideoNews] WHERE VideoNewsId = @VideoNewsId;", new DbParameter[] {
new SqlParameter {
Value = param.VideoNews.VideoNewsId,
SqlDbType = SqlDbType.Int,
ParameterName = "@VideoNewsId",
Direction = ParameterDirection.Input
}
}));
}
}
public static DataSet List(VideoNewsParameter param)
{
using (var db = new MsSql(DbName.Official))
{
return(db.DataSet(
CommandType.StoredProcedure,
"[dbo].[sp_VideoNewsList_Sel]",
new DbParameter[] {
new SqlParameter {
Value = param.KeyWord,
SqlDbType = SqlDbType.NVarChar,
ParameterName = "@argStrKeyWord",
Direction = ParameterDirection.Input
},
new SqlParameter {
Value = param.StartUtcDateTime,
SqlDbType = SqlDbType.DateTime,
ParameterName = "@argDteStart",
Direction = ParameterDirection.Input
},
new SqlParameter {
Value = param.EndUtcDateTime,
SqlDbType = SqlDbType.DateTime,
ParameterName = "@argDteEnd",
Direction = ParameterDirection.Input
},
new SqlParameter {
Value = param.Page,
SqlDbType = SqlDbType.Int,
ParameterName = "@argIntPage",
Direction = ParameterDirection.Input
},
new SqlParameter {
Value = param.PageSize,
SqlDbType = SqlDbType.Int,
ParameterName = "@argIntPageSize",
Direction = ParameterDirection.Input
},
new SqlParameter {
Value = param.VideoNewsType,
SqlDbType = SqlDbType.TinyInt,
ParameterName = "@argIntType",
Direction = ParameterDirection.Input
}
}));
}
}
public static StringDictionary Detail(VideoNewsParameter param)
{
using (var db = new MsSql(DbName.Official))
{
return(db.First(
CommandType.Text,
"SELECT [VideoNewsId],[Sort], [Type],[ImgPath], [Link],[IsTop],[Title], [TextBody], [StartDate],[EndDate],[CreateTime],[UpdateTime],[Status]FROM [dbo].[VideoNews] WITH(READUNCOMMITTED)WHERE [VideoNewsId] = @VideoNewsId;",
new DbParameter[] {
new SqlParameter {
Value = param.VideoNews.VideoNewsId,
SqlDbType = SqlDbType.Int,
ParameterName = "@VideoNewsId",
Direction = ParameterDirection.Input
}
}));
}
}
public ActionResult AjaxVideoNewsDelete(VideoNewsParameter param)
{
var result = new JsonNetResult();
var r = new GeneralResponse();
try
{
var detail = VideoNewsTableProvider.Detail(param);
r.Code = VideoNewsTableProvider.Delete(param).ToString(Section.Get.Common.Culture);
if (!string.IsNullOrEmpty(detail["ImgPath"]))
{
Io.DeleteFile(System.Web.HttpContext.Current.Server.MapPath($"~{detail["ImgPath"]}"));
}
}
catch (Exception ex)
{
Log.Error(ex.Message, ex);
r.Code = "-11";
}
result.Data = r;
return(result);
}
//Update
public static int Update(VideoNewsParameter param)
{
using (var db = new MsSql(DbName.Official))
{
return(db.Write(
CommandType.Text,
" UPDATE [dbo].[VideoNews]SET [Sort] = @Sort,[Type] = @Type,[ImgPath] = @ImgPath,[Link] = @Link,[IsTop] = @IsTop,[Title] = @Title,[TextBody] = @TextBody,[StartDate] = @StartDate,[EndDate] = @EndDate,[UpdateTime] = GETUTCDATE(),[Status] = @Status WHERE [VideoNewsId] = @VideoNewsId;",
new DbParameter[] {
new SqlParameter {
Value = param.VideoNews.VideoNewsId,
SqlDbType = SqlDbType.Int,
ParameterName = "@VideoNewsId",
Direction = ParameterDirection.Input
},
new SqlParameter {
Value = param.VideoNews.Sort,
SqlDbType = SqlDbType.Int,
ParameterName = "@Sort",
Direction = ParameterDirection.Input
},
new SqlParameter {
Value = param.VideoNews.StartDate,
SqlDbType = SqlDbType.DateTime,
ParameterName = "@StartDate",
Direction = ParameterDirection.Input
},
new SqlParameter {
Value = param.VideoNews.EndDate,
SqlDbType = SqlDbType.DateTime,
ParameterName = "@EndDate",
Direction = ParameterDirection.Input
},
new SqlParameter {
Value = param.VideoNews.Status,
SqlDbType = SqlDbType.TinyInt,
ParameterName = "@Status",
Direction = ParameterDirection.Input
},
new SqlParameter {
Value = param.VideoNews.Type,
SqlDbType = SqlDbType.TinyInt,
ParameterName = "@Type",
Direction = ParameterDirection.Input
},
new SqlParameter {
Value = param.VideoNews.Link,
SqlDbType = SqlDbType.NVarChar,
Size = 256,
ParameterName = "@Link",
Direction = ParameterDirection.Input
},
new SqlParameter {
Value = param.VideoNews.ImgPath,
SqlDbType = SqlDbType.NVarChar,
Size = 512,
ParameterName = "@ImgPath",
Direction = ParameterDirection.Input
},
new SqlParameter {
Value = param.VideoNews.IsTop ? 1 : 0,
SqlDbType = SqlDbType.Bit,
ParameterName = "@IsTop",
Direction = ParameterDirection.Input
},
new SqlParameter {
Value = param.VideoNews.Title,
SqlDbType = SqlDbType.NVarChar,
Size = 128,
ParameterName = "@Title",
Direction = ParameterDirection.Input
},
new SqlParameter {
Value = param.VideoNews.TextBody,
SqlDbType = SqlDbType.NVarChar,
Size = -1,
ParameterName = "@TextBody",
Direction = ParameterDirection.Input
}
}));
}
}
public static int Create(VideoNewsParameter param)
{
using (var db = new MsSql(DbName.Official))
{
return(db.Write(
CommandType.Text,
"INSERT INTO [dbo].[VideoNews]([Sort],[Type],[Link],[ImgPath],[IsTop],[Title],[TextBody],[StartDate],[EndDate],[Status],[CreateTime],[UpdateTime])VALUES(@Sort,@Type,@Link,@ImgPath,@IsTop,@Title,@TextBody,@StartDate,@EndDate,@Status,GETUTCDATE(),GETUTCDATE());",
new DbParameter[] {
new SqlParameter {
Value = param.VideoNews.Sort,
SqlDbType = SqlDbType.Int,
ParameterName = "@Sort",
Direction = ParameterDirection.Input
},
new SqlParameter {
Value = param.VideoNews.StartDate,
SqlDbType = SqlDbType.DateTime,
ParameterName = "@StartDate",
Direction = ParameterDirection.Input
},
new SqlParameter {
Value = param.VideoNews.EndDate,
SqlDbType = SqlDbType.DateTime,
ParameterName = "@EndDate",
Direction = ParameterDirection.Input
},
new SqlParameter {
Value = param.VideoNews.Status,
SqlDbType = SqlDbType.TinyInt,
ParameterName = "@Status",
Direction = ParameterDirection.Input
},
new SqlParameter {
Value = param.VideoNews.Type,
SqlDbType = SqlDbType.TinyInt,
ParameterName = "@Type",
Direction = ParameterDirection.Input
},
new SqlParameter {
Value = param.VideoNews.Link,
SqlDbType = SqlDbType.NVarChar,
Size = 256,
ParameterName = "@Link",
Direction = ParameterDirection.Input
},
new SqlParameter {
Value = param.VideoNews.ImgPath,
SqlDbType = SqlDbType.NVarChar,
Size = 512,
ParameterName = "@ImgPath",
Direction = ParameterDirection.Input
},
new SqlParameter {
Value = param.VideoNews.IsTop ? 1 : 0,
SqlDbType = SqlDbType.Bit,
ParameterName = "@IsTop",
Direction = ParameterDirection.Input
},
new SqlParameter {
Value = param.VideoNews.Title,
SqlDbType = SqlDbType.NVarChar,
Size = 128,
ParameterName = "@Title",
Direction = ParameterDirection.Input
},
new SqlParameter {
Value = param.VideoNews.TextBody,
SqlDbType = SqlDbType.NVarChar,
Size = -1,
ParameterName = "@TextBody",
Direction = ParameterDirection.Input
}
}));
}
}
