//插入信息 public int EdmGroupNewInsert(EdmGroupNewQuery query) { StringBuilder sql = new StringBuilder(); query.Replace4MySQL(); try { sql.Append("insert into edm_group_new (group_name, is_member_edm,trial_url, sort_order,description,group_createdate,group_create_userid,group_update_userid)values "); sql.AppendFormat("('{0}','{1}','{2}','{3}','{4}',NOW(),'{5}','{6}')", query.group_name, query.is_member_edm,query.trial_url, query.sort_order, query.description,query.group_create_userid,query.group_update_userid); return _access.execCommand(sql.ToString()); } catch (Exception ex) { throw new Exception("EdmGroupNewDao-->EdmGroupNewInsert-->" + sql.ToString() + ex.Message); } }
//更新信息 public int EdmGroupNewUpdate(EdmGroupNewQuery query) { StringBuilder sql = new StringBuilder(); query.Replace4MySQL(); try { sql.AppendFormat("update edm_group_new set group_name = '{0}', is_member_edm = '{1}', trial_url='{2}',sort_order = '{3}',description='{4}',group_update_userid='{5}' where group_id='{6}' ", query.group_name, query.is_member_edm, query.trial_url, query.sort_order, query.description,query.group_update_userid, query.group_id); return _access.execCommand(sql.ToString()); } catch (Exception ex) { throw new Exception("EdmGroupNewDao-->EdmGroupNewUpdate-->" + sql.ToString() + ex.Message); } }