private void btnNextMulTable_Click(object sender, EventArgs e) { List <string> tableList = new List <string>(); if (connect != null && lstTables.SelectedItems.Count > 0) { foreach (ListViewItem item in lstTables.SelectedItems) { tableList.Add(item.Text); } } if (tableList.Count > 0) { Cache_Next.InitDbName(PageCache.DatabaseName); Cache_Next.InitTables(tableList); foreach (var tbName in tableList) { var list = connect.GetColumnsList(server, name, pwd, port, dbname, tbName); Cache_Next.AddColumnList(tbName, list); } AspNetCoreHelper.Init(); this.Invoke(new Action <TabControl>(p => { int mulIndex = 2; p.TabPages.RemoveAt(0); p.TabPages.AddRange(new TabPage[] { cache_tabPageList[mulIndex] }); }), this.tabControl1); } else { MessageBox.Show("请先选中至少一张表."); } }
public static void Init(string guid) { AspNetHelper.guid = guid; db_name = Cache_Next.GetDbName(); tableList = Cache_Next.GetTableList(); tbDic = Cache_Next.GetColumnAll(); }
public static SqlColumnInfo GetDeleteColumnNameAndValue(string table_name, List <SqlColumnInfo> current) { List <SqlColumnInfo> result = new List <SqlColumnInfo>(); var tbInfo = dataList.Find(p => p.db_name == Cache_Next.GetDbName() && p.type == 0); if (tbInfo != null) { if (tbInfo.extendInfo != null && tbInfo.extendInfo.type == 0 && tbInfo.extendInfo.v1 == 1) { var item = current.Find(p => p.Name == tbInfo.extendInfo.name); if (item != null) { SqlColumnInfo col = new SqlColumnInfo() { Name = item.Name, DefaultValue = tbInfo.extendInfo.value }; return(col); } } } return(null); }
public static List <SqlColumnInfo> GetVMList(string table_name, VMType vmType, List <SqlColumnInfo> current) { List <SqlColumnInfo> result = new List <SqlColumnInfo>(); var tbInfo = dataList.Find(p => p.db_name == Cache_Next.GetDbName() && p.table_name == table_name); if (tbInfo == null || (vmType == VMType.Add && tbInfo.add_list.Count == 0) || (vmType == VMType.Edit && tbInfo.edit_list.Count == 0) || (vmType == VMType.Query && tbInfo.query_list.Count == 0)) { var info = dataList.Find(p => p.db_name == Cache_Next.GetDbName() && p.type == 0); if (info == null) { return(current); } else { if (vmType == VMType.Add) { return(current.FindAll(p => !info.add_list.Contains(p.Name))); } else if (vmType == VMType.Edit) { return(current.FindAll(p => !info.edit_list.Contains(p.Name))); } else { return(current.FindAll(p => !info.query_list.Contains(p.Name))); } } } else { if (vmType == VMType.Add) { return(current.FindAll(p => tbInfo.add_list.Contains(p.Name))); } else if (vmType == VMType.Edit) { return(current.FindAll(p => tbInfo.edit_list.Contains(p.Name))); } else { return(current.FindAll(p => tbInfo.query_list.Contains(p.Name))); } } }
public static List <SqlColumnInfo> GetAddCheckList(string table_name, List <SqlColumnInfo> current) { List <SqlColumnInfo> result = new List <SqlColumnInfo>(); var tbInfo = dataList.Find(p => p.db_name == Cache_Next.GetDbName() && p.table_name == table_name); if (tbInfo == null || tbInfo.add_check_list.Count == 0) { return(result); } else { var equalList = tbInfo.add_check_list.FindAll(p => p.Contains("=")); var paramsList = tbInfo.add_check_list.FindAll(p => !p.Contains("=")); var list = current.FindAll(p => paramsList.Contains(p.Name)); foreach (var item in equalList) { string[] key = item.Split(new char[] { '=' }, StringSplitOptions.RemoveEmptyEntries); if (key.Length == 2) { // 处理有值的情况 var col = current.Find(p => p.Name == key[0]); if (col != null) { col.TempValue = key[1]; result.Add(col); } } } foreach (var item in paramsList) { var col = current.Find(p => p.Name == item); if (col != null) { result.Add(col); } } return(result); } }
public static void Init() { db_name = Cache_Next.GetDbName(); tableList = Cache_Next.GetTableList(); tbDic = Cache_Next.GetColumnAll(); }