public static int GetPageData(out DataTable tb, string tableName, string keyField, int PageSize, int PageIndex, string queryCondition, string sortExp, string fieldList)
{
/*
* @table nvarchar(50),
* @keyField nvarchar(50),
* @sortExp nvarchar(50),
* @fieldList nvarchar(255),
* @queryCondition nvarchar(255),
* @PageSize int,
* @PageIndex int,
* @recsCount int OUTPUT
*/
SqlParameter[] prams =
{
SqlParameterHelper.MakeInParam("@table", SqlDbType.NVarChar, 0, tableName),
SqlParameterHelper.MakeInParam("@keyField", SqlDbType.NVarChar, 0, keyField),
SqlParameterHelper.MakeInParam("@sortExp", SqlDbType.NVarChar, 0, sortExp),
SqlParameterHelper.MakeInParam("@fieldList", SqlDbType.NVarChar, 0, fieldList),
SqlParameterHelper.MakeInParam("@queryCondition", SqlDbType.NVarChar, 0, queryCondition),
SqlParameterHelper.MakeInParam("@PageSize", SqlDbType.Int, 0, PageSize),
SqlParameterHelper.MakeInParam("@PageIndex", SqlDbType.Int, 0, PageIndex),
SqlParameterHelper.MakeParam("@recsCount", SqlDbType.Int, 0, ParameterDirection.Output, null)
};
DataSet ds;
Database.RunProc("pageList", prams, out ds);
tb = ds.Tables[0];
int recCount = Convert.ToInt32(prams[prams.Length - 1].Value);
return(recCount);
}
/// <summary>
/// 获取收藏夹的分页数据
/// </summary>
/// <param name="tb">输出的数据表</param>
/// <param name="PageSize">页尺寸</param>
/// <param name="PageIndex">页索引</param>
/// <param name="queryCondition">查询条件</param>
/// <param name="sortExp">排序表达式如： ID ASC</param>
/// <param name="fieldList">查询的字段列表</param>
/// <returns>记录总数</returns>
public int GetPageData(out DataTable tb, int PageSize, int PageIndex, string queryCondition, string sortExp, string fieldList)
{
/*
* @fields varchar(512),
* @where varchar(200),
* @OrderExp varchar(50),
* @pageIndex int,
* @pageSize int,
* @RecsCount int output
*/
SqlParameter[] prams =
{
SqlParameterHelper.MakeInParam("@OrderExp", SqlDbType.NVarChar, 0, sortExp),
SqlParameterHelper.MakeInParam("@fields", SqlDbType.NVarChar, 0, fieldList),
SqlParameterHelper.MakeInParam("@where", SqlDbType.NVarChar, 0, queryCondition),
SqlParameterHelper.MakeInParam("@pageSize", SqlDbType.Int, 0, PageSize),
SqlParameterHelper.MakeInParam("@pageIndex", SqlDbType.Int, 0, PageIndex),
SqlParameterHelper.MakeParam("@RecsCount", SqlDbType.Int, 0, ParameterDirection.Output, null)
};
DataSet ds;
Database.RunProc("[knowdba].MyCollector_GetPageData", prams, out ds);
tb = ds.Tables[0];
int recCount = Convert.ToInt32(prams[prams.Length - 1].Value);
return(recCount);
}
public int UpdateByID(XBase.Model.KnowledgeCenter.KnowledgeWarehouse entity)
{
SqlParameter[] parameters = new SqlParameter[] {
SqlParameterHelper.MakeInParam("@ID", SqlDbType.Int, 0, entity.ID),
SqlParameterHelper.MakeInParam("@KnowledgeNo", SqlDbType.VarChar, 50, entity.KnowledgeNo),
SqlParameterHelper.MakeInParam("@Flag", SqlDbType.Char, 1, entity.Flag),
SqlParameterHelper.MakeInParam("@TypeID", SqlDbType.Int, 0, entity.TypeID),
SqlParameterHelper.MakeInParam("@Title", SqlDbType.VarChar, 100, entity.Title),
SqlParameterHelper.MakeInParam("@Keyword", SqlDbType.VarChar, 100, entity.Keyword),
SqlParameterHelper.MakeInParam("@Content", SqlDbType.NText, 0, entity.Content),
SqlParameterHelper.MakeInParam("@IsShow", SqlDbType.Char, 1, entity.IsShow),
SqlParameterHelper.MakeInParam("@SourceFrom", SqlDbType.Char, 1, entity.SourceFrom),
SqlParameterHelper.MakeInParam("@SafeLevel", SqlDbType.Char, 1, entity.SafeLevel),
SqlParameterHelper.MakeInParam("@Author", SqlDbType.VarChar, 50, entity.Author),
SqlParameterHelper.MakeInParam("@Attachment", SqlDbType.VarChar, 200, entity.Attachment),
SqlParameterHelper.MakeInParam("@CreateUserID", SqlDbType.VarChar, 20, entity.CreateUserID),
SqlParameterHelper.MakeInParam("@CreateDate", SqlDbType.DateTime, 0, entity.CreateDate),
SqlParameterHelper.MakeInParam("@ModifiedDate", SqlDbType.DateTime, 0, entity.ModifiedDate),
SqlParameterHelper.MakeInParam("@ModifiedUserID", SqlDbType.VarChar, 20, entity.ModifiedUserID),
SqlParameterHelper.MakeInParam("@ReadTimes", SqlDbType.Int, 0, entity.ReadTimes),
SqlParameterHelper.MakeInParam("@DownloadTimes", SqlDbType.Int, 0, entity.DownloadTimes)
};
int result;
Database.RunProc("[knowdba].KnowledgeWarehouse_UpdateByID", parameters, out result);
return(result);
}
/// <summary>
/// GetCompanyOpenServ
/// </summary>
/// <param name="companyCD">公司</param>
/// <returns></returns>
public DataSet GetCompanyOpenServ(string companyCD)
{
SqlParameter[] parameters = new SqlParameter[] {
SqlParameterHelper.MakeInParam("@CompanyCD", SqlDbType.VarChar, 200, companyCD)
};
string sql = "SELECT * FROM [pubdba].[companyOpenServ] WHERE [CompanyCD]=@CompanyCD";
return(Database.RunSql(sql, parameters));
}
public void SubscribeSend(DateTime LastEndDate)
{
SqlParameter[] prams =
{
SqlParameterHelper.MakeInParam("@LastEndDate", SqlDbType.DateTime, 0, LastEndDate)
};
Database.RunProc("[knowdba].SubscribeSend", prams);
}
public int GetCount(string where)
{
SqlParameter[] parameters = new SqlParameter[] {
SqlParameterHelper.MakeInParam("@where", SqlDbType.VarChar, 200, where),
SqlParameterHelper.MakeParam("@RecCount", SqlDbType.Int, 0, ParameterDirection.Output, null)
};
Database.RunProc("[knowdba].KnowledgeType_GetCount", parameters);
return(Convert.ToInt32(parameters[parameters.Length - 1].Value));
}
public int DeleteByID(int iD)
{
SqlParameter[] parameters = new SqlParameter[] {
SqlParameterHelper.MakeInParam("@ID", SqlDbType.Int, 0, iD)
};
int result;
Database.RunProc("[knowdba].KnowledgeType_DeleteByID", parameters, out result);
return(result);
}
public DataSet SelectWhereOrderedEx(string Where, string OrderExp, string Fields)
{
SqlParameter[] parameters = new SqlParameter[] {
SqlParameterHelper.MakeInParam("@Where", SqlDbType.VarChar, 200, Where)
, SqlParameterHelper.MakeInParam("@OrderExp", SqlDbType.VarChar, 100, OrderExp)
, SqlParameterHelper.MakeInParam("@Fields", SqlDbType.VarChar, 300, Fields)
};
DataSet ds;
Database.RunProc("[knowdba].KnowledgeType_SelectWhereOrderedEx", parameters, out ds);
return(ds);
}
public DataSet SelectWhereOrderedTopNEx(string Where, string OrderExp, int Num, string Fields)
{
SqlParameter[] parameters = new SqlParameter[] {
SqlParameterHelper.MakeInParam("@Where", SqlDbType.VarChar, 200, Where)
, SqlParameterHelper.MakeInParam("@OrderExp", SqlDbType.VarChar, 100, OrderExp)
, SqlParameterHelper.MakeInParam("@Num", SqlDbType.Int, 0, Num)
, SqlParameterHelper.MakeInParam("@Fields", SqlDbType.VarChar, 300, Fields)
};
DataSet ds;
Database.RunProc("[knowdba].MyCollector_SelectWhereOrderedTopNEx", parameters, out ds);
return(ds);
}
public bool Create(XBase.Model.KnowledgeCenter.KeyWordHistory entity)
{
SqlParameter[] parameters = new SqlParameter[] {
SqlParameterHelper.MakeInParam("@TypeID", SqlDbType.Int, 0, entity.TypeID),
SqlParameterHelper.MakeInParam("@KeyWordName", SqlDbType.VarChar, 100, entity.KeyWordName),
SqlParameterHelper.MakeInParam("@SearchTimes", SqlDbType.Int, 0, entity.SearchTimes),
SqlParameterHelper.MakeInParam("@LastDate", SqlDbType.DateTime, 0, entity.LastDate)
};
bool result;
Database.RunProc("[knowdba].KeyWordHistory_Create", parameters, out result);
return(result);
}
public bool Create(XBase.Model.KnowledgeCenter.KnowledgeType entity)
{
SqlParameter[] parameters = new SqlParameter[] {
SqlParameterHelper.MakeInParam("@Flag", SqlDbType.Char, 1, entity.Flag),
SqlParameterHelper.MakeInParam("@TypeName", SqlDbType.VarChar, 100, entity.TypeName),
SqlParameterHelper.MakeInParam("@SupperTypeID", SqlDbType.Int, 0, entity.SupperTypeID),
SqlParameterHelper.MakeInParam("@ModifiedDate", SqlDbType.DateTime, 0, entity.ModifiedDate),
SqlParameterHelper.MakeInParam("@ModifiedUserID", SqlDbType.VarChar, 20, entity.ModifiedUserID)
};
bool result;
Database.RunProc("[knowdba].KnowledgeType_Create", parameters, out result);
return(result);
}
/// <summary>
/// 自定义的关键字最大数量
/// </summary>
/// <param name="companyCD">公司</param>
/// <returns></returns>
public int GetMaxUserKeywordCount(string companyCD)
{
SqlParameter[] parameters = new SqlParameter[] {
SqlParameterHelper.MakeInParam("@CompanyCD", SqlDbType.VarChar, 200, companyCD)
};
string sql = "SELECT [MaxUserKeywords] FROM [pubdba].[companyOpenServ] WHERE [CompanyCD]=@CompanyCD";
DataSet ds = Database.RunSql(sql, parameters);
if (ds.Tables[0].Rows.Count == 0)
{
return(-1);
}
return(int.Parse(ds.Tables[0].Rows[0][0].ToString()));
}
public bool Create(XBase.Model.KnowledgeCenter.SubscribeHistory entity)
{
SqlParameter[] parameters = new SqlParameter[] {
SqlParameterHelper.MakeInParam("@CompanyCD", SqlDbType.VarChar, 8, entity.CompanyCD),
SqlParameterHelper.MakeInParam("@Receiver", SqlDbType.VarChar, 20, entity.Receiver),
SqlParameterHelper.MakeInParam("@KnowledgeID", SqlDbType.Int, 0, entity.KnowledgeID),
SqlParameterHelper.MakeInParam("@SendDate", SqlDbType.DateTime, 0, entity.SendDate),
SqlParameterHelper.MakeInParam("@KeyWordID", SqlDbType.VarChar, 50, entity.KeyWordID),
SqlParameterHelper.MakeInParam("@KeyWordName", SqlDbType.VarChar, 50, entity.KeyWordName)
};
bool result;
Database.RunProc("[knowdba].SubscribeHistory_Create", parameters, out result);
return(result);
}
public int UpdateByID(XBase.Model.KnowledgeCenter.KeyWordPrepare entity)
{
SqlParameter[] parameters = new SqlParameter[] {
SqlParameterHelper.MakeInParam("@ID", SqlDbType.Int, 0, entity.ID),
SqlParameterHelper.MakeInParam("@TypeID", SqlDbType.Int, 0, entity.TypeID),
SqlParameterHelper.MakeInParam("@KeyWordName", SqlDbType.VarChar, 100, entity.KeyWordName),
SqlParameterHelper.MakeInParam("@CreateUserID", SqlDbType.VarChar, 20, entity.CreateUserID),
SqlParameterHelper.MakeInParam("@CreateDate", SqlDbType.DateTime, 0, entity.CreateDate),
SqlParameterHelper.MakeInParam("@ModifiedDate", SqlDbType.DateTime, 0, entity.ModifiedDate),
SqlParameterHelper.MakeInParam("@ModifiedUserID", SqlDbType.VarChar, 20, entity.ModifiedUserID)
};
int result;
Database.RunProc("[knowdba].KeyWordPrepare_UpdateByID", parameters, out result);
return(result);
}
public bool Create(XBase.Model.KnowledgeCenter.KnowledgeRequire entity)
{
SqlParameter[] parameters = new SqlParameter[] {
SqlParameterHelper.MakeInParam("@CompanyCD", SqlDbType.VarChar, 8, entity.CompanyCD),
SqlParameterHelper.MakeInParam("@SendDate", SqlDbType.DateTime, 0, entity.SendDate),
SqlParameterHelper.MakeInParam("@SendUserID", SqlDbType.VarChar, 20, entity.SendUserID),
SqlParameterHelper.MakeInParam("@Content", SqlDbType.NVarChar, 200, entity.Content),
SqlParameterHelper.MakeInParam("@FeeBackStatus", SqlDbType.Char, 1, entity.FeeBackStatus),
SqlParameterHelper.MakeInParam("@FeeBackDate", SqlDbType.DateTime, 0, entity.FeeBackDate),
SqlParameterHelper.MakeInParam("@FeeBackUserID", SqlDbType.VarChar, 20, entity.FeeBackUserID)
};
bool result;
Database.RunProc("[knowdba].KnowledgeRequire_Create", parameters, out result);
return(result);
}
public XBase.Model.KnowledgeCenter.KnowledgeType GetEntityByID(int iD)
{
SqlParameter[] parameters = new SqlParameter[] {
SqlParameterHelper.MakeInParam("@ID", SqlDbType.Int, 0, iD)
};
XBase.Model.KnowledgeCenter.KnowledgeType entity = null;
SqlDataReader dr;
Database.RunProc("[knowdba].KnowledgeType_GetEntityByID", parameters, out dr);
if (dr.Read())
{
entity = GetEntity(dr);
}
dr.Close();
return(entity);
}
public bool Create(XBase.Model.KnowledgeCenter.MyKeyWord entity)
{
SqlParameter[] parameters = new SqlParameter[] {
SqlParameterHelper.MakeInParam("@CompanyCD", SqlDbType.VarChar, 8, entity.CompanyCD),
SqlParameterHelper.MakeInParam("@TypeID", SqlDbType.Int, 0, entity.TypeID),
SqlParameterHelper.MakeInParam("@KeyType", SqlDbType.Char, 1, entity.KeyType),
SqlParameterHelper.MakeInParam("@KeyWordID", SqlDbType.Int, 0, entity.KeyWordID),
SqlParameterHelper.MakeInParam("@KeyWordName", SqlDbType.VarChar, 100, entity.KeyWordName),
SqlParameterHelper.MakeInParam("@Creator", SqlDbType.VarChar, 20, entity.Creator),
SqlParameterHelper.MakeInParam("@CreateDate", SqlDbType.DateTime, 0, entity.CreateDate),
SqlParameterHelper.MakeInParam("@ModifiedDate", SqlDbType.DateTime, 0, entity.ModifiedDate),
SqlParameterHelper.MakeInParam("@ModifiedUserID", SqlDbType.VarChar, 20, entity.ModifiedUserID)
};
bool result;
Database.RunProc("[knowdba].MyKeyWord_Create", parameters, out result);
return(result);
}
public bool Create(XBase.Model.KnowledgeCenter.MyCollector entity)
{
SqlParameter[] parameters = new SqlParameter[] {
SqlParameterHelper.MakeInParam("@Flag", SqlDbType.Char, 1, entity.Flag),
SqlParameterHelper.MakeInParam("@KnowledgeID", SqlDbType.Int, 0, entity.KnowledgeID),
SqlParameterHelper.MakeInParam("@Owner", SqlDbType.VarChar, 20, entity.Owner),
SqlParameterHelper.MakeInParam("@SourceType", SqlDbType.Char, 1, entity.SourceType),
SqlParameterHelper.MakeInParam("@CreateDate", SqlDbType.DateTime, 0, entity.CreateDate),
SqlParameterHelper.MakeInParam("@ReadStatus", SqlDbType.Char, 1, entity.ReadStatus),
SqlParameterHelper.MakeInParam("@ReadDate", SqlDbType.DateTime, 0, entity.ReadDate),
SqlParameterHelper.MakeInParam("@ModifiedDate", SqlDbType.DateTime, 0, entity.ModifiedDate),
SqlParameterHelper.MakeInParam("@ModifiedUserID", SqlDbType.VarChar, 20, entity.ModifiedUserID)
};
bool result;
Database.RunProc("[knowdba].MyCollector_Create", parameters, out result);
return(result);
}
/// <summary>
/// 获取知识库的分页数据2
/// </summary>
/// <param name="tb">输出的数据表</param>
/// <param name="PageSize">页尺寸</param>
/// <param name="PageIndex">页索引</param>
/// <param name="queryCondition">查询条件</param>
/// <param name="sortExp">排序表达式如： ID ASC</param>
/// <param name="fieldList">查询的字段列表</param>
/// <returns>记录总数</returns>
public int GetPageData(out DataTable tb, int PageSize, int PageIndex, string queryCondition, string sortExp, string fieldList, int maxCount)
{
SqlParameter[] prams =
{
SqlParameterHelper.MakeInParam("@OrderExp", SqlDbType.NVarChar, 0, sortExp),
SqlParameterHelper.MakeInParam("@fields", SqlDbType.NVarChar, 0, fieldList),
SqlParameterHelper.MakeInParam("@where", SqlDbType.NVarChar, 0, queryCondition),
SqlParameterHelper.MakeInParam("@pageSize", SqlDbType.Int, 0, PageSize),
SqlParameterHelper.MakeInParam("@pageIndex", SqlDbType.Int, 0, PageIndex),
SqlParameterHelper.MakeInParam("@maxCount", SqlDbType.Int, 0, maxCount),
SqlParameterHelper.MakeParam("@RecsCount", SqlDbType.Int, 0, ParameterDirection.Output, null)
};
DataSet ds;
Database.RunProc("[knowdba].KnowledgeWarehouse_GetSearchPageData", prams, out ds);
tb = ds.Tables[0];
int recCount = Convert.ToInt32(prams[prams.Length - 1].Value);
return(recCount);
}
