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