8,497
社区成员
发帖
与我相关
我的任务
分享
SELECT COPMA.MA002 AS 客户简称,COPTC.TC001 AS 订单单别, COPTC.TC002 AS 订单单号,
COPTD.TD003 AS 订单序号,CONVERT(datetime,COPTD.TD013) 交货日,
CONVERT(datetime,COPTC.TC003) AS 订单日期,
COPTD.TD016 订单状态,COPTD.TD004 AS 品号 FROM COPTD
INNER JOIN COPTC ON COPTD.TD001 = COPTC.TC001 AND COPTD.TD002 = COPTC.TC002
left JOIN COPMA ON COPTC.TC004 = COPMA.MA001
WHERE 1=1 and
COPTC.TC003 >='20140701' AND COPTC.TC003 <='20140716'
string sqlStr = " Select MA002,TD001,TD002,TD003,TD004,TD005,TD006,TD008,TD009,TD011,TD012,TD013,TC003 "
+ " from COPTD left join COPTC ON TC001 = TD001 AND TC002 = TD002 "
+ " left join COPMA ON MA001 = TC004 "
+ " Where MA002 like '%" + MA002
+ "%' AND TD004 like '%" + TD004
+ "%' AND TD005 like '%" + TD005
+ "%' AND TD006 like '%" + TD006
+ "%'";
var order =
erp.Database.SqlQuery<COPMA_COPTC_COPTD>(sqlStr);
var bbb = (from tc in erp.COPTC
join td in erp.COPTD on tc.TC001 + tc.TC002 equals td.TD001 + td.TD002
join ma in erp.COPMA on tc.TC004 equals ma.MA001
select new
{
ma.MA002,
tc.TC003,
tc.TC004,
tc.TC005,
td.TD003,
td.TD001,
td.TD002,
td.TD006,
td.TD007
}).Take(30);
var ccc = (from tc in erp.COPTC
select new
{
tc.TC001,
tc.TC002,
tc.TC003,
tc.TC004,
aaa = from td in erp.COPTD
where td.TD001 == tc.TC001 && td.TD002 == tc.TC002
select new
{
td.TD001,
td.TD002,
td.TD003,
td.TD004
},
bbb = from ma in erp.COPMA
where ma.MA001 == tc.TC004
select new
{
ma.MA002
}
}).Take(30);
Convert.ToDateTime(cc.TC003) > Convert.ToDateTime("2014-07-01")