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