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);
}
private void btn_Calibrate3_Click(object sender, RoutedEventArgs e)
{
wsCalibration item = dg_Not.SelectedItem as wsCalibration;
cwnd_RunCalibration w = new cwnd_RunCalibration((int)item.ID);
w.Show();
w.Closed += new EventHandler(w_Closed);
}
//-------- 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);
}
private void btn_Calibrate1_Click(object sender, RoutedEventArgs e)
{
wsCalibration item = dg_NextWeek.SelectedItem as wsCalibration;
//Parent p = (sender as Button).Parent;
cwnd_RunCalibration w = new cwnd_RunCalibration((int)item.ID);
w.Show();
w.Closed += new EventHandler(w_Closed);
}
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);
}
