3个文件已添加
35个文件已修改
8个文件已删除
1 文件已重命名
| | |
|---|
| | | </site> |
|---|
| | | <site name="web" id="2"> |
|---|
| | | <application path="/" applicationPool="Clr4IntegratedAppPool"> |
|---|
| | | <virtualDirectory path="/" physicalPath="C:\Users\mac\Desktop\RDream\SMGW_NewWeb\web\web" /> |
|---|
| | | <virtualDirectory path="/" physicalPath="C:\Users\mac\Desktop\Work-Archives\SMGW\SMGW_NewWeb\web\web" /> |
|---|
| | | </application> |
|---|
| | | <bindings> |
|---|
| | | <binding protocol="http" bindingInformation="*:60960:localhost" /> |
|---|
| | |
|---|
| | | <DebugSymbols>true</DebugSymbols> |
|---|
| | | <DebugType>full</DebugType> |
|---|
| | | <Optimize>false</Optimize> |
|---|
| | | <OutputPath>..\Lib\</OutputPath> |
|---|
| | | <OutputPath>bin\Release\</OutputPath> |
|---|
| | | <DefineConstants>DEBUG;TRACE</DefineConstants> |
|---|
| | | <ErrorReport>prompt</ErrorReport> |
|---|
| | | <WarningLevel>4</WarningLevel> |
|---|
| | |
|---|
| | | /// <param name="productId">产品ID</param> |
|---|
| | | /// <returns></returns> |
|---|
| | | //public List<GwClient> LoadInfoList(out int recordCount, int pageIndex, int pageSizestring, string clientID, string clientName, string telphone, string agent) |
|---|
| | | public List<GwClient> LoadInfoList(out int recordCount, int pageIndex, int pageSizestring, string clientID, string clientName, string telephone, string agent, string company, string salesman, string supportStaff, string productId, int isEnable, string permissionsSQL ) |
|---|
| | | public List<GwClient> LoadInfoList(out int recordCount, int pageIndex, int pageSizestring, string clientID, string clientName, string telephone, string agent, string company, string salesman, string supportStaff, string productId, int isEnable,int isSub, string permissionsSQL ) |
|---|
| | | { |
|---|
| | | |
|---|
| | | List<GwClient> list = new List<GwClient>(); |
|---|
| | |
|---|
| | | stringBuilder.Append(" ) t on t.client_id = gwc.client_id "); |
|---|
| | | //stringBuilder.Append("from GW_CLIENT where 1=1"); |
|---|
| | | stringBuilder.Append(" WHERE 1=1"); |
|---|
| | | OracleParameter[] oracleParameterArray = new OracleParameter[8]; |
|---|
| | | OracleParameter[] oracleParameterArray = new OracleParameter[9]; |
|---|
| | | if (clientID != null && clientID != "") |
|---|
| | | { |
|---|
| | | oracleParameterArray[0] = new OracleParameter(":ClientID", (OracleDbType)126); |
|---|
| | |
|---|
| | | stringBuilder.Append(" and gwc.IS_ENABLE = :IS_ENABLE"); |
|---|
| | | } |
|---|
| | | |
|---|
| | | //是否一级账户。0为一级 |
|---|
| | | if (isSub == 0) |
|---|
| | | { |
|---|
| | | oracleParameterArray[8] = new OracleParameter(":CLIENT_PARENTID", OracleDbType.Int32); |
|---|
| | | ((DbParameter)oracleParameterArray[8]).Value = (object)(isSub); |
|---|
| | | stringBuilder.Append(" and gwc.CLIENT_PARENTID = :CLIENT_PARENTID"); |
|---|
| | | } |
|---|
| | | else |
|---|
| | | { |
|---|
| | | oracleParameterArray[8] = new OracleParameter(":CLIENT_PARENTID", OracleDbType.Int32); |
|---|
| | | ((DbParameter)oracleParameterArray[8]).Value = (object)(isSub); |
|---|
| | | stringBuilder.Append(" and gwc.CLIENT_PARENTID != :CLIENT_PARENTID"); |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | if (productId != null && productId != "") |
|---|
| | | { |
|---|
| | | stringBuilder.Append(" and gwc.CLIENT_ID IN ( SELECT distinct CLIENT_ID FROM GW_SP WHERE PRODUCT_ID = '" + productId + "' )"); |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | //客户权限SQL脚本 |
|---|
| | | stringBuilder.Append(permissionsSQL); |
|---|
| | | |
|---|
| | |
|---|
| | | EndProjectSection |
|---|
| | | ProjectSection(WebsiteProperties) = preProject |
|---|
| | | TargetFrameworkMoniker = ".NETFramework,Version%3Dv4.0" |
|---|
| | | ProjectReferences = "" |
|---|
| | | ProjectReferences = "{6199dc29-d043-41b0-bdfd-afa19adc7848}|App_Code.dll;{d0cdbf9c-d79a-434f-adb0-0a58b7b5e1d6}|Dao.dll;{337CD576-BA09-4182-9FDD-8F1AB1B30624}|Model.dll;" |
|---|
| | | Debug.AspNetCompiler.VirtualPath = "/Web" |
|---|
| | | Debug.AspNetCompiler.PhysicalPath = "Web\" |
|---|
| | | Debug.AspNetCompiler.TargetPath = "PrecompiledWeb\Web\" |
|---|
| | |
|---|
| | | int recordCount = 0; |
|---|
| | | int pageSize = this.AppContext.GetInt("pageSize", 999999999); |
|---|
| | | |
|---|
| | | int isSub = AppContext.GetInt("isSub",0); |
|---|
| | | |
|---|
| | | string str = ""; |
|---|
| | | using (GwClientDao dao = new GwClientDao()) |
|---|
| | | { |
|---|
| | | string permissionsSQL = dao.GetClientPermissions(_userId, _userType, "gwc"); |
|---|
| | | var list = dao.LoadInfoList(out recordCount, pageIndex, pageSize, ClientID, ClientName, Telephone, Agent, Company, Salesman, SupportStaff, ProductId, IsEnable, permissionsSQL); |
|---|
| | | var list = dao.LoadInfoList(out recordCount, pageIndex, pageSize, ClientID, ClientName, Telephone, Agent, Company, Salesman, SupportStaff, ProductId, IsEnable,isSub, permissionsSQL); |
|---|
| | | if (recordCount> 1000000) |
|---|
| | | { |
|---|
| | | this.Response.Write("<script type='text/javascript'>alert('导出数据不能大于100万条！');location.href='GwClient.aspx?IsEnable=" + IsEnable + "';</script>"); |
|---|
| | |
|---|
| | | string serverIp = ConfigurationManager.AppSettings["serverIp"]; |
|---|
| | | string clientPort = ConfigurationManager.AppSettings["clientPort"]; |
|---|
| | | |
|---|
| | | int isSub = context.GetInt("isSub",0); |
|---|
| | | |
|---|
| | | string str = ""; |
|---|
| | | using (GwClientDao dao = new GwClientDao()) |
|---|
| | | { |
|---|
| | | string permissionsSQL = dao.GetClientPermissions(_userId, _userType, "gwc"); |
|---|
| | | var list = dao.LoadInfoList(out recordCount, pageIndex, pageSize, ClientID, ClientName, Telephone, Agent, Company, Salesman, SupportStaff, ProductId, IsEnable, permissionsSQL); |
|---|
| | | var list = dao.LoadInfoList(out recordCount, pageIndex, pageSize, ClientID, ClientName, Telephone, Agent, Company, Salesman, SupportStaff, ProductId, IsEnable,isSub, permissionsSQL); |
|---|
| | | |
|---|
| | | if (list != null && list.Count > 0) |
|---|
| | | { |
|---|
| | |
|---|
| | | } |
|---|
| | | } |
|---|
| | | }); |
|---|
| | | |
|---|
| | | //swal.close(); |
|---|
| | | //} |
|---|
| | | //}); |
|---|
| | | } |
|---|
| | | }); |
|---|
| | | |
|---|
| | |
|---|
| | | var SupportStaff = $("#SupportStaff").val(); |
|---|
| | | var ProductId = $("#ProductId").val(); |
|---|
| | | var IsEnable = <%=IsEnable%>; |
|---|
| | | let isSub = 1; |
|---|
| | | $.ajax({ |
|---|
| | | url: "GwClient.ashx", |
|---|
| | | type: "POST", |
|---|
| | | data: { action: "loadGwClientPageList", ClientID: ClientID, Company: Company, ClientName: ClientName, Telephone: Telephone, Agent: Agent, Salesman: Salesman, SupportStaff: SupportStaff, ProductId: ProductId, IsEnable: IsEnable , pageSize: $("#pager").Pager("getPageSize"), pageIndex: $("#pager").Pager("getPageIndex") }, |
|---|
| | | data: { action: "loadGwClientPageList", isSub: isSub, ClientID: ClientID, Company: Company, ClientName: ClientName, Telephone: Telephone, Agent: Agent, Salesman: Salesman, SupportStaff: SupportStaff, ProductId: ProductId, IsEnable: IsEnable, pageSize: $("#pager").Pager("getPageSize"), pageIndex: $("#pager").Pager("getPageIndex") }, |
|---|
| | | success: function (result) { |
|---|
| | | if (result.OK) { |
|---|
| | | $("#gwclientTable tbody").html(result.Message.Table); |
|---|
| | |
|---|
| | | |
|---|
| | | using System; |
|---|
| | | using System.Web; |
|---|
| | | //using com.softwee.smgw.common; |
|---|
| | | using Dao; |
|---|
| | | using Model; |
|---|
| | | using System.Collections.Generic; |
|---|
| | |
|---|
| | | <a href="#"><i class="fa fa-user-secret"></i><span class="nav-label">客户管理 </span><span class="fa arrow"></span></a> |
|---|
| | | <ul class="nav nav-second-level"> |
|---|
| | | <li><a href="GwClient.aspx?IsEnable=1" class="J_menuItem">客户信息管理</a> </li> |
|---|
| | | <li><a href="GwClient.aspx?IsEnable=1" class="J_menuItem">分销商下级客户信息管理</a> </li> |
|---|
| | | <li><a href="GwClientSub.aspx?IsEnable=1" class="J_menuItem">分销商下级客户信息管理</a> </li> |
|---|
| | | |
|---|
| | | <li><a href="GwClient.aspx?IsEnable=0" class="J_menuItem">停用客户信息管理</a> </li> |
|---|
| | | <li><a href="GwSp.aspx" class="J_menuItem">短信账号管理</a> </li> |
|---|
| | |
|---|
| | | <Project>{6199DC29-D043-41B0-BDFD-AFA19ADC7848}</Project> |
|---|
| | | <Name>App_Code</Name> |
|---|
| | | </ProjectReference> |
|---|
| | | <ProjectReference Include="..\Dao\Dao.csproj"> |
|---|
| | | <Project>{D0CDBF9C-D79A-434F-ADB0-0A58B7B5E1D6}</Project> |
|---|
| | | <Name>Dao</Name> |
|---|
| | | </ProjectReference> |
|---|
| | | <ProjectReference Include="..\Model\Model.csproj"> |
|---|
| | | <Project>{337CD576-BA09-4182-9FDD-8F1AB1B30624}</Project> |
|---|
| | | <Name>Model</Name> |
|---|
| | | </ProjectReference> |
|---|
| | | <ProjectReference Include="..\UMCLib\UMCLib.csproj"> |
|---|
| | | <Project>{AA804FAB-0293-4EB3-BF43-8103F1CC93F5}</Project> |
|---|
| | | <Name>UMCLib</Name> |
|---|
| | | </ProjectReference> |
|---|
| | | </ItemGroup> |
|---|
| | | <Import Project="$(_WebPublishTargetsPath)\Web\Microsoft.WebSite.Publishing.targets" /> |
|---|
| | | </Project> |
|---|
