private void VMSettingFrm_Load(object sender, EventArgs e)
{
// 移除模板（仅供观看）
this.tabControl1.TabPages.RemoveAt(1);
var tbList = Cache_Next.GetTableList();
foreach (var item in tbList)
{
TabPage tb = CreateTabPage(Cache_Next.GetColumnList(item));
tb.Text = item;
this.tabControl1.TabPages.Add(tb);
}
LoadSetting();
}
private void btnSaveAll_Click(object sender, EventArgs e)
{
List <VMDataInfo> list = new List <VMDataInfo>();
int index = 0;
foreach (TabPage tb in this.tabControl1.TabPages)
{
if (index == 0)
{
var commonVM = new VMDataInfo()
{
db_name = Cache_Next.GetDbName(), type = 0
};
commonVM.add_list.AddRange(this.txtAddExcept.Text.Split(new char[] { '\r', '\n' }, StringSplitOptions.RemoveEmptyEntries));
commonVM.edit_list.AddRange(this.txtEditExcept.Text.Split(new char[] { '\r', '\n' }, StringSplitOptions.RemoveEmptyEntries));
commonVM.query_list.AddRange(this.txtQueryExcept.Text.Split(new char[] { '\r', '\n' }, StringSplitOptions.RemoveEmptyEntries));
commonVM.extendInfo = new VMDataExtendInfo();
commonVM.extendInfo.type = 0;
commonVM.extendInfo.v1 = this.rbtnDelete1.Checked ? 0 : 1;
commonVM.extendInfo.name = this.txtDeleteColName.Text;
commonVM.extendInfo.value = this.txtDeleteColValue.Text;
list.Add(commonVM);
}
else
{
var tableVM = new VMDataInfo()
{
db_name = Cache_Next.GetDbName(), type = 1, table_name = tb.Text
};
tableVM.add_list.AddRange((tb.Controls[1] as TextBox).Text.Split(new char[] { '\r', '\n' }, StringSplitOptions.RemoveEmptyEntries));
tableVM.edit_list.AddRange((tb.Controls[2] as TextBox).Text.Split(new char[] { '\r', '\n' }, StringSplitOptions.RemoveEmptyEntries));
tableVM.query_list.AddRange((tb.Controls[3] as TextBox).Text.Split(new char[] { '\r', '\n' }, StringSplitOptions.RemoveEmptyEntries));
if ((tb.Controls[4] as CheckBox).Checked)
{
tableVM.add_check_list.AddRange((tb.Controls[5] as TextBox).Text.Split(new char[] { '\r', '\n' }, StringSplitOptions.RemoveEmptyEntries));
}
list.Add(tableVM);
}
index++;
}
Cache_VMData.SaveData(list);
}
private void LoadSetting()
{
var list = Cache_VMData.LoadData();
int index = 0;
foreach (TabPage tb in this.tabControl1.TabPages)
{
if (index == 0)
{
var model = list.Find(p => p.db_name == Cache_Next.GetDbName() && p.type == 0);
if (model != null)
{
this.txtAddExcept.Text = string.Join("\r\n", model.add_list.ToArray());
this.txtEditExcept.Text = string.Join("\r\n", model.edit_list.ToArray());
this.txtQueryExcept.Text = string.Join("\r\n", model.query_list.ToArray());
if (model.extendInfo != null)
{
if (model.extendInfo.type == 0)
{
this.rbtnDelete2.Checked = model.extendInfo.v1 == 1;
this.txtDeleteColName.Text = model.extendInfo.name ?? "";
this.txtDeleteColValue.Text = model.extendInfo.value ?? "";
}
}
}
}
else
{
var model = list.Find(p => p.db_name == Cache_Next.GetDbName() && p.type == 1 && p.table_name == tb.Text);
if (model != null)
{
(tb.Controls[1] as TextBox).Text = string.Join("\r\n", model.add_list.ToArray());
(tb.Controls[2] as TextBox).Text = string.Join("\r\n", model.edit_list.ToArray());
(tb.Controls[3] as TextBox).Text = string.Join("\r\n", model.query_list.ToArray());
if (model.add_check_list.Count > 0)
{
(tb.Controls[5] as TextBox).Text = string.Join("\r\n", model.add_check_list.ToArray());
(tb.Controls[4] as CheckBox).Checked = true;
}
}
}
index++;
}
}
