38 lines
1.4 KiB
C#
38 lines
1.4 KiB
C#
using System;
|
|
using System.Data;
|
|
using System.Data.OracleClient;
|
|
using WX.CRM.Common;
|
|
|
|
namespace WX.CRM.DAL.QH
|
|
{
|
|
public class QH_TRANSACTIONDETAIL_DAL
|
|
{
|
|
public DataTable GetList(ref Pager pager, string userAccount, string year, string quarter)
|
|
{
|
|
OracleConnection conn = new OracleConnection(OracleHelper.AYCRMConn);
|
|
if (conn.State == ConnectionState.Closed)
|
|
conn.Open();
|
|
try
|
|
{
|
|
string str = "select count(*) from qh_transactiondetail_" + year + quarter + " t where t.USERACCOUNT='" + userAccount + "'";
|
|
string sql = "select * from (select a.*,rownum row_num from (select * from qh_transactiondetail_" + year + quarter + @"
|
|
t where t.USERACCOUNT = '" + userAccount + @"' order by t.CTIME desc) a) TB where
|
|
TB.row_num between " + ((pager.page - 1) * pager.rows + 1) + " and " + ((pager.page - 1) * pager.rows + pager.rows);
|
|
pager.totalRows = Convert.ToInt32(OracleHelper.ExecuteScalar(CommandType.Text, str));
|
|
DataSet ds = OracleHelper.DataQueray(CommandType.Text, sql);
|
|
return ds.Tables[0];
|
|
}
|
|
catch (Exception)
|
|
{
|
|
|
|
throw;
|
|
}
|
|
finally
|
|
{
|
|
if (conn.State == ConnectionState.Open)
|
|
conn.Close();
|
|
}
|
|
}
|
|
}
|
|
}
|