public void SaveKuaFuLueDuoBHData(KuaFuLueDuoBHData data) { string sql = string.Format("INSERT INTO t_kfld_banghui(`season`, `bhid`, `bhname`, `zoneid`, `sum_ziyuan`, `last`) VALUES({0},{1},'{2}',{3},{4},{5}) ON DUPLICATE KEY UPDATE `season`='{0}',`bhname`='{2}',`zoneid`={3},`sum_ziyuan`='{4}',`last`={5}", new object[] { data.season, data.bhid, data.bhname, data.zoneid, data.sum_ziyuan, data.last_ziyuan }); this.ExecuteSqlNoQuery(sql); }
public void SaveKuaFuLueDuoBHSeasonData(int season, KuaFuLueDuoBHData data) { string sql = string.Format("INSERT INTO t_kfld_banghui_season(`season`, `bhid`, `bhname`, `zoneid`, `jingjia`, `jingjia_sid`, `last_jingjia`,`group`) VALUES({0},{1},'{2}',{3},{4},{5},{6},{7}) ON DUPLICATE KEY UPDATE `bhname`='{2}',`zoneid`={3},`jingjia`='{4}',`jingjia_sid`={5},`last_jingjia`={6}", new object[] { data.season, data.bhid, data.bhname, data.zoneid, data.jingjia, data.jingjia_sid, data.last_jingjia, data.group }); this.ExecuteSqlNoQuery(sql); }