private int InsertCatch(StockFoo.Entity.Catch ch)
{
int excutecount = 0;
string sql = @"DECLARE @ch_id INT
SELECT @ch_id = ID
FROM [sf_Catch]
WHERE catch_name = @catch_name
IF @ch_id IS NULL
BEGIN
INSERT INTO [sf_Catch]
([guid]
,[catch_name]
,[site_name]
,[site_encode]
,[classid]
,[catalog_url]
,[catalog_xpath]
,[catalog_regex]
,[article_xpath]
,[article_regex]
,[article_title_xpath]
,[article_title_regex]
,[article_time_xpath]
,[article_time_regex]
,[article_time_format]
,[enabled]
,[next_time]
,[timespan])
VALUES
(@guid
,@catch_name
,@site_name
,@site_encode
,@classid
,@catalog_url
,@catalog_xpath
,@catalog_regex
,@article_xpath
,@article_regex
,@article_title_xpath
,@article_title_regex
,@article_time_xpath
,@article_time_regex
,@article_time_format
,@enabled
,@next_time
,@timespan)
END";
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;
cmd.Parameters.AddWithValue("@guid", ch.Guid);
cmd.Parameters.AddWithValue("@catch_name", ch.CatchName);
cmd.Parameters.AddWithValue("@site_name", ch.SiteName);
cmd.Parameters.AddWithValue("@site_encode", ch.SiteEncode);
cmd.Parameters.AddWithValue("@classid", ch.ClassId);
cmd.Parameters.AddWithValue("@catalog_url", ch.CatalogUrl);
cmd.Parameters.AddWithValue("@catalog_xpath", ch.CatalogXPath);
cmd.Parameters.AddWithValue("@catalog_regex", ch.CatalogRegex);
cmd.Parameters.AddWithValue("@article_xpath", ch.ArticleXPath);
cmd.Parameters.AddWithValue("@article_regex", ch.ArticleRegex);
cmd.Parameters.AddWithValue("@article_title_xpath", ch.ArticleTitleXPath);
cmd.Parameters.AddWithValue("@article_title_regex", ch.ArticleTitleRegex);
cmd.Parameters.AddWithValue("@article_time_xpath", ch.ArticleTimeXPath);
cmd.Parameters.AddWithValue("@article_time_regex", ch.ArticleTimeRegex);
cmd.Parameters.AddWithValue("@article_time_format", ch.ArticleTimeFormat);
cmd.Parameters.AddWithValue("@enabled", ch.Enabled);
cmd.Parameters.AddWithValue("@next_time", ch.NextTime);
cmd.Parameters.AddWithValue("@timespan", ch.TimeSpan);
excutecount = cmd.ExecuteNonQuery();
}
return excutecount;
}
private int UpdateCatchByID(StockFoo.Entity.Catch ch)
{
int excutecount = 0;
string sql = @"UPDATE [sf_Catch]
SET
[catch_name] = @catch_name
,[site_name] = @site_name
,[site_encode] = @site_encode
,[classid] = @classid
,[catalog_url] = @catalog_url
,[catalog_xpath] = @catalog_xpath
,[catalog_regex] = @catalog_regex
,[article_xpath] = @article_xpath
,[article_regex] = @article_regex
,[article_title_xpath] = @article_title_xpath
,[article_title_regex] =@article_title_regex
,[article_time_xpath] = @article_time_xpath
,[article_time_regex] = @article_time_regex
,[article_time_format] = @article_time_format
,[enabled] = @enabled
,[next_time] = @next_time
,[timespan] = @timespan
WHERE [id]=@id
";
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;
cmd.Parameters.AddWithValue("@id", ch.Id);
cmd.Parameters.AddWithValue("@catch_name", ch.CatchName);
cmd.Parameters.AddWithValue("@site_name", ch.SiteName);
cmd.Parameters.AddWithValue("@site_encode", ch.SiteEncode);
cmd.Parameters.AddWithValue("@classid", ch.ClassId);
cmd.Parameters.AddWithValue("@catalog_url", ch.CatalogUrl);
cmd.Parameters.AddWithValue("@catalog_xpath", ch.CatalogXPath);
cmd.Parameters.AddWithValue("@catalog_regex", ch.CatalogRegex);
cmd.Parameters.AddWithValue("@article_xpath", ch.ArticleXPath);
cmd.Parameters.AddWithValue("@article_regex", ch.ArticleRegex);
cmd.Parameters.AddWithValue("@article_title_xpath", ch.ArticleTitleXPath);
cmd.Parameters.AddWithValue("@article_title_regex", ch.ArticleTitleRegex);
cmd.Parameters.AddWithValue("@article_time_xpath", ch.ArticleTimeXPath);
cmd.Parameters.AddWithValue("@article_time_regex", ch.ArticleTimeRegex);
cmd.Parameters.AddWithValue("@article_time_format", ch.ArticleTimeFormat);
cmd.Parameters.AddWithValue("@enabled", ch.Enabled);
cmd.Parameters.AddWithValue("@next_time", ch.NextTime);
cmd.Parameters.AddWithValue("@timespan", ch.TimeSpan);
excutecount = cmd.ExecuteNonQuery();
}
return excutecount;
}
