private void UpdateView(JJGeshiInfo jj)
{
//刷新界面显示
cbb_geshimingcheng.Text = jj._mingcheng;
cbb_chachongku.Text = jj._chachongku;
tb_zhengwenchongfulujing.Text = jj._zhengwenchongfulujing;
cb_quanwenchachong.Checked = Convert.ToBoolean(jj._quanwenchachong);
cb_zhengwenchachong.Checked = Convert.ToBoolean(jj._zhengwenchachong);
cb_biaozhunduanchachong.Checked = Convert.ToBoolean(jj._biaozhunduanchachong);
cb_biaozhunjuchachong.Checked = Convert.ToBoolean(jj._biaozhunjuchachong);
cb_quanwenruku.Checked = Convert.ToBoolean(jj._quanwenruku);
cb_zhengwenruku.Checked = Convert.ToBoolean(jj._zhengwenruku);
cb_biaozhunduanruku.Checked = Convert.ToBoolean(jj._biaozhunduanruku);
cb_biaozhunjuruku.Checked = Convert.ToBoolean(jj._biaozhunjuruku);
//百分比设置
panel1.Controls.Clear();
JJBaifenbiList jjb = JsonConvert.DeserializeObject <JJBaifenbiList>(jj._baifenbishezhi);
foreach (JJBaifenbi b in jjb.list_baifenbi)
{
JJUCbairfenbi myuc = new JJUCbairfenbi(b)
{
Dock = DockStyle.Top
};
panel1.Controls.Add(myuc);
//panel1.Controls.SetChildIndex(myuc, 0);
}
}
/// <summary>
/// 删除格式
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public bool DeleteFormat(JJGeshiInfo info)
{
string str_sql = $"update 查重工具库.格式信息表 set 删除=1 where 名称='{info._mingcheng}' and 删除=0";
int num = _mysql.ExecuteNonQuery(str_sql);
return(num > 0 ? true : false);
}
private void cbb_geshimingcheng_TextChanged(object sender, EventArgs e)
{
try
{
//获得jjgeshiinof 类
JJGeshiInfo info = _myc.GetGeshiInfo(cbb_geshimingcheng.Text);
//刷新界面显示
UpdateView(info);
}
catch { }
}
/// <summary>
/// 保存格式信息
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public bool SaveFormat(JJGeshiInfo info)
{
string str_sql = $"delete from 查重工具库.格式信息表 where 名称='{info._mingcheng}' and 删除=0";
_mysql.ExecuteNonQuery(str_sql);
str_sql = $"insert into 查重工具库.格式信息表 values('{info._mingcheng}','{info._chachongku}',@zhengwenlujing," +
$"'{info._quanwenchachong}','{info._zhengwenchachong}','{info._biaozhunduanchachong}'," +
$"'{info._biaozhunjuchachong}','{info._quanwenruku}','{info._zhengwenruku}','{info._biaozhunduanruku}'," +
$"'{info._biaozhunjuruku}',@baifenbi,'0')";
int num = _mysql.ExecuteNonQuery(str_sql, new MySqlParameter[] {
new MySqlParameter("@zhengwenlujing", info._zhengwenchongfulujing),
new MySqlParameter("@baifenbi", info._baifenbishezhi)
});;
return(num > 0 ? true : false);
}
/// <summary>
/// 点击删除按钮式触发的事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button3_Click(object sender, EventArgs e)
{
//构造一个jjgeshiinfo
JJGeshiInfo info = new JJGeshiInfo()
{
_mingcheng = cbb_geshimingcheng.Text
};
//删除格式
bool b = _myc.DeleteFormat(info);
if (b)
{
MessageBox.Show("格式已删除！");
//刷新界面数据
cbb_geshimingcheng.SelectedIndex = 0;
}
}
/// <summary>
/// 点击保存格式按钮式触发的事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button2_Click(object sender, EventArgs e)
{
string formatname = cbb_geshimingcheng.Text;
//构造一个jjgeshiinfo
JJGeshiInfo info = new JJGeshiInfo()
{
_mingcheng = cbb_geshimingcheng.Text,
_chachongku = cbb_chachongku.Text,
//_quanwenchongfulujing = tb_quanwenchongfulujing.Text,
_zhengwenchongfulujing = tb_zhengwenchongfulujing.Text,
_quanwenchachong = Convert.ToInt32(cb_quanwenchachong.Checked),
_zhengwenchachong = Convert.ToInt32(cb_zhengwenchachong.Checked),
_biaozhunduanchachong = Convert.ToInt32(cb_biaozhunduanchachong.Checked),
_biaozhunjuchachong = Convert.ToInt32(cb_biaozhunjuchachong.Checked),
_quanwenruku = Convert.ToInt32(cb_quanwenruku.Checked),
_zhengwenruku = Convert.ToInt32(cb_zhengwenruku.Checked),
_biaozhunduanruku = Convert.ToInt32(cb_biaozhunduanruku.Checked),
_biaozhunjuruku = Convert.ToInt32(cb_biaozhunjuruku.Checked)
};
JJBaifenbiList mylist = new JJBaifenbiList();
mylist.list_baifenbi = new List <JJBaifenbi>();
//构造json格式的百分比设置
foreach (UserControl uc in panel1.Controls)
{
JJUCbairfenbi myuc = uc as JJUCbairfenbi;
mylist.list_baifenbi.Add(myuc._myb);
}
string json_baifenbi = JsonConvert.SerializeObject(mylist);
info._baifenbishezhi = json_baifenbi;
//保存数据
bool b = _myc.SaveFormat(info);
if (b)
{
MessageBox.Show("格式已保存！");
}
//刷新界面数据,切换一下选中的文格式名称
//cbb_chachongku.Text = string.Empty;
//cbb_chachongku.Text = formatname;
}
/// <summary>
/// 根据格式名称获得格式信息类
/// </summary>
/// <param name="s"></param>
/// <returns></returns>
public JJGeshiInfo GetGeshiInfo(string s)
{
string str_sql = $"select * from 查重工具库.格式信息表 where 名称='{s}' and 删除=0";
DataRow dr = _mysql.ExecuteDataRow(str_sql);
JJGeshiInfo j = new JJGeshiInfo()
{
_mingcheng = dr["名称"].ToString(),
_chachongku = dr["查重库"].ToString(),
_zhengwenchongfulujing = dr["正文重复路径"].ToString(),
_quanwenchachong = Convert.ToInt32(dr["全文查重"].ToString()),
_zhengwenchachong = Convert.ToInt32(dr["正文查重"].ToString()),
_biaozhunduanchachong = Convert.ToInt32(dr["标准段查重"].ToString()),
_biaozhunjuchachong = Convert.ToInt32(dr["标准句查重"].ToString()),
_quanwenruku = Convert.ToInt32(dr["全文入库"].ToString()),
_zhengwenruku = Convert.ToInt32(dr["正文入库"].ToString()),
_biaozhunduanruku = Convert.ToInt32(dr["标准段入库"].ToString()),
_biaozhunjuruku = Convert.ToInt32(dr["标准句入库"].ToString()),
_baifenbishezhi = dr["百分比设置"].ToString()
};
return(j);
}
