public ActionResult Save(SE_ShareMakeMoneyConfig model) { ShareMakeMoneyManager manager = new ShareMakeMoneyManager(); if (manager.Save(model, User.Identity.Name)) { return(Json(1)); } else { return(Json(0)); } }
public ActionResult SelectProducts(string datetime, string pid, string displayName, string times, string status, int id) { ShareMakeMoneyManager manager = new ShareMakeMoneyManager(); return(Content(JsonConvert.SerializeObject(manager.GetProductEntities(datetime, pid, displayName, times, status, id).OrderByDescending(p => p.CreateDate).Select(o => new { BatchGuid = o.BatchGuid, CreateDate = string.Format("{0:yyyy-MM-dd}", o.CreateDate), DisplayName = o.DisplayName, ID = o.ID, IsMakeMoney = o.IsMakeMoney == true ? "启用" : "禁用", IsShare = o.IsShare == true ? "显示" : "不显示", Orderby = o.Orderby, PID = o.PID, Times = o.Times })))); }
/// <summary> /// 上传 xlsx /// </summary> /// <returns></returns> public ActionResult AddProduct(int id) { try { //var file = Request.Files[0]; // if (!file.FileName.Contains(".xlsx") || !file.FileName.Contains(".xls")) // return Json(new { Status = -1, Error = "请上传.xlsx文件或者.xls文件" }, "text/html"); // var excel = new Tuhu.Provisioning.Controls.ExcelHelper(file.InputStream, file.FileName); // var dt = excel.ExcelToDataTable("分享赚钱活动产品", true); ShareMakeMoneyManager manager = new ShareMakeMoneyManager(); var dt = manager.GetFenxiangzhuanqianProduct(); if (dt == null || dt.Rows.Count == 0) { return(Content(JsonConvert.SerializeObject(new { Status = -1, Error = "没有要同步的数据" }))); } List <SE_ShareMakeImportProducts> list = new List <SE_ShareMakeImportProducts>(); Guid BatchGuid = Guid.NewGuid(); int i = 1; foreach (DataRow dr in dt.Rows) { if (string.IsNullOrWhiteSpace(dr["PID"].ToString())) { continue; } double times = Convert.ToDouble(dr["multiple"].ToString()); if (times < 0.1 || times > 10) { return(Json(new { Status = -1, Error = "积分奖励倍数不符合,配置的PID:" + dr["PID"].ToString() + "积分奖励倍数:" + dr[2].ToString() }, "text/html")); } list.Add(new SE_ShareMakeImportProducts() { BatchGuid = BatchGuid.ToString(), IsMakeMoney = true, IsShare = false, Orderby = i++, PID = dr["PID"].ToString(), Times = dr["multiple"].ToString() }); } using (var client = new Tuhu.Service.Product.ProductClient()) { int baseNumber = 1000; int number = (list.Count / baseNumber); for (int j = 0; j <= number; j++) { var temp = list.GetRange(j * baseNumber, list.Count < baseNumber ? list.Count : ((j + 1) * baseNumber - list.Count) > 0 ? (list.Count - (j * baseNumber)) : baseNumber); var result = client.SelectSkuProductListByPids(temp.Select(o => o.PID).ToList()); result.ThrowIfException(true); if (result.Success) { var pids = result.Result.Select(o => o.Pid); foreach (var item in temp) { if (!pids.Contains(item.PID)) { return(Content(JsonConvert.SerializeObject((new { Status = -1, Error = "PID配置有误:PID:" + item.PID })))); } else { if (temp.Where(o => o.PID == item.PID).Count() > 1) { return(Content(JsonConvert.SerializeObject(new { Status = -1, Error = "PID配置有误,同一批次不能有相同的:PID:" + item.PID }))); } var product = result.Result.Where(o => o.Pid == item.PID).FirstOrDefault(); if (product == null) { return(Content(JsonConvert.SerializeObject(new { Status = -1, Error = "PID未查询出来误:PID:" + item.PID }))); } else { item.DisplayName = product.DisplayName; } } } } else { return(Content(JsonConvert.SerializeObject(new { Status = -1, Error = "调用服务验证产品信息失败" + result.ErrorMessage }))); } } } int resultID = manager.AddProducts(list, id); if (resultID > 0) { return(Content(JsonConvert.SerializeObject(new { Status = 0, ID = resultID }))); } else { return(Content(JsonConvert.SerializeObject(new { Status = -1, Error = "保存失败" }))); } } catch (Exception em) { return(Content(JsonConvert.SerializeObject(new { Status = -1, Error = "请检查文件内容格式是否正确", ErrorMsg = em.Message }))); } }