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