public void InsertRebornRoleData(KFRebornRoleData roleData) { string sql = string.Format("INSERT INTO t_reborn_roles(ptid, rid, rname, lev, rarity, rarity_last, boss, boss_last, liansha, liansha_last, boss_award) VALUES({0},{1},'{2}',{3},{4},{5},{6},{7},{8},{9},'{10}');", new object[] { roleData.PtID, roleData.RoleID, roleData.RoleName, roleData.Lev, roleData.Rarity, roleData.RarityLast, roleData.Boss, roleData.BossLast, roleData.LianSha, roleData.LianShaLast, roleData.FormatBossAwardString(roleData.BossAwardList) }); this.AddDelayWriteSql(sql); }
public void UpdateRebornRoleDataBossAward(KFRebornRoleData roleData) { string sql = string.Format("UPDATE t_reborn_roles SET boss_award='{2}' WHERE ptid={0} AND rid={1};", roleData.PtID, roleData.RoleID, roleData.FormatBossAwardString(roleData.BossAwardList)); this.AddDelayWriteSql(sql); }