private void LoadInfo()
{
DataRow[] idrs = wapp.WebSpiderInfoList.WebSpiderInfoTable.Select("ListID='" + ids + "'");
if (idrs.Length > 0)
{
infodt = DataOften.GetTable(idrs);
}
else
{
WinOften.MessShow("该信息不存在或已被删除！", 1);
this.Close();
return;
}
tbListTitle.Text = DataOften.GetStr(infodt, "ListTitle");
tbListCode.Text = DataOften.GetStr(infodt, "ListCode");
tbOrderNum.Text = DataOften.GetStr(infodt, "OrderNum");
rTBContentRule.Text = DataOften.GetStr(infodt, "ContentRule");
rTBContentRangeRule.Text = DataOften.GetStr(infodt, "ContentRangeRule");
tbContentRuleIndex.Text = DataOften.GetStr(infodt, "ContentRuleIndex");
tbContentRangeRuleIndex.Text = DataOften.GetStr(infodt, "ContentRangeRuleIndex");
rTBContentRegFilt.Text = DataOften.GetStr(infodt, "ContentRegFilt");
wapp.AppPub.SetRadioListChecked(DataOften.GetStr(infodt, "ContentType"), rbctype);
wapp.AppPub.SelectComboBoxItems(cBContentCodeMode, DataOften.GetStr(infodt, "ContentCodeMode"));
string cf = DataOften.GetStr(infodt, "ContentFilt");
cflist = wapp.AppPub.GetIntList(cf, 4);
wapp.AppPub.SetRadioListChecked(cflist[0].ToString(), rbcfilta);
wapp.AppPub.SetRadioListChecked(cflist[1].ToString(), rbcfiltb);
wapp.AppPub.SetRadioListChecked(cflist[2].ToString(), rbcfiltc);
wapp.AppPub.SetRadioListChecked(cflist[3].ToString(), rbcfiltd);
}
/// <summary>返回数据表字段的数字格式</summary>
/// <param name="dt">数据表</param>
/// <param name="cname">列名</param>
/// <param name="row">行索引</param>
/// <param name="defval">默认值</param>
/// <returns>返回数据表字段的数字格式</returns>
public static double GetNumber(DataTable dt, string cname, int row, string defval)
{
string val = DataOften.GetStr(dt, cname, row);
if (!Often.IsNum(val))
{
val = defval;
}
return(GetHoldDigit(Convert.ToDouble(val), 2));
}
/// <summary>返回数据表字段的数字格式</summary>
/// <param name="dt">数据表</param>
/// <param name="cname">列名</param>
/// <param name="row">行索引</param>
/// <returns>返回数据表字段的数字格式</returns>
public static double GetDouble(DataTable dt, string cname, int row)
{
string val = DataOften.GetStr(dt, cname, row);
if (!Often.IsNum(val))
{
val = "0";
}
return(Convert.ToDouble(val));
}
/// <summary>返回数据表字段的数字格式</summary>
/// <param name="dt">数据表</param>
/// <param name="cname">列名</param>
/// <param name="defval">默认值</param>
/// <returns>返回数据表字段的数字格式</returns>
public static double GetDouble(DataTable dt, string cname, string defval)
{
string val = DataOften.GetStr(dt, cname);
if (!Often.IsNum(val))
{
val = defval;
}
return(Convert.ToDouble(val));
}
/// <summary>返回数据表字段的数字格式</summary>
/// <param name="dt">数据表</param>
/// <param name="cname">列名</param>
/// <param name="defval">默认值</param>
/// <returns>返回数据表字段的数字格式</returns>
public static int GetInt(DataTable dt, string cname, string defval)
{
string val = DataOften.GetStr(dt, cname);
if (!Often.IsInt32(val))
{
val = defval;
}
return(Convert.ToInt32(val));
}
/// <summary>返回数据表字段的数字格式</summary>
/// <param name="dt">数据行集合</param>
/// <param name="cname">列名</param>
/// <param name="row">行索引</param>
/// <param name="defval">默认值</param>
/// <returns>返回数据表字段的数字格式</returns>
public static int GetInt(DataRow[] dr, string cname, int row, string defval)
{
string val = DataOften.GetStr(dr, cname, row);
if (!Often.IsInt32(val))
{
val = defval;
}
return(Convert.ToInt32(val));
}
/// <summary>返回数据表字段的数字格式</summary>
/// <param name="dr">数据行集合</param>
/// <param name="cname">列名</param>
/// <param name="row">行索引</param>
/// <param name="defval">默认值</param>
/// <returns>返回数据表字段的数字格式</returns>
public static double GetDouble(DataRow[] dr, string cname, int row, string defval)
{
string val = DataOften.GetStr(dr, cname, row);
if (!Often.IsNum(val))
{
val = defval;
}
return(Convert.ToDouble(val));
}
/// <summary>返回数据表字段的数字格式</summary>
/// <param name="dt">数据表</param>
/// <param name="cname">列名</param>
/// <param name="row">行索引</param>
/// <returns>返回数据表字段的数字格式</returns>
public static int GetInt(DataTable dt, string cname, int row)
{
string val = DataOften.GetStr(dt, cname, row);
if (!Often.IsInt32(val))
{
val = "0";
}
return(Convert.ToInt32(val));
}
/// <summary>返回数据表字段的数字格式</summary>
/// <param name="dr">数据行集合</param>
/// <param name="cname">列名</param>
/// <returns>返回数据表字段的数字格式</returns>
public static int GetInt(DataRow[] dr, string cname)
{
string val = DataOften.GetStr(dr, cname);
if (!Often.IsInt32(val))
{
val = "0";
}
return(Convert.ToInt32(val));
}
/// <summary>返回数据表字段的数字格式</summary>
/// <param name="dr">数据行集合</param>
/// <param name="cname">列名</param>
/// <returns>返回数据表字段的数字格式</returns>
public static double GetDouble(DataRow[] dr, string cname)
{
string val = DataOften.GetStr(dr, cname);
if (!Often.IsNum(val))
{
val = "0";
}
return(Convert.ToDouble(val));
}
/// <summary>返回数据表字段的数字格式</summary>
/// <param name="dr">数据行集合</param>
/// <param name="cname">列名</param>
/// <param name="defval">默认值</param>
/// <returns>返回数据表字段的数字格式</returns>
public static double GetNumber(DataRow[] dr, string cname, string defval)
{
string val = DataOften.GetStr(dr, cname);
if (!Often.IsNum(val))
{
val = defval;
}
return(GetHoldDigit(Convert.ToDouble(val), 2));
}
private void Form1_Load(object sender, EventArgs e)
{
App.Win.Utils.SetComboBoxItems(cBdc, "|全部||" + wapp.AppList.AnswerResult(), "");
cBdc.SelectedIndex = 0;
tkdt = wapp.SQLiteConn.Sqllite.GetDT("select * from tklb where zid=?", tkid);
ltkbt.Text = DataOften.GetStr(tkdt, "bt");
tmdt = wapp.SQLiteConn.Sqllite.GetDT("select * from tmlb where zid=?", tmid);
ltmbt.Text = DataOften.GetStr(tmdt, "tm");
LoadList();
isLoad = true;
}
private void Form_Load(object sender, EventArgs e)
{
bW.WorkerSupportsCancellation = true;
App.Win.Utils.SetComboBoxItems(cBlx, "|全部||" + wapp.AppList.SubjectType(), "");
cBlx.SelectedIndex = 0;
App.Win.Utils.SetComboBoxItems(cBuse, "|全部||" + wapp.AppList.IsUser(), "");
cBuse.SelectedIndex = 0;
App.Win.Utils.SetComboBoxItems(cBmb, wapp.AppList.SearchTarget(), "");
cBmb.SelectedIndex = 0;
App.Win.Utils.SetComboBoxItems(cBhs, wapp.AppList.RowNumbers(), "");
cBhs.SelectedIndex = 0;
tkdt = wapp.SQLiteConn.Sqllite.GetDT("select * from tklb where zid=?", tkid);
ltkbt.Text = DataOften.GetStr(tkdt, "bt");
LoadList(1);
isLoad = true;
}
private void FrmAnswerInfo_Load(object sender, EventArgs e)
{
cBpx.Checked = false;
ppx.Enabled = false;
tBpx.Text = "";
tkdt = wapp.SQLiteConn.Sqllite.GetDT("select * from tklb where zid=?", tkid);
ltkbt.Text = DataOften.GetStr(tkdt, "bt");
tmdt = wapp.SQLiteConn.Sqllite.GetDT("select * from tmlb where zid=?", tmid);
ltmbt.Text = DataOften.GetStr(tmdt, "tm");
if (daid != "")
{
DataTable dadt = wapp.SQLiteConn.Sqllite.GetDT("select * from dalb where zid=?", daid);
if (dadt != null && dadt.Rows.Count > 0)
{
rTextName.Text = App.DataOften.GetStr(dadt, "dan");
string dc = App.DataOften.GetStr(dadt, "dc");
if (dc == "1")
{
rB1.Checked = true;
}
else
{
rB2.Checked = true;
}
gB.Enabled = false;
int px = App.Often.GetInt(App.DataOften.GetStr(dadt, "px"), "0");
if (px > 0)
{
cBpx.Checked = true;
ppx.Enabled = true;
tBpx.Text = px.ToString();
}
IsEdit = true;
}
}
if (IsEdit)
{
this.Text = "编辑答案";
}
else
{
this.Text = "新增答案";
}
}
private void LoadUserInfo()
{
DataRow[] udrs = wapp.UserList.UsersTable.Select("UserName='******'");
if (udrs.Length > 0)
{
userdt = DataOften.GetTable(udrs);
}
else
{
WinOften.MessShow("该用户不存在或已被删除！", 1);
this.Close();
return;
}
tbfPwd.Enabled = false;
tbName.Text = DataOften.GetStr(userdt, "UserName");
tbrealName.Text = DataOften.GetStr(userdt, "RealName");
tbphone.Text = DataOften.GetStr(userdt, "Phones");
tbPwd.Text = " ";
tbName.Enabled = false;
}
private void LoadInfo()
{
DataRow[] idrs = wapp.WebSpiderList.WebSpiderTable.Select("SpiderID='" + ids + "'");
if (idrs.Length > 0)
{
infodt = DataOften.GetTable(idrs);
}
else
{
WinOften.MessShow("该信息不存在或已被删除！", 1);
this.Close();
return;
}
btset.Visible = true;
tbSpiderName.Text = DataOften.GetStr(infodt, "SpiderName");
tbOrderNum.Text = DataOften.GetStr(infodt, "OrderNum");
rTBUrlList.Text = DataOften.GetStr(infodt, "UrlList");
rTBUrlRule.Text = DataOften.GetStr(infodt, "UrlRule");
rTBUrlRangeRule.Text = DataOften.GetStr(infodt, "UrlRangeRule");
tbUrlRuleIndex.Text = DataOften.GetStr(infodt, "UrlRuleIndex");
tbUrlRangeRuleIndex.Text = DataOften.GetStr(infodt, "UrlRangeRuleIndex");
tbExcelSavePath.Text = DataOften.GetStr(infodt, "ExcelSavePath");
tbHtmlSavePath.Text = DataOften.GetStr(infodt, "HtmlSavePath");
tbGatherMaxNum.Text = DataOften.GetStr(infodt, "GatherMaxNum");
cBPageCoding.Text = DataOften.GetStr(infodt, "PageCoding");
rTBNextRangeRule.Text = DataOften.GetStr(infodt, "NextRangeRule");
rTBNextRule.Text = DataOften.GetStr(infodt, "NextRule");
rTBConNextRangeRule.Text = DataOften.GetStr(infodt, "ConNextRangeRule");
rTBConNextRule.Text = DataOften.GetStr(infodt, "ConNextRule");
tbNextRangeRuleIndex.Text = DataOften.GetStr(infodt, "NextRangeRuleIndex");
tbNextRuleIndex.Text = DataOften.GetStr(infodt, "NextRuleIndex");
tbConNextRangeRuleIndex.Text = DataOften.GetStr(infodt, "ConNextRangeRuleIndex");
tbConNextRuleIndex.Text = DataOften.GetStr(infodt, "ConNextRuleIndex");
wapp.AppPub.SetRadioListChecked(DataOften.GetStr(infodt, "IsSaveHtml"), rbishtml);
wapp.AppPub.SetRadioListChecked(DataOften.GetStr(infodt, "CodingMode"), rbcmode);
wapp.AppPub.SetRadioListChecked(DataOften.GetStr(infodt, "IsEcho"), rbisecho);
wapp.AppPub.SetRadioListChecked(DataOften.GetStr(infodt, "IsNext"), rbisnext);
wapp.AppPub.SetRadioListChecked(DataOften.GetStr(infodt, "ConIsNext"), rbcisnext);
wapp.AppPub.SetRadioListChecked(DataOften.GetStr(infodt, "NextMode"), rbnmode);
wapp.AppPub.SetRadioListChecked(DataOften.GetStr(infodt, "ConNextMode"), rbcnmode);
}
private void btsave_Click(object sender, EventArgs e)
{
if (!IsRunOper())
{
return;
}
string name = tbName.Text.Trim();
if (OpMode == 0)
{
DataRow[] udrs = wapp.UserList.UsersTable.Select("UserName='******'");
if (udrs.Length > 0)
{
WinOften.MessShow("用户名已存在！", 1);
return;
}
}
int mv = 60;
wapp.SysUser su = new wapp.SysUser();
su.UserName = name;
su.UserPwd = tbPwd.Text.Trim();
su.ManageLv = mv;
su.RealName = tbrealName.Text.Trim();
su.Phones = tbphone.Text.Trim();
if (OpMode == 1)
{
su.LoginDate = Convert.ToDateTime(DataOften.GetStr(userdt, "LoginDate"));
}
else
{
su.LoginDate = Convert.ToDateTime("1990-01-01");
}
wapp.UserList.SaveUsersTable(su);
WinOften.MessShow("保存成功！", 0);
IsOper = true;
this.Close();
}
private void FrmSubjectInfo_Load(object sender, EventArgs e)
{
tkdt = wapp.SQLiteConn.Sqllite.GetDT("select * from tklb where zid=?", tkid);
ltkbt.Text = DataOften.GetStr(tkdt, "bt");
if (tmid != "")
{
tmdt = wapp.SQLiteConn.Sqllite.GetDT("select * from tmlb where zid=?", tmid);
if (tmdt != null && tmdt.Rows.Count > 0)
{
rTextName.Text = App.DataOften.GetStr(tmdt, "tm");
rTBdajx.Text = App.DataOften.GetStr(tmdt, "dajx");
string lx = App.DataOften.GetStr(tmdt, "lx");
if (lx == "1")
{
rB2.Checked = true;
}
else if (lx == "2")
{
rB3.Checked = true;
}
else
{
rB1.Checked = true;
}
gB.Enabled = false;
IsEdit = true;
}
}
if (IsEdit)
{
this.Text = "编辑题目";
}
else
{
this.Text = "新增题目";
}
}
/// <summary>读取网络蜘蛛设置</summary>
/// <param name="wsid">网络蜘蛛ID</param>
public void LoadWebSpiderInfo(string wsid)
{
IsLoad = false;
SpiderID = wsid;
DataRow[] sdrs = wapp.WebSpiderList.WebSpiderTable.Select("SpiderID='" + wsid + "'");
if (sdrs.Length <= 0)
{
return;
}
ws = new WebSpider();
ws.SpiderID = DataOften.GetStr(sdrs, "SpiderID");
ws.SpiderName = DataOften.GetStr(sdrs, "SpiderName");
ws.UrlList = DataOften.GetStr(sdrs, "UrlList");
ws.UrlRangeRule = DataOften.GetStr(sdrs, "UrlRangeRule").Replace("\\[RegRuleZhyNoLabel88088]", "([\\S\\s][^<>]*?)").Replace("\\[RegRuleZhyLabel88088]", "([\\S\\s]*?)");
ws.UrlRule = DataOften.GetStr(sdrs, "UrlRule").Replace("\\[RegRuleZhyNoLabel88088]", "([\\S\\s][^<>]*?)").Replace("\\[RegRuleZhyLabel88088]", "([\\S\\s]*?)");
ws.NextRangeRule = DataOften.GetStr(sdrs, "NextRangeRule").Replace("\\[RegRuleZhyNoLabel88088]", "([\\S\\s][^<>]*?)").Replace("\\[RegRuleZhyLabel88088]", "([\\S\\s]*?)");
ws.NextRule = DataOften.GetStr(sdrs, "NextRule").Replace("\\[RegRuleZhyNoLabel88088]", "([\\S\\s][^<>]*?)").Replace("\\[RegRuleZhyLabel88088]", "([\\S\\s]*?)");
ws.UrlRangeRuleIndex = AppPub.GetInt(DataOften.GetStr(sdrs, "UrlRangeRuleIndex", "0"));
ws.UrlRuleIndex = AppPub.GetInt(DataOften.GetStr(sdrs, "UrlRuleIndex", "0"));
ws.NextRangeRuleIndex = AppPub.GetInt(DataOften.GetStr(sdrs, "NextRangeRuleIndex", "0"));
ws.NextRuleIndex = AppPub.GetInt(DataOften.GetStr(sdrs, "NextRuleIndex", "0"));
ws.IsSaveHtml = AppPub.GetInt(DataOften.GetStr(sdrs, "IsSaveHtml", "0"));
ws.HtmlSavePath = DataOften.GetStr(sdrs, "HtmlSavePath");
ws.ExcelSavePath = DataOften.GetStr(sdrs, "ExcelSavePath");
ws.OrderNum = AppPub.GetInt(DataOften.GetStr(sdrs, "OrderNum", "0"));
ws.GatherCount = AppPub.GetInt(DataOften.GetStr(sdrs, "GatherCount", "0"));
ws.CodingMode = AppPub.GetInt(DataOften.GetStr(sdrs, "CodingMode", "0"));
ws.PageCoding = DataOften.GetStr(sdrs, "PageCoding");
ws.GatherMaxNum = AppPub.GetInt(DataOften.GetStr(sdrs, "GatherMaxNum", "0"));
ws.IsEcho = AppPub.GetInt(DataOften.GetStr(sdrs, "IsEcho", "0"));
ws.IsNext = AppPub.GetInt(DataOften.GetStr(sdrs, "IsNext", "0"));
ws.NextMode = AppPub.GetInt(DataOften.GetStr(sdrs, "NextMode", "0"));
ws.ConNextRangeRule = DataOften.GetStr(sdrs, "ConNextRangeRule").Replace("\\[RegRuleZhyNoLabel88088]", "([\\S\\s][^<>]*?)").Replace("\\[RegRuleZhyLabel88088]", "([\\S\\s]*?)");
ws.ConNextRule = DataOften.GetStr(sdrs, "ConNextRule").Replace("\\[RegRuleZhyNoLabel88088]", "([\\S\\s][^<>]*?)").Replace("\\[RegRuleZhyLabel88088]", "([\\S\\s]*?)");
ws.ConNextRangeRuleIndex = AppPub.GetInt(DataOften.GetStr(sdrs, "ConNextRangeRuleIndex", "0"));
ws.ConNextRuleIndex = AppPub.GetInt(DataOften.GetStr(sdrs, "ConNextRuleIndex", "0"));
ws.ConIsNext = AppPub.GetInt(DataOften.GetStr(sdrs, "ConIsNext", "0"));
ws.ConNextMode = AppPub.GetInt(DataOften.GetStr(sdrs, "ConNextMode", "0"));
DataRow[] sidrs = wapp.WebSpiderInfoList.WebSpiderInfoTable.Select("SpiderID='" + wsid + "'");
if (sidrs.Length <= 0)
{
return;
}
Table table = new Table("GTable");
bool iscol = false;
for (int i = 0; i < sidrs.Length; i++)
{
WebSpiderInfo wsi = new wapp.WebSpiderInfo();
wsi.ListID = DataOften.GetStr(sidrs, "ListID", i);
wsi.SpiderID = DataOften.GetStr(sidrs, "SpiderID", i);
wsi.ListTitle = DataOften.GetStr(sidrs, "ListTitle", i);
wsi.ListCode = DataOften.GetStr(sidrs, "ListCode", i);
wsi.ContentRangeRule = DataOften.GetStr(sidrs, "ContentRangeRule", i).Replace("\\[RegRuleZhyNoLabel88088]", "([\\S\\s][^<>]*?)").Replace("\\[RegRuleZhyLabel88088]", "([\\S\\s]*?)");
wsi.ContentRule = DataOften.GetStr(sidrs, "ContentRule", i).Replace("\\[RegRuleZhyNoLabel88088]", "([\\S\\s][^<>]*?)").Replace("\\[RegRuleZhyLabel88088]", "([\\S\\s]*?)");
wsi.ContentRangeRuleIndex = AppPub.GetInt(DataOften.GetStr(sidrs, "ContentRangeRuleIndex", i, "0"));
wsi.ContentRuleIndex = AppPub.GetInt(DataOften.GetStr(sidrs, "ContentRuleIndex", i, "0"));
wsi.ContentFilt = DataOften.GetStr(sidrs, "ContentFilt", i);
wsi.ContentRegFilt = DataOften.GetStr(sidrs, "ContentRegFilt", i);
wsi.ContentType = AppPub.GetInt(DataOften.GetStr(sidrs, "ContentType", i, "0"));
wsi.OrderNum = AppPub.GetInt(DataOften.GetStr(sidrs, "OrderNum", i, "0"));
wsi.ContentCodeMode = AppPub.GetInt(DataOften.GetStr(sidrs, "ContentCodeMode", i, "0"));
if (wsi.ContentType == 1)
{
table.Add(wsi.ListTitle, "double", 0);
}
else if (wsi.ContentType == 2)
{
table.Add(wsi.ListTitle, "datetime", 0);
}
else
{
table.Add(wsi.ListTitle, "string", 0);
}
wsilist.Add(wsi);
iscol = true;
}
gdt = DataTables.GetDataTable(table);
if (iscol)
{
IsLoad = true;
}
}
