/// <summary> /// 查询出未卸货的车辆数据 /// </summary> /// <returns>返回数据源</returns> public static DataSet SelectAll(string select, string WhereSql) { DataBase db = new DataBase(); DataBaseVisitor visitor = new Dal.CarMain.MainDal(); DataSet ds = new DataSet(); try { switch (select) { //1号伸缩链板机的未卸货排队车辆 case "1": ds = db.ReturnDataSet(visitor, "Selectstate1_1", "V_Bus_RegistrationInfo", WhereSql); break; //2号伸缩链板机的未卸货排队车辆 case "2": ds = db.ReturnDataSet(visitor, "Selectstate1_2", "V_Bus_RegistrationInfo", WhereSql); break; } } catch (Exception ex) { throw ex; } finally { db.Dispose(); } return ds; }
/// <summary> /// 查询正在卸烟的车辆数据 /// </summary> /// <returns>返回数据源</returns> public static DataSet GetInfo(string select) { DataBase db = new DataBase(); DataBaseVisitor visitor = new Dal.CarMain.MainDal(); DataSet ds = new DataSet(); try { switch (select) { //1号伸缩链板机正在卸烟的车辆信息 case "1": ds = db.ReturnDataSet(visitor, "Selectstate2_1", "V_Bus_RegistrationInfo"); break; //2号伸缩链板机正在卸烟的车辆信息 case "2": ds = db.ReturnDataSet(visitor, "Selectstate2_2", "V_Bus_RegistrationInfo"); break; } } catch (Exception ex) { throw ex; } finally { db.Dispose(); } return ds; }
/// <summary> /// 查询出未递交货运单所有的车辆数据和未卸货的车辆总数 /// </summary> /// <returns>返回数据源</returns> public static DataSet SelectAllCar(string select) { DataBase db = new DataBase(); DataBaseVisitor visitor = new Dal.CarMain.MainDal(); DataSet ds = new DataSet(); try { switch (select) { // 查询出未递交货运单所有的车辆数据 case "0": ds = db.ReturnDataSet(visitor, "Selectstate0", "V_Bus_RegistrationInfo"); break; //未卸货的车辆总数 case "1": ds = db.ReturnDataSet(visitor, "Selectstate0+1", "V_Bus_RegistrationInfo"); break; } } catch (Exception ex) { throw ex; } finally { db.Dispose(); } return ds; }