public static String CurrentSiteID
{
get
{
String BU = (String)DBHelper.GetSingle("select SUBSTRING(Dept1,CHARINDEX('-',Dept1) + 1,CHARINDEX('-',SUBSTRING(Dept1,CHARINDEX('-',Dept1) + 1,LEN(Dept1))) - 1) as BU from dbo.Master_Data where Prid = '" + CurrentUserAccount + "'");
return (from site in GetSite(null).AsEnumerable() where site["BU"].Equals(BU) select site).First()["ID"].ToString();
}
}红色部分的SQL语句为啥要把SELECT倒着写呢?
太奇怪了.
高手解释下吧.立即给分.谢谢..
{
get
{
String BU = (String)DBHelper.GetSingle("select SUBSTRING(Dept1,CHARINDEX('-',Dept1) + 1,CHARINDEX('-',SUBSTRING(Dept1,CHARINDEX('-',Dept1) + 1,LEN(Dept1))) - 1) as BU from dbo.Master_Data where Prid = '" + CurrentUserAccount + "'");
return (from site in GetSite(null).AsEnumerable() where site["BU"].Equals(BU) select site).First()["ID"].ToString();
}
}红色部分的SQL语句为啥要把SELECT倒着写呢?
太奇怪了.
高手解释下吧.立即给分.谢谢..
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货