/// <summary>
/// 调用存储过程增加一个
/// </summary>
/// <param name="info">实体对象</param>
/// <returns>正常返回大于 0 的自增id, 0代表重复，否则返回-1</returns>
public static int ArticleAdd(Entity.Article info)
{
SqlParameter[] prams =
{
SqlDB.MakeInParam("@CategoryId", SqlDbType.Int, 4, info.CategoryId),
SqlDB.MakeInParam("@Icon", SqlDbType.NVarChar, 200, info.Icon),
SqlDB.MakeInParam("@Title", SqlDbType.NVarChar, 200, info.Title),
SqlDB.MakeInParam("@ShortTitle", SqlDbType.NVarChar, 200, info.ShortTitle),
SqlDB.MakeInParam("@MetaTitle", SqlDbType.NVarChar, 200, info.MetaTitle),
SqlDB.MakeInParam("@MetaKeyWords", SqlDbType.NVarChar, 500, info.MetaKeyWords),
SqlDB.MakeInParam("@MetaDescription", SqlDbType.NVarChar, 300, info.MetaDescription),
SqlDB.MakeInParam("@Summary", SqlDbType.NVarChar, 2000, info.Summary),
SqlDB.MakeInParam("@Content", SqlDbType.NVarChar, 0, info.Content),
SqlDB.MakeInParam("@IsPause", SqlDbType.Int, 4, info.IsPause),
SqlDB.MakeInParam("@IsTuiJian", SqlDbType.Int, 4, info.IsTuiJian),
SqlDB.MakeInParam("@IsNew", SqlDbType.Int, 4, info.IsNew),
SqlDB.MakeInParam("@IsZhiDing", SqlDbType.Int, 4, info.IsZhiDing),
SqlDB.MakeInParam("@ZhiDingTime", SqlDbType.DateTime, 8, info.ZhiDingTime),
SqlDB.MakeInParam("@PublishTime", SqlDbType.DateTime, 8, info.PublishTime),
SqlDB.MakeInParam("@AddTime", SqlDbType.DateTime, 8, info.AddTime),
SqlDB.MakeInParam("@AddWid", SqlDbType.Int, 4, info.AddWid),
SqlDB.MakeInParam("@IsCheck", SqlDbType.Int, 4, info.IsCheck),
SqlDB.MakeInParam("@CheckTime", SqlDbType.DateTime, 8, info.CheckTime),
SqlDB.MakeInParam("@CheckWid", SqlDbType.Int, 4, info.CheckWid),
SqlDB.MakeInParam("@ClickNum", SqlDbType.Int, 4, info.ClickNum),
};
return(Basic.Utils.StrToInt(SqlDB.ExecuteScalar(CommandType.StoredProcedure, "ArticleAdd", prams).ToString(), -1));
}
/// <summary>
/// 暂停该值
/// </summary>
/// <param name="Id">自增id的值</param>
/// <returns>暂停成功返回ture，否则返回false</returns>
public static bool ArticlePause(Entity.Article info)
{
int intReturnValue = 0;
intReturnValue = SqlDB.ExecuteNonQuery(CommandType.Text, "UPDATE [Article] SET IsPause = " + info.IsPause + " WHERE Id = " + info.Id);
if (intReturnValue == 1)
{
return(true);
}
return(false);
}
public void Update_Article(int p_Article_ID, int p_Article_ClassID, int p_Article_LanguageID, string p_Article_Content)
{
Entity.Article e_Article = new Entity.Article();
e_Article.Article_ID = p_Article_ID;
e_Article.Article_ClassID = p_Article_ClassID;
e_Article.Article_LanguageID = p_Article_LanguageID;
e_Article.Article_Content = FilterUtility.FilterSQL(p_Article_Content);
e_Article.Article_AddTime = DateTime.Now;
d_Article.Update_Article(e_Article);
}
public Entity.Article Select_Article(int p_Article_ClassID, int p_Article_LanguageID)
{
DataTable o_DataTable = d_Article.Select_Article(p_Article_ClassID, p_Article_LanguageID);
if (o_DataTable == null)
return null;
else
{
Entity.Article e_Article = new Entity.Article();
e_Article.Article_ID = Convert.ToInt32(o_DataTable.Rows[0]["Article_ID"].ToString());
e_Article.Article_ClassID = Convert.ToInt32(o_DataTable.Rows[0]["Article_ClassID"].ToString());
e_Article.Article_LanguageID = Convert.ToInt32(o_DataTable.Rows[0]["Article_LanguageID"].ToString());
e_Article.Article_Content = o_DataTable.Rows[0]["Article_Content"].ToString();
e_Article.Article_AddTime = DateTime.Parse(o_DataTable.Rows[0]["Article_AddTime"].ToString());
return e_Article;
}
}
/// <summary>
/// 获取某一个实体
/// </summary>
/// <param name="Id">标识</param>
/// <returns>返回Entity</returns>
public static Entity.Article ArticleEntityGet(int Id)
{
Entity.Article info = new Entity.Article();
DataTable dt = SqlDB.ExecuteDataset(CommandType.Text, "SELECT * FROM [Article] WHERE Id = " + Id + ";").Tables[0];
if (dt.Rows.Count > 0)
{
info.Id = Basic.Utils.StrToInt(dt.Rows[0]["Id"].ToString(), 0);
info.CategoryId = Basic.Utils.StrToInt(dt.Rows[0]["CategoryId"].ToString(), 0);
info.Icon = dt.Rows[0]["Icon"].ToString();
info.Title = dt.Rows[0]["Title"].ToString();
info.ShortTitle = dt.Rows[0]["ShortTitle"].ToString();
info.MetaTitle = dt.Rows[0]["MetaTitle"].ToString();
info.MetaKeyWords = dt.Rows[0]["MetaKeyWords"].ToString();
info.MetaDescription = dt.Rows[0]["MetaDescription"].ToString();
info.Summary = dt.Rows[0]["Summary"].ToString();
info.Content = dt.Rows[0]["Content"].ToString();
info.IsPause = Basic.Utils.StrToInt(dt.Rows[0]["IsPause"].ToString(), 0);
info.IsTuiJian = Basic.Utils.StrToInt(dt.Rows[0]["IsTuiJian"].ToString(), 0);
info.IsNew = Basic.Utils.StrToInt(dt.Rows[0]["IsNew"].ToString(), 0);
info.IsZhiDing = Basic.Utils.StrToInt(dt.Rows[0]["IsZhiDing"].ToString(), 0);
info.AddWid = Basic.Utils.StrToInt(dt.Rows[0]["AddWid"].ToString(), 0);
info.IsCheck = Basic.Utils.StrToInt(dt.Rows[0]["IsCheck"].ToString(), 0);
info.CheckWid = Basic.Utils.StrToInt(dt.Rows[0]["CheckWid"].ToString(), 0);
info.ClickNum = Basic.Utils.StrToInt(dt.Rows[0]["ClickNum"].ToString(), 0);
info.AddTime = Basic.Utils.StrToDateTime(dt.Rows[0]["AddTime"].ToString());
info.CheckTime = Basic.Utils.StrToDateTime(dt.Rows[0]["CheckTime"].ToString());
info.PublishTime = Basic.Utils.StrToDateTime(dt.Rows[0]["PublishTime"].ToString());
info.ZhiDingTime = Basic.Utils.StrToDateTime(dt.Rows[0]["ZhiDingTime"].ToString());
return(info);
}
else
{
return(null);
}
}
/// <summary>
/// 调用存储过程修改一个
/// </summary>
/// <param name="info">实体对象</param>
/// <returns>更新成功返回ture，否则返回false</returns>
public static bool ArticleEdit(Entity.Article info)
{
SqlParameter[] prams =
{
SqlDB.MakeInParam("@Id", SqlDbType.Int, 4, info.Id),
SqlDB.MakeInParam("@CategoryId", SqlDbType.Int, 4, info.CategoryId),
SqlDB.MakeInParam("@Icon", SqlDbType.NVarChar, 200, info.Icon),
SqlDB.MakeInParam("@Title", SqlDbType.NVarChar, 200, info.Title),
SqlDB.MakeInParam("@ShortTitle", SqlDbType.NVarChar, 200, info.ShortTitle),
SqlDB.MakeInParam("@MetaTitle", SqlDbType.NVarChar, 200, info.MetaTitle),
SqlDB.MakeInParam("@MetaKeyWords", SqlDbType.NVarChar, 500, info.MetaKeyWords),
SqlDB.MakeInParam("@MetaDescription", SqlDbType.NVarChar, 300, info.MetaDescription),
SqlDB.MakeInParam("@Summary", SqlDbType.NVarChar, 2000, info.Summary),
SqlDB.MakeInParam("@Content", SqlDbType.NVarChar, 0, info.Content),
SqlDB.MakeInParam("@IsPause", SqlDbType.Int, 4, info.IsPause),
SqlDB.MakeInParam("@IsTuiJian", SqlDbType.Int, 4, info.IsTuiJian),
SqlDB.MakeInParam("@IsNew", SqlDbType.Int, 4, info.IsNew),
SqlDB.MakeInParam("@IsZhiDing", SqlDbType.Int, 4, info.IsZhiDing),
SqlDB.MakeInParam("@ZhiDingTime", SqlDbType.DateTime, 8, info.ZhiDingTime),
SqlDB.MakeInParam("@PublishTime", SqlDbType.DateTime, 8, info.PublishTime),
SqlDB.MakeInParam("@AddTime", SqlDbType.DateTime, 8, info.AddTime),
SqlDB.MakeInParam("@AddWid", SqlDbType.Int, 4, info.AddWid),
SqlDB.MakeInParam("@IsCheck", SqlDbType.Int, 4, info.IsCheck),
SqlDB.MakeInParam("@CheckTime", SqlDbType.DateTime, 8, info.CheckTime),
SqlDB.MakeInParam("@CheckWid", SqlDbType.Int, 4, info.CheckWid),
SqlDB.MakeInParam("@ClickNum", SqlDbType.Int, 4, info.ClickNum),
};
int intReturnValue = 0;
intReturnValue = SqlDB.ExecuteNonQuery(CommandType.StoredProcedure, "ArticleEdit", prams);
if (intReturnValue == 1)
{
return(true);
}
return(false);
}
private int InsertIntoArticle(DataAccess dac, Article art, Catch info)
{
//插入数据库
var counter = 0;
try
{
counter = dac.ExecuteNonQuery(DataAccess.ConnManagementMode.Manual, false,
@"DECLARE @article_id INT
SELECT @article_id = id
FROM dbo.sf_Article
WHERE url = @url
OR title = @title
IF @article_id IS NULL
BEGIN
INSERT INTO [sf_Article]
( [guid] ,
[title] ,
[body] ,
[site] ,
[url] ,
[publish_time] ,
[create_time]
)
VALUES ( @guid ,
@title ,
@body ,
@site ,
@url ,
@publish_time ,
@create_time
)
SET @article_id = SCOPE_IDENTITY()
END
ELSE
BEGIN
UPDATE [sf_Article]
SET [guid]=@guid ,
[title]=@title ,
[body] =@body ,
[site] =@site ,
[url]=@url ,
[publish_time] =@publish_time ,
[create_time]=@create_time
WHERE id=@article_id
END
IF NOT EXISTS ( SELECT 1
FROM dbo.sf_Map_ArtCls
WHERE article_id = @article_id
AND class_id = @class_id )
BEGIN
INSERT INTO [sf_Map_ArtCls]
( [guid] ,
[article_id] ,
[class_id] ,
[display_order]
)
VALUES ( @guid2 ,
@article_id ,
@class_id ,
@display_order
)
END
",
dac.CreateParameter("@guid", art.Guid), dac.CreateParameter("@title", art.Title),
dac.CreateParameter("@body", art.Body), dac.CreateParameter("@site", art.Site),
dac.CreateParameter("@url", art.Url), dac.CreateParameter("@publish_time", art.PublishTime),
dac.CreateParameter("@create_time", art.CreateTime),
dac.CreateParameter("@guid2", Guid.NewGuid()), dac.CreateParameter("@class_id", info.ClassId),
dac.CreateParameter("@display_order", 0));
}
catch
{
counter = 0;
}
if (counter < 0)
counter = 0;
return counter;
}
private int CreateArticleIndex(Article art)
{
int createcount=0;
try
{
StockFooAnalyzer analyzer = new StockFooAnalyzer(System.Configuration.ConfigurationManager.AppSettings["AnalyzerPath"].ToString());
FSDirectory dy = FSDirectory.Open(new DirectoryInfo(System.Configuration.ConfigurationManager.AppSettings["IndexDirectory"].ToString()));
IndexWriter writer = new IndexWriter(dy, analyzer, false, IndexWriter.MaxFieldLength.LIMITED);
AddDocument(writer, art.Title, art.Url, art.Site, art.Body.Length>300?art.Body.Substring(0,300):art.Body, art.PublishTime.ToString());
writer.Optimize();
writer.Close();
createcount = 1;
}
catch
{
createcount = 0;
}
return createcount;
}
