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;
