ATUL_v1.Atul_v1Data.FlexFieldUpsert C# (CSharp) Метод

FlexFieldUpsert() публичный Метод

public FlexFieldUpsert ( string TokenName, int IsRequired, long CreatedBy, long AtulProcessID, long AtulSubProcessID, long AtulActivityID, string DefaultTokenValue, string FriendlyName, string ToolTip, int IsParameter ) : bool
TokenName string
IsRequired int
CreatedBy long
AtulProcessID long
AtulSubProcessID long
AtulActivityID long
DefaultTokenValue string
FriendlyName string
ToolTip string
IsParameter int
Результат bool
        public bool FlexFieldUpsert(string TokenName, int IsRequired, long CreatedBy, long? AtulProcessID, long? AtulSubProcessID, long? AtulActivityID, string DefaultTokenValue, string FriendlyName, string ToolTip, int IsParameter)
        {
            if (AtulProcessID == 0)
            {
                AtulProcessID = null;
            }
            if (AtulSubProcessID == 0)
            {
                AtulSubProcessID = null;
            }
            if (AtulActivityID == 0)
            {
                AtulActivityID = null;
            }

            SqlCommand cmd = new SqlCommand("exec dbo.Atul_FlexFieldUpsert_sp @TokenName, @IsRequired, @CreatedBy, @AtulProcessID, @AtulSubProcessID, @AtulActivityID, @DefaultTokenValue, @FriendlyName, @ToolTip, @IsParameter", this._connection);
            cmd.Parameters.Add(new SqlParameter("@TokenName", TokenName));
            cmd.Parameters.Add(new SqlParameter("@IsRequired", IsRequired));
            cmd.Parameters.Add(new SqlParameter("@CreatedBy", CreatedBy));
            cmd.Parameters.Add(new SqlParameter("@AtulProcessID", AtulProcessID));
            cmd.Parameters.Add(new SqlParameter("@AtulSubProcessID", AtulSubProcessID));
            cmd.Parameters.Add(new SqlParameter("@AtulActivityID", AtulActivityID));
            cmd.Parameters.Add(new SqlParameter("@DefaultTokenValue", DefaultTokenValue));
            cmd.Parameters.Add(new SqlParameter("@FriendlyName", FriendlyName));
            cmd.Parameters.Add(new SqlParameter("@ToolTip", ToolTip));
            cmd.Parameters.Add(new SqlParameter("@IsParameter", IsParameter));
            bool success = Convert.ToBoolean(cmd.ExecuteNonQuery());
            return success;
        }

Usage Example

Пример #1
0
 /// <summary>
 /// Upsert the flexfield.
 /// </summary>
 /// <param name="TokenName">Name of the token.</param>
 /// <param name="IsRequired">The is required.</param>
 /// <param name="CreatedBy">The created by.</param>
 /// <param name="AtulProcessID">The atul process ID.</param>
 /// <param name="AtulSubProcessID">The atul sub process ID.</param>
 /// <param name="AtulActivityID">The atul activity ID.</param>
 /// <param name="DefaultTokenValue">The default token value.</param>
 /// <param name="FriendlyName">Name of the friendly.</param>
 /// <param name="ToolTip">The tool tip.</param>
 /// <param name="IsParameter">The is parameter.</param>
 /// <returns></returns>
 public bool FlexFieldUpsert(string TokenName, int IsRequired, long CreatedBy, long? AtulProcessID, long? AtulSubProcessID, long? AtulActivityID, string DefaultTokenValue, string FriendlyName, string ToolTip, int IsParameter)
 {
     bool success = false;
     Atul_v1Data adb = new Atul_v1Data();
     success = adb.FlexFieldUpsert(TokenName, IsRequired, CreatedBy, AtulProcessID, AtulSubProcessID, AtulActivityID, DefaultTokenValue, FriendlyName, ToolTip, IsParameter);
     return success;
 }
Atul_v1Data