private void cbbzongtigeshi_SelectedIndexChanged(object sender, EventArgs e)
{
//加载总体格式
DBHelper mydbhelper = new DBHelper(Environment.CurrentDirectory + "\\ruitengdb.db");
mydbhelper.Open();
List <object> list_data = mydbhelper.ExecuteRow("select * from tablesplit where totalname='" + cbbzongtigeshi.Text + "'", null, null);
//加载段落
myflp.Controls.Clear();
foreach (object o in list_data)
{
UCformate2w uce2w = new UCformate2w(o);
uce2w.Dock = DockStyle.Top;
myflp.Controls.Add(uce2w);
}
//加载选中标题
flpfield.Controls.Clear();
Dictionary <string, object> dic = list_data[0] as Dictionary <string, object>;
string[] arr_allfields = dic["allfields"].ToString().Split(new char[] { ',', '，' });
for (int i = 0; i < arr_allfields.Length; i++)
{
Label lbl_field = new Label
{
Text = arr_allfields[i],
TextAlign = ContentAlignment.MiddleCenter,
BorderStyle = BorderStyle.FixedSingle,
Width = 80,
Margin = new Padding(1, 1, 1, 1)
};
lbl_field.Click += Mylbl_Click;
flpfield.Controls.Add(lbl_field);
}
string[] arr_title = dic["titlefields"].ToString().Split(new char[] { ',', '，' });
foreach (Control c in flpfield.Controls)
{
if (arr_title.Contains(c.Text))
{
c.BackColor = Color.SteelBlue;
c.ForeColor = Color.White;
}
}
//foreach (object o in list_data)
//{
// Dictionary<string, object> dic = o as Dictionary<string, object>;
// cbbzongtigeshi.Items.Add(dic["totalname"]);
//}
mydbhelper.Close();
}
private void cbbzongtigeshi_TextChanged(object sender, EventArgs e)
{
//加载总体格式
//List<object> list_data = myMySqlHelper.ExecuteRow("select * from tablesplit where totalname='" + cbbzongtigeshi.Text + "'", null, null);
Dictionary <string, object> mydic = new Dictionary <string, object> {
{ "totalname", cbbzongtigeshi.Text }
};
var list_data = _mycontroller._sqlhelper.GetAnySet("tablesplit", mydic);
//加载段落
myflp.Controls.Clear();
foreach (object o in list_data)
{
UCformate2w uce2w = new UCformate2w(o);
uce2w.Dock = DockStyle.Top;
myflp.Controls.Add(uce2w);
}
//加载选中标题
flpfield.Controls.Clear();
if (list_data.Count == 0)
{
return;
}
Dictionary <string, object> dic = list_data[0] as Dictionary <string, object>;
string[] arr_allfields = dic["alltitle"].ToString().Split(new char[] { ',', '，' });
for (int i = 0; i < arr_allfields.Length; i++)
{
Label lbl_field = new Label
{
Text = arr_allfields[i],
TextAlign = ContentAlignment.MiddleCenter,
BorderStyle = BorderStyle.FixedSingle,
Width = 80,
Margin = new Padding(1, 1, 1, 1)
};
lbl_field.Click += Mylbl_Click;
flpfield.Controls.Add(lbl_field);
}
string[] arr_title = dic["titlefields"].ToString().Split(new char[] { ',', '，' });
foreach (Control c in flpfield.Controls)
{
if (arr_title.Contains(c.Text))
{
c.BackColor = Color.SteelBlue;
c.ForeColor = Color.White;
}
}
}
private void lblconvert_Click(object sender, EventArgs e)
{
//判断输出路径是否存在
string importpath = tbcunfang.Text;
if (!Directory.Exists(importpath))
{
MessageBox.Show("保存路径不存在！");
return;
}
// UpdateStatue("正在提取文本格式……");
/*识别所有的mycu*/
UCformate2w myuc = null;
for (int i = 0; i < myflp.Controls.Count; i++)
{
myuc = new UCformate2w();
myuc = ((UCformate2w)myflp.Controls[i]);
myuc.mysetter = new Model.setter();
//给myuc的setter赋值
for (int j = 0; j < myuc.flp.Controls.Count; j++)
{
Label mylbl0 = ((Label)myuc.flp.Controls[j]);
if (mylbl0.BackColor == Color.SteelBlue)
{
myuc.mysetter.listcolumn.Add(mylbl0.TabIndex);
}
}
//myuc.mysetter.listcolumn = GetContent(tbfilename.Text, rowindex, myuc);
myuc.mysetter.hangjustyle = myuc.cbblinespace.Text;
myuc.mysetter.hangjuvalue = Convert.ToSingle(myuc.nudlinespace.Value);
myuc.mysetter.fontname = myuc.tbfontname.Text;
myuc.mysetter.fontsize = Convert.ToSingle(myuc.nudfontsize.Value);
myuc.mysetter.juzhong = myuc.cbbposition.Text;
myuc.mysetter.bold = myuc.cbbold.Checked ? 1 : 0;
myuc.mysetter.suojin = Convert.ToSingle(myuc.nudsuojin.Value);
myuc.mysetter.konghang = Convert.ToInt32(myuc.cbbkonghang.Text);
//把uc提取到集合中
Global.list_myuc.Add(myuc);
}
//接收选中的列用于文件名
Label mylbl = null;
for (int i = 0; i < flpfield.Controls.Count; i++)
{
mylbl = ((Label)flpfield.Controls[i]);
if (mylbl.BackColor == Color.SteelBlue)
{
Global.listfilename.Add(mylbl.TabIndex);
}
}
Thread t = null;
for (int m = 0; m < dgv_task.Rows.Count; m++)
{
try
{
while (t.ThreadState == ThreadState.Running)
{
Application.DoEvents();
}
}
catch { }
t = new Thread(CreateDocument);
t.Name = "thread_" + m;
t.Start(Global.list_splitfiles[m]);
}
/*提示完成*/
UpdateStatue("版权所有 深圳前海极简信息咨询服务有限公司！");
}
