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