public static void X() { int A = int.Parse(Console.ReadLine()); req R = new req(); if (A > 9) { R.Recursion(A, ""); string result = R.MinNumber(); Console.WriteLine(result); } else if (A > 0) { Console.WriteLine(A); } else { Console.WriteLine(10); } }
public ActionResult savebp1(req req) { if (Session["UserName"] != null) { using (AdityamineralsEntities objDB = new AdityamineralsEntities()) { req.uom = objDB.ADM_M_BILLINGPRODUCTS.Where(v => v.Sno == req.prodid).Select(c => c.UOM_Name).FirstOrDefault(); int count = objDB.ADM_L_BILLINGPART2.Where(c => c.InvoiceNo == req.invoiceno && c.Sno == req.prodid).Count(); if (count > 0) { req.bp2 = objDB.ADM_L_BILLINGPART2.Where(c => c.InvoiceNo == req.invoiceno && c.Sno == req.prodid).FirstOrDefault(); return(PartialView("_editbillprod", req)); } else { return(PartialView("_editbillprodA", req)); } } } else { return(RedirectToAction("Login", "Login")); } }
req.getRequestDispatcher(url).include(req, res);
private static HttpClient _Client4 = HttpClient.Default.Use(async(req, client) => {
protected override void AjaxRequest(HttpContext pContext) { var loggingSessionInfo = new SessionManager().CurrentUserLoginInfo; //登录状态信息 JavaScriptSerializer Serializer = new JavaScriptSerializer(); req _model = Serializer.Deserialize <req>(Request("req").ToString()); var model = _model.parameters; List <IWhereCondition> pWhereConditions = new List <IWhereCondition>() { new EqualsCondition() { FieldName = "a.CustomerId", Value = loggingSessionInfo.ClientID }, new EqualsCondition() { FieldName = "a.IsDelete", Value = 0 }, new EqualsCondition() { FieldName = "a.Status", Value = "10" } }; if (!String.IsNullOrEmpty(model.SuperRetailTraderName)) { pWhereConditions.Add(new LikeCondition() { FieldName = "a.SuperRetailTraderName", Value = "%" + model.SuperRetailTraderName + "%" }); } if (!String.IsNullOrEmpty(model.SuperRetailTraderFrom)) { pWhereConditions.Add(new EqualsCondition() { FieldName = "a.SuperRetailTraderFrom", Value = model.SuperRetailTraderFrom }); } if (!String.IsNullOrEmpty(model.JoinSatrtTime)) { pWhereConditions.Add(new DirectCondition() { Expression = "a.JoinTime>='" + model.JoinSatrtTime + "'" }); } if (!String.IsNullOrEmpty(model.JoinEndTime)) { pWhereConditions.Add(new DirectCondition() { Expression = "a.JoinTime<='" + model.JoinEndTime + "'" }); } T_SuperRetailTraderBLL bll = new T_SuperRetailTraderBLL(loggingSessionInfo); PagedQueryResult <T_SuperRetailTraderEntity> models = bll.FindListByCustomerId(pWhereConditions.ToArray(), null, loggingSessionInfo.ClientID); try { string MapUrl = pContext.Server.MapPath(@"~/Framework/Upload/" + DateTime.Now.ToString("yyyy.MM.dd") + "分销商明细" + ".xls"); Aspose.Cells.License lic = new Aspose.Cells.License(); lic.SetLicense("Aspose.Total.lic"); Workbook workbook = new Workbook(); Worksheet sheet = workbook.Worksheets[0]; Cells cells = sheet.Cells;//单元格 #region //为标题设置样式 Style styleTitle = workbook.Styles[workbook.Styles.Add()]; //新增样式 styleTitle.HorizontalAlignment = TextAlignmentType.Center; //文字居中 styleTitle.Font.Name = "宋体"; //文字字体 styleTitle.Font.Size = 18; //文字大小 styleTitle.Font.IsBold = true; //粗体 //样式2 Style style2 = workbook.Styles[workbook.Styles.Add()]; //新增样式 style2.HorizontalAlignment = TextAlignmentType.Center; //文字居中 style2.Font.Name = "宋体"; //文字字体 style2.Font.Size = 14; //文字大小 style2.Font.IsBold = true; //粗体 style2.IsTextWrapped = true; //单元格内容自动换行 style2.Borders[BorderType.LeftBorder].LineStyle = CellBorderType.Thin; style2.Borders[BorderType.RightBorder].LineStyle = CellBorderType.Thin; style2.Borders[BorderType.TopBorder].LineStyle = CellBorderType.Thin; style2.Borders[BorderType.BottomBorder].LineStyle = CellBorderType.Thin; //样式3 Style style3 = workbook.Styles[workbook.Styles.Add()]; //新增样式 style3.HorizontalAlignment = TextAlignmentType.Center; //文字居中 style3.Font.Name = "宋体"; //文字字体 style3.Font.Size = 12; //文字大小 style3.Borders[BorderType.LeftBorder].LineStyle = CellBorderType.Thin; style3.Borders[BorderType.RightBorder].LineStyle = CellBorderType.Thin; style3.Borders[BorderType.TopBorder].LineStyle = CellBorderType.Thin; style3.Borders[BorderType.BottomBorder].LineStyle = CellBorderType.Thin; #endregion //生成行1 标题行 cells.Merge(0, 0, 1, 8); //合并单元格 cells[0, 0].PutValue("分销商明细"); //填写内容 cells[0, 0].SetStyle(styleTitle); cells.SetRowHeight(0, 38); List <SuperRetailTraderListInfo> lst = models.Entities.Select(m => new SuperRetailTraderListInfo() { JoinTime = Convert.ToDateTime(m.JoinTime).ToString("yyyy-MM-dd HH:mm:ss"), NumberOffline = m.NumberOffline, OrderCount = m.OrderCount, SuperRetailTraderFrom = m.SuperRetailTraderFrom, SuperRetailTraderName = m.SuperRetailTraderName, SuperRetailTraderPhone = m.SuperRetailTraderPhone, WithdrawCount = m.WithdrawCount, WithdrawTotalMoney = m.WithdrawTotalMoney }).ToList(); //生成行2 列名行 for (int i = 0; i < 8; i++) { cells.SetColumnWidth(i, 30); } #region 列明 cells[1, 0].PutValue("分销商姓名"); cells[1, 0].SetStyle(style2); cells.SetRowHeight(1, 25); cells[1, 1].PutValue("分销商手机号码"); cells[1, 1].SetStyle(style2); cells.SetRowHeight(1, 25); cells[1, 2].PutValue("分销商来源"); cells[1, 2].SetStyle(style2); cells.SetRowHeight(1, 25); cells[1, 3].PutValue("分销商下线人数"); cells[1, 3].SetStyle(style2); cells.SetRowHeight(1, 25); cells[1, 4].PutValue("分销商订单总数"); cells[1, 4].SetStyle(style2); cells[1, 5].PutValue("分销商提现次数"); cells[1, 5].SetStyle(style2); cells[1, 6].PutValue("分销商提现总金额"); cells[1, 6].SetStyle(style2); cells[1, 7].PutValue("加盟时间"); cells[1, 7].SetStyle(style2); cells.SetRowHeight(1, 25); #endregion #region 生成数据行 for (int i = 0; i < lst.Count; i++) { cells[2 + i, 0].PutValue(lst[i].SuperRetailTraderName); cells[2 + i, 0].SetStyle(style3); cells[2 + i, 1].PutValue(lst[i].SuperRetailTraderPhone); cells[2 + i, 1].SetStyle(style3); cells[2 + i, 2].PutValue(lst[i].SuperRetailTraderFrom.ToLower() == "vip" ? "会员" : "店员"); cells[2 + i, 2].SetStyle(style3); cells[2 + i, 3].PutValue(lst[i].NumberOffline); cells[2 + i, 3].SetStyle(style3); cells[2 + i, 4].PutValue(lst[i].OrderCount); cells[2 + i, 4].SetStyle(style3); cells[2 + i, 5].PutValue(lst[i].WithdrawCount); cells[2 + i, 5].SetStyle(style3); cells[2 + i, 6].PutValue(lst[i].WithdrawTotalMoney); cells[2 + i, 6].SetStyle(style3); cells[2 + i, 7].PutValue(lst[i].JoinTime); cells[2 + i, 7].SetStyle(style3); cells.SetRowHeight(2 + i, 24); } #endregion workbook.Save(MapUrl); Utils.OutputExcel(pContext, MapUrl);//输出Excel文件 } catch (Exception ex) { throw (ex); } }
var(req, res) = output;