/// <summary>
/// 根据ID修改要素分类
/// </summary>
/// <param name="elementClassify">要素分类对象</param>
/// <param name="dt">最后修改时间</param>
public void PutElementClassifyByID(ElementClassify elementClassify)
{
///获取当前时间
DateTime dt = NewData.NewDate();
ElementClassifyDAL elementClassifyDAL = new ElementClassifyDAL();
elementClassifyDAL.PutElementClassifyByID(elementClassify, dt);
}
/// <summary>
/// 新增要素分类
/// </summary>
/// <param name="elementClassify">要素分类对象</param>
/// <param name="dt">最后修改时间</param>
/// <param name="nid">新GUID</param>
public void CreateElementClassify(ElementClassify elementClassify)
{
///获取当前时间
DateTime dt = NewData.NewDate();
//获取新的GUID
string nid = NewData.NewGuid();
ElementClassifyDAL elementClassifyDAL = new ElementClassifyDAL();
elementClassifyDAL.CreateElementClassify(elementClassify, dt, nid);
}
/// <summary>
/// 根据ID修改要素分类
/// </summary>
/// <param name="resource">ElementClassify对象</param>
/// <param name="dt">最后修改时间</param>
public void PutElementClassifyByID(ElementClassify elementClassify, DateTime dt)
{
OracleDataAccess oracleDataAccess = new OracleDataAccess(SiteConfig.OracleConn);
string sql = @"update 资源分类 set 资源ID=:资源ID,
分类名称=:分类名称,
备注=:备注,
最后修改人=:最后修改人,
最后修改时间=:最后修改时间
where 资源分类ID=:资源分类ID";
OracleParameter[] oracleParameters =
{
new OracleParameter(":资源ID", OracleDbType.Varchar2, elementClassify.RID == null?"":elementClassify.RID, ParameterDirection.Input),
new OracleParameter(":分类名称", OracleDbType.Varchar2, elementClassify.Name, ParameterDirection.Input),
new OracleParameter(":备注", OracleDbType.Varchar2, elementClassify.Note, ParameterDirection.Input),
new OracleParameter(":最后修改人", OracleDbType.Varchar2, elementClassify.LastModify == null?"":elementClassify.LastModify, ParameterDirection.Input),
new OracleParameter(":最后修改时间", OracleDbType.Date, dt, ParameterDirection.Input),
new OracleParameter(":资源分类ID", OracleDbType.Varchar2, elementClassify.ID, ParameterDirection.Input),
};
oracleDataAccess.ExecuteNonQuery(sql, System.Data.CommandType.Text, oracleParameters);
}
/// <summary>
/// 新增要素分类
/// </summary>
/// <param name="elementClassify">ElementClassify对象</param>
/// <param name="dt">最后修改时间</param>
/// <param name="nid">新GUID</param>
public void CreateElementClassify(ElementClassify elementClassify, DateTime dt, string nid)
{
OracleDataAccess oracleDataAccess = new OracleDataAccess(SiteConfig.OracleConn);
string sql = @"insert into 资源分类( 资源分类ID,
资源ID,
分类名称,
备注,
最后修改人,
最后修改时间
)
values(:资源分类ID,:资源ID,:分类名称,:备注,:最后修改人,:最后修改时间)";
OracleParameter[] oracleParameters =
{
new OracleParameter(":资源分类ID", OracleDbType.Varchar2, nid, ParameterDirection.Input),
new OracleParameter(":资源ID", OracleDbType.Varchar2, elementClassify.RID == null?"":elementClassify.RID, ParameterDirection.Input),
new OracleParameter(":分类名称", OracleDbType.Varchar2, elementClassify.Name, ParameterDirection.Input),
new OracleParameter(":备注", OracleDbType.Varchar2, elementClassify.Note, ParameterDirection.Input),
new OracleParameter(":最后修改人", OracleDbType.Varchar2, elementClassify.LastModify == null?"":elementClassify.LastModify, ParameterDirection.Input),
new OracleParameter(":最后修改时间", OracleDbType.Date, dt, ParameterDirection.Input),
};
oracleDataAccess.ExecuteNonQuery(sql, System.Data.CommandType.Text, oracleParameters);
}
public void PutElementClassifyByID([FromBody] ElementClassify elementClassify)
{
ElementClassifyBLL elementClassifyBLL = new ElementClassifyBLL();
elementClassifyBLL.PutElementClassifyByID(elementClassify);
}
public void CreateElementClassify([FromBody] ElementClassify elementClassify)
{
ElementClassifyBLL elementClassifyBLL = new ElementClassifyBLL();
elementClassifyBLL.CreateElementClassify(elementClassify);
}
