private void Form2_Shown(object sender, EventArgs e)
{
Task.Run(() =>
{
string sqlstr = $@"select [WorldID],[WorldName] from [LobbyDB].dbo.[GameWorld]";
List <Word_Entity> list = new List <Word_Entity>();
using (SqlDataReader sdr = db._SQLRead(sqlstr))
{
while (sdr.Read())
{
Word_Entity entity = new Word_Entity()
{
WordID = Convert.ToInt32(sdr["WorldID"]),
WordName = sdr["WorldName"].ToString()
};
list.Add(entity);
}
}
this.Invoke(new Action(delegate
{
comboBox1.DataSource = null;
comboBox1.DisplayMember = "WordName";
comboBox1.ValueMember = "WordID";
comboBox1.DataSource = list;
}));
});
}
private void button1_Click(object sender, EventArgs e)
{
Task.Run(() =>
{
string sqlstr = $@"select * from [ManagementDB].dbo.[Announce]";
List <Announce_Entity> list = new List <Announce_Entity>();
using (SqlDataReader sdr = db._SQLRead(sqlstr))
{
while (sdr.Read())
{
Announce_Entity entity = new Announce_Entity()
{
registerID = Convert.ToInt32(sdr["registerID"]),
author = sdr["author"].ToString(),
dayInterval = Convert.ToInt32(sdr["dayInterval"]),
endDate = Convert.ToDateTime(sdr["endDate"]),
startDate = Convert.ToDateTime(sdr["startDate"]),
godSayMessage = sdr["godSayMessage"].ToString(),
godSayPosition = Convert.ToInt32(sdr["godSayPosition"]),
godSayType = Convert.ToInt32(sdr["godSayType"]),
minInterval = Convert.ToInt32(sdr["minInterval"]),
repeatCount = Convert.ToInt32(sdr["repeatCount"]),
title = sdr["title"].ToString(),
worlds = sdr["worlds"].ToString()
};
list.Add(entity);
}
}
List <ListViewItem> lvi = new List <ListViewItem>();
foreach (var item in list)
{
ListViewItem l = new ListViewItem();
l.Tag = item.registerID;
l.Text = (lvi.Count + 1).ToString();
l.SubItems.Add(item.title);
l.SubItems.Add(item.godSayMessage);
l.SubItems.Add(item.worlds);
l.SubItems.Add(item.author);
l.SubItems.Add(item.dayInterval.ToString());
l.SubItems.Add(item.minInterval.ToString());
l.SubItems.Add(item.repeatCount.ToString());
l.SubItems.Add(item.startDate.ToString("yyyy-MM-dd HH:mm:ss"));
l.SubItems.Add(item.endDate.ToString("yyyy-MM-dd HH:mm:ss"));
lvi.Add(l);
}
this.Invoke(new Action(delegate
{
listView1.Items.Clear();
listView1.Items.AddRange(lvi.ToArray());
}));
});
}
private void button1_Click(object sender, EventArgs e)
{
string sql = string.Empty;
list.Clear();
sql += $"select a.[PostID],d.[dataID],d.[Amount],a.[SenderName],a.[RecipientName],a.[ReceiptTime],e.[LoginName] as 'SendAcction',f.[LoginName] as 'RecipientAcction' from [BlGame01].dbo.[UserPost] as a inner join [BlGame01].dbo.[CreatureProperty] as b on a.[SenderPCID] = b.[PCID] inner join [BlGame01].dbo.[CreatureProperty] as c on a.[RecipientPCID] = c.[PCID] left join [BlGame01].dbo.[UserPostAttachment] as d on d.[PostID] = a.[PostID] inner join [PlatformAcctDb].dbo.[Users] as e on e.[UserID] = b.[game_account_id] inner join [PlatformAcctDb].dbo.[Users] as f on f.[UserID] = c.[game_account_id] where 1 = 1";
string sql_str = string.Empty;
if (textBox1.Text.Trim() != "")
{
sql += $"and e.[LoginName] = '{textBox1.Text.Trim()}'";
sql_str += $"and b.[LoginName] = '{textBox1.Text.Trim()}@ncsoft.com'";
}
if (textBox2.Text.Trim() != "")
{
sql += $"and a.[SenderName] like '%{textBox2.Text.Trim()}'%";
}
if (textBox3.Text.Trim() != "")
{
sql += $"and d.[dataId] in ({textBox3.Text.Trim()})";
sql_str += $"and a.[道具ID] in ({textBox3.Text.Trim()})";
}
sql += " order by a.[ReceiptTime] desc ";
Task.Run(() =>
{
List <PostEntity> da = new List <PostEntity>();
using (SqlDataReader sdr = db._SQLRead(sql))
{
while (sdr.Read())
{
da.Add(new PostEntity()
{
PostID = sdr["PostID"].ToString(),
Amount = sdr["Amount"].ToString(),
dataID = sdr["dataID"] == DBNull.Value ? "无" : sdr["dataID"].ToString(),
ReceiptTime = sdr["ReceiptTime"].ToString(),
RecipientName = sdr["RecipientName"].ToString(),
RecipientAcction = sdr["RecipientAcction"].ToString().Replace("@ncsoft.com", ""),
SenderName = sdr["SenderName"].ToString(),
SendAcction = sdr["SendAcction"].ToString().Replace("@ncsoft.com", "")
});
}
}
string PostID = "";
DataMode T = null;
foreach (var item in da)
{
if (PostID != item.PostID)
{
if (T != null)
{
list.Add(T);
}
PostID = item.PostID;
T = new DataMode();
T.PostID = item.PostID;
T.SendName = item.SenderName;
T.SendAcction = item.SendAcction;
T.RecipientName = item.RecipientName;
T.RecipientAcction = item.RecipientAcction;
T.Timer = item.ReceiptTime;
T.jb = "0";
}
if (item.dataID != "无")
{
List <dj_item> d = Data.Where(it => it.ID == Convert.ToInt32(item.dataID)).ToList();
if (d.Count > 0)
{
T.Data += $"[{d[0].Name}]x{item.Amount};";
}
else
{
T.Data += $"{item.dataID}x{item.Amount};";
}
}
else
{
if (item.Amount != "")
{
T.jb = $"{Convert.ToDecimal(item.Amount) / 10000}";
}
}
}
List <ListViewItem> lvi_l = new List <ListViewItem>();
foreach (var item in list)
{
ListViewItem lvi = new ListViewItem();
lvi.Text = (lvi_l.Count + 1).ToString();
lvi.SubItems.Add(item.Data);
lvi.SubItems.Add(item.jb);
lvi.SubItems.Add(item.SendAcction);
lvi.SubItems.Add(item.RecipientAcction);
lvi.SubItems.Add(item.SendName);
lvi.SubItems.Add(item.RecipientName);
lvi.SubItems.Add(item.Timer);
lvi_l.Add(lvi);
}
this.Invoke(new Action(delegate
{
listView1.Items.Clear();
listView1.Items.AddRange(lvi_l.ToArray());
}));
});
}
