public bool UpdateBaoYangPackageImageConfigNew(BaoYangPackageImageConfig model)
{
try
{
return(DalBaoYangPackageImageConfig.UpdateBaoYangPackageImageConfigNew(model));
}
catch (Exception ex)
{
_Logger.Error("UpdateBaoYangPackageImageConfigNew", ex);
return(false);
}
}
public ActionResult Edit(BaoYangPackageImageConfig model)
{
string js = "<script>alert(\"保存失败 \");location='/BaoYangPackageImageConfig/Index';</script>";
if (BaoYangPackageImageConfigManager.UpdateBaoYangPackageImageConfigNew(model))
{
return(RedirectToAction("Index"));
}
else
{
return(Content(js));
}
}
public static bool UpdateBaoYangPackageImageConfigNew(BaoYangPackageImageConfig model)
{
const string sql = @"IF EXISTS ( SELECT 1
FROM Configuration..SE_BaoYangPackageImageConfig WITH ( NOLOCK )
WHERE PID = @PID )
BEGIN
UPDATE [Configuration].[dbo].[SE_BaoYangPackageImageConfig]
SET [Image] = @Image ,
[Image2] = @Image2 ,
[CreateTime] = GETDATE()
WHERE PID = @PID;
END;
ELSE
BEGIN
INSERT INTO [Configuration].[dbo].[SE_BaoYangPackageImageConfig]
( [PID] ,
[Image] ,
[Image2] ,
[CreateTime]
)
VALUES ( @PID ,
@Image ,
@Image2 ,
GETDATE()
);
END;";
var sqlParameters = new SqlParameter[]
{
new SqlParameter("@PID", model.PID),
new SqlParameter("@Image", model.Image),
new SqlParameter("@Image2", model.Image2),
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlParameters) > 0);
}
