/// <summary>
/// 执行返回值为标量的储存过程
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="functionName"></param>
/// <param name="parameters"></param>
/// <returns></returns>
public T ExecuteFunction <T>(string functionName, params System.Data.EntityClient.EntityParameter[] parameters)
{
System.Data.EntityClient.EntityCommand cmd = ((System.Data.EntityClient.EntityConnection)context.Database.Connection).CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;
foreach (var entityParameter in parameters)
{
if ((entityParameter.Direction == ParameterDirection.InputOutput || entityParameter.Direction == ParameterDirection.Input) && (entityParameter.Value == null))
{
//获取参数的值
entityParameter.Value = DBNull.Value;
}
//添加参数
cmd.Parameters.Add(new System.Data.EntityClient.EntityParameter(entityParameter.ParameterName, DbType.Decimal).Value);
}
cmd.Parameters.AddRange(parameters);
cmd.CommandText = functionName;
try
{
if (cmd.Connection.State != ConnectionState.Open)
{
cmd.Connection.Open();
}
var obj = cmd.ExecuteScalar();
return((T)obj);
}
catch (Exception ex)
{
throw;
}
finally
{
cmd.Connection.Close();
}
}
/// <summary>
/// There are no comments for TutorialEntities.AgregarArticulo in the schema.
/// </summary>
public void AgregarArticulo(string PID, string PDESCRIPCION, global::System.Nullable <decimal> PCANT_PALLET_COMPLETO)
{
if (this.Connection.State != System.Data.ConnectionState.Open)
{
this.Connection.Open();
}
System.Data.EntityClient.EntityCommand command = new System.Data.EntityClient.EntityCommand();
command.CommandType = System.Data.CommandType.StoredProcedure;
command.CommandText = @"TutorialObjectContext.AgregarArticulo";
command.Connection = (System.Data.EntityClient.EntityConnection) this.Connection;
global::System.Data.EntityClient.EntityParameter PIDParameter = new global::System.Data.EntityClient.EntityParameter("PID", System.Data.DbType.String);
if (PID != null)
{
PIDParameter.Value = PID;
}
command.Parameters.Add(PIDParameter);
global::System.Data.EntityClient.EntityParameter PDESCRIPCIONParameter = new global::System.Data.EntityClient.EntityParameter("PDESCRIPCION", System.Data.DbType.String);
if (PDESCRIPCION != null)
{
PDESCRIPCIONParameter.Value = PDESCRIPCION;
}
command.Parameters.Add(PDESCRIPCIONParameter);
global::System.Data.EntityClient.EntityParameter PCANT_PALLET_COMPLETOParameter = new global::System.Data.EntityClient.EntityParameter("PCANT_PALLET_COMPLETO", System.Data.DbType.Decimal);
if (PCANT_PALLET_COMPLETO.HasValue)
{
PCANT_PALLET_COMPLETOParameter.Value = PCANT_PALLET_COMPLETO;
}
command.Parameters.Add(PCANT_PALLET_COMPLETOParameter);
command.ExecuteNonQuery();
}
/// <summary>
/// There are no comments for TutorialEntities.AgregarArticulo in the schema.
/// </summary>
public void AgregarArticulo(string PID, string PDESCRIPCION, global::System.Nullable<decimal> PCANT_PALLET_COMPLETO)
{
if (this.Connection.State != System.Data.ConnectionState.Open)
this.Connection.Open();
System.Data.EntityClient.EntityCommand command = new System.Data.EntityClient.EntityCommand();
command.CommandType = System.Data.CommandType.StoredProcedure;
command.CommandText = @"TutorialObjectContext.AgregarArticulo";
command.Connection = (System.Data.EntityClient.EntityConnection)this.Connection;
global::System.Data.EntityClient.EntityParameter PIDParameter = new global::System.Data.EntityClient.EntityParameter("PID", System.Data.DbType.String);
if (PID != null)
PIDParameter.Value = PID;
command.Parameters.Add(PIDParameter);
global::System.Data.EntityClient.EntityParameter PDESCRIPCIONParameter = new global::System.Data.EntityClient.EntityParameter("PDESCRIPCION", System.Data.DbType.String);
if (PDESCRIPCION != null)
PDESCRIPCIONParameter.Value = PDESCRIPCION;
command.Parameters.Add(PDESCRIPCIONParameter);
global::System.Data.EntityClient.EntityParameter PCANT_PALLET_COMPLETOParameter = new global::System.Data.EntityClient.EntityParameter("PCANT_PALLET_COMPLETO", System.Data.DbType.Decimal);
if (PCANT_PALLET_COMPLETO.HasValue)
PCANT_PALLET_COMPLETOParameter.Value = PCANT_PALLET_COMPLETO;
command.Parameters.Add(PCANT_PALLET_COMPLETOParameter);
command.ExecuteNonQuery();
}
