using com.hnshituo.core.webapp.vo; using Common; using Infragistics.Win; using Infragistics.Win.UltraWinGrid; using JC_MeasuringSystem; using MeterPlugInLibrary; using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Reflection; using System.Text; using System.Threading.Tasks; using System.Windows.Forms; using CreateAccess; using Common.DbOption.work; using System.Collections; namespace RailMeterSystem { public partial class frmTgMotoriaMain : Form { #region MeterWorkRailwayActFirstService actFirstService = new MeterWorkRailwayActFirstService(); // MeterBaseRailwayWeightService baseRailwayWgt = new MeterBaseRailwayWeightService(); MeterWorkRailwayActualService actualService = new MeterWorkRailwayActualService(); MeterWorkRailwayRecMainService meterWorkRailwayRecMainService = new MeterWorkRailwayRecMainService(); MeterWorkRailwayReceivedService meterWorkRailwayReceivedService = new MeterWorkRailwayReceivedService(); #endregion List ltMbV = new List(); CoreAppUser appUser = null; string strBaseSpotNo = "00013", sBaseSpotName = "动态轨道衡"; public frmTgMotoriaMain() { InitializeComponent(); } private void frmTgMotoriaMain_Load(object sender, EventArgs e) { appUser = ((ST_MainForm)(this.MdiParent)).AppUser; cbTimeType.SelectedIndex = 1; ValueList vlist1 = new ValueList(); vlist1.ValueListItems.Add("1", "未使用"); vlist1.ValueListItems.Add("2", "已使用"); ultraGridRecive.DisplayLayout.Bands[0].Columns["valueFlag"].ValueList = vlist1; ValueList vlist2 = new ValueList(); vlist2.ValueListItems.Add("1", "正常结净"); vlist2.ValueListItems.Add("2", "匹配结净"); ultraGridNet.DisplayLayout.Bands[0].Columns["netMode"].ValueList = vlist2; ValueList vlist3 = new ValueList(); vlist3.ValueListItems.Add("0", "待审核"); vlist3.ValueListItems.Add("1", "已审核"); vlist3.ValueListItems.Add("2", "已上传"); ultraGridNet.DisplayLayout.Bands[0].Columns["uploadFlag"].ValueList = vlist3; dtStartTime.Value = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd") + " 00:00:00"); dtEndTime.Value = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd") + " 23:59:59"); ClsControlPack.SetUltraGridRowFilter(ref ultraGridNet, true); ClsControlPack.SetUltraGridRowFilter(ref ultraGridFirst, true); } #region 按钮事件 private void btnQuery() { dtRecevice.Clear(); DataTable dtV = dtRecevice.Clone(); ClsControlPack.CopyDataToDatatable(ref dtV, ref this.dtRecevice, true); ClsControlPack.RefreshAndAutoSize(ultraGridRecive); QueryVoice(); QueryNetDb(); QueryFirstDb(); } /// /// 结净匹配 /// private void btnSubmit() { ultraGridRecive.UpdateData(); ultraGridFirst.UpdateData(); List lmmr = new List(); List lmrf = new List(); int icnt = 0; foreach (UltraGridRow ugrR in ultraGridRecive.Rows) { if (ugrR.Cells["UNCK"].Value.ToString().ToUpper() == "TRUE" && !ugrR.HiddenResolved) { icnt++; foreach (UltraGridRow ugr in ultraGridFirst.Rows) { if (ugrR.Cells["railwayNo"].Text.Trim() == ugr.Cells["railwayNo"].Text.Trim()) { MeterWorkRailwayMotorialReceived rec = new MeterWorkRailwayMotorialReceived(); rec.actualFirstNo = ugrR.Cells["actualFirstNo"].Text.Trim(); rec.railwayNo = ugrR.Cells["railwayNo"].Text.Trim(); rec.railwayCarriageNo = ugrR.Cells["railwayCarriageNo"].Text.Trim(); rec.railwaySpeed = Convert.ToDouble(string.IsNullOrEmpty(ugrR.Cells["railwaySpeed"].Text) ? "0" : ugrR.Cells["railwaySpeed"].Text); rec.railwayModel = ugrR.Cells["railwayModel"].Text.Trim(); rec.shipmentGrossWeight = Convert.ToDouble(string.IsNullOrEmpty(ugrR.Cells["shipmentGrossWeight"].Text) ? "0" : ugrR.Cells["shipmentGrossWeight"].Text); rec.shipmentNetWeight = Convert.ToDouble(string.IsNullOrEmpty(ugrR.Cells["shipmentNetWeight"].Text) ? "0" : ugrR.Cells["shipmentNetWeight"].Text); rec.meterWeight = Convert.ToDouble(string.IsNullOrEmpty(ugrR.Cells["meterWeight"].Text) ? "0" : ugrR.Cells["meterWeight"].Text); rec.createTime = Convert.ToDateTime(ugrR.Cells["createTime"].Text.Trim()); rec.valueFlag = ugrR.Cells["valueFlag"].Text.Trim(); rec.baseSpotNo = "00013"; rec.baseSpotName = "动态轨道衡"; rec.railwayTypeNo = "001019002"; rec.railwayTypeName = "动态轨道衡"; rec.weightType = "0"; lmmr.Add(rec); MeterWorkRailwayActFirst first = new MeterWorkRailwayActFirst(); first.actualFirstNo = ugr.Cells["actualFirstNo"].Text.Trim(); first.railwayNo = ugr.Cells["railwayNo"].Text.Trim(); first.railwayCarriageNo = ugr.Cells["railwayCarriageNo"].Text.Trim(); first.railwaySpeed = Convert.ToDouble(string.IsNullOrEmpty(ugr.Cells["railwaySpeed"].Text) ? "0" : ugr.Cells["railwaySpeed"].Text); first.meterWeight = Convert.ToDouble(string.IsNullOrEmpty(ugr.Cells["meterWeight"].Text) ? "0" : ugr.Cells["meterWeight"].Text); first.shipmentGrossWeight = Convert.ToDouble(string.IsNullOrEmpty(ugr.Cells["shipmentGrossWeight"].Text) ? "0" : ugr.Cells["shipmentGrossWeight"].Text); first.shipmentNetWeight = Convert.ToDouble(string.IsNullOrEmpty(ugr.Cells["shipmentNetWeight"].Text) ? "0" : ugr.Cells["shipmentNetWeight"].Text); first.createManNo = ugr.Cells["createManNo"].Text.Trim(); first.createManName = ugr.Cells["createManName"].Text.Trim(); first.createTime = Convert.ToDateTime(ugr.Cells["createTime"].Text.Trim()); first.valueFlag = ugr.Cells["valueFlag"].Text.Trim(); first.weightType = "1"; first.baseSpotNo = "00013"; first.baseSpotName = "动态轨道衡"; first.railwayTypeNo = "001019002"; first.railwayTypeName = "动态轨道衡"; lmrf.Add(first); break; } } } } string MeterTypeNo = "", MeterTypeName = ""; FrmMessage frmMessage = FrmMess($"当前选中【{icnt}】条毛重数据，当前选中【{lmrf.Count}】条皮重数据\n\r是否进行匹配！", "进厂保存"); if (frmMessage.ShowDialog(this) != DialogResult.OK) { return; } else { string sType = frmMessage.setType; switch (sType) { case "0": //采购 MeterTypeNo = "001006001"; MeterTypeName = "采购进厂"; break; case "1": //销售 MeterTypeNo = "001006002"; MeterTypeName = "销售出厂"; break; } } if (lmmr.Count == 0) { MessageBox.Show("请确保至少有一条能进行结净的毛皮数据"); } else { for (int i = 0; i < lmmr.Count; i++) { lmmr[i].meterTypeNo = MeterTypeNo; lmmr[i].meterTypeName = MeterTypeName; lmrf[i].meterTypeNo = MeterTypeNo; lmrf[i].meterTypeName = MeterTypeName; } //下面先保存，保存成功则使用下面的清理predictionNo的代码 RESTfulResult rES = actFirstService.doAddRailNetWf(lmmr, lmrf); if (rES.Succeed) { QueryNetDb(); QueryFirstDb(); UltraGridRow ugr = ultraGridVoice.ActiveRow; if (ugr != null) { QueryReceived(ugr.Cells["actualNo"].Text.Trim()); } MessageBox.Show("操作成功"); } else { MessageBox.Show("操作失败：" + rES.Message); } } } /// /// 取消结净 /// private void btnUnSubmit() { ultraGridNet.UpdateData(); if (ultraGridNet.Rows.Count > 0) { List ltFirst = new List(); foreach (UltraGridRow ugr in ultraGridNet.Rows) { if (ugr.Cells["UNCK"].Value.ToString().ToUpper() == "TRUE" && !ugr.HiddenResolved) { MeterWorkRailwayActual actual = new MeterWorkRailwayActual(); actual.actualNo = ugr.Cells["actualNo"].Text.Trim(); actual.actualFirst1No = ugr.Cells["actualFirst1No"].Text.Trim(); actual.actualFirst2No = ugr.Cells["actualFirst2No"].Text.Trim(); ltFirst.Add(actual); } } if (ltFirst != null && ltFirst.Count > 0) { RESTfulResult result = actFirstService.doRemoveRailNetWf(ltFirst); if (result.Succeed) { QueryNetDb(); QueryFirstDb(); UltraGridRow ugr = ultraGridVoice.ActiveRow; if (ugr != null) { QueryReceived(ugr.Cells["actualNo"].Text.Trim()); } } else { MessageBox.Show("删除失败：" + result.Message); } } else { MessageBox.Show("请先勾选需删除且未审核的结净数据"); } } } /// ///皮重保存 /// private void btnTare() { if (ultraGridRecive.Rows.Count > 0) { List ltFirst = new List(); foreach (UltraGridRow ugr in ultraGridRecive.Rows) { if (ugr.Cells["UNCK"].Value.ToString().ToUpper() == "TRUE" && !ugr.HiddenResolved) { MeterWorkRailwayActFirst fs = new MeterWorkRailwayActFirst(); fs.railwayNo = ugr.Cells["railwayNo"].Text.Trim(); fs.actualFirstNo = ugr.Cells["actualFirstNo"].Text.Trim(); fs.railwayCarriageNo = ugr.Cells["railwayCarriageNo"].Text.Trim(); fs.railwaySpeed = Convert.ToDouble(ugr.Cells["railwaySpeed"].Text.Trim()); fs.meterWeight = Convert.ToDouble(ugr.Cells["meterWeight"].Text.Trim()); fs.createTime = Convert.ToDateTime(ugr.Cells["createTime"].Text.Trim()); fs.railwayModelName = ugr.Cells["railwayModel"].Text.Trim(); fs.baseSpotNo = strBaseSpotNo; fs.baseSpotName = sBaseSpotName; fs.valueFlag = "1"; fs.weightType = "1"; fs.createManNo = appUser.userid; fs.createManName = appUser.username; fs.shipmentGrossWeight = Convert.ToDouble(string.IsNullOrEmpty(ugr.Cells["shipmentGrossWeight"].Text) ? "0" : ugr.Cells["shipmentGrossWeight"].Text); fs.shipmentNetWeight = Convert.ToDouble(string.IsNullOrEmpty(ugr.Cells["shipmentNetWeight"].Text) ? "0" : ugr.Cells["shipmentNetWeight"].Text); fs.railwayTypeNo = "001019002"; fs.railwayTypeName = "动态轨道衡"; ltFirst.Add(fs); } } if (ltFirst != null && ltFirst.Count > 0) { RESTfulResult result = actFirstService.doAddRailWf(ltFirst); if (result.Succeed) { UltraGridRow ugr = ultraGridVoice.ActiveRow; QueryReceived(ugr.Cells["actualNo"].Text.Trim()); QueryFirstDb(); } else { MessageBox.Show("新增失败！"); } } } else { MessageBox.Show("请先勾选需确认的皮重数据"); } } /// /// 皮重删除 /// private void btnUnTare() { if (ultraGridFirst.Rows.Count > 0) { List ltFirst = new List(); foreach (UltraGridRow ugr in ultraGridFirst.Rows) { if (ugr.Cells["UNCK"].Value.ToString().ToUpper() == "TRUE" && !ugr.HiddenResolved) { MeterWorkRailwayActFirst fs = new MeterWorkRailwayActFirst(); fs.actualFirstNo = ugr.Cells["actualFirstNo"].Text.Trim(); ltFirst.Add(fs); } } if (ltFirst != null && ltFirst.Count > 0) { RESTfulResult result = actFirstService.doDeleteWf(ltFirst); if (result.Succeed) { QueryFirstDb(); UltraGridRow ugr = ultraGridVoice.ActiveRow; if (ugr != null) { QueryReceived(ugr.Cells["actualNo"].Text.Trim()); } } else { MessageBox.Show("删除失败！"); } } } else { MessageBox.Show("请先勾选需删除的皮重数据"); } } private static FrmMessage FrmMess(string strMess, string strBtnSaveInfo) { FrmMessage frmMessage = new FrmMessage(); frmMessage.StartPosition = FormStartPosition.Manual; frmMessage.Location = new Point(350, 450); frmMessage.ShowMessage = strMess; frmMessage.BtnSaveText = strBtnSaveInfo; frmMessage.BtnCancelText = "取消"; return frmMessage; } private void ultraGridVoice_Click(object sender, EventArgs e) { UltraGridRow ugr = ultraGridVoice.ActiveRow; if (ugr != null) { QueryReceived(ugr.Cells["actualNo"].Text.Trim()); cbCheckAll.Checked = false; foreach (UltraGridRow ur in ultraGridVoice.Rows) { ur.Appearance.BackColor = Color.White; } ugr.Appearance.BackColor = Color.Red; } } #endregion #region 数据查询 /// /// 采集主表数据查询 /// private void QueryVoice() { DataTable dtV = dtVioce.Clone(); Hashtable hashtable = new Hashtable(); hashtable.Add("startTime", dtStartTime.Value.ToString("yyyy-MM-dd HH:mm:ss")); hashtable.Add("endTime", dtEndTime.Value.ToString("yyyy-MM-dd HH:mm:ss")); if (!string.IsNullOrEmpty(strBaseSpotNo)) { hashtable.Add("startTime", dtStartTime.Value.ToString("yyyy-MM-dd HH:mm:ss")); } RESTfulResult> rm = meterWorkRailwayRecMainService.Query(hashtable); dtV = ListToDatatable.ListToDataTable(rm.Data); //PbModelDbService> pb = new PbModelDbService>(); //RESTfulResult> rmType = pb.executeSqlDataWf(sql); //if (rmType.Succeed && rmType.Data != null && rmType.Data.Count > 0) //{ // dtV = rmType.Data.ListToDataTable(); //} ClsControlPack.CopyDataToDatatable(ref dtV, ref this.dtVioce, true); ClsControlPack.RefreshAndAutoSize(ultraGridVoice); } /// /// 采集子表数据查询 /// private void QueryReceived(string actualNo) { string sql = string.Format(@"select t.actual_first_no actualFirstNo, t.railway_no railwayNo, t.railway_carriage_no railwayCarriageNo, t.railway_speed railwaySpeed, nvl(t.meter_weight, 0) meterWeight, t.railway_model railwayModel, to_char(t.create_time,'yyyy-mm-dd hh24:mi:ss') createTime, t.base_spot_no baseSpotNo, t.base_spot_name baseSpotName, t.value_flag valueFlag, t.shipment_Gross_Weight shipmentGrossWeight, t.shipment_Net_Weight shipmentNetWeight from METER_WORK_RAILWAY_RECEIVED t where value_flag ='1' and actual_first_no like '{0}%' order by t.actual_first_no", actualNo); DataTable dtV = dtRecevice.Clone(); PbModelDbService> pb = new PbModelDbService>(); RESTfulResult> rmType = pb.executeSqlDataWf(sql); if (rmType.Succeed && rmType.Data != null && rmType.Data.Count > 0) { dtV = rmType.Data.ListToDataTable(); } ClsControlPack.CopyDataToDatatable(ref dtV, ref this.dtRecevice, true); ClsControlPack.RefreshAndAutoSize(ultraGridRecive); foreach (UltraGridRow ugrc in ultraGridRecive.Rows) { if (ugrc.Cells["valueFlag"].Value.ToString() != "1") { ugrc.Appearance.BackColor = Color.Yellow; } } } /// /// 皮重查询 /// private void QueryFirstDb() { string sql = $@"select actual_first_no actualFirstNo, railway_no railwayNo, railway_carriage_no railwayCarriageNo, railway_work_no railwayWorkNo, railway_speed railwaySpeed, nvl(meter_weight, 0) meterWeight, weight_type weightType, create_man_no createManNo, railway_model_name railwayModelName, create_man_name createManName, to_char(create_time, 'yyyy-mm-dd hh24:mi:ss') createTime, base_spot_no baseSpotNo, base_spot_name baseSpotName, value_flag valueFlag, shipment_Gross_Weight shipmentGrossWeight, shipment_Net_Weight shipmentNetWeight from Meter_Work_Railway_Act_First where value_flag = '1' and weight_type='1' and base_spot_no='00013' and create_time between to_date('{dtStartTime.Value.ToString("yyyy-MM-dd HH:mm:ss")}','yyyy-MM-dd HH24:mi:ss') and to_date('{dtEndTime.Value.ToString("yyyy-MM-dd HH:mm:ss")}','yyyy-MM-dd HH24:mi:ss') order by CREATE_TIME,RAILWAY_CARRIAGE_NO"; dtRailwayActFirst.Clear(); DataTable dtV = dtRailwayActFirst.Clone(); PbModelDbService> pb = new PbModelDbService>(); RESTfulResult> rmType = pb.executeSqlDataWf(sql); if (rmType.Succeed && rmType.Data != null && rmType.Data.Count > 0) { dtV = rmType.Data.ListToDataTable(); } ClsControlPack.CopyDataToDatatable(ref dtV, ref this.dtRailwayActFirst, true); ClsControlPack.RefreshAndAutoSize(ultraGridFirst); } /// /// 结净数据查询 /// private void QueryNetDb() { string sql = $@"select actual_no actualNo， prediction_no predictionNo， notice_no noticeNo， railway_no railwayNo， railway_carriage_no railwayCarriageNo， matter_no matterNo， matter_name matterName， contract_no contractNo， batch_no batchNo， customer_supplier_no customerSupplierNo， customer_supplier_name customerSupplierName， forwarding_unit_no forwardingUnitNo， forwarding_unit_name forwardingUnitName， receiving_uint_no receivingUintNo， receiving_uint_name receivingUintName， material_no materialNo， material_name materialName， spec_no specNo， spec_name specName， load_point_no loadPointNo， load_point_name loadPointName， sample_voucher sampleVoucher， carrier_unit_no carrierUnitNo， carrier_unit_name carrierUnitName， meter_type_no meterTypeNo， meter_type_name meterTypeName， meter_process_no meterProcessNo， meter_process_edition_no meterProcessEditionNo， actual_first1_no actualFirst1No， nvl(gross_weight,0) grossWeight， gross_man_no grossManNo， gross_man_name grossManName， to_char(gross_time, 'yyyy-mm-dd hh24:mi:ss') grossTime ， base_spot1_no baseSpot1No， base_spot1_name baseSpot1Name， gross_class grossClass， gross_group grossGroup， gross_mode grossMode， actual_first2_no actualFirst2No， nvl(tare_weight,0) tareWeight， tare_man_no tareManNo， tare_man_name tareManName， to_char(tare_time, 'yyyy-mm-dd hh24:mi:ss') tareTime ， base_spot2_no baseSpot2No， base_spot2_name baseSpot2Name， tare_class tareClass， tare_group tareGroup， tare_mode tareMode， nvl(net_weight,0) netWeight， net_man_no netManNo， net_man_name netManName， to_char(net_time, 'yyyy-mm-dd hh24:mi:ss') netTime ， net_spot3_no netSpot3No， net_spot3_name netSpot3Name， net_class netClass， net_group netGroup， net_mode netMode， value_flag valueFlag， upload_flag uploadFlag， check_man_no checkManNo， check_man_name checkManName， to_char(check_time, 'yyyy-mm-dd hh24:mi:ss') checkTime ， upload_man_no uploadManNo， upload_man_name uploadManName， to_char(upload_time, 'yyyy-mm-dd hh24:mi:ss') uploadTime， sample_no sampleNo， railway_type_no railwayTypeNo， railway_type_name railwayTypeName, water_num waterNum, round((nvl(net_weight,0)- nvl(net_weight,0) * nvl(water_num,0)/100),2) dryWgt, RAILWAY_MODEL_NAME railwayModelName from meter_work_railway_actual where value_flag = '0' and {(cbTimeType.Text == "毛重时间" ? "gross_time" : "net_time")} between to_date('{dtStartTime.Value.ToString("yyyy-MM-dd HH:mm:ss")}','yyyy-MM-dd HH24:mi:ss') and to_date('{dtEndTime.Value.ToString("yyyy-MM-dd HH:mm:ss")}','yyyy-MM-dd HH24:mi:ss')"; //and railway_type_no='001019002' 轨道衡类型 if (!string.IsNullOrEmpty(strBaseSpotNo)) { sql += string.Format(" and NET_SPOT3_NO ='{0}'", strBaseSpotNo); } sql += " order by net_time"; dtRailwayActual.Clear(); DataTable dt = dtRailwayActual.Clone(); PbModelDbService> pb = new PbModelDbService>(); RESTfulResult> rmType = pb.executeSqlDataWf(sql); if (rmType.Succeed && rmType.Data != null && rmType.Data.Count > 0) { dt = rmType.Data.ListToDataTable(); } ClsControlPack.CopyDataToDatatable(ref dt, ref this.dtRailwayActual, true); ClsControlPack.RefreshAndAutoSize(ultraGridNet); } #endregion private void ultraToolbarsManager1_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e) { ultraGridNet.UpdateData(); ultraGridRecive.UpdateData(); switch (e.Tool.Key) { case "btnQuery": { cbCheckAll.Checked = false; cbNetAll.Checked = false; btnQuery(); break; } case "btnSubmit": { btnSubmit(); break; } case "btnTareSave": { btnTare(); break; } case "btnUnSubmit": { btnUnSubmit(); break; } case "btnUnTareSave": { btnUnTare(); break; } default: break; } } private void cbCheckAll_CheckedChanged(object sender, EventArgs e) { if (ultraGridRecive.Rows.Count > 0) { foreach (UltraGridRow ugr in ultraGridRecive.Rows) { ugr.Cells["UNCK"].Value = cbCheckAll.Checked; foreach (UltraGridRow ugrx in ultraGridFirst.Rows) { if (ugrx.Cells["railwayNo"].Text.Trim() == ugr.Cells["railwayNo"].Text.Trim()) { ugrx.Cells["UNCK"].Value = cbCheckAll.Checked; break; } } } } ultraGridFirst.UpdateData(); ultraGridRecive.UpdateData(); } private void cbCheckTare_CheckedChanged(object sender, EventArgs e) { if (ultraGridFirst.Rows.Count > 0) { foreach (UltraGridRow ugr in ultraGridFirst.Rows) { ugr.Cells["UNCK"].Value = cbCheckTare.Checked; } } ultraGridFirst.UpdateData(); } private void ultraGridRecive_AfterCellUpdate(object sender, CellEventArgs e) { UltraGridRow ugr = ultraGridRecive.ActiveRow; if (ugr != null) { foreach (UltraGridRow ugrx in ultraGridFirst.Rows) { if (ugrx.Cells["railwayNo"].Text.Trim() == ugr.Cells["railwayNo"].Text.Trim()) { ugrx.Cells["UNCK"].Value = ugr.Cells["UNCK"].Value; break; } } } ugr.Appearance.BackColor = Color.Red; } private void ultraGridNet_AfterRowActivate(object sender, EventArgs e) { UltraGridRow ugr = ultraGridNet.ActiveRow; if (ugr != null) { if (ultraGridNet.Rows.Count > 0) { foreach (UltraGridRow ugrc in ultraGridNet.Rows) { ugrc.Appearance.BackColor = Color.White; } } ugr.Appearance.BackColor = Color.Red; } } private void ultraGridVoice_InitializeLayout(object sender, InitializeLayoutEventArgs e) { } private void cbNetAll_CheckedChanged(object sender, EventArgs e) { if (ultraGridNet.Rows.Count > 0) { foreach (UltraGridRow ugr in ultraGridNet.Rows) { ugr.Cells["UNCK"].Value = cbNetAll.Checked; } } ultraGridNet.UpdateData(); } public class ListToDatatable { public ListToDatatable() { } public static DataTable ListToDataTable(List entitys) { //检查实体集合不能为空 if (entitys == null || entitys.Count < 1) { return new DataTable(); } //取出第一个实体的所有Propertie Type entityType = entitys[0].GetType(); PropertyInfo[] entityProperties = entityType.GetProperties(); //生成DataTable的structure //生产代码中，应将生成的DataTable结构Cache起来，此处略 DataTable dt = new DataTable("dt"); for (int i = 0; i < entityProperties.Length; i++) { //dt.Columns.Add(entityProperties[i].Name, entityProperties[i].PropertyType); dt.Columns.Add(entityProperties[i].Name); } //将所有entity添加到DataTable中 foreach (object entity in entitys) { //检查所有的的实体都为同一类型 if (entity.GetType() != entityType) { throw new Exception("要转换的集合元素类型不一致"); } object[] entityValues = new object[entityProperties.Length]; for (int i = 0; i < entityProperties.Length; i++) { entityValues[i] = entityProperties[i].GetValue(entity, null); } dt.Rows.Add(entityValues); } return dt; } } } }