62,041
社区成员
发帖
与我相关
我的任务
分享
public ActionResult Mhcx(string searchContent)
{
int count = 200;
int zt = 0;
var sj = db.Database.SqlQuery<mhcx>(@"select top 200 a.ItemCode,b.U_neu_sbrand,b.ItemName,b.FrgnName ,COUNT(a.ItemCode) sl from inv1 a
left join OITM b on a.ItemCode =b.ItemCode
where DocDate>'2015-01-01' and b.U_TT_Owner !='105' and a.ItemCode not like 'D%' and a.ItemCode not like 'W%'
group by a.ItemCode ,b.U_neu_sbrand,b.ItemName,b.FrgnName
order by newid() desc").ToList();
if (!string.IsNullOrEmpty(searchContent))
{
sj = db.Database.SqlQuery<mhcx>("exec zty_ss_mhcx '" + searchContent + "'").ToList();
var count1 = db.Database.SqlQuery<mhcxsum>("exec zty_ss_mhcxsum '" + searchContent + "'").ToList();
count = count1[0].mhcxsum1;
zt = 1;
}
return View("MySearch", new { zt = zt, count = count, listmsc = sj });
}