using System.ComponentModel;
using System.Drawing;
using System.Text;
namespace MultiTableJoin
public partial class Frm_Main : Form
public Frm_Main()
InitializeComponent();
private void Frm_Main_Load(object sender, EventArgs e)
DataClassesDataContext dc = new DataClassesDataContext();//创立LINQ目标
join sd in dc.SaleDetail on sc.SaleBillCode equals sd.SaleBillCode//按出售单据号相关出售主从表
join ei in dc.EmployeeInfo on sc.SaleMan equals ei.EmployeeCode//按人员代码相关职工表
join ci in dc.ClientInfo on sc.ClientCode equals ci.ClientCode//按客户代码相关客户信息表
{
SaleBillCode = sc.SaleBillCode,//出售单据号
SaleDate = sc.SaleDate,//出售日期
WareHouse = wi.ShortName,//从库房表取库房称号
ProductName = pi.ShortName,//产品称号
Price = sd.Price,//单价
GrossProfit = sd.Quantity * (sd.Price - sd.Cost)//毛利=出售金额-产品本钱
dataGridView1.DataSource = query;//将查询的成果集绑定到dataGridView1
}
A8站源码交易平台
