/// <summary>
        /// 获得前几行数据
        /// </summary>
        public static List <OrderInfoModel> GetPage(int pageIndex, int pageSize, string Column, string strWhere)
        {
            T_OrderInfoDAL dal  = new T_OrderInfoDAL();
            var            list = dal.GetPage(pageIndex, pageSize, Column, strWhere);

            foreach (OrderInfoModel item in list)
            {
                item.orderStatusName = Enum.GetName(typeof(Model.Enum.OrderEnum.OrderStatus), item.orderStatus);

                //京东订单处理
                if (item.OrderTypeId == 3)
                {
                    item.OrderProjectName = "京东日百供货";
                }

                if (item.OrderTypeId == 2)
                {
                    if (item.orderStatus == 1)
                    {
                        item.orderStatusName = "已付款(待发货)";
                    }
                    item.OrderProjectName = dal.GetMaterialGoodsName(item.busId);
                    try
                    {
                        var model = dal.GetMaterialAddressInfo(item.ReceivingAddressId);

                        if (model != null)
                        {
                            item.Address       = model.Address;
                            item.ConsigneeName = model.ConsigneeName;
                            item.TelNumber     = model.TelNumber;
                            if (!string.IsNullOrEmpty(model.ExpressCode) && item.orderStatus == 1)
                            {
                                item.orderStatusName = "已付款(已发货)";
                                item.ExpressCode     = model.ExpressCode;
                                item.ExpressCompany  = model.ExpressCompany;
                            }
                        }
                    }
                    catch (Exception ex)
                    {
                        Logger.Error("订单实物地址信息出错", ex);
                    }
                }
            }

            return(list);
        }
        public string AddExpressInfo(int oid, int accId, string expressCompany, string expressCode)
        {
            ManageUserModel uM    = (ManageUserModel)Session["logUser"];
            int             uid   = uM.UserID;
            string          uName = uM.Name;


            int reVal = T_OrderInfoBLL.AddExpressInfo(oid, accId, expressCompany, expressCode, uid, uName);

            //发货完成后推送消息
            if (reVal == 1)
            {
                //获取实物商品名称
                T_OrderInfoDAL dal       = new T_OrderInfoDAL();
                string         goodsName = dal.GetMaterialGoodsName(Convert.ToInt32(dal.GetBusIdByOid(oid)));

                try
                {
                    #region Kafka Message 实物订单发货后

                    AfterExpress eModel = new AfterExpress();
                    eModel.EventId = 5;
                    eModel.AccId   = accId;

                    eModel.GoodsName   = goodsName;
                    eModel.ExpressName = expressCompany;
                    eModel.ExpressCode = expressCode;

                    string specModel = CommonLib.Helper.JsonSerializeObject(eModel);

                    KafkaMessage mSend = new KafkaMessage();
                    mSend.SendMsg(5, specModel);

                    #endregion
                }
                catch (Exception ex)
                {
                    Logger.Error("实物订单发货后推送模板消息错误", ex);
                }
            }

            return(reVal.ToString());
        }
        public static int AddExpressInfo(int oid, int accId, string expressCompany, string expressCode, int uid, string uName)
        {
            T_OrderInfoDAL dal   = new T_OrderInfoDAL();
            int            reVal = dal.UpdateExpressAddress(oid, accId, expressCompany, expressCode);

            //获取实物商品名称
            string goodsName = dal.GetMaterialGoodsName(Convert.ToInt32(dal.GetBusIdByOid(oid)));

            var    model       = T_AccountBLL.GetAccountBasic(accId);
            string companyName = string.IsNullOrEmpty(model.CompanyName) ? "用户" : "【" + model.CompanyName + "】";

            //发货完成后推送消息
            //if (reVal == 1)
            //{
            //    //string msgTitle = "发货提醒";
            //    //string msgContent = "尊敬的" + companyName + ",您购买的【" + goodsName + "】已经发货,承运物流是【" + expressCompany + "】,单号是【" + expressCode + "】,您可以登录物流公司官网查询" +
            //    //                    "订单配送状态。如果遇到任何问题,请您拨打400-600-6815联系我们。";
            //    //int sendMessage = Utility.MessageCenter.PostMessage(accId.ToString(), msgTitle, msgContent, uid, uName, null);
            //    //int sendMobileMessage = Utility.MessageCenter.PostMobileMessage(accId.ToString(), msgTitle, msgContent, uid, uName, null);
            //}

            return(reVal);
        }