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