protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { int page = GetInt("page", 1); int rows = GetInt("rows", 100); int total = 0; int corpid = GetInt("corpid", 0); string customername = GetString("uname"); string customerphone = GetString("phone"); int connectuserid = GetInt("uid",0); int connectwayid = GetInt("connectway",0); int customerlevelid = GetInt("customerlevel",0); string starttime = GetString("starttime"); string endtime = GetString("endtime"); CustomerConnectRecordQuery query = new CustomerConnectRecordQuery(); query.CorporationID = corpid; if (!string.IsNullOrEmpty(customername)) query.CustomerName = customername; if (!string.IsNullOrEmpty(customerphone)) query.CustomerPhone = customerphone; if(connectuserid > 0) query.ConnectUserID = connectuserid; if (connectwayid > 0) query.ConnectwayID = connectwayid; if (customerlevelid > 0) query.CustomerLevelID = customerlevelid; if (!string.IsNullOrEmpty(starttime)) query.StartTime = DataConvert.SafeDate(starttime); if (!string.IsNullOrEmpty(endtime)) query.EndTime = DataConvert.SafeDate(endtime).AddDays(1); if (!Admin.Administrator && Admin.UserRole != UserRoleType.系统管理员) { if (CurrentPowerGroup != null && !string.IsNullOrEmpty(CurrentPowerGroup.CanviewGroupIds)) { query.CanviewGroupIds = CurrentPowerGroup.CanviewGroupIds; } } List<CustomerConnectRecordInfo> list = CustomerConnectRecords.Instance.GetList(query, page, rows, ref total); int maxpage = total / rows + (total % rows == 0 ? 0 : 1); Response.Write("{\"count\":" + list.Count + ",\"total\":" + total + ",\"maxpage\":" + maxpage + ",\"rows\":" + Serializer.SerializeJson(list) + "}"); } }
protected void ExportUseDetail() { List<AdminInfo> adminlist = Admins.Instance.GetUsers(); List<CustomerInfo> customerlist = Customers.Instance.GetCustomerListByCorporation(DataConvert.SafeInt(ddlCorporation.SelectedValue),true); CustomerConnectRecordQuery query; List<CustomerConnectRecordInfo> connectrecordlist; adminlist = adminlist.FindAll(a => a.CorporationID == DataConvert.SafeInt(ddlCorporation.SelectedValue)).OrderBy(c=>c.PowerGroupID).ToList(); InitializeWorkbook(); HSSFSheet sheet1 = (HSSFSheet)hssfworkbook.CreateSheet("Sheet1"); HSSFRow rowHeader = (HSSFRow)sheet1.CreateRow(0); rowHeader.CreateCell(0).SetCellValue("姓名"); rowHeader.CreateCell(1).SetCellValue("线索数量"); rowHeader.CreateCell(2).SetCellValue("跟踪次数"); rowHeader.CreateCell(3).SetCellValue("登录次数"); rowHeader.CreateCell(4).SetCellValue("最后登录时间"); for (int i = 0; i < adminlist.Count; i++) { HSSFRow row = (HSSFRow)sheet1.CreateRow(i + 1); row.CreateCell(0).SetCellValue(adminlist[i].Realname); row.CreateCell(4).SetCellValue(adminlist[i].LastLoginTime.HasValue ? adminlist[i].LastLoginTime.Value.ToString("yyyy-M-d HH:mm:ss") : ""); row.CreateCell(3).SetCellValue(adminlist[i].LoginTimes); row.CreateCell(1).SetCellValue(customerlist.FindAll(c => c.OwnerID == adminlist[i].ID).Count); int recordcount = 0; query = new CustomerConnectRecordQuery(); query.ConnectUserID = adminlist[i].ID; connectrecordlist = CustomerConnectRecords.Instance.GetList(query, 1, 1, ref recordcount); row.CreateCell(2).SetCellValue(recordcount); } using (System.IO.MemoryStream ms = new System.IO.MemoryStream()) { hssfworkbook.Write(ms); Response.Clear(); Response.Buffer = true; Response.ContentType = "application/vnd.ms-excel"; Response.ContentEncoding = System.Text.Encoding.UTF8; Response.AppendHeader("Content-Disposition", "attachment; filename=销售客户管理系统使用情况统计.xls"); Response.BinaryWrite(ms.ToArray()); Response.End(); hssfworkbook = null; } }
public abstract List <CustomerConnectRecordInfo> GetCustomerConnectRecordList(CustomerConnectRecordQuery query, int pageindex, int pagesize, ref int recordcount);
public override List<CustomerConnectRecordInfo> GetCustomerConnectRecordList(CustomerConnectRecordQuery query, int pageindex, int pagesize, ref int recordcount) { List<CustomerConnectRecordInfo> list = new List<CustomerConnectRecordInfo>(); SqlParameter p; using (IDataReader reader = CommonPageSql.GetDataReaderByPager(_con, pageindex, pagesize, query, out p)) { while (reader.Read()) { list.Add(PopulateCustomerConnectRecordInfo(reader)); } } recordcount = int.Parse(p.Value.ToString()); return list; }
public List<CustomerConnectRecordInfo> GetList(CustomerConnectRecordQuery query,int pageindex,int pagesize,ref int recordcount) { return CommonDataProvider.Instance().GetCustomerConnectRecordList(query, pageindex, pagesize,ref recordcount); }
public abstract List<CustomerConnectRecordInfo> GetCustomerConnectRecordList(CustomerConnectRecordQuery query, int pageindex, int pagesize, ref int recordcount);
public List <CustomerConnectRecordInfo> GetList(CustomerConnectRecordQuery query, int pageindex, int pagesize, ref int recordcount) { return(CommonDataProvider.Instance().GetCustomerConnectRecordList(query, pageindex, pagesize, ref recordcount)); }