| | |
|---|
| | | string sWhere = tSQL; //ç¹æ®æ¡ä»¶(æ¥æéå¶ï¼é¨é¨éå¶) |
|---|
| | | DBUtility.Xt_BaseBillFun.Sub_SQLWhere(ref sWhere); |
|---|
| | | |
|---|
| | | ////è¿æ»¤æ¡ä»¶ |
|---|
| | | //if (frmCondition.SqlStr.Trim().Length == 0) |
|---|
| | | // return; |
|---|
| | | frmCondition.SqlStr = "select * from " + ViewName + " where 1=1 "; |
|---|
| | | //è¿æ»¤æ¡ä»¶ |
|---|
| | | if (frmCondition.SqlStr.Trim().Length == 0) |
|---|
| | | { |
|---|
| | | frmCondition.SqlStr = "select top(1000) * from " + ViewName + " where 1=1 "; |
|---|
| | | } |
|---|
| | | |
|---|
| | | sSql = frmCondition.SqlStr + sWhere ; |
|---|
| | | |
|---|
| | | |
|---|
| | | sSql = sSql.Replace("AND ä½åºäºº=''", ""); |
|---|
| | | sSql = sSql.Replace("Top 10", "top(1000)"); |
|---|
| | | |
|---|
| | | // |
|---|
| | | DSet = SubCn.RunProcReturn(sSql, ViewName, ref DBUtility.ClsPub.sExeReturnInfo); |
|---|
