public object get_equip_2(string equip_no) { DataResult dr = new DataResult(); string sql = "select * from Equip where equip_no=" + equip_no; dr = ServerLib.GetDataTableSQL(sql);//内置接口,执行查询SQL return(dr); }
public object GetDataTableFromSQL() { DataResult dr = new DataResult(); string sql = "select top 1 * from WelcomingSpeech where Type=0 order by ID desc"; dr = ServerLib.GetDataTableSQL(sql);//内置接口,执行查询SQL return(dr); }
public object GetSetParmItem(string equip_no, string set_no) { DataResult dr = new DataResult(); //判断是否为空 if (string.IsNullOrEmpty(equip_no) && string.IsNullOrEmpty(set_no)) { return(ApiCode.Code1003(dr)); } string sql = "select * from setParm where equip_no =" + equip_no + " and set_no=" + set_no; dr = ServerLib.GetDataTableSQL(sql);//内置接口,执行查询SQL return(dr); }