public ActionResult ResetOrdercode(Int64?purch_id, string OrderCode) { GoodsReceivedResult com = new GoodsReceivedResult(); if (purch_id == 0) { com.Msg = "参数错误!"; com.success = false; return(Json(com)); } if (string.IsNullOrWhiteSpace(OrderCode)) { com.Msg = "请填写淘宝订单号!"; com.success = false; return(Json(com)); } try { com = _service.ResetOrdercode(purch_id, OrderCode); return(Json(com)); } catch (Exception ex) { com.Msg = ex.Message; com.success = false; return(Json(com)); } }
public GoodsReceivedResult ResetOrdercode(long?purch_id, string OrderCode) { bool isok = false; GoodsReceivedResult result = new GoodsReceivedResult(); using (var db = SugarDao.GetInstance(LoginUser.GetConstr())) { try { busi_purchase pur = db.Queryable <busi_purchase>().Where(s => s.purch_id == purch_id).FirstOrDefault(); pur.OrderCode = OrderCode; isok = db.Update <busi_purchase>(pur); if (isok) { result.success = true; result.Msg = "操作成功"; return(result); } else { result.success = false; result.Msg = "操作失败"; return(result); } } catch (Exception ex) { result.success = false; result.Msg = "操作失败" + ex.Message; return(result); } } }
public ActionResult Getpage(string pagenum, string onepagecount, string tb_order_code) { GoodsReceivedResult com = new GoodsReceivedResult(); InternationalQuiryResult coms = new InternationalQuiryResult(); if (!Regex.IsMatch(pagenum, @"(?i)^[0-9a-z\u4e00-\u9fa5]+$") && !string.IsNullOrEmpty(pagenum)) { com.Msg = "页数不正确"; com.success = false; return(Json(com)); } if (!Regex.IsMatch(onepagecount, @"(?i)^[0-9a-z\u4e00-\u9fa5]+$") && !string.IsNullOrEmpty(onepagecount)) { com.Msg = "每页数量不正确"; com.success = false; return(Json(com)); } int totil = 0; int totilpage = 0; string exmsg = string.Empty; List <GoodsReceivedModel> mylist = _service.GetGoodsReceivedList(Convert.ToInt32(pagenum), Convert.ToInt32(onepagecount), tb_order_code, out totil, out totilpage, out exmsg); coms = _internationalQuiry.GetExpressList(); if (!string.IsNullOrEmpty(exmsg)) { com.Msg = exmsg; com.success = false; return(Json(com)); } else { GoodsReceivedViewModel mylistview = new GoodsReceivedViewModel(); mylistview.supplist = mylist; mylistview.totil = totil.ToString(); mylistview.totilcount = totilpage.ToString(); if (coms.success) { mylistview.express_info = coms.Msg; } else { mylistview.express_info = null; } com.DataResult = mylistview; com.success = true; return(Json(com)); } }
public ActionResult AddCode(Int64?purch_id, Int64?express_id, string express_code, string express_name, string OrderCode) { GoodsReceivedResult com = new GoodsReceivedResult(); if (purch_id == 0) { com.Msg = "参数错误!"; com.success = false; return(Json(com)); } if (express_id == 0 || string.IsNullOrEmpty(express_name)) { com.Msg = "请选择快递公司!"; com.success = false; return(Json(com)); } if (string.IsNullOrWhiteSpace(express_code)) { com.Msg = "请填写快递单号!"; com.success = false; return(Json(com)); } if (string.IsNullOrWhiteSpace(OrderCode)) { com.Msg = "请填写淘宝订单号!"; com.success = false; return(Json(com)); } try { com = _service.AddCode(purch_id, express_id, express_code, express_name, OrderCode); return(Json(com)); } catch (Exception ex) { com.Msg = ex.ToString(); com.success = false; return(Json(com)); } }
/// <summary> /// 填写快递单号 /// </summary> /// <param name="purch_id"></param> /// <param name="express_id"></param> /// <param name="express_code"></param> /// <param name="express_name"></param> /// <param name="OrderCode"></param> /// <returns></returns> public GoodsReceivedResult AddCode(Int64?purch_id, Int64?express_id, string express_code, string express_name, string OrderCode) { bool rstNum = false; bool rstNums = false; GoodsReceivedResult result = new GoodsReceivedResult(); using (var db = SugarDao.GetInstance(LoginUser.GetConstr())) { db.BeginTran(); var list = db.Queryable <busi_purchase>().Where(s => s.del_flag).InSingle(purch_id.Value); if (list == null) { db.RollbackTran(); result.success = false; result.Msg = "无效的采购信息,操作失败!"; return(result); } rstNum = db.Update <busi_purchase>(new { purch_status = 3, express_id = express_id, express_code = express_code, express_name = express_name, OrderCode = OrderCode }, a => a.purch_id == purch_id && a.purch_status == 2); if (rstNum) { rstNums = db.Update <busi_purchasedetail>(new { purch_status = 3 }, a => a.purch_id == purch_id && a.purch_status == 2); } if (rstNum && rstNums) { db.CommitTran(); result.success = true; result.Msg = "操作成功"; return(result); } else { db.RollbackTran(); result.success = false; result.Msg = "操作失败"; return(result); } } }