销售统计系统 Web API 文档

// 异步函数方式 async function getDashboardStats() { try { const response = await fetch('https://localhost:44337/api/dashboard/stats'); const data = await response.json(); if (data.Success) { console.log('销售额:', data.TotalSales); console.log('库存金额:', data.TotalInventory); // 处理数据... return data; } else { console.error('获取失败:', data.Message); return null; } } catch (error) { console.error('网络错误:', error); return null; } } // 调用示例 getDashboardStats().then(data => { if (data) { // 更新UI document.getElementById('sales').textContent = '¥' + data.TotalSales.toFixed(2); document.getElementById('inventory').textContent = '¥' + data.TotalInventory.toFixed(2); } });

async function getSalesTotal(storeId, startDate, endDate) { const response = await fetch('https://localhost:44337/api/sales/total', { method: 'POST', headers: { 'Content-Type': 'application/json' }, body: JSON.stringify({ StoreId: storeId, StartDate: startDate, EndDate: endDate }) }); const data = await response.json(); return data; } // 调用示例 getSalesTotal(1, '2024-01-01', '2024-01-31') .then(result => { if (result.Success) { // 处理小组销售数据 result.GroupSales.forEach(group => { console.log(`${group.group}: ${group.quantity}件, ¥${group.amount}`); }); // 处理汇总数据 console.log(`总计: ${result.Summary.TotalQuantity}件, ¥${result.Summary.TotalAmount}`); } });

// 获取门店列表 $.ajax({ url: 'https://localhost:44337/api/stores/list', type: 'GET', success: function(data) { if (data.Success) { // 填充下拉菜单 var select = $('#storeSelect'); select.empty(); data.Data.forEach(store => { select.append(`<option value="${store.id}">${store.name}</option>`); }); } }, error: function(error) { console.error('获取门店列表失败:', error); } }); // POST请求示例 - 获取小组列表 $('#storeSelect').change(function() { var storeId = $(this).val(); $.ajax({ url: 'https://localhost:44337/api/groups/list', type: 'POST', contentType: 'application/json', data: JSON.stringify({ StoreId: storeId }), success: function(data) { if (data.Success) { // 处理小组数据 console.log('获取到', data.Count, '个小组'); } } }); });

// 前端JavaScript配置 const API_CONFIG = { // 开发环境 development: { baseUrl: 'https://localhost:44337/api/' }, // 生产环境 production: { baseUrl: 'https://api.your-domain.com/api/' } }; // 根据环境使用不同的配置 const currentEnv = process.env.NODE_ENV || 'development'; const API_BASE_URL = API_CONFIG[currentEnv].baseUrl;

<!-- Web.config --> <connectionStrings> <add name="MyConnectionString" connectionString="Data Source=生产服务器IP;Initial Catalog=SalesDB;User ID=sa;Password=生产密码;Integrated Security=False;Connect Timeout=30" providerName="System.Data.SqlClient" /> </connectionStrings>