private void InsertSubstation_Info() { //LayoutList ll1 = this.ctrlLayoutList1.FocusedObject; //if (ll1 == null) // return; string columnname = ""; try { DataTable dts = new DataTable(); OpenFileDialog op = new OpenFileDialog(); op.Filter = "Excel文件(*.xls)|*.xls"; if (op.ShowDialog() == DialogResult.OK) { dts = GetExcel(op.FileName); IList <Substation_Info> lii = new List <Substation_Info>(); DateTime s8 = DateTime.Now; int x = 0; for (int i = 0; i < dts.Rows.Count; i++) { if (dts.Rows[i][1].ToString().IndexOf("合计") >= 0) { continue; } Substation_Info l1 = new Substation_Info(); foreach (DataColumn dc in dts.Columns) { columnname = dc.ColumnName; if (dts.Rows[i][dc.ColumnName].ToString() == "") { continue; } switch (dc.ColumnName) { case "L2": case "L9": double LL2 = 0; try { LL2 = Convert.ToDouble(dts.Rows[i][dc.ColumnName].ToString()); } catch { } l1.GetType().GetProperty(dc.ColumnName).SetValue(l1, LL2, null); break; case "L10": double L10 = 0; try { L10 = ChangeDou(dts.Rows[i][dc.ColumnName].ToString()); } catch { } l1.GetType().GetProperty(dc.ColumnName).SetValue(l1, L10, null); break; case "L1": case "L3": int LL3 = 0; try { LL3 = Convert.ToInt32(dts.Rows[i][dc.ColumnName].ToString()); } catch { } l1.GetType().GetProperty(dc.ColumnName).SetValue(l1, LL3, null); break; default: l1.GetType().GetProperty(dc.ColumnName).SetValue(l1, dts.Rows[i][dc.ColumnName].ToString(), null); break; } } l1.Flag = selectid; l1.CreateDate = s8.AddSeconds(i); l1.AreaID = ProjectUID; lii.Add(l1); } foreach (Substation_Info lll in lii) { Substation_Info l1 = new Substation_Info(); l1.AreaName = lll.AreaName; l1.Title = lll.Title; l1.AreaID = ProjectUID; l1.Flag = selectid; string con = "AreaID='" + ProjectUID + "' and Title='" + l1.Title + "' and Flag='" + selectid + "'"; object obj = Services.BaseService.GetObject("SelectSubstation_InfoByCon", con); if (obj != null) { lll.UID = ((Substation_Info)obj).UID; Services.BaseService.Update <Substation_Info>(lll); } else { Services.BaseService.Create <Substation_Info>(lll); } } this.ctrlSubstation_Info1.CalcTotal(); } } catch (Exception ex) { MsgBox.Show(columnname + ex.Message); MsgBox.Show("导入格式不正确!"); } }
private void InsertSubstation_Info() { string columnname = ""; try { DataTable dts = new DataTable(); OpenFileDialog op = new OpenFileDialog(); op.Filter = "Excel文件(*.xls)|*.xls"; if (op.ShowDialog() == DialogResult.OK) { dts = GetExcel(op.FileName); IList <Substation_Info> lii = new List <Substation_Info>(); DateTime s8 = DateTime.Now; for (int i = 2; i < dts.Rows.Count; i++) { if (dts.Rows[i][1].ToString().IndexOf("合计") >= 0) { continue; } Substation_Info l1 = new Substation_Info(); foreach (DataColumn dc in dts.Columns) { columnname = dc.ColumnName; if (dts.Rows[i][dc.ColumnName].ToString() == "") { continue; } switch (dc.ColumnName) { case "L2": case "L9": case "L10": double LL2 = 0; try { LL2 = Convert.ToDouble(dts.Rows[i][dc.ColumnName].ToString()); } catch { } l1.GetType().GetProperty(dc.ColumnName).SetValue(l1, LL2, null); break; case "L1": case "L3": int LL3 = 0; try { LL3 = Convert.ToInt32(dts.Rows[i][dc.ColumnName].ToString()); } catch { } l1.GetType().GetProperty(dc.ColumnName).SetValue(l1, LL3, null); break; case "L13": case "L14": case "L15": case "L16": case "L17": case "L18": case "L19": case "L20": ////int LL3 = 0; ////try ////{ //// LL3 = Convert.ToInt32(dts.Rows[i][dc.ColumnName].ToString()); ////} ////catch { } l1.GetType().GetProperty(dc.ColumnName).SetValue(l1, dts.Rows[i][dc.ColumnName].ToString(), null); break; default: l1.GetType().GetProperty(dc.ColumnName).SetValue(l1, dts.Rows[i][dc.ColumnName].ToString(), null); break; } } l1.Flag = "1"; l1.CreateDate = s8.AddSeconds(i); lii.Add(l1); } foreach (Substation_Info lll in lii) { Substation_Info l1 = new Substation_Info(); l1.AreaName = lll.AreaName; l1.Title = lll.Title; l1.Flag = "1"; object obj = Services.BaseService.GetObject("SelectSubstation_InfoByNameFlag", l1); if (obj != null) { lll.UID = ((Substation_Info)obj).UID; Services.BaseService.Update <Substation_Info>(lll); } else { Services.BaseService.Create <Substation_Info>(lll); } } this.ctrlSubstation_Info_LangFang1.RefreshData(); } } catch (Exception ex) { MsgBox.Show(columnname + ex.Message); MsgBox.Show("导入格式不正确!"); } }