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