public bool Update(JobCouponConfigModel model)
{
try
{
return(handler.Update(model));
}
catch (Exception ex)
{
logger.Log(Level.Error, ex.ToString());
return(false);
}
}
public static bool Insert(SqlConnection sqlconn, JobCouponConfigModel model)
{
string sql = @"
INSERT INTO Configuration..SE_JobCouponConfig
( ActivityName ,
RuleID ,
CouponNum ,
CouponName ,
CouponExplain ,
ValidityTime ,
ProductType ,
OrderState,
OrderMoney,
ReturnType ,
State ,
CouponRules ,
CreateTime
)
VALUES ( @ActivityName,
@RuleID,
@CouponNum,
@CouponName,
@CouponExplain,
@ValidityTime,
@ProductType ,
@OrderState,
@OrderMoney,
@ReturnType,
@State,
@CouponRules,
@CreateTime
)";
var sqlParas = new SqlParameter[] {
new SqlParameter("@ActivityName", model.ActivityName),
new SqlParameter("@RuleID", model.RuleID),
new SqlParameter("@CouponNum", model.CouponNum),
new SqlParameter("@CouponName", model.CouponName),
new SqlParameter("@CouponExplain", model.CouponExplain),
new SqlParameter("@ValidityTime", model.ValidityTime),
new SqlParameter("@ProductType", model.ProductType),
new SqlParameter("@OrderState", model.OrderState),
new SqlParameter("@OrderMoney", model.OrderMoney),
new SqlParameter("@ReturnType", model.ReturnType),
new SqlParameter("@State", model.State),
new SqlParameter("@CouponRules", model.CouponRules),
new SqlParameter("@CreateTime", model.CreateTime)
};
return(SqlHelper.ExecuteNonQuery(sqlconn, CommandType.Text, sql, sqlParas) > 0);
}
public ActionResult Save(int id, JobCouponConfigModel model)
{
bool result = false;
if (id == 0)
{
//新增
model.CreateTime = DateTime.Now;
result = _JobCouponConfigManager.Insert(model);
}
else
{
//修改
result = _JobCouponConfigManager.Update(model);
}
return(RedirectToAction("Index"));
}
public static bool Update(SqlConnection sqlconn, JobCouponConfigModel model)
{
string sql = @"
UPDATE Configuration..[SE_JobCouponConfig]
SET [ActivityName] = @ActivityName
,[RuleID] = @RuleID
,[CouponNum] = @CouponNum
,[CouponName] = @CouponName
,[CouponExplain] = @CouponExplain
,[ValidityTime] = @ValidityTime
,[ProductType] = @ProductType
,[OrderState] = @OrderState
,[OrderMoney] = @OrderMoney
,[ReturnType] = @ReturnType
,[State] = @State
,[CouponRules] = @CouponRules
,[CreateTime] = @CreateTime
WHERE ID = @ID ";
var sqlParas = new SqlParameter[] {
new SqlParameter("@ActivityName", model.ActivityName),
new SqlParameter("@RuleID", model.RuleID),
new SqlParameter("@CouponNum", model.CouponNum),
new SqlParameter("@CouponName", model.CouponName),
new SqlParameter("@CouponExplain", model.CouponExplain),
new SqlParameter("@ValidityTime", model.ValidityTime),
new SqlParameter("@ProductType", model.ProductType),
new SqlParameter("@OrderState", model.OrderState),
new SqlParameter("@OrderMoney", model.OrderMoney),
new SqlParameter("@ReturnType", model.ReturnType),
new SqlParameter("@State", model.State),
new SqlParameter("@CouponRules", model.CouponRules),
new SqlParameter("@CreateTime", model.CreateTime),
new SqlParameter("@ID", model.ID)
};
return(SqlHelper.ExecuteNonQuery(sqlconn, CommandType.Text, sql, sqlParas) > 0);
}
public ActionResult AddOrEdit(int id)
{
if (id != 0)
{
//修改
JobCouponConfigModel model = _JobCouponConfigManager.SelectById(id) ?? new JobCouponConfigModel()
{
ID = -1
};
return(View(model));
}
else
{
//新增
JobCouponConfigModel model = new JobCouponConfigModel()
{
ID = 0,
State = true,
ReturnType = 1,
CreateTime = DateTime.Now
};
return(View(model));
}
}
public bool Update(JobCouponConfigModel model)
{
Func <SqlConnection, bool> action = (connection) => JobCouponConfigDAL.Update(connection, model);
return(dbManager.Execute(action));
}
