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