protected void Button7_Click(object sender, EventArgs e)
{
CallReportService service = new CallReportService();
DateTime? a = service.GetMaxDateTimeFromHourData(key);
DateTime? b = service.GetMaxDateTimeFrom15MinData(key);
service.ClearVendor15MinDataFormBeginToEnd(key, DateTime.Today.AddDays(-1), DateTime.Today, Entities.Vender.Holly);
}
protected void Button5_Click(object sender, EventArgs e)
{
string sql = @"select
t.begin_time,
t.hour_hh24,
t.week_n_in_year,
t.month_n_in_year,
t.year,
o.object_name,
decode(o.object_name,'81400@SIPSwitch',1,'81401@SIPSwitch',2,null) as object_type,
round(av_t_abandoned,5) as av_t_abandoned,
round(av_t_answered,5) as av_t_answered,
round(av_t_distributed,5) as av_t_distributed,
n_abandoned,
n_answered,
n_distributed,
n_entered,
n_abandoned_in_tr,
n_distrib_in_tr,
t_abandoned,
t_answered,
t_distributed
from v_routepoint_hour v, o_routepoint_hour o , t_routepoint_hour t
where v.time_key=t.time_key and v.object_id=o.object_id
and o.delete_time is null
and o.object_name in ('81400@SIPSwitch','81401@SIPSwitch')
order by t.begin_time,o.object_name";
int total = ReportOracleBLL.Instance.GetDataTableCount(sql);
//分页查询，每页100条
int page = total / 100 + ((total % 100 == 0) ? 0 : 1);
for (int p = 1; p <= page; p++)
{
DataTable dt = ReportOracleBLL.Instance.GetDataTable(sql, p, 100, out total);
int rowlen = dt.Rows.Count;
byte[] b = BitAuto.ISDC.CC2012.BLL.Util.GetBinaryFormatData(dt.DataSet);
double mlen = (double)b.Length / 1024.0 / 1024.0;
string msg = "";
CallReportService service = new CallReportService();
bool a = service.SyncRoutepointHourData(key, b, ref msg);
}
}
