public ActionResult SearchByContact() { string contact = Request.Form["contact"]; Regex regex = new Regex(@"^\b[A-Z]+\d+\b$"); Dictionary <int, string> kamis = new Dictionary <int, string>(); string tNo = ""; if (!regex.IsMatch(contact)) { kamis = BKaMi.SearchKamiByContact(contact, ref tNo); if (kamis.Count == 0) { return(Content("未查到对应订单信息")); } } else { kamis = BKaMi.SearchKamiByContact("", ref contact); tNo = contact; if (kamis.Count == 0) { return(Content("未查到对应订单信息")); } } ViewBag.tNo = tNo; return(View("KaMiList", kamis)); }
public ActionResult Add() { string name = Request.Form["proT"]; if (string.IsNullOrEmpty(name)) { return(Content(ReturnMsg.empty.ToString())); } KaMiViewModel model = LitJson.JsonMapper.ToObject <KaMiViewModel>(name); if (model == null) { return(Content(ReturnMsg.fail.ToString())); } if (model.Content.Contains("\n")) { //批量操作 string kamis = model.Content; string[] contentArr = kamis.Split(new char[] { '\n' }, StringSplitOptions.RemoveEmptyEntries); List <KaMiViewModel> kamiModes = new List <KaMiViewModel>(); foreach (var item in contentArr) { KaMiViewModel subModel = new KaMiViewModel(); subModel.Product_Id = model.Product_Id; subModel.ProductType_Id = model.ProductType_Id; subModel.Remark = model.Remark; subModel.Content = item; kamiModes.Add(subModel); } if (BKaMi.Insert(kamiModes)) { return(Content(ReturnMsg.success.ToString())); } else { return(Content(ReturnMsg.fail.ToString())); } } else { //单个操作 model.AddedTime = DateTime.Now; model.UpdateTime = DateTime.Now; if (BKaMi.Insert(model)) { return(Content(ReturnMsg.success.ToString())); } else { return(Content(ReturnMsg.fail.ToString())); } } }
public JsonResult GetKaMis(int limit, int offset, string departmentname, string productType, string product) { List <KaMiViewModel> lstRes = null; if (!string.IsNullOrEmpty(departmentname) || (!string.IsNullOrEmpty(productType) && !string.IsNullOrEmpty(product))) { lstRes = BKaMi.SearchBysql(departmentname, productType, product); } else { lstRes = BKaMi.SearchAll(); } var total = lstRes.Count; var rows = lstRes.Skip(offset).Take(limit).ToList(); return(Json(new { total = total, rows = rows }, JsonRequestBehavior.AllowGet)); }
public ActionResult KaMiList() { //查询卡密,并显示 string tNo = Request.QueryString["tNo"]; OrderViewModel order = BOrder.SearchByTradeNo(tNo); if (order == null) { return(View()); } Dictionary <int, string> kamis = BKaMi.SearchKamiByTrade(order); #region 更新卡密状态为已使用 List <KaMiViewModel> models = new List <KaMiViewModel>(); foreach (var item in kamis) { KaMiViewModel ka = new KaMiViewModel(); ka.Id = item.Key; ka.Remark = order.Remark; ka.Trade_No = tNo; models.Add(ka); } BKaMi.UpdateBySql(models); #endregion string dir = Server.MapPath("~/Files"); string path = dir + "/" + tNo + ".csv"; using (StreamWriter writer = new StreamWriter(path, true, Encoding.UTF8)) { string title = "订单号,卡密内容,联系方式\r\n"; writer.Write(title); string content = ""; foreach (var item in kamis) { content += tNo + "," + item.Value + "," + order.Remark + "\r\n"; } writer.Write(content); } ViewBag.tNo = tNo; return(View(kamis)); }
public ActionResult Delete() { string name = Request.Form["pId"]; List <DeleteId> models = LitJson.JsonMapper.ToObject <List <DeleteId> >(name); if (models == null) { return(Content(ReturnMsg.fail.ToString())); } bool isSucc = BKaMi.Delete(models.Select(_ => _.Id).ToList()); if (isSucc) { return(Content(ReturnMsg.success.ToString())); } else { return(Content(ReturnMsg.fail.ToString())); } }
public ActionResult Update() { string newName = Request.Form["proM"]; KaMiViewModel model = LitJson.JsonMapper.ToObject <KaMiViewModel>(newName); model.UpdateTime = DateTime.Now; if (model == null) { return(Content(ReturnMsg.fail.ToString())); } if (string.IsNullOrEmpty(model.Content)) { return(Content(ReturnMsg.empty.ToString())); } if (BKaMi.Update(model)) { return(Content(ReturnMsg.success.ToString())); } else { return(Content(ReturnMsg.fail.ToString())); } }