public static UltrasonicControlProductModels Do(int id)
{
UltrasonicControlProductModels m = new UltrasonicControlProductModels();
string query = "SELECT ,[Alloy],[DeliveryStatus],[NormativeDocument],[Gang],[ProductCodeNumber],[NumberPacket],[Standart]"
+ " FROM [StoredBase].[dbo].[ProtocolsTable]";
return(m);
}
public static IEnumerable <UltrasonicControlProductModels> HeaderProtocol(int id, long numberProtocol, DateTime dteTme, int count, string Operator)
{
List <UltrasonicControlProductModels> res = new List <UltrasonicControlProductModels>();
string queryString = "SELECT [Alloy],[DeliveryStatus],[NormativeDocument],[Gang]"
+ ",[ProductCodeNumber],[NumberPacket],[Standart]"
+ ", ProtocolNumber"
+ " FROM [ProtocolsTable]"
+ "WHERE [ID]= @id"
;
using (SqlConnection connection = new SqlConnection(Properties.Settings.Default.StoredBaseConnectionString))
{
SqlCommand command = new SqlCommand(queryString, connection);
command.Parameters.Add("@id", SqlDbType.Int);
command.Parameters["@id"].Value = id;
command.Connection.Open();
SqlDataReader reader = command.ExecuteReader();
try
{
if (reader.Read())
{
UltrasonicControlProductModels t = new UltrasonicControlProductModels();
t.Alloy = (string)reader[0];
t.DeliveryStatus = (string)reader[1];
t.NormativeDocument = (string)reader[2];
t.Gang = (string)reader[3];
t.ProductCodeNumber = (string)reader[4];
t.NumberPacket = (string)reader[5];
t.Standart = (string)reader[6];
numberProtocol = (int)((reader[7] is DBNull) ? 0 : reader[7]);
t.Count = count;
t.TteTme = dteTme;
t.Operator = Operator;
command.Connection.Close();
//(SqlConnection connection, int NumberProtocol, DateTime date_time, int ID)
numberProtocol = GetProtocolNumber(connection, numberProtocol, dteTme, id);
t.NumberProtocol = numberProtocol.ToString();
res.Add(t);
}
}
finally
{
reader.Close();
}
}
return(res);
}
