> For the complete documentation index, see [llms.txt](https://youngtae.gitbook.io/gst_platform/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://youngtae.gitbook.io/gst_platform/library/parameterbuilder.md).

# ParameterBuilder

## Methods

### Append

* Parameters
  * `DataRow dataRow` : 값을 참조할 DataRow 객체
  * `string fieldName` : DataRow의 ColumnName (이면서 GetParameter 메서드에서 참조할 Key Field)
  * `string value` : 값
* Returns
  * `ParameterBuilder` : 메서드를 호출했던 자신 객체 반환

```csharp
public ParameterBuilder Append(DataRow dataRow, string fieldName);

public ParameterBuilder Append(DataRow dataRow, string fieldName, char symbol);

public ParameterBuilder Append(string fieldName, string value);

public ParameterBuilder Append(string fieldName, string value, char symbol);
```

### GetParameter

* Parameters
  * `string fieldName` : Append 메서드에서 등록했던 Key Field
* Returns
  * `string` : 파싱된 문자열 값

```csharp
public string GetParameter(string fieldName);
```

### GetCount

* Parameters
  * `string fieldName` : Append 메서드에서 등록했던 Key Field
* Returns
  * `int` : 등록된 파라미터의 개수

```csharp
public int GetCount(string fieldName);
```

## 예시

```csharp
private bool ExecuteSave(string workType)
{
    ParameterBuilder paramBuilder = new ParameterBuilder();
    
    DataTable source = BindingData(grdDefault);
    if (source == null)
				return false;
				
		foreach (DataRow row in source.Rows)
		{
				// DataRow로부터 값을 자동으로 처리
				paramBuilder.Append(row, "row_status");
				paramBuilder.Append(row, "type");
				paramBuilder.Append(row, "date");
				paramBuilder.Append(row, "apply_date");
				paramBuilder.Append(row, "descriptions");
				
				// DataRow의 값을 직접 가공하여 처리
				DateTime.TryParse(row.GetValue("start_time")?.ToString(), out DateTime startTime);
				DateTime.TryParse(row.GetValue("end_time")?.ToString(), out DateTime endTime);
				paramBuilder.Append("start_time", startTime.ToString("HH:mm:ss"));
				paramBuilder.Append("end_time", startTime.ToString("HH:mm:ss"));
		}

		try
		{
				sav_work_calender procInfo = new sav_work_calender();
				procInfo.AddParamData(
				workType,
				resourceType.ToString().ToLower(),
				paramBuilder.GetParameter("row_status"),
				paramBuilder.GetParameter("type"),
				paramBuilder.GetParameter("date"),
				paramBuilder.GetParameter("apply_date"),
				paramBuilder.GetParameter("start_time"),
				paramBuilder.GetParameter("end_time"),
				paramBuilder.GetParameter("descriptions"),
				SessionInfo.UserId,
				$"{GetClientPCName()}/{GetIPAddress()}");
				
				ResultSet result = ExecuteProcedure(procInfo);
				
				bool isSuccess = result?.IsSuccess ?? false;
				
				return isSuccess;
		}
		catch (Exception ex)
		{
				ShowErrorMessageBox(ex);
				return false;
		}
}
```

## 적용 사례

* 저장용 프로시저 호출 메서드의 코드를 좀 더 간결하게 작성 가능
* 아래 두 코드는 같은 동작을 하며, ParameterBuilder의 사용 여부에만 차이가 있음

{% tabs %}
{% tab title="ParameterBuilder 미사용" %}

```csharp
private bool ExecuteSave(string workType)
{
    if (!ValidateControls(grpMaster))
        return false;

    // 기본 정보
    string groupCode = txtGroup_code1.Text;
    string groupName = txtGroup_name1.Text;
    int codeLength = Convert.ToInt32(numCode_length.Value);
    string category = cboGroup_category1.EditValue?.ToString() ?? string.Empty;

    string fieldCaption1 = txtField_caption1.Text;
    string fieldCaption2 = txtField_caption2.Text;
    string numCaption1 = txtNumref_caption1.Text;
    string numCaption2 = txtNumref_caption2.Text;

    string useYN = chkUse_yn.EditValue?.ToString() ?? string.Empty;
    string memo = memoMemo.Text;

    // 상세 정보
    string rowStatus = string.Empty;
    string subCodes = string.Empty;
    string codeNames = string.Empty;
    string systemYNs = string.Empty;
    string extraFields1 = string.Empty;
    string extraFields2 = string.Empty;
    string numrefs1 = string.Empty;
    string numrefs2 = string.Empty;
    string sortSeqs = string.Empty;
    string useYNs = string.Empty;

    if (!workType.Equals("D"))
    {
        int i = 0;
        DataTable datas = BindingData(grdDetail);

        if (datas != null)
        {
            foreach (DataRow row in datas.Rows)
            {
                if (i++ > 0)
                {
                    rowStatus += "|";
                    subCodes += "|";
                    codeNames += "|";
                    systemYNs += "|";
                    extraFields1 += "|";
                    extraFields2 += "|";
                    numrefs1 += "|";
                    numrefs2 += "|";
                    sortSeqs += "|";
                    useYNs += "|";
                }
                

                rowStatus += row.GetValue("row_status")?.ToString() ?? string.Empty;
                subCodes += row.GetValue("sub_code")?.ToString() ?? string.Empty;
                codeNames += row.GetValue("code_name")?.ToString() ?? string.Empty;
                systemYNs += row.GetValue("system_yn")?.ToString() ?? string.Empty;
                extraFields2 += row.GetValue("extra_field1")?.ToString() ?? string.Empty;
                extraFields1 += row.GetValue("extra_field2")?.ToString() ?? string.Empty;
                numrefs1 += row.GetValue("numref1")?.ToString() ?? string.Empty;
                numrefs2 += row.GetValue("numref2")?.ToString() ?? string.Empty;
                sortSeqs += row.GetValue("sort_seq")?.ToString() ?? string.Empty;
                useYNs += row.GetValue("use_yn")?.ToString() ?? string.Empty;
            }
        }
    }

    try
    {
        P_DEV002_xxx_S procInfo = new P_DEV002_xxx_S();

        procInfo.AddParamData(
            workType,
            groupCode,
            groupName,
            codeLength,
            category,
            fieldCaption1,
            fieldCaption2,
            numCaption1,
            numCaption2,
            useYN,
            memo,
            SessionInfo.UserId,
            $"{GetClientPCName()}/{GetIPAddress()}",
            rowStatus,
            subCodes,
            codeNames,
            systemYNs,
            extraFields1,
            extraFields2,
            numrefs1,
            numrefs2,
            sortSeqs,
            useYNs);

        ResultSet result = ExecuteProcedure(procInfo);

        if (!workType.Equals("D"))
        {
            _FindRowValue = result?.ReturnString;
        }

        return result?.IsSuccess ?? false;
    }
    catch (Exception ex)
    {
        ShowErrorMessageBox(ex);
        return false;
    }
}
```

{% endtab %}

{% tab title="ParameterBuilder 사용" %}

```csharp
private bool ExecuteSave(string workType)
{
    if (!ValidateControls(grpMaster))
        return false;

    string groupCode = txtGroup_code1.Text;
    string groupName = txtGroup_name1.Text;
    int codeLength = Convert.ToInt32(numCode_length.Value);
    string category = cboGroup_category1.EditValue?.ToString() ?? string.Empty;

    string fieldCaption1 = txtField_caption1.Text;
    string fieldCaption2 = txtField_caption2.Text;
    string numCaption1 = txtNumref_caption1.Text;
    string numCaption2 = txtNumref_caption2.Text;

    string useYN = chkUse_yn.EditValue?.ToString() ?? string.Empty;
    string memo = memoMemo.Text;

    ParameterBuilder paramBuilder = new ParameterBuilder();

    if (!workType.Equals("D"))
    {
        DataTable datas = BindingData(grdDetail);

        if (datas != null)
        {
            foreach (DataRow row in datas.Rows)
            {
                paramBuilder.Append(row, "row_status");
                paramBuilder.Append(row, "sub_code");
                paramBuilder.Append(row, "code_name");
                paramBuilder.Append(row, "system_yn");
                paramBuilder.Append(row, "extra_field1");
                paramBuilder.Append(row, "extra_field2");
                paramBuilder.Append(row, "numref1");
                paramBuilder.Append(row, "numref2");
                paramBuilder.Append(row, "sort_seq");
                paramBuilder.Append(row, "use_yn");
            }
        }
    }

    try
    {
        P_DEV002_xxx_S procInfo = new P_DEV002_xxx_S();

        procInfo.AddParamData(
            workType,
            groupCode,
            groupName,
            codeLength,
            category,
            fieldCaption1,
            fieldCaption2,
            numCaption1,
            numCaption2,
            useYN,
            memo,
            SessionInfo.UserId,
            $"{GetClientPCName()}/{GetIPAddress()}",
            paramBuilder.GetParameter("row_status"),
            paramBuilder.GetParameter("sub_code"),
            paramBuilder.GetParameter("code_name"),
            paramBuilder.GetParameter("system_yn"),
            paramBuilder.GetParameter("extra_field1"),
            paramBuilder.GetParameter("extra_field2"),
            paramBuilder.GetParameter("numref1"),
            paramBuilder.GetParameter("numref2"),
            paramBuilder.GetParameter("sort_seq"),
            paramBuilder.GetParameter("use_yn"));

        ResultSet result = ExecuteProcedure(procInfo);

        if (!workType.Equals("D"))
        {
            _FindRowValue = result?.ReturnString;
        }

        return result?.IsSuccess ?? false;
    }
    catch (Exception ex)
    {
        ShowErrorMessageBox(ex);
        return false;
    }
}
```

{% endtab %}
{% endtabs %}