private XBase.Model.KnowledgeCenter.KnowledgeRequire GetEntity(SqlDataReader dr)
{
XBase.Model.KnowledgeCenter.KnowledgeRequire entity = new XBase.Model.KnowledgeCenter.KnowledgeRequire();
entity.ID = SqlClientUtility.GetInt32(dr,"ID",0);
entity.CompanyCD = SqlClientUtility.GetString(dr,"CompanyCD",String.Empty);
entity.SendDate = SqlClientUtility.GetDateTime(dr,"SendDate",DateTime.Now);
entity.SendUserID = SqlClientUtility.GetString(dr,"SendUserID",String.Empty);
entity.Content = SqlClientUtility.GetString(dr,"Content",String.Empty);
entity.FeeBackStatus = SqlClientUtility.GetString(dr,"FeeBackStatus",String.Empty);
entity.FeeBackDate = SqlClientUtility.GetDateTime(dr,"FeeBackDate",DateTime.Now);
entity.FeeBackUserID = SqlClientUtility.GetString(dr,"FeeBackUserID",String.Empty);
return entity;
}
private XBase.Model.KnowledgeCenter.KnowledgeRequire GetEntity(SqlDataReader dr)
{
XBase.Model.KnowledgeCenter.KnowledgeRequire entity = new XBase.Model.KnowledgeCenter.KnowledgeRequire();
entity.ID = SqlClientUtility.GetInt32(dr, "ID", 0);
entity.CompanyCD = SqlClientUtility.GetString(dr, "CompanyCD", String.Empty);
entity.SendDate = SqlClientUtility.GetDateTime(dr, "SendDate", DateTime.Now);
entity.SendUserID = SqlClientUtility.GetString(dr, "SendUserID", String.Empty);
entity.Content = SqlClientUtility.GetString(dr, "Content", String.Empty);
entity.FeeBackStatus = SqlClientUtility.GetString(dr, "FeeBackStatus", String.Empty);
entity.FeeBackDate = SqlClientUtility.GetDateTime(dr, "FeeBackDate", DateTime.Now);
entity.FeeBackUserID = SqlClientUtility.GetString(dr, "FeeBackUserID", String.Empty);
return(entity);
}
public XBase.Model.KnowledgeCenter.KnowledgeRequire GetEntityByID(int iD)
{
SqlParameter[] parameters = new SqlParameter[] {
SqlParameterHelper.MakeInParam("@ID", SqlDbType.Int, 0, iD)
};
XBase.Model.KnowledgeCenter.KnowledgeRequire entity = null;
SqlDataReader dr;
Database.RunProc("[knowdba].KnowledgeRequire_GetEntityByID", parameters, out dr);
if (dr.Read())
{
entity = GetEntity(dr);
}
dr.Close();
return(entity);
}
public bool Create(XBase.Model.KnowledgeCenter.KnowledgeRequire entity)
{
SqlParameter[] parameters = new SqlParameter[] {
SqlParameterHelper.MakeInParam("@CompanyCD", SqlDbType.VarChar, 8, entity.CompanyCD),
SqlParameterHelper.MakeInParam("@SendDate", SqlDbType.DateTime, 0, entity.SendDate),
SqlParameterHelper.MakeInParam("@SendUserID", SqlDbType.VarChar, 20, entity.SendUserID),
SqlParameterHelper.MakeInParam("@Content", SqlDbType.NVarChar, 200, entity.Content),
SqlParameterHelper.MakeInParam("@FeeBackStatus", SqlDbType.Char, 1, entity.FeeBackStatus),
SqlParameterHelper.MakeInParam("@FeeBackDate", SqlDbType.DateTime, 0, entity.FeeBackDate),
SqlParameterHelper.MakeInParam("@FeeBackUserID", SqlDbType.VarChar, 20, entity.FeeBackUserID)
};
bool result;
Database.RunProc("[knowdba].KnowledgeRequire_Create", parameters, out result);
return(result);
}
public int UpdateByID(XBase.Model.KnowledgeCenter.KnowledgeRequire entity)
{
return(dal.UpdateByID(entity));
}
public bool Create(XBase.Model.KnowledgeCenter.KnowledgeRequire entity)
{
return(dal.Create(entity));
}
