public static SE_Activity GetEntity(string id)
{
SE_Activity model = null;
var db = DbHelper.CreateDefaultDbHelper();
try
{
string sql = "SELECT * FROM Configuration.dbo.SE_ActivityConfig WITH(NOLOCK) WHERE ID=@ID";
SqlCommand cmd = new SqlCommand(sql);
cmd.Parameters.AddWithValue("@ID", id.ToString());
model = db.ExecuteDataTable(cmd).ConvertTo <SE_Activity>().FirstOrDefault();
if (model == null)
{
return(null);
}
sql = "SELECT * FROM Configuration.dbo.SE_ActivityDeatilConfig WITH(NOLOCK) WHERE FK_Activity=@FK_Activity";
cmd = new SqlCommand(sql);
cmd.Parameters.AddWithValue("@FK_Activity", id.ToString());
model.Items = db.ExecuteDataTable(cmd).ConvertTo <SE_ActivityDeatil>();
}
catch (Exception e)
{
}
finally
{
db.Dispose();
}
return(model);
}
public static bool Add(SE_Activity model)
{
bool result = false;
string sql = @"INSERT INTO Configuration.dbo.SE_ActivityConfig
( ID ,
Title ,
CreateDT ,
UpdateDT ,
BgImageUrl ,
BgColor
)
VALUES ( @ID , -- ID - uniqueidentifier
@Title , -- Title - nvarchar(50)
GETDATE() , -- CreateDT - datetime
GETDATE() , -- UpdateDT - datetime
@BgImageUrl , -- BgImageUrl - nvarchar(500)
@BgColor -- BgColor - nvarchar(50)
)";
var db = DbHelper.CreateDefaultDbHelper();
Guid ID = Guid.NewGuid();
model.ID = ID;
try
{
db.BeginTransaction();
SqlCommand cmd = new SqlCommand(sql);
cmd.Parameters.AddWithValue("@ID", ID.ToString());
cmd.Parameters.AddWithValue("@Title", model.Title);
cmd.Parameters.AddWithValue("@BgImageUrl", model.BgImageUrl);
cmd.Parameters.AddWithValue("@BgColor", model.BgColor);
db.ExecuteNonQuery(cmd);
foreach (var item in model.Items)
{
item.FK_Activity = ID;
AddDeatil(db, item);
}
db.Commit();
result = true;
}
catch (Exception e)
{
db.Rollback();
}
finally
{
db.Dispose();
}
return(result);
}
public ActionResult ActivityEdit(string id = "")
{
SE_Activity model = new SE_Activity();
if (!string.IsNullOrWhiteSpace(id))
{
model = SE_ActivityManager.GetEntity(id);
}
else
{
// model.Content = "{total:0,rows:[]}";
}
return(View(model));
}
public static int Save(SE_Activity model)
{
int result = 0;
if (model.ID.ToString() == "00000000-0000-0000-0000-000000000000")
{
if (DALSE_Activity.Add(model))
{
result = 1;
}
}
else
{
if (DALSE_Activity.Update(model))
{
result = 1;
}
}
return(result);
}
public ActionResult Save(string data)
{
if (!string.IsNullOrWhiteSpace(data))
{
SE_Activity model = JsonConvert.DeserializeObject <SE_Activity>(data);
SE_Activity preModel = null;
if (model.ID.ToString() != "00000000-0000-0000-0000-000000000000")
{
preModel = SE_ActivityManager.GetEntity(model.ID.ToString());
}
if (SE_ActivityManager.Save(model) == 1)
{
JObject json = JObject.Parse(data);
JToken token = null;
if (!json.TryGetValue("ID", out token))
{
LoggerManager.InsertOplog(new ConfigHistory()
{
AfterValue = JsonConvert.SerializeObject(model), Author = User.Identity.Name, Operation = "新增活动:" + model.Title, ObjectType = "SPACF"
});
}
else
{
LoggerManager.InsertOplog(new ConfigHistory()
{
BeforeValue = JsonConvert.SerializeObject(preModel), AfterValue = JsonConvert.SerializeObject(model), Author = User.Identity.Name, Operation = "修改活动:" + model.Title, ObjectType = "SPACF"
});
}
return(Json(1));
}
else
{
return(Json(0));
}
}
else
{
return(Json(0));
}
}
public static bool Update(SE_Activity model)
{
bool result = false;
string sql = @"UPDATE Configuration.dbo.SE_ActivityConfig SET Title=@Title,UpdateDT=GETDATE(),BgImageUrl=@BgImageUrl, BgColor=@BgColor WHERE ID=@ID";
var db = DbHelper.CreateDefaultDbHelper();
try
{
db.BeginTransaction();
SqlCommand cmd = new SqlCommand(sql);
cmd.Parameters.AddWithValue("@ID", model.ID.ToString());
cmd.Parameters.AddWithValue("@Title", model.Title);
cmd.Parameters.AddWithValue("@BgImageUrl", model.BgImageUrl);
cmd.Parameters.AddWithValue("@BgColor", model.BgColor);
db.ExecuteNonQuery(cmd);
DeteleDeatil(db, model.ID.ToString());
foreach (var item in model.Items)
{
item.FK_Activity = model.ID;
AddDeatil(db, item);
}
db.Commit();
result = true;
}
catch (Exception e)
{
db.Rollback();
result = false;
}
finally
{
db.Dispose();
}
return(result);
}
