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