public bool UpdateColumns(string filePath) { DataTable distinct = MyXlsHelper.GetData(filePath).Tables[0]; if (distinct == null) { return(false); } if (distinct.Columns.Contains("字段名称") && distinct.Columns.Contains("字段说明")) { DataTable dt = BLLFactory.Instance.idb.GetTablesColumnsList(Utils.dbName, ""); foreach (DataRow dict in distinct.Rows) { string dicoumName = dict["字段名称"].ToString(); string dicoumInfo = dict["字段说明"].ToString(); foreach (DataRow row in dt.Rows) { string tableName = row["表名"].ToString(); string columnName = row["字段名"].ToString().Trim().ToLower(); string columnInfoInfo = row["字段说明"].ToString(); if (dicoumName.Equals(columnName)) { if (!string.IsNullOrEmpty(columnInfoInfo)) { //存在就更新 BLLFactory.Instance.idb.ExtendedProperty(false, dicoumInfo, tableName, columnName); } else { BLLFactory.Instance.idb.ExtendedProperty(true, dicoumInfo, tableName, columnName); } } } } return(true); } else { // MessageBox.Show("xls文件里面必须包含 字段名称,字段说明 这两列,并且文件工作表的名字必须是Sheet1$ "); return(false); } }
private void 导出数据库里相同的字段ToolStripMenuItem_Click(object sender, EventArgs e) { try { if (MessageBox.Show("导出数据库里相同的字段", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes) { DataTable table = BLLFactory.Instance.idb.GetEqualColumnsList(Utils.dbName); MyXlsHelper.LeadOutToExcel(table); } else { DataTable table = BLLFactory.Instance.idb.GetTablesColumnsList("", Utils.dbName); MyXlsHelper.LeadOutToExcel(table); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }