public ActionResult AjaxIndexBannerDeleteFile(IndexBannerParameter param) { var result = new JsonNetResult(); Io.DeleteFile(HttpContext.Server.MapPath($"~{param.Entity.ImgPath}")); result.Data = new { Ststus = "OK" }; return(result); }
/// <summary> /// 首頁 Banner 清單頁 /// </summary> /// <param name="param"></param> /// <returns></returns> public ActionResult IndexBanners(IndexBannerParameter param) { param.KeyWord = HttpUtility.UrlDecode(param.KeyWord); return(View( new InternalDataTransferToView { List = IndexBannerTableProvider.List(param), Data = param })); }
public ActionResult IndexBannerEdit(IndexBannerParameter param) { if (0L < param.Entity.IndexBannerId) { param.Entity = IndexBannerTableProvider.Detail(param); } return(View(new InternalDataTransferToView { Data = param })); }
public static int Delete(IndexBannerParameter param) { using (var db = new MsSql(DbName.Official)) { return(db.Write( CommandType.Text, " DELETE FROM [dbo].[IndexBanner] WHERE [IndexBannerId] = @IndexBannerId;", new DbParameter[] { new SqlParameter { Value = param.Entity.IndexBannerId, SqlDbType = SqlDbType.Int, ParameterName = "@IndexBannerId", Direction = ParameterDirection.Input } })); } }
public ActionResult AjaxIndexBannerEdit(IndexBannerParameter param) { var result = new JsonNetResult(); var r = new GeneralResponse(); try { r.Code = (0L < param.Entity.IndexBannerId ? IndexBannerTableProvider.Update(param) : IndexBannerTableProvider.Create(param)).ToString(Section.Get.Common.Culture); } catch (Exception ex) { Log.Error(ex.Message, ex); r.Code = "-11" + ex.Message; } result.Data = r; return(result); }
public static IndexBanner Detail(IndexBannerParameter param) { using (var db = new MsSql(DbName.Official)) { var data = new IndexBanner(); data.Fill( db.First( CommandType.Text, "SELECT [IndexBannerId],[ImgPath],[FirstString],[FirstStringColor],[SecondString],[SecondStringColor],[ThreeString],[ThreeStringColor],[Align],[Link],[CreateTime] FROM [dbo].[IndexBanner] WITH(READUNCOMMITTED) WHERE [IndexBannerId] = @IndexBannerId;", new DbParameter[] { new SqlParameter { Value = param.Entity.IndexBannerId, SqlDbType = SqlDbType.Int, ParameterName = "@IndexBannerId", Direction = ParameterDirection.Input } })); return(data); } }
public ActionResult AjaxIndexBannerDelete(IndexBannerParameter param) { var result = new JsonNetResult(); var r = new GeneralResponse(); try { var detail = IndexBannerTableProvider.Detail(param); r.Code = IndexBannerTableProvider.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); }
public static DataSet List(IndexBannerParameter param) { using (var db = new MsSql(DbName.Official)) { return(db.DataSet( CommandType.StoredProcedure, "[dbo].[sp_FetchIndexBannerList_Sel]", new DbParameter[] { new SqlParameter { Value = param.KeyWord, SqlDbType = SqlDbType.NVarChar, ParameterName = "@argStrKeyWord", Direction = ParameterDirection.Input }, new SqlParameter { Value = string.IsNullOrEmpty(param.StartUtcDateTime) ? null : param.StartUtcDateTime, SqlDbType = SqlDbType.DateTime, ParameterName = "@argDteStart", Direction = ParameterDirection.Input }, new SqlParameter { Value = string.IsNullOrEmpty(param.EndUtcDateTime) ? null : 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 } })); } }
public static int Update(IndexBannerParameter param) { using (var db = new MsSql(DbName.Official)) { return(db.Write( CommandType.Text, "UPDATE [dbo].[IndexBanner] SET [ImgPath] = @ImgPath,[Link] = @Link, [Align]=@Align,[FirstString] = @FirstString,[FirstStringColor] = @FirstStringColor,[SecondString] = @SecondString,[SecondStringColor] = @SecondStringColor,[ThreeString] = @ThreeString,[ThreeStringColor] = @ThreeStringColor WHERE [IndexBannerId] = @IndexBannerId;", new DbParameter[] { new SqlParameter { Value = param.Entity.IndexBannerId, SqlDbType = SqlDbType.Int, ParameterName = "@IndexBannerId", Direction = ParameterDirection.Input }, new SqlParameter { Value = param.Entity.FirstString, SqlDbType = SqlDbType.NVarChar, ParameterName = "@FirstString", Direction = ParameterDirection.Input }, new SqlParameter { Value = param.Entity.FirstStringColor, SqlDbType = SqlDbType.NVarChar, ParameterName = "@FirstStringColor", Direction = ParameterDirection.Input }, new SqlParameter { Value = param.Entity.SecondString, SqlDbType = SqlDbType.NVarChar, ParameterName = "@SecondString", Direction = ParameterDirection.Input }, new SqlParameter { Value = param.Entity.SecondStringColor, SqlDbType = SqlDbType.NVarChar, ParameterName = "@SecondStringColor", Direction = ParameterDirection.Input }, new SqlParameter { Value = param.Entity.ThreeString, SqlDbType = SqlDbType.NVarChar, ParameterName = "@ThreeString", Direction = ParameterDirection.Input }, new SqlParameter { Value = param.Entity.ThreeStringColor, SqlDbType = SqlDbType.NVarChar, ParameterName = "@ThreeStringColor", Direction = ParameterDirection.Input }, new SqlParameter { Value = param.Entity.Align, SqlDbType = SqlDbType.VarChar, ParameterName = "@Align", Direction = ParameterDirection.Input }, new SqlParameter { Value = param.Entity.Link, SqlDbType = SqlDbType.NVarChar, ParameterName = "@Link", Direction = ParameterDirection.Input }, new SqlParameter { Value = param.Entity.ImgPath, SqlDbType = SqlDbType.NVarChar, ParameterName = "@ImgPath", Direction = ParameterDirection.Input } })); } }
public static int Create(IndexBannerParameter param) { using (var db = new MsSql(DbName.Official)) { return(db.Write( CommandType.Text, "INSERT INTO [dbo].[IndexBanner]([ImgPath],[FirstString],[FirstStringColor],[SecondString],[SecondStringColor],[ThreeString],[ThreeStringColor],[Align],[Link],[CreateTime])VALUES(@ImgPath,@FirstString,@FirstStringColor,@SecondString,@SecondStringColor,@ThreeString,@ThreeStringColor,@Align,@Link,GETUTCDATE());", new DbParameter[] { new SqlParameter { Value = param.Entity.FirstString, SqlDbType = SqlDbType.NVarChar, ParameterName = "@FirstString", Direction = ParameterDirection.Input }, new SqlParameter { Value = param.Entity.FirstStringColor, SqlDbType = SqlDbType.NVarChar, ParameterName = "@FirstStringColor", Direction = ParameterDirection.Input }, new SqlParameter { Value = param.Entity.SecondString, SqlDbType = SqlDbType.NVarChar, ParameterName = "@SecondString", Direction = ParameterDirection.Input }, new SqlParameter { Value = param.Entity.SecondStringColor, SqlDbType = SqlDbType.NVarChar, ParameterName = "@SecondStringColor", Direction = ParameterDirection.Input }, new SqlParameter { Value = param.Entity.ThreeString, SqlDbType = SqlDbType.NVarChar, ParameterName = "@ThreeString", Direction = ParameterDirection.Input }, new SqlParameter { Value = param.Entity.ThreeStringColor, SqlDbType = SqlDbType.NVarChar, ParameterName = "@ThreeStringColor", Direction = ParameterDirection.Input }, new SqlParameter { Value = param.Entity.Align, SqlDbType = SqlDbType.VarChar, ParameterName = "@Align", Direction = ParameterDirection.Input }, new SqlParameter { Value = param.Entity.Link, SqlDbType = SqlDbType.NVarChar, ParameterName = "@Link", Direction = ParameterDirection.Input }, new SqlParameter { Value = param.Entity.ImgPath, SqlDbType = SqlDbType.NVarChar, ParameterName = "@ImgPath", Direction = ParameterDirection.Input } })); } }