public ActionResult testcheck1(string data) { StringBuilder sb = new StringBuilder(data); sb.Append(CheckA.checksum(data)); ViewData["Qrcode"] = sb.ToString(); return(Content("62210" + sb.ToString())); }
public ActionResult exceportMbills() { var mb1 = mb1Service.GetEntities(b => true).AsQueryable().ToList(); List <string> checkesum1 = new List <string>(); foreach (var item in mb1) { string b = item.account.ToString().Substring(item.account.ToString().Length - 3, 3); string straccount = b; StringBuilder sb = new StringBuilder(); sb.Append(straccount); sb.Append(item.billno.ToString()); // sb.ToString(); string Ocode = CheckA.checksum(sb.ToString()); checkesum1.Add("62210" + sb.ToString() + Ocode); } HSSFWorkbook book = new HSSFWorkbook(); ISheet sheet1 = book.CreateSheet("sheet1"); IRow row1 = sheet1.CreateRow(0); row1.CreateCell(0).SetCellValue("account"); row1.CreateCell(2).SetCellValue("billno"); row1.CreateCell(3).SetCellValue("prev"); row1.CreateCell(4).SetCellValue("pres"); row1.CreateCell(5).SetCellValue("unit"); row1.CreateCell(6).SetCellValue("type"); row1.CreateCell(7).SetCellValue("bf"); row1.CreateCell(8).SetCellValue("odd"); row1.CreateCell(9).SetCellValue("chg"); row1.CreateCell(10).SetCellValue("misc"); row1.CreateCell(11).SetCellValue("bill"); row1.CreateCell(12).SetCellValue("auto"); row1.CreateCell(13).SetCellValue("descs"); row1.CreateCell(14).SetCellValue("name"); row1.CreateCell(15).SetCellValue("address1"); row1.CreateCell(16).SetCellValue("address2"); row1.CreateCell(17).SetCellValue("address3"); row1.CreateCell(18).SetCellValue("date"); row1.CreateCell(1).SetCellValue("paycode"); for (int i = 0; i < mb1.Count; i++) { IRow rowtemp = sheet1.CreateRow(i + 1); rowtemp.CreateCell(0).SetCellValue(mb1[i].account.ToString()); rowtemp.CreateCell(1).SetCellValue(checkesum1[i].ToString()); rowtemp.CreateCell(2).SetCellValue(mb1[i].billno.ToString()); rowtemp.CreateCell(3).SetCellValue(mb1[i].prev.ToString()); rowtemp.CreateCell(4).SetCellValue(mb1[i].pres.ToString()); rowtemp.CreateCell(5).SetCellValue(mb1[i].unit.ToString()); rowtemp.CreateCell(6).SetCellValue(mb1[i].type.ToString()); rowtemp.CreateCell(7).SetCellValue(mb1[i].bf.ToString()); rowtemp.CreateCell(8).SetCellValue(mb1[i].odd.ToString()); rowtemp.CreateCell(9).SetCellValue(mb1[i].chg.ToString()); rowtemp.CreateCell(10).SetCellValue(mb1[i].misc.ToString()); rowtemp.CreateCell(11).SetCellValue(mb1[i].bill.ToString()); rowtemp.CreateCell(12).SetCellValue(mb1[i].auto.ToString()); rowtemp.CreateCell(13).SetCellValue(mb1[i].descs.ToString()); rowtemp.CreateCell(14).SetCellValue(mb1[i].name.ToString()); rowtemp.CreateCell(15).SetCellValue(mb1[i].address1.ToString()); rowtemp.CreateCell(16).SetCellValue(mb1[i].address2.ToString()); rowtemp.CreateCell(17).SetCellValue(mb1[i].address3.ToString()); rowtemp.CreateCell(18).SetCellValue(mb1[i].date.ToString()); } MemoryStream ms = new MemoryStream(); book.Write(ms); ms.Seek(0, SeekOrigin.Begin); return(File(ms, "application/vnd.ms-excel", "code.xls")); // return View(); }