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