public ActionResult Save(SE_FlagshipStoreConfig model)
{
JObject json = new JObject();
FlagshipStoreConfigManager manager = new FlagshipStoreConfigManager();
if (model.PKID == 0)
{
if (manager.Add(model))
{
return(Json(1));
}
else
{
return(Json(0));
}
}
else
{
if (manager.Update(model) == true)
{
return(Json(1));
}
else
{
return(Json(0));
}
}
}
public bool Update(SE_FlagshipStoreConfig model)
{
if (model == null || model.PKID == 0)
{
return(false);
}
return(dal.Update(model));
}
public bool Add(SE_FlagshipStoreConfig model)
{
if (model == null)
{
return(false);
}
return(dal.Add(model));
}
public bool Update(SE_FlagshipStoreConfig model)
{
StringBuilder sql = new StringBuilder("UPDATE Configuration.DBO.SE_FlagshipStoreConfig SET Brand=@Brand,Name=@Name,Describe=@Describe,Uri=@Uri,ImageUrl=@ImageUrl,Remark=@Remark,UpdateDT=GETDATE() Where PKID=@PKID ");
using (SqlCommand cmd = new SqlCommand(sql.ToString()))
{
cmd.Parameters.AddWithValue("@Brand", model.Brand);
cmd.Parameters.AddWithValue("@Name", model.Name);
cmd.Parameters.AddWithValue("@Describe", model.Describe);
cmd.Parameters.AddWithValue("@Uri", model.Uri);
cmd.Parameters.AddWithValue("@ImageUrl", model.ImageUrl.Trim());
cmd.Parameters.AddWithValue("@Remark", model.Remark);
cmd.Parameters.AddWithValue("@PKID", model.PKID);
int n = db.ExecuteNonQuery(cmd);
return(n > 0);
}
}
public ActionResult Edit(SE_FlagshipStoreConfig model = null)
{
FlagshipStoreConfigManager manager = new FlagshipStoreConfigManager();
ViewBag.BrandList = manager.GetBrand();
if (model.Name == null)
{
return(View(new SE_FlagshipStoreConfig()
{
ImageUrl = string.Empty
}));
}
else
{
return(View(model));
}
}
public bool Add(SE_FlagshipStoreConfig model)
{
StringBuilder sql = new StringBuilder("INSERT INTO configuration.dbo.SE_FlagshipStoreConfig(Brand,Name,Describe,Uri,ImageUrl,Remark,CreateDT,UpdateDT)");
sql.Append(" VALUES(@Brand,@Name,@Describe,@Uri,@ImageUrl,@Remark,GETDATE(),GETDATE()) ");
try
{
using (SqlCommand cmd = new SqlCommand(sql.ToString()))
{
cmd.Parameters.AddWithValue("@Brand", model.Brand);
cmd.Parameters.AddWithValue("@Name", model.Name);
cmd.Parameters.AddWithValue("@Describe", model.Describe);
cmd.Parameters.AddWithValue("@Uri", model.Uri);
cmd.Parameters.AddWithValue("@ImageUrl", model.ImageUrl.Trim());
cmd.Parameters.AddWithValue("@Remark", model.Remark);
return(db.ExecuteNonQuery(cmd) > 0);
}
}
catch (Exception e)
{
return(false);
}
}
