1、存储过程名：
public static class CampaignTrackingDomainSql
{
/// <summary>
/// proc
/// </summary>
public static readonly string PageProcSql = @"NewsLetterSystem_TrackingDB_GetClicksDomainV2";
}
2、DapperUtil
/// <summary>
/// get datatable by query proc
/// </summary>
/// <param name="sql"></param>
/// <param name="parms"></param>
/// <param name="connectionString"></param>
/// <returns></returns>
public static DataTable QueryDataTableByStoredProc(string sql, dynamic parms, string connectionString = null)
{
DataTable dataTable = new DataTable();
using (IDbConnection connection = OpenConnection(connectionString))
{
return QueryDataTableByStoredProc(connection, sql, parms, connectionString);
}
}
3、DapperService：
/// <summary>
/// get datatable
/// </summary>
/// <param name="parModel"></param>
/// <returns></returns>
public DataTable GetDataTable(int campId)
{
DynamicParameters par = new DynamicParameters(); par.Add("@CampaignID", campId);
par.Add("@PageStart", );
par.Add("@PageEnd", );
par.Add("@IsPage", false);
par.Add("@Total", , DbType.Int32, ParameterDirection.Output);
par.Add("@TotalClick", , DbType.Int32, ParameterDirection.Output);
par.Add("@TotalUniqueClick", , DbType.Int32, ParameterDirection.Output); DataTable dt = SqlMapperUtil.QueryDataTableByStoredProc(CampaignTrackingDomainSql.PageProcSql, par);
int total = par.Get<int>("@Total");
int totalOpen = par.Get<int>("@TotalClick");
int totalUniqueOpen = par.Get<int>("@TotalUniqueClick");
return dt;
}