public DS_Agent.AgentReceivablesDataTable GetAgentOrder(int orderID) { string sql = @" SELECT a.orderID, o.firstName+'.'+o.lastName as username, a.agentID, a.agentReceivable, a.agentPaid, a.orderClosedDate, c.companyName, c.companyName_cn, a.status FROM AgentOrders AS a LEFT OUTER JOIN Company AS c ON a.agentID = c.companyId left join orders as o on a.orderID=o.orderID WHERE a.orderID=@orderID"; DS_Agent ds = new DS_Agent(); SqlParameter[] para = { new SqlParameter("@orderID", orderID) }; m_dao.FillDataSet(ds, "NewAgentOrders", sql, para); return ds.AgentReceivables; }
public DS_Agent.AgentReceivablesDataTable AgentNewReceivableByAgentID_noused(int agentID) { string sql = @" SELECT a.invoiceID, a.orderID, o.firstName+'.'+o.lastName as username, a.agentID, a.agentReceivable, a.additionalDiscount, a.agentPaid, a.agentReceivable-a.additionalDiscount-agentPaid as balance, a.orderClosedDate, a.reportDate, c.companyName, c.companyName_cn, a.status FROM AgentOrders AS a left join Company AS c ON a.agentID = c.companyId left join orders as o on a.orderID=o.orderID WHERE a.agentID=@agentID and a.invoiceID=0 ORDER BY a.orderID desc"; DS_Agent ds = new DS_Agent(); SqlParameter[] para = { new SqlParameter("@agentID", agentID) }; m_dao.FillDataSet(ds, "AgentReceivables", sql, para); return ds.AgentReceivables; }
public DS_Agent.AgentReceivablesDataTable AgentReceivablesQuery_noused() { string sql = @" SELECT a.invoiceID, a.orderID, o.firstName+'.'+o.lastName as username, a.agentID, a.agentReceivable, a.additionalDiscount, a.agentPaid, a.orderClosedDate, a.reportDate, c.companyName, c.companyName_cn, a.status FROM AgentOrders AS a left join Company AS c ON a.agentID = c.companyId left join orders as o on a.orderID=o.orderID WHERE a.status<2 ORDER BY c.companyName"; DS_Agent ds = new DS_Agent(); m_dao.FillDataSet(ds, "AgentReceivables", sql, null); return ds.AgentReceivables; }