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);
}
public XBase.Model.KnowledgeCenter.KnowledgeWarehouse GetEntityByID(int iD)
{
SqlParameter[] parameters = new SqlParameter[] {
SqlParameterHelper.MakeInParam("@ID", SqlDbType.Int, 0, iD)
};
XBase.Model.KnowledgeCenter.KnowledgeWarehouse entity = null;
SqlDataReader dr;
Database.RunProc("[knowdba].KnowledgeWarehouse_GetEntityByID", parameters, out dr);
if (dr.Read())
{
entity = GetEntity(dr);
}
dr.Close();
return(entity);
}
private XBase.Model.KnowledgeCenter.KnowledgeWarehouse GetEntity(SqlDataReader dr)
{
XBase.Model.KnowledgeCenter.KnowledgeWarehouse entity = new XBase.Model.KnowledgeCenter.KnowledgeWarehouse();
entity.ID = SqlClientUtility.GetInt32(dr, "ID", 0);
entity.KnowledgeNo = SqlClientUtility.GetString(dr, "KnowledgeNo", String.Empty);
entity.Flag = SqlClientUtility.GetString(dr, "Flag", String.Empty);
entity.TypeID = SqlClientUtility.GetInt32(dr, "TypeID", 0);
entity.Title = SqlClientUtility.GetString(dr, "Title", String.Empty);
entity.Keyword = SqlClientUtility.GetString(dr, "Keyword", String.Empty);
entity.Content = SqlClientUtility.GetString(dr, "Content", String.Empty);
entity.IsShow = SqlClientUtility.GetString(dr, "IsShow", String.Empty);
entity.SourceFrom = SqlClientUtility.GetString(dr, "SourceFrom", String.Empty);
entity.SafeLevel = SqlClientUtility.GetString(dr, "SafeLevel", String.Empty);
entity.Author = SqlClientUtility.GetString(dr, "Author", String.Empty);
entity.Attachment = SqlClientUtility.GetString(dr, "Attachment", String.Empty);
entity.CreateUserID = SqlClientUtility.GetString(dr, "CreateUserID", String.Empty);
entity.CreateDate = SqlClientUtility.GetDateTime(dr, "CreateDate", DateTime.Now);
entity.ModifiedDate = SqlClientUtility.GetDateTime(dr, "ModifiedDate", DateTime.Now);
entity.ModifiedUserID = SqlClientUtility.GetString(dr, "ModifiedUserID", String.Empty);
entity.ReadTimes = SqlClientUtility.GetInt32(dr, "ReadTimes", 0);
entity.DownloadTimes = SqlClientUtility.GetInt32(dr, "DownloadTimes", 0);
return(entity);
}
private XBase.Model.KnowledgeCenter.KnowledgeWarehouse GetEntity(SqlDataReader dr)
{
XBase.Model.KnowledgeCenter.KnowledgeWarehouse entity = new XBase.Model.KnowledgeCenter.KnowledgeWarehouse();
entity.ID = SqlClientUtility.GetInt32(dr, "ID", 0);
entity.KnowledgeNo = SqlClientUtility.GetString(dr, "KnowledgeNo", String.Empty);
entity.Flag = SqlClientUtility.GetString(dr, "Flag", String.Empty);
entity.TypeID = SqlClientUtility.GetInt32(dr, "TypeID", 0);
entity.Title = SqlClientUtility.GetString(dr, "Title", String.Empty);
entity.Keyword = SqlClientUtility.GetString(dr, "Keyword", String.Empty);
entity.Content = SqlClientUtility.GetString(dr, "Content", String.Empty);
entity.IsShow = SqlClientUtility.GetString(dr, "IsShow", String.Empty);
entity.SourceFrom = SqlClientUtility.GetString(dr, "SourceFrom", String.Empty);
entity.SafeLevel = SqlClientUtility.GetString(dr, "SafeLevel", String.Empty);
entity.Author = SqlClientUtility.GetString(dr, "Author", String.Empty);
entity.Attachment = SqlClientUtility.GetString(dr, "Attachment", String.Empty);
entity.CreateUserID = SqlClientUtility.GetString(dr, "CreateUserID", String.Empty);
entity.CreateDate = SqlClientUtility.GetDateTime(dr, "CreateDate", DateTime.Now);
entity.ModifiedDate = SqlClientUtility.GetDateTime(dr, "ModifiedDate", DateTime.Now);
entity.ModifiedUserID = SqlClientUtility.GetString(dr, "ModifiedUserID", String.Empty);
entity.ReadTimes = SqlClientUtility.GetInt32(dr, "ReadTimes", 0);
entity.DownloadTimes = SqlClientUtility.GetInt32(dr, "DownloadTimes", 0);
return entity;
}
public int UpdateByID(XBase.Model.KnowledgeCenter.KnowledgeWarehouse entity)
{
return(dal.UpdateByID(entity));
}
public bool Create(XBase.Model.KnowledgeCenter.KnowledgeWarehouse entity)
{
return(dal.Create(entity));
}
