//列出采集项目 private void GetCollItemList() { TPortalClass.JpCollect_box JpCollect_box = new TPortalClass.JpCollect_box(); //string ls_sql2 = "SELECT * FROM JpCollect_box as a,JpColumns as b where a.ClassId = b.cid order by Id"; DataTable dt = JpCollect_box.Getcjlb(); this.GvCollItemList.DataSource = dt; this.GvCollItemList.DataBind(); }
//复制向导 private void CopyCollectInfo() { TPortalClass.JpCollect_box JpCollect_box = new TPortalClass.JpCollect_box(); if (Request.QueryString["id"] != null) { JpCollect_box.ItemName = ItemName + "副本"; JpCollect_box.ClassId = ClassId; JpCollect_box.WebEncode = WebEncode; JpCollect_box.WebName = WebName; JpCollect_box.WebUrl = WebUrl; JpCollect_box.ItemRemark = ItemRemark; JpCollect_box.Script_Iframe = Script_Iframe; JpCollect_box.Script_Object = Script_Object; JpCollect_box.Script_Script = Script_Script; JpCollect_box.Script_Div = Script_Div; JpCollect_box.Script_Table = Script_Table; JpCollect_box.Script_Span = Script_Span; JpCollect_box.Script_Img = Script_Img; JpCollect_box.Script_Font = Script_Font; JpCollect_box.Script_A = Script_A; JpCollect_box.Script_Html = Script_Html; JpCollect_box.IsSaveImg = IsSaveImg; JpCollect_box.IsDesc = IsDesc; JpCollect_box.CollecNum = CollecNum; JpCollect_box.ListUrl = ListUrl; JpCollect_box.ListStart = ListStart; JpCollect_box.ListEnd = ListEnd; JpCollect_box.LinkStart = LinkStart; JpCollect_box.LinkEnd = LinkEnd; JpCollect_box.TitleStart = TitleStart; JpCollect_box.TitleEnd = TitleEnd; JpCollect_box.RemoveTitle = RemoveTitle; JpCollect_box.KeyWordStart = KeyWordStart; JpCollect_box.KeyWordEnd = KeyWordEnd; JpCollect_box.DateStart = DateStart; JpCollect_box.SourceStart = SourceStart; JpCollect_box.DateEnd = DateEnd; JpCollect_box.SourceEnd = SourceEnd; JpCollect_box.ContentStart = ContentStart; JpCollect_box.ContentEnd = ContentEnd; JpCollect_box.RemoveBodyStart = RemoveBodyStart; JpCollect_box.RemoveBodyEnd = RemoveBodyEnd; JpCollect_box.NextPageRegex = NextPageRegex; JpCollect_box.Copydoc(); } }
//根据ID得到列表所有内容 private void GetAllListContent() { TPortalClass.JpCollect_box JpCollect_box = new TPortalClass.JpCollect_box(); if (Request.QueryString["id"] != null && Request.QueryString["id"] != "8888") { Id = this.Request.QueryString["id"].ToString(); //string ls_sql = "select * from JpCollect_box where id = " + Id; dt = JpCollect_box.Getdocbyid(int.Parse(Id)); //dt = db.GetDataTable(ls_sql); if (dt.Rows.Count > 0) { this.txtId.Text = dt.Rows[0]["Id"].ToString(); ListUrl = dt.Rows[0]["ListUrl"].ToString(); ListStart = dt.Rows[0]["ListStart"].ToString(); ListEnd = dt.Rows[0]["ListEnd"].ToString(); LinkStart = dt.Rows[0]["LinkStart"].ToString(); LinkEnd = dt.Rows[0]["LinkEnd"].ToString(); TitleStart = dt.Rows[0]["TitleStart"].ToString(); TitleEnd = dt.Rows[0]["TitleEnd"].ToString(); RemoveTitle = dt.Rows[0]["RemoveTitle"].ToString(); KeyWordStart = dt.Rows[0]["KeyWordStart"].ToString(); KeyWordEnd = dt.Rows[0]["KeyWordEnd"].ToString(); DateStart = dt.Rows[0]["DateStart"].ToString(); SourceStart = dt.Rows[0]["SourceStart"].ToString(); DateEnd = dt.Rows[0]["DateEnd"].ToString(); SourceEnd = dt.Rows[0]["SourceEnd"].ToString(); ContentStart = dt.Rows[0]["ContentStart"].ToString(); ContentEnd = dt.Rows[0]["ContentEnd"].ToString(); RemoveBodyStart = dt.Rows[0]["RemoveBodyStart"].ToString(); RemoveBodyEnd = dt.Rows[0]["RemoveBodyEnd"].ToString(); NextPageRegex = dt.Rows[0]["NextPageRegex"].ToString(); ItemName = dt.Rows[0]["ItemName"].ToString(); ClassId = dt.Rows[0]["ClassId"].ToString(); WebEncode = dt.Rows[0]["WebEncode"].ToString(); WebName = dt.Rows[0]["WebName"].ToString(); WebUrl = dt.Rows[0]["WebUrl"].ToString(); ItemRemark = dt.Rows[0]["ItemRemark"].ToString(); CollecNum = Convert.ToInt32(dt.Rows[0]["CollecNum"].ToString()); IsSaveImg = Convert.ToInt32(dt.Rows[0]["IsSaveImg"].ToString()); IsDesc = Convert.ToInt32(dt.Rows[0]["IsDesc"].ToString()); Script_Iframe = Convert.ToInt32(dt.Rows[0]["Script_Iframe"].ToString()); Script_A = Convert.ToInt32(dt.Rows[0]["Script_A"].ToString()); Script_Div = Convert.ToInt32(dt.Rows[0]["Script_Div"].ToString()); Script_Font = Convert.ToInt32(dt.Rows[0]["Script_Font"].ToString()); Script_Html = Convert.ToInt32(dt.Rows[0]["Script_Html"].ToString()); Script_Img = Convert.ToInt32(dt.Rows[0]["Script_Img"].ToString()); Script_Object = Convert.ToInt32(dt.Rows[0]["Script_Object"].ToString()); Script_Script = Convert.ToInt32(dt.Rows[0]["Script_Script"].ToString()); Script_Span = Convert.ToInt32(dt.Rows[0]["Script_Span"].ToString()); Script_Table = Convert.ToInt32(dt.Rows[0]["Script_Table"].ToString()); } } }
protected void BtnAdd_Click(object sender, EventArgs e) { TPortalClass.JpCollect_box JpCollect_box = new TPortalClass.JpCollect_box(); int Script_Iframe = 0, Script_Object = 0, Script_Script = 0, Script_Div = 0, Script_Table = 0, Script_Span = 0; int Script_Img = 0, Script_Font = 0, Script_A = 0, Script_Html = 0, IsSaveImg = 0, IsDesc = 0; if (this.ChkIframe.Checked) { Script_Iframe = 1; } if (this.ChkObject.Checked) { Script_Object = 1; } if (this.ChkScript.Checked) { Script_Script = 1; } if (this.ChkDiv.Checked) { Script_Div = 1; } if (this.ChkTable.Checked) { Script_Table = 1; } if (this.ChkSpan.Checked) { Script_Span = 1; } if (this.ChkImg.Checked) { Script_Img = 1; } if (this.ChkFont.Checked) { Script_Font = 1; } if (this.ChkA.Checked) { Script_A = 1; } if (this.ChkHtml.Checked) { Script_Html = 1; } if (this.ChkSaveImg.Checked) { IsSaveImg = 1; } if (this.ChkIsDesc.Checked) { IsDesc = 1; } string ls_url = ""; JpCollect_box.ItemName = TxtItemName.Text; JpCollect_box.ClassId = ddl1.SelectedItem.Value; JpCollect_box.WebEncode = DdlEndoce.SelectedValue; JpCollect_box.WebName = TxtWebName.Text; JpCollect_box.WebUrl = TxtWebUrl.Text; JpCollect_box.ItemRemark = TxtItemRemark.Text; JpCollect_box.Script_Iframe = Script_Iframe; JpCollect_box.Script_Object = Script_Object; JpCollect_box.Script_Script = Script_Script; JpCollect_box.Script_Div = Script_Div; JpCollect_box.Script_Table = Script_Table; JpCollect_box.Script_Span = Script_Span; JpCollect_box.Script_Img = Script_Img; JpCollect_box.Script_Font = Script_Font; JpCollect_box.Script_A = Script_A; JpCollect_box.Script_Html = Script_Html; JpCollect_box.IsSaveImg = IsSaveImg; JpCollect_box.IsDesc = IsDesc; JpCollect_box.CollecNum = int.Parse(TxtCollecNum.Text); if (Request.QueryString["id"] == "8888") { //新建 //Response.Write("<script>alert('采集基本信息填写111111111111111');</script>"); JpCollect_box.Insert(); //sql = "insert into JpCollect_box (ItemName,ClassId,WebEncode,WebName,WebUrl,ItemRemark,Script_Iframe"; //sql += ",Script_Object,Script_Script,Script_Div,Script_Table,Script_Span,Script_Img,Script_Font"; //sql += ",Script_A,Script_Html,IsSaveImg,IsDesc,CollecNum) values ("; //sql += "'" + TxtItemName.Text + "','" + ddl1.SelectedItem.Value + "','" + DdlEndoce.SelectedValue + "','" + TxtWebName.Text + "','" + TxtWebUrl.Text + "','" + TxtItemRemark.Text + "','" + Script_Iframe.ToString() + "'"; //sql += ",'" + Script_Object.ToString() + "','" + Script_Script.ToString() + "','" + Script_Div.ToString() + "','" + Script_Table.ToString() + "','" + Script_Span.ToString() + "','" + Script_Img.ToString() + "','" + Script_Font.ToString() + "'"; //sql += ",'" + Script_A.ToString() + "','" + Script_Html.ToString() + "','" + IsSaveImg.ToString() + "','" + IsDesc.ToString() + "','" + TxtCollecNum.Text + "'"; //sql += ")"; //db.Execute(sql); //得到最大的ID //string ls_maxid = ""; ////string ls_sql = "select max(Id) as maxid from JpCollect_box"; //DataTable dt1 = JpCollect_box.GetMaxID(); //if (dt1.Rows.Count > 0) //{ // ls_maxid = JpCollect_box.GetMaxID(); //} ls_url = "list_collect_box.aspx?action=list&id=" + JpCollect_box.GetMaxID(); } else { //修改 JpCollect_box.Id = int.Parse(this.txtId.Text); JpCollect_box.UpdateCjjbxx(); //sql = "update JpCollect_box set ItemName='" + TxtItemName.Text + "',ClassId='" + ddl1.SelectedItem.Value + "',WebEncode='" + DdlEndoce.SelectedValue + "'"; //sql += ",WebName='" + TxtWebName.Text + "',WebUrl='" + TxtWebUrl.Text + "',ItemRemark='" + TxtItemRemark.Text + "'"; //sql += ",Script_Iframe='" + Script_Iframe + "',Script_Object='" + Script_Object + "',Script_Script='" + Script_Script + "'"; //sql += ",Script_Div='" + Script_Div + "',Script_Table='" + Script_Table + "',Script_Span='" + Script_Span + "'"; //sql += ",Script_Img='" + Script_Img + "',Script_Font='" + Script_Font + "',Script_A='" + Script_A + "'"; //sql += ",Script_Html='" + Script_Html + "',IsSaveImg='" + IsSaveImg + "',IsDesc='" + IsDesc + "'"; //sql += ",CollecNum='" + TxtCollecNum.Text + "' where id=" + this.txtId.Text; //db.Execute(sql); ls_url = "list_collect_box.aspx?action=list&id=" + this.txtId.Text; } Response.Write("<script>alert('采集基本信息填写完成!');window.location='" + ls_url + "';</script>"); }
protected void GvCollItemList_RowDeleting(object sender, GridViewDeleteEventArgs e) { int Id = Convert.ToInt32(GvCollItemList.DataKeys[e.RowIndex].Value); TPortalClass.JpCollect_box JpCollect_box = new TPortalClass.JpCollect_box(); JpCollect_box.Id = Id; JpCollect_box.Delete(); //string sql = "delete from JpCollect_box where id=" + Id; //db.Execute(sql); //db.Close(); GetCollItemList(); }
//通过测试 设置采集状态为“可采集” protected void BtnTestOK_Click(object sender, EventArgs e) { TPortalClass.JpCollect_box JpCollect_box = new TPortalClass.JpCollect_box(); JpCollect_box.Id = int.Parse(this.txtId.Text); JpCollect_box.UpdateCjnrcs(); //string sql = "update JpCollect_box set State='0' where id=" + this.txtId.Text; //db.Execute(sql); //db.Close(); Response.Write("<script>alert('采集内容测试');window.location='list_collect_box.aspx';</script>"); }
//列表内容更新 protected void BtnList_Click(object sender, EventArgs e) { TPortalClass.JpCollect_box JpCollect_box = new TPortalClass.JpCollect_box(); JpCollect_box.ListUrl = this.TxtListUrl.Text.Trim(); JpCollect_box.ListStart = this.TxtListStart.Text.Trim(); JpCollect_box.ListEnd = this.TxtListEnd.Text.Trim(); JpCollect_box.Id = int.Parse(this.txtId.Text); JpCollect_box.UpdateCjlb(); //string sql = "update JpCollect_box set ListUrl='" + this.TxtListUrl.Text.Trim() + "',ListStart='" + this.TxtListStart.Text.Trim() + "',ListEnd='" + this.TxtListEnd.Text.Trim() + "'"; //sql += " where id=" + this.txtId.Text; //db.Execute(sql); //db.Close(); //string ls_url = "list_collect_box.aspx?action=link&id=" + this.txtId.Text; string ls_url = "list_collect_box.aspx"; Response.Write("<script>alert('采集列表填写完成!');window.location='" + ls_url + "';</script>"); }
//内容TxtRemoveTitle protected void BtnContent_Click(object sender, EventArgs e) { TPortalClass.JpCollect_box JpCollect_box = new TPortalClass.JpCollect_box(); JpCollect_box.TitleStart = this.TxtTitleStart.Text.Trim(); JpCollect_box.TitleEnd = this.TxtTitleEnd.Text.Trim(); JpCollect_box.RemoveTitle = this.TxtRemoveTitle.Text.Trim(); JpCollect_box.KeyWordStart = this.TxtKeyWordStart.Text.Trim(); JpCollect_box.KeyWordEnd = this.TxtKeyWordEnd.Text.Trim(); //JpCollect_box.DateRegex = this.TxtDateRegex.Text.Trim(); //JpCollect_box.SourceRegex = this.TxtSourceRegex.Text.Trim(); JpCollect_box.DateStart = this.TxtDateStart.Text; JpCollect_box.SourceStart = this.TxtSourceStart.Text; JpCollect_box.DateEnd = this.TxtDateEnd.Text; JpCollect_box.SourceEnd = this.TxtSourceEnd.Text; JpCollect_box.ContentStart = this.TxtContentStart.Text.Trim(); JpCollect_box.ContentEnd = this.TxtContentEnd.Text.Trim(); JpCollect_box.RemoveBodyStart = this.TxtRemoveBodyStart.Text.Trim(); JpCollect_box.RemoveBodyEnd = this.TxtRemoveBodyEnd.Text.Trim(); JpCollect_box.NextPageRegex = this.TxtNextPageRegex.Text.Trim(); JpCollect_box.Id = int.Parse(this.txtId.Text); JpCollect_box.UpdateCjnr(); //string sql = "update JpCollect_box set TitleStart='" + this.TxtTitleStart.Text.Trim() + "',TitleEnd='" + this.TxtTitleEnd.Text.Trim() + "'"; //sql += ",RemoveTitle='" + this.TxtRemoveTitle.Text.Trim() + "',KeyWordStart='" + this.TxtKeyWordStart.Text.Trim() + "'"; //sql += ",KeyWordEnd='" + this.TxtKeyWordEnd.Text.Trim() + "',DateRegex='" + this.TxtDateRegex.Text.Trim() + "'"; //sql += ",SourceRegex='" + this.TxtSourceRegex.Text.Trim() + "',ContentStart='" + this.TxtContentStart.Text.Trim() + "'"; //sql += ",ContentEnd='" + this.TxtContentEnd.Text.Trim() + "',RemoveBodyStart='" + this.TxtRemoveBodyStart.Text.Trim() + "'"; //sql += ",RemoveBodyEnd='" + this.TxtRemoveBodyEnd.Text.Trim() + "',NextPageRegex='" + this.TxtNextPageRegex.Text.Trim() + "'"; //sql += " where id=" + this.txtId.Text; //db.Execute(sql); //db.Close(); string ls_url = "list_collect_box.aspx?action=test&id=" + this.txtId.Text; Response.Write("<script>alert('采集内容填写完成!');window.location='" + ls_url + "';</script>"); }