public ActionResult AjaxAnnouncementEdit(AnnouncementParameter param)
{
var result = new JsonNetResult();
var r = new GeneralResponse();
try {
if (param.Forever)
{
param.Announcement.EndDate = new System.DateTime(9999, 12, 31, 23, 59, 59);
}
param.Announcement.StartDate = TimeZoneInfo.ConvertTimeToUtc(param.Announcement.StartDate,
Section.Get.Common.TimeZone);
param.Announcement.EndDate = TimeZoneInfo.ConvertTimeToUtc(param.Announcement.EndDate,
Section.Get.Common.TimeZone);
r.Code = (0L < param.Announcement.AnnouncementId
? AnnouncementTableProvider.Update(param)
: AnnouncementTableProvider.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 AjaxAnnouncementDeleteFile(AnnouncementParameter param)
{
var result = new JsonNetResult();
Io.DeleteFile(HttpContext.Server.MapPath($"~{param.Announcement.ImgPath}"));
result.Data = new { Ststus = "OK" };
return(result);
}
/// <summary>
///
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public ActionResult Announcements(AnnouncementParameter param)
{
param.KeyWord = HttpUtility.UrlDecode(param.KeyWord);
return(View(
new InternalDataTransferToView {
List = AnnouncementTableProvider.List(param),
Data = param
}));
}
public ActionResult AnnouncementEdit(AnnouncementParameter param)
{
if (0L < param.Announcement.AnnouncementId)
{
param.Announcement.Fill(AnnouncementTableProvider.Detail(param));
}
return(View(new InternalDataTransferToView {
Data = param
}));
}
public static int Delete(AnnouncementParameter param)
{
using (var db = new MsSql(DbName.Official)) {
return(db.Write(CommandType.Text, " DELETE FROM [dbo].[Announcement] WHERE AnnouncementId = @AnnouncementId;", new DbParameter[] {
new SqlParameter {
Value = param.Announcement.AnnouncementId,
SqlDbType = SqlDbType.Int,
ParameterName = "@AnnouncementId",
Direction = ParameterDirection.Input
}
}));
}
}
public static StringDictionary Detail(AnnouncementParameter param)
{
using (var db = new MsSql(DbName.Official)) {
return(db.First(
CommandType.Text,
"SELECT [AnnouncementId],[Sort], [Type],[ImgPath], [Link],[IsTop],[Title], [TextBody], [StartDate],[EndDate],[CreateTime],[UpdateTime],[Status]FROM [dbo].[Announcement] WITH(READUNCOMMITTED)WHERE [AnnouncementId] = @AnnouncementId;",
new DbParameter[] {
new SqlParameter {
Value = param.Announcement.AnnouncementId,
SqlDbType = SqlDbType.Int,
ParameterName = "@AnnouncementId",
Direction = ParameterDirection.Input
}
}));
}
}
public static DataSet List(AnnouncementParameter param)
{
using (var db = new MsSql(DbName.Official)) {
return(db.DataSet(
CommandType.StoredProcedure,
"[dbo].[sp_AnnouncementList_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.AnnouncementType,
SqlDbType = SqlDbType.TinyInt,
ParameterName = "@argIntType",
Direction = ParameterDirection.Input
}
}));
}
}
public ActionResult AjaxAnnouncementDelete(AnnouncementParameter param)
{
var result = new JsonNetResult();
var r = new GeneralResponse();
try {
var detail = AnnouncementTableProvider.Detail(param);
r.Code = AnnouncementTableProvider.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(AnnouncementParameter param)
{
using (var db = new MsSql(DbName.Official)) {
return(db.Write(
CommandType.Text,
" UPDATE [dbo].[Announcement]SET [Sort] = @Sort,[Type] = @Type,[ImgPath] = @ImgPath,[Link] = @Link,[IsTop] = @IsTop,[Title] = @Title,[TextBody] = @TextBody,[StartDate] = @StartDate,[EndDate] = @EndDate,[UpdateTime] = GETUTCDATE(),[Status] = @Status WHERE [AnnouncementId] = @AnnouncementId;",
new DbParameter[] {
new SqlParameter {
Value = param.Announcement.AnnouncementId,
SqlDbType = SqlDbType.Int,
ParameterName = "@AnnouncementId",
Direction = ParameterDirection.Input
},
new SqlParameter {
Value = param.Announcement.Sort,
SqlDbType = SqlDbType.Int,
ParameterName = "@Sort",
Direction = ParameterDirection.Input
},
new SqlParameter {
Value = param.Announcement.StartDate,
SqlDbType = SqlDbType.DateTime,
ParameterName = "@StartDate",
Direction = ParameterDirection.Input
},
new SqlParameter {
Value = param.Announcement.EndDate,
SqlDbType = SqlDbType.DateTime,
ParameterName = "@EndDate",
Direction = ParameterDirection.Input
},
new SqlParameter {
Value = param.Announcement.Status,
SqlDbType = SqlDbType.TinyInt,
ParameterName = "@Status",
Direction = ParameterDirection.Input
},
new SqlParameter {
Value = param.Announcement.Type,
SqlDbType = SqlDbType.TinyInt,
ParameterName = "@Type",
Direction = ParameterDirection.Input
},
new SqlParameter {
Value = param.Announcement.Link,
SqlDbType = SqlDbType.NVarChar,
Size = 256,
ParameterName = "@Link",
Direction = ParameterDirection.Input
},
new SqlParameter {
Value = param.Announcement.ImgPath,
SqlDbType = SqlDbType.NVarChar,
Size = 512,
ParameterName = "@ImgPath",
Direction = ParameterDirection.Input
},
new SqlParameter {
Value = param.Announcement.IsTop ? 1 : 0,
SqlDbType = SqlDbType.Bit,
ParameterName = "@IsTop",
Direction = ParameterDirection.Input
},
new SqlParameter {
Value = param.Announcement.Title,
SqlDbType = SqlDbType.NVarChar,
Size = 128,
ParameterName = "@Title",
Direction = ParameterDirection.Input
},
new SqlParameter {
Value = param.Announcement.TextBody,
SqlDbType = SqlDbType.NVarChar,
Size = -1,
ParameterName = "@TextBody",
Direction = ParameterDirection.Input
}
}));
}
}
public static int Create(AnnouncementParameter param)
{
using (var db = new MsSql(DbName.Official)) {
return(db.Write(
CommandType.Text,
"INSERT INTO [dbo].[Announcement]([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.Announcement.Sort,
SqlDbType = SqlDbType.Int,
ParameterName = "@Sort",
Direction = ParameterDirection.Input
},
new SqlParameter {
Value = param.Announcement.StartDate,
SqlDbType = SqlDbType.DateTime,
ParameterName = "@StartDate",
Direction = ParameterDirection.Input
},
new SqlParameter {
Value = param.Announcement.EndDate,
SqlDbType = SqlDbType.DateTime,
ParameterName = "@EndDate",
Direction = ParameterDirection.Input
},
new SqlParameter {
Value = param.Announcement.Status,
SqlDbType = SqlDbType.TinyInt,
ParameterName = "@Status",
Direction = ParameterDirection.Input
},
new SqlParameter {
Value = param.Announcement.Type,
SqlDbType = SqlDbType.TinyInt,
ParameterName = "@Type",
Direction = ParameterDirection.Input
},
new SqlParameter {
Value = param.Announcement.Link,
SqlDbType = SqlDbType.NVarChar,
Size = 256,
ParameterName = "@Link",
Direction = ParameterDirection.Input
},
new SqlParameter {
Value = param.Announcement.ImgPath,
SqlDbType = SqlDbType.NVarChar,
Size = 512,
ParameterName = "@ImgPath",
Direction = ParameterDirection.Input
},
new SqlParameter {
Value = param.Announcement.IsTop ? 1 : 0,
SqlDbType = SqlDbType.Bit,
ParameterName = "@IsTop",
Direction = ParameterDirection.Input
},
new SqlParameter {
Value = param.Announcement.Title,
SqlDbType = SqlDbType.NVarChar,
Size = 128,
ParameterName = "@Title",
Direction = ParameterDirection.Input
},
new SqlParameter {
Value = param.Announcement.TextBody,
SqlDbType = SqlDbType.NVarChar,
Size = -1,
ParameterName = "@TextBody",
Direction = ParameterDirection.Input
}
}));
}
}
