コード例 #1
0
 /// <summary>
 /// 使用快递单号
 /// </summary>
 /// <param name="expressid"></param>
 /// <param name="csvtable"></param>
 /// <returns></returns>
 public int UseExpressCode(int expressid, System.Data.DataTable csvtable)
 {
     using (var db = SugarDao.GetInstance(LoginUser.GetConstr()))
     {
         int mycount = 0;
         db.CommandTimeOut = 3000;//设置超时时间
         try
         {
             db.BeginTran();//开启事务
             //string sql = string.Format(@"", expressid);
             foreach (DataRow item in csvtable.Rows)
             {
                 base_expresscode Eid      = db.SqlQuery <base_expresscode>("select top 1 * from base_expresscode where isuse=0 and express_id=@expressid order by Eid", new { expressid = expressid }).FirstOrDefault();
                 string           mypackge = item["包裹号"].ToString();
                 db.Update <base_expresscode>(new { isuse = true, Usetime = DateTime.Now, packgecode = mypackge }, it => it.Eid == Eid.Eid);
                 bool isok = db.Update <busi_sendorder>(new { exp_code = Eid.Expresscode }, it => it.order_code == mypackge);//如果包裹号不存在系统中也没事
                 if (isok)
                 {
                     mycount++;
                 }
             }
             db.CommitTran();//提交事务
             return(mycount);
         }
         catch (Exception ex)
         {
             db.RollbackTran();//回滚事务
             throw ex;
         }
     }
 }
コード例 #2
0
 /// <summary>
 /// 生成单号区间
 /// </summary>
 /// <param name="express"></param>
 /// <param name="scode"></param>
 /// <param name="lcode"></param>
 /// <returns></returns>
 public ActionResult CreateExpressCode(int express, string scode, string lcode, int pageindex, int insys)
 {
     DBModel.Common.ComResult res = new DBModel.Common.ComResult();
     try
     {
         string[] nexpcode = null;
         myexpresscode = AUTOgetcode(scode, lcode);
         if (insys == 1)
         {
             List <base_expresscode> listexp = new List <base_expresscode> ();
             foreach (var item in myexpresscode)
             {
                 base_expresscode aa = new base_expresscode();
                 aa.express_id  = express;
                 aa.Expresscode = item;
                 aa.importtime  = DateTime.Now;
                 aa.isuse       = false;
                 aa.packgecode  = "";
                 aa.Usetime     = null;
                 listexp.Add(aa);
             }
             bool isok = _service.Import(listexp);
             if (isok)
             {
                 res.State = 2;
                 res.Msg   = "单号进入系统成功";
                 return(Json(res));
             }
             else
             {
                 res.State = 0;
                 res.Msg   = "单号进入系统失败";
                 return(Json(res));
             }
         }
         else
         {
             nexpcode       = myexpresscode.Skip(20 * (pageindex - 1)).Take(20).ToArray();
             res.DataResult = nexpcode;
             res.State      = 1;
             res.URL        = myexpresscode.Count.ToString();
             int pages = myexpresscode.Count / 20;
             if (myexpresscode.Count % 20 > 0)
             {
                 pages++;
             }
             res.Msg = pages.ToString();
             return(Json(res));
         }
     }
     catch (Exception ex)
     {
         res.State = 0;
         res.Msg   = ex.ToString();
         return(Json(res));
     }
 }