public ActionResult AddAppShopBanner(int?PKID) { int _PKID = PKID.GetValueOrDefault(0); ShopsManager manager = new ShopsManager(); if (_PKID != 0) { ShopAppBanner _Model = manager.GetAppShopBannerByPKID(_PKID); if (string.IsNullOrWhiteSpace(_Model.Type)) { _Model.Type = "1"; } return(View(_Model)); } else { ShopAppBanner _Model = new ShopAppBanner() { PKID = 0, Type = "1" }; return(View(_Model)); } }
public static int UpdateShopBanner(SqlConnection connection, ShopAppBanner banner) { /* * string sql = @"UPDATE dbo.ShopAppBanner WITH(ROWLOCK) SET * Type=N'{0}', * Theme=N'{1}', * MainTitle=N'{2}', * Contents=N'{3}', * URL=N'{4}', * Action=N'{5}', * StartDate='{6}', * EndDate= '{7}', * BgColor=N'{8}', * ImgType=N'{9}', * ImgUrl1=N'{10}', * ImgUrl2=N'{11}', * ImgUrl3=N'{12}', * ImgUrl4=N'{13}', * Remark=N'{14}', * Operator=N'{15}', * PushType=N'{16}', * UpdateTime=GETDATE() * WHERE PKID={17} * "; * sql = string.Format(sql, banner.Type, banner.Theme, banner.MainTitle, banner.Contents, banner.URL, banner.Action, banner.StartDate.ToString("yyyy-MM-dd"), banner.EndDate.ToString("yyyy-MM-dd"), * banner.BgColor, banner.ImgType, banner.ImgUrl1, banner.ImgUrl2, banner.ImgUrl3, banner.ImgUrl4, banner.Remark, banner.Operator,banner.PushType, banner.PKID); */ string sql = @"UPDATE dbo.ShopAppBanner WITH(ROWLOCK) SET Type=@Type, Theme=@Theme, MainTitle=@MainTitle, Contents=@Contents, URL=@URL, Action=@Action, StartDate=@StartDate, EndDate= @EndDate, BgColor=@BgColor, ImgType=@ImgType, ImgUrl1=@ImgUrl1, ImgUrl2=@ImgUrl2, ImgUrl3=@ImgUrl3, ImgUrl4=@ImgUrl4, Remark=@Remark, Operator=@Operator, PushType=@PushType, UpdateTime=GETDATE() WHERE PKID=@PKID " ; var parameters = new[] { new SqlParameter("@Type", banner.Type), new SqlParameter("@Theme", banner.Theme), new SqlParameter("@MainTitle", banner.MainTitle), new SqlParameter("@Contents", banner.Contents), new SqlParameter("@URL", banner.URL), new SqlParameter("@Action", banner.Action), new SqlParameter("@StartDate", banner.StartDate.ToString("yyyy -MM-dd")), new SqlParameter("@EndDate", banner.EndDate.ToString("yyyy -MM-dd")), new SqlParameter("@BgColor", banner.BgColor), new SqlParameter("@ImgType", banner.ImgType), new SqlParameter("@ImgUrl1", banner.ImgUrl1), new SqlParameter("@ImgUrl2", banner.ImgUrl2), new SqlParameter("@ImgUrl3", banner.ImgUrl3), new SqlParameter("@ImgUrl4", banner.ImgUrl4), new SqlParameter("@Remark", banner.Remark), new SqlParameter("@Operator", banner.Operator), new SqlParameter("@PushType", banner.PushType), new SqlParameter("@PKID", banner.PKID) }; return(SqlHelper.ExecuteNonQuery(connection, CommandType.Text, sql, parameters)); }
public ActionResult EditShopBanner(int pkid, string type, string theme, string mainTitle, string contents, string url, string acction, string startDate , string endDate, string bgColor, string imgType, string imgUrl1, string imgUrl2, string imgUrl3, string imgUrl4, string remark, string pushType) { ShopsManager manager = new ShopsManager(); string _Result = string.Empty; ShopAppBanner banner = new ShopAppBanner(); banner.PKID = pkid; banner.Type = type; banner.Theme = theme; banner.MainTitle = mainTitle; banner.Contents = contents; banner.URL = url; banner.Action = acction; banner.StartDate = Convert.ToDateTime(startDate); banner.EndDate = Convert.ToDateTime(endDate); banner.BgColor = bgColor; banner.ImgType = imgType; banner.ImgUrl1 = imgUrl1; banner.ImgUrl2 = imgUrl2; banner.ImgUrl3 = imgUrl3; banner.ImgUrl4 = imgUrl4; banner.Remark = remark; banner.Operator = User.Identity.Name; banner.UpdateTime = DateTime.Now; banner.PushType = pushType; if (pkid == 0) { int i = manager.InsertShopBanner(banner); if (i > 0) { _Result = "新增成功!"; } else { _Result = "新增失败!"; } } else { int i = manager.UpdateShopBanner(banner); if (i > 0) { _Result = "修改成功!"; } else { _Result = "修改失败!"; } } return(Json(_Result, JsonRequestBehavior.AllowGet)); }
public int UpdateShopBanner(ShopAppBanner banner) { try { return(handler.UpdateShopBanner(banner)); } catch (Exception ex) { var exception = new ShopsException(0, "修改App首页图片配置失败!", ex); logger.Log(Level.Error, exception, "Error in UpdateShopBanner."); throw exception; } }
public int InsertShopBanner(ShopAppBanner banner) { return(dbManager.Execute(connection => DalShop.InsertShopBanner(connection, banner))); }
public int UpdateShopBanner(ShopAppBanner banner) { return(dbManager.Execute(connection => DalShop.UpdateShopBanner(connection, banner))); }
public static int InsertShopBanner(SqlConnection connection, ShopAppBanner banner) { /* * string sql = @"INSERT INTO dbo.ShopAppBanner * ( * Type , * Theme , * MainTitle , * Contents , * URL , * Action , * StartDate , * EndDate , * BgColor , * ImgType , * ImgUrl1 , * ImgUrl2 , * ImgUrl3 , * ImgUrl4 , * Remark , * Operator , * PushType, * UpdateTime * ) * VALUES ( * N'{0}', -- Type - nvarchar(50) * N'{1}', -- Theme - nvarchar(100) * N'{2}', -- MainTitle - nvarchar(100) * N'{3}', -- Contents - nvarchar(100) * N'{4}', -- URL - nvarchar(500) * N'{5}', -- Action - nvarchar(50) * '{6}', -- StartDate - datetime * '{7}', -- EndDate - datetime * N'{8}', -- BgColor - nvarchar(20) * N'{9}', -- ImgType - nvarchar(50) * N'{10}', -- ImgUrl1 - nvarchar(500) * N'{11}', -- ImgUrl2 - nvarchar(500) * N'{12}', -- ImgUrl3 - nvarchar(500) * N'{13}', -- ImgUrl4 - nvarchar(500) * N'{14}', -- Remark - nvarchar(max) * N'{15}', -- Operator - nvarchar(50) * N'{16}', -- PushType -nvchar(32) * GETDATE() -- UpdateTime - datetime * )"; */ string sql = @"INSERT INTO dbo.ShopAppBanner ( Type , Theme , MainTitle , Contents , URL , Action , StartDate , EndDate , BgColor , ImgType , ImgUrl1 , ImgUrl2 , ImgUrl3 , ImgUrl4 , Remark , Operator , PushType, UpdateTime ) VALUES( @Type , @Theme , @MainTitle , @Contents , @URL , @Action , @StartDate , @EndDate , @BgColor , @ImgType , @ImgUrl1 , @ImgUrl2 , @ImgUrl3 , @ImgUrl4 , @Remark , @Operator , @PushType, GETDATE() )"; // sql = string.Format(sql, banner.Type, banner.Theme, banner.MainTitle, banner.Contents, banner.URL, banner.Action, banner.StartDate.ToString("yyyy -MM-dd"), banner.EndDate.ToString("yyyy-MM-dd"), // banner.BgColor, banner.ImgType, banner.ImgUrl1, banner.ImgUrl2, banner.ImgUrl3, banner.ImgUrl4, banner.Remark, banner.Operator,banner.PushType); var parameters = new[] { new SqlParameter("@Type", banner.Type), new SqlParameter("@Theme", banner.Theme), new SqlParameter("@MainTitle", banner.MainTitle), new SqlParameter("@Contents", banner.Contents), new SqlParameter("@URL", banner.URL), new SqlParameter("@Action", banner.Action), new SqlParameter("@StartDate", banner.StartDate.ToString("yyyy -MM-dd")), new SqlParameter("@EndDate", banner.EndDate.ToString("yyyy -MM-dd")), new SqlParameter("@BgColor", banner.BgColor), new SqlParameter("@ImgType", banner.ImgType), new SqlParameter("@ImgUrl1", banner.ImgUrl1), new SqlParameter("@ImgUrl2", banner.ImgUrl2), new SqlParameter("@ImgUrl3", banner.ImgUrl3), new SqlParameter("@ImgUrl4", banner.ImgUrl4), new SqlParameter("@Remark", banner.Remark), new SqlParameter("@Operator", banner.Operator), new SqlParameter("@PushType", banner.PushType) }; return(SqlHelper.ExecuteNonQuery(connection, CommandType.Text, sql, parameters)); }