コード例 #1
0
        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);
        }
コード例 #2
0
        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);
        }