49 lines
1.5 KiB
C#
49 lines
1.5 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.Data;
|
|
using System.Data.OracleClient;
|
|
|
|
namespace WX.CRM.DAL.AutoRpt
|
|
{
|
|
public class AutoRpt_DAL
|
|
{
|
|
public void DeleteScheduling(DateTime ctime)
|
|
{
|
|
string sql = "delete AUTORPT_SCHEDULINGTASKS where ctime<:v_ctime";
|
|
var p = new List<OracleParameter>()
|
|
{
|
|
new OracleParameter()
|
|
{
|
|
ParameterName = "v_ctime",
|
|
OracleType = OracleType.DateTime,
|
|
Value = ctime
|
|
}
|
|
};
|
|
OracleHelper.ExecuteNonQuery(CommandType.Text, sql, p.ToArray());
|
|
}
|
|
|
|
public DataSet EnableScheduling(string procName)
|
|
{
|
|
OracleConnection conn = new OracleConnection(OracleHelper.AYCRMConn);
|
|
if (conn.State == ConnectionState.Closed)
|
|
conn.Open();
|
|
try
|
|
{
|
|
using (OracleTransaction trans = conn.BeginTransaction())
|
|
{
|
|
OracleParameter[] p = new[] {
|
|
new OracleParameter{ParameterName="p_sqlData",OracleType=OracleType.Cursor,Direction = ParameterDirection.Output}
|
|
};
|
|
var ds = OracleHelper.DataQueray(trans, CommandType.StoredProcedure, procName, p);
|
|
trans.Commit();
|
|
return ds;
|
|
}
|
|
}
|
|
catch { throw; }
|
|
finally { conn.Close(); }
|
|
}
|
|
|
|
|
|
}
|
|
}
|