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); } }