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