public void LoadList() { StringBuilder sb = new StringBuilder(); List <string> li = new List <string>(); DataOften.SqlAddArr("tmid=?", tmid, ref sb, ref li); string cname = tBName.Text.Trim(); if (cname != "") { DataOften.SqlAddArr("dan like ?", "%" + cname + "%", ref sb, ref li); } string dc = App.Win.Utils.GetComboBoxValue(cBdc); if (dc != "") { DataOften.SqlAddArr("dc = ?", dc, ref sb, ref li); } DataOften.SqlAddWhere(ref sb); string sql = "select * from dalb " + sb.ToString(); dadt = wapp.SQLiteConn.Sqllite.GetDT(sql, li); int xh = 1; listv.Items.Clear(); for (int i = 0; i < dadt.Rows.Count; i++) { string zid = dadt.Rows[i]["zid"].ToString().Trim(); ListViewItem itema = new ListViewItem("", 0); itema.UseItemStyleForSubItems = false; itema.Name = zid; itema.SubItems.Add((xh + i).ToString()); itema.SubItems.Add(dadt.Rows[i]["dan"].ToString().Trim()); string dcs = dadt.Rows[i]["dc"].ToString().Trim(); itema.SubItems.Add(App.Web.WebOften.GetListVal(wapp.AppList.AnswerResult(), dcs)); wapp.pub.setResultColor(itema.SubItems[itema.SubItems.Count - 1], dcs); itema.SubItems.Add(dadt.Rows[i]["px"].ToString().Trim()); listv.Items.AddRange(new ListViewItem[] { itema }); } cBallsel.Checked = false; }
public void LoadList(int pageNum) { centPage.PageNum = pageNum; centPage.DataCount = 0; centPage.EachCount = App.Often.GetInt(App.Win.Utils.GetComboBoxValue(cBhs)); StringBuilder sb = new StringBuilder(); List <string> li = new List <string>(); string cname = tBName.Text.Trim(); if (cname != "") { DataOften.SqlAddArr("bt like ?", "%" + cname + "%", ref sb, ref li); } DataOften.SqlAddWhere(ref sb); centPage.DataCount = App.Often.GetInt(wapp.SQLiteConn.Sqllite.GetES("select count(0) from tklb " + sb.ToString(), li)); centPage.SetCent(); string sql = "select * from tklb " + sb.ToString() + " limit " + centPage.EachCount.ToString() + " offset " + centPage.StartData.ToString(); DataTable dt = wapp.SQLiteConn.Sqllite.GetDT(sql, li); int xh = centPage.StartData + 1; listv.Items.Clear(); for (int i = 0; i < dt.Rows.Count; i++) { string zid = dt.Rows[i]["zid"].ToString().Trim(); ListViewItem itema = new ListViewItem("", 0); itema.Name = zid; itema.SubItems.Add((xh + i).ToString()); itema.SubItems.Add(dt.Rows[i]["bt"].ToString().Trim()); itema.SubItems.Add(dt.Rows[i]["sl"].ToString().Trim()); itema.SubItems.Add(dt.Rows[i]["yxsl"].ToString().Trim()); itema.SubItems.Add(dt.Rows[i]["wxsl"].ToString().Trim()); itema.SubItems.Add(dt.Rows[i]["ms"].ToString().Trim()); listv.Items.AddRange(new ListViewItem[] { itema }); } cBallsel.Checked = false; }
public void LoadList(int pageNum) { if (bW.IsBusy) { bW.CancelAsync(); } centPage.PageNum = pageNum; centPage.DataCount = 0; centPage.EachCount = App.Often.GetInt(App.Win.Utils.GetComboBoxValue(cBhs)); StringBuilder sb = new StringBuilder(); List <string> li = new List <string>(); DataOften.SqlAddArr("tkid=?", tkid, ref sb, ref li); string cname = tBName.Text.Trim(); if (cname != "") { string mb = App.Win.Utils.GetComboBoxValue(cBmb); if (mb == "0") { DataOften.SqlAddArr("(tm like ? or zid in (select tmid from dalb where dan like ?) or dajx like ?)", ref sb, ref li, "%" + cname + "%", "%" + cname + "%", "%" + cname + "%"); } else if (mb == "1") { DataOften.SqlAddArr("tm like ?", "%" + cname + "%", ref sb, ref li); } else if (mb == "2") { DataOften.SqlAddArr("zid in (select tmid from dalb where dan like ?)", ref sb, ref li, "%" + cname + "%"); } else if (mb == "3") { DataOften.SqlAddArr("tm like ? or dajx like ?", ref sb, ref li, "%" + cname + "%", "%" + cname + "%"); } } string lx = App.Win.Utils.GetComboBoxValue(cBlx); if (lx != "") { DataOften.SqlAddArr("lx = ?", lx, ref sb, ref li); } string qy = App.Win.Utils.GetComboBoxValue(cBuse); if (qy != "") { DataOften.SqlAddArr("qy = ?", qy, ref sb, ref li); } DataOften.SqlAddWhere(ref sb); centPage.DataCount = App.Often.GetInt(wapp.SQLiteConn.Sqllite.GetES("select count(0) from tmlb " + sb.ToString(), li)); centPage.SetCent(); string sql = "select * from tmlb " + sb.ToString() + " limit " + centPage.EachCount.ToString() + " offset " + centPage.StartData.ToString(); tmdt = wapp.SQLiteConn.Sqllite.GetDT(sql, li); int xh = centPage.StartData + 1; listv.Items.Clear(); if (tmdt.Rows.Count > 0) { for (int i = 0; i < tmdt.Rows.Count; i++) { string zid = tmdt.Rows[i]["zid"].ToString().Trim(); ListViewItem itema = new ListViewItem("", 0); itema.UseItemStyleForSubItems = false; itema.Name = zid; itema.SubItems.Add((xh + i).ToString()); itema.SubItems.Add(tmdt.Rows[i]["tm"].ToString().Trim()); itema.SubItems.Add(tmdt.Rows[i]["dajx"].ToString().Trim()); string qys = tmdt.Rows[i]["qy"].ToString().Trim(); itema.SubItems.Add(App.Web.WebOften.GetListVal(wapp.AppList.IsUser(), qys)); wapp.pub.setUseColor(itema.SubItems[itema.SubItems.Count - 1], qys); string lxs = tmdt.Rows[i]["lx"].ToString().Trim(); itema.SubItems.Add(App.Web.WebOften.GetListVal(wapp.AppList.SubjectType(), lxs)); wapp.pub.setSubjectTypeColor(itema.SubItems[itema.SubItems.Count - 1], lxs); itema.SubItems.Add(tmdt.Rows[i]["sl"].ToString().Trim()); listv.Items.AddRange(new ListViewItem[] { itema }); } index = listv.Items[0].SubItems.Count - 1; bW.RunWorkerAsync(); } cBallsel.Checked = false; }