/// <summary> /// 초기지급 에너지 설정 /// </summary> public void FirstSupply() { Items.Clear(); foreach (var data in Codes.Energy.Items) { Data energy = new Data(_user, data.Value.EnergyId); Items.Add(energy); } // Insert to DB using (var cmd = GameDB.NewCommand(_user.UserNo)) { Int32 idx = 0; cmd.CommandText.Append("insert into t_userinfo_energy values"); foreach (var energy in Items) { cmd.CommandText.AppendFormat("(@{0}, @{1}, @{2}, @{3}),", idx + 0, idx + 1, idx + 2, idx + 3); cmd.BindParameter(String.Format("@{0}", idx + 0), _user.UserNo); cmd.BindParameter(String.Format("@{0}", idx + 1), energy.EnergyId); cmd.BindParameter(String.Format("@{0}", idx + 2), energy.Point); cmd.BindParameter(String.Format("@{0}", idx + 3), energy.LastUpdateTime); idx += 4; } cmd.CommandText[cmd.CommandText.Length - 1] = ';'; cmd.PostQueryNoReader(); } }
public Data AddResource(Int32 resourceId, Int32 point) { Data resource = new Data(resourceId); resource.Point = point; Items.Add(resource); using (var cmd = GameDB.NewCommand(_user.UserNo)) { cmd.CommandText.Append("insert into t_userinfo_resource values(@0, @1, @2);"); cmd.BindParameter("@0", _user.UserNo); cmd.BindParameter("@1", resourceId); cmd.BindParameter("@2", point); cmd.PostQueryNoReader(); } return resource; }
/// <summary> /// 초기지급 리소스 설정 /// </summary> public void FirstSupply() { Items.Clear(); foreach (var data in GameData.FirstSupply.ResourceData.Items) { Data resource = new Data(data.ResourceId); resource.Point = data.Point; Items.Add(resource); } // Insert to DB using (var cmd = GameDB.NewCommand(_user.UserNo)) { Int32 idx = 0; cmd.CommandText.Append("insert into t_userinfo_resource values"); foreach (var energy in Items) { cmd.CommandText.AppendFormat("(@{0}, @{1}, @{2}),", idx + 0, idx + 1, idx + 2); cmd.BindParameter(String.Format("@{0}", idx + 0), _user.UserNo); cmd.BindParameter(String.Format("@{0}", idx + 1), energy.ResourceId); cmd.BindParameter(String.Format("@{0}", idx + 2), energy.Point); idx += 3; } cmd.CommandText[cmd.CommandText.Length - 1] = ';'; cmd.PostQueryNoReader(); } }