public DataTable Get_DataView_ToQC(Batch.Status Status, QCReport.ReportStatus QCReportStatus, long UserID)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@Status", Status),
new SqlParameter("@QCReportStatus", Convert.ToInt32(QCReportStatus)),
new SqlParameter("@UserID", UserID)
};
return(Execute.RunSP_DataTable(Connection, "SPGET_Batch_By_Status_view_ToQC", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
private void LoadReports()
{
QCReport.ReportStatus state = QCReport.ReportStatus.Initial;
if (rbInitial.Checked)
{
state = QCReport.ReportStatus.Initial;
}
else if (rbReject.Checked)
{
state = QCReport.ReportStatus.Reject;
btnMore.Enabled = false;
}
else if (rcAccept.Checked)
{
state = QCReport.ReportStatus.Accept;
btnMore.Enabled = false;
}
bindReports.DataSource = objQCReport_DL.GetView(cmbType.SelectedItem.ToString(), (int)state);
if (cmbType.SelectedItem.Equals("RPD"))
{
colRPD.Visible = true;
colPRPD.Visible = false;
colProduction.Visible = false;
}
else if (cmbType.SelectedItem.Equals("PRPD"))
{
colPRPD.Visible = true;
colRPD.Visible = false;
colProduction.Visible = false;
}
else
{
//colProduction.Visible = true;
//colPRPD.Visible = false;
//colRPD.Visible = false;
}
}