/// <summary>
/// 事業コード検索のWhere句を作成する。
/// </summary>
private string CreateSearchTextForBusinessCode(string searchDebitBusinessCode, string searchDebitBusinessName, int?selectedAccountingCode,
bool showDeleted, DynamicParameters paramater)
{
List <string> whereSql = new List <string>();
//借方事業コード
if (!String.IsNullOrEmpty(searchDebitBusinessCode))
{
whereSql.Add(base.CreateSearchText(CommonUtil.SplitSearchText(searchDebitBusinessCode), new String[] { "DebitBusinessCode" }, paramater, "main"));
}
//借方事業名
if (!String.IsNullOrEmpty(searchDebitBusinessName))
{
whereSql.Add(base.CreateSearchText(CommonUtil.SplitSearchText(searchDebitBusinessName), new String[] { "DebitBusinessName" }, paramater, "main"));
}
//
if (selectedAccountingCode != null)
{
paramater.Add("@AccountingCodeNo", selectedAccountingCode, dbType: DbType.Int32);
whereSql.Add(@" main.AccountingCodeNo = @AccountingCodeNo ");
}
paramater.Add("@DeleteFlag", showDeleted.AsFlag(), dbType: DbType.Int32);
whereSql.Add(@" main.DeleteFlag = @DeleteFlag ");
return(whereSql.IsNullOrEmpty() ? "" : string.Join(" AND ", whereSql));
}