private void sheet_SelectionRangeChanged(object sender, unvell.ReoGrid.Events.RangeEventArgs e) { Worksheet sheet = rgBookings.CurrentWorksheet; ReoGridRange r = sheet.SelectionRange; SharedData.dtSelectedStart = Convert.ToDateTime(sheet[1, r.StartPos.Col].ToString()); SharedData.dtSelectedFinish = Convert.ToDateTime(sheet[1, r.EndPos.Col].ToString()); string sRooms = ""; for (int i = r.StartPos.Row; i <= r.EndPos.Row; i++) { sRooms += (sRooms.Length > 0 ? "|" : "") + sheet.Cells[i, 0].Tag.ToString(); } SharedData.sBookingRooms = sRooms; }
private void sheet_CellMouseEnter(object sender, unvell.ReoGrid.Events.CellMouseEventArgs e) { Worksheet sheet = e.Worksheet; ReoGridPos p = sheet.HoverPos; if (sheet.Cells[p].Tag != null && sheet.Cells[p].Tag.ToString().Length > 0) { DataSet d = Program.DB.SelectAll("SELECT BName,BCompany,BDates,BTimes,BComments FROM Jobs WHERE ID=" + sheet.Cells[p].Tag.ToString() + ";"); if (d.Tables.Count > 0 && d.Tables[0].Rows.Count > 0) { string sDate = "", sStart = "", sFinish = ""; DataRow row = d.Tables[0].Rows[0]; if (ab == null) { ShowTooltip(); } string[] sDates = new string[] { }; if (row["BDates"] != DBNull.Value) { sDates = row["BDates"].ToString().Split('|'); if (sDates.Length == 2) { sDates[0] = sDates[0].Replace(" 00:00:00", ""); sDates[1] = sDates[1].Replace(" 00:00:00", ""); sDate = sDates[0] + " - " + sDates[1]; } } if (row["BTimes"] != DBNull.Value) { string[] sTimes = row["BTimes"].ToString().Split('|'); if (sTimes.Length == 2 && sDates.Length == 2) { sDates[0] += " " + sTimes[0] + ":00"; sDates[1] += " " + sTimes[1] + ":00"; sStart = sTimes[0]; sFinish = sTimes[1]; DateTime now = DateTime.Now; int iYear = now.Year, iMonth = now.Month, iDay = now.Day; string[] d1 = sDates[0].Split('/'); string[] t1 = sTimes[0].Split(':'); iYear = Convert.ToInt32(d1[2].Substring(0, d1[2].IndexOf(' '))); iMonth = Convert.ToInt32(d1[1]); iDay = Convert.ToInt32(d1[0]); sStart = new DateTime(iYear, iMonth, iDay, Convert.ToInt32(t1[0]), Convert.ToInt32(t1[1]), 0).ToString("hh:mm"); string[] d2 = sDates[1].Split('/'); string[] t2 = sTimes[1].Split(':'); iYear = Convert.ToInt32(d2[2].Substring(0, d2[2].IndexOf(' '))); iMonth = Convert.ToInt32(d2[1]); iDay = Convert.ToInt32(d2[0]); sFinish = new DateTime(iYear, iMonth, iDay, Convert.ToInt32(t2[0]), Convert.ToInt32(t2[1]), 0).ToString("hh:mm"); } } string sCompany = ""; if (d.Tables[0].Rows[0]["BCompany"].ToString().Length > 0) { DataSet ds = Program.DB.SelectAll("SELECT Name FROM Companies WHERE ID=" + d.Tables[0].Rows[0]["BCompany"].ToString() + ";"); if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { sCompany = ds.Tables[0].Rows[0]["Name"].ToString(); } } b.Text = ""; b.CaptionText = d.Tables[0].Rows[0]["BName"].ToString(); if (sCompany.Length > 0 && !sCompany.Any(char.IsDigit)) { b.Text = sCompany; } if (sDate.Length > 0) { b.Text += b.Text.Length > 0 ? Environment.NewLine : ""; b.Text += sDate; } if (sStart.Length > 0 && sFinish.Length > 0) { b.Text += b.Text.Length > 0 ? Environment.NewLine : ""; b.Text += sStart + " - " + sFinish; } b.AutoResize(); b.Show(rgBookings, false); } } }
private void sheet_CellMouseLeave(object sender, unvell.ReoGrid.Events.CellMouseEventArgs e) { Worksheet sheet = e.Worksheet; ReoGridPos p = sheet.HoverPos; if (sheet.Cells[p].Tag != null) { return; } if (b != null && b.Visible) { b.Hide(); } }
private void sheet_CellMouseDown(object sender, unvell.ReoGrid.Events.CellMouseEventArgs e) { if (e.Cell != null && e.Cell.Tag != null) { iSSItemSelected = Convert.ToInt32(e.Cell.Tag); } }