//点击复制发布规则按钮
private void btnCopyPubConfig_Click(object sender, EventArgs e)
{
try
{
ListViewItem checkedItem = listViewPublish.CheckedItems[0];
long pubID = long.Parse(checkedItem.SubItems[0].Text);
string pubName = checkedItem.SubItems[1].Text;
mySqlDB myDB = new mySqlDB(_coConnString);
string sResult = "";
int count = 0;
long LastInsertedId;
string sql = "insert into pub_config(pub_name,co_typeid,co_typename,pub_typeid,pub_typename,pub_nums,random_date_start,random_date_stop)";
sql = sql + " select pub_name,co_typeid,co_typename,pub_typeid,pub_typename,pub_nums,random_date_start,random_date_stop";
sql = sql + " from pub_config where id = '" + pubID.ToString() + "'";
count = myDB.executeDMLSQL(sql, ref sResult);
if (sResult == mySqlDB.SUCCESS && count == 1)
{
LastInsertedId = myDB.LastInsertedId;
MessageBox.Show(string.Format("复制成功！复制的发布规则ID为：{0}", LastInsertedId));
string sqlRename = "update pub_config set pub_name = '" + pubName + "复件'" + " where id ='" + LastInsertedId.ToString() + "'";
count = myDB.executeDMLSQL(sqlRename, ref sResult);
loadPubConfig();
}
else
{
MessageBox.Show(string.Format("复制失败：{0}", sResult));
}
}
catch (Exception ex)
{
MessageBox.Show("请选择需要复制的发布规则项！");
}
}
//复制采集规则
private void btnCopyCoconfig_Click(object sender, EventArgs e)
{
try
{
ListViewItem checkedItem = listViewCollect.CheckedItems[0];
long cid = long.Parse(checkedItem.SubItems[0].Text);
string coName = checkedItem.SubItems[1].Text;
mySqlDB myDB = new mySqlDB(_coConnString);
string sResult = "";
int count = 0;
long LastInsertedId;
string sql = "insert into co_config(co_name,type_name,source_lang,source_site,co_offline,list_path,more_list_pages,xpath_arcurl_node,";
sql = sql + " xpath_title_node,xpath_content_node,arc_subpage_symbol,arc_subpage_startnum,sub_node_params,regex_params) ";
sql = sql + " select co_name,type_name,source_lang,source_site,co_offline,list_path,more_list_pages,xpath_arcurl_node,";
sql = sql + "xpath_title_node,xpath_content_node,arc_subpage_symbol,arc_subpage_startnum,sub_node_params,regex_params";
sql = sql + " from co_config where cid = '" + cid.ToString() + "'";
count = myDB.executeDMLSQL(sql, ref sResult);
if (sResult == mySqlDB.SUCCESS && count == 1)
{
LastInsertedId = myDB.LastInsertedId;
MessageBox.Show(string.Format("复制成功！复制的采集规则ID为：{0}", LastInsertedId));
string sqlRename = "update co_config set co_name = '" + coName + "复件'" + " where cid ='" + LastInsertedId.ToString() + "'";
count = myDB.executeDMLSQL(sqlRename, ref sResult);
loadCoConfig();
}
else
{
MessageBox.Show(string.Format("复制失败：{0}", sResult));
}
}
catch (Exception ex)
{
MessageBox.Show("请选择需要复制的采集规则项！");
}
}