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()); })); }); }