/// <summary> /// 获取供应商列表交易次数合计 /// </summary> /// <param name="companyId">公司编号(专线)</param> /// <param name="type">供应商类型</param> /// <param name="searchInfo">查询信息</param> /// <returns></returns> public int GetTimesGYSSummary(int companyId, EyouSoft.Model.EnumType.CompanyStructure.SupplierType type, EyouSoft.Model.CompanyStructure.MSupplierSearchInfo searchInfo) { if (companyId < 1) { return(0); } return(Dal.GetTimesGYSSummary(companyId, type, searchInfo)); }
/// <summary> /// 分页获取供应商购物信息 /// </summary> /// <param name="pageSize">每页数</param> /// <param name="pageIndex">起始页</param> /// <param name="recordCount">总数</param> /// <param name="supplierType">供应商类型</param> /// <param name="queryModel">查询实体</param> public IList <EyouSoft.Model.SupplierStructure.SupplierShopping> GetList(int pageSize, int pageIndex, ref int recordCount, int companyId, EyouSoft.Model.EnumType.CompanyStructure.SupplierType supplierType, EyouSoft.Model.SupplierStructure.SupplierQuery queryModel) { IList <EyouSoft.Model.SupplierStructure.SupplierShopping> ls = new List <EyouSoft.Model.SupplierStructure.SupplierShopping>(); string tableName = "tbl_CompanySupplier"; StringBuilder fields = new StringBuilder(); fields.Append(" Id,UnitAddress,ProvinceName,CityName,"); fields.Append(" (select top 1 ContactName,ContactTel,ContactFax from tbl_SupplierContact a where a.SupplierId = tbl_CompanySupplier.[Id] for xml raw,root('root')) as ContactXML,"); fields.Append(" (select top 1 SaleProduct from tbl_SupplierShopping b where b.Id = tbl_CompanySupplier.[Id] for xml raw,root('root')) as ShoppingXML,"); fields.Append(" UnitName,TradeNum "); string primaryKey = "Id"; string orderbyStr = "IssueTime desc"; StringBuilder strWhere = new StringBuilder(" IsDelete='0' "); strWhere.AppendFormat(" and SupplierType={0}", Convert.ToByte((int)supplierType)); strWhere.AppendFormat(" and CompanyId = {0}", companyId); if (queryModel != null) { if (queryModel.ProvinceId > 0) { strWhere.AppendFormat(" and ProvinceId={0}", queryModel.ProvinceId); } if (queryModel.CityId > 0) { strWhere.AppendFormat(" and CityId={0}", queryModel.CityId); } if (!string.IsNullOrEmpty(queryModel.UnitName)) { strWhere.AppendFormat(" and UnitName like '%{0}%'", queryModel.UnitName); } } using (IDataReader dr = DbHelper.ExecuteReader(this._db, pageSize, pageIndex, ref recordCount, tableName, primaryKey, fields.ToString(), strWhere.ToString(), orderbyStr)) { while (dr.Read()) { EyouSoft.Model.SupplierStructure.SupplierShopping model = new EyouSoft.Model.SupplierStructure.SupplierShopping(); model.Id = dr.GetInt32(dr.GetOrdinal("Id")); model.ProvinceName = dr.IsDBNull(dr.GetOrdinal("ProvinceName")) ? "" : dr.GetString(dr.GetOrdinal("ProvinceName")); model.CityName = dr.IsDBNull(dr.GetOrdinal("CityName")) ? "" : dr.GetString(dr.GetOrdinal("CityName")); model.UnitAddress = dr.IsDBNull(dr.GetOrdinal("UnitAddress")) ? "" : dr.GetOrdinal("UnitAddress").ToString(); model.UnitName = dr.GetString(dr.GetOrdinal("UnitName")); model.TradeNum = dr.GetInt32(dr.GetOrdinal("TradeNum")); model.SupplierContact = GetContactList(dr.IsDBNull(dr.GetOrdinal("ContactXML")) ? "" : dr.GetString(dr.GetOrdinal("ContactXML"))); model.SaleProduct = GetShoppingList(dr.IsDBNull(dr.GetOrdinal("ShoppingXML")) ? "" : dr.GetString(dr.GetOrdinal("ShoppingXML"))); ls.Add(model); model = null; } } return(ls); }
/// <summary> /// /// </summary> protected void DataInit(string djName) { EyouSoft.Model.EnumType.CompanyStructure.SupplierType sType = EyouSoft.Model.EnumType.CompanyStructure.SupplierType.地接; if (Utils.GetInt(Utils.GetQueryStringValue("sType"), 0) == 5) { sType = EyouSoft.Model.EnumType.CompanyStructure.SupplierType.票务; lbSupplerTypeName.InnerText = "票务名称:"; } if (Utils.GetInt(Utils.GetQueryStringValue("sType"), 0) == 4) { sType = EyouSoft.Model.EnumType.CompanyStructure.SupplierType.保险; lbSupplerTypeName.InnerText = "保险名称:"; } if (Utils.GetInt(Utils.GetQueryStringValue("sType"), 0) == 7) { sType = EyouSoft.Model.EnumType.CompanyStructure.SupplierType.购物; lbSupplerTypeName.InnerText = "购物名称:"; } if (Utils.GetInt(Utils.GetQueryStringValue("sType"), 0) == 3) { sType = EyouSoft.Model.EnumType.CompanyStructure.SupplierType.景点; lbSupplerTypeName.InnerText = "景点名称:"; } if (Utils.GetInt(Utils.GetQueryStringValue("sType"), 0) == 1) { sType = EyouSoft.Model.EnumType.CompanyStructure.SupplierType.酒店; lbSupplerTypeName.InnerText = "酒店名称:"; } if (Utils.GetInt(Utils.GetQueryStringValue("sType"), 0) == 9) { sType = EyouSoft.Model.EnumType.CompanyStructure.SupplierType.其他; lbSupplerTypeName.InnerText = "其它名称:"; } if (Utils.GetInt(Utils.GetQueryStringValue("sType"), 0) == 8) { sType = EyouSoft.Model.EnumType.CompanyStructure.SupplierType.车队; lbSupplerTypeName.InnerText = "车队名称:"; } if (Utils.GetInt(Utils.GetQueryStringValue("sType"), 0) == 2) { sType = EyouSoft.Model.EnumType.CompanyStructure.SupplierType.餐馆; lbSupplerTypeName.InnerText = "餐馆名称:"; } //声明操作对象 EyouSoft.BLL.CompanyStructure.CompanySupplier bll = new EyouSoft.BLL.CompanyStructure.CompanySupplier(); //查询地接社数据,获得列表list IList <EyouSoft.Model.CompanyStructure.CompanySupplier> list = bll.GetList(pageSize, pageIndex, ref recordCount, sType, 0, 0, djName, this.CurrentUserCompanyID); if (list != null && list.Count > 0) { this.rptList.DataSource = list; this.rptList.DataBind(); //设置分页 BindPage(); } else { //没有数据时隐藏分页控件 并 提示信息 this.ExportPageInfo1.Visible = false; this.lblMsg.Text = "没有找到相关信息!"; } }
/// <summary> /// 分页获取供应商购物信息 /// </summary> /// <param name="pageSize">每页显示数</param> /// <param name="pageIndex">起始页码</param> /// <param name="recordCount">总数</param> /// <param name="supplierType">供应商类型</param> /// <param name="cityId">城市ID</param> /// <param name="shopName">商店名称</param> /// <param name="companyId">公司ID</param> /// <returns></returns> public IList <EyouSoft.Model.SupplierStructure.SupplierShopping> GetList(int pageSize, int pageIndex, ref int recordCount, int companyId, EyouSoft.Model.EnumType.CompanyStructure.SupplierType supplierType, EyouSoft.Model.SupplierStructure.SupplierQuery queryModel) { return(Dal.GetList(pageSize, pageIndex, ref recordCount, companyId, supplierType, queryModel)); }
/// <summary> /// 分页获取供应商列表 /// </summary> /// <param name="pageSize">每页条数</param> /// <param name="pageIndex">当前页码</param> /// <param name="RecordCount">总数</param> /// <param name="supplierType">供应商类型(0-地接 1票务)</param> /// <param name="ProvinceName">省份名称(可为空)</param> /// <param name="CityName">城市名称(可为空)</param> /// <param name="UnitName">单位名称(可为空)</param> /// <returns></returns> public IList <EyouSoft.Model.SupplierStructure.SupplierOther> GetList(int pageSize, int pageIndex, ref int RecordCount, EyouSoft.Model.EnumType.CompanyStructure.SupplierType supplierType, int ProvinceId, int CityId, string UnitName, int companyId) { return(Dal.GetOtherList(pageSize, pageIndex, ref RecordCount, supplierType, UnitName, companyId)); }
/// <summary> /// 将供应商类型转换为模块 /// </summary> /// <param name="SupplierType">供应商类型</param> /// <returns></returns> private EyouSoft.Model.EnumType.CompanyStructure.SysPermissionClass GetModule(EyouSoft.Model.EnumType.CompanyStructure.SupplierType SupplierType) { EyouSoft.Model.EnumType.CompanyStructure.SysPermissionClass t = EyouSoft.Model.EnumType.CompanyStructure.SysPermissionClass.供应商管理_其它; switch (SupplierType) { case EyouSoft.Model.EnumType.CompanyStructure.SupplierType.保险: t = EyouSoft.Model.EnumType.CompanyStructure.SysPermissionClass.供应商管理_保险; break; case EyouSoft.Model.EnumType.CompanyStructure.SupplierType.餐馆: t = EyouSoft.Model.EnumType.CompanyStructure.SysPermissionClass.供应商管理_餐馆; break; case EyouSoft.Model.EnumType.CompanyStructure.SupplierType.车队: t = EyouSoft.Model.EnumType.CompanyStructure.SysPermissionClass.供应商管理_车队; break; case EyouSoft.Model.EnumType.CompanyStructure.SupplierType.地接: t = EyouSoft.Model.EnumType.CompanyStructure.SysPermissionClass.供应商管理_地接; break; case EyouSoft.Model.EnumType.CompanyStructure.SupplierType.购物: t = EyouSoft.Model.EnumType.CompanyStructure.SysPermissionClass.供应商管理_购物; break; case EyouSoft.Model.EnumType.CompanyStructure.SupplierType.景点: t = EyouSoft.Model.EnumType.CompanyStructure.SysPermissionClass.供应商管理_景点; break; case EyouSoft.Model.EnumType.CompanyStructure.SupplierType.酒店: t = EyouSoft.Model.EnumType.CompanyStructure.SysPermissionClass.供应商管理_酒店; break; case EyouSoft.Model.EnumType.CompanyStructure.SupplierType.票务: t = EyouSoft.Model.EnumType.CompanyStructure.SysPermissionClass.供应商管理_票务; break; case EyouSoft.Model.EnumType.CompanyStructure.SupplierType.其他: t = EyouSoft.Model.EnumType.CompanyStructure.SysPermissionClass.供应商管理_其它; break; } return(t); }