/// <summary>
/// 根据ID修改统计指标
/// </summary>
/// <param name="CountNorm">统计指标对象</param>
/// <param name="dt">最后修改时间</param>
public void PutCountNormByID(CountNorm countNorm, DateTime dt)
{
OracleDataAccess oracleDataAccess = new OracleDataAccess(SiteConfig.OracleConn);
string sql = @"update 统计指标定义
set 指标名称 = :指标名称,
计算类型 = :计算类型,
运算符 = :运算符,
运算值 = :运算值,
关联类型 = :关联类型,
关联ID = :关联ID,
备注 = :备注,
最后修改人 = :最后修改人,
最后修改时间 = :最后修改时间,
资源ID = :资源ID
where 指标定义ID=:指标定义ID";
OracleParameter[] oracleParameters =
{
new OracleParameter(":指标名称", OracleDbType.Varchar2, countNorm.NormName == null?"":countNorm.NormName, ParameterDirection.Input),
new OracleParameter(":计算类型", OracleDbType.Varchar2, countNorm.CalculateType == null?"":countNorm.CalculateType, ParameterDirection.Input),
new OracleParameter(":运算符", OracleDbType.Varchar2, countNorm.Operator == null?"":countNorm.Operator, ParameterDirection.Input),
new OracleParameter(":运算值", OracleDbType.Varchar2, countNorm.Ovalue == null?"":countNorm.Ovalue, ParameterDirection.Input),
new OracleParameter(":关联类型", OracleDbType.Varchar2, countNorm.AssociationType == null?"":countNorm.AssociationType, ParameterDirection.Input),
new OracleParameter(":关联ID", OracleDbType.Varchar2, countNorm.GLID == null?"":countNorm.GLID, ParameterDirection.Input),
new OracleParameter(":备注", OracleDbType.Varchar2, countNorm.Note == null?"":countNorm.Note, ParameterDirection.Input),
new OracleParameter(":最后修改人", OracleDbType.Varchar2, countNorm.LastModify == null?"":countNorm.LastModify, ParameterDirection.Input),
new OracleParameter(":最后修改时间", OracleDbType.Date, dt, ParameterDirection.Input),
new OracleParameter(":资源ID", OracleDbType.Varchar2, countNorm.RID == null?"":countNorm.RID, ParameterDirection.Input),
new OracleParameter(":指标定义ID", OracleDbType.Varchar2, countNorm.ID == null?"":countNorm.ID, ParameterDirection.Input),
};
oracleDataAccess.ExecuteNonQuery(sql, System.Data.CommandType.Text, oracleParameters);
}
/// <summary>
/// 根据ID修改资源目录
/// </summary>
/// <param name="countNorm">资源目录对象</param>
/// <param name="dt">最后修改时间</param>
public void PutCountNormByID(CountNorm countNorm)
{
///获取当前时间
DateTime dt = NewData.NewDate();
CountNormDAL countNormDAL = new CountNormDAL();
countNormDAL.PutCountNormByID(countNorm, dt);
}
/// <summary>
/// 新增统计指标
/// </summary>
/// <param name="countNorm">统计指标对象</param>
/// <param name="dt">最后修改时间</param>
/// <param name="nid">新GUID</param>
public void CreateCountNorm(CountNorm countNorm)
{
///获取当前时间
DateTime dt = NewData.NewDate();
//获取新的GUID
string nid = NewData.NewGuid();
CountNormDAL countNormDAL = new CountNormDAL();
countNormDAL.CreateCountNorm(countNorm, dt, nid);
}
/// <summary>
/// 新增统计指标
/// </summary>
/// <param name="CountNorm">统计指标</param>
/// <param name="dt">最后修改时间</param>
/// <param name="nid">新GUID</param>
public void CreateCountNorm(CountNorm countNorm, DateTime dt, string nid)
{
OracleDataAccess oracleDataAccess = new OracleDataAccess(SiteConfig.OracleConn);
string sql = @"insert into 统计指标定义( 指标定义id, 指标名称, 计算类型, 运算符, 运算值, 关联类型, 关联id, 备注, 最后修改人, 最后修改时间, 资源id)
values(:指标定义id, :指标名称, :计算类型, :运算符, :运算值, :关联类型, :关联id, :备注, :最后修改人, ：最后修改时间, ：资源id)";
OracleParameter[] oracleParameters =
{
new OracleParameter(":指标定义id", OracleDbType.Varchar2, nid, ParameterDirection.Input),
new OracleParameter(":指标名称", OracleDbType.Varchar2, countNorm.NormName, ParameterDirection.Input),
new OracleParameter(":计算类型", OracleDbType.Varchar2, countNorm.CalculateType, ParameterDirection.Input),
new OracleParameter(":运算符", OracleDbType.Varchar2, countNorm.Operator, ParameterDirection.Input),
new OracleParameter(":运算值", OracleDbType.Varchar2, countNorm.Ovalue, ParameterDirection.Input),
new OracleParameter(":关联类型", OracleDbType.Varchar2, countNorm.AssociationType, ParameterDirection.Input),
new OracleParameter(":关联id", OracleDbType.Varchar2, countNorm.GLID, ParameterDirection.Input),
new OracleParameter(":备注", OracleDbType.Varchar2, countNorm.Note, ParameterDirection.Input),
new OracleParameter(":最后修改人", OracleDbType.Varchar2, countNorm.LastModify, ParameterDirection.Input),
new OracleParameter(":最后修改时间", OracleDbType.Date, dt, ParameterDirection.Input),
new OracleParameter(":资源id", OracleDbType.Varchar2, countNorm.RID == null?"":countNorm.RID, ParameterDirection.Input),
};
oracleDataAccess.ExecuteNonQuery(sql, System.Data.CommandType.Text, oracleParameters);
}
public void PutCountNormByID([FromBody] CountNorm countNorm)
{
CountNormBLL countNormBLL = new CountNormBLL();
countNormBLL.PutCountNormByID(countNorm);
}
public void CreateCountNorm([FromBody] CountNorm countNorm)
{
CountNormBLL countNormBLL = new CountNormBLL();
countNormBLL.CreateCountNorm(countNorm);
}
