private string ConvertDataTableToHTMLTable() { DataTable dt = SqlDataAccessHelper.ExecuteQueryString("select * from RelationDept"); string messageBody = "<font>The following are the records: </font><br><br>"; if (dt.Rows.Count == 0) { return(messageBody); } string htmlTableStart = "<table style=\"border-collapse:collapse; text-align:center;\" >"; string htmlTableEnd = "</table>"; string htmlHeaderRowStart = "<tr style =\"background-color:#6FA1D2; color:#ffffff;\">"; string htmlHeaderRowEnd = "</tr>"; string htmlTrStart = "<tr style =\"color:#555555;\">"; string htmlTrEnd = "</tr>"; string htmlTdStart = "<td style=\" border-color:#5c87b2; border-style:solid; border-width:thin; padding: 5px;\">"; string htmlTdEnd = "</td>"; messageBody += htmlTableStart; messageBody += htmlHeaderRowStart; messageBody += htmlTdStart + "Description " + htmlTdEnd; messageBody += htmlHeaderRowEnd; foreach (DataRow Row in dt.Rows) { messageBody = messageBody + htmlTrStart; messageBody = messageBody + htmlTdStart + Row["Description"] + htmlTdEnd; messageBody = messageBody + htmlTrEnd; } messageBody = messageBody + htmlTableEnd; return(messageBody); }
private void demo_loadTree_Load(object sender, EventArgs e) { var tablePB = SqlDataAccessHelper.ExecuteQueryString("select * from RelationDept"); loadTreePhgBan(treeView1, tablePB); treeView1.AfterSelect += treePhongBan_AfterSelect; }
public DataTable DocDSCheck(List <int> dsnv, DateTime gioBD, DateTime gioKT) { #region query string query = @" select * from CheckInOut where TimeStr between (@giobd and @giokt) "; string chuoiOR = TaoChuoiOR(dsnv, "CheckInOut.UserEnrollNumber"); query += " AND " + chuoiOR; #endregion DataTable tableCheckk = SqlDataAccessHelper.ExecuteQueryString(query, new[] { "@giobd", "@giokt" }, new object[] { gioBD, gioKT }); return(tableCheckk); /* * tableChkINN_Auto = tableCheckk.Clone(); * tableChkOUT_Auto = tableCheckk.Clone(); * DataRow[] arrChkINN_Auto = tableCheckk.Select("MachineNo % 2 = 1 and (IDXacNhanCaVaLamThem is null)"); * DataRow[] arrChkOUT_Auto = tableCheckk.Select("MachineNo % 2 = 0 and (IDXacNhanCaVaLamThem is null) "); * DataRow[] arrChkINN_DaXN = tableCheckk.Select("MachineNo % 2 = 1 and (IDXacNhanCaVaLamThem is not null)"); * DataRow[] arrChkOUT_DaXN = tableCheckk.Select("MachineNo % 2 = 0 and (IDXacNhanCaVaLamThem is not null) "); * Loc(arrChkINN_Auto, tableChkINN_Auto); * Loc(arrChkOUT_Auto, tableChkOUT_Auto); */ //ToDataTable(arrChkINN_DaXN, ta); }
private void Form1_Load(object sender, EventArgs e) { table = SqlDataAccessHelper.ExecuteQueryString("select * from UserInfo where UserEnrollNumber between 9000 and 9500", null, null); var collection = new AutoCompleteStringCollection() { }; var arrString = new string[table.Rows.Count]; for (var i = 0; i < table.Rows.Count; i++) { arrString[i] = table.Rows[i]["UserFullCode"].ToString() + table.Rows[i]["UserFullName"].ToString(); } collection.AddRange(arrString); tb1.AutoCompleteSource = AutoCompleteSource.CustomSource; tb1.AutoCompleteMode = AutoCompleteMode.SuggestAppend; tb1.AutoCompleteCustomSource = collection; dataGridView1.DataSource = table; //Debug.WriteLine("dataGridView1.DataSource = table "); var table2 = SqlDataAccessHelper.ExecuteQueryString("select * from Shifts"); comboBox1.ValueMember = "ShiftID"; comboBox1.DisplayMember = "ShiftCode"; comboBox1.DataSource = table2; }
private void btnLoadDataSource_Click(object sender, EventArgs e) { DataTable tableNV = SqlDataAccessHelper.ExecuteQueryString("select * from UserInfo"); checkedComboBoxEdit1.Properties.DataSource = tableNV; checkedComboBoxEdit1.Properties.DisplayMember = "UserFullName"; checkedComboBoxEdit1.Properties.ValueMember = "UserEnrollNumber"; }
public void XemCong(List <int> dsnv, DateTime ngaybd, DateTime ngaykt) { DataTable table = SqlDataAccessHelper.ExecuteQueryString( @"select * from UserInfo, RelationDept where UserInfo.UserIDD = 294 and UserInfo.UserIDD = RelationDept.ID and UserInfo.Enabled = 1"); List <string> iLstUserEnrollNumber = LayArrIDStr("UserEnrollNumber", table); DataTable tableCheck = DocDSCheck(dsnv, ngaybd, ngaykt); for (int i = 0; i < dsnv.Count; i++) { #region query string query = @"SELECT dbo.UserInfo.UserEnrollNumber, dbo.Shifts.ShiftID, dbo.Shifts.ShiftCode, dbo.Shifts.Onduty, dbo.Shifts.Offduty, dbo.Shifts.DayCount, dbo.Shifts.OnTimeIn, dbo.Shifts.OnTimeOut, dbo.Shifts.CutIn, dbo.Shifts.CutOut, dbo.Shifts.OnLunch, dbo.Shifts.OffLunch, dbo.Shifts.WorkingTime, dbo.Shifts.Workingday, dbo.Shifts.LateGrace, dbo.Shifts.EarlyGrace, dbo.Shifts.AfterOT FROM dbo.UserInfo, dbo.Schedule, dbo.Shifts, dbo.ShiftSch WHERE dbo.UserInfo.SchID = dbo.Schedule.SchID AND dbo.Schedule.SchID = dbo.ShiftSch.SchID AND dbo.ShiftSch.T1 = dbo.Shifts.ShiftID AND dbo.UserInfo.UserEnrollNumber = " + dsnv[i]; #endregion DataTable table_Ca = SqlDataAccessHelper.ExecuteQueryString(query, null, null); DataRow[] arrRow_INN_A = tableCheck.Select("UserEnrollNumber=" + dsnv[i] + " and MachineNo % 2 = 1 and (IDXacNhanCaVaLamThem is null)"); DataRow[] arrRow_OUT_A = tableCheck.Select("UserEnrollNumber=" + dsnv[i] + " and MachineNo % 2 = 0 and (IDXacNhanCaVaLamThem is null)"); DataTable tableINN_A = tableCheck.Clone(); DataTable tableOUT_A = tableCheck.Clone(); Loc(arrRow_INN_A, tableINN_A); Loc(arrRow_OUT_A, tableOUT_A); DataTable tableCIO_A = TaoCauTrucDataTable( new[] { "UserEnrollNumber", "TimeStrVao", "MachineNoVao", "TimeStrRaa", "MachineNoRaa", "HaveINOUT", } , new[] { typeof(int), typeof(DateTime), typeof(int), typeof(DateTime), typeof(int), typeof(int), }); TaoTable_CIO_A(tableINN_A, tableOUT_A, tableCIO_A); XetCa_A(tableCIO_A, table_Ca); } }
public DataTable GetAllNV(int IDPhong) { #region string query = @"SELECT UserFullCode, UserFullName, UserLastName, UserEnrollNumber, UserEnrollName, UserIDTitle, UserIDC, UserIDD, SchID, HeSoLuongCB, HeSoLuongSP FROM UserInfo where UserEnabled = 1"; #endregion DataTable table = SqlDataAccessHelper.ExecuteQueryString(query, null, null); return(table); }