/// <summary>
/// ユーザー情報取得（検索条件指定）
/// </summary>
/// <param name="structure">Trueの場合、構造体のみ返却</param>
/// <returns></returns>
public DataTable getUserInfo()
{
StringBuilder sb = new StringBuilder();
StringBuilder sbwork = new StringBuilder();
sb.AppendLine("SELECT ");
sb.AppendLine("* ");
sb.AppendLine("FROM ");
sb.AppendLine("M_USER ");
sb.AppendLine("WHERE ");
sb.AppendLine("USER_ID = null");
// SQL実行
DataTable dt = new SqlBridging().ExecuteReader(sb.ToString());
return(dt);
}
/// <summary>
/// ユーザー情報取得（複数ユーザーiD指定）
/// </summary>
/// <param name="structure">Trueの場合、構造体のみ返却</param>
/// <returns></returns>
public DataTable getUserInfo(List <string> userIdList)
{
StringBuilder sb = new StringBuilder();
StringBuilder sbwork = new StringBuilder();
sb.AppendLine("SELECT ");
sb.AppendLine("* ");
sb.AppendLine("FROM ");
sb.AppendLine("M_USER ");
sb.AppendLine("WHERE ");
var parm = "";
for (int i = 0; i < userIdList.Count; i++)
{
userIdList.CombineFromStringSingleQuotes(ref parm);
}
sb.AppendLine("USER_ID IN (@param)");
sb = sb.Replace("@param", parm);
sb.AppendLine(sbwork.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);
}
/// <summary>
/// 部署情報取得（検索条件指定）
/// </summary>
/// <param name="structure">Trueの場合、構造体のみ返却</param>
/// <returns></returns>
public DataTable getDivisionInfo()
{
StringBuilder sb = new StringBuilder();
StringBuilder sbwork = new StringBuilder();
sb.AppendLine("SELECT ");
sb.AppendLine("* ");
sb.AppendLine("FROM ");
sb.AppendLine("M_BUSYO_SEKKEI ");
sb.AppendLine("WHERE ");
sb.AppendLine("KA_CODE = null");
sb.AppendLine("AND ");
sb.AppendLine("BU_CODE = null");
sb.AppendLine("AND ");
sb.AppendLine("BY_PU = null");
// SQL実行
DataTable dt = new SqlBridging().ExecuteReader(sb.ToString());
return(dt);
}
/// <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);
}
/// <summary>
/// ユーザー情報取得（検索条件指定）
/// </summary>
/// <param name="structure">Trueの場合、構造体のみ返却</param>
/// <returns></returns>
public DataTable getUserInfo(BLUserSearch parent)
{
StringBuilder sb = new StringBuilder();
StringBuilder sbwork = new StringBuilder();
sb.AppendLine("SELECT ");
sb.AppendLine("* ");
sb.AppendLine("FROM ");
sb.AppendLine("M_USER ");
sb.AppendLine("WHERE ");
if (parent.SearchPrmUserName != "")
{
sbwork.AppendLine("USER_NAME LIKE '@userName%' ");
sbwork = sbwork.Replace("@userName", parent.SearchPrmUserName);
}
if (parent.SearchPrmMailAddress != "")
{
if (sbwork.ToString() != "")
{
sbwork.AppendLine("AND ");
}
sbwork.AppendLine("MAIL LIKE '@address%' ");
sbwork = sbwork.Replace("@address", parent.SearchPrmMailAddress);
}
if (parent.SearchPrmDepartment != "")
{
if (sbwork.ToString() != "")
{
sbwork.AppendLine("AND ");
}
sbwork.AppendLine("BU_CODE LIKE '@department%' ");
sbwork = sbwork.Replace("@department", parent.SearchPrmDepartment);
}
if (parent.SearchPrmDivision != "")
{
if (sbwork.ToString() != "")
{
sbwork.AppendLine("AND ");
}
sbwork.AppendLine("KA_CODE LIKE '@division%' ");
sbwork = sbwork.Replace("@division", parent.SearchPrmDivision);
}
sb.AppendLine(sbwork.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);
}