/// <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>
/// ＣＳＶデータから部門コンボボックスに課名をロードする </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="fName">
/// ＣＳＶデータファイルパス</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;
}