ATUL_v1.Atul_v1Data.UpdateActivity C# (CSharp) 메소드

UpdateActivity() 공개 메소드

public UpdateActivity ( long AtulActivityID, long AtulSubProcessID, string ActivityDescription, string ActivitySummary, string ActivityProcedure, int AtulActivitySortOrder, int ModifiedBy, int OwnedBy ) : bool
AtulActivityID long
AtulSubProcessID long
ActivityDescription string
ActivitySummary string
ActivityProcedure string
AtulActivitySortOrder int
ModifiedBy int
OwnedBy int
리턴 bool
        public bool UpdateActivity(long AtulActivityID, long AtulSubProcessID, string ActivityDescription, string ActivitySummary, string ActivityProcedure, int AtulActivitySortOrder, int ModifiedBy, int OwnedBy)
        {
            SqlCommand cmd = new SqlCommand("exec dbo.Atul_ActivityUpdate_sp @AtulActivityID, @AtulSubProcessID, @ActivityDescription, @ActivitySummary, @ActivityProcedure, @AtulActivitySortOrder, @ModifiedBy, @OwnedBy", this._connection);
            cmd.Parameters.Add(new SqlParameter("@AtulActivityID", AtulActivityID));
            cmd.Parameters.Add(new SqlParameter("@AtulSubProcessID", AtulSubProcessID));
            cmd.Parameters.Add(new SqlParameter("@ActivityDescription", ActivityDescription));
            cmd.Parameters.Add(new SqlParameter("@ActivitySummary", ActivitySummary));
            cmd.Parameters.Add(new SqlParameter("@ActivityProcedure", ActivityProcedure));
            cmd.Parameters.Add(new SqlParameter("@AtulActivitySortOrder", AtulActivitySortOrder));
            cmd.Parameters.Add(new SqlParameter("@ModifiedBy", ModifiedBy));
            cmd.Parameters.Add(new SqlParameter("@OwnedBy", OwnedBy));

            bool success = Convert.ToBoolean(cmd.ExecuteNonQuery());
            return success;
        }

Usage Example

예제 #1
0
 public bool UpdateActivity(long AtulActivityID, long AtulSubProcessID, string ActivityDescription, string ActivitySummary, string ActivityProcedure, int AtulActivitySortOrder, int ModifiedBy, int OwnedBy)
 {
     bool success = false;
     Atul_v1Data adb = new Atul_v1Data();
     success = adb.UpdateActivity(AtulActivityID, AtulSubProcessID, ActivityDescription, ActivitySummary, ActivityProcedure, AtulActivitySortOrder, ModifiedBy, OwnedBy);
     return success;
 }
Atul_v1Data