34 lines
901 B
C#
34 lines
901 B
C#
using System;
|
|
using System.Data;
|
|
using System.Data.OracleClient;
|
|
|
|
namespace WX.CRM.DAL.Qc
|
|
{
|
|
public class QC_ORDMEMO_DAL
|
|
{
|
|
public void ORD_MEMO_HANDLE()
|
|
{
|
|
OracleConnection conn = new OracleConnection(OracleHelper.AYCRMConn);
|
|
if (conn.State == ConnectionState.Closed)
|
|
conn.Open();
|
|
try
|
|
{
|
|
using (OracleTransaction trans = conn.BeginTransaction())
|
|
{
|
|
var ds = OracleHelper.ExecuteNonQuery(trans, CommandType.StoredProcedure, "PACK_ORD_MEMO.ORD_MEMO_HANDLE");
|
|
trans.Commit();
|
|
}
|
|
}
|
|
catch (Exception)
|
|
{
|
|
throw;
|
|
}
|
|
finally
|
|
{
|
|
if (conn.State == ConnectionState.Open)
|
|
conn.Close();
|
|
}
|
|
}
|
|
}
|
|
}
|