/// <summary>
/// 更新Active的時候進行更新的數據
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public string UpdatePromoAmountDisActive(PromotionsAmountDiscountCustom model)
{
model.Replace4MySQL();
StringBuilder sql = new StringBuilder();
try
{
sql.AppendFormat("update promotions_amount_discount set active={0},modified='{1}',muser='******'", model.active, CommonFunction.DateTimeToString(model.modified), model.muser);
sql.AppendFormat(" where id={0};", model.id);
return sql.ToString();
}
catch (Exception ex)
{
throw new Exception("PromotionsAmountDiscountDao-->UpdatePromoAmountDisActive-->" + ex.Message + sql.ToString(), ex);
}
}
public int Save(PromotionsAmountDiscountCustom query)
{
StringBuilder sql = new StringBuilder();
query.Replace4MySQL();
try
{
if (query.id == 0)//新增
{
sql.AppendFormat("insert into promotions_amount_discount (");
sql.AppendFormat("name,group_id,class_id,brand_id,category_id,product_id,type,amount,quantity,discount,vendor_coverage,start,end,");
sql.AppendFormat("event_desc,event_type,condition_id,device,payment_code,kuser,created,muser,modified,site,active,status,url_by) values ");
sql.AppendFormat("('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}','{18}','{19}','{20}','{21}','{22}',{23},'{24}','{25}');", query.name, query.group_id, query.class_id, query.brand_id, query.category_id, query.product_id, query.type, query.amount, query.quantity, query.discount, query.vendor_coverage, CommonFunction.DateTimeToString(query.start), CommonFunction.DateTimeToString(query.end), query.event_desc, query.event_type, query.condition_id, query.device, query.payment_code, query.kuser, CommonFunction.DateTimeToString(query.created), query.muser, CommonFunction.DateTimeToString(query.modified), query.site, query.active, query.status, query.url_by);
}
else//編輯
{
sql.AppendFormat("update promotions_amount_discount set name='{0}',group_id='{1}', discount='{2}',start='{3}',end='{4}',modified='{5}', muser='******' ,amount='{7}',quantity='{8}',site='{9}' where id='{10}';", query.name, query.group_id, query.discount, CommonFunction.DateTimeToString(query.start), CommonFunction.DateTimeToString(query.end), CommonFunction.DateTimeToString(query.modified), query.muser, query.amount,query.quantity,query.site,query.id);
}
return _access.execCommand(sql.ToString());
}
catch (Exception ex)
{
throw new Exception("PromotionAmountDiscountsDao-->Save-->+" + sql.ToString() + ex.Message, ex);
}
}
/// <summary>
/// 更新PromoAmountDis數據
/// </summary>
/// <param name="model">參數模型</param>
/// <returns>返回sql語句</returns>
public string UpdatePromoAmountDis(PromotionsAmountDiscountCustom model)
{
model.Replace4MySQL();
StringBuilder sql = new StringBuilder();
try
{
sql.AppendFormat("update promotions_amount_discount set ");
sql.AppendFormat("name='{0}',group_id={1},class_id={2},brand_id={3},category_id={4}", model.name, model.group_id, model.class_id, model.brand_id, model.category_id);
sql.AppendFormat(",product_id={0},type={1},amount={2},quantity={3},discount={4},vendor_coverage={5}", model.product_id, model.type, model.amount, model.quantity, model.discount, model.vendor_coverage);
sql.AppendFormat(",start='{0}',end='{1}',modified='{2}',active={3}", CommonFunction.DateTimeToString(model.start), CommonFunction.DateTimeToString(model.end), CommonFunction.DateTimeToString(model.modified), model.active);
sql.AppendFormat(",event_desc='{0}',event_type='{1}',condition_id={2},device={3},payment_code={4}", model.event_desc, model.event_type, model.condition_id, model.device, model.payment_code);
sql.AppendFormat(",muser='******',site='{1}',status='{2}',url_by='{3}'", model.muser, model.site, model.status, model.url_by);
sql.AppendFormat(" where id={0};", model.id);
return sql.ToString();
}
catch (Exception ex)
{
throw new Exception("PromotionsAmountDiscountDao-->UpdatePromoAmountDis-->" + ex.Message + sql.ToString(), ex);
}
}
