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;
}
}
