protected void bntUpdateCatch_Click(object sender, EventArgs e) { if (txtCatchName.Text.Equals("")) { txtCatchName.Focus(); return; } if (txtSiteName.Text.Equals("")) { txtSiteName.Focus(); return; } if (ddlClassID.SelectedItem.Value == "-1") { ddlClassID.Focus(); return; } try { DateTime dt = Convert.ToDateTime(txtNextTime.Text); } catch { txtNextTime.Focus(); return; } try { int temp = Convert.ToInt32(txtTimespan.Text); } catch { txtTimespan.Focus(); return; } StockFoo.Entity.Catch ch = new StockFoo.Entity.Catch(); ch.Id = Convert.ToInt32(Request["id"]); ch.CatchName = txtCatchName.Text; ch.SiteName = txtSiteName.Text; ch.SiteEncode = Convert.ToInt32(ddlSiteEncode.SelectedItem.Value); ch.ClassId = Convert.ToInt32(ddlClassID.SelectedItem.Value); ch.CatalogUrl = txtCatalogUrl.Text; ch.CatalogXPath = txtCatalogXPath.Text; ch.CatalogRegex = txtCatalogRegex.Text; ch.ArticleXPath = txtArticleXPath.Text; ch.ArticleRegex = txtArticleRegex.Text; ch.ArticleTitleXPath = txtArticleTitleXPath.Text; ch.ArticleTitleRegex = txtArticleTitleRegex.Text; ch.ArticleTimeXPath = txtArticleTimeXPath.Text; ch.ArticleTimeRegex = txtArticleTimeRegex.Text; ch.ArticleTimeFormat = txtArticleTimeFormat.Text; if (rblEnabled.SelectedItem.Value == "1") { ch.Enabled = true; } else { ch.Enabled = false; } ch.NextTime = Convert.ToDateTime(txtNextTime.Text); ch.TimeSpan = Convert.ToInt32(txtTimespan.Text); int insertcount = UpdateCatchByID(ch); if (insertcount > 0) { Page.RegisterStartupScript("ok", "<script>alert('更新成功!');window.location.href='UpdateCatch.aspx?id="+Request["id"].ToString()+"';</script>"); } else { Page.RegisterStartupScript("error", "<script>alert('更新失败!');</script>"); } }
protected void bntAddCatch_Click(object sender, EventArgs e) { if (txtCatchName.Text.Equals("")) { txtCatchName.Focus(); return; } if (txtSiteName.Text.Equals("")) { txtSiteName.Focus(); return; } if (ddlClassID.SelectedItem.Value == "-1") { ddlClassID.Focus(); return; } try { DateTime dt = Convert.ToDateTime(txtNextTime.Text); } catch { txtNextTime.Focus(); return; } try { int temp = Convert.ToInt32(txtTimespan.Text); } catch { txtTimespan.Focus(); return; } StockFoo.Entity.Catch ch = new StockFoo.Entity.Catch(); ch.Guid = Guid.NewGuid(); ch.CatchName = txtCatchName.Text; ch.SiteName = txtSiteName.Text; ch.SiteEncode =Convert.ToInt32(ddlSiteEncode.SelectedItem.Value); ch.ClassId = Convert.ToInt32(ddlClassID.SelectedItem.Value); ch.CatalogUrl = txtCatalogUrl.Text; ch.CatalogXPath = txtCatalogXPath.Text; ch.CatalogRegex = txtCatalogRegex.Text; ch.ArticleXPath = txtArticleXPath.Text; ch.ArticleRegex = txtArticleRegex.Text; ch.ArticleTitleXPath =txtArticleTitleXPath.Text; ch.ArticleTitleRegex = txtArticleTitleRegex.Text; ch.ArticleTimeXPath = txtArticleTimeXPath.Text; ch.ArticleTimeRegex = txtArticleTimeRegex.Text; ch.ArticleTimeFormat = txtArticleTimeFormat.Text; if (rblEnabled.SelectedItem.Value == "1") { ch.Enabled = true; } else { ch.Enabled = false; } ch.NextTime =Convert.ToDateTime(txtNextTime.Text); ch.TimeSpan = Convert.ToInt32(txtTimespan.Text); int insertcount = InsertCatch(ch); if (insertcount > 0) { Page.RegisterStartupScript("ok", "<script>alert('添加成功!');</script>"); } else { Page.RegisterStartupScript("error", "<script>alert('添加失败!');</script>"); } }
private StockFoo.Entity.Catch GetCatchByID(int id) { string sql = "select * from [sf_Catch] where id=" + id; StockFoo.Entity.Catch ch = null; string conStr = ConfigurationManager.ConnectionStrings["Default"].ConnectionString; using (SqlConnection conn = new SqlConnection(conStr)) { conn.Open(); SqlCommand cmd = conn.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = sql; SqlDataReader sdr = cmd.ExecuteReader(); sdr.Read(); ch = new StockFoo.Entity.Catch(); ch.Id =(int)sdr["id"]; ch.CatchName = sdr["catch_name"].ToString(); ch.SiteName = sdr["site_name"].ToString(); ch.SiteEncode = (int)sdr["site_encode"]; ch.ClassId = (int)sdr["classid"]; ch.CatalogUrl = sdr["catalog_url"].ToString(); ch.CatalogXPath = sdr["catalog_xpath"].ToString(); ch.CatalogRegex = sdr["catalog_regex"].ToString(); ch.ArticleXPath = sdr["article_xpath"].ToString(); ch.ArticleRegex = sdr["article_regex"].ToString(); ch.ArticleTitleXPath = sdr["article_title_xpath"].ToString(); ch.ArticleTitleRegex = sdr["article_title_regex"].ToString(); ch.ArticleTimeXPath = sdr["article_time_xpath"].ToString(); ch.ArticleTimeRegex = sdr["article_time_regex"].ToString(); ch.ArticleTimeFormat = sdr["article_time_format"].ToString(); ch.Enabled = (bool)sdr["enabled"]; ch.NextTime = (DateTime)sdr["next_time"]; ch.TimeSpan = Convert.ToInt32(sdr["timespan"]); } return ch; }