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);
}
