private XBase.Model.KnowledgeCenter.MyKeyWord GetEntity(SqlDataReader dr)
{
XBase.Model.KnowledgeCenter.MyKeyWord entity = new XBase.Model.KnowledgeCenter.MyKeyWord();
entity.ID = SqlClientUtility.GetInt32(dr, "ID", 0);
entity.CompanyCD = SqlClientUtility.GetString(dr, "CompanyCD", String.Empty);
entity.TypeID = SqlClientUtility.GetInt32(dr, "TypeID", 0);
entity.KeyType = SqlClientUtility.GetString(dr, "KeyType", String.Empty);
entity.KeyWordID = SqlClientUtility.GetInt32(dr, "KeyWordID", 0);
entity.KeyWordName = SqlClientUtility.GetString(dr, "KeyWordName", String.Empty);
entity.Creator = SqlClientUtility.GetString(dr, "Creator", 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);
return(entity);
}
private XBase.Model.KnowledgeCenter.MyKeyWord GetEntity(SqlDataReader dr)
{
XBase.Model.KnowledgeCenter.MyKeyWord entity = new XBase.Model.KnowledgeCenter.MyKeyWord();
entity.ID = SqlClientUtility.GetInt32(dr,"ID",0);
entity.CompanyCD = SqlClientUtility.GetString(dr,"CompanyCD",String.Empty);
entity.TypeID = SqlClientUtility.GetInt32(dr,"TypeID",0);
entity.KeyType = SqlClientUtility.GetString(dr,"KeyType",String.Empty);
entity.KeyWordID = SqlClientUtility.GetInt32(dr,"KeyWordID",0);
entity.KeyWordName = SqlClientUtility.GetString(dr,"KeyWordName",String.Empty);
entity.Creator = SqlClientUtility.GetString(dr,"Creator",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);
return entity;
}
public XBase.Model.KnowledgeCenter.MyKeyWord GetEntityByID(int iD)
{
SqlParameter[] parameters = new SqlParameter[] {
SqlParameterHelper.MakeInParam("@ID", SqlDbType.Int, 0, iD)
};
XBase.Model.KnowledgeCenter.MyKeyWord entity = null;
SqlDataReader dr;
Database.RunProc("[knowdba].MyKeyWord_GetEntityByID", parameters, out dr);
if (dr.Read())
{
entity = GetEntity(dr);
}
dr.Close();
return(entity);
}
public bool Create(XBase.Model.KnowledgeCenter.MyKeyWord entity)
{
SqlParameter[] parameters = new SqlParameter[] {
SqlParameterHelper.MakeInParam("@CompanyCD", SqlDbType.VarChar, 8, entity.CompanyCD),
SqlParameterHelper.MakeInParam("@TypeID", SqlDbType.Int, 0, entity.TypeID),
SqlParameterHelper.MakeInParam("@KeyType", SqlDbType.Char, 1, entity.KeyType),
SqlParameterHelper.MakeInParam("@KeyWordID", SqlDbType.Int, 0, entity.KeyWordID),
SqlParameterHelper.MakeInParam("@KeyWordName", SqlDbType.VarChar, 100, entity.KeyWordName),
SqlParameterHelper.MakeInParam("@Creator", SqlDbType.VarChar, 20, entity.Creator),
SqlParameterHelper.MakeInParam("@CreateDate", SqlDbType.DateTime, 0, entity.CreateDate),
SqlParameterHelper.MakeInParam("@ModifiedDate", SqlDbType.DateTime, 0, entity.ModifiedDate),
SqlParameterHelper.MakeInParam("@ModifiedUserID", SqlDbType.VarChar, 20, entity.ModifiedUserID)
};
bool result;
Database.RunProc("[knowdba].MyKeyWord_Create", parameters, out result);
return(result);
}
public int UpdateByID(XBase.Model.KnowledgeCenter.MyKeyWord entity)
{
return(dal.UpdateByID(entity));
}
public bool Create(XBase.Model.KnowledgeCenter.MyKeyWord entity)
{
return(dal.Create(entity));
}
