// 会社情報取得
public static void GetKetasu(string dbName)
{
dbControl.DataControl dcon = new dbControl.DataControl(dbName);
OleDbDataReader dR = null;
try
{
// データリーダー取得
string mySql = string.Empty;
mySql += "SELECT BumonCodeKeta,ShainCodeKeta FROM Kaisha ";
dR = dcon.FreeReader(mySql);
// 部門コード桁数、社員コード桁数を取得
while (dR.Read())
{
global.ShozokuLength = int.Parse(dR["BumonCodeKeta"].ToString());
global.ShainLength = int.Parse(dR["ShainCodeKeta"].ToString());
}
}
catch (Exception e)
{
MessageBox.Show(e.Message, "エラー", MessageBoxButtons.OK);
}
finally
{
if (!dR.IsClosed)
{
dR.Close();
}
dcon.Close();
}
}
// データ領域ロード
public static void load(ComboBox tempObj)
{
dbControl.DataControl dcon = new dbControl.DataControl(Properties.Settings.Default.SQLDataBase);
OleDbDataReader dR = null;
try
{
ComboDataArea cmb;
// データリーダー取得
string mySql = string.Empty;
mySql += "SELECT * FROM Common_Unit_DataAreaInfo ";
mySql += "where CompanyTerm = " + DateTime.Today.Year.ToString();
dR = dcon.FreeReader(mySql);
//会社情報がないとき
if (!dR.HasRows)
{
MessageBox.Show("会社領域情報が存在しません", "会社領域選択", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
// コンボボックスにアイテムを追加します
tempObj.Items.Clear();
tempObj.DisplayMember = "DisplayName";
while (dR.Read())
{
cmb = new ComboDataArea();
// "CompanyCode"が数字のレコードを対象とする
if (Utility.NumericCheck(dR["CompanyCode"].ToString()))
{
cmb.DisplayName = dR["CompanyName"].ToString().Trim();
cmb.ID = dR["Name"].ToString().Trim();
cmb.code = dR["CompanyCode"].ToString().Trim();
tempObj.Items.Add(cmb);
}
}
}
catch (Exception e)
{
MessageBox.Show(e.Message, "エラー", MessageBoxButtons.OK);
}
finally
{
if (!dR.IsClosed)
{
dR.Close();
}
dcon.Close();
}
}
// パートタイマーロード
public static void loadPart(ComboBox tempObj, string dbName)
{
try
{
ComboShain cmb1;
string sqlSTRING = string.Empty;
dbControl.DataControl dCon = new dbControl.DataControl(dbName);
OleDbDataReader dR;
sqlSTRING += "select Bumon.Code as bumoncode,Bumon.Name as bumonname,Shain.Id as shainid,";
sqlSTRING += "Shain.Code as shaincode,Shain.Sei,Shain.Mei, Shain.YakushokuType ";
sqlSTRING += "from Shain left join Bumon ";
sqlSTRING += "on Shain.BumonId = Bumon.Id ";
sqlSTRING += "where Shurojokyo = 1 and YakushokuType = 1 ";
sqlSTRING += "order by Shain.Code";
//sqlSTRING += "select Id,Code, Sei, Mei, YakushokuType from Shain ";
//sqlSTRING += "where Shurojokyo = 1 and YakushokuType = 1 ";
//sqlSTRING += "order by Code";
//データリーダーを取得する
dR = dCon.FreeReader(sqlSTRING);
tempObj.Items.Clear();
tempObj.DisplayMember = "DisplayName";
tempObj.ValueMember = "code";
while (dR.Read())
{
cmb1 = new ComboShain();
cmb1.ID = int.Parse(dR["shainid"].ToString());
cmb1.DisplayName = dR["shaincode"].ToString().Trim() + " " + dR["Sei"].ToString().Trim() + " " + dR["Mei"].ToString().Trim();
cmb1.Name = dR["Sei"].ToString().Trim() + " " + dR["Mei"].ToString().Trim();
cmb1.code = (dR["shaincode"].ToString() + "").Trim();
cmb1.YakushokuType = int.Parse(dR["YakushokuType"].ToString());
cmb1.BumonCode = dR["bumoncode"].ToString().PadLeft(3, '0');
cmb1.BumonName = dR["bumonname"].ToString();
tempObj.Items.Add(cmb1);
}
dR.Close();
dCon.Close();
}
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, "部門コンボボックスロード");
}
}
