/// <summary> /// 根据标识符获取实例 /// </summary> /// <param name="pID">标识符的值</param> public ItemKnowledgeEntity GetByID(object pID) { //参数检查 if (pID == null) { return(null); } string id = pID.ToString(); //组织SQL StringBuilder sql = new StringBuilder(); sql.AppendFormat("select * from [ItemKnowledge] where ItemKnowledgeID='{0}' and IsDelete=0 ", id.ToString()); //读取数据 ItemKnowledgeEntity m = null; using (SqlDataReader rdr = this.SQLHelper.ExecuteReader(sql.ToString())) { while (rdr.Read()) { this.Load(rdr, out m); break; } } //返回 return(m); }
/// <summary> /// 在事务内创建一个新实例 /// </summary> /// <param name="pEntity">实体实例</param> /// <param name="pTran">事务实例,可为null,如果为null,则不使用事务来更新</param> public void Create(ItemKnowledgeEntity pEntity, IDbTransaction pTran) { //参数校验 if (pEntity == null) { throw new ArgumentNullException("pEntity"); } //初始化固定字段 pEntity.CreateTime = DateTime.Now; pEntity.CreateBy = CurrentUserInfo.UserID; pEntity.LastUpdateTime = pEntity.CreateTime.ToString(); pEntity.LastUpdateBy = CurrentUserInfo.UserID; pEntity.IsDelete = 0; StringBuilder strSql = new StringBuilder(); strSql.Append("insert into [ItemKnowledge]("); strSql.Append("[Item],[Content],[CreateTime],[CreateBy],[LastUpdateTime],[LastUpdateBy],[IsDelete],[ItemKnowledgeID])"); strSql.Append(" values ("); strSql.Append("@Item,@Content,@CreateTime,@CreateBy,@LastUpdateTime,@LastUpdateBy,@IsDelete,@ItemKnowledgeID)"); string pkString = pEntity.ItemKnowledgeID; SqlParameter[] parameters = { new SqlParameter("@Item", SqlDbType.NVarChar), new SqlParameter("@Content", SqlDbType.Text), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@CreateBy", SqlDbType.NVarChar), new SqlParameter("@LastUpdateTime", SqlDbType.NVarChar), new SqlParameter("@LastUpdateBy", SqlDbType.NVarChar), new SqlParameter("@IsDelete", SqlDbType.Int), new SqlParameter("@ItemKnowledgeID", SqlDbType.NVarChar) }; parameters[0].Value = pEntity.Item; parameters[1].Value = pEntity.Content; parameters[2].Value = pEntity.CreateTime; parameters[3].Value = pEntity.CreateBy; parameters[4].Value = pEntity.LastUpdateTime; parameters[5].Value = pEntity.LastUpdateBy; parameters[6].Value = pEntity.IsDelete; parameters[7].Value = pkString; //执行并将结果回写 int result; if (pTran != null) { result = this.SQLHelper.ExecuteNonQuery((SqlTransaction)pTran, CommandType.Text, strSql.ToString(), parameters); } else { result = this.SQLHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters); } pEntity.ItemKnowledgeID = pkString; }
/// <summary> /// 删除 /// </summary> /// <param name="pEntity">实体实例</param> /// <param name="pTran">事务实例,可为null,如果为null,则不使用事务来更新</param> public void Delete(ItemKnowledgeEntity pEntity, IDbTransaction pTran) { //参数校验 if (pEntity == null) { throw new ArgumentNullException("pEntity"); } if (pEntity.ItemKnowledgeID == null) { throw new ArgumentException("执行删除时,实体的主键属性值不能为null."); } //执行 this.Delete(pEntity.ItemKnowledgeID, pTran); }
/// <summary> /// 根据用户的微信公众平台唯一码获取知识 /// </summary> /// <param name="WeiXinUserId"></param> /// <returns></returns> public ItemKnowledgeEntity GetByWeiXinUserId(object WeiXinUserId) { //参数检查 if (WeiXinUserId == null) { return(null); } string id = WeiXinUserId.ToString(); //组织SQL StringBuilder sql = new StringBuilder(); sql.AppendFormat("select top 1 a.* from ItemKnowledge a inner join VipItemMapping b on(a.Item = b.Item) where b.WeiXinUserId = '{0}' and a.IsDelete=0 order by b.lastUpdateTime desc ", id.ToString()); //读取数据 ItemKnowledgeEntity m = null; using (SqlDataReader rdr = this.SQLHelper.ExecuteReader(sql.ToString())) { while (rdr.Read()) { this.Load(rdr, out m); break; } } if (m == null) { sql = new StringBuilder(); sql.AppendFormat("select top 1 a.* from ItemKnowledge a where item = '公共' and a.IsDelete=0 ", ""); using (SqlDataReader rdr = this.SQLHelper.ExecuteReader(sql.ToString())) { while (rdr.Read()) { this.Load(rdr, out m); break; } } } //返回 return(m); }
/// <summary> /// 装载实体 /// </summary> /// <param name="pReader">向前只读器</param> /// <param name="pInstance">实体实例</param> protected void Load(SqlDataReader pReader, out ItemKnowledgeEntity pInstance) { //将所有的数据从SqlDataReader中读取到Entity中 pInstance = new ItemKnowledgeEntity(); pInstance.PersistenceHandle = new PersistenceHandle(); pInstance.PersistenceHandle.Load(); if (pReader["ItemKnowledgeID"] != DBNull.Value) { pInstance.ItemKnowledgeID = Convert.ToString(pReader["ItemKnowledgeID"]); } if (pReader["Item"] != DBNull.Value) { pInstance.Item = Convert.ToString(pReader["Item"]); } if (pReader["Content"] != DBNull.Value) { pInstance.Content = Convert.ToString(pReader["Content"]); } if (pReader["CreateTime"] != DBNull.Value) { pInstance.CreateTime = Convert.ToDateTime(pReader["CreateTime"]); } if (pReader["CreateBy"] != DBNull.Value) { pInstance.CreateBy = Convert.ToString(pReader["CreateBy"]); } if (pReader["LastUpdateTime"] != DBNull.Value) { pInstance.LastUpdateTime = Convert.ToString(pReader["LastUpdateTime"]); } if (pReader["LastUpdateBy"] != DBNull.Value) { pInstance.LastUpdateBy = Convert.ToString(pReader["LastUpdateBy"]); } if (pReader["IsDelete"] != DBNull.Value) { pInstance.IsDelete = Convert.ToInt32(pReader["IsDelete"]); } }
/// <summary> /// 分页根据实体条件查询实体 /// </summary> /// <param name="pQueryEntity">以实体形式传入的参数</param> /// <param name="pOrderBys">排序组合</param> /// <returns>符合条件的实体集</returns> public PagedQueryResult <ItemKnowledgeEntity> PagedQueryByEntity(ItemKnowledgeEntity pQueryEntity, OrderBy[] pOrderBys, int pPageSize, int pCurrentPageIndex) { return(_currentDAO.PagedQueryByEntity(pQueryEntity, pOrderBys, pPageSize, pCurrentPageIndex)); }
/// <summary> /// 根据实体条件查询实体 /// </summary> /// <param name="pQueryEntity">以实体形式传入的参数</param> /// <param name="pOrderBys">排序组合</param> /// <returns>符合条件的实体集</returns> public ItemKnowledgeEntity[] QueryByEntity(ItemKnowledgeEntity pQueryEntity, OrderBy[] pOrderBys) { return(_currentDAO.QueryByEntity(pQueryEntity, pOrderBys)); }
/// <summary> /// 删除 /// </summary> /// <param name="pEntity"></param> public void Delete(ItemKnowledgeEntity pEntity) { _currentDAO.Delete(pEntity); }
public void Update(ItemKnowledgeEntity pEntity, bool pIsUpdateNullField) { _currentDAO.Update(pEntity, pIsUpdateNullField); }
/// <summary> /// 更新 /// </summary> /// <param name="pEntity">实体实例</param> public void Update(ItemKnowledgeEntity pEntity) { Update(pEntity, true); }
/// <summary> /// 删除 /// </summary> /// <param name="pEntity"></param> public void Delete(ItemKnowledgeEntity pEntity) { this.Delete(pEntity, null); }
/// <summary> /// 更新 /// </summary> /// <param name="pEntity">实体实例</param> /// <param name="pTran">事务实例,可为null,如果为null,则不使用事务来更新</param> public void Update(ItemKnowledgeEntity pEntity, IDbTransaction pTran) { Update(pEntity, true, pTran); }
/// <summary> /// 创建一个新实例 /// </summary> /// <param name="pEntity">实体实例</param> public void Create(ItemKnowledgeEntity pEntity) { this.Create(pEntity, null); }
/// <summary> /// 根据实体非Null属性生成查询条件。 /// </summary> /// <returns></returns> protected IWhereCondition[] GetWhereConditionByEntity(ItemKnowledgeEntity pQueryEntity) { //获取非空属性数量 List <EqualsCondition> lstWhereCondition = new List <EqualsCondition>(); if (pQueryEntity.ItemKnowledgeID != null) { lstWhereCondition.Add(new EqualsCondition() { FieldName = "ItemKnowledgeID", Value = pQueryEntity.ItemKnowledgeID }); } if (pQueryEntity.Item != null) { lstWhereCondition.Add(new EqualsCondition() { FieldName = "Item", Value = pQueryEntity.Item }); } if (pQueryEntity.Content != null) { lstWhereCondition.Add(new EqualsCondition() { FieldName = "Content", Value = pQueryEntity.Content }); } if (pQueryEntity.CreateTime != null) { lstWhereCondition.Add(new EqualsCondition() { FieldName = "CreateTime", Value = pQueryEntity.CreateTime }); } if (pQueryEntity.CreateBy != null) { lstWhereCondition.Add(new EqualsCondition() { FieldName = "CreateBy", Value = pQueryEntity.CreateBy }); } if (pQueryEntity.LastUpdateTime != null) { lstWhereCondition.Add(new EqualsCondition() { FieldName = "LastUpdateTime", Value = pQueryEntity.LastUpdateTime }); } if (pQueryEntity.LastUpdateBy != null) { lstWhereCondition.Add(new EqualsCondition() { FieldName = "LastUpdateBy", Value = pQueryEntity.LastUpdateBy }); } if (pQueryEntity.IsDelete != null) { lstWhereCondition.Add(new EqualsCondition() { FieldName = "IsDelete", Value = pQueryEntity.IsDelete }); } return(lstWhereCondition.ToArray()); }
/// <summary> /// 分页根据实体条件查询实体 /// </summary> /// <param name="pQueryEntity">以实体形式传入的参数</param> /// <param name="pOrderBys">排序组合</param> /// <returns>符合条件的实体集</returns> public PagedQueryResult <ItemKnowledgeEntity> PagedQueryByEntity(ItemKnowledgeEntity pQueryEntity, OrderBy[] pOrderBys, int pPageSize, int pCurrentPageIndex) { IWhereCondition[] queryWhereCondition = GetWhereConditionByEntity(pQueryEntity); return(PagedQuery(queryWhereCondition, pOrderBys, pPageSize, pCurrentPageIndex)); }
/// <summary> /// 根据实体条件查询实体 /// </summary> /// <param name="pQueryEntity">以实体形式传入的参数</param> /// <param name="pOrderBys">排序组合</param> /// <returns>符合条件的实体集</returns> public ItemKnowledgeEntity[] QueryByEntity(ItemKnowledgeEntity pQueryEntity, OrderBy[] pOrderBys) { IWhereCondition[] queryWhereCondition = GetWhereConditionByEntity(pQueryEntity); return(Query(queryWhereCondition, pOrderBys)); }
/// <summary> /// 创建一个新实例 /// </summary> /// <param name="pEntity">实体实例</param> public void Create(ItemKnowledgeEntity pEntity) { _currentDAO.Create(pEntity); }
/// <summary> /// 在事务内创建一个新实例 /// </summary> /// <param name="pEntity">实体实例</param> /// <param name="pTran">事务实例,可为null,如果为null,则不使用事务来更新</param> public void Create(ItemKnowledgeEntity pEntity, IDbTransaction pTran) { _currentDAO.Create(pEntity, pTran); }
public void Update(ItemKnowledgeEntity pEntity, bool pIsUpdateNullField, IDbTransaction pTran) { //参数校验 if (pEntity == null) { throw new ArgumentNullException("pEntity"); } if (pEntity.ItemKnowledgeID == null) { throw new ArgumentException("执行更新时,实体的主键属性值不能为null."); } //初始化固定字段 pEntity.LastUpdateTime = DateTime.Now.ToString(); pEntity.LastUpdateBy = CurrentUserInfo.UserID; //组织参数化SQL StringBuilder strSql = new StringBuilder(); strSql.Append("update [ItemKnowledge] set "); if (pIsUpdateNullField || pEntity.Item != null) { strSql.Append("[Item]=@Item,"); } if (pIsUpdateNullField || pEntity.Content != null) { strSql.Append("[Content]=@Content,"); } if (pIsUpdateNullField || pEntity.LastUpdateTime != null) { strSql.Append("[LastUpdateTime]=@LastUpdateTime,"); } if (pIsUpdateNullField || pEntity.LastUpdateBy != null) { strSql.Append("[LastUpdateBy]=@LastUpdateBy"); } strSql.Append(" where ItemKnowledgeID=@ItemKnowledgeID "); SqlParameter[] parameters = { new SqlParameter("@Item", SqlDbType.NVarChar), new SqlParameter("@Content", SqlDbType.Text), new SqlParameter("@LastUpdateTime", SqlDbType.NVarChar), new SqlParameter("@LastUpdateBy", SqlDbType.NVarChar), new SqlParameter("@ItemKnowledgeID", SqlDbType.NVarChar) }; parameters[0].Value = pEntity.Item; parameters[1].Value = pEntity.Content; parameters[2].Value = pEntity.LastUpdateTime; parameters[3].Value = pEntity.LastUpdateBy; parameters[4].Value = pEntity.ItemKnowledgeID; //执行语句 int result = 0; if (pTran != null) { result = this.SQLHelper.ExecuteNonQuery((SqlTransaction)pTran, CommandType.Text, strSql.ToString(), parameters); } else { result = this.SQLHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters); } }
public void Update(ItemKnowledgeEntity pEntity, bool pIsUpdateNullField, IDbTransaction pTran) { _currentDAO.Update(pEntity, pIsUpdateNullField, pTran); }
public void Update(ItemKnowledgeEntity pEntity, bool pIsUpdateNullField) { this.Update(pEntity, pIsUpdateNullField, null); }