// 会社情報取得 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, "部門コンボボックスロード"); } }