public TPlaningAllDTO GetInspectionPlanAll(string PID, string uploadPath, string actionPath) { List <SqlParameter> parameterList = new List <SqlParameter>(); TPlaningAllDTO obj = new TPlaningAllDTO(); SqlDataAdapter da = new SqlDataAdapter(); DataSet ds = new DataSet(); string procName = "sp_T_Planing_AllReport"; try { dataTable = new DataTable(); adapter = new SqlDataAdapter(); SqlConnection conn = OpenConnection(); command = new SqlCommand(procName, conn); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new SqlParameter("@PID", PID)); da.SelectCommand = command; da.Fill(ds); if (ds != null && ds.Tables.Count > 0) { #region T_Planing obj.T_PlaningDT = ds.Tables[0].Copy(); obj.T_PlaningDT.TableName = "TPlaning"; obj.T_Planing_FilesDT = DTO.Util.ConvertX.ConvertDatatableToReportFile(ds.Tables[1].Copy(), "TPlaing_File", 2, uploadPath + "/" + PID); obj.T_Planing_FilesDT.TableName = "TPlaing_File"; #endregion #region T_Planing_Action_SiteSurvey obj.T_Planing_SiteSurveyDT = ds.Tables[2].Copy(); obj.T_Planing_SiteSurveyDT.TableName = "Sitesurvey"; obj.T_Planing_SiteSurvey_File1DT = DTO.Util.ConvertX.ConvertDatatableToReportFile(ds.Tables[3].Copy(), "TPlaing_File", 2, actionPath + "/SiteSurvey/" + PID + "/1"); obj.T_Planing_SiteSurvey_File1DT.TableName = "TPlaing_File"; obj.T_Planing_SiteSurvey_File2DT = DTO.Util.ConvertX.ConvertDatatableToReportFile(ds.Tables[4].Copy(), "TPlaing_File", 2, actionPath + "/SiteSurvey/" + PID + "/2"); obj.T_Planing_SiteSurvey_File2DT.TableName = "TPlaing_File"; #endregion #region Site Preparation obj.T_Planing_SitePreparationDT = ds.Tables[5].Copy(); obj.T_Planing_SitePreparationDT.TableName = "SitePreparation"; obj.T_Planing_SitePreparation_FileDT = DTO.Util.ConvertX.ConvertDatatableToReportFile(ds.Tables[6].Copy(), "TPlaing_File", 4, actionPath + "/SitePreparation/" + PID + "/1"); obj.T_Planing_SitePreparation_FileDT.TableName = "TPlaing_File"; obj.T_Planing_SitePreparation_UnderDT = DTO.Util.ConvertX.ConvertToSitePreparationUnder(ds.Tables[7].Copy()); obj.T_Planing_SitePreparationDT.TableName = "SitePreparation_under"; #endregion #region Weather Collection obj.T_Planing_WeatherCollectionDT = ds.Tables[8].Copy(); #endregion #region Before Coating Removal obj.T_Planing_BFRemovalDT = ds.Tables[9].Copy(); obj.T_Planing_BFRemovalDT.TableName = "BeforeCoatingRemoval"; obj.T_Planing_BFRemoval_ConditionDT = ds.Tables[10].Copy(); obj.T_Planing_BFRemoval_ConditionDT.TableName = "BeforeCoatingRemoval_Condition"; obj.T_Planing_BFRemoval_ConditionDT.Columns.Add("File", typeof(byte[])); foreach (DataRow drTemp in obj.T_Planing_BFRemoval_ConditionDT.Rows) { drTemp["FileName"] = string.Format(@"{0}/{1}", actionPath + "/BFRemoval/" + PID + "/3", drTemp["FileName"].ToString()); } obj.T_Planing_BFRemoval_File1DT = DTO.Util.ConvertX.ConvertDatatableToReportFile(ds.Tables[11].Copy(), "TPlaing_File", 2, actionPath + "/BFRemoval/" + PID + "/1"); obj.T_Planing_BFRemoval_File1DT.TableName = "TPlaing_File"; obj.T_Planing_BFRemoval_File2DT = DTO.Util.ConvertX.ConvertDatatableToReportFile(ds.Tables[12].Copy(), "TPlaing_File", 2, actionPath + "/BFRemoval/" + PID + "/2"); obj.T_Planing_BFRemoval_File2DT.TableName = "TPlaing_File"; #endregion #region After Coating Removal obj.T_Planing_AFRemovalDT = ds.Tables[13].Copy(); obj.T_Planing_AFRemovalDT.TableName = "AfterCoatingRemoval"; obj.T_Planing_AFRemoval_DefectDT = ds.Tables[14].Copy(); obj.T_Planing_AFRemoval_DefectDT.TableName = "AfterCoatingRemoval_Defect"; foreach (DataRow drTemp in obj.T_Planing_AFRemoval_DefectDT.Rows) { drTemp["FileName"] = string.Format(@"{0}/{1}", actionPath + "/AfterRemoval/" + PID + "/1", drTemp["FileName"].ToString()); } obj.T_Planing_AFRemoval_WallThicknessDT = ds.Tables[15].Copy(); obj.T_Planing_AFRemoval_WallThicknessDT.TableName = "AfterCoatingRemoval_WallThickness"; #endregion #region AppliedCoating obj.T_Planing_AppliedCoatingDT = ds.Tables[16].Copy(); obj.T_Planing_AppliedCoatingDT.TableName = "AppliedCoating"; obj.T_Planing_AppliedCoating_SurfaceProfileDT = ds.Tables[17].Copy(); obj.T_Planing_AppliedCoating_SurfaceProfileDT.TableName = "AppliedCoating_SurfaceProfile"; foreach (DataRow drTemp in obj.T_Planing_AppliedCoating_SurfaceProfileDT.Rows) { drTemp["FileName"] = string.Format(@"{0}/{1}", actionPath + "/AppliedCoating/" + PID + "/1", drTemp["FileName"].ToString()); } obj.T_Planing_AppliedCoating_InformationDT = ds.Tables[18].Copy(); obj.T_Planing_AppliedCoating_InformationDT.TableName = "AppliedCoating_Information"; #endregion #region After AppliedCoating obj.T_Planing_AfterAppliedCoatingDT = ds.Tables[19].Copy(); obj.T_Planing_AfterAppliedCoatingDT.TableName = "AfterAppliedCoating"; obj.T_Planing_AfterAppliedCoating_DryFilmThicknessDT = ds.Tables[20].Copy(); obj.T_Planing_AfterAppliedCoating_DryFilmThicknessDT.TableName = "AfterAppliedCoating_DryFilmThickness"; obj.T_Planing_AfterAppliedCoating_File1DT = DTO.Util.ConvertX.ConvertDatatableToReportFile(ds.Tables[21].Copy(), "TPlaing_File", 2, actionPath + "/AfterAppliedCoating/" + PID + "/1"); obj.T_Planing_AfterAppliedCoating_File1DT.TableName = "TPlaing_File"; obj.T_Planing_AfterAppliedCoating_File2DT = DTO.Util.ConvertX.ConvertDatatableToReportFile(ds.Tables[22].Copy(), "TPlaing_File", 2, actionPath + "/AfterAppliedCoating/" + PID + "/2"); obj.T_Planing_AfterAppliedCoating_File2DT.TableName = "TPlaing_File"; #endregion #region Site Recovery obj.T_Planing_SiteRecoveryDT = ds.Tables[23].Copy(); obj.T_Planing_SiteRecoveryDT.TableName = "SiteRecovery"; obj.T_Planing_SiteRecovery_File1DT = DTO.Util.ConvertX.ConvertDatatableToReportFile(ds.Tables[24].Copy(), "TPlaing_File", 2, actionPath + "/SiteRecovery/" + PID + "/1"); obj.T_Planing_SiteRecovery_File1DT.TableName = "TPlaing_File"; obj.T_Planing_SiteRecovery_File2DT = DTO.Util.ConvertX.ConvertDatatableToReportFile(ds.Tables[25].Copy(), "TPlaing_File", 2, actionPath + "/SiteRecovery/" + PID + "/2"); obj.T_Planing_SiteRecovery_File2DT.TableName = "TPlaing_File"; #endregion } } catch (Exception ex) { } finally { CloseConnection(); } return(obj); }
public TPlaningAllDTO GetInspectionPlanAll(string PID, string uploadPath) { List <SqlParameter> parameterList = new List <SqlParameter>(); TPlaningAllDTO obj = new TPlaningAllDTO(); SqlDataAdapter da = new SqlDataAdapter(); DataSet ds = new DataSet(); string procName = "sp_T_Planing_AllReport"; try { dataTable = new DataTable(); adapter = new SqlDataAdapter(); SqlConnection conn = OpenConnection(); command = new SqlCommand(procName, conn); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new SqlParameter("@PID", PID)); da.SelectCommand = command; da.Fill(ds); if (ds != null && ds.Tables.Count > 0) { #region T_Planing obj.T_PlaningDT = ds.Tables[0].Copy(); obj.T_PlaningDT.TableName = "TPlaning"; obj.T_Planing_FilesDT = DTO.Util.ConvertX.ConvertDatatableToReportFile(ds.Tables[1].Copy(), "TPlaing_File", 2, uploadPath); obj.T_Planing_FilesDT.TableName = "TPlaing_File"; #endregion #region T_Planing_Action_SiteSurvey obj.T_Planing_SiteSurveyDT = ds.Tables[2].Copy(); obj.T_Planing_SiteSurveyDT.TableName = "Sitexurvey"; obj.T_Planing_SiteSurvey_File1DT = DTO.Util.ConvertX.ConvertDatatableToReportFile(ds.Tables[3].Copy(), "TPlaing_File", 2, uploadPath); obj.T_Planing_SiteSurvey_File1DT.TableName = "TPlaing_File"; obj.T_Planing_SiteSurvey_File2DT = DTO.Util.ConvertX.ConvertDatatableToReportFile(ds.Tables[4].Copy(), "TPlaing_File", 2, uploadPath); obj.T_Planing_SiteSurvey_File2DT.TableName = "TPlaing_File"; #endregion #region Site Preparation obj.T_Planing_SitePreparationDT = ds.Tables[5].Copy(); obj.T_Planing_SitePreparationDT.TableName = "SitePreparation"; obj.T_Planing_SitePreparation_FileDT = DTO.Util.ConvertX.ConvertDatatableToReportFile(ds.Tables[6].Copy(), "TPlaing_File", 4, uploadPath); obj.T_Planing_SitePreparation_FileDT.TableName = "TPlaing_File"; obj.T_Planing_SitePreparation_UnderDT = DTO.Util.ConvertX.ConvertToSitePreparationUnder(ds.Tables[7].Copy()); obj.T_Planing_SitePreparationDT.TableName = "SitePreparation_under"; obj.T_Planing_WeatherCollectionDT = ds.Tables[8].Copy(); #endregion } } catch (Exception ex) { } finally { CloseConnection(); } return(obj); }