public bool Submit(SE_EveryDaySeckill model, IPrincipal user)
{
DalSE_EveryDaySeckill dal = new DalSE_EveryDaySeckill();
if (model.ActivityGuid == null)
{
model.ActivityGuid = Guid.NewGuid();
model.EveryDaySeckillInfo.FK_EveryDaySeckill = model.ActivityGuid;
model.CreateDate = DateTime.Now;
model.UpdateDate = DateTime.Now;
model.EveryDaySeckillInfo.UpdateDate = DateTime.Now;
model.EveryDaySeckillInfo.CreateDate = DateTime.Now;
if (dal.Exits(model.StartDate, model.EndDate))
{
return(false);
}
LoggerManager.InsertOplog(new ConfigHistory()
{
BeforeValue = "",
ChangeDatetime = DateTime.Now,
AfterValue = JsonConvert.SerializeObject(model),
Author = user.Identity.Name,
ObjectType = "EDSKill",
Operation = "新增天天秒杀" + model.ActivityName
});
return(dal.Add(model));
}
else
{
model.UpdateDate = DateTime.Now;
model.EveryDaySeckillInfo.CreateDate = DateTime.Now;
LoggerManager.InsertOplog(new ConfigHistory()
{
ChangeDatetime = DateTime.Now,
BeforeValue = JsonConvert.SerializeObject(GetEntity(model.ActivityGuid.Value)),
AfterValue = JsonConvert.SerializeObject(model),
// ObjectID= model.ID.Value.ToString(),
Author = user.Identity.Name,
ObjectType = "EDSKill",
Operation = "修改天天秒杀" + model.ActivityName
});
return(dal.Update(model));
}
}
public bool Update(SE_EveryDaySeckill model)
{
bool result = false;
string sql = @"UPDATE Configuration.dbo.SE_EveryDaySeckill SET ActivityName=@ActivityName,StartDate=@StartDate,EndDate=@EndDate ,UpdateDate=@UpdateDate where ActivityGuid=@ActivityGuid ";
var db = DbHelper.CreateDefaultDbHelper();
try
{
db.BeginTransaction();
SqlCommand cmd = new SqlCommand(sql);
cmd.Parameters.AddWithValue("@ActivityGuid", model.ActivityGuid);
cmd.Parameters.AddWithValue("@ActivityName", model.ActivityName);
cmd.Parameters.AddWithValue("@StartDate", model.StartDate);
cmd.Parameters.AddWithValue("@EndDate", model.EndDate);
cmd.Parameters.AddWithValue("@UpdateDate", DateTime.Now);
db.ExecuteNonQuery(cmd);
sql = @"UPDATE Configuration.dbo.SE_EveryDaySeckillInfo SET SpecialUrl=@SpecialUrl, SpecialPicture=@SpecialPicture ,SpecialStyle=@SpecialStyle ,ActivityContent=@ActivityContent,FlashActivityGuid=@FlashActivityGuid , UpdateDate=@UpdateDate where FK_EveryDaySeckill=@FK_EveryDaySeckill";
cmd = new SqlCommand(sql);
cmd.Parameters.AddWithValue("@SpecialUrl", model.EveryDaySeckillInfo.SpecialUrl);
cmd.Parameters.AddWithValue("@SpecialPicture", model.EveryDaySeckillInfo.SpecialPicture);
cmd.Parameters.AddWithValue("@SpecialStyle", model.EveryDaySeckillInfo.SpecialStyle);
cmd.Parameters.AddWithValue("@ActivityContent", model.EveryDaySeckillInfo.ActivityContent);
// cmd.Parameters.AddWithValue("@ActivityCoupon", model.EveryDaySeckillInfo.ActivityCoupon);
cmd.Parameters.AddWithValue("@FlashActivityGuid", model.EveryDaySeckillInfo.FlashActivityGuid);
cmd.Parameters.AddWithValue("@UpdateDate", DateTime.Now);
cmd.Parameters.AddWithValue("@FK_EveryDaySeckill", model.ActivityGuid);
db.ExecuteNonQuery(cmd);
db.Commit();
result = true;
}
catch (Exception em)
{
db.Rollback();
result = false;
}
finally
{
db.Dispose();
}
return(result);
}
public ActionResult Submit(string everyDaySeckill, string items)
{
if (string.IsNullOrWhiteSpace(everyDaySeckill))
{
return(Json(0));
}
SE_EveryDaySeckill model = JsonConvert.DeserializeObject <SE_EveryDaySeckill>(everyDaySeckill);
SE_EveryDaySeckillInfo info = JsonConvert.DeserializeObject <SE_EveryDaySeckillInfo>(items);
model.EveryDaySeckillInfo = info;
EveryDaySeckillHandler handler = new EveryDaySeckillHandler();
if (handler.Submit(model, User))
{
return(Json(1));
}
else
{
return(Json(0));
}
}
public SE_EveryDaySeckill GetEntity(Guid?activityGuid)
{
if (activityGuid.HasValue)
{
DalSE_EveryDaySeckill dal = new DalSE_EveryDaySeckill();
DataTable dt = dal.GetEntity(activityGuid.Value);
if (dt == null || dt.Rows.Count <= 0)
{
return(null);
}
SE_EveryDaySeckill model = dt.ConvertTo <SE_EveryDaySeckill>().FirstOrDefault();
DataTable infoDataTable = dal.GetEntityDataTable(activityGuid.Value);
if (infoDataTable == null || infoDataTable.Rows.Count <= 0)
{
return(null);
}
model.EveryDaySeckillInfo = infoDataTable.ConvertTo <SE_EveryDaySeckillInfo>().FirstOrDefault();
return(model);
}
return(null);
}
public bool Add(SE_EveryDaySeckill model)
{
bool result = false;
string sql = @"INSERT INTO Configuration.dbo.SE_EveryDaySeckill
( ActivityGuid ,
ActivityName ,
StartDate ,
EndDate ,
CreateDate ,
UpdateDate
)
VALUES ( @ActivityGuid , -- ActivityGuid - uniqueidentifier
@ActivityName , -- ActivityName - nvarchar(50)
@StartDate , -- StartDate - datetime
@EndDate , -- EndDate - datetime
@CreateDate , -- CreateDate - datetime
@UpdateDate -- UpdateDate - datetime
) ";
var db = DbHelper.CreateDefaultDbHelper();
db.BeginTransaction();
try
{
SqlCommand cmd = new SqlCommand(sql);
cmd.Parameters.AddWithValue("@ActivityGuid", model.ActivityGuid);
cmd.Parameters.AddWithValue("@ActivityName", model.ActivityName);
cmd.Parameters.AddWithValue("@StartDate", model.StartDate);
cmd.Parameters.AddWithValue("@EndDate", model.EndDate);
cmd.Parameters.AddWithValue("@CreateDate", DateTime.Now);
cmd.Parameters.AddWithValue("@UpdateDate", DateTime.Now);
db.ExecuteNonQuery(cmd);
sql = @"INSERT INTO Configuration.dbo.SE_EveryDaySeckillInfo
( FK_EveryDaySeckill ,
SpecialUrl ,
SpecialPicture ,
SpecialStyle ,
ActivityContent ,
FlashActivityGuid ,
CreateDate ,
UpdateDate
)
VALUES ( @FK_EveryDaySeckill , -- FK_EveryDaySeckill - uniqueidentifier
@SpecialUrl , -- SpecialUrl - nvarchar(200)
@SpecialPicture , -- SepecialPicture - nvarchar(max)
@SpecialStyle , -- SepecialStyle - int
@ActivityContent , -- ActivityContent - nvarchar(max)
@FlashActivityGuid , -- FlashActivityGuid - uniqueidentifier
@CreateDate , -- CreateDate - datetime
@UpdateDate -- UpdateDate - datetime
)";
cmd = new SqlCommand(sql);
cmd.Parameters.AddWithValue("@FK_EveryDaySeckill", model.ActivityGuid);
cmd.Parameters.AddWithValue("@SpecialUrl", model.EveryDaySeckillInfo.SpecialUrl);
cmd.Parameters.AddWithValue("@SpecialPicture", model.EveryDaySeckillInfo.SpecialPicture);
cmd.Parameters.AddWithValue("@SpecialStyle", model.EveryDaySeckillInfo.SpecialStyle);
cmd.Parameters.AddWithValue("@ActivityContent", model.EveryDaySeckillInfo.ActivityContent);
//cmd.Parameters.AddWithValue("@ActivityCoupon", model.EveryDaySeckillInfo.ActivityCoupon);
cmd.Parameters.AddWithValue("@FlashActivityGuid", model.EveryDaySeckillInfo.FlashActivityGuid);
cmd.Parameters.AddWithValue("@CreateDate", DateTime.Now);
cmd.Parameters.AddWithValue("@UpdateDate", DateTime.Now);
db.ExecuteNonQuery(cmd);
db.Commit();
result = true;
}
catch (Exception em)
{
db.Rollback();
}
finally
{
db.Dispose();
}
return(result);
}
