private void InsertLineData1() { //LayoutList lla = this.ctrlLayoutList1.FocusedObject; //if (lla == null) // return; if (selectid == "") return; try { DataTable dts = new DataTable(); OpenFileDialog op = new OpenFileDialog(); op.Filter = "Excel�ļ�(*.xls)|*.xls"; if (op.ShowDialog() == DialogResult.OK) { dts = GetExcel(op.FileName); IList<Line_Info> lii = new List<Line_Info>(); DateTime s8 = DateTime.Now; for (int i = 0; i < dts.Rows.Count; i++) { if (dts.Rows[i][1].ToString().IndexOf("�ϼ�") >= 0) continue; Line_Info l1 = new Line_Info(); foreach(DataColumn dc in dts.Columns) { if (dc.ColumnName == "L1") { int LL1 = 0; try { LL1 = Convert.ToInt32(dts.Rows[i]["L1"].ToString()); } catch { } l1.L1 = LL1; l1.DY = LL1; l1.K1 = LL1; } else if (dc.ColumnName == "L5") { double LL2 = 0; try { LL2 = Convert.ToDouble(dts.Rows[i]["L5"].ToString()); } catch { } l1.L5 = LL2; } else if (dc.ColumnName == "L6") { //DateTime LL3 = DateTime.Now; //try //{ // LL3 = Convert.ToDateTime(dts.Rows[i]["L6"].ToString()); //} //catch { } l1.L6 = dts.Rows[i]["L6"].ToString(); } else if (dc.ColumnName == "K1") { continue; } else { l1.GetType().GetProperty(dc.ColumnName).SetValue(l1, dts.Rows[i][dc.ColumnName].ToString(), null); } } l1.Flag = selectid; l1.CreateDate = s8.AddSeconds(i); l1.AreaID = ProjectUID; lii.Add(l1); } foreach (Line_Info lll in lii) { Line_Info l1 = new Line_Info(); // l1.AreaName = lll.AreaName; l1.Title = lll.Title; l1.Flag = selectid; l1.DY = lll.DY; try { int tx = int.Parse(l1.L6); if (tx > DateTime.Now.Year) l1.Flag = "2"; else l1.Flag = "1"; } catch { l1.Flag = "1"; } string conn = "Title='" + lll.Title + "' and Flag='" + l1.Flag + "' and DY='" + lll.DY + "'"; object obj = Services.BaseService.GetObject("SelectLine_InfoByConn", conn); if (obj != null) { lll.UID = ((Line_Info)obj).UID; lll.Code = ((Line_Info)obj).Code; Services.BaseService.Update<Line_Info>(lll); } else { lll.UID += "|" + ProjectUID; Services.BaseService.Create<Line_Info>(lll); } } this.ctrlLine_Info1.RefreshData(selectid); } } catch (Exception ex) { MsgBox.Show(ex.Message); MsgBox.Show("�����ʽ����ȷ��"); } }
private void InsertLineData2() { //LayoutList lla = this.ctrlLayoutList1.FocusedObject; //if (lla == null) // return; if (selectid == "") 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<Line_Info> lii = new List<Line_Info>(); DateTime s8 = DateTime.Now; for (int i = 0; i < dts.Rows.Count; i++) { if (dts.Rows[i][1].ToString().IndexOf("�ϼ�") >= 0) continue; Line_Info l1 = new Line_Info(); foreach (DataColumn dc in dts.Columns) { columnname = dc.ColumnName; switch (dc.ColumnName) { case "DY": case "L1": case "K1": int LL1 = 0; try { LL1 = Convert.ToInt32(dts.Rows[i][dc.ColumnName].ToString()); } catch { } l1.L1 = LL1; l1.DY = LL1; l1.K1 = LL1; break; case "K4": case "K5": case "K6": case "K7": case "K16": case "K17": case "K18": case "K19": case "K20": case "K21": 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 "K8": case "K9": case "K10": case "K11": case "K12": case "K13": case "K14": case "K15": 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.L6 = DateTime.Now; lii.Add(l1); } foreach (Line_Info lll in lii) { Line_Info l1 = new Line_Info(); l1.AreaName = lll.AreaName; l1.Title = lll.Title; l1.Flag = selectid; object obj = Services.BaseService.GetObject("SelectLine_InfoByNameFlag", l1); if (obj != null) { lll.UID = ((Line_Info)obj).UID; lll.Code = ((Line_Info)obj).Code; Services.BaseService.Update<Line_Info>(lll); } else { Services.BaseService.Create<Line_Info>(lll); } } this.ctrlLine_Info1.RefreshData(selectid); } } catch (Exception ex) { MsgBox.Show(columnname+ex.Message); MsgBox.Show("�����ʽ����ȷ��"); } }
private void InsertLineData1() { try { DataTable dts = new DataTable(); OpenFileDialog op = new OpenFileDialog(); op.Filter = "Excel�ļ�(*.xls)|*.xls"; if (op.ShowDialog() == DialogResult.OK) { dts = GetExcel(op.FileName); IList<Line_Info> lii = new List<Line_Info>(); DateTime s8 = DateTime.Now; for (int i = 1; i < dts.Rows.Count; i++) { if (dts.Rows[i][1].ToString().IndexOf("�ϼ�") >= 0) continue; Line_Info l1 = new Line_Info(); foreach (DataColumn dc in dts.Columns) { if (dc.ColumnName == "L1") { int LL1 = 0; try { LL1 = Convert.ToInt32(dts.Rows[i]["L1"].ToString()); } catch { } l1.L1 = LL1; l1.DY = LL1; l1.K1 = LL1; } else if (dc.ColumnName == "L5") { double LL2 = 0; try { LL2 = Convert.ToDouble(dts.Rows[i]["L5"].ToString()); } catch { } l1.L5 = LL2; } else if (dc.ColumnName == "L6") { //DateTime LL3 = DateTime.Now; //try //{ // LL3 = Convert.ToDateTime(dts.Rows[i]["L6"].ToString()); //} //catch { } l1.L6 = dts.Rows[i]["L6"].ToString(); } else if (dc.ColumnName == "K1") { continue; } else { l1.GetType().GetProperty(dc.ColumnName).SetValue(l1, dts.Rows[i][dc.ColumnName].ToString(), null); } } l1.Flag = "1"; l1.CreateDate = s8.AddSeconds(i); lii.Add(l1); } foreach (Line_Info lll in lii) { Line_Info l1 = new Line_Info(); l1.AreaName = lll.AreaName; l1.Title = lll.Title; l1.Flag = "1"; object obj = Services.BaseService.GetObject("SelectLine_InfoByNameFlag", l1); if (obj != null) { lll.UID = ((Line_Info)obj).UID; Services.BaseService.Update<Line_Info>(lll); } else { Services.BaseService.Create<Line_Info>(lll); } } this.ctrlLine_Info1.RefreshData(); } } catch (Exception ex) { MsgBox.Show(ex.Message); MsgBox.Show("�����ʽ����ȷ��"); } }