public object GetGoodsList(string orderStatus)
        {
            string devSort     = string.Empty;
            string searchName  = ToolHelper.UrlParDecode(Request.QueryString["searchName"], "");
            string byTimeStart = ToolHelper.UrlParDecode(Request.QueryString["byTimeStart"], "");
            string byTimeEnd   = ToolHelper.UrlParDecode(Request.QueryString["byTimeEnd"], "");
            int    pageNow     = Convert.ToInt32(ToolHelper.UrlParDecode(Request.QueryString["pageNow"], "1"));

            sltByTimeStart.Value = byTimeStart;
            sltByTimeEnd.Value   = byTimeEnd;
            iptSearch.Value      = searchName;
            int    pageSize    = 20;
            string suppliersID = WebLoginHelper.GetAdminSupplier();
            int    listCount   = 0;
            string url         = "/web/thirdAdmin/data_goodsInfo.aspx?";

            url += "byTimeStart=" + ToolHelper.UrlParEncode(byTimeStart, "") + "&";
            url += "byTimeEnd=" + ToolHelper.UrlParEncode(byTimeEnd, "") + "&";
            url += "byOrderStatus=" + ToolHelper.UrlParEncode(orderStatus, "") + "&";
            url += "searchName=" + ToolHelper.UrlParEncode(searchName, "") + "&";
            object dt = new DB.BLL.MB_Bll(DBEnum.Slave).GetByPageDataGoodsList(byTimeStart, byTimeEnd, suppliersID, orderStatus, searchName, (pageNow - 1) * pageSize, pageSize, out listCount);

            PageNavHelper pageNavHelper = new PageNavHelper(listCount, pageNow, pageSize, url + "pageNow=");

            pageNav.InnerHtml = pageNavHelper.ToHtml();
            return(dt);
        }
        private object GetUserList(string byUserType)
        {
            string searchName = ToolHelper.UrlParDecode(Request.QueryString["searchName"], "");
            int    pageNow    = Convert.ToInt32(ToolHelper.UrlParDecode(Request.QueryString["pageNow"], "1"));

            iptSearch.Value = searchName;
            int    pageSize = 50;
            int    devCount = 0;
            string url      = "/web/admin/web_user_list.aspx?";

            url += "byScreenType=" + ToolHelper.UrlParEncode(byUserType, "") + "&";
            url += "searchName=" + ToolHelper.UrlParEncode(searchName, "") + "&";
            IEnumerable <dynamic> dt            = new DB.BLL.MB_Bll(DBEnum.Slave).GetByPageUserList(byUserType, searchName, (pageNow - 1) * pageSize, pageSize, out devCount);
            PageNavHelper         pageNavHelper = new PageNavHelper(devCount, pageNow, pageSize, url + "pageNow=");

            pageNav.InnerHtml = pageNavHelper.ToHtml();
            int i = 1 * pageSize * (pageNow - 1) + 1;

            return(dt.Select(info => {
                return new
                {
                    RowNo = i++,
                    info.UserName,
                    info.NickName,
                    info.Phone,
                    info.RegTime,
                    info.LastLogin,
                    info.CpyName,
                    info.NSex
                };
            }));;
        }
示例#3
0
        public void BindDdl()
        {
            IEnumerable <dynamic> cateInfo = new DB.BLL.MB_Bll(DBEnum.Slave).GetModelList("SELECT * FROM M_Category WHERE ParentID = 0", null);

            new DdlHelper().BindDdlMore(choiceParentsID, cateInfo, "无", x => { return(new ListItem(Convert.ToString(x.CateName), Convert.ToString(x.CateID))); });
            new DdlHelper().BindDdlMore(updateChoiceParentsID, cateInfo, "无", x => { return(new ListItem(Convert.ToString(x.CateName), Convert.ToString(x.CateID))); });
        }
示例#4
0
        public void BindDdl()
        {
            string strWhere = " SELECT * FROM M_Category WHERE 1=1 AND IsDelete=0 ORDER BY ParentID ASC , OrderBy ASC ";
            IEnumerable <dynamic> CateInfo = new DB.BLL.MB_Bll(DBEnum.Slave).GetModelList(strWhere, null);

            new DdlHelper().BindDdlMore(sltByCateType, CateInfo, "全部", x => { return(new ListItem(Convert.ToString(x.CateName), Convert.ToString(x.CateID))); });
            IEnumerable <dynamic> FareInfo = new DB.BLL.MB_Bll(DBEnum.Slave).GetModelList(" SELECT FareName,FareSysID FROM M_FareTemplate WHERE 1=1  ", null);

            new DdlHelper().BindDdlMore(addFareTemp, FareInfo, "请选择", x => { return(new ListItem(Convert.ToString(x.FareName), Convert.ToString(x.FareSysID))); });
            IEnumerable <dynamic> SuppliersInfo = new DB.BLL.MB_Bll(DBEnum.Slave).GetModelList("SELECT * FROM M_Suppliers WHERE 1=1", null);

            new DdlHelper().BindDdlMore(addSuppliers, SuppliersInfo, "请选择", x => { return(new ListItem(Convert.ToString(x.SuppliersName), Convert.ToString(x.SuppliersID))); });
            hiddenSupplier.InnerHtml = WebLoginHelper.GetAdminSupplier();
            if (!string.IsNullOrEmpty(Request.QueryString["byCateType"]))
            {
                sltByCateType.SelectedIndex = sltByCateType.Items.IndexOf(sltByCateType.Items.FindByValue(ToolHelper.UrlParDecode(Request.QueryString["byCateType"], "")));
            }
            if (!string.IsNullOrEmpty(Request.QueryString["byIsEnable"]))
            {
                sltByIsEnable.SelectedIndex = sltByIsEnable.Items.IndexOf(sltByIsEnable.Items.FindByValue(ToolHelper.UrlParDecode(Request.QueryString["byIsEnable"], "")));
            }
            if (!string.IsNullOrEmpty(Request.QueryString["byOrderBy"]))
            {
                sltOrderBy.SelectedIndex = sltOrderBy.Items.IndexOf(sltOrderBy.Items.FindByValue(ToolHelper.UrlParDecode(Request.QueryString["byOrderBy"], "")));
            }
        }
示例#5
0
        public void BindDdl()
        {
            IEnumerable <dynamic> paymentInfo = new DB.BLL.MB_Bll(DBEnum.Slave).GetModelList("SELECT * FROM M_Payment WHERE 1=1 AND IsEnabled =1 ORDER BY PayOrder DESC", null);

            new DdlHelper().BindDdlMore(sltByPayID, paymentInfo, "全部", x => { return(new ListItem(Convert.ToString(x.PayName), Convert.ToString(x.PayID))); });
            IEnumerable <dynamic> SuppliersInfo = new DB.BLL.MB_Bll(DBEnum.Slave).GetModelList(" SELECT * FROM M_Suppliers WHERE 1=1 AND IsCheck =1  ORDER BY SuppliersID ASC ", null);

            new DdlHelper().BindDdlMore(sltBySuppliers, SuppliersInfo, "全部", x => { return(new ListItem(Convert.ToString(x.SuppliersName), Convert.ToString(x.SuppliersID))); });
            if (!string.IsNullOrEmpty(Request.QueryString["byOrderStatus"]))
            {
                sltByOrderStatus.SelectedIndex = sltByOrderStatus.Items.IndexOf(sltByOrderStatus.Items.FindByValue(ToolHelper.UrlParDecode(Request.QueryString["byOrderStatus"], "")));
            }
            if (!string.IsNullOrEmpty(Request.QueryString["byPayID"]))
            {
                sltByPayID.SelectedIndex = sltByPayID.Items.IndexOf(sltByPayID.Items.FindByValue(ToolHelper.UrlParDecode(Request.QueryString["byPayID"], "")));
            }
            if (!string.IsNullOrEmpty(Request.QueryString["bySuppliers"]))
            {
                sltBySuppliers.SelectedIndex = sltBySuppliers.Items.IndexOf(sltBySuppliers.Items.FindByValue(ToolHelper.UrlParDecode(Request.QueryString["bySuppliers"], "")));
            }
            if (!string.IsNullOrEmpty(Request.QueryString["byOrderBy"]))
            {
                sltOrderBy.SelectedIndex = sltOrderBy.Items.IndexOf(sltOrderBy.Items.FindByValue(ToolHelper.UrlParDecode(Request.QueryString["byOrderBy"], "")));
            }
        }
        public object GetGoodsList(string comfirmStatus, string byPayID)
        {
            string searchName  = ToolHelper.UrlParDecode(Request.QueryString["searchName"], "");
            string byTimeStart = ToolHelper.UrlParDecode(Request.QueryString["byTimeStart"], "");
            string byTimeEnd   = ToolHelper.UrlParDecode(Request.QueryString["byTimeEnd"], "");
            int    pageNow     = Convert.ToInt32(ToolHelper.UrlParDecode(Request.QueryString["pageNow"], "1"));

            iptSearch.Value      = searchName;
            sltByTimeStart.Value = byTimeStart;
            sltByTimeEnd.Value   = byTimeEnd;
            int     pageSize    = 20;
            decimal moneyAmount = 0;
            int     listCount   = new DB.BLL.MB_Bll(DBEnum.Slave).GetByPageUnusualRebackTradeListCount(byTimeStart, byTimeEnd, comfirmStatus, byPayID, searchName);
            string  url         = "/web/order/reback_trade.aspx?";

            url += "byTimeStart=" + ToolHelper.UrlParEncode(byTimeStart, "") + "&";
            url += "byTimeEnd=" + ToolHelper.UrlParEncode(byTimeEnd, "") + "&";
            url += "byComfirmStatus=" + ToolHelper.UrlParEncode(comfirmStatus, "") + "&";
            url += "byPayID=" + ToolHelper.UrlParEncode(byPayID, "") + "&";
            url += "searchName=" + ToolHelper.UrlParEncode(searchName, "") + "&";
            object        dt            = new DB.BLL.MB_Bll(DBEnum.Slave).GetByPageUnusualRebackTradeList(byTimeStart, byTimeEnd, comfirmStatus, byPayID, searchName, (pageNow - 1) * pageSize, pageSize, out moneyAmount);
            PageNavHelper pageNavHelper = new PageNavHelper(listCount, pageNow, pageSize, url + "pageNow=");

            pageNav.InnerHtml      = pageNavHelper.ToHtml();
            moneyAccount.InnerHtml = Convert.ToString(moneyAmount);
            return(dt);
        }
示例#7
0
        public void BindDdl()
        {
            string strWhere = " SELECT * FROM M_Category WHERE 1=1 AND IsDelete=0 ORDER BY ParentID ASC , OrderBy ASC ";
            IEnumerable <dynamic> CateInfo = new DB.BLL.MB_Bll(DBEnum.Slave).GetModelList(strWhere, null);

            new DdlHelper().BindDdlMore(sltByCateType, CateInfo, "全部", x => { return(new ListItem(Convert.ToString(x.CateName), Convert.ToString(x.CateID))); });
            IEnumerable <dynamic> SuppliersInfo = new DB.BLL.MB_Bll(DBEnum.Slave).GetModelList("SELECT * FROM M_Suppliers WHERE 1=1", null);

            new DdlHelper().BindDdlMore(sltBySuppliers, SuppliersInfo, "全部", x => { return(new ListItem(Convert.ToString(x.SuppliersName), Convert.ToString(x.SuppliersID))); });
            new DdlHelper().BindDdlMore(addSuppliers, SuppliersInfo, "请选择", x => { return(new ListItem(Convert.ToString(x.SuppliersName), Convert.ToString(x.SuppliersID))); });
            IEnumerable <dynamic> FareInfo = new DB.BLL.MB_Bll(DBEnum.Slave).GetModelList(" SELECT FareName,FareSysID FROM M_FareTemplate WHERE 1=1  ", null);

            new DdlHelper().BindDdlMore(addFareTemp, FareInfo, "请选择", x => { return(new ListItem(Convert.ToString(x.FareName), Convert.ToString(x.FareSysID))); });
            if (!string.IsNullOrEmpty(Request.QueryString["byCateType"]))
            {
                sltByCateType.SelectedIndex = sltByCateType.Items.IndexOf(sltByCateType.Items.FindByValue(ToolHelper.UrlParDecode(Request.QueryString["byCateType"], "")));
            }
            if (!string.IsNullOrEmpty(Request.QueryString["bySuppliers"]))
            {
                sltBySuppliers.SelectedIndex = sltBySuppliers.Items.IndexOf(sltBySuppliers.Items.FindByValue(ToolHelper.UrlParDecode(Request.QueryString["bySuppliers"], "")));
            }
            if (!string.IsNullOrEmpty(Request.QueryString["byIsEnable"]))
            {
                sltByIsEnable.SelectedIndex = sltByIsEnable.Items.IndexOf(sltByIsEnable.Items.FindByValue(ToolHelper.UrlParDecode(Request.QueryString["byIsEnable"], "")));
            }
            if (!string.IsNullOrEmpty(Request.QueryString["byOrderBy"]))
            {
                sltOrderBy.SelectedIndex = sltOrderBy.Items.IndexOf(sltOrderBy.Items.FindByValue(ToolHelper.UrlParDecode(Request.QueryString["byOrderBy"], "")));
            }
            if (File.Exists(Server.MapPath("/files/excel/上传错误信息表.xls")))
            {
                downLoad.Attributes["href"] = "/files/excel/上传错误信息表.xls";
                downLoad.Style.Remove("display");
            }
        }
        public object GetGoodsList(string byOrderStatus, string sltOrderBy, string byReBackType)
        {
            string devSort     = string.Empty;
            string searchName  = ToolHelper.UrlParDecode(Request.QueryString["searchName"], "");
            string byTimeStart = ToolHelper.UrlParDecode(Request.QueryString["byTimeStart"], "");
            string byTimeEnd   = ToolHelper.UrlParDecode(Request.QueryString["byTimeEnd"], "");
            int    pageNow     = Convert.ToInt32(ToolHelper.UrlParDecode(Request.QueryString["pageNow"], "1"));

            if (sltOrderBy == "0")
            {
                devSort = " ORDER BY O.ShippingTime DESC ";
            }
            if (sltOrderBy == "1")
            {
                devSort = " ORDER BY R.CreatTime DESC ";
            }
            iptSearch.Value      = searchName;
            sltByTimeStart.Value = byTimeStart;
            sltByTimeEnd.Value   = byTimeEnd;
            int    pageSize    = 20;
            string suppliersID = WebLoginHelper.GetAdminSupplier();
            int    listCount   = new DB.BLL.MB_Bll(DBEnum.Slave).GetByPageReBackThirdOrderListCount(byTimeStart, byTimeEnd, suppliersID, byOrderStatus, byReBackType, searchName);
            string url         = "/web/thirdAdmin/reback_order.aspx?";

            url += "byTimeStart=" + ToolHelper.UrlParEncode(byTimeStart, "") + "&";
            url += "byTimeEnd=" + ToolHelper.UrlParEncode(byTimeEnd, "") + "&";
            url += "byReBackType=" + ToolHelper.UrlParEncode(byReBackType, "") + "&";
            url += "byOrderBy=" + ToolHelper.UrlParEncode(sltOrderBy, "") + "&";
            url += "searchName=" + ToolHelper.UrlParEncode(searchName, "") + "&";
            object        dt            = new DB.BLL.MB_Bll(DBEnum.Slave).GetByPageReBackThirdOrderList(byTimeStart, byTimeEnd, suppliersID, byOrderStatus, byReBackType, searchName, devSort, (pageNow - 1) * pageSize, pageSize);
            PageNavHelper pageNavHelper = new PageNavHelper(listCount, pageNow, pageSize, url + "pageNow=");

            pageNav.InnerHtml = pageNavHelper.ToHtml();
            return(dt);
        }
        private void BindDdl()
        {
            if (!string.IsNullOrEmpty(Request.QueryString["byUserType"]))
            {
                sltByUserType.SelectedIndex = sltByUserType.Items.IndexOf(sltByUserType.Items.FindByValue(ToolHelper.UrlParDecode(Request.QueryString["byUserType"], "")));
            }
            int count = new DB.BLL.MB_Bll(DBEnum.Slave).GetModelListCount <DB.Model.M_Users>("  RegTime>@_RegTime ", new { _RegTime = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd")) });

            register_count.InnerHtml = Convert.ToString(count);
        }
        public object GetBrandList()
        {
            int           pageNow       = Convert.ToInt32(ToolHelper.UrlParDecode(Request.QueryString["pageNow"], "1"));
            int           pageSize      = 5;
            int           listCount     = new DB.BLL.MB_Bll(DBEnum.Slave).GetModelListCount(" SELECT COUNT(*) FROM M_FareTemplate ", null);
            string        url           = "/web/database/fareDeliery_list.aspx?";
            object        dt            = new DB.BLL.MB_Bll(DBEnum.Slave).GetModelList(" SELECT * FROM M_FareTemplate WHERE 1=1 LIMIT @StartSize,@EndSize", new { StartSize = (pageNow - 1) * pageSize, EndSize = pageSize }).Select(info => { return(new { info.FareName, info.FareSysID, info.UpdateTime }); });
            PageNavHelper pageNavHelper = new PageNavHelper(listCount, pageNow, pageSize, url + "pageNow=");

            pageNav.InnerHtml = pageNavHelper.ToHtml();
            return(dt);
        }
示例#11
0
        public object GetBrandList()
        {
            int           pageNow       = Convert.ToInt32(ToolHelper.UrlParDecode(Request.QueryString["pageNow"], "1"));
            int           pageSize      = 15;
            int           listCount     = new DB.BLL.MB_Bll(DBEnum.Slave).GetByPageAdminListCount(string.Empty);
            string        url           = "/web/admin/web_admin_list.aspx?";
            object        dt            = new DB.BLL.MB_Bll(DBEnum.Slave).GetByPageAdminList((pageNow - 1) * pageSize, pageSize);
            PageNavHelper pageNavHelper = new PageNavHelper(listCount, pageNow, pageSize, url + "pageNow=");

            pageNav.InnerHtml = pageNavHelper.ToHtml();
            return(dt);
        }
示例#12
0
        public object GetBrandList()
        {
            string searchName = ToolHelper.UrlParDecode(Request.QueryString["searchName"], "");

            iptSearch.Value = searchName;
            string url = "/web/database/supplier_list.aspx?";

            url += "searchName=" + ToolHelper.UrlParEncode(searchName, "") + "&";
            object dt = new DB.BLL.MB_Bll(DBEnum.Slave).GetModelList <DB.Model.M_Suppliers>(" 1=1 ", null);

            return(dt);
        }
示例#13
0
        public object GetList()
        {
            int           pageNow       = Convert.ToInt32(ToolHelper.UrlParDecode(Request.QueryString["pageNow"], "1"));
            int           pageSize      = 20;
            int           devCount      = new DB.BLL.MB_Bll(DBEnum.Slave).GetModelListCount <DB.Model.M_ErrorLog>(" 1=1 ", null);
            string        url           = "/web/database/log_error.aspx?";
            object        dt            = new DB.BLL.MB_Bll(DBEnum.Slave).GetModelList <DB.Model.M_ErrorLog>(" 1=1 ORDER BY ErrLogTime DESC LIMIT @StartSize,@EndSize ", new { StartSize = (pageNow - 1) * pageSize, EndSize = pageSize });
            PageNavHelper pageNavHelper = new PageNavHelper(devCount, pageNow, pageSize, url + "pageNow=");

            pageNav.InnerHtml = pageNavHelper.ToHtml();
            return(dt);
        }
示例#14
0
        public object GetList()
        {
            int           pageNow       = Convert.ToInt32(ToolHelper.UrlParDecode(Request.QueryString["pageNow"], "1"));
            int           pageSize      = 10;
            int           devCount      = new DB.BLL.MB_Bll(DBEnum.Slave).GetByPageRollListCount();
            string        url           = "/web/database/roll.aspx?";
            object        dt            = new DB.BLL.MB_Bll(DBEnum.Slave).GetByPageRollList((pageNow - 1) * pageSize, pageSize);
            PageNavHelper pageNavHelper = new PageNavHelper(devCount, pageNow, pageSize, url + "pageNow=");

            pageNav.InnerHtml = pageNavHelper.ToHtml();
            return(dt);
        }
示例#15
0
        public object GetBrandList()
        {
            int           pageNow       = Convert.ToInt32(ToolHelper.UrlParDecode(Request.QueryString["pageNow"], "1"));
            int           pageSize      = 18;
            string        url           = "/web/database/imges.aspx?";
            int           listCount     = new DB.BLL.MB_Bll(DBEnum.Slave).GetModelListCount <DB.Model.M_FileManage>("1=1 AND FileName NOT LIKE '%Themb%'", null);
            object        dt            = new DB.BLL.MB_Bll(DBEnum.Slave).GetModelList <DB.Model.M_FileManage>(" 1=1 AND FileName NOT LIKE '%Themb%' ORDER BY CreatTime ASC LIMIT @PageNow ,@PageSize ", new { PageNow = (pageNow - 1) * pageSize, pageSize = pageSize });//.Select(info => new { FilePath = "http://mallmanage.51ipc.com/" + info.FilePath, info.FileName,info.FileSysID });
            PageNavHelper pageNavHelper = new PageNavHelper(listCount, pageNow, pageSize, url + "pageNow=");

            pageNav.InnerHtml = pageNavHelper.ToHtml();
            return(dt);
        }
示例#16
0
        /// <summary>
        /// 获取用户模块权限==写入session中的是(模块,与相应的模块页面)
        /// </summary>
        /// <returns></returns>
        public static List <DB.Model.M_Modal> GetModalAuth()
        {
            List <DB.Model.M_Modal> dicModalAuth = (List <DB.Model.M_Modal>)HttpContext.Current.Session[SESSION_AUTH]; //判断权限模块对应表是否在session中已经存在

            if (dicModalAuth == null || dicModalAuth.Count <= 0)                                                       //如果不存在,从数据库获取相关信息存入session中,同时返回这个字典内容
            {
                DB.Model.M_AdminUser adminModel = (DB.Model.M_AdminUser)HttpContext.Current.Session[SESSION_ADMIN];    //获取存在session中的用户信息,检索时会用到当前登录用户的用户SysID
                if (adminModel != null)                                                                                //不为空,即已经登录
                {
                    dicModalAuth = new DB.BLL.MB_Bll(DBEnum.Slave).GetModalList(adminModel.AdminID);                   //获取用户模块权限表的数据
                    HttpContext.Current.Session[SESSION_AUTH] = dicModalAuth;                                          //对这个session进行赋值
                }
            }
            return(dicModalAuth);//同时返回这个datatable类型变量
        }
示例#17
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (WebLoginHelper.IsAuthority(AdminAuth.AdminManage))
     {
         if (!IsPostBack)
         {
             BindGrid();
             IEnumerable <dynamic> SuppliersInfo = new DB.BLL.MB_Bll(DBEnum.Slave).GetModelList("SELECT * FROM M_Suppliers WHERE 1=1", null);
             new DdlHelper().BindDdlMore(addSuppliers, SuppliersInfo, "请选择", x => { return(new ListItem(Convert.ToString(x.SuppliersName), Convert.ToString(x.SuppliersID))); });
         }
     }
     else
     {
         Response.Redirect("/web/web_login.aspx", false);
     }
 }
示例#18
0
        public object GetSizeList()
        {
            string bySysID      = ToolHelper.UrlParDecode(Request.QueryString["bySysID"], "");
            string searchName   = string.Empty;
            int    pageNow      = Convert.ToInt32(ToolHelper.UrlParDecode(Request.QueryString["pageNow"], "1"));
            int    pageSize     = 20;
            int    productCount = new DB.BLL.MB_Bll(DBEnum.Slave).GetByPageCagegoryListCount(bySysID);
            string url          = "/web/database/category.aspx?";

            url += "bySysID=" + ToolHelper.UrlParEncode(bySysID, "") + "&";
            object        dt            = new DB.BLL.MB_Bll(DBEnum.Slave).GetByPageCagegoryList(bySysID, (pageNow - 1) * pageSize, pageSize);
            PageNavHelper pageNavHelper = new PageNavHelper(productCount, pageNow, pageSize, url + "pageNow=");

            pageNav.InnerHtml = pageNavHelper.ToHtml();
            return(dt);
        }
示例#19
0
        public object GetBrandList()
        {
            string searchName = ToolHelper.UrlParDecode(Request.QueryString["searchName"], "");
            int    pageNow    = Convert.ToInt32(ToolHelper.UrlParDecode(Request.QueryString["pageNow"], "1"));

            iptSearch.Value = searchName;
            int    pageSize  = 10;
            int    listCount = new DB.BLL.MB_Bll(DBEnum.Slave).GetByPageBrandListCount(searchName);
            string url       = "/web/database/brand.aspx?";

            url += "searchName=" + ToolHelper.UrlParEncode(searchName, "") + "&";
            object        dt            = new DB.BLL.MB_Bll(DBEnum.Slave).GetByPageBrandList(searchName, (pageNow - 1) * pageSize, pageSize);
            PageNavHelper pageNavHelper = new PageNavHelper(listCount, pageNow, pageSize, url + "pageNow=");

            pageNav.InnerHtml = pageNavHelper.ToHtml();
            return(dt);
        }
示例#20
0
        /// <summary>
        /// 获取当前账户需要处理的售后换货订单数量
        /// </summary>
        /// <param name="hrefUrl"></param>
        /// <returns></returns>
        private int GetReBackOrderToChangeGoods(out string hrefUrl)
        {
            int resMsg = 0;

            hrefUrl = "javascript:;";
            string suppliersID = WebLoginHelper.GetAdminSupplier();

            if (!string.IsNullOrEmpty(suppliersID))
            {
                if (WebLoginHelper.IsAuthority(AdminAuth.SuppliersManage))
                {
                    hrefUrl = "/web/thirdAdmin/data_backorder.aspx?";
                    resMsg  = new DB.BLL.MB_Bll(DBEnum.Slave).GetModelListCount <DB.Model.M_ReBackOrder>(" SuppliersID=@_SuppliersID AND ReBackType=20 AND AuthType=30 ", new { _SuppliersID = suppliersID });
                }
            }
            return(resMsg);
        }
示例#21
0
        public void BindDdl()
        {
            string strWhere = " SELECT * FROM M_Category WHERE 1=1 AND IsDelete=0 ORDER BY ParentID ASC , OrderBy ASC ";
            IEnumerable <dynamic> CateInfo = new DB.BLL.MB_Bll(DBEnum.Slave).GetModelList(strWhere, null);

            new DdlHelper().BindDdlMore(sltByCateName, CateInfo, "全部", x => { return(new ListItem(Convert.ToString(x.CateName), Convert.ToString(x.CateID))); });
            IEnumerable <dynamic> SuppliersInfo = new DB.BLL.MB_Bll(DBEnum.Slave).GetModelList("SELECT * FROM M_Suppliers WHERE 1=1", null);

            new DdlHelper().BindDdlMore(sltBySuppliers, SuppliersInfo, "全部", x => { return(new ListItem(Convert.ToString(x.SuppliersName), Convert.ToString(x.SuppliersID))); });
            IEnumerable <dynamic> FareInfo = new DB.BLL.MB_Bll(DBEnum.Slave).GetModelList(" SELECT FareName,FareSysID FROM M_FareTemplate WHERE 1=1  ", null);

            new DdlHelper().BindDdlMore(updateFareTemp, FareInfo, "请选择", x => { return(new ListItem(Convert.ToString(x.FareName), Convert.ToString(x.FareSysID))); });
            string goodsSysID = ToolHelper.UrlParDecode(Request.QueryString["byGoodsSysID"], "");

            if (!string.IsNullOrEmpty(goodsSysID))
            {
                DB.Model.M_Goods dtGoodsInfo = new DB.BLL.MB_Bll(DBEnum.Slave).GetModel <DB.Model.M_Goods>(" GoodsID=@_GoodsID ", new { _GoodsID = goodsSysID });
                if (dtGoodsInfo != null)
                {
                    thisGoodsName.InnerHtml = dtGoodsInfo.GoodsName + "--" + dtGoodsInfo.GoodsSn;
                    myContent.InnerHtml     = dtGoodsInfo.GoodsDesc;
                    saveInfo.Attributes.Add("mydata", goodsSysID);
                    myGoodsName.Value      = dtGoodsInfo.GoodsName;
                    sltByCateName.Value    = Convert.ToString(dtGoodsInfo.CateID);
                    sltBySuppliers.Value   = Convert.ToString(dtGoodsInfo.SuppliersID);
                    shopPrice.Value        = Convert.ToString(dtGoodsInfo.ShopPrice);
                    marketPrice.Value      = Convert.ToString(dtGoodsInfo.MarketPrice);
                    myGoodsBrief.InnerText = Convert.ToString(dtGoodsInfo.GoodsBrief);
                    myRemark.InnerText     = Convert.ToString(dtGoodsInfo.SellerNote);
                    myKeyWords.Value       = dtGoodsInfo.KeyWords;
                    updateFareTemp.Value   = dtGoodsInfo.FareSysID;
                    updateBrand.Attributes.Add("mydata", Convert.ToString(dtGoodsInfo.BrandID));
                }
            }
            HttpCookie c*k = Request.Cookies["editorUrl"];

            if (c*k != null)
            {
                thisUrl.Attributes["href"] = HttpUtility.UrlDecode(c*k.Value);
            }
            if (string.IsNullOrEmpty(goodsSysID))
            {
                Response.Redirect("/web/goods/goods_list.aspx?", false);
            }
        }
示例#22
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (WebLoginHelper.IsAuthority(AdminAuth.BackgroundManage))
     {
         if (!IsPostBack)
         {
             StringBuilder strList  = new StringBuilder();
             string        strWhere = "  ParentID = 0 AND IsDelete = 0 ORDER BY OrderBy ASC ";
             List <DB.Model.M_Category> categoryInfo = new DB.BLL.MB_Bll(DBEnum.Slave).GetModelList <DB.Model.M_Category>(strWhere, null);
             for (int i = 0; i < categoryInfo.Count; i++)
             {
                 if (i < 10)
                 {
                     strList.Append(" <li id=\"" + categoryInfo[i].CateName + "\" ><a href=\"/web/database/category.aspx?bySysID=" + categoryInfo[i].CateID + "\" onclick=\"FocusThis(this)\" >" + categoryInfo[i].CateName + "</a></li> ");
                 }
                 else
                 {
                     if (i == 10)
                     {
                         strList.Append(" <li class=\"dropdown\"><a href=\"\" class=\"dropdown-toggle\" data-toggle=\"dropdown\">更多<span class=\"caret\"></span></a><ul class=\"dropdown-menu\" role=\"menu\"> ");
                         strList.Append(" <li id=\"" + categoryInfo[i].CateName + "\"><a href=\"/web/database/category.aspx?bySysID=" + categoryInfo[i].CateID + "\" onclick=\"FocusThis(this)\" >" + categoryInfo[i].CateName + "</a></li> ");
                     }
                     else
                     {
                         strList.Append(" <li id=\"" + categoryInfo[i].CateName + "\" ><a href=\"/web/database/category.aspx?bySysID=" + categoryInfo[i].CateID + "\" onclick=\"FocusThis(this)\" >" + categoryInfo[i].CateName + "</a></li> ");
                     }
                 }
             }
             if (categoryInfo.Count >= 10)
             {
                 strList.Append("  </ul> </ li > ");
             }
             sltFirstType.InnerHtml = strList.ToString();
             BindGrid();
             BindDdl();
         }
     }
     else
     {
         Response.Redirect("/web/web_login.aspx", false);
     }
 }
示例#23
0
        /// <summary>
        ///  获取联想集合,传入的值内容是DataTable类型的
        /// </summary>
        /// <param name="sessionEnum">临时session的名字</param>
        /// <param name="dt">传入的DataTable数据集名</param>
        /// <param name="id">字典的key</param>
        /// <param name="name">字典的value</param>
        /// <param name="queryName">标签获取的字符串</param>
        /// <param name="excludeID">要排除在外的内容</param>
        /// <returns></returns>
        public Dictionary <string, string> GetUlListByIEnumerable(SessionEnum sessionEnum, string strSql, string queryName, string excludeID, Action <IEnumerable <dynamic>, Dictionary <string, string> > iEnumerable)
        {
            Dictionary <string, string> dicFrom = new Dictionary <string, string>();                //定义两个字典类型的变量
            Dictionary <string, string> dicTo   = new Dictionary <string, string>();
            object sessionTempName = HttpContext.Current.Session[WebLoginHelper.SESSION_TEMP_NAME]; //尝试获取某个session的值(这个session存储的是上个session使用过的临时名)

            if (sessionTempName == null || (SessionEnum)sessionTempName != sessionEnum)             //如果这个session的值为空(即获取不到这个session值,或者这个session的临时名字不叫我们现在传入的这个session的枚举值sessionEnum)
            {
                IEnumerable <dynamic>       info = new DB.BLL.MB_Bll(DBEnum.Slave).GetModelList(strSql, null);
                Dictionary <string, string> dic  = new Dictionary <string, string>();
                dicFrom = ToolHelper.IEnumerableListToDic(info, iEnumerable);                //ToolHelper.DataTableToDic(dt, id, name);//将dataTable转化成字典类型
                HttpContext.Current.Session[WebLoginHelper.SESSION_TEMP_DATA] = dicFrom;     //将转化后的字典内容赋值给这个临时session值内容
                HttpContext.Current.Session[WebLoginHelper.SESSION_TEMP_NAME] = sessionEnum; //将这个临时文session的临时名命名为我们传入的session枚举名
            }
            else
            {
                dicFrom = (Dictionary <string, string>)HttpContext.Current.Session[WebLoginHelper.SESSION_TEMP_DATA]; //否则直接从session中读取字典内容
            }
            if (dicFrom.Count > 0)                                                                                    //如果字典内容不为空
            {
                try
                {
                    //我们要在目标字符串中找到我们传入的从标签获取到的值,看是否存在,而目标字符串就是使用代码 Match match = regex.Match(dic.Value);//这个就是确认我们要进行匹配的目标字符串(dic.Value),通过这句代码实现。
                    Regex regex = new Regex(queryName);     //调用系统本身的正则表达式类(类似于文件操作类,路径操作类)
                    Match match = null;
                    foreach (var dic in dicFrom)            //dic代表的是字典的每一行的key与value的集合
                    {
                        if (dic.Key != excludeID)           //判断如果字典的key值不等于要排除在外的内容
                        {
                            match = regex.Match(dic.Value); //调用系统的
                            if (match.Success)
                            {
                                dicTo.Add(dic.Key, dic.Value);
                            }
                        }
                    }
                }
                catch { dicTo.Add("ERR", "请不要输入非法字符"); }
            }
            return(dicTo);
        }
示例#24
0
        public object GetGoodsList(string orderStatus, string suppliersID, string payID, string sltOrderBy)
        {
            string devSort     = string.Empty;
            string searchName  = ToolHelper.UrlParDecode(Request.QueryString["searchName"], "");
            string byTimeStart = ToolHelper.UrlParDecode(Request.QueryString["byTimeStart"], "");
            string byTimeEnd   = ToolHelper.UrlParDecode(Request.QueryString["byTimeEnd"], "");
            int    pageNow     = Convert.ToInt32(ToolHelper.UrlParDecode(Request.QueryString["pageNow"], "1"));

            if (sltOrderBy == "0")
            {
                devSort = " ORDER BY O.PayTime DESC ";
            }
            if (sltOrderBy == "1")
            {
                devSort = " ORDER BY O.AddTime DESC ";
            }
            if (sltOrderBy == "2")
            {
                devSort = " ORDER BY O.UpdateTime DESC ";
            }
            iptSearch.Value      = searchName;
            sltByTimeStart.Value = byTimeStart;
            sltByTimeEnd.Value   = byTimeEnd;
            int    pageSize  = 20;
            int    listCount = new DB.BLL.MB_Bll(DBEnum.Slave).GetByPageOrderListCount(byTimeStart, byTimeEnd, suppliersID, orderStatus, payID, searchName);
            string url       = "/web/order/order_list.aspx?";

            url += "byTimeStart=" + ToolHelper.UrlParEncode(byTimeStart, "") + "&";
            url += "byTimeEnd=" + ToolHelper.UrlParEncode(byTimeEnd, "") + "&";
            url += "byOrderStatus=" + ToolHelper.UrlParEncode(orderStatus, "") + "&";
            url += "byPayID=" + ToolHelper.UrlParEncode(payID, "") + "&";
            url += "bySuppliers=" + ToolHelper.UrlParEncode(suppliersID, "") + "&";
            url += "byOrderBy=" + ToolHelper.UrlParEncode(sltOrderBy, "") + "&";
            url += "searchName=" + ToolHelper.UrlParEncode(searchName, "") + "&";
            object        dt            = new DB.BLL.MB_Bll(DBEnum.Slave).GetByPageOrderList(byTimeStart, byTimeEnd, suppliersID, orderStatus, payID, searchName, devSort, (pageNow - 1) * pageSize, pageSize);
            PageNavHelper pageNavHelper = new PageNavHelper(listCount, pageNow, pageSize, url + "pageNow=");

            pageNav.InnerHtml = pageNavHelper.ToHtml();
            return(dt);
        }
示例#25
0
        /// <summary>
        /// 获取当前账号需要发货的订单数量
        /// </summary>
        /// <returns></returns>
        private int GetOrderInfoToDelivery(out string hrefUrl)
        {
            int resMsg = 0;

            hrefUrl = "javascript:;";
            string suppliersID = WebLoginHelper.GetAdminSupplier();

            if (!string.IsNullOrEmpty(suppliersID))
            {
                if (WebLoginHelper.IsAuthority(AdminAuth.SuppliersManage))
                {
                    hrefUrl = "/web/thirdAdmin/orderList.aspx?";
                    resMsg  = new DB.BLL.MB_Bll(DBEnum.Slave).GetModelListCount <DB.Model.M_OrderInfo>(" SuppliersID=@_SuppliersID AND OrderStatus=1 AND PayStatus=2 AND ShippingStatus=0 ", new { _SuppliersID = suppliersID });
                }
                else if (WebLoginHelper.IsAuthority(AdminAuth.BackgroundManage))
                {
                    hrefUrl = "/web/order/order_list.aspx?";
                    resMsg  = new DB.BLL.MB_Bll(DBEnum.Slave).GetModelListCount <DB.Model.M_OrderInfo>(" OrderStatus=1 AND PayStatus=2 AND ShippingStatus=0 ", null);
                }
            }
            return(resMsg);
        }
示例#26
0
        public object GetGoodsList(string byCateType, string bySuppliers, string byIsEnable, string byOrderBy)
        {
            string devSort    = string.Empty;
            string searchName = ToolHelper.UrlParDecode(Request.QueryString["searchName"], "");
            int    pageNow    = Convert.ToInt32(ToolHelper.UrlParDecode(Request.QueryString["pageNow"], "1"));

            if (byOrderBy == "0")
            {
                devSort = " ORDER BY GoodsNumber ASC, OrderBy ASC,GoodsID ";
            }
            if (byOrderBy == "1")
            {
                devSort = " ORDER BY ShopPrice ASC ,OrderBy ASC,GoodsID ";
            }
            if (byOrderBy == "2")
            {
                devSort = "  ORDER BY SaleNumber DESC ,OrderBy ASC,GoodsID ";
            }
            if (byOrderBy == "3")
            {
                devSort = " ORDER BY AddTime DESC ,OrderBy ASC,GoodsID ";
            }
            iptSearch.Value = searchName;
            int    pageSize  = 10;
            int    listCount = new DB.BLL.MB_Bll(DBEnum.Slave).GetByPageGoodsListCount(byCateType, bySuppliers, byIsEnable, searchName);
            string url       = "/web/goods/goods_list.aspx?";

            url += "byCateType=" + ToolHelper.UrlParEncode(byCateType, "") + "&";
            url += "bySuppliers=" + ToolHelper.UrlParEncode(bySuppliers, "") + "&";
            url += "byIsEnable=" + ToolHelper.UrlParEncode(byIsEnable, "") + "&";
            url += "searchName=" + ToolHelper.UrlParEncode(searchName, "") + "&";
            url += "byOrderBy=" + ToolHelper.UrlParEncode(byOrderBy, "") + "&";
            object        dt            = new DB.BLL.MB_Bll(DBEnum.Slave).GetByPageGoodsList(byCateType, bySuppliers, byIsEnable, devSort, searchName, (pageNow - 1) * pageSize, pageSize);
            PageNavHelper pageNavHelper = new PageNavHelper(listCount, pageNow, pageSize, url + "pageNow=");

            pageNav.InnerHtml = pageNavHelper.ToHtml();
            return(dt);
        }
示例#27
0
        /// <summary>
        /// EXCLE上传商品信息
        /// </summary>
        /// <param name="path"></param>
        /// <returns></returns>
        public string ReadExclToSqlProduct(string path)
        {
            string resInfo = string.Empty;

            if (WebLoginHelper.IsAuthority(AdminAuth.GoodsManage))
            {
                DataTable dt             = new ExcelHelper().ReadExcel(HttpContext.Current.Server.MapPath(path));
                decimal   outMarketPrice = 0;
                decimal   outShopPrice   = 0;
                string    sqlPath_1      = string.Empty;
                string    sqlPath_2      = string.Empty;
                string    url            = string.Empty;

                //复制DataTable表结构到错误表
                DataTable dtError = dt.Clone();
                if (!dtError.Columns.Contains("错误信息"))
                {
                    dtError.Columns.Add("错误信息", Type.GetType("System.String"));
                }
                if (dt != null)
                {
                    resInfo = "共上传" + dt.Rows.Count + "条数据";
                    DateTime nowTime = DateTime.Now;
                    IEnumerable <dynamic> dtCategoryList = new DB.BLL.MB_Bll(DBEnum.Slave).GetCategoryList();                                                           //获取所有的类目数据(包括父级)
                    IEnumerable <dynamic> dtFareTempList = new DB.BLL.MB_Bll(DBEnum.Slave).GetModelList(" SELECT FareName,FareSysID FROM M_FareTemplate WHERE 1=1 ", null);
                    List <M_Goods>        dtGoodsList    = new DB.BLL.MB_Bll(DBEnum.Slave).GetModelList <M_Goods>("1=1 AND IsDelete = 0 ORDER BY AddTime DESC ", null); //获取当前已有的产品信息
                    List <M_Brand>        dtBrandList    = new DB.BLL.MB_Bll(DBEnum.Slave).GetModelList <M_Brand>(" 1=1 ", null);                                       //获取当前已有的品牌信息
                    List <M_Suppliers>    dtSuppliers    = new DB.BLL.MB_Bll(DBEnum.Slave).GetModelList <M_Suppliers>(" 1=1 ", null);
                    string  errInfo   = string.Empty;
                    string  tempErr   = string.Empty;
                    M_Goods goodsInfo = new M_Goods();
                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        goodsInfo      = new M_Goods();
                        errInfo        = string.Empty;
                        sqlPath_1      = string.Empty;
                        sqlPath_2      = string.Empty;
                        url            = string.Empty;
                        outMarketPrice = 0;
                        outShopPrice   = 0;
                        try
                        {
                            if (dtGoodsList != null)
                            {
                                foreach (var item in dtGoodsList)//遍历商品信息表查看该商品编号是否存在,如果存在则跳出本次循环
                                {
                                    if (item.GoodsSn == dt.Rows[i]["GoodsSn"].ToString())
                                    {
                                        errInfo += "该商品编号已经存在,勿重复创建;";
                                        break;
                                    }
                                }
                            }
                            tempErr = "供应商不存在";
                            if (dtSuppliers != null)
                            {
                                foreach (var item in dtSuppliers)
                                {
                                    if (item.SuppliersName == Convert.ToString(dt.Rows[i]["SuppliersID"]))
                                    {
                                        goodsInfo.SuppliersID = item.SuppliersID;
                                        tempErr = string.Empty;
                                        break;
                                    }
                                }
                            }
                            errInfo += tempErr;
                            tempErr  = "类目不存在;";//临时错误信息用来存储临时判断环节可能出现的错误
                            if (dtCategoryList != null)
                            {
                                foreach (var item in dtCategoryList)
                                {
                                    if (item.CateName_1 == dt.Rows[i]["CateName_1"].ToString() && item.CateName_2 == dt.Rows[i]["CateName_2"].ToString())
                                    {
                                        goodsInfo.CateID = Convert.ToInt32(item.CateID);
                                        tempErr          = string.Empty;//符合条件后清空临时错误
                                        break;
                                    }
                                }
                            }
                            errInfo += tempErr;    //判断一个环节结束后将临时错误加到这个要输出的错误信息后面去
                            tempErr  = "运费模板不存在;"; //临时错误信息用来存储临时判断环节可能出现的错误
                            if (dtFareTempList != null)
                            {
                                foreach (var item in dtFareTempList)
                                {
                                    if (item.FareName == dt.Rows[i]["FareName"].ToString())//遍历运费模板页,找到这个运费模板信息后清空错误信息
                                    {
                                        goodsInfo.FareSysID = item.FareSysID;
                                        tempErr             = string.Empty;//符合条件后清空临时错误
                                        break;
                                    }
                                }
                            }
                            errInfo += tempErr;
                            tempErr  = "金额出错;";
                            if (decimal.TryParse(dt.Rows[i]["MarketPrice"].ToString(), out outMarketPrice) && decimal.TryParse(dt.Rows[i]["ShopPrice"].ToString(), out outShopPrice))
                            {
                                goodsInfo.MarketPrice = outMarketPrice;
                                goodsInfo.ShopPrice   = outShopPrice;
                                tempErr = string.Empty;//符合条件后清空临时错误
                            }
                            errInfo += tempErr;
                            if (!string.IsNullOrEmpty(dt.Rows[i]["BrandName"].ToString()))
                            {
                                tempErr = "品牌不存在";
                                if (dtBrandList != null)
                                {
                                    foreach (var item in dtBrandList)
                                    {
                                        if (item.BrandName == dt.Rows[i]["BrandName"].ToString())
                                        {
                                            goodsInfo.BrandID = item.BrandID;
                                            tempErr           = string.Empty;
                                            break;
                                        }
                                    }
                                }
                                errInfo += tempErr;
                            }
                            if (string.IsNullOrEmpty(errInfo))//最后判断这个临时错误信息
                            {
                                url = dt.Rows[i]["GoodsImg"].ToString();
                                url = GetInterNetImgUrl(url);
                                if (!string.IsNullOrEmpty(url))
                                {
                                    DownloadFiles(url, out sqlPath_1, out sqlPath_2);
                                }
                                goodsInfo.GoodsImg    = sqlPath_1;
                                goodsInfo.GoodsThumb  = sqlPath_2;
                                goodsInfo.OriginalImg = sqlPath_1;
                                goodsInfo.GoodsID     = Guid.NewGuid().ToString();
                                goodsInfo.GoodsSn     = dt.Rows[i]["GoodsSn"].ToString();
                                goodsInfo.GoodsName   = dt.Rows[i]["GoodsName"].ToString();
                                goodsInfo.GoodsNumber = Convert.ToInt32(dt.Rows[i]["GoodsNumber"].ToString());
                                goodsInfo.GoodsBrief  = dt.Rows[i]["GoodsBrief"].ToString();
                                goodsInfo.IsReal      = Convert.ToInt32(dt.Rows[i]["IsReal"].ToString());
                                goodsInfo.IsNew       = Convert.ToInt32(dt.Rows[i]["IsNew"].ToString());
                                goodsInfo.IsHot       = Convert.ToInt32(dt.Rows[i]["IsHot"].ToString());
                                goodsInfo.SellerNote  = dt.Rows[i]["SellerNote"].ToString();
                                goodsInfo.Weight      = Convert.ToDouble(dt.Rows[i]["Weight"].ToString());
                                if (!(new DB.BLL.MB_Bll(DBEnum.Master).AddGoodsInfo(goodsInfo.CateID, goodsInfo.MarketPrice, goodsInfo.ShopPrice, goodsInfo.BrandID, goodsInfo.GoodsImg, goodsInfo.GoodsThumb, goodsInfo.OriginalImg, goodsInfo.SuppliersID, goodsInfo.GoodsSn, goodsInfo.GoodsName, goodsInfo.GoodsNumber, goodsInfo.GoodsBrief, goodsInfo.IsReal, goodsInfo.IsNew, goodsInfo.IsHot, goodsInfo.Weight, goodsInfo.SellerNote, goodsInfo.FareSysID, WebLoginHelper.GetAdminName())))
                                {
                                    dtError.ImportRow(dt.Rows[i]);
                                    dtError.Rows[dtError.Rows.Count - 1]["错误信息"] = "该条记录写入数据库失败";
                                }
                                else
                                {
                                    dtGoodsList.Add(goodsInfo);//将创建成功后的这条信息加到数据集合中
                                }
                            }
                            else
                            {
                                dtError.ImportRow(dt.Rows[i]);
                                dtError.Rows[dtError.Rows.Count - 1]["错误信息"] = errInfo;
                            }
                        }
                        catch (Exception eMsg)
                        {
                            dtError.ImportRow(dt.Rows[i]);
                            dtError.Rows[dtError.Rows.Count - 1]["错误信息"] = "该条记录使系统产生严重错误,请联系管理员:" + eMsg.Message;
                        }
                    }
                    if (dtError != null)
                    {
                        resInfo += " 上传失败" + dtError.Rows.Count + "条";
                        new ExcelHelper().DataTableToExcel(dtError, "xls", "上传错误信息表", Path.GetDirectoryName(HttpContext.Current.Server.MapPath(path)) + "/上传错误信息表.xls");
                    }
                }
            }
            else
            {
                resInfo = "上传失败,当前账户无权执行ECXEL商品信息导入操作";
            }
            return(resInfo);
        }
示例#28
0
        /// <summary>
        /// 将订单的付款金额推送给XF系统进行资金结算
        /// </summary>
        /// <param name="pushType">推送类型</param>
        /// <param name="pushOrderSn">推送订单编号</param>
        /// <param name="pushOrderAmount">推送订单总金额</param>
        /// <param name="pushFeeAmount">推送订单运费金额</param>
        /// <param name="resPayInfo">返回的支付信息</param>
        /// <returns></returns>
        public static bool SeacherThisOrderTrade(string orderID, out string resPayInfo)
        {
            resPayInfo = string.Empty;
            DSMT_TAE_ServiceSoapClient taeCilent = new DSMT_TAE_ServiceSoapClient();
            GetQueryOrderStatusEntity  getQueryOrderStatusEntity  = new GetQueryOrderStatusEntity();
            BackQueryOrderStatusEntity backQueryOrderStatusEntity = new BackQueryOrderStatusEntity();
            VerifyHelper verifyHelper = new VerifyHelper();

            DB.Model.M_OrderInfo orderInfo   = new DB.BLL.MB_Bll(DBEnum.Slave).GetModel <DB.Model.M_OrderInfo>(" OrderID=@_OrderID ", new { _OrderID = orderID });
            DB.Model.M_Payment   payMentInfo = new DB.BLL.MB_Bll(DBEnum.Slave).GetModel <DB.Model.M_Payment>(" PayID=@_PayID ", new { _PayID = 20 });
            if (orderInfo != null && payMentInfo != null)
            {
                getQueryOrderStatusEntity.OpenID       = orderInfo.OpenID;
                getQueryOrderStatusEntity.OrderNo      = orderInfo.OrderSn;
                getQueryOrderStatusEntity.UnifyOrderNo = orderInfo.OrderUnifySn;
                getQueryOrderStatusEntity.OrderTime    = Convert.ToString(orderInfo.AddTime);
                string resMsg  = string.Empty;
                string orderSn = string.Empty;
                verifyHelper.EncryptPmtEntity(getQueryOrderStatusEntity);
                try
                {
                    backQueryOrderStatusEntity = taeCilent.QueryOrderStatus(getQueryOrderStatusEntity);//调xf接口
                    if (verifyHelper.CheckPmtSign(ref backQueryOrderStatusEntity))
                    {
                        /// 交易状态10-成功20-失败30-待同步40-交易信息不存在
                        if (backQueryOrderStatusEntity != null && !string.IsNullOrEmpty(backQueryOrderStatusEntity.TradeStatus) && !string.IsNullOrEmpty(backQueryOrderStatusEntity.TradeNo))//XF系统返回的数据不为空,并且状态信息不为空
                        {
                            if (backQueryOrderStatusEntity.TradeStatus == "10" || backQueryOrderStatusEntity.TradeStatus == "20" || backQueryOrderStatusEntity.TradeStatus == "30")
                            {
                                orderSn = (backQueryOrderStatusEntity.IsUnify == "0")? orderInfo.OrderSn:orderSn;
                                if (new DB.BLL.MB_Bll(DBEnum.Master).UpdateOrderInfoFromXFPayment(orderInfo.OrderUnifySn, orderSn, ToolHelper.ConventToDecimal(backQueryOrderStatusEntity.TradeMoney, 9999), backQueryOrderStatusEntity.TradeNo, ToolHelper.ConventToDateTime(backQueryOrderStatusEntity.TradeTime, DateTime.Now), payMentInfo, backQueryOrderStatusEntity.CpySysID, backQueryOrderStatusEntity.CpyName, out resMsg))
                                {
                                    //WeChatAPI.SendMsg("异常订单处理成功", "您有一笔异常订单已被成功处理,请关注最新的订单状态",orderInfo.OpenID);
                                    return(true);
                                }
                                else
                                {
                                    resPayInfo = resMsg;
                                }
                            }
                            else
                            {
                                resPayInfo = "交易信息不存在";
                            }
                        }
                        else
                        {
                            resPayInfo = "XF系统返回数据出错,请稍后再试";
                        }
                    }
                    else//验签失败
                    {
                        resPayInfo = "从XF系统返回的数据通讯错误,签名验证失败";
                    }
                }
                catch (Exception e)
                {
                    resPayInfo = "与XF系统的通讯出错,返回错误信息:" + e.Message;
                }
            }
            else
            {
                resPayInfo = "获取相应的数据出错";
            }
            return(false);
        }