public int ws_insertCalibration(wsCalibration c, out string OpStatus)
{
try
{
OpStatus = "Выполнено";
DeviceDataManager DDM = new DeviceDataManager();
DDM.insertCalibration(c);
return 1;
}
catch (Exception err)
{
OpStatus = err.Message.ToString();
return 0;
}
}
private void OKButton_Click(object sender, RoutedEventArgs e)
{
item = grid_Calibration.DataContext as wsCalibration;
if ((int)(cbox_result.SelectedItem as wsSimpleItem).ID == 1)
item.result = true;
else
item.result = false;
item.typeID = (int)(cbox_type.SelectedItem as wsSimpleItem).ID;
wc.ws_insertCalibrationAsync(item);
}
public List<wsCalibration> selectNextCalibrations() //lp_sel_NextCalibration
{
List<wsCalibration> l = new List<wsCalibration>();
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())
{
wsCalibration t = new wsCalibration();
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"];
l.Add(t);
}
conn.Close();
}
return l;
}
public int insertCalibration(wsCalibration c)//lp_ins_NewCalibration
{
int ret = 0;
// @DevID int -- Устройство
//,@FactDate datetime -- Фактическая дата калибровки
//,@CalibrationTypeID int -- Тип поверки
//,@Result bit -- Результат поверки
//,@DocNo nvarchar(50) = null -- Номер документа
//,@Comments nvarchar(max) = null -- Комментарии
using (SqlConnection conn = new SqlConnection(Configuration.ConnectionString))
{
SqlCommand cmd = new SqlCommand("lp_ins_NewCalibration");
conn.Open();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ReturnVal", SqlDbType.Int);
cmd.Parameters["@ReturnVal"].Direction = ParameterDirection.ReturnValue;
cmd.Parameters.AddWithValue("@DevID", c.ID);
cmd.Parameters.AddWithValue("@FactDate", c.factDate);
cmd.Parameters.AddWithValue("@CalibrationTypeID", c.typeID);
cmd.Parameters.AddWithValue("@Result", c.result);
cmd.Parameters.AddWithValue("@DocNo", c.docNo);
cmd.Parameters.AddWithValue("@Comments", c.comment);
cmd.ExecuteNonQuery();
ret = (int)cmd.Parameters["@ReturnVal"].Value;
conn.Close();
}
return ret;
}
//-------- CALIBRATION ----------------------------------------------------
public List<wsCalibration> selectDeviceCalibrations(int id) //lp_sel_DeviceCalibration
{
List<wsCalibration> l = new List<wsCalibration>();
using (SqlConnection conn = new SqlConnection(Configuration.ConnectionString))
{
SqlCommand cmd = new SqlCommand("lp_sel_DeviceCalibration");
conn.Open();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@DevID", id);
SqlDataReader Reader = cmd.ExecuteReader();
while (Reader.Read())
{
wsCalibration t = new wsCalibration();
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("TypeName")))
t.typeName = (string)Reader["TypeName"];
if (!Reader.IsDBNull(Reader.GetOrdinal("Result")))
t.result = (bool)Reader["Result"];
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;
}