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 = "更新完成,谢谢使用"; }