protected void btnDown_Click(object sender, EventArgs e) { DateTime dfrom = DateTime.Parse(tbDateFrom.Text); DateTime dto = DateTime.Parse(tbDateTo.Text).AddDays(1); using (LandRoverOldDbDataContext ctx = new LandRoverOldDbDataContext()) { var list = from u in ctx.shouce where u.times >= dfrom && u.times < dto select u; var data = list.ToList(); if (data.Count == 0) return; StringBuilder sb = new StringBuilder("id,sex,username,date,sheng,city,address,youbian,email,dianhua,shouji,shouceida,shouceidb,shouceid1,shouceid2,shouceid3,shouceid4,shouceid5,contactme,times,gcsj,gcys,phcx,phcx1,phcx2,phcx3,phcx4,phcx5,td"); Regex quote = new Regex("\""); foreach (var obj in data) { sb.AppendLine(); sb.AppendFormat("{0},", obj.id); sb.AppendFormat("{0},", obj.sex); sb.AppendFormat("\"{0}\",", Helper.FormatForCSV(obj.username)); sb.AppendFormat("{0},", obj.date); sb.AppendFormat("{0},", obj.sheng); sb.AppendFormat("{0},", obj.city); sb.AppendFormat("\"{0}\",", Helper.FormatForCSV(obj.address)); sb.AppendFormat("\"{0}\",", Helper.FormatForCSV(obj.youbian)); sb.AppendFormat("\"{0}\",", Helper.FormatForCSV(obj.email)); sb.AppendFormat("\"{0}\",", Helper.FormatForCSV(obj.dianhua)); sb.AppendFormat("\"{0}\",", Helper.FormatForCSV(obj.shouji)); sb.AppendFormat("{0},", obj.shouceida); sb.AppendFormat("{0},", obj.shouceidb); sb.AppendFormat("{0},", obj.shouceid1); sb.AppendFormat("{0},", obj.shouceid2); sb.AppendFormat("{0},", obj.shouceid3); sb.AppendFormat("{0},", obj.shouceid4); sb.AppendFormat("{0},", obj.shouceid5); sb.AppendFormat("{0},", obj.contactme); sb.AppendFormat("{0},", obj.times); sb.AppendFormat("{0},", obj.gcsj); sb.AppendFormat("{0},", obj.gcys); sb.AppendFormat("{0},", obj.phcx); sb.AppendFormat("{0},", obj.phcx1); sb.AppendFormat("{0},", obj.phcx2); sb.AppendFormat("{0},", obj.phcx3); sb.AppendFormat("{0},", obj.phcx4); sb.AppendFormat("{0},", obj.phcx5); sb.AppendFormat("{0},", obj.td); } string path = Helper.ExportAsCsvFile(sb); Response.Redirect(path); } }
protected void btnDown_Click(object sender, EventArgs e) { DateTime dfrom = DateTime.Parse(tbDateFrom.Text); DateTime dto = DateTime.Parse(tbDateTo.Text).AddDays(1); using (LandRoverOldDbDataContext ctx = new LandRoverOldDbDataContext()) { var list = from u in ctx.shijia1 where u.times >= dfrom && u.times < dto select u; var data = list.ToList(); if (data.Count == 0) return; StringBuilder sb = new StringBuilder("id,sex,username,date,sheng,city,address,youbian,email,dianhua,shouji,chexing,sjsj,jxssf,jxscs,jxs,lxfs,times,gcsj,gcys,phcx,phcx1,phcx2,phcx3,phcx4,owner,boughtdate,carbrand,carmodel,brochure"); foreach (var obj in data) { sb.AppendLine(); sb.AppendFormat("{0},", obj.id); sb.AppendFormat("{0},", obj.sex); sb.AppendFormat("\"{0}\",", Helper.FormatForCSV(obj.username)); sb.AppendFormat("{0},", obj.date); sb.AppendFormat("{0},", obj.sheng); sb.AppendFormat("{0},", obj.city); sb.AppendFormat("\"{0}\",", Helper.FormatForCSV(obj.address)); sb.AppendFormat("\"{0}\",", Helper.FormatForCSV(obj.youbian)); sb.AppendFormat("\"{0}\",", Helper.FormatForCSV(obj.email)); sb.AppendFormat("\"{0}\",", Helper.FormatForCSV(obj.dianhua)); sb.AppendFormat("\"{0}\",", Helper.FormatForCSV(obj.shouji)); sb.AppendFormat("\"{0}\",", Helper.FormatForCSV(obj.chexing)); sb.AppendFormat("{0},", obj.sjsj); sb.AppendFormat("{0},", obj.jxssf); sb.AppendFormat("{0},", obj.jxscs); sb.AppendFormat("{0},", obj.jxs); sb.AppendFormat("{0},", obj.lxfs); sb.AppendFormat("{0},", obj.times); sb.AppendFormat("{0},", obj.gcsj); sb.AppendFormat("{0},", obj.gcys); sb.AppendFormat("{0},", obj.phcx); sb.AppendFormat("{0},", obj.phcx1); sb.AppendFormat("{0},", obj.phcx2); sb.AppendFormat("{0},", obj.phcx3); sb.AppendFormat("{0},", obj.phcx4); sb.AppendFormat("{0},", obj.owner); sb.AppendFormat("{0},", obj.boughtdate); sb.AppendFormat("{0},", obj.carbrand); sb.AppendFormat("\"{0}\",", Helper.FormatForCSV(obj.carmodel)); sb.AppendFormat("{0},", obj.brochure); } string path = Helper.ExportAsCsvFile(sb); Response.Redirect(path); } }
protected void btnDown_Click(object sender, EventArgs e) { DateTime dfrom = DateTime.Parse(tbDateFrom.Text); DateTime dto = DateTime.Parse(tbDateTo.Text).AddDays(1); using (LandRoverOldDbDataContext ctx = new LandRoverOldDbDataContext()) { var list = from u in ctx.users where u.times >= dfrom && u.times < dto select new { ID = u.id, Name = u.username, Email = u.email, Phone = u.phone, Sub = u.enews, Model = u.carStyle, Time = u.times, Source = u.receive }; var data = list.ToList(); if (data.Count == 0) return; StringBuilder sb = new StringBuilder("id,username,email,phone,enews,carStyle,times,receive"); Regex quote = new Regex("\""); foreach (var obj in data) { sb.AppendLine(); sb.AppendFormat("{0},", obj.ID); sb.AppendFormat("\"{0}\",", Helper.FormatForCSV(obj.Name)); sb.AppendFormat("\"{0}\",", Helper.FormatForCSV(obj.Email)); sb.AppendFormat("\"{0}\",", Helper.FormatForCSV(obj.Phone)); sb.AppendFormat("{0},", obj.Sub); sb.AppendFormat("\"{0}\",", Helper.FormatForCSV(obj.Model)); sb.AppendFormat("{0},", obj.Time); sb.AppendFormat("{0},", obj.Source); } string path = Helper.ExportAsCsvFile(sb); Response.Redirect(path); } }
protected void btnFilter_Click(object sender, EventArgs e) { DateTime dfrom = DateTime.Parse(tbDateFrom.Text); DateTime dto = DateTime.Parse(tbDateTo.Text).AddDays(1); using (LandRoverOldDbDataContext ctx = new LandRoverOldDbDataContext()) { var list = from u in ctx.users where u.times >= dfrom && u.times < dto && u.receive == "effect2011" select new { ID = u.id, Name = u.username, Email = u.email, Phone = u.phone, Sub = u.enews, Time = u.times, Source = u.receive }; dataList.DataSource = list.ToList(); dataList.DataBind(); } }