public void LoadKyoukaMaster()
{
var Kyoukas = MS_KYOUKA_CACHE.GetAll();
KyoukaMaster.Clear();
foreach (var Kyouka in Kyoukas)
{
KyoukaMaster.Add(Kyouka);
}
}
private MS_KYOUKA GetKoma(int SearchKoma)
{
var data = MsWeeks.Where(x => x.KOMA == SearchKoma).FirstOrDefault();
if (data == null)
{
return(null);
}
return(MS_KYOUKA_CACHE.Get(data.MS_KYOUKA_ID));
}
public Dictionary <string, float> Get年時数(List <DateData> dateData)
{
Dictionary <string, float> retDatas = new Dictionary <string, float>();
var joinDatas = dateData.Join(MS_KYOUKA_CACHE.GetAll(), x => x.MS_KYOUKA_ID, j => j.MS_KYOUKA_ID, (x, j) => new
{
KYOUKA_NAME = j.KYOUKA_NAME,
RATIO = j.KYOUKA_RATIO
});
var groupDatas = joinDatas.GroupBy(x => x.KYOUKA_NAME).Select(a => new { KYOUKA_NAME = a.Key, Sum = a.Sum(x => x.RATIO) });
foreach (var d in groupDatas)
{
float aa = (float)((int)(d.Sum * ROUND)) / ROUND;
retDatas.Add(d.KYOUKA_NAME, aa);
}
return(retDatas);
}
public double 月合計(List <DateData> dateData, int Year, int Month)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("{0}{1}", Year, Month.ToString("d2"));
var joinDatas = dateData.Where(x => x.JIKANWARI.ToString("yyyyMM") == sb.ToString()).Join(MS_KYOUKA_CACHE.GetAll(), x => x.MS_KYOUKA_ID, j => j.MS_KYOUKA_ID, (x, j) => new
{
KYOUKA_NAME = j.KYOUKA_NAME,
RATIO = j.KYOUKA_RATIO
});
double aa = (double)((int)(joinDatas.Sum(x => x.RATIO) * ROUND)) / ROUND;
return(aa);
}
public Dictionary <string, float> Get月時数(List <DateData> dateData, int Year, int Month)
{
Dictionary <string, float> retDatas = new Dictionary <string, float>();
StringBuilder sb = new StringBuilder();
sb.AppendFormat("{0}{1}", Year, Month.ToString("d2"));
var joinDatas = dateData.Where(x => x.JIKANWARI.ToString("yyyyMM") == sb.ToString()).Join(MS_KYOUKA_CACHE.GetAll(), x => x.MS_KYOUKA_ID, j => j.MS_KYOUKA_ID, (x, j) => new
{
KYOUKA_NAME = j.KYOUKA_NAME,
RATIO = j.KYOUKA_RATIO
});
var groupDatas = joinDatas.GroupBy(x => x.KYOUKA_NAME).Select(a => new { KYOUKA_NAME = a.Key, Sum = (float)((int)(a.Sum(x => x.RATIO) * ROUND) / ROUND) });
foreach (var d in groupDatas)
{
retDatas.Add(d.KYOUKA_NAME, d.Sum);
}
return(retDatas);
}
public void DBOpen()
{
DBConnect.GetInstance().Open(@"Database=Jisu;Data Source=jisudb.cjzvzzwypzj9.us-east-2.rds.amazonaws.com;User Id=JisuAccessUser;Password=ZU6CzwL7lNgvXv");
MS_KYOUKA_CACHE.CacheFill();
}
