///-------------------------------------------------------------------------
/// <summary>
/// 部門マスターロード </summary>
/// <param name="tempObj">
/// コンボボックスオブジェクト</param>
/// <param name="bumon">
/// 部門 DataTable</param>
///-------------------------------------------------------------------------
public static void Load(ComboBox tempObj, System.Data.DataTable bumon)
{
try
{
ComboBumon cmb1;
tempObj.Items.Clear();
tempObj.DisplayMember = "Name";
tempObj.ValueMember = "ID";
DataRow[] rows = bumon.AsEnumerable().OrderBy(a => Utility.StrtoInt(a["部門コード"].ToString())).ToArray();
foreach (var t in rows)
{
cmb1 = new ComboBumon();
cmb1.ID = t["部門コード"].ToString(); // 部門コード
cmb1.Name = t["部門名"].ToString(); // 部門名
tempObj.Items.Add(cmb1);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "部門コンボボックスロード");
}
}
// 部門コンボ表示
public static void selectedIndex(ComboBox tempObj, int id)
{
ComboBumon cmbS = new ComboBumon();
Boolean Sh;
Sh = false;
for (int iX = 0; iX <= tempObj.Items.Count - 1; iX++)
{
//tempObj.SelectedIndex = iX;
//cmbS = (ComboBumon)tempObj.SelectedItem;
cmbS = (ComboBumon)tempObj.Items[iX];
if (cmbS.ID == id.ToString())
{
tempObj.SelectedIndex = iX;
Sh = true;
break;
}
}
if (Sh == false)
{
tempObj.SelectedIndex = -1;
}
}
///----------------------------------------------------------------
/// <summary>
/// ＣＳＶデータから部門コンボボックスに課名をロードする </summary>
/// <param name="tempObj">
/// コンボボックスオブジェクト</param>
/// <param name="fName">
/// ＣＳＶデータファイルパス</param>
///----------------------------------------------------------------
public static void loadKa(ComboBox tempObj, string dbName)
{
try
{
ComboBumon cmb1;
tempObj.Items.Clear();
tempObj.DisplayMember = "DisplayName";
tempObj.ValueMember = "code";
// 奉行SQLServer接続文字列取得
string sc = sqlControl.obcConnectSting.get(dbName);
sqlControl.DataControl sdCon = new sqlControl.DataControl(sc);
StringBuilder sb = new StringBuilder();
sb.Clear();
sb.Append("select DepartmentCode,DepartmentName from tbDepartment ");
sb.Append("where Right(DepartmentCode, 2) = '00'");
sb.Append("order by DepartmentCode");
SqlDataReader dR = sdCon.free_dsReader(sb.ToString());
while (dR.Read())
{
string dCode = string.Empty;
// コンボボックスにセット
cmb1 = new ComboBumon();
cmb1.ID = string.Empty;
if (Utility.NumericCheck(dR["DepartmentCode"].ToString()))
{
dCode = Utility.StrtoInt(dR["DepartmentCode"].ToString()).ToString().PadLeft(5, '0');
}
else
{
dCode = dR["DepartmentCode"].ToString().Trim();
}
cmb1.DisplayName = dCode + " " + dR["DepartmentName"].ToString();
cmb1.Name = dR["DepartmentName"].ToString();
cmb1.code = dCode;
tempObj.Items.Add(cmb1);
}
dR.Close();
sdCon.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "部門コンボボックスロード");
}
}
/// <summary>
/// 部門マスターロード ※帳票区分による対象絞り込み </summary>
/// <param name="tempObj"></param>
/// <param name="dts"></param>
/// <param name="choHyoKbn"></param>
public static void load(ComboBox tempObj, int choHyoKbn)
{
try
{
ComboBumon cmb1;
MTYSDataSet dts = new MTYSDataSet();
MTYSDataSetTableAdapters.社員所属TableAdapter adp = new MTYSDataSetTableAdapters.社員所属TableAdapter();
adp.Fill(dts.社員所属);
tempObj.Items.Clear();
tempObj.DisplayMember = "Name";
tempObj.ValueMember = "ID";
var s = dts.社員所属
.Where(a => a.RowState != System.Data.DataRowState.Deleted && a.RowState != System.Data.DataRowState.Detached)
.OrderBy(a => a.所属コード)
.Select(a => new
{
ID = a.所属コード,
称 = a.所属名称,
帳票区分 = a.帳票区分
}).Distinct();
if (choHyoKbn != 0)
{
s = s.Where(a => a.帳票区分 == choHyoKbn)
.OrderBy(a => a.ID);
}
foreach (var t in s)
{
cmb1 = new ComboBumon();
cmb1.ID = t.ID.ToString();
cmb1.Name = t.ID.ToString() + " " + t.称;
cmb1.DisplayName = t.称;
tempObj.Items.Add(cmb1);
}
tempObj.DropDownStyle = ComboBoxStyle.DropDownList;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "部門コンボボックスロード");
}
}
//部門マスターロード
public static void load(ComboBox tempObj, int tempLen, string dbName)
{
try
{
ComboBumon cmb1;
string sqlSTRING = string.Empty;
dbControl.DataControl dCon = new dbControl.DataControl(dbName);
OleDbDataReader dR;
sqlSTRING += "select * from Bumon inner join ";
sqlSTRING += "(select distinct BumonId as bumonid from Shain) as sbumon ";
sqlSTRING += "on Bumon.Id = sbumon.bumonid ";
sqlSTRING += "order by Code";
//データリーダーを取得する
dR = dCon.FreeReader(sqlSTRING);
tempObj.Items.Clear();
tempObj.DisplayMember = "DisplayName";
tempObj.ValueMember = "code";
while (dR.Read())
{
cmb1 = new ComboBumon();
cmb1.ID = int.Parse(dR["Id"].ToString());
cmb1.DisplayName = string.Format("{0:D" + tempLen.ToString() + "}", int.Parse(dR["Code"].ToString())) + " " + dR["Name"].ToString().Trim() + "";
cmb1.Name = dR["Name"].ToString().Trim() + "";
cmb1.code = dR["Code"].ToString() + "";
tempObj.Items.Add(cmb1);
}
dR.Close();
dCon.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "部門コンボボックスロード");
}
}
///----------------------------------------------------------------
/// <summary>
/// ＣＳＶデータから部門コンボボックスにロードする </summary>
/// <param name="tempObj">
/// コンボボックスオブジェクト</param>
/// <param name="fName">
/// ＣＳＶデータファイルパス</param>
///----------------------------------------------------------------
public static void loadCsv(ComboBox tempObj, string fName)
{
string[] bArray = null;
try
{
ComboBumon cmb1;
tempObj.Items.Clear();
tempObj.DisplayMember = "DisplayName";
tempObj.ValueMember = "code";
// 社員名簿CSV読み込み
bArray = System.IO.File.ReadAllLines(fName, Encoding.Default);
System.Collections.ArrayList al = new System.Collections.ArrayList();
foreach (var t in bArray)
{
string[] d = t.Split(',');
if (d.Length < 4)
{
continue;
}
string bn = d[3].PadLeft(5, '0') + "," + d[2] + "";
al.Add(bn);
}
// 配列をソートします
al.Sort();
string alCode = string.Empty;
foreach (var item in al)
{
string [] d = item.ToString().Split(',');
// 重複コード・部門はネグる
if (alCode != string.Empty && alCode.Substring(0, 5) == d[0])
{
continue;
}
// コンボボックスにセット
cmb1 = new ComboBumon();
cmb1.ID = 0;
cmb1.DisplayName = item.ToString().Replace(',', ' ');
string[] cn = item.ToString().Split(',');
cmb1.Name = cn[1] + "";
cmb1.code = cn[0] + "";
tempObj.Items.Add(cmb1);
alCode = item.ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "部門コンボボックスロード");
}
}
