public bool UpdateBonusMaster(BonusMasterQuery store)
{
store.Replace4MySQL();
StringBuilder sql = new StringBuilder();
try
{
sql.AppendFormat("update bonus_master set `user_id`='{0}',`type_id`='{1}',`master_total`='{2}',`master_balance`='{3}',`master_note`='{4}' ", store.user_id, store.type_id, store.master_total, store.master_balance, store.master_note);
sql.AppendFormat(" ,`master_writer`='{0}',`master_start`='{1}',`master_end`='{2}',`master_updatedate`='{3}',`master_ipfrom`='{4}',`bonus_type`='{5}')", store.master_writer, store.master_start, store.master_end, store.master_updatedate, store.master_ipfrom, store.bonus_type);
if (_access.execCommand(sql.ToString()) > 0)
{
return true;
}
else
{
return false;
}
}
catch (Exception ex)
{
throw new Exception("BonusMasterDao-->UpdateBonusMaster-->" + sql.ToString() + ex.Message, ex);
}
}
public int updateuser_master(BonusMasterQuery store)
{
StringBuilder sb = new StringBuilder();
try
{
store.Replace4MySQL();
strSql = string.Format(@"update bonus_master set master_total='{0}',master_balance='{1}', master_start='{2}',master_end='{3}',master_note='{4}' where user_id='{5}' and master_id='{6}'", store.master_total, store.master_balance, store.master_start, store.master_end, store.master_note, store.user_id, store.master_id);
sb.Append(strSql.ToString());
return _access.execCommand(strSql.ToString());
}
catch (Exception ex)
{
throw new Exception("UsersListDao-->updateuser_master-->" + ex.Message + sb.ToString(), ex);
}
}
