| | |
|---|
| | | public DataTable getInfodatanow(string hsoucreID) |
|---|
| | | { |
|---|
| | | SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); |
|---|
| | | string sql = $" select HMacAddr, runStu, countAll from Gy_Source t1 left join HX_LIOTsys..Info_data_now t2 on t1.HMacAddr = t2.hid where t1.hitemid={hsoucreID}"; |
|---|
| | | string sql = $" select HMacAddr, isnull(runStu,'')runStu, isnull(countAll,0)countAll from Gy_Source t1 left join HX_LIOTsys..Info_data_now t2 on t1.HMacAddr = t2.hid where t1.hitemid={hsoucreID}"; |
|---|
| | | DataTable dt = oCn.RunProcReturn(sql, "dt").Tables[0]; |
|---|
| | | return dt; |
|---|
| | | } |
|---|
