private XBase.Model.KnowledgeCenter.SubscribeHistory GetEntity(SqlDataReader dr) { XBase.Model.KnowledgeCenter.SubscribeHistory entity = new XBase.Model.KnowledgeCenter.SubscribeHistory(); entity.ID = SqlClientUtility.GetInt32(dr, "ID", 0); entity.CompanyCD = SqlClientUtility.GetString(dr, "CompanyCD", String.Empty); entity.Receiver = SqlClientUtility.GetString(dr, "Receiver", String.Empty); entity.KnowledgeID = SqlClientUtility.GetInt32(dr, "KnowledgeID", 0); entity.SendDate = SqlClientUtility.GetDateTime(dr, "SendDate", DateTime.Now); entity.KeyWordID = SqlClientUtility.GetString(dr, "KeyWordID", String.Empty); entity.KeyWordName = SqlClientUtility.GetString(dr, "KeyWordName", String.Empty); return(entity); }
private XBase.Model.KnowledgeCenter.SubscribeHistory GetEntity(SqlDataReader dr) { XBase.Model.KnowledgeCenter.SubscribeHistory entity = new XBase.Model.KnowledgeCenter.SubscribeHistory(); entity.ID = SqlClientUtility.GetInt32(dr,"ID",0); entity.CompanyCD = SqlClientUtility.GetString(dr,"CompanyCD",String.Empty); entity.Receiver = SqlClientUtility.GetString(dr,"Receiver",String.Empty); entity.KnowledgeID = SqlClientUtility.GetInt32(dr,"KnowledgeID",0); entity.SendDate = SqlClientUtility.GetDateTime(dr,"SendDate",DateTime.Now); entity.KeyWordID = SqlClientUtility.GetString(dr,"KeyWordID",String.Empty); entity.KeyWordName = SqlClientUtility.GetString(dr,"KeyWordName",String.Empty); return entity; }
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 XBase.Model.KnowledgeCenter.SubscribeHistory GetEntityByID(int iD) { SqlParameter[] parameters = new SqlParameter[] { SqlParameterHelper.MakeInParam("@ID", SqlDbType.Int, 0, iD) }; XBase.Model.KnowledgeCenter.SubscribeHistory entity = null; SqlDataReader dr; Database.RunProc("[knowdba].SubscribeHistory_GetEntityByID", parameters, out dr); if (dr.Read()) { entity = GetEntity(dr); } dr.Close(); return(entity); }
public int UpdateByID(XBase.Model.KnowledgeCenter.SubscribeHistory entity) { return(dal.UpdateByID(entity)); }
public bool Create(XBase.Model.KnowledgeCenter.SubscribeHistory entity) { return(dal.Create(entity)); }