Пример #1
0
        /// <summary>
        /// 设置打印插件在线状态
        /// </summary>
        /// <returns></returns>
        private int online(int on) //on=0,离线,on=1,在线
        {
            NewXmlControl xmlfile2 = new NewXmlControl(Comm.StartupPath + "//config//regedit.xml", false, "Passport");
            string        ID       = xmlfile2.ReadNodeInnerText("/Passport/ID[1]");
            int           p_id     = Convert.ToInt32(ID);

            using (var db = SugarDao.GetInstance(Getconnstring.Getmyconnstring()))
            {
                try
                {
                    //获取配置的插件信息
                    var obj = db.Queryable <base_print>().Where(s => s.del_flag == 0).Where(s => s.p_id == p_id).FirstOrDefault();
                    if (null == obj)
                    {
                        return(0); //"打印插件未在系统中注册或者被删除了!";
                    }
                    else
                    {
                        var isok = db.Update <base_print>(new { isonline = on }, s => s.p_id == p_id);
                        if (isok)
                        {
                            return(1);//"启动成功";
                        }
                        else
                        {
                            return(2);//"启动失败";
                        }
                    }
                }
                catch (Exception ex)
                {
                    throw ex;
                }
            }
        }
Пример #2
0
 /// <summary>
 /// 判断扫描的包裹号在系统中是否存在且未删除
 /// </summary>
 /// <param name="packgecode"></param>
 /// <returns></returns>
 public static int CheckPackge(string packgecode)
 {
     using (var db = SugarDao.GetInstance(Getconnstring.Getmyconnstring()))
     {
         try
         {
             busi_sendorder packge = db.Queryable <busi_sendorder>().Where(s => s.order_code == packgecode).FirstOrDefault();
             if (null == packge)
             {
                 return(1);//代表包裹不存在系统中
             }
             else
             {
                 busi_sendorder packge2 = db.Queryable <busi_sendorder>().Where(s => s.order_code == packgecode).Where(s => s.del_flag == true).FirstOrDefault();
                 if (null == packge2)
                 {
                     return(2); //代表包裹被删除
                 }
                 else
                 {
                     return(3); //包裹存在,正常
                 }
             }
         }
         catch (Exception ex)
         {
             throw ex;
         }
     }
 }
Пример #3
0
        /// <summary>
        /// 打印插件信息
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void label5_DoubleClick(object sender, EventArgs e)
        {
            NewXmlControl xmlfile2 = new NewXmlControl(Comm.StartupPath + "//config//regedit.xml", false, "Passport");
            string        ID       = xmlfile2.ReadNodeInnerText("/Passport/ID[1]");

            using (var db = SugarDao.GetInstance(Getconnstring.Getmyconnstring()))
            {
                try
                {
                    //获取配置的插件信息
                    var obj = db.Queryable <base_print>().Where(s => s.p_id == Convert.ToInt32(ID)).FirstOrDefault();
                    if (null == obj)
                    {
                        MessageBox.Show("此打印插件在系统中不存在");
                        return;
                    }
                    else
                    {
                        MessageBox.Show("打印插件名称:" + obj.p_name, "提示");
                        return;
                    }
                }
                catch (Exception ex)
                {
                    throw ex;
                }
            }
        }
Пример #4
0
        public static List <PackgePrintInfo> GetPckgePrintInfo(string packgecode)
        {
            using (var db = SugarDao.GetInstance(Getconnstring.Getmyconnstring()))
            {
                try
                {
                    List <PackgePrintInfo> packinfo = db.Queryable <busi_sendorder_detail>().JoinTable <busi_sendorder>((s1, s2) => s1.order_id == s2.order_id)
                                                      .JoinTable <base_prod_code>((s1, s3) => s1.code_id == s3.code_id)
                                                      .Where <busi_sendorder>((s1, s2) => s2.order_code == packgecode)
                                                      .Select <busi_sendorder, base_prod_code, PackgePrintInfo>((s1, s2, s3) =>
                                                                                                                new PackgePrintInfo()
                    {
                        expressid = s2.express_id,
                        ExpCode   = s2.exp_code,
                        zipcode   = s2.receive_zip,
                        mobile    = s2.receive_mobile,
                        phone     = s2.receive_phone,
                        address   = s2.receive_address,
                        name      = s2.receive_name,
                        count     = s2.prod_num,
                        skucode   = s3.sku_code,
                        skunum    = s1.prod_num.ObjToInt()
                    }).ToList();

                    return(packinfo);
                }
                catch (Exception ex)
                {
                    throw ex;
                }
            }
        }
Пример #5
0
 /// <summary>
 /// 得到打印包裹信息(面单上)
 /// </summary>
 /// <param name="packge"></param>
 /// <returns></returns>
 public static packgeInfoViewModel GetPrintpackge(busi_printwork packge)
 {
     using (var db = SugarDao.GetInstance(Getconnstring.Getmyconnstring()))
     {
         try
         {
             packgeInfoViewModel aa=db.Queryable<busi_custorder>().JoinTable<busi_sendorder>((s1, s2) => s1.order_id == s2.custorder_id)
                 .JoinTable<base_shop>((s1, s3) => s1.shop_id == s3.shop_id)
                 .JoinTable<busi_printwork>((s2, s4) => s2.order_code == s4.data_1)
                 .Where<busi_sendorder>((s1, s2) => s2.order_code == packge.data_1)
                 .Select<busi_sendorder, base_shop, busi_printwork,packgeInfoViewModel>((s1, s2, s3,s4) =>
                 new packgeInfoViewModel()
                 {
                     LastTime=s1.latest_date.ObjToString(),
                     Number=s2.prod_num.ObjToString(),
                     Packgecode=s2.order_code,
                     ShopName=s3.shop_name,
                     workID=s4.p_Workid.ObjToInt()
                 }).FirstOrDefault();
             return aa;
         }
         catch (Exception ex)
         {
             throw ex;
         }
     }
 }
Пример #6
0
 public static Myamato GetPrintyamato(busi_printwork packge)
 {
     using (var db = SugarDao.GetInstance(Getconnstring.Getmyconnstring()))
     {
         try
         {
             yamatoShopname aa = db.Queryable<busi_sendorder>().JoinTable<busi_custorder>((s1, s2) => s1.custorder_id == s2.order_id)
                 .JoinTable<busi_custorder,base_shop>((s1,s2, s3) => s2.shop_id == s3.shop_id)
                 .JoinTable<base_shop,base_platform>((s1,s3, s4) => s3.platform_id == s4.platform_id)
                 .Where<busi_sendorder>(s1=> s1.order_code == packge.data_10)
                 .Select<base_shop, base_platform, yamatoShopname>((s1,s3, s4) =>
                 new yamatoShopname()
                 {
                     shopname=s3.shop_name,
                     platfromname=s4.platform_name,
                     Shopaddress=s3.shop_address,
                     Shopphone=s3.shop_telephone,
                     Shopzip=s3.shop_zipcode,
                     Companyname = ""
                 }).FirstOrDefault();
             if(null==aa)
             {
                 throw new Exception("无法得到发货定订单信息");
             }
             Myamato pyamato = new Myamato();
             pyamato.Shopname = aa.shopname;
             pyamato.Platform = aa.platfromname;
             pyamato.Shopzip = aa.Shopzip;
             pyamato.Shopphone = aa.Shopphone;
             pyamato.Shopaddress = aa.Shopaddress;
             pyamato.Companyname = "株式会社ジャパンドレス";
             //--------------------------------------------------
             pyamato.data_1 = packge.data_1;
             pyamato.data_2 = packge.data_2;
             pyamato.data_3 = packge.data_3;
             pyamato.data_4 = packge.data_4;
             pyamato.data_5 = packge.data_5;
             pyamato.data_6 = packge.data_6;
             pyamato.data_7 = packge.data_7;
             pyamato.data_8 = packge.data_8;
             pyamato.data_9 = packge.data_9;
             pyamato.data_10 = packge.data_10;
             pyamato.create_DateTime = packge.create_DateTime;
             pyamato.create_UserID = packge.create_UserID;
             pyamato.edit_DateTime = packge.edit_DateTime;
             pyamato.p_idPoint = packge.p_idPoint;
             pyamato.p_Status = packge.p_Status;
             pyamato.p_Workid = packge.p_Workid;
             pyamato.p_WorkRemarks = packge.p_WorkRemarks;
             pyamato.p_WorkType = packge.p_WorkType;
             pyamato.Print_DateTime = packge.Print_DateTime;
             return pyamato;
         }
         catch (Exception ex)
         {
             throw ex;
         }
     }
 }
Пример #7
0
 /// <summary>
 /// 得到需要打印的数据
 /// </summary>  20:拣选单,30:包裹号,40:转运单,50:yamato,60:Umail,70:Upacket,后面再增加
 /// <param name="printID">插件id</param>
 /// <param name="Pworktype">打印哪种类型数据</param>
 /// <returns></returns>
 public static List<busi_printwork> GetprintInfo(int printID,int Pworktype)
 {
     using (var db = SugarDao.GetInstance(Getconnstring.Getmyconnstring()))
     {
         try
         {
             List<busi_printwork> list = db.SqlQuery<busi_printwork>("select top 10 * from busi_printwork where p_WorkType=@worktype and p_Status=1 and p_idPoint=@id order by p_Workid asc", new { id = printID, worktype = Pworktype }).ToList();
             return list;
         }
         catch (Exception ex)
         {
             throw ex;
         }
     }
 }
Пример #8
0
 /// <summary>
 /// 打印拣选单打印完包裹设置状态
 /// </summary>
 /// <param name="printID"></param>
 /// <param name="packgecode"></param>
 /// <returns></returns>
 public static bool FinshSelectPrint(int printID, string packgecode)
 {
     using (var db = SugarDao.GetInstance(Getconnstring.Getmyconnstring()))
     {
         try
         {
             bool isok = db.Update<busi_printwork>(new { p_Status = 0, p_idActual = printID }, it => it.data_1 == packgecode);
             return isok;
         }
         catch (Exception ex)
         {
             throw ex;
         }
     }
 }
Пример #9
0
 /// <summary>
 /// 
 /// </summary>
 /// <param name="printID"></param>
 /// <param name="Pworktype"></param>
 /// <returns></returns>
 public static List<busi_printwork> GetSelectPackgeList(int printID, int Pworktype,string packgecode)
 {
     using (var db = SugarDao.GetInstance(Getconnstring.Getmyconnstring()))
     {
         try
         {
             List<busi_printwork> list = db.Queryable<busi_printwork>().Where(s => s.p_Status == 1).Where(s => s.p_WorkType == 20).Where(s => s.p_idPoint == printID)
                                        .Where(s => s.data_1 == packgecode).ToList();
             return list;
         }
         catch (Exception ex)
         {
             throw ex;
         }
     }
 }
Пример #10
0
 public static bool FinshPrint(int printID, busi_printwork pack)
 {
     using (var db = SugarDao.GetInstance(Getconnstring.Getmyconnstring()))
     {
         try
         {
             DateTime ptime = DateTime.Now;
             pack.p_idActual = printID;
             pack.Print_DateTime = ptime;
             pack.p_Status = 0;
             bool isok = db.Update<busi_printwork>(pack);
             return isok;
         }
         catch (Exception ex)
         {
             throw ex;
         }
     }
 }
Пример #11
0
 public static bool InsertPrintMiandan(busi_printwork pwork)
 {
     using (var db = SugarDao.GetInstance(Getconnstring.Getmyconnstring()))
     {
         try
         {
             var isok = db.Insert <busi_printwork>(pwork);
             if (isok.ObjToInt() > 0)
             {
                 return(true);
             }
             else
             {
                 return(false);
             }
         }
         catch (Exception ex)
         {
             throw ex;
         }
     }
 }
Пример #12
0
 /// <summary>
 /// 插入打印数据到打印表中
 /// </summary>
 /// <param name="pwork"></param>
 /// <returns></returns>
 public static bool InsertPrintMiandan(busi_printwork pwork)
 {
     using (var db = SugarDao.GetInstance(Getconnstring.Getmyconnstring()))
     {
         try
         {
             var isok = db.Insert <busi_printwork>(pwork);
             db.Update <busi_sendorder>(new { is_print = 1, print_time = DateTime.Now }, s => s.order_code == pwork.data_10);
             if (isok.ObjToInt() > 0)
             {
                 return(true);
             }
             else
             {
                 return(false);
             }
         }
         catch (Exception ex)
         {
             throw ex;
         }
     }
 }