private System.Data.DataTable ListConvertDataTable(List<MVTHistoryMovementServiceViewModel> listMVTHistoryMovementServiceViewModel) { System.Data.DataTable dt = new System.Data.DataTable(); DataColumn dcStartTime = new DataColumn("colStartTime", Type.GetType("System.String")); DataColumn dcFinalTime = new DataColumn("colFinalTime", Type.GetType("System.String")); DataColumn dcTankName = new DataColumn("colTankName", Type.GetType("System.String")); DataColumn dcMaterialName = new DataColumn("colMaterialName", Type.GetType("System.String")); DataColumn dcStartLevel = new DataColumn("colStartLevel", Type.GetType("System.String")); DataColumn dcFinalLevel = new DataColumn("colFinalLevel", Type.GetType("System.String")); DataColumn dcStartGSV = new DataColumn("colStartGSV", Type.GetType("System.String")); DataColumn dcFinalGSV = new DataColumn("colFinalGSV", Type.GetType("System.String")); DataColumn dcGSVVolumn = new DataColumn("colGSVVolumn", Type.GetType("System.String")); DataColumn dcStartGOV = new DataColumn("colStartGOV", Type.GetType("System.String")); DataColumn dcFinalGOV = new DataColumn("colFinalGOV", Type.GetType("System.String")); DataColumn dcGOVVolumn = new DataColumn("colGOVVolumn", Type.GetType("System.String")); DataColumn dcStartPressure = new DataColumn("colStartPressure", Type.GetType("System.String")); DataColumn dcFinalPressure = new DataColumn("colFinalPressure", Type.GetType("System.String")); DataColumn dcStartTemperature = new DataColumn("colStartTemperature", Type.GetType("System.String")); DataColumn dcFinalTemperature = new DataColumn("colFinalTemperature", Type.GetType("System.String")); DataColumn dcStartDensity = new DataColumn("colStartDensity", Type.GetType("System.String")); DataColumn dcFinalDensity = new DataColumn("colFinalDensity", Type.GetType("System.String")); DataColumn dcTankRole = new DataColumn("colTankRole", Type.GetType("System.String")); DataColumn dcMovementServiceName = new DataColumn("colMovementServiceName", Type.GetType("System.String")); dt.Columns.Add(dcStartTime); dt.Columns.Add(dcFinalTime); dt.Columns.Add(dcTankName); dt.Columns.Add(dcMaterialName); dt.Columns.Add(dcStartLevel); dt.Columns.Add(dcFinalLevel); dt.Columns.Add(dcStartGSV); dt.Columns.Add(dcFinalGSV); dt.Columns.Add(dcGSVVolumn); dt.Columns.Add(dcStartGOV); dt.Columns.Add(dcFinalGOV); dt.Columns.Add(dcGOVVolumn); dt.Columns.Add(dcStartPressure); dt.Columns.Add(dcFinalPressure); dt.Columns.Add(dcStartTemperature); dt.Columns.Add(dcFinalTemperature); dt.Columns.Add(dcStartDensity); dt.Columns.Add(dcFinalDensity); dt.Columns.Add(dcTankRole); dt.Columns.Add(dcMovementServiceName); try { MVTHistoryMovementServiceViewModel viewModel = new MVTHistoryMovementServiceViewModel(); if (listMVTHistoryMovementServiceViewModel != null && listMVTHistoryMovementServiceViewModel.Count > 0) { DataRow dr = dt.NewRow(); for (int i = 0; i < listMVTHistoryMovementServiceViewModel.Count; i++) { dr = dt.NewRow(); viewModel = listMVTHistoryMovementServiceViewModel[i]; dr["colStartTime"] = viewModel.StartTime; dr["colFinalTime"] = viewModel.FinalTime; dr["colTankName"] = viewModel.TankName; dr["colMaterialName"] = viewModel.MaterialName; dr["colStartLevel"] = viewModel.StartLevel; dr["colFinalLevel"] = viewModel.FinalLevel; dr["colStartGSV"] = viewModel.StartGSV; dr["colFinalGSV"] = viewModel.FinalGSV; dr["colGSVVolumn"] = viewModel.GSVVolumn; dr["colStartGOV"] = viewModel.StartGOV; dr["colFinalGOV"] = viewModel.FinalGOV; dr["colGOVVolumn"] = viewModel.GOVVolumn; dr["colStartPressure"] = viewModel.StartPressure; dr["colFinalPressure"] = viewModel.FinalPressure; dr["colStartTemperature"] = viewModel.StartTemperature; dr["colFinalTemperature"] = viewModel.FinalTemperature; dr["colStartDensity"] = viewModel.StartDensity; dr["colFinalDensity"] = viewModel.FinalDensity; dr["colTankRole"] = viewModel.TankRole; dr["colMovementServiceName"] = viewModel.MovementServiceName; dt.Rows.Add(dr); } } } catch (Exception e) { // MessageBox.Show(e.Message); } return dt; }
怎么把list转换成 datatable
最新推荐文章于 2023-11-03 11:27:22 发布