//-------- REPAIRS & TO ----------------------------------------------------
public List <wsMaintenance> selectDeviceMaintenances(int id) //lp_sel_DeviceCalibration
{
List <wsMaintenance> l = new List <wsMaintenance>();
using (SqlConnection conn = new SqlConnection(Configuration.ConnectionString))
{
SqlCommand cmd = new SqlCommand("lp_sel_DeviceMaintenance");
conn.Open();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@DevID", id);
SqlDataReader Reader = cmd.ExecuteReader();
while (Reader.Read())
{
wsMaintenance t = new wsMaintenance();
t.ID = id;
if (!Reader.IsDBNull(Reader.GetOrdinal("FactDate")))
{
t.factDate = (DateTime)Reader["FactDate"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("PlannedDate")))
{
t.plannedDate = (DateTime)Reader["PlannedDate"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("FName")))
{
t.factName = (string)Reader["FName"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("PName")))
{
t.plannedName = (string)Reader["PName"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("DocNo")))
{
t.docNo = (string)Reader["DocNo"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("Comments")))
{
t.comment = (string)Reader["Comments"];
}
l.Add(t);
}
conn.Close();
}
return(l);
}
public List <wsMaintenance> selectNextMaintenances() //lp_sel_NextCalibration
{
List <wsMaintenance> l = new List <wsMaintenance>();
using (SqlConnection conn = new SqlConnection(Configuration.ConnectionString))
{
SqlCommand cmd = new SqlCommand("lp_sel_NextCalibration");
conn.Open();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@FuturePeriod", 7); //7 дней
SqlDataReader Reader = cmd.ExecuteReader();
while (Reader.Read())
{
wsMaintenance t = new wsMaintenance();
if (!Reader.IsDBNull(Reader.GetOrdinal("DevID")))
{
t.ID = (int)Reader["DevID"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("LongDescrRU")))
{
t.Description = (string)Reader["LongDescrRU"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("NextDate")))
{
t.plannedDate = (DateTime)Reader["NextDate"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("PName")))
{
t.plannedName = (string)Reader["PName"];
}
l.Add(t);
}
conn.Close();
}
return(l);
}
