private void button1_Click(object sender, EventArgs e)
{
try
{
if (textBox1.Text.Trim() != "")
{
data_count = Convert.ToInt32(textBox1.Text.Trim());
Task.Run(() =>
{
string sqlstr = $@"
begin tran
begin try
update [BlGame01].dbo.[GroceryProperty] set [count] = '{data_count}' where [pcid] = '{pcid}' and [id] = '{id}'
end try
begin catch
if(@@trancount>0)
rollback tran
end catch
if(@@trancount>0)
commit tran";
if (db.IsConnection)
{
count = db._SQL_IDU(sqlstr);
ReturnValue = count;
ReturnValue1 = data_count;
this.Invoke(new Action(delegate
{
this.DialogResult = DialogResult.OK;
this.Close();
}));
}
});
}
else
{
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show($"修改数量时发生错误 \r\n角色PCID:{pcid}\r\n物品ID:{id}\r\n物品Count{data_count}\r\n错误信息:{ex.Message}", "无法执行", MessageBoxButtons.OK, MessageBoxIcon.Warning);
this.Close();
}
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text.Trim() != "")
{
try
{
List <string> sql = new List <string>();
string item_id = string.Empty;
foreach (var item in dat)
{
item_id += $"'{item.id}'";
if (item != dat[dat.Count - 1])
{
item_id += $",";
}
}
if (typ == "ChangedPCID")
{
sql.Add($"update [BlGame01].dbo.[GemProperty] set [pcid] = '{textBox1.Text.Trim()}' where [pcid]='{pcid}' and [id] in ({item_id}); -- 八卦");
sql.Add($"update [BlGame01].dbo.[AccessoryProperty] set [pcid] = '{textBox1.Text.Trim()}' where [pcid]='{pcid}' and [id] in ({item_id}); -- 首饰/衣服");
sql.Add($"update[BlGame01].dbo.[GroceryProperty] set[pcid] = '{textBox1.Text.Trim()}' where[pcid] = '{pcid}' and [id] in ({item_id}); --材料 / 消耗品");
sql.Add($"update[BlGame01].dbo.[WeaponProperty] set[pcid] = '{textBox1.Text.Trim()}' where[pcid] = '{pcid}' and [id] in ({item_id}); --武器");
sql.Add($"update[BlGame01].dbo.[CostumeProperty] set[pcid] = '{textBox1.Text.Trim()}' where[pcid] = '{pcid}' and [id] in ({item_id}); --衣服");
sql.Add($"update[BlGame01].dbo.[Closet] set[pcid] = '{textBox1.Text.Trim()}' where[pcid] = '{pcid}' and [ItemInstanceID] in ({item_id}); --衣柜");
Task.Run(() =>
{
if (db.IsConnection)
{
foreach (var item in sql)
{
count += db._SQL_IDU(item);
Thread.Sleep(100);
}
ReturnValue = count;
this.Invoke(new Action(delegate
{
this.DialogResult = DialogResult.OK;
this.Close();
}));
}
});
}
else if (typ == "NewPCID")
{
string Pc = textBox1.Text.Trim();
Task.Run(() =>
{
sql.Add($"insert into [BlGame01].dbo.[GemProperty] select [pawn],[converted_lock_expiration_time],([id]+(select cast( floor(rand()*10000000) as int))+{textBox1.Text.Trim()}) as 'id','{textBox1.Text.Trim()}' as 'PCID',[depot],[pos],[data_id],[level],[exp],[used],[sequestration],[locked],[lock_expiration_time],[equip_gem_piece_id],[ability_type_main],[ability_value_main],[ability_type_sub1],[ability_value_sub1],[ability_type_sub2],[ability_value_sub2] from [BlGame01].dbo.[GemProperty] where [pcid]='{pcid}' and [id] in ({item_id}); -- 八卦");
sql.Add($"insert into [BlGame01].dbo.[AccessoryProperty] select [pawn],[converted_lock_expiration_time],[converted_time_limit_expiration_time],([id]+(select cast( floor(rand()*10000000) as int))+{textBox1.Text.Trim()}) as 'id','{textBox1.Text.Trim()}' as 'PCID',[depot],[pos],[data_id],[level],[exp],[used],[sequestration],[locked],[lock_expiration_time],[time_limit_type],[time_limit_expiration_time],[guild_id] from [BlGame01].dbo.[AccessoryProperty] where [pcid]='{pcid}' and [id] in ({item_id}); -- 首饰/衣服");
sql.Add($"insert into [BlGame01].dbo.[GroceryProperty] select [pawn],([id]+(select cast( floor(rand()*10000000) as int))+{textBox1.Text.Trim()}) as 'id','{textBox1.Text.Trim()}' as 'PCID',[depot],[pos],[data_id],[level],[exp],[sequestration],[count] from [BlGame01].dbo.[GroceryProperty] where[pcid] = '{pcid}' and [id] in ({item_id}); --材料 / 消耗品");
sql.Add($"insert into [BlGame01].dbo.[WeaponProperty] select [pawn],[converted_lock_expiration_time],[converted_time_limit_expiration_time],([id]+(select cast( floor(rand()*10000000) as int))+{textBox1.Text.Trim()}) as 'id','{textBox1.Text.Trim()}' as 'PCID',[depot],[pos],[data_id],[level],[exp],[used],[sequestration],[locked],[lock_expiration_time],[time_limit_type],[time_limit_expiration_time],[durability],[enchant],[appearance_item_data_id],[appearance_item_level],[gem_1],[gem_2],[gem_3],[gem_4],[gem_5],[gem_6] from [BlGame01].dbo.[WeaponProperty] where[pcid] = '{pcid}' and [id] in ({item_id}); --武器");
sql.Add($"insert into [BlGame01].dbo.[CostumeProperty] select [pawn],[converted_lock_expiration_time],[converted_time_limit_expiration_time],([id]+(select cast( floor(rand()*10000000) as int))+{textBox1.Text.Trim()}) as 'id','{textBox1.Text.Trim()}' as 'PCID',[depot],[pos],[data_id],[level],[exp],[used],[sequestration],[locked],[lock_expiration_time],[time_limit_type],[time_limit_expiration_time],[guild_id] from [BlGame01].dbo.[CostumeProperty] where[pcid] = '{pcid}' and [id] in ({item_id}); --衣服");
sql.Add($"insert into [BlGame01].dbo.[Closet] select '{textBox1.Text.Trim()}' as 'PCID',[ClosetGroupID],([ItemInstanceID]+(select cast( floor(rand()*10000000) as int))+{textBox1.Text.Trim()}) as 'ItemInstanceID',[ItemDataID],[Used],[Locked],[LockExpirationTime],[TimeLimitType],[TimeLimitExpirationTime],[ClosetState] from [BlGame01].dbo.[Closet] where[pcid] = '{pcid}' and [ItemInstanceID] in ({item_id}); --衣柜");
if (db.IsConnection)
{
foreach (var item in sql)
{
count += db._SQL_IDU(item);
Thread.Sleep(500);
}
ReturnValue = count;
this.Invoke(new Action(delegate
{
this.DialogResult = DialogResult.OK;
this.Close();
}));
}
});
}
}
catch (Exception ex)
{
MessageBox.Show($"发生错误 \r\n错误信息:{ex.Message}", "无法执行", MessageBoxButtons.OK, MessageBoxIcon.Warning);
this.Close();
}
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
if (textBox1.Text.Trim() != "")
{
datas = Convert.ToInt64(textBox1.Text.Trim());
string sqlstr = string.Empty;
if (typ == "exp")
{
sqlstr = $@"
begin tran
begin try
update [BlGame01].dbo.[WeaponProperty] set [exp] = '{datas}' where [pcid] = '{pcid}' and [id] = '{id}';
update [BlGame01].dbo.[AccessoryProperty] set [exp] = '{datas}' where [pcid] = '{pcid}' and [id] = '{id}';
end try
begin catch
if(@@trancount>0)
rollback tran
end catch
if(@@trancount>0)
commit tran";
}
else if (typ == "data_id")
{
sqlstr = $@"
begin tran
begin try
update [BlGame01].dbo.[WeaponProperty] set [data_id] = '{datas}' where [pcid] = '{pcid}' and [id] = '{id}';
update [BlGame01].dbo.[AccessoryProperty] set [data_id] = '{datas}' where [pcid] = '{pcid}' and [id] = '{id}';
update [BlGame01].dbo.[GroceryProperty] set [data_id] = '{datas}' where [pcid] = '{pcid}' and [id] = '{id}';
update [BlGame01].dbo.[CostumeProperty] set [data_id] = '{datas}' where [pcid] = '{pcid}' and [id] = '{id}';
update [BlGame01].dbo.[GemProperty] set [data_id] = '{datas}' where [pcid] = '{pcid}' and [id] = '{id}';
end try
begin catch
if(@@trancount>0)
rollback tran
end catch
if(@@trancount>0)
commit tran";
}
else if (typ == "hh")
{
sqlstr = $@"
begin tran
begin try
update [BlGame01].dbo.[WeaponProperty] set [appearance_item_data_id] = '{datas}' where [pcid] = '{pcid}' and [id] = '{id}';
end try
begin catch
if(@@trancount>0)
rollback tran
end catch
if(@@trancount>0)
commit tran";
}
Task.Run(() =>
{
if (db.IsConnection)
{
count = db._SQL_IDU(sqlstr);
ReturnValue = count;
ReturnValue1 = datas;
this.Invoke(new Action(delegate
{
this.DialogResult = DialogResult.OK;
this.Close();
}));
}
});
}
else
{
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show($"修改时发生错误 \r\n角色PCID:{pcid}\r\n物品ID:{id}\r\n错误信息:{ex.Message}", "无法执行", MessageBoxButtons.OK, MessageBoxIcon.Warning);
this.Close();
}
}
private void button1_Click(object sender, EventArgs e)
{
string data_str = textBox1.Text.Trim();
string pcid = string.Empty;
if (data_str != "")
{
string tips = string.Empty;
int Index = 0;
foreach (var item in dic)
{
if (Index < 4)
{
tips += $"[{item.Value}],";
}
else
{
tips += $"[{item.Value}]\r\n";
Index = 0;
}
pcid += $"'{item.Key}',";
Index++;
}
if (tips.Substring(tips.Length - 1, 1) == ",")
{
tips = tips.Substring(0, tips.Length - 1);
}
if (pcid.Substring(pcid.Length - 1, 1) == ",")
{
pcid = pcid.Substring(0, pcid.Length - 1);
}
DialogResult di = MessageBox.Show($"请确认删除物品ID为({data_str})的物品.\r\n 共选择账号:\r\n{tips}", "请确认操作！", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
Task.Run(() =>
{
if (DialogResult.Yes == di)
{
string sqlstr = $@"
begin tran
begin try
delete [BlGame01].dbo.[AccessoryProperty] where [pcid] in ({pcid}) and [data_id] in ({data_str})
delete [BlGame01].dbo.[GroceryProperty] where [pcid] in ({pcid}) and [data_id] in ({data_str})
delete [BlGame01].dbo.[WeaponProperty] where [pcid] in ({pcid}) and [data_id] in ({data_str})
delete [BlGame01].dbo.[CostumeProperty] where [pcid] in ({pcid}) and [data_id] in ({data_str})
delete [BlGame01].dbo.[Closet] where [pcid] in ({pcid}) and [ItemDataID] in ({data_str})
delete [BlGame01].dbo.[GemProperty] where [pcid] in ({pcid}) and [data_id] in ({data_str})
end try
begin catch
if(@@trancount>0)
rollback tran
end catch
if(@@trancount>0)
commit tran";
if (db.IsConnection)
{
int count = db._SQL_IDU(sqlstr);
this.Invoke(new Action(delegate
{
MessageBox.Show($"已完成操作！受影响数据共:{count}条！", "执行完毕");
this.Close();
}));
}
}
});
}
}
