private void InitialScreen() { try { this.ToolBarSwitch = "1212001221"; this.tsbDDPrint2.Text = "สอ.๓"; this.tsbDDPrint2_Preview.Visible = false; this.tsbDDPrint2_Print.Visible = false; this.tsbDDPrint2_PDF.Visible = false; this.tsbDDPrint2_Word.Visible = false; this.tsbDDPrint_Excel.Visible = true; gvResult.SetOISStyle(); gvResult.MappingEnum(typeof(eCol)); gvResult.SetColumnDateTime((int)eCol.CRT_DATE); gvResult.SetColumnDateTime((int)eCol.UPD_DATE); gvResult.SetColumnDateTime((int)eCol.DEL_DATE); for (int i = (int)eCol.ID; i <= (int)eCol.DEL_ID; i++) { gvResult.Columns[i].Visible = false; } criteria = new RPT002_WorkPlaceAir_Criteria(); bdSource.DataSource = criteria; } catch (Exception ex) { rMessageBox.ShowException(this, ex); } }
private void ClearScreen() { gvResult.DataSource = null; gvResult.Rows.Clear(); criteria = new RPT002_WorkPlaceAir_Criteria(); bdSource.DataSource = criteria; this.ToolBarSwitch = "1212001221"; }
private void LoadData() { try { this.Cursor = Cursors.WaitCursor; bdSource.EndEdit(); criteria = new RPT002_WorkPlaceAir_Criteria() { ANALYSYS_NO = txtReportNumber.TextValue, JOB_NO = txtJobNo.TextValue, ANALYTICAL_DATE_FROM = dtMeasuredDate.DateValue, ANALYTICAL_DATE_TO = dtMeasuredDateTo.DateValue, CUSTOMER_ID = txtCustomer.IntValue, SAMPING_BY = txtMeasuredBy.StringValue, SHOW_DELETE_RECORD = chkShowDeleteRecord.Checked, }; rptList = vmRpt.GetWorkPlaceAir(criteria); gvResult.DataSource = rptList; gvResult.SetRowDeletedStyle((int)eCol.DEL_ID); if (gvResult.RowCount > 0) { this.ToolBarSwitch = "1212111221"; //this.ToolBarSwitch = "1212121221"; } else { this.ToolBarSwitch = "1212001221"; } } catch (Exception ex) { rMessageBox.ShowException(this, ex); } finally { this.Cursor = Cursors.Default; } }
public SortableBindingList <sp_RPT002_GetWorkPlaceAir_Result> GetWorkPlaceAir(RPT002_WorkPlaceAir_Criteria criteria) { return(service.GetWorkPlaceAir(criteria)); }
public SortableBindingList <sp_RPT002_GetWorkPlaceAir_Result> GetWorkPlaceAir(RPT002_WorkPlaceAir_Criteria criteria) { try { using (OIS_RPTEntities ct = new OIS_RPTEntities()) { var result = ct.sp_RPT002_GetWorkPlaceAir(criteria.ID, criteria.ANALYSYS_NO, criteria.JOB_NO, criteria.CUSTOMER_ID, criteria.ANALYTICAL_DATE_FROM, criteria.ANALYTICAL_DATE_TO, criteria.SAMPLING_DATE_FROM, criteria.SAMPLING_DATE_TO, criteria.SAMPING_BY, criteria.SHOW_DELETE_RECORD).ToList(); return(new SortableBindingList <sp_RPT002_GetWorkPlaceAir_Result>(result)); } } catch (Exception ex) { throw ex; } }