C# (CSharp) global::System.Data.EntityClient.EntityParameter 예제들

예제 #1

파일: TutorialDataSourceModel.TutorialObjectContext.cs 프로젝트: simple555a/niko78csharp

 /// <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();
 }

예제 #2

파일: TutorialDataSourceModel.TutorialObjectContext.cs 프로젝트: AymanShawky/niko78csharp

 /// <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();
 }