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();
}
