📄 formmain.cs
字号:
cmd.CommandText = strSql;
rdr= cmd.ExecuteReader();
if (rdr.Read())
{ls_zdg = rdr[0].ToString(); }
rdr.Close();
strSql="select bh from SZDJ where name ='"+ ls_szdj +"'";
cmd.CommandText = strSql;
rdr= cmd.ExecuteReader();
if (rdr.Read())
{ls_szdj = rdr[0].ToString(); }
rdr.Close();
strSql="select bh from tsbj where name ='"+ ls_tsbj +"'";
cmd.CommandText = strSql;
rdr= cmd.ExecuteReader();
if (rdr.Read())
{ls_tsbj = rdr[0].ToString(); }
rdr.Close();
strSql="select bh from zdl where name ='"+ ls_zdl +"'";
cmd.CommandText = strSql;
rdr= cmd.ExecuteReader();
if (rdr.Read())
{ls_zdl = rdr[0].ToString(); }
rdr.Close();
strSql="select bh from zxj where name ='"+ ls_zxj +"'";
cmd.CommandText = strSql;
rdr= cmd.ExecuteReader();
if (rdr.Read())
{ls_zxj = rdr[0].ToString(); }
rdr.Close();
strSql="select bh from zx where name ='"+ ls_zx +"'";
cmd.CommandText = strSql;
rdr= cmd.ExecuteReader();
if (rdr.Read())
{ls_zx = rdr[0].ToString(); }
rdr.Close();
conn.Close();
}
catch (SqlCeException ee)
{
MessageBox.Show(ee.Message.ToString());
}
strSql =mypreff + "update d_dx_ct22b set KGSJ=to_date('"+ ls_kgrq +"','yyyy-mm-dd hh12:mi:ss'),YJRQ=to_date('"+ ls_yjrq +"','yyyy-mm-dd'),QCDXRQ=to_date('"+ ls_dxrq +"','yyyy-mm-dd'),QCFXRQ=to_date('"+ ls_fxrq +"','yyyy-mm-dd') where sys_code ='"+ as_bh +"'";
Message message = new Message(Message.CommandHeader.SendMessage,1,1,strSql);
client.messageQueue.Add(message);
Thread.Sleep(1000);
strSql =mypreff + "update d_dx_ct22b set QCCXRQ=to_date('"+ ls_cxrq +"','yyyy-mm-dd'),ZZ="+ ls_zz +",ZAIZ ="+ ls_zaiz +",HC="+ ls_zz +",ZJ="+ ls_zj +",RJ="+ ls_rj +",QCCXDW='"+ ls_cxdw +"',SZDJ='"+ ls_szdj +"',ZDGXB='"+ ls_zdg +"' where sys_code ='"+ as_bh +"'";
Message message3 = new Message(Message.CommandHeader.SendMessage,1,1,strSql);
client.messageQueue.Add(message3);
Thread.Sleep(1000);
strSql =mypreff + "update d_dx_ct22b set QCDXDW='"+ ls_dxdw +"',QCFXDW= '"+ ls_fxdw +"',RXCS= '"+ ls_rxcs +"',GCRLJB='"+ ls_gcljb +"',TSBJ='"+ ls_tsbj +"',yjyxm= '"+ ls_yjry +"',ZXJ='"+ ls_zxj +"',ZDLXB='"+ ls_zdl +"' where sys_code ='"+ as_bh +"'" ;
Message message1 = new Message(Message.CommandHeader.SendMessage,1,1,strSql);
client.messageQueue.Add(message1);
Thread.Sleep(1000);
strSql =mypreff + "update d_dx_ct22b set FX='"+ ls_fx +"',CG='"+ ls_cgxh +"',ZTQ='"+ ls_ztq +"',KZCZHZZ= '"+ ls_kzxh +"',HCQ1XB= '"+ ls_hcq1 +"',HCQ2XB= '"+ ls_hcq2 +"',flag_15= '"+ ls_dx15 +"',ycx= '"+ ls_cz +"',zx= '"+ ls_zx +"' where sys_code ='"+ as_bh +"'" + "endf";
Message message2 = new Message(Message.CommandHeader.SendMessage,1,1,strSql);
client.messageQueue.Add(message2);
}
// 0 , 1 , 2 , 3 , 4 , 5 , 6 ,7 , 8 , 9 , 10 ,11,12,13 , 14 ,15,16,17,18,19 , 20 ,21, 22 , 23 , 24 , 25 , 26 , 27, 28 , 29 ,30,31,32,33, 34
//"select DW,QCCXDW,QCCXRQ,QCDXDW,QCDXRQ,QCFXDW,QCFXRQ,ZZ,ZAIZ,HCQ1XB,HCQ2XB,HC,ZX,ZXJ,ZDGXB,CG,RJ,FX,ZJ,ZTQ,FLAG_15,XC,ZDLXB,ZBCSZDW,GCRLJB,KZCZHZZ,TSBJ,YJRQ,SZDJ,RXCS,BC,TW,GD,CZ,YCX from d_dx_ct22b where sys_code ='"+ as_bh +"'";
private void xsch(string[] as_data)
{
//显示从服务器中请求的车辆信息
string strSql = "";
string ls_kzxh="",ls_cxdw="",ls_fxdw="",ls_dxdw="",ls_hcq1="",ls_hcq2="",ls_szdj="",ls_zdg="",ls_zxj="";
string ls_tsbj="",ls_zdl="",ls_fx="",ls_cgxh="",ls_ztq="",ls_zx="",ls_xc ="",ls_dw="";
SqlCeConnection conn;
conn = new SqlCeConnection (@"Data Source = \windows\程序\SmartD\yj.sdf");
conn.Open();
SqlCeCommand cmd = conn.CreateCommand();
SqlCeDataReader rdr ;
try
{
strSql="select name from cxdw where bh ='"+ as_data[1] +"'";
cmd.CommandText = strSql;
rdr= cmd.ExecuteReader();
if (rdr.Read())
{
ls_cxdw = rdr[0].ToString();
}
rdr.Close();
strSql="select name from dxdw where bh ='"+ as_data[3] +"'";
cmd.CommandText = strSql;
rdr= cmd.ExecuteReader();
if (rdr.Read())
{
ls_dxdw = rdr[0].ToString();
}
rdr.Close();
strSql="select name from dxdw where bh ='"+ as_data[0] +"'";
cmd.CommandText = strSql;
rdr= cmd.ExecuteReader();
if (rdr.Read())
{
ls_dw = rdr[0].ToString();
}
rdr.Close();
strSql="select name from fxdw where bh ='"+ as_data[5] +"'";
cmd.CommandText = strSql;
rdr= cmd.ExecuteReader();
if (rdr.Read())
{
ls_fxdw = rdr[0].ToString();
}
rdr.Close();
strSql="select name from xc where bh ='"+ as_data[21] +"'";
cmd.CommandText = strSql;
rdr= cmd.ExecuteReader();
if (rdr.Read())
{ls_xc = rdr[0].ToString(); }
rdr.Close();
strSql="select name from kztzxh where bh ='"+ as_data[25] +"'";
cmd.CommandText = strSql;
rdr= cmd.ExecuteReader();
if (rdr.Read())
{
ls_kzxh = rdr[0].ToString();
}
rdr.Close();
strSql="select name from hcq where bh ='"+ as_data[9] +"'";
cmd.CommandText = strSql;
rdr= cmd.ExecuteReader();
if (rdr.Read())
{
ls_hcq1 = rdr[0].ToString();
}
rdr.Close();
strSql="select name from hcq where bh ='"+ as_data[10] +"'";
cmd.CommandText = strSql;
rdr= cmd.ExecuteReader();
if (rdr.Read())
{
ls_hcq2 = rdr[0].ToString();
}
rdr.Close();
strSql="select name from zx where bh ='"+ as_data[12] +"'";
cmd.CommandText = strSql;
rdr= cmd.ExecuteReader();
if (rdr.Read())
{
ls_zx = rdr[0].ToString();
}
rdr.Close();
strSql="select name from tsbj where bh ='"+ as_data[26] +"'";
cmd.CommandText = strSql;
rdr= cmd.ExecuteReader();
if (rdr.Read())
{
ls_tsbj = rdr[0].ToString();
}
rdr.Close();
strSql="select name from zdl where bh ='"+ as_data[22] +"'";
cmd.CommandText = strSql;
rdr= cmd.ExecuteReader();
if (rdr.Read())
{
ls_zdl = rdr[0].ToString();
}
rdr.Close();
strSql="select name from fx where bh ='"+ as_data[17] +"'";
cmd.CommandText = strSql;
rdr= cmd.ExecuteReader();
if (rdr.Read())
{
ls_fx = rdr[0].ToString();
}
rdr.Close();
strSql="select name from cgxh where bh ='"+ as_data[15] +"'";
cmd.CommandText = strSql;
rdr= cmd.ExecuteReader();
if (rdr.Read())
{
ls_cgxh = rdr[0].ToString();
}
rdr.Close();
strSql="select name from ztq where bh ='"+ as_data[19] +"'";
cmd.CommandText = strSql;
rdr= cmd.ExecuteReader();
if (rdr.Read())
{
ls_ztq = rdr[0].ToString();
}
rdr.Close();
strSql="select name from zxj where bh ='"+ as_data[13] +"'";
cmd.CommandText = strSql;
rdr= cmd.ExecuteReader();
if (rdr.Read())
{
ls_zxj = rdr[0].ToString();
}
rdr.Close();
strSql="select name from szdj where bh ='"+ as_data[28] +"'";
cmd.CommandText = strSql;
rdr= cmd.ExecuteReader();
if (rdr.Read())
{
ls_szdj = rdr[0].ToString();
}
rdr.Close();
strSql="select name from zdg where bh ='"+ as_data[14] +"'";
cmd.CommandText = strSql;
rdr= cmd.ExecuteReader();
if (rdr.Read())
{
ls_zdg = rdr[0].ToString();
}
rdr.Close();
conn.Close();
}
catch (SqlCeException ee)
{
MessageBox.Show(ee.Message.ToString());
}
tb_yjrq.Text =as_data[27];
tb_cxrq.Text =as_data[2];
tb_dxrq.Text =as_data[4];
tb_fxrq.Text =as_data[6];
tb_xc.Text = ls_xc;
tb_cz.Text = as_data[33];
tb_zj.Text =as_data[18];
tb_rj.Text =as_data[16];
tb_zaiz.Text =as_data[8];
tb_hc.Text =as_data[11];
tb_zz.Text =as_data[7];
tb_dw.Text = ls_dw;
tb_rxcs.Text =as_data[29];
tb_gcljb.Text =as_data[24];
tb_tsbj.Text =ls_tsbj;
cb_szdj.Text =ls_szdj;
cb_zdg.Text =ls_zdg;
tb_zxj.Text =ls_zxj;
tb_zdl.Text =ls_zdl;
cb_fx.Text =ls_fx;
cb_cgxh.Text =ls_cgxh;
cb_ztq.Text =ls_ztq;
cb_kzxh.Text =ls_kzxh;
cb_hcq1.Text =ls_hcq1;
cb_hcq2.Text =ls_hcq2;
cb_cxdw.Text =ls_cxdw;
cb_dxdw.Text =ls_dxdw;
cb_fxdw.Text =ls_fxdw;
tb_zx.Text =ls_zx;
if (as_data[20] =="T")
{checkBox1.Checked = true;}
else
{checkBox1.Checked = false;}
}
private void deletech(string as_bh)
{
mypreff ="f322";
string strSql =mypreff + "delete from d_dx_ct22b where sys_code ='"+ as_bh +"'";
Message message = new Message(Message.CommandHeader.SendMessage,1,1,strSql);
client.messageQueue.Add(message);
}
private void xzdata(string as_table,string as_data)
{
//将下载的基础数据存到本地数据库
string SQL;
string[] ls_reseve ;
string[] ls_line = new string[2] ;
ls_reseve =as_data.Split(new char[] {','});
SQL = "delete from " + as_table + "";
cmdall.CommandText = SQL;
try { cmdall.ExecuteNonQuery(); }
catch (SqlCeException ee) { Message.ShowErrors(ee); }
if (ls_reseve.Length > 0)
{
for (int i =0;i < ls_reseve.Length; i++)
{
ls_line = ls_reseve[i].Split(new char[] {'_'});
SQL = "insert into " + as_table + "(bh,name) values( '" + ls_line[0].ToString() + "' , '" + ls_line[1].ToString() + "' )";
cmdall.CommandText = SQL;
try { cmdall.ExecuteNonQuery(); }
catch
{}
}
}
}
private void menuItem2_Click_1(object sender, System.EventArgs e)
{
this.Close();
}
private void Formmain_GotFocus(object sender, System.EventArgs e)
{
//刷新车辆信息
DateTime ld_date = DateTime.Now;
tb_kgsj.Text=ld_date.ToString("yyyy-MM-dd hh:mm");
tb_rq.Text =pubics.gs_rq;
tb_user.Text =pubics.gs_user;
tb_cz.Text =pubics.gs_cz;
tb_ch.Text =pubics.gs_ch;
}
private void menuItem3_Click(object sender, System.EventArgs e)
{
Form4 Form4 =new Form4();
Form4.ShowDialog();
}
private void menuItem5_Click(object sender, System.EventArgs e)
{
updatech(pubics.gs_id);
}
private void menuItem4_Click(object sender, System.EventArgs e)
{
deletech(pubics.gs_id);
}
private void menuItem6_Click(object sender, System.EventArgs e)
{
if (pubics.gs_resievech !=null && pubics.gs_resievech.Length > 0 )
{
xsch(pubics.gs_resievech);
}
else
{MessageBox.Show("没有发现数据，请刷新纪录!");}
}
private void menuItem7_Click(object sender, System.EventArgs e)
{
//刷新车辆信息
getch(pubics.gs_id);
initform();
Thread.Sleep(2000);
}
private void initform()
{
tb_yjrq.Text =null;
tb_cxrq.Text =null;
tb_dxrq.Text =null;
tb_fxrq.Text =null;
tb_xc.Text =null;
tb_zj.Text =null;
tb_rj.Text =null;
tb_zaiz.Text =null;
tb_hc.Text =null;
tb_zz.Text =null;
tb_dw.Text =null;
tb_rxcs.Text =null;
tb_gcljb.Text =null;
tb_tsbj.Text =null;
cb_szdj.Text =null;
cb_zdg.Text =null;
tb_zxj.Tex⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -