49 lines
1.9 KiB
C#
49 lines
1.9 KiB
C#
|
using System;
|
|||
|
|
using System.Data;
|
|||
|
|
using System.Data.SqlClient;
|
|||
|
|
|
|||
|
|
namespace DASFactoryDb.DAS
|
|||
|
|
{
|
|||
|
|
public static class DAS
|
|||
|
|
{
|
|||
|
|
public static int InsertDASSimple(string serialNumber,
|
|||
|
|
string firmwareVersion,
|
|||
|
|
string connectString)
|
|||
|
|
{
|
|||
|
|
using (var cmd = DbWrapper.GetDASFactoryCommand())
|
|||
|
|
{
|
|||
|
|
try
|
|||
|
|
{
|
|||
|
|
cmd.CommandType = CommandType.StoredProcedure;
|
|||
|
|
cmd.CommandText = "sp_IDASCommunicationTableSimpleInsert";
|
|||
|
|
cmd.Parameters.Add(new SqlParameter("@SerialNumber", SqlDbType.NVarChar, 50)
|
|||
|
|
{ Value = serialNumber });
|
|||
|
|
cmd.Parameters.Add(new SqlParameter("@FirmwareVersion", SqlDbType.NVarChar, 50)
|
|||
|
|
{ Value = firmwareVersion });
|
|||
|
|
cmd.Parameters.Add(new SqlParameter("ConnectString", SqlDbType.NVarChar, 255)
|
|||
|
|
{ Value = connectString });
|
|||
|
|
|
|||
|
|
var errorNumber = new SqlParameter("@errorNumber", SqlDbType.Int) { Direction = ParameterDirection.Output };
|
|||
|
|
cmd.Parameters.Add(errorNumber);
|
|||
|
|
|
|||
|
|
var errorMessage = new SqlParameter("@errorMessage", SqlDbType.NVarChar, 255)
|
|||
|
|
{ Direction = ParameterDirection.Output };
|
|||
|
|
cmd.Parameters.Add(errorMessage);
|
|||
|
|
|
|||
|
|
var newId = new SqlParameter("@new_id", SqlDbType.Int)
|
|||
|
|
{ Direction = ParameterDirection.Output };
|
|||
|
|
cmd.Parameters.Add(newId);
|
|||
|
|
|
|||
|
|
cmd.ExecuteNonQuery();
|
|||
|
|
DbWrapper.ProcessReturn(errorNumber, errorMessage);
|
|||
|
|
return Convert.ToInt32(newId.Value);
|
|||
|
|
}
|
|||
|
|
finally
|
|||
|
|
{
|
|||
|
|
cmd.Connection.Dispose();
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|