//bug:修改好密码后应该回到登录窗口 private void buttonfinish_Click(object sender, EventArgs e) { string sqlAlter = "update tbl_user set password='******' where username='******'"; MyMeans.getsqlcom(sqlAlter); this.Close(); }
private void 除文件夹ToolStripMenuItem_Click(object sender, EventArgs e) { string sqlDelete = "delete from tbl_folder where foldername='" + treeViewFolder.SelectedNode.Text + "'"; treeViewFolder.SelectedNode.Remove(); MyMeans.getsqlcom(sqlDelete); }
//右击彻底删除回收站信息 private void 彻底删除ToolStripMenuItem_Click(object sender, EventArgs e) { OnOperatorClick1(this); string sqlDelete = "delete from tbl_rabbish where rtime='" + this.textBoxtime.Text.Trim() + "'"; MyMeans.getsqlcom(sqlDelete); }
private void buttonfinish_Click(object sender, EventArgs e) { string sqlDelete = "delete from tbl_user where username='******'"; MyMeans.getsqlcom(sqlDelete); Application.Exit(); }
private void butLogin_Click(object sender, EventArgs e) { if (textName.Text != "" & textPass.Text != "") { //数据表中查找是否有当前登录用户 SQLiteDataReader temDR = MyMeans.getcom("select * from tb_Login where Name='" + textName.Text.Trim() + "'and Pass='******'"); bool ifcom = temDR.Read(); //必须用Reab方法读 //当有记录时表示用户名和密码正确 if (ifcom) { DataClass.MyMeans.Login_Name = textName.Text.Trim(); //将用户名记录到公共变量中 DataClass.MyMeans.Login_ID = temDR.GetString(0); //获取当前的操作员编号 DataClass.MyMeans.My_con.Close(); DataClass.MyMeans.My_con.Dispose(); DataClass.MyMeans.Login_n = (int)(this.Tag);//记录当前窗体的Tag属性 this.Close(); } else { MessageBox.Show("用户名或密码错误", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); textName.Text = ""; textPass.Text = ""; } } else { MessageBox.Show("请将登录信息填写完整", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void buttonExit_Click(object sender, EventArgs e) //退出 { int number = Int32.Parse(labelChenshu.Text); int lv = Int32.Parse(labelLV.Text); int life = Int32.Parse(labelShenming.Text); int attack = Int32.Parse(labelGongji.Text); int defense = Int32.Parse(labelFangyu.Text); int experience = Int32.Parse(labelJingyan.Text); int gold = Int32.Parse(labelJingbi.Text); int keyyellow = Int32.Parse(labelKeyYellow.Text); int keyblue = Int32.Parse(labelKeyBlue.Text); int keyred = Int32.Parse(labelKeyRed.Text); int keyqing = Int32.Parse(labelKeyQin.Text); int id = User.Id; int x = People.X; int y = People.Y; string sql = "update tb_game set number = '" + number + "',lv ='" + lv + "',life='" + life + "',attack='" + attack + "',defense='" + defense + "',experience='" + experience + "',gold='" + gold + "',keyyellow='" + keyyellow + "',keyblue='" + keyblue + "',keyred='" + keyred + "',keyqing='" + keyqing + "',x='" + x + "',y='" + y + "' where uid='" + id + "'"; MyMeans.get_cmdsql(); if (MyMeans.b) { MyMeans.con_close(); MessageBox.Show("退出成功"); FormMain formMain = new FormMain(); formMain.Close(); } }
private void Sta_Save_Click(object sender, EventArgs e) { if (tabControl1.SelectedTab.Name == "tabPage1")//如果当前是职工基本信息选项卡 { System.Byte[] Photo = oto; string ID = S_0.Text, StaffName = S_1.Text, Folk = S_2.Text, Culture = S_5.Text, Marriage = S_6.Text, Sex = S_7.Text; string Visage = S_8.Text, Employee = S_12.Text, IDCard = S_9.Text, Business = S_13.Text, Laborage = S_14.Text, Branch = S_15.Text; string Duthcall = S_16.Text, Phone = S_17.Text, Handset = S_18.Text, School = S_19.Text, Speciality = S_20.Text, Address = S_22.Text; string Age = S_4.Text, WorkLength = S_11.Text, M_Pay = S_25.Text, Pact_Y = S_29.Text; string BeAware = S_23.Text, City = S_24.Text, Bank = S_26.Text; DateTime Birthday, Workdate, GraduateDate, Pact_B, Pact_E; Birthday = Convert.ToDateTime(this.S_3.Text.Trim());; Workdate = Convert.ToDateTime(this.S_10.Text.Trim());; GraduateDate = Convert.ToDateTime(this.S_21.Text.Trim()); Pact_B = Convert.ToDateTime(this.S_27.Text.Trim());; Pact_E = Convert.ToDateTime(this.S_28.Text.Trim());; string s = string.Format(@"INSERT INTO tb_Staffbasic VALUES ('{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}')" , ID, StaffName, Folk, Birthday, Age, Culture, Marriage, Sex, Visage, IDCard, WorkLength, Workdate, Employee, Business, Laborage, Branch, Duthcall, Phone, Handset, School, Speciality, GraduateDate, Address, oto, BeAware, City, M_Pay, Bank, Pact_B, Pact_E, Pact_Y); MyMeans.getsqlcom(s); Sta_Save.Enabled = false; button6_Click(sender, e); } }
public void getsqlcomTest() { MyMeans target = new MyMeans(); // TODO: 初始化为适当的值 string SQLstr = string.Empty; // TODO: 初始化为适当的值 target.getsqlcom(SQLstr); Assert.Inconclusive("无法验证不返回值的方法。"); }
private void ReadEcuIDF() { log.Info("Ecu Id readding start..."); MyMeans.DropAccess(); Thread thread = new Thread(C13IdRead.workRun); thread.Start(); }
//主窗体加载 private void FormMain_Load(object sender, EventArgs e) { panelTop.BackColor = ColorTranslator.FromHtml("#398dee"); panelNewFile.BackColor = ColorTranslator.FromHtml("#398dee"); uc1 = new UserControl1(); uc3 = new UserControl3(); //默认UC1控件显示 uc1.Show(); textBoxgroup.Controls.Clear(); textBoxgroup.Controls.Add(uc1); //委托点击按钮新建笔记 this.uc1.button1.Click += userControl11_button1_Click; string str = "delete from tbl_note"; string str1 = "delete from tbl_rabbish"; MyMeans.getsqlcom(str); MyMeans.getsqlcom(str1); //显示所有的文件夹 String SQLstr = "select * from tbl_folder"; SqlConnection My_con; string M_str_sqlcon = "Integrated Security=SSPI;Database=notebook;Server=."; My_con = new SqlConnection(M_str_sqlcon); My_con.Open(); SqlCommand cmd = new SqlCommand(SQLstr, My_con); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds, "tbl_folder"); //获取表中有多少条记录,循环显示文件夹 SqlConnection conn = new SqlConnection("Integrated Security=SSPI;Database=notebook;Server=."); conn.Open(); SqlCommand comm = new SqlCommand(); comm.CommandText = "select count(*) from tbl_folder"; comm.Connection = conn; int count = (int)comm.ExecuteScalar(); for (int i = 0; i < count; i++) { string foldername = ds.Tables["tbl_folder"].Rows[i]["foldername"].ToString(); newnode = new TreeNode(foldername, 0, 0); treeViewFolder.Nodes.Add(newnode); } }
private void 查看内容ToolStripMenuItem_Click(object sender, EventArgs e) { string title = treeViewFolder.SelectedNode.Text; string sqldefault = "select * from tbl_note where title='" + title + "'"; SqlDataReader userdefault = MyMeans.getcom(sqldefault); if (userdefault.Read()) { string content = userdefault["content"].ToString(); this.textBoxTitle.Text = title; this.textBoxContent.Text = content; } }
private void 文件夹ToolStripMenuItem_Click(object sender, EventArgs e) { FolderBrowserDialog folderBrowserDialog1 = new FolderBrowserDialog(); folderBrowserDialog1.ShowNewFolderButton = true; folderBrowserDialog1.RootFolder = Environment.SpecialFolder.Desktop; DialogResult result = folderBrowserDialog1.ShowDialog(); if (result == DialogResult.OK) { folderpath = folderBrowserDialog1.SelectedPath; string folderName = new System.IO.DirectoryInfo(folderpath).Name; if (folderName != "") { newnode = new TreeNode(folderName, 0, 0); treeViewFolder.Nodes.Add(newnode); string time = DateTime.Now.ToString(); MyMeans.getsqlcom("insert into tbl_folder(foldername,buildtime) values('" + folderName + "','" + time + "')"); //获取该文件夹下面的所有文件名 System.IO.DirectoryInfo dir = new DirectoryInfo(folderpath); if (dir.Exists) { FileInfo[] fiList = dir.GetFiles(); foreach (var item in fiList) { var FileName = item.Name; string content = ""; using (StreamReader sr = item.OpenText()) { content += sr.ReadToEnd(); } string filetime = DateTime.Now.ToString(); MyMeans.getsqlcom("insert into tbl_note(title,content,time,foldername) values('" + FileName + "','" + content + "','" + filetime + "','" + folderName + "')"); newnode = new TreeNode(FileName, 1, 1); SqlConnection conn = new SqlConnection("Integrated Security=SSPI;Database=notebook;Server=."); conn.Open(); SqlCommand comm = new SqlCommand(); comm.CommandText = "select count(*) from tbl_folder"; comm.Connection = conn; int count = (int)comm.ExecuteScalar(); treeViewFolder.Nodes[count - 1].Nodes.Add(newnode); } } } } }
public void buttondelete_Click_1(object sender, EventArgs e) { // 从note表中移除笔记 string sqlDelete = "delete from tbl_note where time='" + this.textBoxtime.Text.Trim() + "'"; MyMeans.getsqlcom(sqlDelete); OnOperatorClick(this); //将该数据插入到让rabbish表中 MyMeans.getsqlcom("insert into tbl_rabbish(rtitle,rcontent,rtime) values('" + this.textBoxtitle.Text + "','" + this.textBoxcontent.Text + "','" + this.textBoxtime.Text + "')"); //一点删除让回收站加载删除的控件 fm.uc3.AddControl(); }
//修改所属文件夹 public void alterinfo() { if (fm.uc1.uclist.textBoxtitle.Text.Trim() == fm.textBoxTitle.Text.Trim()) { fm.uc1.uclist.textBoxcontent.Text = fm.textBoxContent.Text; string sqldefault = "select * from tbl_note where title='" + fm.textBoxTitle.Text.Trim() + "'"; SqlDataReader userdefault = MyMeans.getcom(sqldefault); if (userdefault.Read()) { string dbfoldername = userdefault["foldername"].ToString(); fm.uc1.uclist.textBoxfolder.Text = dbfoldername; } } }
}//右 private void FormMain_Load(object sender, EventArgs e) { PictureBox[,] pb = new PictureBox[11, 11] { { pictureBox1_1, pictureBox1_2, pictureBox1_3, pictureBox1_4, pictureBox1_5, pictureBox1_6, pictureBox1_7, pictureBox1_8, pictureBox1_9, pictureBox1_10, pictureBox1_11 }, { pictureBox2_1, pictureBox2_2, pictureBox2_3, pictureBox2_4, pictureBox2_5, pictureBox2_6, pictureBox2_7, pictureBox2_8, pictureBox2_9, pictureBox2_10, pictureBox2_11 }, { pictureBox3_1, pictureBox3_2, pictureBox3_3, pictureBox3_4, pictureBox3_5, pictureBox3_6, pictureBox3_7, pictureBox3_8, pictureBox3_9, pictureBox3_10, pictureBox3_11 }, { pictureBox4_1, pictureBox4_2, pictureBox4_3, pictureBox4_4, pictureBox4_5, pictureBox4_6, pictureBox4_7, pictureBox4_8, pictureBox4_9, pictureBox4_10, pictureBox4_11 }, { pictureBox5_1, pictureBox5_2, pictureBox5_3, pictureBox5_4, pictureBox5_5, pictureBox5_6, pictureBox5_7, pictureBox5_8, pictureBox5_9, pictureBox5_10, pictureBox5_11 }, { pictureBox6_1, pictureBox6_2, pictureBox6_3, pictureBox6_4, pictureBox6_5, pictureBox6_6, pictureBox6_7, pictureBox6_8, pictureBox6_9, pictureBox6_10, pictureBox6_11 }, { pictureBox7_1, pictureBox7_2, pictureBox7_3, pictureBox7_4, pictureBox7_5, pictureBox7_6, pictureBox7_7, pictureBox7_8, pictureBox7_9, pictureBox7_10, pictureBox7_11 }, { pictureBox8_1, pictureBox8_2, pictureBox8_3, pictureBox8_4, pictureBox8_5, pictureBox8_6, pictureBox8_7, pictureBox8_8, pictureBox8_9, pictureBox8_10, pictureBox8_11 }, { pictureBox9_1, pictureBox9_2, pictureBox9_3, pictureBox9_4, pictureBox9_5, pictureBox9_6, pictureBox9_7, pictureBox9_8, pictureBox9_9, pictureBox9_10, pictureBox9_11 }, { pictureBox10_1, pictureBox10_2, pictureBox10_3, pictureBox10_4, pictureBox10_5, pictureBox10_6, pictureBox10_7, pictureBox10_8, pictureBox10_9, pictureBox10_10, pictureBox10_11 }, { pictureBox11_1, pictureBox11_2, pictureBox11_3, pictureBox11_4, pictureBox11_5, pictureBox11_6, pictureBox11_7, pictureBox11_8, pictureBox11_9, pictureBox11_10, pictureBox11_11 } }; Label[] label = new Label[] { labelChenshu, labelLV, labelShenming, labelGongji, labelFangyu, labelJingyan, labelJingbi, labelKeyYellow, labelKeyBlue, labelKeyRed, labelKeyQin, label3, label11 }; for (int j = 0; j <= 18; j++) { string map = "map" + j; MainSql.mapxytable(j, map); for (int i = 0; i < Int32.Parse(MyMeans.dt.Rows.Count.ToString()); i++) { pb[Int32.Parse(MyMeans.dt.Rows[i][1].ToString()) - 1, Int32.Parse(MyMeans.dt.Rows[i][0].ToString()) - 1].Image = imageList1.Images[j]; } } int uid = User.Id; MyMeans.sqlstr = "select number,lv,life,attack,defense,experience,gold,keyyellow,keyblue,keyred,keyqing,x,y from tb_game where uid ='" + uid + "'"; MyMeans.get_cmd(); if (MyMeans.reader.HasRows) { if (MyMeans.reader.Read()) { for (int m = 0; m < 13; m++) { label[m].Text = MyMeans.reader.GetInt32(m).ToString(); } pictureBoxPeople.Left = pictureBoxPeople.Left + ((People.X - 1) * 45); pictureBoxPeople.Top = pictureBoxPeople.Top - ((People.Y - 1) * 45); MyMeans.cmd_close(); } } else { MessageBox.Show("找不到数据"); MyMeans.cmd_close(); } }
//点击注册 private void buttonRegister_Click_1(object sender, EventArgs e) { if (textRusername.Text != null & textRpassword.Text != null & textRpassword.Text == textRcomfirm.Text) { string time = DateTime.Now.ToString(); MyMeans.getsqlcom("insert into tbl_user(username,password,logintime) values('" + textRusername.Text.Trim() + "','" + textRpassword.Text.Trim() + "','" + time + "')"); this.Hide(); FormLogin formLogin = new FormLogin(); formLogin.ShowDialog(); } else { textError.Text = "请输入完整注册信息!"; } }
//一点uclist中的删除就在uclist3中增加带有以下信息的控件 public void addInfo() { String SQLstr = "select * from tbl_rabbish order by rtime desc"; SqlDataReader note = MyMeans.getcom(SQLstr); if (note.Read()) { string dbtitle = note["rtitle"].ToString(); string dbcontent = note["rcontent"].ToString(); string dbtime = note["rtime"].ToString(); this.textBoxtitle.Text = dbtitle; this.textBoxcontent.Text = dbcontent; this.textBoxtime.Text = dbtime; } }
//一点保存所要增加的用户控件显示的信息 public void addInfo() { String SQLstr = "select * from tbl_note where title='" + fm.textBoxTitle.Text.Trim() + "'"; SqlDataReader note = MyMeans.getcom(SQLstr); if (note.Read()) { string dbtitle = note["title"].ToString(); string dbcontent = note["content"].ToString(); string dbtime = note["time"].ToString(); string dbfolder = note["foldername"].ToString(); this.textBoxtitle.Text = dbtitle; this.textBoxcontent.Text = dbcontent; this.textBoxtime.Text = dbtime; this.textBoxfolder.Text = dbfolder; } }
private void Sta_Delete_Click(object sender, EventArgs e) //删除人事档案信息 { if (MyDS_Grid.RowCount < 2) //判断控件中是否有记录 { MessageBox.Show("数据表为空,不可以删除!"); return; } MyMeans.getsqlcom("Delete tb_Staffbasic where = ID'" + S_0.Text.Trim() + "'"); MyMeans.getsqlcom("Delete tb_WorkResume where = Stu_ID'" + S_0.Text.Trim() + "'"); MyMeans.getsqlcom("Delete tb_Family where = Sta_ID'" + S_0.Text.Trim() + "'"); MyMeans.getsqlcom("Delete tb_TrainNote where = Sta_ID '" + S_0.Text.Trim() + "'"); MyMeans.getsqlcom("Delete tb_RANDP where = Sta_ID'" + S_0.Text.Trim() + "'"); MyMeans.getsqlcom("Delete tb_WorkResume where = Sta_ID'" + S_0.Text.Trim() + "'"); MyMeans.getsqlcom("Delete tb_Individual where = ID'" + S_0.Text.Trim() + "'"); button6_Click(sender, e); }
/// <summary> /// 获取初始命令 /// </summary> private void GetCmdFormDb(String EcuVersion) { DataSet dataSet = MyMeans.GetEcuTrip(EcuVersion); foreach (DataRow row in dataSet.Tables["Table1_1"].Rows) { General1cmd = (String)row[1]; General2cmd = (String)row[2]; General3cmd = (String)row[3]; General4cmd = (String)row[4]; General5cmd = (String)row[5]; MaxAndMincmd = (String)row[6]; Timercmd = (String)row[7]; Countercmd = (String)row[8]; _1Ddata1 = (String)row[9]; _1Ddata2 = (String)row[10]; _2Ddata1 = (String)row[11]; _2Ddata2 = (String)row[12]; _2Ddata3 = (String)row[13]; } }
private void buttonsave_Click(object sender, EventArgs e) { string sqltitle = "select count(*) from tbl_person_info where username='******'"; MyMeans.My_con = new SqlConnection(MyMeans.M_str_sqlcon); SqlCommand cmd = new SqlCommand(sqltitle, MyMeans.My_con); MyMeans.My_con.Open(); int num = Convert.ToInt32(cmd.ExecuteScalar()); if (num > 0) { sqltitle = "update tbl_person_info set realname='" + this.textrealname.Text + "',phone='" + this.textphone.Text + "',deacription='" + this.textdeacription.Text + "',province='" + this.textprovince.Text + "',county='" + this.textcounty.Text + "'"; MyMeans.getsqlcom(sqltitle); } else { string sqlinstert = "insert into tbl_person_info(username,realname,phone,deacription,province,county) values('" + textBoxname.Text + "','" + textrealname.Text + "','" + textphone.Text + "','" + textdeacription.Text + "','" + textprovince.Text + "','" + textcounty.Text + "')"; MyMeans.getsqlcom(sqlinstert); } this.Hide(); }
private void FormPersonInfo_Load(object sender, EventArgs e) { InfopanelTop.BackColor = ColorTranslator.FromHtml("#398dee"); textBoxname.Text = fm.toolStripMenuuser.Text; string sqldefault = "select * from tbl_person_info where username='******'"; SqlDataReader userdefault = MyMeans.getcom(sqldefault); if (userdefault.Read()) { string dbrealname = userdefault["realname"].ToString(); string dbphone = userdefault["phone"].ToString(); string dbdeacription = userdefault["deacription"].ToString(); string dbprovince = userdefault["province"].ToString(); string dbcounty = userdefault["county"].ToString(); textrealname.Text = dbrealname; textphone.Text = dbphone; textdeacription.Text = dbdeacription; textprovince.Text = dbprovince; textcounty.Text = dbcounty; } }
private void buttonLogin_Click(object sender, EventArgs e) { //获取窗体数据 string name = textName.Text.Trim(); string password = textPassword.Text.Trim(); //执行语句 MyMeans.sqlstr = "select password,id from tb_user where name = '" + name + "'"; MyMeans.get_cmd(); if (name != "" & password != "") { MyMeans.reader.Read(); if (MyMeans.reader.HasRows) //判断是否有值,没有的话用户名错误 { string pwd = MyMeans.reader.GetString(MyMeans.reader.GetOrdinal("password")); if (password.Equals(pwd)) { User.Id = MyMeans.reader.GetInt32(1); //将用户ID传到静态变量里 MyMeans.cmd_close(); //关闭连接 FormMain formMain = new FormMain(); formMain.Show(); this.Hide(); } else { MessageBox.Show("密码错误", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { MessageBox.Show("用户名错误", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { MessageBox.Show("用户名或密码为空", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } //登录
private void FormMyCounter_Load(object sender, EventArgs e) { panelcountertop.BackColor = ColorTranslator.FromHtml("#398dee"); labelname.Text = fm.toolStripMenuuser.Text; string sqldefault = "select * from tbl_person_info where username='******'"; SqlDataReader personInfo = MyMeans.getcom(sqldefault); if (personInfo.Read()) { string dbphone = personInfo["phone"].ToString(); textphone.Text = dbphone; } string registerSql = "select * from tbl_user where username='******'"; SqlDataReader registertime = MyMeans.getcom(registerSql); if (registertime.Read()) { DateTime time = DateTime.Parse(registertime["logintime"].ToString()); texttime.Text = "亲爱的" + fm.toolStripMenuuser.Text + ",您在" + time + "注册了灵盘笔记。"; } }
private void buttonLogin_Click(object sender, EventArgs e) { if (textUsername.Text != null & textPassword.Text != null) { String SQLstr = "select * from tbl_user where username='******'and password='******'"; SqlDataReader user = MyMeans.getcom(SQLstr); bool ifcom = user.Read(); if (ifcom) { MyMeans.con_close(); string time = DateTime.Now.ToString(); this.Hide(); fm.toolStripMenuuser.Text = textUsername.Text; fm.ShowDialog(); } else { i++; if (i >= 3) { buttonLogin.Enabled = false; textError.Text = "密码错误3次,请退出!"; } else { textError.Text = "用户名或密码错误,请重新输入!"; textPassword.Text = ""; textPassword.Focus(); } } MyMeans.con_close(); } else { textError.Text = "请将登录信息填写完整!"; textPassword.Focus(); } }
public void InsertDtccode9() { MyMeans.AccessLink(); #region 插入DTC数据库 string title = "#" + _9DTCID + " " + C9dtcname + " " + C9BackTDCnumcode + " " + _C9Sactive + "\\" + _C9Tested; MyMeans.InsertDTC(title, C9S_Descrition_English, "", "", "", C9S_Descrition_Chinese); MyMeans.InsertDTC("", "Symptom", "", "", "", ""); MyMeans.InsertDTC("", "First", FirstStatuValue, "", "", ""); MyMeans.InsertDTC("", "Current", CurrentStatuValue, "", "", ""); MyMeans.InsertDTC("", "All", AllsStatuValue, "", "", ""); MyMeans.InsertDTC("", "Frequency counter", "", _C9s_Frequency_counter.ToString(), "", "发生频率"); MyMeans.InsertDTC("", "Error delete counter", "", "40", "", "完成测试数 (DLC)"); MyMeans.InsertDTC("", "Status", "", "", "", ""); MyMeans.InsertDTC("", "", "Debounce completed", Debounce_completed, "", ""); MyMeans.InsertDTC("", "", "Visible to OBD tool", Visible_to_OBD_tool, "", ""); MyMeans.InsertDTC("", "", "MIL lamp on", MIL_lamp_on, "", ""); MyMeans.InsertDTC("", "", "MIL lamp is blinking", MIL_lamp_is_blinking, "", ""); MyMeans.InsertDTC("", "", "System lamp on", System_lamp, "", ""); MyMeans.InsertDTC("", "Time since first appearance ", "", Time_since_first_appearance.ToString(), "", ""); MyMeans.InsertDTC("", "Active time", "", Active_Time.ToString(), "", ""); MyMeans.InsertDTC("", "Raw values:", C9_Value, "", "", ""); #endregion MyMeans.AccessBreak(); }
/// <summary> /// 显示行程记录 /// </summary> private void ShowTripRecord() { try { UInt64 VehDa_tiEngOn_COLCK, VehDa_tiEngOn_MIN, VehDa_tiEngOn_SECOND; UInt64 VehDa_tiECUOn_COLCK, VehDa_tiECUOn_MIN, VehDa_tiECUOn_SECOND; VehDa_tiEngOn_COLCK = Convert.ToUInt64(Genera2[1]) / 3600; VehDa_tiEngOn_MIN = Convert.ToUInt64(Genera2[1]) % 3600 / 60; VehDa_tiEngOn_SECOND = Convert.ToUInt64(Genera2[1]) % 3600 % 60; VehDa_tiECUOn_COLCK = Convert.ToUInt64(Genera2[2]) / 3600; VehDa_tiECUOn_MIN = Convert.ToUInt64(Genera2[2]) % 3600 / 60; VehDa_tiECUOn_SECOND = Convert.ToUInt64(Genera2[2]) % 3600 % 60; StringBuilder _General = new StringBuilder(); #region Trip数据表填充 MyMeans.DropTrip();//清除原先数据 MyMeans.InsertTrip("Trip Recorder Variable", "", "", "", "", "", "", "", "", ""); MyMeans.InsertTrip("General", "", "记录值[h][min][s]", "记录值[s]", "描述", "", "", "", "", ""); MyMeans.InsertTrip("", "VehDa_lSum [m]", Genera2[0], Genera2[0], "发动机行驶总里程", "", "", "", "", ""); MyMeans.InsertTrip("", "VehDa_tiEngOn", VehDa_tiEngOn_COLCK + "h " + VehDa_tiEngOn_MIN + "min " + VehDa_tiEngOn_SECOND + "s", Genera2[1], "发动机累积运转时间", "", "", "", "", ""); MyMeans.InsertTrip("", "VehDa_tiECUOn", VehDa_tiECUOn_COLCK + "h " + VehDa_tiECUOn_MIN + "min " + VehDa_tiECUOn_SECOND + "s", Genera2[2], "发动机ECU运行时间", "", "", "", "", ""); MyMeans.InsertTrip("", "VehDa_nEngRevTot [r]", Convert.ToString(Convert.ToInt64(Genera2[3]) * 1000), Convert.ToString(Convert.ToInt64(Genera2[3]) * 1000), "发动机总运转数", "", "", "", "", ""); MyMeans.InsertTrip("", "VehDa_volFlConsumTot [l]", Convert.ToString(Convert.ToInt64(Genera2[4]) / 2), Convert.ToString(Convert.ToInt64(Genera2[4]) / 2), "发动机总油耗", "", "", "", "", ""); //for (int i = 0; i < 5; i++) //{ // string[] SubGeneral = Genera1[i].Split('\r'); // string InsertDtcGeneral = SubGeneral[1].Replace(" ", ""); // string Sendstring1 = "21016D"; // int intA1 = Convert.ToInt64(Sendstring1, 16); // intA1 = intA1 + i; // string Sendstring2 = Convert.ToString(intA1, 16) + "\n"; // MyMeans.InsertTrip(Sendstring2, InsertDtcGeneral, "", "", "", "", "", "", "", ""); //} MyMeans.InsertTrip("Min/Max Value", "", "单位", "最小值", "最大值", "描述", "", "", "", ""); MyMeans.InsertTrip("", "Nr. 1: Eng_nAvrg", "[rpm]", Convert.ToString(Emp_nEngMin), Convert.ToString(Emp_nEngMax), "发动机转速", "", "", "", ""); MyMeans.InsertTrip("", "Nr. 2: CTSCD_tClnt", "[deg C] ", Convert.ToString(CEngDst_tMin), Convert.ToString(CEngDst_tMax), "发动机水温", "", "", "", ""); MyMeans.InsertTrip("", "Nr. 3: FTSCD_tFuel", "[deg C]", Convert.ToString(CEnhgDst_tMin), Convert.ToString(CEnhgDst_tMax), "发动机转速燃油温度", "", "", "", ""); MyMeans.InsertTrip("", "Nr. 4: RailCD_pPeak", "[hPa]", Convert.ToString(Rall_pFltMin), Convert.ToString(Rall_PFltMax), "发动机轨压", "", "", "", ""); MyMeans.InsertTrip("", "Nr. 5: OTSCD_tEngOil", "[deg C]", Convert.ToString(Oil_PswmpMin), Convert.ToString(Oil_PswmpMax), "发动机机油温度", "", "", "", ""); MyMeans.InsertTrip(MaxValue_minValue, "", "", "", "", "", "", "", "", ""); MyMeans.InsertTrip("Single 计数器", "", "单位", "范围", "数值", "描述", "", "", "", ""); MyMeans.InsertTrip("", "Nr. 1: SIGNALS_RDLI_CoEng_st", "[-]", ">= 1.00", Convert.ToString(CounterArry[0]), "上电次数", "", "", "", ""); MyMeans.InsertTrip("", "Nr. 2: SIGNALS_RailP_pFlt", "[hpa]", "1750000 ~ 2000000", Convert.ToString(CounterArry[1]), "轨压超压的次数", "", "", "", ""); MyMeans.InsertTrip("", "Nr. 3: SIGNALS_Epm_nEng", "[rpm]", ">= 550.00", Convert.ToString(CounterArry[2]), "发动机转速", "", "", "", ""); MyMeans.InsertTrip("", "Nr. 4: SIGNALS_Epm_nEng", "[rpm]", ">= 2600.00", Convert.ToString(CounterArry[3]), "发动机超速", "", "", "", ""); MyMeans.InsertTrip("", "Nr. 5: SIGNALS_CEngDsT_t", "[deg C]", "-100.0 ~ 5.0", Convert.ToString(CounterArry[4]), "水温正常", "", "", "", ""); MyMeans.InsertTrip("", "Nr. 6: SIGNALS_CEngDsT_t", "[deg C]", ">= 122.0 ", Convert.ToString(CounterArry[5]), "水温过热", "", "", "", ""); MyMeans.InsertTrip("", "Nr. 7: SIGNALS_VehV_v", "[Km/h]", ">= 130", Convert.ToString(CounterArry[6]), "车速", "", "", "", ""); MyMeans.InsertTrip("", "Nr. 8: SIGNALS_Air_tCACDs", "[deg C]", "-100.0 ~ 30.0", Convert.ToString(CounterArry[7]), "进气温度", "", "", "", ""); MyMeans.InsertTrip("", "Nr. 9: SIGNALS_Air_tCACDs", "[deg C]", ">= 95.0", Convert.ToString(CounterArry[8]), "进气温度", "", "", "", ""); MyMeans.InsertTrip("", "Nr. 10: SIGNALS_BattU_u", "[mV]", "0 .. 36000", Convert.ToString(CounterArry[9]), "蓄电池电压", "", "", "", ""); MyMeans.InsertTrip("", "Nr. 11: SIGNALS_BattU_u", "[deg C]", "-100.0 .. 40.0", Convert.ToString(CounterArry[10]), "机油温度", "", "", "", ""); MyMeans.InsertTrip("", "Nr. 12: SIGNALS_Oil_tSwmp", "[hpa]", "850 .. 1050", Convert.ToString(CounterArry[11]), "高怠速设置值低值 ", "", "", "", ""); MyMeans.InsertTrip("", "Nr. 13: SIGNALS_RDLI_Rail_pDvt", "[hpa]", "2000 .. 5000", Convert.ToString(CounterArry[12]), "轨压偏差", "", "", "", ""); MyMeans.InsertTrip("", "Nr. 14: SIGNALS_RDLI_EnvP_p", "[hpa]", "0 ~ 635", Convert.ToString(CounterArry[13]), "环境大气压力", "", "", "", ""); MyMeans.InsertTrip("", "Nr. 15: SIGNALS_EnvP_p", "[hpa]", "635 ~ 1010", Convert.ToString(CounterArry[14]), "环境大气压力", "", "", "", ""); //for (int x = 0; x < 1; x++) //{ // string Sendstring1 = "210165"; // int intA1 = Convert.ToInt64(Sendstring1, 16); // intA1 = intA1 + x; // string Sendstring2 = Convert.ToString(intA1, 16) + "\n"; // _General.Append(Sendstring2 + " " + _0165_016BS[x] + "\n"); // MyMeans.InsertTrip(Sendstring2, _0165_016BS[x], "", "", "", "", "", "", "", ""); //} MyMeans.InsertTrip("1 - Dimensional Maps", "", "", "", "", "", "", "", "", ""); MyMeans.InsertTrip("", "Nr. 1: Eng_nAvrg [rpm] 发动机平均转速", "", "", "", "", "", "", "", ""); MyMeans.InsertTrip("", " ", "2300 ~ 2500", "2500 ~ 2700", "2700 ~ 2900", "2900 ~ 3100", "", "", "", ""); MyMeans.InsertTrip("", "", _1Dimensional_Maps_toStr[0][0], _1Dimensional_Maps_toStr[0][1], _1Dimensional_Maps_toStr[0][2], _1Dimensional_Maps_toStr[0][3], "", "", "", ""); MyMeans.InsertTrip("", "Nr. 2: CTSCD_tClnt [deg C] 冷却液温度", "", "", "", "", "", "", "", ""); MyMeans.InsertTrip("", "", "102 ~ 107", "107 ~ 112", "112 ~ 117", "117 ~ 122", "", "", "", ""); MyMeans.InsertTrip("", "", _1Dimensional_Maps_toStr[1][0], _1Dimensional_Maps_toStr[1][1], _1Dimensional_Maps_toStr[1][2], _1Dimensional_Maps_toStr[1][3], "", "", "", ""); MyMeans.InsertTrip("", "Nr. 3: IATSCD_tAir [deg C] 进气温度", "", "", "", "", "", "", "", ""); MyMeans.InsertTrip("", "", "80 ~ 85", "85 ~ 90", "90 ~ 95", "95 ~ 100", "", "", "", ""); MyMeans.InsertTrip("", "", _1Dimensional_Maps_toStr[2][0], _1Dimensional_Maps_toStr[2][1], _1Dimensional_Maps_toStr[2][2], _1Dimensional_Maps_toStr[2][3], "", "", "", ""); MyMeans.InsertTrip("", "Nr. 4: OTSCD_tEngOil [deg C] 发动机机油温度", "", "", "", "", "", "", "", ""); MyMeans.InsertTrip("", "", "115 ~ 120", "120 ~ 125", "125 ~ 130", "130 ~ 135", "", "", "", ""); MyMeans.InsertTrip("", "", _1Dimensional_Maps_toStr[3][0], _1Dimensional_Maps_toStr[3][1], _1Dimensional_Maps_toStr[3][2], _1Dimensional_Maps_toStr[3][3], "", "", "", ""); MyMeans.InsertTrip("", "Nr. 5: FTSCD_tFuel [deg C] 燃油温度", "", "", "", "", "", "", "", ""); MyMeans.InsertTrip("", "", "80 ~ 85", "85 ~ 90", "90 ~ 95", "95 ~ 100", "", "", "", ""); MyMeans.InsertTrip("", "", _1Dimensional_Maps_toStr[4][0], _1Dimensional_Maps_toStr[4][1], _1Dimensional_Maps_toStr[4][2], _1Dimensional_Maps_toStr[4][3], "", "", "", ""); MyMeans.InsertTrip("", "Nr. 6: RailCD_pPeak [hPa] 持续10毫秒最大轨道压", "", "", "", "", "", "", "", ""); MyMeans.InsertTrip("", "", "250bar ~ 594bar", "594bar ~ 938bar", "938bar ~ 1282bar", "1282bar ~ 1625bar", "", "", "", ""); MyMeans.InsertTrip("", "", _1Dimensional_Maps_toStr[5][0], _1Dimensional_Maps_toStr[5][1], _1Dimensional_Maps_toStr[5][2], _1Dimensional_Maps_toStr[5][3], "", "", "", ""); //// 2wei shuju/////////////////////////////////////////////////////////////////////////////////// MyMeans.InsertTrip("2 - Dimensional Maps", "", "", "", "", "", "", "", "", ""); MyMeans.InsertTrip("", " x: Eng_nAvrg[rpm] / y: CoEng_rTrq[%] 发动机平均转速 ", "", "", "", "", "", "", "", ""); MyMeans.InsertTrip("", "当前扭矩与最大扭矩的比率", "500 ~ 1000 ", "1000 ~ 1500", "1500 ~ 2000", "2000 ~ 2500", "", "", "", ""); MyMeans.InsertTrip("", "94.9707 ~ 114.9658 %", _68_Dimensional_Maps_toStr[2][0], _68_Dimensional_Maps_toStr[2][1], _68_Dimensional_Maps_toStr[2][2], _68_Dimensional_Maps_toStr[2][3], "", "", "", ""); MyMeans.InsertTrip("", "74.9756 ~ 94.9707 %", _68_Dimensional_Maps_toStr[1][0], _68_Dimensional_Maps_toStr[1][1], _68_Dimensional_Maps_toStr[1][2], _68_Dimensional_Maps_toStr[1][3], "", "", "", ""); MyMeans.InsertTrip("", "54.9805 ~ 74.9756 %", _68_Dimensional_Maps_toStr[0][0], _68_Dimensional_Maps_toStr[0][1], _68_Dimensional_Maps_toStr[0][2], _68_Dimensional_Maps_toStr[0][3], "", "", "", ""); MyMeans.InsertTrip("", "34.9894 ~ 54.9805 %", _68_Dimensional_Maps_toStr[5][0], _68_Dimensional_Maps_toStr[5][1], _68_Dimensional_Maps_toStr[5][2], _68_Dimensional_Maps_toStr[5][3], "", "", "", ""); MyMeans.InsertTrip("", "14.9984 ~ 34.9894 %", _68_Dimensional_Maps_toStr[4][0], _68_Dimensional_Maps_toStr[4][1], _68_Dimensional_Maps_toStr[4][2], _68_Dimensional_Maps_toStr[4][3], "", "", "", ""); MyMeans.InsertTrip("", "-4.9927 ~ 14.9984 %", _68_Dimensional_Maps_toStr[3][0], _68_Dimensional_Maps_toStr[3][1], _68_Dimensional_Maps_toStr[3][2], _68_Dimensional_Maps_toStr[3][3], "", "", "", ""); MyMeans.InsertTrip("", " x: VSSCD_v[km/h] / y: CoEng_rTrq[%] 车速 ", "", "", "", "", "", "", "", ""); MyMeans.InsertTrip("", " 当前扭矩与最大扭矩的比率", "-5 ~ 30 ", "30 ~ 65", "65 ~ 100", "100 ~ 135", "", "", "", ""); MyMeans.InsertTrip("", "94.9707 ~ 114.9658 %", _68_Dimensional_Maps_toStr[8][0], _68_Dimensional_Maps_toStr[8][1], _68_Dimensional_Maps_toStr[8][2], _68_Dimensional_Maps_toStr[8][3], "", "", "", ""); MyMeans.InsertTrip("", "74.9756 ~ 94.9707 %", _68_Dimensional_Maps_toStr[7][0], _68_Dimensional_Maps_toStr[7][1], _68_Dimensional_Maps_toStr[7][2], _68_Dimensional_Maps_toStr[7][3], "", "", "", ""); MyMeans.InsertTrip("", "54.9805 ~ 74.9756 %", _68_Dimensional_Maps_toStr[6][0], _68_Dimensional_Maps_toStr[6][1], _68_Dimensional_Maps_toStr[6][2], _68_Dimensional_Maps_toStr[6][3], "", "", "", ""); MyMeans.InsertTrip("", "34.9894 ~ 54.9805 %", _69_Dimensional_Maps_toStr[2][0], _68_Dimensional_Maps_toStr[2][1], _68_Dimensional_Maps_toStr[2][2], _68_Dimensional_Maps_toStr[2][3], "", "", "", ""); MyMeans.InsertTrip("", "14.9984 ~ 34.9894 %", _69_Dimensional_Maps_toStr[1][0], _68_Dimensional_Maps_toStr[1][1], _68_Dimensional_Maps_toStr[1][2], _68_Dimensional_Maps_toStr[1][3], "", "", "", ""); MyMeans.InsertTrip("", "-4.9927 ~ 14.9984 % ", _69_Dimensional_Maps_toStr[0][0], _68_Dimensional_Maps_toStr[0][1], _68_Dimensional_Maps_toStr[0][2], _68_Dimensional_Maps_toStr[0][3], "", "", "", ""); MyMeans.InsertTrip("", "x: Eng_nAvrg[rpm] / y: BPSCD_pOutVal[mbar] 发动机平均转速", "", "", "", "", "", "", "", ""); MyMeans.InsertTrip("", " 增压压力传感器的输出值 ", "500 ~ 1000", "1000 ~ 1500", "1500 ~ 2000 ", " 2000 ~ 2500 ", "", "", "", ""); MyMeans.InsertTrip("", "2500 ~ 3100 ", _69_Dimensional_Maps_toStr[5][0], _68_Dimensional_Maps_toStr[5][1], _68_Dimensional_Maps_toStr[5][2], _68_Dimensional_Maps_toStr[5][3], "", "", "", ""); MyMeans.InsertTrip("", "2100 ~ 2500 ", _69_Dimensional_Maps_toStr[4][0], _68_Dimensional_Maps_toStr[4][1], _68_Dimensional_Maps_toStr[4][2], _68_Dimensional_Maps_toStr[4][3], "", "", "", ""); MyMeans.InsertTrip("", "1600 ~ 2100 ", _69_Dimensional_Maps_toStr[3][0], _68_Dimensional_Maps_toStr[3][1], _68_Dimensional_Maps_toStr[3][2], _68_Dimensional_Maps_toStr[3][3], "", "", "", ""); MyMeans.InsertTrip("", "x: Eng_nAvrg[rpm] / y: RailCD_pPeak[bar] 发动机平均转速", "", "", "", "", "", "", "", ""); MyMeans.InsertTrip("", " 持续10毫秒最大轨道压力 ", "500 ~ 1000", "1000 ~ 1500", "1500 ~ 2000 ", " 2000 ~ 2500 ", "", "", "", ""); MyMeans.InsertTrip("", "1200~ 1650 ", _69_Dimensional_Maps_toStr[8][0], _68_Dimensional_Maps_toStr[8][1], _68_Dimensional_Maps_toStr[8][2], _68_Dimensional_Maps_toStr[8][3], "", "", "", ""); MyMeans.InsertTrip("", "650 ~ 1200 ", _69_Dimensional_Maps_toStr[7][0], _68_Dimensional_Maps_toStr[7][1], _68_Dimensional_Maps_toStr[7][2], _68_Dimensional_Maps_toStr[7][3], "", "", "", ""); MyMeans.InsertTrip("", "100 ~ 650 ", _69_Dimensional_Maps_toStr[6][0], _68_Dimensional_Maps_toStr[6][1], _68_Dimensional_Maps_toStr[6][2], _68_Dimensional_Maps_toStr[6][3], "", "", "", ""); #endregion //for (int x = 2; x < 5; x++) //{ // string Sendstring1 = "210165"; // int intA1 = Convert.ToInt64(Sendstring1, 16); // intA1 = intA1 + x; // string Sendstring2 = Convert.ToString(intA1, 16) + "\n"; // _General.Append(Sendstring2 + " " + _0165_016BS[x] + "\n"); // MyMeans.InsertTrip(Sendstring2, _0165_016BS[x], "", "", "", "", "", "", "", ""); //} } catch (Exception e) { log.Info("tp insert data to db is error: " + e.Message); } }
/// <summary> /// read dtc code /// </summary> public static void ReadECU13DTC() { CommonCmd.SendATE1(); GobalSerialPort.ClearSendAndRecive(); try { byte[] stringToalldtccodeA = StringToSendBytes.bytesToSend("1800FF00\n"); //发送命令的一个转化 GobalSerialPort.WriteByMessage(stringToalldtccodeA, 0, stringToalldtccodeA.Length); StringOfGets = GobalSerialPort.ResultBackString; string[] splitstring = StringOfGets.Split('\r'); if (splitstring[1] != null && (!splitstring[1].Contains("NO"))) { string result = splitstring[1]; string ss = result; ss = result.Replace(" ", ""); //这里是将空格改为空的字符串,但是还有其他的方法 string sub = ss.Substring(2, 2); string subtostr = sub.ToString(); int subtoint = Convert.ToInt32(subtostr, 16); //subint 是表示有多少个故障代码 string[] strsubtring = new string[subtoint]; //strsubtring 表示要开辟多少个字符串数组 ECU13DTC = new string[subtoint]; int[] strsubtint = new int[subtoint]; Console.WriteLine(subtoint); byte[][] C13DTwrite = new byte[subtoint][]; Save13BackDTC = new string[subtoint]; C13BackTDNumCode = new string[subtoint]; for (int i = 0; i < subtoint; i++) { C13DTwrite[i] = new byte[8]; } //初始化数据 SingleDtcFunction singleDtcFunction = new SingleDtcFunction(); MyMeans.DropDTC(); //清除原先数据 MyMeans.AccessLink(); int x = 4; for (int i = 0; i < subtoint; i++) { strsubtring[i] = ss.Substring(x, 6); x = x + 6; strsubtring[i] = strsubtring[i].Substring(0, 4); C13BackTDNumCode[i] = strsubtring[i]; int TheoneString = Convert.ToInt32(strsubtring[i].Substring(0, 1), 16); int _16TheoneString = int.Parse(TheoneString.ToString("X"), System.Globalization.NumberStyles.HexNumber); string ThethreeString = strsubtring[i].Substring(1, 3); //将前面的一个数据去掉前面的两位 string SUBba = Convert.ToString(_16TheoneString, 2).PadLeft(4, '0'); string C = SUBba.Substring(2, 2); string D = "00" + C; string Fianba = (Convert.ToInt32("00" + C)).ToString("X"); string Fianba1 = Convert.ToInt32(D, 2).ToString(); strsubtring[i] = Fianba1 + ThethreeString; ECU13DTC[i] = strsubtring[i]; ECU13DTCSingle = strsubtring[i]; strsubtring[i] = "17" + strsubtring[i]; C13DTwrite[i] = StringToSendBytes.bytesToSend(strsubtring[i] + "\n"); try { GobalSerialPort.WriteByMessage(C13DTwrite[i], 0, C13DTwrite[0].Length); StringOfGets = GobalSerialPort.ResultBackString; Save13BackDTC[i] = StringOfGets; Save13BackDTCSingle = StringOfGets; //Date int count = i + 1; singleDtcFunction.ShowDtcCodeF(count); } catch (Exception e) { log.Info("the error fo message is :" + e.Message); continue; } } MainF.ShowBoxTex("读取故障完毕"); MyMeans.AccessBreak(); SaveFileFunction.Dtc_SaveExcel(); } } catch (Exception e) { SaveFileFunction.Dtc_SaveExcel(); log.Info("Dtc final error :" + e.Message); } }
/// <summary> /// 数据解析 进入数据库 /// </summary> public static void WorkOutToDb() { _13IdFDataWork.InsertAcessF_7(ECUstringtochangeASCII[0]); //86 MyMeans.InsertAccess("86", "客户字符串0", "ASCII/10", _13IdFDataWork.WorkOutData, ECUstringtochangeASCII[0]); _13IdFDataWork.InsertAcessF_10(ECUstringtochangeASCII[1]); //87 MyMeans.InsertAccess("87", "ECU软件版本号", "ASCII/64", _13IdFDataWork.WorkOutData, ECUstringtochangeASCII[1]); _13IdFDataWork.InsertAcessF_7(ECUstringtochangeASCII[2]); //89 MyMeans.InsertAccess("89", "客户字符串1", "ASCII/10", _13IdFDataWork.WorkOutData, ECUstringtochangeASCII[2]); _13IdFDataWork.InsertAcessF_10(ECUstringtochangeASCII[3]); //8a log.Info("13id 1a8a :" + _13IdFDataWork.WorkOutData); MyMeans.InsertAccess("8A", "ECU软件系统号", "ASCII/100", _13IdFDataWork.WorkOutData, ECUstringtochangeASCII[3]); _13IdFDataWork.InsertAcessF_1A8C(ECUstringtochangeASCII[4]); //8c MyMeans.InsertAccess("8C", "SCD协议版本", "Unsigned/1", _13IdFDataWork.WorkOutData, ECUstringtochangeASCII[4]); _13IdFDataWork.InsertAcessF_7(ECUstringtochangeASCII[5]); //8e MyMeans.InsertAccess("8E", "EEPROM数据集标识", "ASCII/40", _13IdFDataWork.WorkOutData, ECUstringtochangeASCII[5]); _13IdFDataWork.InsertAcessF_7(ECUstringtochangeASCII[6]); //90 MyMeans.InsertAccess("90", "车辆识别号码", "ASCII/17", _13IdFDataWork.WorkOutData, ECUstringtochangeASCII[6]); _13IdFDataWork.InsertAcessF_7(ECUstringtochangeASCII[7]); //91 MyMeans.InsertAccess("91", "ECU硬件编号", "ASCII/13", _13IdFDataWork.WorkOutData, ECUstringtochangeASCII[7]); _13IdFDataWork.InsertAcessF_7(ECUstringtochangeASCII[8]); //92 MyMeans.InsertAccess("92", "ECU硬件系统编号", "ASCII/8", _13IdFDataWork.WorkOutData, ECUstringtochangeASCII[8]); _13IdFDataWork.InsertAcessF_7(ECUstringtochangeASCII[9]); //93 MyMeans.InsertAccess("93", "ECU硬件版本号", "ASCII/8", _13IdFDataWork.WorkOutData, ECUstringtochangeASCII[9]); _13IdFDataWork.InsertAcessF_7(ECUstringtochangeASCII[10]); //94 MyMeans.InsertAccess("94", "ECU软件系统编号", "ASCII/26", _13IdFDataWork.WorkOutData, ECUstringtochangeASCII[10]); _13IdFDataWork.InsertAcessF_7(ECUstringtochangeASCII[12]); //97 MyMeans.InsertAccess("97", "发动机类型", "ASCII/15", _13IdFDataWork.WorkOutData, ECUstringtochangeASCII[12]); _13IdFDataWork.InsertAcessF_7(ECUstringtochangeASCII[13]); //98 MyMeans.InsertAccess("98", "维修站代码或诊断仪序列号", "ASCII/10", _13IdFDataWork.WorkOutData, ECUstringtochangeASCII[13]); _13IdFDataWork.InsertAcessF_7(ECUstringtochangeASCII[14]); //99 MyMeans.InsertAccess("99", "编程日期", "BCD/3", _13IdFDataWork.WorkOutData, ECUstringtochangeASCII[14]); _13IdFDataWork.InsertAcessF_7(ECUstringtochangeASCII[15]); //9a MyMeans.InsertAccess("9A", "发动机测试日期", "BCD/3", _13IdFDataWork.WorkOutData, ECUstringtochangeASCII[15]); _13IdFDataWork.InsertAcessF_7(ECUstringtochangeASCII[16]); //9b MyMeans.InsertAccess("9B", "数据集识别", "ASCII/30", _13IdFDataWork.WorkOutData, ECUstringtochangeASCII[16]); _13IdFDataWork.InsertAcessF_7(ECUstringtochangeASCII[17]); //9c MyMeans.InsertAccess("9C", "客户字符串2", "ASCII/10", _13IdFDataWork.WorkOutData, ECUstringtochangeASCII[17]); _13IdFDataWork.InsertAcessF_7(ECUstringtochangeASCII[18]); //9d MyMeans.InsertAccess("9D", "客户字符串3", "ASCII/10", _13IdFDataWork.WorkOutData, ECUstringtochangeASCII[18]); _13IdFDataWork.InsertAcessF_7(ECUstringtochangeASCII[19]); //9e MyMeans.InsertAccess("9E", "客户字符串4", "ASCII/10", _13IdFDataWork.WorkOutData, ECUstringtochangeASCII[19]); _13IdFDataWork.InsertAcessF_7(ECUstringtochangeASCII[20]); //9f MyMeans.InsertAccess("9F", "客户字符串5", "ASCII/10", _13IdFDataWork.WorkOutData, ECUstringtochangeASCII[20]); }
//bug:好像必须改名字才能存到数据库,且不能重名 private void treeViewFolder_AfterLabelEdit(object sender, NodeLabelEditEventArgs e) { string time = DateTime.Now.ToString(); MyMeans.getsqlcom("insert into tbl_folder(foldername,buildtime) values('" + e.Label + "','" + time + "')"); }