public void IssueSernos(
int documentNumber,
string docType,
int docLine,
string partNumber,
int createdBy,
int quantity,
int?firstSernosNumber)
{
var connection = new OracleConnection(ConnectionStrings.ManagedConnectionString());
var cmd = new OracleCommand("SERNOS_PACK_V2.ISSUE_SERNOS", connection)
{
CommandType = CommandType.StoredProcedure
};
var documentNumberParameter = new OracleParameter("p_document_number", OracleDbType.Int32)
{
Direction = ParameterDirection.Input,
Value = documentNumber
};
cmd.Parameters.Add(documentNumberParameter);
var documentTypeParameter = new OracleParameter("p_doc_type", OracleDbType.Varchar2)
{
Direction = ParameterDirection.Input,
Value = docType,
Size = 2
};
cmd.Parameters.Add(documentTypeParameter);
var docLineParameter = new OracleParameter("p_doc_line", OracleDbType.Int32)
{
Direction = ParameterDirection.Input,
Value = docLine
};
cmd.Parameters.Add(docLineParameter);
var partNumberParameter = new OracleParameter("p_part_number", OracleDbType.Varchar2)
{
Direction = ParameterDirection.Input,
Size = 50,
Value = partNumber
};
cmd.Parameters.Add(partNumberParameter);
var raisedByParameter = new OracleParameter("p_raised_by", OracleDbType.Int32)
{
Direction = ParameterDirection.Input,
Value = createdBy
};
cmd.Parameters.Add(raisedByParameter);
var quantityParameter = new OracleParameter("p_qty", OracleDbType.Int32)
{
Direction = ParameterDirection.Input,
Value = quantity
};
cmd.Parameters.Add(quantityParameter);
var firstSernosNumberParameter = new OracleParameter("p_first_sernos_number", OracleDbType.Int32)
{
Direction = ParameterDirection.InputOutput,
Value = firstSernosNumber
};
cmd.Parameters.Add(firstSernosNumberParameter);
connection.Open();
cmd.ExecuteNonQuery();
connection.Close();
}
public bool BuildSernos(
int documentNumber,
string docType,
string partNumber,
int docLine,
int fromSerial,
int toSerial,
int userNumber)
{
var connection = new OracleConnection(ConnectionStrings.ManagedConnectionString());
var cmd = new OracleCommand("SERNOS_PACK_V2.BUILD_SERNOS_WRAPPER", connection)
{
CommandType = CommandType.StoredProcedure
};
var result = new OracleParameter(null, OracleDbType.Int32)
{
Direction = ParameterDirection.ReturnValue
};
cmd.Parameters.Add(result);
var documentNumberParameter = new OracleParameter("p_document_number", OracleDbType.Int32)
{
Direction = ParameterDirection.Input,
Value = documentNumber
};
cmd.Parameters.Add(documentNumberParameter);
var documentTypeParameter = new OracleParameter("p_doc_type", OracleDbType.Varchar2)
{
Direction = ParameterDirection.Input,
Value = docType,
Size = 2
};
cmd.Parameters.Add(documentTypeParameter);
var partNumberParameter = new OracleParameter("p_part_number", OracleDbType.Varchar2)
{
Direction = ParameterDirection.Input,
Value = partNumber
};
cmd.Parameters.Add(partNumberParameter);
var firstSernosParameter = new OracleParameter("p_first_sernos", OracleDbType.Int32)
{
Direction = ParameterDirection.Input,
Size = 50,
Value = fromSerial
};
cmd.Parameters.Add(firstSernosParameter);
var lastSernosParameter = new OracleParameter("p_last_sernos", OracleDbType.Int32)
{
Direction = ParameterDirection.Input,
Value = toSerial
};
cmd.Parameters.Add(lastSernosParameter);
var raisedByParameter = new OracleParameter("p_raised_by", OracleDbType.Int32)
{
Direction = ParameterDirection.Input,
Value = userNumber
};
cmd.Parameters.Add(raisedByParameter);
connection.Open();
cmd.ExecuteNonQuery();
connection.Close();
return(int.Parse(result.Value.ToString()) == 1);
}
public bool PrintLabels(
string fileName,
string printer,
int qty,
string template,
string data,
ref string message)
{
var connection = new OracleConnection(ConnectionStrings.ManagedConnectionString());
var cmd = new OracleCommand("BARTENDER.PRINT_LABELS_WRAPPER", connection)
{
CommandType = CommandType.StoredProcedure
};
var result = new OracleParameter(null, OracleDbType.Int32)
{
Direction = ParameterDirection.ReturnValue,
Size = 2000
};
cmd.Parameters.Add(result);
cmd.Parameters.Add(new OracleParameter("p_filename", OracleDbType.Varchar2)
{
Direction = ParameterDirection.Input,
Size = 50,
Value = fileName
});
cmd.Parameters.Add(new OracleParameter("p_printer", OracleDbType.Varchar2)
{
Direction = ParameterDirection.Input,
Size = 100,
Value = printer
});
cmd.Parameters.Add(new OracleParameter("p_qty", OracleDbType.Int32)
{
Direction = ParameterDirection.Input,
Value = qty
});
cmd.Parameters.Add(new OracleParameter("p_template", OracleDbType.Varchar2)
{
Direction = ParameterDirection.Input,
Size = 100,
Value = template
});
cmd.Parameters.Add(new OracleParameter("p_data", OracleDbType.Varchar2)
{
Direction = ParameterDirection.Input,
Size = 4000,
Value = data
});
cmd.Parameters.Add(new OracleParameter("p_message", OracleDbType.Varchar2)
{
Direction = ParameterDirection.InputOutput,
Size = 500,
Value = message
});
connection.Open();
cmd.ExecuteNonQuery();
connection.Close();
return(result.Value.ToString() == "1");
}
public OracleConnection GetConnection()
{
return(new OracleConnection(ConnectionStrings.ManagedConnectionString()));
}
public string ReissueSerialNumber(
string sernosGroup,
int serialNumber,
int?newSerialNumber,
string articleNumber,
string newArticleNumber,
string comments,
int?createdBy)
{
var connection = new OracleConnection(ConnectionStrings.ManagedConnectionString());
var cmd = new OracleCommand("SERNOS_RENUM_PACK.REISSUE_SERNOS", connection)
{
CommandType = CommandType.StoredProcedure
};
var result = new OracleParameter(null, OracleDbType.Varchar2)
{
Direction = ParameterDirection.ReturnValue,
Size = 200
};
cmd.Parameters.Add(result);
var sernosGroupParameter = new OracleParameter("p_sernos_group", OracleDbType.Varchar2)
{
Direction = ParameterDirection.Input,
Size = 10,
Value = sernosGroup
};
cmd.Parameters.Add(sernosGroupParameter);
var serialNumberParameter = new OracleParameter("p_orig_serial_number", OracleDbType.Decimal)
{
Direction = ParameterDirection.Input,
Value = serialNumber
};
cmd.Parameters.Add(serialNumberParameter);
var newSerialNumberParameter = new OracleParameter("p_new_serial_number", OracleDbType.Decimal)
{
Direction = ParameterDirection.InputOutput,
Value = newSerialNumber
};
cmd.Parameters.Add(newSerialNumberParameter);
var articleNumberParameter = new OracleParameter("p_orig_article_number", OracleDbType.Varchar2)
{
Direction = ParameterDirection.Input,
Size = 14,
Value = articleNumber
};
cmd.Parameters.Add(articleNumberParameter);
var newArticleNumberParameter = new OracleParameter("p_new_article_number", OracleDbType.Varchar2)
{
Direction = ParameterDirection.Input,
Size = 14,
Value = newArticleNumber
};
cmd.Parameters.Add(newArticleNumberParameter);
var commentsParameter = new OracleParameter("p_comments", OracleDbType.Varchar2)
{
Direction = ParameterDirection.Input,
Size = 200,
Value = comments
};
cmd.Parameters.Add(commentsParameter);
var createdByParameter = new OracleParameter("p_user_number", OracleDbType.Decimal)
{
Direction = ParameterDirection.Input,
Value = createdBy
};
cmd.Parameters.Add(createdByParameter);
connection.Open();
cmd.ExecuteNonQuery();
connection.Close();
return(result.Value.ToString());
}
