private void PushToWeb()
{
NC_Version_Num version = new NC_Version_Num(); //保存版本信息的jason字符串
Data_json data_info = new Data_json(); //上传WEB SERVICE的一级数据结构
Data_Identity_info data_idten = new Data_Identity_info(); //上传WEB SERVICE的二级数据结构
string jsonIdentity = ""; //最终上传WEB 的JSON字符串
version.strNC_Version_Num_1 = newnc.strNC_Version_Num_1;
version.strNC_Version_Num_2 = newnc.strNC_Version_Num_2;
version.strNC_Version_Num_3 = newnc.strNC_Version_Num_3;
version.strNC_Version_Num_4 = newnc.strNC_Version_Num_4;
version.strNC_Version_Num_5 = newnc.strNC_Version_Num_5;
string strversion = WebSreverce_PostJson.ConvertToJson(version);
data_idten.id = newnc.strNC_ID;
data_idten.tp = newnc.strNC_Num;
data_idten.ver = strversion;
strversion = WebSreverce_PostJson.ConvertToJson(data_idten);
data_info.dt = strversion;
data_info.did = Constants.IDENTITY;
jsonIdentity = WebSreverce_PostJson.ConvertToJson(data_info);
string reponce = WebSreverce_PostJson.Post_Jsonstr(WebSreverce_PostJson.urladd_inn, jsonIdentity); //url表示数据服务器的地址及接口名称，可以定义成全局变量
//Console.WriteLine(reponce);
if (reponce == "ac")
{
Console.WriteLine(jsonIdentity);
this.Test.BackColor = Color.WhiteSmoke;;
//返回值正确，服务器收到了请求
MessageBox.Show("Web服务器注册成功");
reset_Click();
}
else
{
MessageBox.Show("注册失败，请检查与Web服务器的连接");
reset_Click();
}
}
private void pushdata_Click(object sender, EventArgs e)
{
if (db_tblist.SelectedItems.Count == 0)
{
MessageBox.Show("请选中数据表再上传！");
}
else
{
if (MessageBox.Show("确定上传选中数据表吗？", "警告", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning) == DialogResult.OK)
{
if (db_tblist.SelectedItems[0].Text == "运行数据表")
{
if (tb_count[0] == 0)
{
MessageBox.Show("数据表为空，不需要上传");
}
else
{
db_progressBar.Value = 1;
db_progressBar.Minimum = 0;
db_progressBar.Maximum = tb_count[0];
for (int i = 0; tb_count[0] - 3 * i > 0; i++)
{
List <Data_Run_info> result;
DataBase pdata = new DataBase();
/*MySqlDataReader to list */
string comm3 = "select id,cas,ccs,aload,aspd1,aspd2,aspd3,aspd4,aspd5,apst1,apst2,apst3,apst4,apst5,cpst1,cpst2,cpst3,cpst4,cpst5,load1,load2,load3,load4,load5,pd,pn,ps,pl,pm,time from tb_runstate limit 10 "; //获取前2000条数据,其中数据数据项名称必须与要转换的LIst数据项名称一样，否则无法正确赋值
MySqlConnection Conn = new MySqlConnection(pdata.M_str_sqlcon);
Conn.Open();
MySqlCommand cmd = new MySqlCommand(comm3, Conn);
MySqlDataReader reader = cmd.ExecuteReader();
//MySqlDataReader reader = pdata.Select(comm3);
result = DataBase.Fabricate.FillList <Data_Run_info>(reader);
/*close the connection*/
reader.Close();
Conn.Close();
/*list to json string*/
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
String listStr = JsonConvert.SerializeObject(result, Formatting.None, timeConverter);
/*进一步转换数据*/
Data_json data_info = new Data_json();
data_info.dt = listStr; //打包发送
data_info.did = Constants.RUNSTATE;
/*push data*/
listStr = WebSreverce_PostJson.ConvertToJson(data_info);
string reponce = WebSreverce_PostJson.Post_Jsonstr(WebSreverce_PostJson.urladd_inn, listStr); //url表示数据服务器的地址及接口名称，可以定义成全局变量
// Console.WriteLine(reponce);
if (reponce == "ac")
{
//Console.WriteLine(rundata);
//返回值正确，服务器收到了请求,执行删除数据库数据的操作
MySqlConnection sqlcon = new MySqlConnection(pdata.M_str_sqlcon);
sqlcon.Open();
string comm4 = " delete from tb_runstate limit 10 "; //获取前2000条数据
pdata.Delete(sqlcon, comm4);
sqlcon.Close();
/*操作Processbar*/
if (db_progressBar.Value + 3 <= db_progressBar.Maximum)
{
db_progressBar.Value += 3;
this.pbar_state.Text = "进行中 [" + db_progressBar.Value.ToString() + "/" + db_progressBar.Maximum + "]....";
}
else
{
this.pbar_state.Text = "上传已完成！";
if (MessageBox.Show("上传完成！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information) == DialogResult.OK)
{
return;
}
}
}
else
{
if (MessageBox.Show("与Web服务器连接异常，请检查后重试！", "警告", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning) == DialogResult.OK)
{
break;
}
}
}
}
}
if (db_tblist.SelectedItems[0].Text == "登入登出表")
{
if (db_tblist.SelectedItems[0].SubItems[1].Text == "0")
{
MessageBox.Show("数据表为空，不需要上传");
}
else
{
db_progressBar.Value = 1;
db_progressBar.Minimum = 0;
db_progressBar.Maximum = tb_count[1];
for (int i = 0; tb_count[1] - i > 0; i++)
{
/*采用单条数据上传*/
Data_LogIn_info temp = new Data_LogIn_info();
DataBase pdata = new DataBase();
string comm3 = "select * from tb_login limit 1 "; //获取1条数据
MySqlDataReader reader = pdata.Select(comm3);
temp.id = reader[1].ToString();
temp.ontime = (long)Int32.Parse(reader[2].ToString());
temp.runtime = (long)Int32.Parse(reader[3].ToString());
temp.time = reader[4].ToString();
/*close the connection*/
reader.Close();
pdata.con_close();
/*进一步打包数据，转json*/
string rundata = WebSreverce_PostJson.ConvertToJson(temp);
Data_json data_info = new Data_json();
data_info.dt = rundata;
data_info.did = Constants.LOGIN;
rundata = WebSreverce_PostJson.ConvertToJson(data_info);
string reponce = WebSreverce_PostJson.Post_Jsonstr(WebSreverce_PostJson.urladd_inn, rundata); //url表示数据服务器的地址及接口名称，可以定义成全局变量
if (reponce == "ac")
{
//Console.WriteLine(rundata);
//返回值正确，服务器收到了请求
MySqlConnection sqlcon = new MySqlConnection(pdata.M_str_sqlcon);
sqlcon.Open();
string comm4 = " delete from tb_login limit 1 "; //获取前1条数据
pdata.Delete(sqlcon, comm4);
sqlcon.Close();
/*操作Processbar*/
if (db_progressBar.Value < db_progressBar.Maximum)
{
db_progressBar.Value += 1;
this.pbar_state.Text = "上传进行中 [" + db_progressBar.Value.ToString() + "/" + db_progressBar.Maximum + "]....";
}
else
{
this.pbar_state.Text = "上传已完成！";
if (MessageBox.Show("上传完成！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information) == DialogResult.OK)
{
return;
}
}
}
else
{
if (MessageBox.Show("与Web服务器连接异常，请检查后重试！", "警告", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning) == DialogResult.OK)
{
return;
}
}
}
}
}
if (db_tblist.SelectedItems[0].Text == "报警表")
{
if (db_tblist.SelectedItems[0].SubItems[1].Text == "0")
{
MessageBox.Show("数据表为空，不需要上传");
}
else
{
db_progressBar.Value = 1;
db_progressBar.Minimum = 0;
db_progressBar.Maximum = tb_count[2];
for (int i = 0; tb_count[2] - i > 0; i++)
{
/*采用单条数据上传*/
Data_Err_info temp = new Data_Err_info();
DataBase pdata = new DataBase();
string comm3 = "select * from tb_error limit 1 "; //获取1条数据
MySqlDataReader reader = pdata.Select(comm3);
temp.id = reader[1].ToString();
temp.f = (byte)Int16.Parse(reader[2].ToString());
temp.no = reader[3].ToString();
temp.time = reader[4].ToString();
temp.ctt = reader[5].ToString();
/*close the connection*/
reader.Close();
pdata.con_close();
/*进一步打包数据，转json*/
string rundata = WebSreverce_PostJson.ConvertToJson(temp);
Data_json data_info = new Data_json();
data_info.dt = rundata;
data_info.did = Constants.ERRORINFO;
rundata = WebSreverce_PostJson.ConvertToJson(data_info);
string reponce = WebSreverce_PostJson.Post_Jsonstr(WebSreverce_PostJson.urladd_inn, rundata); //url表示数据服务器的地址及接口名称，可以定义成全局变量
// Console.WriteLine(reponce);
if (reponce == "ac")
{
//Console.WriteLine(rundata);
//返回值正确，服务器收到了请求
MySqlConnection sqlcon = new MySqlConnection(pdata.M_str_sqlcon);
sqlcon.Open();
string comm4 = " delete from tb_error limit 1 "; //获取前1条数据
pdata.Delete(sqlcon, comm4);
sqlcon.Close();
/*操作Processbar*/
if (db_progressBar.Value < db_progressBar.Maximum)
{
db_progressBar.Value += 1;
this.pbar_state.Text = "上传进行中 [" + db_progressBar.Value.ToString() + "/" + db_progressBar.Maximum + "]....";
}
else
{
this.pbar_state.Text = "上传已完成！";
if (MessageBox.Show("上传完成！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information) == DialogResult.OK)
{
return;
}
}
}
else
{
if (MessageBox.Show("与Web服务器连接异常，请检查后重试！", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning) == DialogResult.OK)
{
return;
}
}
}
}
}
if (db_tblist.SelectedItems[0].Text == "环境数据表")
{
if (db_tblist.SelectedItems[0].SubItems[1].Text == "0")
{
MessageBox.Show("数据表为空，不需要上传");
}
else
{
db_progressBar.Value = 1;
db_progressBar.Minimum = 0;
db_progressBar.Maximum = tb_count[3];
for (int i = 0; tb_count[3] - i > 0; i++)
{
/*采用单条数据上传*/
Data_Env_info temp = new Data_Env_info();
DataBase pdata = new DataBase();
string comm3 = "select * from tb_env limit 1 "; //获取1条数据
MySqlDataReader reader = pdata.Select(comm3);
temp.id = reader[1].ToString();
temp.u = Convert.ToSingle(reader[2].ToString());
temp.v = Convert.ToSingle(reader[3].ToString());
temp.w = Convert.ToSingle(reader[4].ToString());
temp.tep = Convert.ToSingle(reader[5].ToString());
temp.hmi = Convert.ToSingle(reader[6].ToString());
temp.time = reader[7].ToString();
/*close the connection*/
reader.Close();
pdata.con_close();
/*进一步打包数据，转json*/
string rundata = WebSreverce_PostJson.ConvertToJson(temp);
Data_json data_info = new Data_json();
data_info.dt = rundata;
data_info.did = Constants.ENVINFO;
rundata = WebSreverce_PostJson.ConvertToJson(data_info);
string reponce = WebSreverce_PostJson.Post_Jsonstr(WebSreverce_PostJson.urladd_inn, rundata); //url表示数据服务器的地址及接口名称，可以定义成全局变量
// Console.WriteLine(reponce);
if (reponce == "ac")
{
//Console.WriteLine(rundata);
//返回值正确，服务器收到了请求
MySqlConnection sqlcon = new MySqlConnection(pdata.M_str_sqlcon);
sqlcon.Open();
string comm4 = " delete from tb_env limit 1 "; //获取前1条数据
pdata.Delete(sqlcon, comm4);
sqlcon.Close();
/*操作Processbar*/
if (db_progressBar.Value < db_progressBar.Maximum)
{
db_progressBar.Value += 1;
this.pbar_state.Text = "上传进行中 [" + db_progressBar.Value.ToString() + "/" + db_progressBar.Maximum + "]....";
}
else
{
this.pbar_state.Text = "上传已完成！";
if (MessageBox.Show("上传完成！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information) == DialogResult.OK)
{
return;
}
}
}
else
{
if (MessageBox.Show("与Web服务器连接异常，请检查后重试！", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning) == DialogResult.OK)
{
return;
}
}
}
}
}
}
}
}