public static SuKienCollection SelectUnXoa(SqlConnection con, string xoa, string top) { var List = new SuKienCollection(); var obj = new SqlParameter[2]; if (!string.IsNullOrEmpty(xoa)) { obj[0] = new SqlParameter("xoa", xoa); } else { obj[0] = new SqlParameter("xoa", DBNull.Value); } if (!string.IsNullOrEmpty(top)) { obj[1] = new SqlParameter("top", top); } else { obj[1] = new SqlParameter("top", DBNull.Value); } using (IDataReader rd = SqlHelper.ExecuteReader(con, CommandType.StoredProcedure, "sp_tblSpaMgr_SuKien_Select_SelectUnXoa_linhnx", obj)) { while (rd.Read()) { List.Add(getFromReader(rd)); } } return(List); }
public static SuKienCollection SelectAll() { var List = new SuKienCollection(); using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblSpaMgr_SuKien_Select_SelectAll_linhnx")) { while (rd.Read()) { List.Add(getFromReader(rd)); } } return(List); }
public static SuKienCollection SelectPhieuDichVuForCalendarChupAnh(SqlConnection con, DateTime tuNgay, DateTime denNgay, string NhanVien_Id) { var List = new SuKienCollection(); var obj = new SqlParameter[3]; if (denNgay > DateTime.MinValue) { obj[0] = new SqlParameter("denNgay", denNgay); } else { obj[0] = new SqlParameter("denNgay", DBNull.Value); } if (tuNgay > DateTime.MinValue) { obj[1] = new SqlParameter("tuNgay", tuNgay); } else { obj[1] = new SqlParameter("tuNgay", DBNull.Value); } if (!string.IsNullOrEmpty(NhanVien_Id)) { obj[2] = new SqlParameter("NhanVien_Id", NhanVien_Id); } else { obj[2] = new SqlParameter("NhanVien_Id", DBNull.Value); } using (IDataReader rd = SqlHelper.ExecuteReader(con, CommandType.StoredProcedure, "sp_tblSpaMgr_SuKien_Select_SelectPhieuDichVuForCalendarChupAnh_linhnx", obj)) { while (rd.Read()) { List.Add(getFromReader(rd)); } } return(List); }