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()));
}
}
