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("�����ʽ����ȷ��"); }
}
