26 lines
844 B
C#
26 lines
844 B
C#
using System;
|
|
using System.Data;
|
|
using System.Data.SqlClient;
|
|
|
|
namespace WX.CRM.DAL.IPSC
|
|
{
|
|
public class IPSC_DAL
|
|
{
|
|
public DataSet SetCallRecordSatisfaction(DateTime dt)
|
|
{
|
|
string sql = @"select *
|
|
from ivr_satisfaction
|
|
where agent!='' and inserttime>@start";
|
|
return SqlHelper.GetDataSet(SqlHelper.DatabaseType.IPSC, sql, CommandType.Text, new[]{
|
|
new SqlParameter(){ParameterName="@start", SqlDbType = SqlDbType.DateTime, Value= dt}
|
|
});
|
|
}
|
|
|
|
public DataSet Get_IVR_Moniter()
|
|
{
|
|
string sql = @"select userid,username,agentid,type,state,worktype from dbo.AgentState";
|
|
return SqlHelper.GetDataSet(SqlHelper.DatabaseType.IPSC, sql, CommandType.Text);
|
|
}
|
|
}
|
|
}
|