//增加到众筹
public ActionResult AddHuoDong(AddHuoDongInfoIn InModel)
{
string errorType = "";
string msg = "OK";
int huodongNumber = 1;
//先查这种商品在活动里存在的话他的活动期数就在原有的基础上加，否则从1开始
huodongNumber = BLL.HuoDongInfoBll.GetMaxHuoDongNumByGoodsID(Converter.TryToInt32(InModel.GoodsID)) + 1;
Model.HuoDongInfo huodongInfo = new Model.HuoDongInfo()
{
GoodsID = Converter.TryToInt64(InModel.GoodsID),
FinishedTime = Converter.TryToDateTime(InModel.FinishedTime),
ShareCount = Converter.TryToInt32(InModel.ShareCount),
State = 10,//开始众筹
HuodongNumber = huodongNumber,
CreateTime = DateTime.Now,
CreateUser = Identity.LoginUserInfo.UserID.ToString(),
};
bool result = BLL.HuoDongInfoBll.Add(huodongInfo);
if (result && huodongNumber > 1)
{
//前一期的活动隐藏 设置State=40
result = BLL.HuoDongInfoBll.UpdateState(Converter.TryToInt32(InModel.ID), (huodongNumber - 1));
}
if (!result)
{
errorType = "alert";
msg = "添加失败，请重试";
}
return(Json(new { Message = msg, ErrorType = errorType }, JsonRequestBehavior.AllowGet));
}
public static bool Update(Model.HuoDongInfo entity)
{
var sql = @"UPDATE HuodongInfo SET FinishedTime=GETDATE(),State=@State,LuckDogID=@LuckDogID,LuckNumber=@LuckNumber WHERE ID=@ID";
var parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter()
{
ParameterName = "@ID", Value = entity.ID
});
parameters.Add(new SqlParameter()
{
ParameterName = "@State", Value = entity.State
});
parameters.Add(new SqlParameter()
{
ParameterName = "@LuckDogID", Value = entity.LuckDogID
});
parameters.Add(new SqlParameter()
{
ParameterName = "@LuckNumber", Value = entity.LuckNumber
});
try
{
return(SqlHelper.ExecuteNonQuery(sql, parameters.ToArray()) > 0);
}
catch
{
return(false);
}
}
public static bool Update(Model.HuoDongInfo entity)
{
return(DAL.HuoDongInfoDal.Update(entity));
}
public static bool Add(Model.HuoDongInfo entity)
{
var sql = @"
INSERT INTO [HuoDongInfo]
(
GoodsID
,ShareCount
,State
,CreateTime
,CreateUser
,FinishedTime
,HuodongNumber
,LuckDogID
,LuckNumber
,IsDelete
)
VALUES
(
@GoodsID
,@ShareCount
,@State
,GETDATE()
,@CreateUser
,@FinishedTime
,@HuodongNumber
,@LuckDogID
,@LuckNumber
,0
)";
var parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter()
{
ParameterName = "@GoodsID", Value = entity.GoodsID
});
parameters.Add(new SqlParameter()
{
ParameterName = "@ShareCount", Value = entity.ShareCount
});
parameters.Add(new SqlParameter()
{
ParameterName = "@State", Value = entity.State
});
parameters.Add(new SqlParameter()
{
ParameterName = "@CreateUser", Value = entity.CreateUser
});
parameters.Add(new SqlParameter()
{
ParameterName = "@FinishedTime", Value = entity.FinishedTime
});
parameters.Add(new SqlParameter()
{
ParameterName = "@HuodongNumber", Value = entity.HuodongNumber
});
parameters.Add(new SqlParameter()
{
ParameterName = "@LuckDogID", Value = 0
});
parameters.Add(new SqlParameter()
{
ParameterName = "@LuckNumber", Value = 0
});
try
{
return(SqlHelper.ExecuteNonQuery(sql, parameters.ToArray()) > 0);
}
catch
{
return(false);
}
}
public static bool Add(Model.HuoDongInfo entity)
{
return(DAL.HuoDongInfoDal.Add(entity));
}
