52 lines
1.7 KiB
C#
52 lines
1.7 KiB
C#
using System;
|
|
using System.Data;
|
|
using System.Data.OracleClient;
|
|
using WX.CRM.Common;
|
|
|
|
namespace WX.CRM.DAL.Res
|
|
{
|
|
public class RES_ResRecycleRecord_DAL
|
|
{
|
|
|
|
public DataTable GetNotice(decimal type)
|
|
{
|
|
DataTable table = null;
|
|
try
|
|
{
|
|
|
|
OracleParameter[] p2 =
|
|
{
|
|
new OracleParameter() { ParameterName = "p_type", OracleType=OracleType.Number,Value = type},
|
|
new OracleParameter() { ParameterName = "p_data", OracleType=OracleType.Cursor,Direction = ParameterDirection.Output}
|
|
};
|
|
table = OracleHelper.DataQueray(CommandType.StoredProcedure, "PACK_RES_RECYCLE.GetZhenGuRecycleNotice", p2).Tables[0];
|
|
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
LogHelper.Error(ex.ToString());
|
|
}
|
|
return table;
|
|
}
|
|
public bool UpadteNoticeLookStatus(decimal userid, decimal type)
|
|
{
|
|
bool result = false;
|
|
try
|
|
{
|
|
OracleParameter[] p2 =
|
|
{
|
|
new OracleParameter() { ParameterName = "p_userid", OracleType=OracleType.Number,Value=userid},
|
|
new OracleParameter() { ParameterName = "p_type", OracleType=OracleType.Number,Value=type},
|
|
};
|
|
OracleHelper.ExecuteNonQuery(CommandType.StoredProcedure, "PACK_RES_RECYCLE.UpdateLookStatus", p2);
|
|
result = true;
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
LogHelper.Error(ex.ToString());
|
|
}
|
|
return result;
|
|
}
|
|
}
|
|
}
|