private void Insert(DateData dateData)
{
#region SQL
string SQL = @"
insert into DATE_DATA(
MS_GAKUNEN_ID,
JIKANWARI,
KOMA,
MS_KYOUKA_ID)
values(
@MS_GAKUNEN_ID,
@JIKANWARI,
@KOMA,
@MS_KYOUKA_ID)
";
#endregion
using (MySqlCommand command = new MySqlCommand(SQL, DBConnect.GetConnection()))
{
command.Parameters.AddWithValue("@MS_GAKUNEN_ID", dateData.MS_GAKUNEN_ID);
command.Parameters.AddWithValue("@JIKANWARI", dateData.JIKANWARI);
command.Parameters.AddWithValue("@KOMA", dateData.KOMA);
command.Parameters.AddWithValue("@MS_KYOUKA_ID", dateData.MS_KYOUKA_ID);
command.ExecuteNonQuery();
}
}
public void Update(List <DateData> DateDatas, List <MS_WEEK> MsWeeks, int Year, int Month, int MsGakunenID)
{
int TargetYear = Year;
if (Month < 4)
{
TargetYear++;
}
DateTime TargetDate = new DateTime(TargetYear, Month, 1);
DateTime FinishDate = new DateTime(TargetYear, Month, DateTime.DaysInMonth(Year, Month));
//ターゲットのデータを削除する
DateDatas.RemoveAll(x =>
{
if (x.MS_GAKUNEN_ID == MsGakunenID && x.JIKANWARI >= TargetDate && x.JIKANWARI <= FinishDate)
{
return(true);
}
else
{
return(false);
}
});
while (TargetDate < FinishDate)
{
//MS_WEEKからTargetDateの曜日のデータを取得する
var YoubiDatas = MsWeeks.Where(x => x.DAY == (int)TargetDate.DayOfWeek);
if (YoubiDatas != null)
{
foreach (var YoubiData in YoubiDatas)
{
if (YoubiData.MS_KYOUKA_ID > 0)
{
DateData dateData = new DateData {
JIKANWARI = TargetDate, KOMA = YoubiData.KOMA, MS_KYOUKA_ID = YoubiData.MS_KYOUKA_ID, MS_GAKUNEN_ID = MsGakunenID
};
DateDatas.Add(dateData);
}
}
}
TargetDate = TargetDate.AddDays(1);
}
}
