//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 + "')");
}
