public static int Save(SE_BrandFlagship model)
{
if (model.ID == 0)
{
return(DALSE_BrandFlagship.Add(model));
}
else
{
return(DALSE_BrandFlagship.Update(model));
}
}
public ActionResult Edit(string id = "")
{
if (string.IsNullOrWhiteSpace(id))
{
return(View(new SE_BrandFlagship()));
}
else
{
SE_BrandFlagship model = SE_BrandFlagshipManager.GetEntity(id);
return(View(model));
}
}
public static SE_BrandFlagship GetEntity(string id)
{
SE_BrandFlagship model = DALSE_BrandFlagship.GetBrandFlagship(id).ConvertTo <SE_BrandFlagship>().FirstOrDefault();
if (model == null)
{
return(null);
}
else
{
IEnumerable <SE_BrandFlagshipDetail> information = DALSE_BrandFlagship.GetBrandFlagshipDeatil(id, 0).ConvertTo <SE_BrandFlagshipDetail>();
IEnumerable <SE_BrandFlagshipDetail> testing = DALSE_BrandFlagship.GetBrandFlagshipDeatil(id, 1).ConvertTo <SE_BrandFlagshipDetail>();
model.Information = information;
model.Testing = testing;
return(model);
}
}
public ActionResult Save(string content)
{
SE_BrandFlagship model = JsonConvert.DeserializeObject <SE_BrandFlagship>(content);
return(Json(SE_BrandFlagshipManager.Save(model)));
}
public static int Add(SE_BrandFlagship model)
{
int result = 0;
var db = DbHelper.CreateDefaultDbHelper();
db.BeginTransaction();
try
{
string sql = @"INSERT INTO Configuration.dbo.SE_BrandFlagshipConfig
( Name ,
ImageUrl ,
ActivityHome ,
Description ,
ArticleID ,
ArticleTitle ,
DecorativePattern,
LogoUrl,Brand,CreateDT,UpdateDT,ShareParameter
)
VALUES ( @Name , -- Name - nvarchar(200)
@ImageUrl , -- ImageUrl - nvarchar(500)
@ActivityHome , -- ActivityHome - nvarchar(200)
@Description , -- Description - text
@ArticleID , -- ArticleID - int
@ArticleTitle , -- ArticleTitle - nvarchar(200)
@DecorativePattern, -- DecorativePattern - nvarchar(100)
@LogoUrl,@Brand,GETDATE(),GETDATE(),@ShareParameter
) SELECT @RowID=@@IDENTITY";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = sql;
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@Name", model.Name);
cmd.Parameters.AddWithValue("@ImageUrl", model.ImageUrl);
cmd.Parameters.AddWithValue("@ActivityHome", model.ActivityHome);
cmd.Parameters.AddWithValue("@Description", model.Description);
cmd.Parameters.AddWithValue("@ArticleID", model.ArticleID);
cmd.Parameters.AddWithValue("@ArticleTitle", model.ArticleTitle);
cmd.Parameters.AddWithValue("@DecorativePattern", model.DecorativePattern);
cmd.Parameters.AddWithValue("@LogoUrl", model.LogoUrl);
cmd.Parameters.AddWithValue("@Brand", model.Brand);
cmd.Parameters.AddWithValue("@ShareParameter", model.ShareParameter);
cmd.Parameters.Add(new SqlParameter()
{
ParameterName = "@RowID",
Direction = ParameterDirection.Output,
SqlDbType = SqlDbType.Int
});
db.ExecuteNonQuery(cmd);
model.ID = Convert.ToInt32(cmd.Parameters["@RowID"].Value);
string sqlDeatil = @"INSERT INTO Configuration.dbo.SE_BrandFlagshipDetailConfig
( FK_BrandFlagship ,
ArticleID ,
ArticleTitle ,
ArticleType,
[Description],
OrderBy
)
VALUES ( @FK_BrandFlagship , -- FK_BrandFlagship - int
@ArticleID , -- ArticleID - int
@ArticleTitle , -- ArticleTitle - nvarchar(200)
@ArticleType, -- ArticleType - int
@Description,
@OrderBy
)";
foreach (var item in model.Information)
{
SqlCommand cmdItem = new SqlCommand();
cmdItem.CommandText = sqlDeatil;
cmdItem.CommandType = CommandType.Text;
cmdItem.Parameters.AddWithValue("@FK_BrandFlagship", model.ID);
cmdItem.Parameters.AddWithValue("@ArticleID", item.ArticleID);
cmdItem.Parameters.AddWithValue("@ArticleTitle", item.ArticleTitle);
cmdItem.Parameters.AddWithValue("@ArticleType", item.ArticleType);
cmdItem.Parameters.AddWithValue("@Description", item.Description);
cmdItem.Parameters.AddWithValue("@OrderBy", item.OrderBy);
db.ExecuteNonQuery(cmdItem);
}
foreach (var item in model.Testing)
{
SqlCommand cmdItem = new SqlCommand();
cmdItem.CommandText = sqlDeatil;
cmdItem.CommandType = CommandType.Text;
cmdItem.Parameters.AddWithValue("@FK_BrandFlagship", model.ID);
cmdItem.Parameters.AddWithValue("@ArticleID", item.ArticleID);
cmdItem.Parameters.AddWithValue("@ArticleTitle", item.ArticleTitle);
cmdItem.Parameters.AddWithValue("@ArticleType", item.ArticleType);
cmdItem.Parameters.AddWithValue("@Description", item.Description);
cmdItem.Parameters.AddWithValue("@OrderBy", item.OrderBy);
db.ExecuteNonQuery(cmdItem);
}
db.Commit();
result = 1;
}
catch (Exception e)
{
db.Rollback();
}
finally
{
db.Dispose();
}
return(result);
}
public static int Update(SE_BrandFlagship model)
{
int result = 0;
var db = DbHelper.CreateDefaultDbHelper();
try
{
db.BeginTransaction();
StringBuilder strSql = new StringBuilder();
strSql.Append("update Configuration.dbo.SE_BrandFlagshipConfig set ");
strSql.Append("Name=@Name,");
strSql.Append("ImageUrl=@ImageUrl,");
strSql.Append("ActivityHome=@ActivityHome,");
strSql.Append("[Description]=@Description,");
strSql.Append("ArticleID=@ArticleID,");
strSql.Append("ArticleTitle=@ArticleTitle,");
strSql.Append("DecorativePattern=@DecorativePattern,");
strSql.Append("LogoUrl=@LogoUrl,");
strSql.Append("Brand=@Brand,UpdateDT=GETDATE(),ShareParameter=@ShareParameter");
strSql.Append(" where ID=@ID");
SqlCommand cmd = new SqlCommand(strSql.ToString());
cmd.Parameters.AddWithValue("@Name", model.Name);
cmd.Parameters.AddWithValue("@ImageUrl", model.ImageUrl);
cmd.Parameters.AddWithValue("@ActivityHome", model.ActivityHome);
cmd.Parameters.AddWithValue("@Description", model.Description);
cmd.Parameters.AddWithValue("@ArticleID", model.ArticleID);
cmd.Parameters.AddWithValue("@ArticleTitle", model.ArticleTitle);
cmd.Parameters.AddWithValue("@DecorativePattern", model.DecorativePattern);
cmd.Parameters.AddWithValue("@LogoUrl", model.LogoUrl);
cmd.Parameters.AddWithValue("@Brand", model.Brand);
cmd.Parameters.AddWithValue("@ShareParameter", model.ShareParameter);
cmd.Parameters.AddWithValue("@ID", model.ID);
db.ExecuteNonQuery(cmd);
string delStr = @"DELETE FROM Configuration.dbo.SE_BrandFlagshipDetailConfig WHERE FK_BrandFlagship=@FK_BrandFlagship";
cmd = new SqlCommand(delStr);
cmd.Parameters.AddWithValue("@FK_BrandFlagship", model.ID);
db.ExecuteNonQuery(cmd);
string sqlDeatil = @"INSERT INTO Configuration.dbo.SE_BrandFlagshipDetailConfig
( FK_BrandFlagship ,
ArticleID ,
ArticleTitle ,
ArticleType,
[Description],
OrderBy
)
VALUES ( @FK_BrandFlagship , -- FK_BrandFlagship - int
@ArticleID , -- ArticleID - int
@ArticleTitle , -- ArticleTitle - nvarchar(200)
@ArticleType, -- ArticleType - int
@Description,
@OrderBy
)";
foreach (var item in model.Information)
{
SqlCommand cmdItem = new SqlCommand();
cmdItem.CommandText = sqlDeatil;
cmdItem.CommandType = CommandType.Text;
cmdItem.Parameters.AddWithValue("@FK_BrandFlagship", model.ID);
cmdItem.Parameters.AddWithValue("@ArticleID", item.ArticleID);
cmdItem.Parameters.AddWithValue("@ArticleTitle", item.ArticleTitle);
cmdItem.Parameters.AddWithValue("@ArticleType", item.ArticleType);
cmdItem.Parameters.AddWithValue("@Description", item.Description);
cmdItem.Parameters.AddWithValue("@OrderBy", item.OrderBy);
db.ExecuteNonQuery(cmdItem);
}
foreach (var item in model.Testing)
{
SqlCommand cmdItem = new SqlCommand();
cmdItem.CommandText = sqlDeatil;
cmdItem.CommandType = CommandType.Text;
cmdItem.Parameters.AddWithValue("@FK_BrandFlagship", model.ID);
cmdItem.Parameters.AddWithValue("@ArticleID", item.ArticleID);
cmdItem.Parameters.AddWithValue("@ArticleTitle", item.ArticleTitle);
cmdItem.Parameters.AddWithValue("@ArticleType", item.ArticleType);
cmdItem.Parameters.AddWithValue("@Description", item.Description);
cmdItem.Parameters.AddWithValue("@OrderBy", item.OrderBy);
db.ExecuteNonQuery(cmdItem);
}
db.Commit();
result = 1;
}
catch (Exception e)
{
db.Rollback();
}
finally
{
db.Dispose();
}
return(result);
}
