private void button2_Click(object sender, EventArgs e)
{
if (this.openFileDialog1.ShowDialog() == DialogResult.OK)
{
this.textBox1.Text = this.openFileDialog1.FileName;
DataTable dt = FileSvr.GetExcelDatatable(this.textBox1.Text, this.openFileDialog1.SafeFileName);
List <CategoryEntity> list = new List <CategoryEntity>();
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
CategoryEntity ca = new CategoryEntity();
ca.Category1 = dr[0].ToString().Trim();
ca.Category2 = dr[1].ToString().Trim();
ca.Category3 = dr[2].ToString().Trim();
list.Add(ca);
}
}
foreach (var item in list)
{
if (!string.IsNullOrEmpty(item.Category1) && !string.IsNullOrEmpty(item.Category2) && !string.IsNullOrEmpty(item.Category3))
{
EC_Category ecca1 = ExcelToCategoryFormsDA.VCategory1(item.Category1);
if (ecca1 == null)
{
CategoryEntity entity1 = ExcelToCategoryFormsDA.AddCategory1(item);
CategoryEntity entity2 = ExcelToCategoryFormsDA.AddCategory2(entity1);
CategoryEntity entity3 = ExcelToCategoryFormsDA.AddCategory3(entity2);
}
else
{
EC_Category ecca2 = ExcelToCategoryFormsDA.VCategory2(item.Category2);
if (ecca2 == null)
{
EC_Category EC_CategoryRelationSysNo = ExcelToCategoryFormsDA.GetEC_CategoryRelationSysNo(item.Category1);
item.ParentCategorySysNo = ecca1.SysNo;
item.ParentSysNo = EC_CategoryRelationSysNo.SysNo;
CategoryEntity entity2 = ExcelToCategoryFormsDA.AddCategory2(item);
CategoryEntity entity3 = ExcelToCategoryFormsDA.AddCategory3(entity2);
}
else
{
EC_Category ecca3 = ExcelToCategoryFormsDA.VCategory3(item.Category3);
if (ecca3 == null)
{
EC_Category EC_CategoryRelationSysNo = ExcelToCategoryFormsDA.GetEC_CategoryRelationSysNo(item.Category2);
item.ParentCategorySysNo = ecca2.SysNo;
item.ParentSysNo = EC_CategoryRelationSysNo.SysNo;
CategoryEntity entity3 = ExcelToCategoryFormsDA.AddCategory3(item);
}
}
}
}
}
this.label2.Text = "上传完成，谢谢使用";
}
}
private void button1_Click(object sender, EventArgs e)
{
List <EC_Category> list = ExcelToCategoryFormsDA.GetEC_CategorySysNoList();
if (list.Count > 0)
{
foreach (var item in list)
{
List <EC_Category> TopSysNolist = ExcelToCategoryFormsDA.GetEC_CategoryTopSysNo(item.SysNo);
List <EC_Category> BottomSysNolist = ExcelToCategoryFormsDA.GetEC_CategoryBottomSysNoList(139510);
string Bottom = null;
if (BottomSysNolist.Count > 0)
{
foreach (var SysNo in BottomSysNolist)
{
Bottom += SysNo.SysNo.ToString() + ',';
}
}
Bottom = Bottom.Trim().TrimEnd(',');
//ExcelToCategoryFormsDA.UpdateEC_CategoryRelationTopAndBottom(TopSysNolist.Count > 0 ? TopSysNolist[0].SysNo.ToString() : null, Bottom, item.SysNo);
}
}
this.label2.Text = "更新完成，谢谢使用";
}
