| | |
|---|
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
|---|
| | | if (sWhere == null || sWhere.Equals("")) |
|---|
| | | { |
|---|
| | | ds = oCN.RunProcReturn("Select HItemID,HNumber ,HName from Gy_ClassTimePrjGroup where HStopflag=0 Order by HItemID ", "Gy_ClassTimePrjGroup"); |
|---|
| | | ds = oCN.RunProcReturn("Select HItemID,HNumber ,HName from Gy_ClassTimePrj where HStopflag=0 Order by HItemID ", "Gy_ClassTimePrj"); |
|---|
| | | } |
|---|
| | | else |
|---|
| | | { |
|---|
| | | string sql1 = "Select HItemID,HNumber ,HName from Gy_ClassTimePrjGroup where HStopflag=0 "; |
|---|
| | | string sql1 = "Select HItemID,HNumber ,HName from Gy_ClassTimePrj where HStopflag=0 "; |
|---|
| | | string sql = sql1 + sWhere; |
|---|
| | | ds = oCN.RunProcReturn(sql, "Gy_ClassTimePrjGroup"); |
|---|
| | | ds = oCN.RunProcReturn(sql, "Gy_ClassTimePrj"); |
|---|
| | | } |
|---|
| | | |
|---|
| | | //ds = webserver.GetUnitList(sWhere, ref DBUtility.ClsPub.sErrInfo); |
|---|
