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 }; }));; }
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))); }); }
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"], ""))); } }
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); }
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); }
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); }
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); }
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); }
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); }
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); }
/// <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类型变量 }
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); } }
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); }
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); }
/// <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); }
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); } }
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); } }
/// <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); }
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); }
/// <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); }
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); }
/// <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); }
/// <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); }