/*******************************************************************************************************************\ * * \*******************************************************************************************************************/ private void update_timebook() // shift_version { if (RefWeek == null) { return; } DataSet ds = dacTimebook.GetDS(RefWeek, 14); foreach (DataRow row in ds.Tables[0].Rows) { var bookdate_ = row["Bookdate"]; if (bookdate_ == DBNull.Value) { continue; } DateTime bookdate = (DateTime)bookdate_; if (bookdate.Date < RefWeek.Date) { continue; } if (bookdate.Date >= RefWeek.AddDays(14).Date) { continue; } //ucStat uc = (ucStat)tlpCrew.GetControlFromPosition(0, 0); ucStat uc = _crew[row["EmpID"].ToString()]; uc.RefreshDay(bookdate, row["ToffCode"].ToString(), Convert.ToSingle(row["LogHours"]), Convert.ToSingle(row["LogOver"]), row["LogVessel"].ToString(), Convert.ToInt32(row["LogShift"]), row["LogNote"].ToString()); } }
/*******************************************************************************************************************\ * * \*******************************************************************************************************************/ private void update_timebook(bool show_all) { if (RefWeek == null) { return; } //DataSet ds = dacTimebook.GetDS(RefWeek, 14); //foreach (DataRow row in ds.Tables[0].Rows) foreach (DataRow row in _dt_crew.Rows) { var bookdate_ = row["Bookdate"]; if (bookdate_ == DBNull.Value) { continue; } DateTime bookdate = (DateTime)bookdate_; //if (bookdate.Date < RefWeek.Date) continue; //if (bookdate.Date >= RefWeek.AddDays(14).Date) continue; if (bookdate.Date.CompareTo(RefWeek.Date) == -1) { continue; } if (bookdate.Date.CompareTo(RefWeek.AddDays(14).Date) == 1) { continue; } //ucStat uc = (ucStat)tlpCrew.GetControlFromPosition(0, 0); //if (!_crew.ContainsKey(row["EmpId"].ToString())) // load_crew_from_row(RefWeek, row); try { if (!show_all && !_crew.ContainsKey(row["EmpID"].ToString())) { continue; } ucStat uc = _crew[row["EmpID"].ToString()]; string notebug = null; // can't use row["LogNote"].ToString() if (!DBNull.Value.Equals(row["LogNote"])) { notebug = row["LogNote"].ToString(); } //if (row["EmpID"].ToString().Equals("G8") && ((decimal)row["LogHours"]) == 13.0M //if (row["EmpID"].ToString().Equals("W3") && ((DateTime)row["BookDate"]).Date.Equals(new DateTime(2015, 05, 11)) // ) MessageBox.Show("W3" + row["ToffCode"].ToString() + row["LogHours"].ToString() ); uc.RefWeek = RefWeek; uc.RefreshDay(bookdate, row["ToffCode"].ToString(), Convert.ToSingle(row["LogHours"]), Convert.ToSingle(row["LogOver"]), row["LogVessel"].ToString(), Convert.ToInt32(row["LogShift"]), notebug); } catch (Exception ex) { string msg = string.Format("Error ({0}) : Employee : [{1}:{2}] {3} => TOFF Code [{4}]", ex.Message, bookdate, row["EmpID"].ToString(), row["EmpName"].ToString(), row["ToffCode"].ToString()); MessageBox.Show(msg, "frmSched.update_timebook()"); } } }