public string AddOrUpdate(EventPromoAdditionalPrice model)
{
model.Replace4MySQL();
StringBuilder sql = new StringBuilder();
try
{
if (model.row_id == 0)
{
sql.Append(@"insert into event_promo_additional_price(event_name,event_desc,event_start,event_end,event_type,event_id,site_id,create_user,create_time,modify_user,modify_time,user_condition_id,condition_type,quantity,amount,num_limit,group_id,device,event_status)");
sql.AppendFormat(" values('{0}','{1}','{2}','{3}','{4}','{5}'", model.event_name, model.event_desc, Common.CommonFunction.DateTimeToString(model.event_start), Common.CommonFunction.DateTimeToString(model.event_end), model.event_type, model.event_id);
sql.AppendFormat(",'{0}','{1}','{2}','{3}','{4}','{5}','{6}',{7},{8},{9},{10}", model.site_id, model.create_user, Common.CommonFunction.DateTimeToString(model.create_time), model.modify_user, Common.CommonFunction.DateTimeToString(model.modify_time), model.user_condition_id, model.condition_type, model.quantity, model.amount, model.num_limit, model.group_id);
sql.AppendFormat(",'{0}','{1}');select @@identity;", model.device, model.event_status);
}
else
{
sql.AppendFormat("update event_promo_additional_price set event_name='{0}',event_desc='{1}',event_start='{2}',event_end='{3}',event_type='{4}',", model.event_name, model.event_desc, Common.CommonFunction.DateTimeToString(model.event_start), Common.CommonFunction.DateTimeToString(model.event_end), model.event_type);
sql.AppendFormat(" site_id='{0}',modify_user='******',modify_time='{2}',user_condition_id='{3}',condition_type='{4}',", model.site_id, model.modify_user, Common.CommonFunction.DateTimeToString(model.modify_time), model.user_condition_id, model.condition_type);
sql.AppendFormat(" device='{0}',event_status='{1}',quantity={2},amount={3},num_limit={4},group_id={5},event_id='{6}' where row_id='{7}';", model.device, model.event_status, model.quantity, model.amount, model.num_limit, model.group_id,model.event_id, model.row_id);
}
return sql.ToString();
}
catch (Exception ex)
{
throw new Exception("EventPromoAdditionalPriceDao-->AddOrUpdate-->" + ex.Message, ex);
}
}
public List<EventPromoAdditionalPriceQuery> GetList(EventPromoAdditionalPrice model, out int count)
{
count = 0;
model.Replace4MySQL();
StringBuilder sbStrAll = new StringBuilder();
StringBuilder sbStrJoin = new StringBuilder();
StringBuilder sbStrPage = new StringBuilder();
StringBuilder sbWhr = new StringBuilder();
try
{
sbStrAll.Append("SELECT ep.row_id,ep.modify_user,ep.event_id,ep.group_id,ep.event_name,ep.event_start,ep.event_end,mu.user_username,ep.event_desc,ep.site_id,ep.condition_type,ep.device,ep.user_condition_id,ep.quantity,ep.amount,ep.num_limit,ep.event_status ");
sbStrJoin.Append(" FROM event_promo_additional_price AS ep LEFT JOIN manage_user mu ON ep.modify_user=mu.user_id where 1=1 ");
if (!string.IsNullOrEmpty(model.event_id))
{
model.event_id = model.event_id.Replace(",", "\',\'");
sbWhr.AppendFormat(" and ep.event_id in ('{0}') ", model.event_id);
}
if (!string.IsNullOrEmpty(model.event_name))
{
sbWhr.AppendFormat(" and ep.event_name like N'%{0}%'", model.event_name);
}
if (model.IsPage)
{
count = int.Parse(access.getDataTable("select count(ep.event_id)" + sbStrJoin.ToString() + sbWhr.ToString()).Rows[0][0].ToString());
sbWhr.AppendFormat(" limit {0},{1}", model.Start, model.Limit);
}
return access.getDataTableForObj<EventPromoAdditionalPriceQuery>(sbStrAll.ToString() + sbStrJoin.ToString() + sbWhr.ToString());
}
catch (Exception ex)
{
throw new Exception("EventPromoAdditionalPriceDao-->GetList-->" + ex.Message + sbStrAll.ToString() + sbStrJoin.ToString(), ex);
}
}
public string UpdateActive(EventPromoAdditionalPrice model)
{
StringBuilder sql = new StringBuilder();
try
{
model.Replace4MySQL();
sql.AppendFormat("set sql_safe_updates = 0;update event_promo_additional_price set event_status ='{0}', modify_user='******',modify_time='{2}' where event_id = '{3}';set sql_safe_updates = 1;", model.event_status, model.modify_user, Common.CommonFunction.DateTimeToString(model.modify_time), model.event_id);
return sql.ToString();
}
catch (Exception ex)
{
throw new Exception("EventPromoAdditionalPriceDao-->UpdateActive-->" + ex.Message + sql.ToString(), ex);
}
}