/// <summary>
/// 検索ボタン押下処理
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Btn_Search_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
if (_BlDivisionSearch == null)
{
_BlDivisionSearch = new BLDivisionSearch();
}
// 検索条件取得
_BlDivisionSearch.SearchPrmDivision = TxtDivision.Text;
_BlDivisionSearch.SearchPrmDepartment = TxtDepartment.Text;
// 検索処理（フィールドセット）
_BlDivisionSearch.getDivisionInfo();
_SearchResultList = _BlDivisionSearch.SearchResult;
}
/// <summary>
/// 部署情報取得（検索条件指定）
/// </summary>
/// <param name="structure">Trueの場合、構造体のみ返却</param>
/// <returns></returns>
public DataTable getDivisionInfo(BLDivisionSearch parent)
{
StringBuilder sb = new StringBuilder();
StringBuilder sbwork = new StringBuilder();
StringBuilder sbwork2 = new StringBuilder();
sb.AppendLine("SELECT ");
sb.AppendLine("* ");
sb.AppendLine("FROM ");
sb.AppendLine("M_BUSYO_SEKKEI ");
sb.AppendLine("WHERE ");
if (parent.SearchPrmDivision != "")
{
sbwork.AppendLine("KA_CODE LIKE '@division%' ");
sbwork = sbwork.Replace("@division", parent.SearchPrmDivision);
}
if (parent.SearchPrmDepartment != "")
{
if (sbwork.ToString() != "")
{
sbwork.AppendLine("AND ");
}
sbwork.AppendLine("BU_CODE LIKE '@department%' ");
sbwork = sbwork.Replace("@department", parent.SearchPrmDepartment);
}
sb.AppendLine(sbwork.ToString());
sb.AppendLine("UNION ");
sb.AppendLine("SELECT ");
sb.AppendLine("* ");
sb.AppendLine("FROM ");
sb.AppendLine("M_BUSYO_HYOUKA ");
sb.AppendLine("WHERE ");
if (parent.SearchPrmDivision != "")
{
sbwork2.AppendLine("KA_CODE LIKE '@division%' ");
sbwork2 = sbwork2.Replace("@division", parent.SearchPrmDivision);
}
if (parent.SearchPrmDepartment != "")
{
if (sbwork2.ToString() != "")
{
sbwork2.AppendLine("AND ");
}
sbwork2.AppendLine("BU_CODE LIKE '@department%' ");
sbwork2 = sbwork2.Replace("@department", parent.SearchPrmDepartment);
}
sb.AppendLine(sbwork2.ToString());
// SQL実行
DataTable dt = new SqlBridging().ExecuteReader(sb.ToString());
DataColumn[] stringColumns =
dt.Columns.Cast <DataColumn>()
.Where(c => c.DataType == typeof(string))
.ToArray();
foreach (DataRow row in dt.Rows)
{
foreach (DataColumn col in stringColumns)
{
if (row.Field <string>(col) == null)
{
continue;
}
row.SetField <string>(col, row.Field <string>(col).Trim());
}
}
return(dt);
}
public frmDivisionSearch()
{
_BLCommon = new CommonLogic();
_BlDivisionSearch = new BLDivisionSearch();
_DbDivisionSearch = new DADivisionSearch();
}