📄 formmain.cs
字号:
{
mypreff ="f309";
ls_sql =mypreff + "select sys_code,sys_name from HMIS.B_DICT_FX";
sendyj(ls_sql);
}
if (cb_xz.Text =="车钩型号")
{
mypreff ="f310";
ls_sql =mypreff + "select sys_code,sys_name from HMIS.B_DICT_CG";
sendyj(ls_sql);
}
if (cb_xz.Text =="闸调器")
{
mypreff ="f311";
ls_sql =mypreff + "select sys_code,sys_name from HMIS.B_DICT_ZTQ";
sendyj(ls_sql);
}
if (cb_xz.Text =="空重调整型号")
{
mypreff ="f312";
ls_sql =mypreff + "select sys_code,sys_name from HMIS.B_DICT_KZCTZ";
sendyj(ls_sql);
}
if (cb_xz.Text =="缓冲器型号")
{
mypreff ="f313";
ls_sql =mypreff + "select sys_code,sys_name from HMIS.B_DICT_HCQ";
sendyj(ls_sql);
}
if (cb_xz.Text =="自备车所属单位")
{
mypreff ="f314";
ls_sql =mypreff + "select sys_code,sys_name from HMIS.B_DICT_ZBCSSDW";
sendyj(ls_sql);
}
if (cb_xz.Text =="厂修单位")
{
mypreff ="f315";
ls_sql =mypreff + "select udh,UJU from HMIS.HCCLDDM1";
sendyj(ls_sql);
}
if (cb_xz.Text =="段修单位")
{
mypreff ="f316";
ls_sql =mypreff + "select ddh,DJU2 from HMIS.HCCLDDM2";
sendyj(ls_sql);
}
if (cb_xz.Text =="辅修单位")
{
mypreff ="f317";
ls_sql =mypreff + "select axsdh,axsju from HMIS.HCCLDDM3";
sendyj(ls_sql);
}
}
}
// 项目 服务器表与字段 本地表 前缀(mypreff)
// 车种车型 hmis.ch_czcx_field :uaux,ch_min,ch_max ch_czcx "f301"
// 轴型 HMIS.B_DICT_ZX :zx_code,zx_name zx "f302"
// 转向架 HMIS.B_DICT_ZXJ :sys_code,sys_name zxj "f303"
// 制动梁 HMIS.B_DICT_ZDL :sys_code,sys_name zdl "f304"
// 修程 HMIS.B_DICT_XC :zx_code,zx_name xc "f305"
// 特殊标记 HMIS.B_DICT_TSBJ :sys_code,sys_name tsbj "f306"
// 手制动机型号 HMIS.B_DICT_SZDJ :sys_code,sys_name SZDJ "f307"
// 制动缸型别 HMIS.B_DICT_ZDG :sys_code,sys_name ZDG "f308"
// 阀型 HMIS.B_DICT_FX :sys_code,sys_name fx "f309"
// 车钩型号 HMIS.B_DICT_CG :sys_code,sys_name cgxh "f310"
// 闸调器 HMIS.B_DICT_ZTQ :sys_code,sys_name ztq "f311"
// 空重调整型号 HMIS.B_DICT_KZCTZ :sys_code,sys_name kztzxh "f312"
// 缓冲器型号 HMIS.B_DICT_HCQ :sys_code,sys_name hcq "f313"
// 自备车单位 HMIS.B_DICT_ZBCSSDW :sys_code,sys_name zbsscdw "f314"
// 厂修单位 HMIS.HCCLDDM1 :udh,UJU cxdw "f315"
// 段修单位 HMIS.HCCLDDM2 :ddh,DJU2 dxdw "f316"
// 辅修单位 HMIS.HCCLDDM3 :axsdh,axsju fxdw "f317"
// f320 从服务器上取得车辆信息
// f321 保存数据到服务器
// f333 删除服务器上的对应记录
// 车种车型 SQL = "create table ch_czcx(cx nvarchar(12) not null,cmin nvarchar(10), cmax nvarchar(10))";
SqlCeConnection connall;
SqlCeCommand cmdall;
private void _MessageReceived(object sender,MessageEventArgst e)
{
// 处理接收到的信息
// f320 从服务器上取得车辆信息
// f321 保存数据到服务器
// f333 删除服务器上的对应记录
if (e.Smessage =="norows")
{
if (mypreff =="f321" )
{MessageBox.Show("保存失败!");}
else
{
if (mypreff =="f322" )
{MessageBox.Show("删除失败!");}
else
{MessageBox.Show("没有记录!");}
}
}
else
{
if (mypreff =="f321" )
{
MessageBox.Show("保存成功!");
}
else
{
if (mypreff =="f322" )
{
pubics.gs_id = "";
MessageBox.Show("删除成功!");
}
else
{
if (mypreff =="f320" )
{
string[] ls_reseve1 = new string[2];
ls_reseve1= e.Smessage.Split(new char[] {','});
pubics.gs_resievech =ls_reseve1 ;
}
else
{
connall = new SqlCeConnection (@"Data Source = \windows\程序\SmartD\yj.sdf");
connall.Open();
cmdall = connall.CreateCommand();
try
{
if (mypreff =="f301" )
{
string SQL;
string[] ls_reseve ;
string[] ls_line = new string[3] ;
ls_reseve =e.Smessage.Split(new char[] {','});
SQL = "delete from ch_czcx";
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 ch_czcx(cx,cmin,cmax) values( '" + ls_line[0].ToString() + "' , '" + ls_line[1].ToString() + "', '" + ls_line[2].ToString() + "' )";
cmdall.CommandText = SQL;
try { cmdall.ExecuteNonQuery(); }
catch
{}
}
}
}
if (mypreff =="f302" )
{
xzdata("zx",e.Smessage);
}
if (mypreff =="f303" )
{
xzdata("zxj",e.Smessage);
}
if (mypreff =="f304" )
{
xzdata("zdl",e.Smessage);
}
if (mypreff =="f305" )
{
xzdata("xc",e.Smessage);
}
if (mypreff =="f306" )
{
xzdata("tsbj",e.Smessage);
}
if (mypreff =="f307" )
{
xzdata("SZDJ",e.Smessage);
}
if (mypreff =="f308" )
{
xzdata("ZDG",e.Smessage);
}
if (mypreff =="f309" )
{
xzdata("fx",e.Smessage);
}
if (mypreff =="f310" )
{
xzdata("cgxh",e.Smessage);
}
if (mypreff =="f311" )
{
xzdata("ztq",e.Smessage);
}
if (mypreff =="f312" )
{
xzdata("kztzxh",e.Smessage);
}
if (mypreff =="f313" )
{
xzdata("hcq",e.Smessage);
}
if (mypreff =="f314" )
{
xzdata("zbsscdw",e.Smessage);
}
if (mypreff =="f315" )
{
xzdata("cxdw",e.Smessage);
}
if (mypreff =="f316" )
{
xzdata("dxdw",e.Smessage);
}
if (mypreff =="f317" )
{
xzdata("fxdw",e.Smessage);
}
connall.Close();
}
catch (SqlCeException ee)
{
MessageBox.Show(ee.Message.ToString());
}
listBox1.Items.Add(cb_xz.Text + "----" + "下载成功！");
}
}
}
}
}
private void sendyj(string sql)
{
//发送下载数据请求
Message message = new Message(Message.CommandHeader.SendMessage,1,1,sql);
client.messageQueue.Add(message);
}
// d_dx_ct22b
// DW, RQ, CH, QCCXDW,QCCXRQ,QCDXDW,QCDXRQ,QCFXDW,QCFXRQ, ZZ, ZAIZ,HCQ1XB,HCQ2XB,HC,ZX, ZXJ, ZDGXB
// 单位，修车日期，厂修单位,,,, , 自重,载重,缓冲器型号1,, 换长,轴型,转向架,制动缸型别
// CG, RJ, YJYXM, FX, ZJ, ZTQ, FLAG_15, XC, ZDLXB, ZBCSZDW, GCRLJB, KZCZHZZ
// 车钩型号,容积,预检员,阀型,直径,闸调器,段修1.5年 ,修程,制动梁型号,自备车所属单位,罐车容量计表,空重调整型号
// TSBJ ,YJRQ, SZDJ, RXCS, BC,TW,GD,CZ,YCX, SYS_CODE,KGSJ
// 特殊标记, ,手制动机型号,入线次数, , ,车种车型, ,开工时间
private void getch(string as_bh)
{
//发送获取当前车辆信息请求
mypreff ="f320";
string strSql =mypreff + "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 +"'";
client.StartClient(System.Net.IPAddress.Parse("192.168.1.178"),1001);
Message message = new Message(Message.CommandHeader.SendMessage,1,1,strSql);
client.messageQueue.Add(message);
}
private void updatech(string as_bh)
{
//保存当前车辆信息到服务器
string strSql = "";
SqlCeConnection conn;
conn = new SqlCeConnection (@"Data Source = \windows\程序\SmartD\yj.sdf");
conn.Open();
SqlCeCommand cmd = conn.CreateCommand();
SqlCeDataReader rdr ;
string ls_yjrq,ls_kgrq,ls_cxrq,ls_dxrq,ls_fxrq;
string ls_zj,ls_rj,ls_zaiz,ls_hc,ls_zz,ls_dx15;
string ls_rxcs,ls_gcljb,ls_tsbj,ls_yjry,ls_xc;
string ls_szdj,ls_zdg,ls_zxj,ls_zdl,ls_fx,ls_cgxh,ls_ztq,ls_kzxh,ls_hcq1,ls_hcq2,ls_cxdw,ls_dxdw,ls_fxdw,ls_cz,ls_zx;
try
{ls_yjrq = DateTime.Parse(tb_yjrq.Text.Trim()).Date.ToString("yyyy-MM-dd"); }
catch
{ls_yjrq =DateTime.Today.ToString("yyyy-MM-dd");}
try
{ls_kgrq = DateTime.Parse(tb_kgsj.Text.Trim()).Date.ToString("yyyy-MM-dd hh:mm:ss");}
catch
{ls_kgrq =DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");}
try
{ls_cxrq = DateTime.Parse(tb_cxrq.Text.Trim()).Date.ToString("yyyy-MM-dd");}
catch
{ls_cxrq = DateTime.Parse("1911-01-01").Date.ToString("yyyy-MM-dd");}
try
{ls_dxrq = DateTime.Parse(tb_dxrq.Text.Trim()).Date.ToString("yyyy-MM-dd");}
catch
{ls_dxrq = DateTime.Parse("1911-01-01").Date.ToString("yyyy-MM-dd");}
try
{ls_fxrq = DateTime.Parse(tb_dxrq.Text.Trim()).Date.ToString("yyyy-MM-dd");}
catch
{ls_fxrq = DateTime.Parse("1911-01-01").Date.ToString("yyyy-MM-dd");}
ls_zj = tb_zj.Text.Trim();
ls_rj = tb_rj.Text.Trim();
ls_zaiz = tb_zaiz.Text.Trim();
ls_hc = tb_hc.Text.Trim();
ls_zz = tb_zz.Text.Trim();
ls_rxcs = tb_rxcs.Text.Trim();
ls_gcljb =tb_gcljb.Text.Trim();
ls_tsbj =tb_tsbj.Text.Trim();
ls_yjry =tb_user.Text.Trim();
ls_xc =tb_xc.Text.Trim();
ls_szdj =cb_szdj.Text.Trim();
ls_zdg =cb_zdg.Text.Trim();
ls_zxj =tb_zxj.Text.Trim();
ls_zdl =tb_zdl.Text.Trim();
ls_fx =cb_fx.Text.Trim();
ls_cgxh =cb_cgxh.Text.Trim();
ls_ztq =cb_ztq.Text.Trim();
ls_kzxh =cb_kzxh.Text.Trim();
ls_hcq1 =cb_hcq1.Text.Trim();
ls_hcq2 =cb_hcq2.Text.Trim();
ls_cxdw =cb_cxdw.Text.Trim();
ls_dxdw =cb_dxdw.Text.Trim();
ls_fxdw =cb_fxdw.Text.Trim();
ls_cz =tb_cz.Text.Trim();
ls_zx =tb_zx.Text.Trim();
if (checkBox1.Checked)
{ls_dx15 ="T";}
else
{ls_dx15 ="F";}
mypreff ="f321";
try
{
strSql="select bh from cxdw where name ='"+ ls_cxdw +"'";
cmd.CommandText = strSql;
rdr= cmd.ExecuteReader();
if (rdr.Read())
{ls_cxdw = rdr[0].ToString(); }
rdr.Close();
strSql="select bh from dxdw where name ='"+ ls_dxdw +"'";
cmd.CommandText = strSql;
rdr= cmd.ExecuteReader();
if (rdr.Read())
{ls_dxdw = rdr[0].ToString(); }
rdr.Close();
strSql="select bh from fxdw where name ='"+ ls_fxdw +"'";
cmd.CommandText = strSql;
rdr= cmd.ExecuteReader();
if (rdr.Read())
{ls_fxdw = rdr[0].ToString(); }
rdr.Close();
strSql="select bh from xc where name ='"+ ls_xc +"'";
cmd.CommandText = strSql;
rdr= cmd.ExecuteReader();
if (rdr.Read())
{ls_xc = rdr[0].ToString(); }
rdr.Close();
strSql="select bh from hcq where name ='"+ ls_hcq2 +"'";
cmd.CommandText = strSql;
rdr= cmd.ExecuteReader();
if (rdr.Read())
{ls_hcq2 = rdr[0].ToString(); }
rdr.Close();
strSql="select bh from hcq where name ='"+ ls_hcq1 +"'";
cmd.CommandText = strSql;
rdr= cmd.ExecuteReader();
if (rdr.Read())
{ls_hcq1 = rdr[0].ToString(); }
rdr.Close();
strSql="select bh from kztzxh where name ='"+ ls_kzxh +"'";
cmd.CommandText = strSql;
rdr= cmd.ExecuteReader();
if (rdr.Read())
{ls_kzxh = rdr[0].ToString(); }
rdr.Close();
strSql="select bh from ztq where name ='"+ ls_ztq +"'";
cmd.CommandText = strSql;
rdr= cmd.ExecuteReader();
if (rdr.Read())
{ls_ztq = rdr[0].ToString(); }
rdr.Close();
strSql="select bh from cgxh where name ='"+ ls_cgxh +"'";
cmd.CommandText = strSql;
rdr= cmd.ExecuteReader();
if (rdr.Read())
{ls_cgxh = rdr[0].ToString(); }
rdr.Close();
strSql="select bh from fx where name ='"+ ls_fx +"'";
cmd.CommandText = strSql;
rdr= cmd.ExecuteReader();
if (rdr.Read())
{ls_fx = rdr[0].ToString(); }
rdr.Close();
strSql="select bh from ZDG where name ='"+ ls_zdg +"'";
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -