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