public JsonResult ViewReceiptEditSave(T_Receipt model, string jsonStr) { using (TransactionScope sc = new TransactionScope()) { try { List <T_ReceiptDetails> details = Com.Deserialize <T_ReceiptDetails>(jsonStr); var receipt = db.T_Receipt.Find(model.ID); receipt.Receivings = model.Receivings; receipt.Vip_Name = model.Vip_Name; receipt.StorName = model.StorName; receipt.Money = model.Money; db.SaveChanges(); if (details != null) { foreach (var item in details) { var itemdetail = db.T_ReceiptDetails.Find(item.ID); itemdetail.ProductName = item.ProductName; itemdetail.Qty = item.Qty; itemdetail.Unit = item.Unit; } db.SaveChanges(); } sc.Complete(); return(Json(new { State = "Success" }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { State = "Faile", Message = ex.Message }, JsonRequestBehavior.AllowGet)); } } }
public JsonResult UpdateprintCountByID(int id) { try { T_Receipt model = db.T_Receipt.Find(id); model.PrintCount += 1; db.SaveChanges(); return(Json(new { State = "Success" }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { State = "Faile", Message = ex.Message })); } }
public JsonResult RecieptDelete(int id) { try { T_Receipt model = db.T_Receipt.Find(id); model.IsDelete = 1; db.SaveChanges(); return(Json(new { State = "Success" }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { State = "Faile", Message = ex.Message }, JsonRequestBehavior.AllowGet)); } }
protected void updateUser_Click(object sender, EventArgs e) { ReceiptAdapter da = new ReceiptAdapter(); T_Receipt item = new T_Receipt(); item.Code = this.txt_code.Text.Trim(); item.Name = this.txt_name.Text.Trim(); if (string.IsNullOrEmpty(item.Code)) { Label1.Text = "部门代码不能为空"; return; } if (string.IsNullOrEmpty(item.Name)) { Label1.Text = "部门名称不能为空"; return; } if (string.IsNullOrEmpty(HiddenField1.Value)) { //新增 try { da.addReceipt(item); Label1.Text = "新增成功"; init(); GridViewBand(); } catch (Exception ex) { Label1.Text = ex.Message; } } else { //更新 item.Id = Int32.Parse(HiddenField1.Value); try { da.updateReceipt(item); Label1.Text = "保存成功"; init(); GridViewBand(); } catch (Exception ex) { Label1.Text = ex.Message; } } }
/// <summary> /// 打印 /// </summary> /// <param name="id"></param> /// <param name="page"></param> /// <returns></returns> public ActionResult ViewReceiptPrint(int id, int page = 1) { if (id == 0) { return(HttpNotFound()); } T_Receipt model = db.T_Receipt.Find(id); IQueryable <T_ReceiptDetails> list = db.T_ReceiptDetails.Where(s => s.ReceiptOrderID == model.ID); int totalRows = list.Count(); int total = 0; string href = ""; if (totalRows % 10 != 0) { total = totalRows / 10 + 1; } else { total = totalRows / 6; } for (int i = 1; i <= total; i++) { href += "<a href=\"?page=" + i + "&id=" + id + "\"> " + i + " </a>"; } Recipts models = new Recipts { ID = model.ID, StorName = model.StorName, ShopDate = model.ShopDate, Vip_Name = model.Vip_Name, Receivings = model.Receivings, Money = model.Money, receiptDetails = list.OrderByDescending(s => s.ID).Skip((page - 1) * 10).Take(10).ToList() }; ViewData["pager"] = href; ViewData["page"] = page; ViewData["total"] = total; return(View(models)); }
public void updateReceipt(T_Receipt item) { Manager.updateReceipt(item); }
public void addReceipt(T_Receipt item) { Manager.addReceipt(item); }
public JsonResult ViewReceiptAddSave(T_Receipt model, string jsonStr) { using (TransactionScope sc = new TransactionScope()) { try { GY gy = new GY(); string cmd = ""; cmd = "{" + "\"appkey\":\"171736\"," + "\"method\":\"gy.erp.trade.get\"," + "\"page_no\":1," + "\"page_size\":10," + "\"platform_code\":\"" + model.OrderCode + "\"," + "\"sessionkey\":\"f5885504d9c84d1d8146200a4841f4b7\"" + "}"; string sign = gy.Sign(cmd); cmd = cmd.Replace("}", ",\"sign\":\"" + sign + "\"}"); string ret = gy.DoPost("http://api.guanyierp.com/rest/erp_open", cmd); JsonData jsonData = null; jsonData = JsonMapper.ToObject(ret); if (jsonData.Count == 6 || jsonData["orders"].Count == 0) { cmd = "{" + "\"appkey\":\"171736\"," + "\"method\":\"gy.erp.trade.history.get\"," + "\"page_no\":1," + "\"page_size\":10," + "\"platform_code\":\"" + model.OrderCode + "\"," + "\"sessionkey\":\"f5885504d9c84d1d8146200a4841f4b7\"" + "}"; sign = gy.Sign(cmd); cmd = cmd.Replace("}", ",\"sign\":\"" + sign + "\"}"); ret = gy.DoPost("http://api.guanyierp.com/rest/erp_open", cmd); jsonData = null; jsonData = JsonMapper.ToObject(ret); if (jsonData.Count == 6 || jsonData["orders"].Count == 0) { return(Json(new { State = "Faile", Message = "订单号不存在" })); } } JsonData jsonOrders = jsonData["orders"][0]; List <T_ReceiptDetails> details = Com.Deserialize <T_ReceiptDetails>(jsonStr); //T_OrderList order = db.T_OrderList.Find(model.OrderId); string code = "SKSJ"; string date = DateTime.Now.ToString("yyyyMMdd"); List <T_Receipt> list = db.T_Receipt.Where(s => s.Code.Contains(date)).OrderByDescending(s => s.ID).ToList(); if (list.Count == 0) { code += date + "0001"; } else { string old = list[0].Code.Substring(12); int newCode = int.Parse(old) + 1; code += date + newCode.ToString().PadLeft(4, '0'); } model.Code = code; model.Date = DateTime.Now; model.IsDelete = 0; model.ShopDate = DateTime.Parse(jsonOrders["createtime"].ToString()); model.PostUser = UserModel.Nickname; model.PrintCount = 0; db.T_Receipt.Add(model); db.SaveChanges(); if (details != null) { foreach (var item in details) { item.ReceiptOrderID = model.ID; db.T_ReceiptDetails.Add(item); } db.SaveChanges(); } sc.Complete(); return(Json(new { State = "Success" }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { State = "Faile", Message = ex.Message }, JsonRequestBehavior.AllowGet)); } } }
/// <summary> /// 查询管易订单 /// </summary> /// <param name="code"></param> /// <returns></returns> public JsonResult GetReceiptByGy(string code) { GY gy = new GY(); string cmd = ""; cmd = "{" + "\"appkey\":\"171736\"," + "\"method\":\"gy.erp.trade.get\"," + "\"page_no\":1," + "\"page_size\":10," + "\"platform_code\":\"" + code + "\"," + "\"sessionkey\":\"f5885504d9c84d1d8146200a4841f4b7\"" + "}"; string sign = gy.Sign(cmd); cmd = cmd.Replace("}", ",\"sign\":\"" + sign + "\"}"); string ret = gy.DoPost("http://api.guanyierp.com/rest/erp_open", cmd); JsonData jsonData = null; jsonData = JsonMapper.ToObject(ret); if (jsonData.Count == 6 || jsonData["orders"].Count == 0) { cmd = "{" + "\"appkey\":\"171736\"," + "\"method\":\"gy.erp.trade.history.get\"," + "\"page_no\":1," + "\"page_size\":10," + "\"platform_code\":\"" + code + "\"," + "\"sessionkey\":\"f5885504d9c84d1d8146200a4841f4b7\"" + "}"; sign = gy.Sign(cmd); cmd = cmd.Replace("}", ",\"sign\":\"" + sign + "\"}"); ret = gy.DoPost("http://api.guanyierp.com/rest/erp_open", cmd); jsonData = null; jsonData = JsonMapper.ToObject(ret); if (jsonData.Count == 6 || jsonData["orders"].Count == 0) { return(Json(new { State = "Faile", Message = "订单号不存在" })); } } JsonData jsonOrders = jsonData["orders"][0]; //订单信息 string platform_code = isNULL(jsonOrders["platform_code"]).ToString(); //店铺名称 string shop_name = isNULL(jsonOrders["shop_name"]).ToString(); //旺旺帐号 string vip_name = isNULL(jsonOrders["vip_name"]).ToString(); string receiver_name = isNULL(jsonOrders["receiver_name"]).ToString(); string payment = isNULL(jsonOrders["payment"]).ToString(); T_Receipt model = new T_Receipt(); model.OrderCode = code; model.Receivings = receiver_name; model.Money = decimal.Parse(payment); model.Vip_Name = receiver_name; model.StorName = shop_name; List <T_ReceiptDetails> DetailsList = new List <T_ReceiptDetails>(); JsonData jsonDetails = jsonOrders["details"]; for (int i = 0; i < jsonDetails.Count; i++) { T_ReceiptDetails DetailsModel = new T_ReceiptDetails(); DetailsModel.ProductName = jsonDetails[i]["item_name"] == null ? "" : jsonDetails[i]["item_name"].ToString(); DetailsModel.Unit = jsonDetails[i]["item_simple_name"] == null ? "" : jsonDetails[i]["item_simple_name"].ToString(); DetailsModel.Qty = jsonDetails[i]["qty"] == null ? 0 : int.Parse(jsonDetails[i]["qty"].ToString()); DetailsList.Add(DetailsModel); } var json = new { rows = (from r in DetailsList select new T_ReceiptDetails { ProductName = r.ProductName, Unit = r.Unit, Qty = r.Qty }).ToArray() }; return(Json(new { State = "Success", ModelList = model, Json = json }, JsonRequestBehavior.AllowGet)); }