/// <summary> /// グリッドビューへ会社情報を表示する /// </summary> /// <param name="dg">DataGridViewオブジェクト名</param> private void GridViewShowData(string sConnect, DataGridView dg) { string sqlSTRING = string.Empty; sqlControl.DataControl sdCon = new common.sqlControl.DataControl(sConnect); SqlDataReader dR; //人事就業の会社領域のみを対象とする 2011/03/04 sqlSTRING += "select * from "; sqlSTRING += "(select tbCorpDatabaseContext.EntityCode,tbCorpDatabaseContext.EntityName,"; sqlSTRING += "tbCorpDatabaseContext.DatabaseName,tbCorpDatabaseContext.CreateDate,"; sqlSTRING += "CorpData.value('(/ObcCorpData/Node[@key=\"InitializeHR\"])[1]','varchar') as type, "; sqlSTRING += "CorpData.value('(/ObcCorpData/Node[@key=\"EraIndicate\"])[1]','varchar') as EraIn, "; sqlSTRING += "CorpData.value('(/ObcCorpData/Node[@key=\"HRFiscalMonth\"])[1]','varchar(7)') as FisMonth, "; sqlSTRING += "CorpData.value('(/ObcCorpData/Node[@key=\"HRFiscalYear\"])[1]','varchar(4)') as FisYear "; sqlSTRING += "from tbCorpDatabaseContext) as Corp "; sqlSTRING += "where (type is not null) "; sqlSTRING += "order by EntityCode"; dR = sdCon.free_dsReader(sqlSTRING); try { //グリッドビューに表示する int iX = 0; dg.RowCount = 0; while (dR.Read()) { //データグリッドにデータを表示する dg.Rows.Add(); GridViewCellData(dg, iX, dR); iX++; } dg.CurrentCell = null; } catch (Exception e) { MessageBox.Show(e.Message, "エラー", MessageBoxButtons.OK); } finally { dR.Close(); sdCon.Close(); } //会社情報がないとき if (dg.RowCount == 0) { MessageBox.Show("会社情報が存在しません", "会社選択", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); Environment.Exit(0); } }
///---------------------------------------------------------------- /// <summary> /// CSVデータから部門コンボボックスに課名をロードする </summary> /// <param name="tempObj"> /// コンボボックスオブジェクト</param> /// <param name="fName"> /// CSVデータファイルパス</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> /// CSVデータから部門コンボボックスにロードする </summary> /// <param name="tempObj"> /// コンボボックスオブジェクト</param> /// <param name="fName"> /// CSVデータファイルパス</param> ///---------------------------------------------------------------- public static void load(ComboBox tempObj, string dbName) { try { ComboProject cmb1; tempObj.Items.Clear(); tempObj.DisplayMember = "DisplayName"; tempObj.ValueMember = "code"; // 奉行SQLServer接続文字列取得 string sc_ac = sqlControl.obcConnectSting.get(dbName); // 奉行SQLServer接続 sqlControl.DataControl sdCon_ac = new sqlControl.DataControl(sc_ac); // プロジェクトデータリーダーを取得する string sqlSTRING = string.Empty; sqlSTRING += "SELECT ProjectCode,ProjectName,ValidDate,InValidDate "; sqlSTRING += "from tbProject "; sqlSTRING += "Order by ProjectCode"; SqlDataReader dR = sdCon_ac.free_dsReader(sqlSTRING); while (dR.Read()) { string dCode = string.Empty; // コンボボックスにセット cmb1 = new ComboProject(); cmb1.ID = string.Empty; dCode = dR["ProjectCode"].ToString().PadLeft(20, '0').Substring(12, 8); cmb1.DisplayName = dCode + " " + dR["ProjectName"].ToString(); cmb1.Name = dR["ProjectName"].ToString(); cmb1.code = dCode; tempObj.Items.Add(cmb1); } dR.Close(); sdCon_ac.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message, "現場コンボボックスロード"); } }
///---------------------------------------------------------------------------------- /// <summary> /// 対象シフトコードの開始時刻と終了時刻を取得する /// : 日替わり時刻を取得 2018/02/06 </summary> /// <param name="_dbName"> /// データベース名</param> /// <param name="sftCode"> /// シフトコード </param> /// <param name="sTime"> /// 開始時刻</param> /// <param name="eTime"> /// 終了時刻</param> /// <param name="changeTime"> /// 日替わり時刻</param> ///---------------------------------------------------------------------------------- private void GetSftTime(string sftCode, out string sTime, out string eTime, out DateTime changeTime, sqlControl.DataControl sdCon) { // 対象のシフトコード取得する DateTime sDt = DateTime.Now; DateTime eDt = DateTime.Now; DateTime cDt = DateTime.Now; // 2018/02/06 // 勤務体系(シフト)コード情報取得 StringBuilder sb = new StringBuilder(); sb.Clear(); sb.Append("SELECT tbLaborSystem.LaborSystemID,tbLaborSystem.LaborSystemCode,"); sb.Append("tbLaborSystem.LaborSystemName,tbLaborTimeSpanRule.StartTime,"); sb.Append("tbLaborTimeSpanRule.EndTime,tbLaborSystem.DayChangeTime "); sb.Append("FROM tbLaborSystem inner join tbLaborTimeSpanRule "); sb.Append("on tbLaborSystem.LaborSystemID = tbLaborTimeSpanRule.LaborSystemID "); sb.Append("where tbLaborTimeSpanRule.LaborTimeSpanRuleType = 1 "); sb.Append("and tbLaborSystem.LaborSystemCode = '").Append(sftCode).Append("'"); SqlDataReader dR = sdCon.free_dsReader(sb.ToString()); while (dR.Read()) { sDt = DateTime.Parse(dR["StartTime"].ToString()); eDt = DateTime.Parse(dR["EndTime"].ToString()); cDt = DateTime.Parse(dR["DayChangeTime"].ToString()); // 2018/02/06 break; } dR.Close(); // 開始時刻 sTime = sDt.Hour.ToString() + ":" + sDt.Minute.ToString().PadLeft(2, '0'); // 終了時刻 eTime = string.Empty; if (sDt.Day < eDt.Day) { // 翌日のとき eTime = "翌日"; } eTime += eDt.Hour.ToString() + ":" + eDt.Minute.ToString().PadLeft(2, '0'); // 2018/02/06 changeTime = cDt; }