private void Parttime_Click(object sender, EventArgs e) { GridPart.Show(); GridShow.Hide(); GridFull.Hide(); string sql = "SELECT *,EMP_TIMEWORK * EMP_CHG_HOUR AS TOTAL FROM EMPLOYEE WHERE EMP_TYPE = 'P'"; MySqlConnection con = new MySqlConnection("host = angsila.informatics.buu.ac.th; user = cs57160477; password = cs57160477; database = cs57160477"); MySqlCommand cmd = new MySqlCommand(sql, con); con.Open(); GridPart.Rows.Clear(); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { string code = reader.GetString("EMP_CODE"); string fname = reader.GetString("EMP_FNAME"); string lname = reader.GetString("EMP_LNAME"); string hour = reader.GetString("EMP_TIMEWORK"); string chg = reader.GetString("EMP_CHG_HOUR"); string total = reader.GetString("TOTAL"); GridPart.Rows.Add(code, fname, lname, hour, chg, total); } con.Close(); }
internal static string CreateSearchField(Grid grid) { StringBuilder javascript = new StringBuilder(string.Empty); StringBuilder onblur = new StringBuilder(" onblur=\""); if (grid.InputHighLight != Color.Empty) { javascript.AppendFormat( " onfocus=\"this.accessKey = this.style.backgroundColor;this.style.backgroundColor='{0}';\"", Grid.ColorToHtml(grid.InputHighLight)); onblur.Append("this.style.backgroundColor=this.accessKey;"); } if (grid.ColumnChangedColour != Color.Empty) { onblur.AppendFormat("isChanged(this,'{0}');", Grid.ColorToHtml(grid.ColumnChangedColour)); } onblur.Append("\""); javascript.Append(onblur); string s = string.Format( "<input {0} type=\"text\" onkeypress=\"return submitenter(this,event)\" class=\"wgeditfield wgsearchfield\" name=\"{1}_gridsearch\" value=\"{2}\"/> ", javascript, grid.ClientID, grid.Search); GridPart customSearchField = GridPart.GetControl(grid, Enums.GridPart.SearchField); // editorSystem.Web.HttpContext.Current.Server.ClientScript.RegisterClientScriptBlock(page.GetType(),"WGSearchBox", @" if (customSearchField != null) { StringBuilder builder = new StringBuilder(); StringWriter theStringWriter = new StringWriter(builder); System.Web.UI.HtmlTextWriter theHtmlWriter = new System.Web.UI.HtmlTextWriter(theStringWriter); if (customSearchField.Html != null) { Buttons.TextButtonControl(grid, customSearchField.Html, "SearchClick", new string[] {}, grid.GetSystemMessageClass("Search", "wgsearch")); customSearchField.m_InternalHtml = s + builder; } else { theHtmlWriter.Write(Buttons.TextButtonControl(grid, grid.GetSystemMessage("Search"), "SearchClick", new string[] { }, grid.GetSystemMessageClass("Search", "wgsearch"))); customSearchField.m_InternalHtml = s + builder; } } else { return (String.Format( "<table cellspacing=\"0\" cellpadding=\"0\"><tr valign=\"middle\"><td>{0}</td><td>{1}</td></tr></table>", s, Buttons.TextButtonControl(grid, grid.GetSystemMessage("Search"), "SearchClick", new string[] {}, grid.GetSystemMessageClass("Search", "wgsearch")))); } return(string.Empty); }
public void IsComplete_OutOfRangeValue_ReturnsTrue() { thePart = new GridPart(valuesWith7); bool expected = true; bool actual = thePart.IsComplete(); Assert.That(actual, Is.EqualTo(expected)); }
public void IsComplete_CorrectValues_ReturnsTrue() { thePart = new GridPart(valuesCorrect); bool expected = true; bool actual = thePart.IsComplete(); Assert.That(actual, Is.EqualTo(expected)); }
public void IsComplete_Contains0_ReturnsFalse() { thePart = new GridPart(valuesWith0); bool expected = false; bool actual = thePart.IsComplete(); Assert.That(actual, Is.EqualTo(expected)); }
public void IsValid_OutOfRangeValue_ReturnsFalse() { thePart = new GridPart(valuesWith7); bool expected = false; bool actual = thePart.IsValid(); Assert.That(actual, Is.EqualTo(expected)); }
public void IsValid_Contains0_ReturnsTrue() { thePart = new GridPart(valuesWith0); bool expected = true; bool actual = thePart.IsValid(); Assert.That(actual, Is.EqualTo(expected)); }
public void IsCorrect_DuplicateValues_ReturnsFalse() { thePart = new GridPart(valuesWithDuplicate); bool expected = false; bool actual = thePart.IsCorrect(); Assert.That(actual, Is.EqualTo(expected)); }
public void GetInvalidValues_ReturnsExpectedValues() { thePart = new GridPart(valuesSparse); List <int> expected = new List <int>() { 1, 4, 6 }; List <int> actual = thePart.GetInvalidValues(); Assert.That(actual, Is.EquivalentTo(expected)); }
internal static string CreateNewPostButton(Grid grid) { if (grid.AllowNew) { foreach (Column column in grid.MasterTable.Columns) { if (column.ColumnType == ColumnType.SystemColumn && ((SystemColumn)column).SystemColumnType == Enums.SystemColumn.NewRecordLink) { if (column.Visibility == Visibility.None) { return(string.Empty); } if (((SystemColumn)column).Html != null) { return (Buttons.TextButtonControl(grid, ((SystemColumn)column).Html, "NewRecordClick", new string[] {}, grid.GetSystemMessageClass("NewRecord", "wgnewrecord"))); } break; } } GridPart customNewRecord = GridPart.GetControl(grid, Enums.GridPart.NewRecord); if (customNewRecord != null) { StringBuilder builder = new StringBuilder(); StringWriter theStringWriter = new StringWriter(builder); System.Web.UI.HtmlTextWriter theHtmlWriter = new System.Web.UI.HtmlTextWriter(theStringWriter); string html = customNewRecord.Html ?? grid.GetSystemMessage("NewRecord"); theHtmlWriter.Write(Buttons.TextButtonControl(grid, html, "NewRecordClick", new string[] {}, grid.GetSystemMessageClass("NewRecord", "wgnewrecord"))); customNewRecord.m_InternalHtml = builder.ToString(); } else { return(Buttons.TextButtonControl(grid, grid.GetSystemMessage("NewRecord"), "NewRecordClick", new string[] {}, grid.GetSystemMessageClass("NewRecord", "wgnewrecord"))); } } return(string.Empty); }
internal static string CreateUpdateRowsButton(Grid grid) { foreach (Column column in grid.MasterTable.Columns) { if (column.Visibility != Visibility.Grid) { continue; } if (column.ColumnType != ColumnType.SystemColumn || ((SystemColumn)column).SystemColumnType != Enums.SystemColumn.UpdateRecordsLink) { continue; } string html = ((SystemColumn)column).Html; if (string.IsNullOrEmpty(html)) { continue; } return(Buttons.TextButtonControl(grid, html, "UpdateRowsClick", new string[] {}, grid.GetSystemMessageClass("NewRecord", "wgnewrecord"))); } GridPart customUpdateRecords = GridPart.GetControl(grid, Enums.GridPart.UpdateRecords); if (customUpdateRecords != null) { StringBuilder builder = new StringBuilder(); StringWriter theStringWriter = new StringWriter(builder); System.Web.UI.HtmlTextWriter theHtmlWriter = new System.Web.UI.HtmlTextWriter(theStringWriter); string html = customUpdateRecords.Html ?? grid.GetSystemMessage("UpdateRows"); theHtmlWriter.Write(Buttons.TextButtonControl(grid, html, "UpdateRowsClick", new string[] { }, grid.GetSystemMessageClass("UpdateRows", "wgupdaterecords"), null, string.Format("{0}_wgupdaterecords", grid.ID)) ); customUpdateRecords.m_InternalHtml = builder.ToString(); return(null); } return(Buttons.TextButtonControl(grid, grid.GetSystemMessage("UpdateRows"), "UpdateRowsClick", new string[] {}, grid.GetSystemMessageClass("UpdateRows", "wgupdaterecords"), null, string.Format("{0}_wgupdaterecords", grid.ID))); }
internal static string CreatePager(Grid grid) { Pager pager = grid.PagerSettings; if (pager.PagerType == PagerType.None) { return(string.Empty); } pager.ImagePath = grid.ImagePath; pager.m_PagerGrid = grid; GridPart customPager = GridPart.GetControl(grid, Enums.GridPart.Pager); if (customPager != null) { customPager.m_InternalHtml = pager.GetPager; return(null); } return(pager.GetPager); }
private void Form7_Load(object sender, EventArgs e) { GridFull.Hide(); GridPart.Hide(); }