public void SaveAlarm() { try { string SQL = "select * from " + YBSetAlarm + " where GUIDSTR='" + ProDefine.g_SMExpermentParam.GUID.ToString() + "'"; DataTable dt = AccessHelper.GetDataTableFromDB(SQL); if (dt != null) { if (dt.Rows.Count > 0) { SQL = "delete from " + YBSetAlarm + " where GUIDSTR='" + ProDefine.g_SMExpermentParam.GUID.ToString() + "'"; AccessHelper.ExcuteSql(SQL); } foreach (var info in ProDefine.g_YBAlarm) { string Timestr = ""; string ValueStr = ""; string YbStr = ""; SQL = "insert into " + YBSetAlarm + " Values('" + ProDefine.g_SMExpermentParam.GUID.ToString() + "','" + info.GNFcontion + "','" + info.AlarmH + "','" + info.AlarmL + "','" + info.AlarmDataAbs + "','" + info.AlarmTimeAbs + "','')"; AccessHelper.ExcuteSql(SQL); } } } catch (System.Exception ex) { } }
public void SaveYBChannelInfo() { try { string SQL = "select * from " + YBChannelInfo + " where GUIDSTR='" + ProDefine.g_SMExpermentParam.GUID.ToString() + "'"; DataTable dt = AccessHelper.GetDataTableFromDB(SQL); if (dt != null) { if (dt.Rows.Count > 0) { SQL = "delete from " + YBChannelInfo + " where GUIDSTR='" + ProDefine.g_SMExpermentParam.GUID.ToString() + "'"; AccessHelper.ExcuteSql(SQL); } foreach (var info in ProDefine.g_FunctionChannel) { /*SQL = "insert into " + ChannelSetDBName + " Values('" + ProDefine.g_SMExpermentParam.GUID.ToString() + "','" + info.FunctionName + "','" + info.Duanzi + "','" + info.Xianhao + "','" + info.hzZQ + "','" + info.PerReadNumber + "','" + info.ChannelType + "','" + info.channelNumber + "')"; + AccessHelper.ExcuteSql(SQL);*/ { SQL = "insert into " + YBChannelInfo + " Values('" + ProDefine.g_SMExpermentParam.GUID.ToString() + "','" + info.IndexStr + "','" + info.FunctionName + "','" + info.ChannelNumber.ToString() + "','" + info.YBNumber.ToString() + "','" + info.InfoType + "')"; AccessHelper.ExcuteSql(SQL); } } } } catch (System.Exception ex) { } }
public void SaveChannelSetInfo() { try { string SQL = "select * from " + ChannelSetDBName + " where GUIDSTR='" + ProDefine.g_SMExpermentParam.GUID.ToString() + "'"; DataTable dt = AccessHelper.GetDataTableFromDB(SQL); if (dt != null) { if (dt.Rows.Count > 0) { SQL = "delete from " + ChannelSetDBName + " where GUIDSTR='" + ProDefine.g_SMExpermentParam.GUID.ToString() + "'"; AccessHelper.ExcuteSql(SQL); } foreach (var info in ProDefine.g_ChannelInfos) { SQL = "insert into " + ChannelSetDBName + " Values('" + ProDefine.g_SMExpermentParam.GUID.ToString() + "','" + info.IndexStr + "','" + info.FucntionName + "','" + info.FunctionType + "','" + info.XianHao + "','" + info.Duanzi + "','" + info.Hz.ToString() + "','" + info.PerCount.ToString() + "','" + info.IsFunctionSelect.ToString() + "')"; AccessHelper.ExcuteSql(SQL); } } } catch (System.Exception ex) { } }
public void SaveExpermentInfo(SMExpermentParam experParam) { try { string SQL = "select * from " + ExperParmaDBName + " where GUIDSTR = '" + experParam.GUID.ToString() + "'"; DataTable dt = AccessHelper.GetDataTableFromDB(SQL); if (dt != null) { if (dt.Rows.Count > 0) { SQL = "delete from " + ExperParmaDBName + " where GUIDSTR='" + ProDefine.g_SMExpermentParam.GUID.ToString() + "'"; AccessHelper.ExcuteSql(SQL); //SQL = "update " + ExperParmaDBName + " set GUIDSTR='" + experParam.GUID.ToString() + "',ExpermentType='" + experParam.ExpermentType + "',YLType='" + experParam.YLType.ToString() + "',JSMode='" // + experParam.JSMode.ToString() + "',YLSetType='" + experParam.YLSetType.ToString() + "',CGTemperature='"+ experParam.CGTemperature + "',CGXDSD='" + experParam.CGXDSD + "',CPJXTemperature='" + experParam.CPJXTemperature + "',CPJXXDSD='" + experParam.CPJXXDSD // + "',YLNumber='" + experParam.YLNumber + "',YBNumber='" + experParam.YBNumber + "',JWType='" + experParam.JWType + "',CGZD='" + experParam.CGZD + "',CGDYL='" + experParam.CGDYL + "',JXZD='" + experParam.JXZD + "',JXDYL='" + experParam.JXDYL + "' where GUIDSTR='" + experParam.GUID.ToString() + "'"; } SQL = "insert into " + ExperParmaDBName + " values('" + experParam.GUID.ToString() + "','" + experParam.ExpermentType + "','" + experParam.YLType.ToString() + "','" + experParam.JSMode.ToString() + "','" + experParam.YLSetType.ToString() + "','" + experParam.CGTemperature + "','" + experParam.CGXDSD + "','" + experParam.CPJXTemperature + "','" + experParam.CPJXXDSD + "','" + experParam.YLNumber + "','" + experParam.YBNumber + "','" + experParam.JWType + "','" + experParam.CGZD + "','" + experParam.CGDYL + "','" + experParam.JXZD + "','" + experParam.JXDYL + "')"; AccessHelper.ExcuteSql(SQL); } } catch { } }
public void DelProFromList(ProjectInfo pro) { try { string SQL = "delete from " + ProjectInfoDBName + " where ProjectName='" + pro.ProjectName + "'"; AccessHelper.ExcuteSql(SQL); } catch { } }
public bool ChangeProjectInfo(ProjectInfo pro) { try { string SQL = "update " + ProjectInfoDBName + " set ProjectName='" + pro.ProjectName + "',ProductName='" + pro.ProductName + "',ProductGN='" + pro.ProductGN + "',ProductUse='" + pro.ProductUse + "',ExperTime='" + pro.ExperTime + "',ExperAddress='" + pro.ExperAddress + "' where GUIDSTR='" + pro.GUID.ToString() + "'"; if (AccessHelper.ExcuteSql(SQL) > 0) { return(true); } return(false); } catch { return(true); } }
public void SaveYBSetSignelOut() { try { string SQL = "select * from " + YBSetOutSignle + " where GUIDSTR='" + ProDefine.g_SMExpermentParam.GUID.ToString() + "'"; DataTable dt = AccessHelper.GetDataTableFromDB(SQL); if (dt != null) { if (dt.Rows.Count > 0) { SQL = "delete from " + YBSetOutSignle + " where GUIDSTR='" + ProDefine.g_SMExpermentParam.GUID.ToString() + "'"; AccessHelper.ExcuteSql(SQL); } foreach (var info in ProDefine.g_YBSetSignleOut) { string Timestr = ""; string ValueStr = ""; string YbStr = ""; foreach (var kkk in info.m_TimeList) { Timestr = Timestr + kkk.ToString() + ","; } foreach (var kkk in info.m_ValueList) { ValueStr = ValueStr + kkk.ToString() + ","; } Timestr = Timestr.Substring(0, Timestr.Length - 1); ValueStr = ValueStr.Substring(0, ValueStr.Length - 1); SQL = "insert into " + YBSetOutSignle + " Values('" + ProDefine.g_SMExpermentParam.GUID.ToString() + "','" + info.GNFunction + "','" + Timestr + "','" + ValueStr + "','','" + info.SetType.ToString() + "')"; AccessHelper.ExcuteSql(SQL); } } } catch (System.Exception ex) { } }
private void button1_Click(object sender, EventArgs e) { // 更新 try { //UPDATE Person SET Address = 'Zhongshan 23', City = 'Nanjing'WHERE LastName = 'Wilson' string sql = "update ycyx set fwhm='"+textBox1.Text+"',khmc='"+textBox2.Text+"',gsdq='"+textBox3.Text+"',dqpp='"+textBox4.Text+ "',dqtc='"+textBox5.Text+"',dqzt='"+textBox6.Text+"' where ID="+iid; int ret = achelp.ExcuteSql(sql); if (ret > -1) { this.Hide(); MessageBox.Show("更新成功", "查询"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void SaveExpermentDesign() { try { string SQL = "select * from " + ExperDesignDBName + " where GUIDSTR='" + ProDefine.g_SMExpermentParam.GUID.ToString() + "'"; DataTable dt = AccessHelper.GetDataTableFromDB(SQL); if (dt != null) { if (dt.Rows.Count > 0) { SQL = "delete from " + ExperDesignDBName + " where GUIDSTR='" + ProDefine.g_SMExpermentParam.GUID.ToString() + "'"; AccessHelper.ExcuteSql(SQL); } foreach (var info in ProDefine.g_SMExpermentDesin.ExpParamList) { SQL = "insert into " + ExperDesignDBName + " Values('" + ProDefine.g_SMExpermentParam.GUID.ToString() + "','" + info.Temperature + "','" + info.SD + "','" + info.YBNumber + "','" + info.ExpermentTime + "')"; AccessHelper.ExcuteSql(SQL); } } } catch { } }
//保存按钮 private void button7_Click(object sender, EventArgs e) { //进行处理 string stuName = textBox1.Text.Trim(); string stuSex = textBox2.Text.Trim(); string idCardNum = textBox3.Text.Trim(); string stuId = textBox4.Text.Trim(); string stuDept = textBox5.Text.Trim(); string stuProfession = textBox6.Text.Trim(); string stuClass = textBox7.Text.Trim(); string stuLevel = textBox8.Text.Trim(); string years = textBox9.Text.Trim(); string grade = textBox10.Text.Trim(); string graduateYear = textBox11.Text.Trim(); string isPay; //ID,用来区分是新增保存还是直接修改 string ID = IDtextBox12.Text.Trim(); if (radioButton1.Checked == true) { isPay = "1"; } else { isPay = "0"; } //其中,身份证号,姓名必填,其他依照需要选填 if ("" == idCardNum) { MessageBox.Show("请输入身份证号!"); } else if ("" == stuName) { MessageBox.Show("请输入学生姓名!"); } //else if ("" == stuSex) // MessageBox.Show("请输入学生性别!"); else if (idCardNum.Trim().Trim().ToCharArray().Length != 18) { MessageBox.Show("身份证号输入有误!请重新输入!"); } else { //先进行提示: MessageBoxButtons messButton = MessageBoxButtons.OKCancel; DialogResult dr = MessageBox.Show("保存后不可删除,只可修改!确定要保存吗? ", "系统提示", messButton); if (dr == DialogResult.OK)//如果点击“确定”按钮 { Utils.AccessHelper accessHelper = new AccessHelper(Utils.FileUtils.ProjectPath + projectName + "\\dbf\\photoSystem.accdb"); if (string.IsNullOrEmpty(ID)) { //说明此人没有进行编号,则进行新增保存操作 //查出数据库中最大的id string maxIdSqlStr = "select Max(ID) from info"; //如果表中一条数据都没有,则执行结果为"" int maxId; if (string.IsNullOrEmpty(accessHelper.GetDataTableFromDB(maxIdSqlStr).Rows[0][0].ToString())) { maxId = 1; } else { maxId = int.Parse(accessHelper.GetDataTableFromDB(maxIdSqlStr).Rows[0][0].ToString()) + 1; } string isPhoto = "1"; //已照相 string isManual = "1"; //手动输入标记 //新增之后立马输出这个学生的身份证,姓名,照片编号,代表此学生已经照相 string sqlStr = string.Format("Insert into info (" + "ID , stuName, stuSex, idCardNum, stuID, stuDepartment, stuProfession, stuClass, stuLevel, years, grade, graduateYear, isPay ,isPhoto , isManual"+ ") Values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}')", maxId, stuName, stuSex, idCardNum, stuId, stuDept, stuProfession, stuClass, stuLevel, years, grade, graduateYear, isPay, isPhoto, isManual); accessHelper.ExcuteSql(sqlStr); //清空textbox框,避免多次点击按钮时会插入多次 clearTextbox(); //进行弹窗照相操作 string showStr = idCardNum + "\n" + stuName + "\n" + maxId; MessageBox.Show(showStr); } else //说明此人有编号,则进行修改保操作操作 { string sqlStr = string.Format("update info set stuName = '{0}', stuSex = '{1}', idCardNum = '{2}', stuID = '{3}', stuDepartment = '{4}', stuProfession = '{5}', stuClass = '{6}', stuLevel = '{7}', years = '{8}', grade = '{9}', graduateYear = '{10}', isPay = '{11}' where ID = {12}", stuName, stuSex, idCardNum, stuId, stuDept, stuProfession, stuClass, stuLevel, years, grade, graduateYear, isPay, ID); accessHelper.ExcuteSql(sqlStr); } //更新table表 string sqlStr1 = "select * from info where ID <> 0 order by ID desc;";//筛选出数据库中编号不为0和空的数据 dataTable = accessHelper.GetDataTableFromDB(sqlStr1); //设置datagridview的数据源 dataGridView1.DataSource = dataTable; //第一行显示为红色 dataGridView1.Rows[0].DefaultCellStyle.BackColor = Color.Red; } } }
private void readCard() { if (this.InvokeRequired) { delegateReadCard drc = new delegateReadCard(readCard); this.Invoke(drc); } else { try { //int len = 0; StringBuilder Name = new StringBuilder(31); StringBuilder Gender = new StringBuilder(3); StringBuilder Folk = new StringBuilder(10); StringBuilder BirthDay = new StringBuilder(9); StringBuilder Code = new StringBuilder(19); StringBuilder Address = new StringBuilder(71); StringBuilder Agency = new StringBuilder(31); StringBuilder ExpireStart = new StringBuilder(9); StringBuilder ExpireEnd = new StringBuilder(9); //StringBuilder directory = new StringBuilder(100); StringBuilder pucFPMsg = new StringBuilder(1024); StringBuilder pMsg = new StringBuilder(100); //如果有照片,先删除 if (File.Exists(System.Environment.CurrentDirectory + "\\photo.bmp")) { File.Delete(System.Environment.CurrentDirectory + "\\photo.bmp"); } //读取信息,存照片 int ReadBaseInfosRet = DeviceUtils.ReadBaseInfos(Name, Gender, Folk, BirthDay, Code, Address, Agency, ExpireStart, ExpireEnd); //读取信息同时会保存图片, if (ReadBaseInfosRet != 1) { MessageBox.Show("身份证信息:读身份证失败"); DeviceUtils.CloseComm(); return; } else { //读取成功,此时照片被保存到bin//debug目录下 //挪动照片 if ((File.Exists(System.Environment.CurrentDirectory + "\\photo.bmp")) && (File.Exists(FileUtils.ProjectPath + projectName + "\\bmp\\" + Code + ".bmp"))) { File.Copy(System.Environment.CurrentDirectory + "\\photo.bmp", FileUtils.ProjectPath + projectName + "\\bmp\\" + Code + ".bmp", true); File.Delete(System.Environment.CurrentDirectory + "\\photo.bmp"); } if ((File.Exists(System.Environment.CurrentDirectory + "\\photo.bmp")) && (!File.Exists(FileUtils.ProjectPath + projectName + "\\bmp\\" + Code + ".bmp"))) { File.Move(System.Environment.CurrentDirectory + "\\photo.bmp", FileUtils.ProjectPath + projectName + "\\bmp\\" + Code + ".bmp"); } } Utils.AccessHelper accessHelper = new AccessHelper(Utils.FileUtils.ProjectPath + projectName + "\\dbf\\photoSystem.accdb"); //先判断已排除这种情况:此学生已经刷身份证了,在数据库中有信息,也已经编号,此时再次刷身份证,则提示已刷过请不要重复刷 DataTable d = accessHelper.GetDataTableFromDB("select * from info where idCardNum = '" + Code + "' and ID is not null "); int i = d.Rows.Count; if (i != 0) //存在已有信息且这个学生已编号的情况 { MessageBox.Show("此学生已照相过,请勿重复刷身份证!"); return; } //查出数据库中最大的id string maxIdSqlStr = "select Max(ID) from info"; //如果表中一条数据都没有,则执行结果为"" int maxId; if (string.IsNullOrEmpty(accessHelper.GetDataTableFromDB(maxIdSqlStr).Rows[0][0].ToString())) { maxId = 1; } else { maxId = int.Parse(accessHelper.GetDataTableFromDB(maxIdSqlStr).Rows[0][0].ToString()) + 1; } //根据身份证去数据库查是否有这个学生的记录, DataTable dataTable1 = accessHelper.GetDataTableFromDB("select * from info where idCardNum = '" + Code + "' "); int count = dataTable1.Rows.Count; //如果有: if (count != 0) { //给次学生编号 accessHelper.ExcuteSql("update info set ID = " + maxId + " where idCardNum = '" + Code + "' "); } else { //数据库中没有此学生 //添加学生信息并编号 string isPhoto = "1"; //已照相 string isManual = "0"; //手动输入标记 string isPay = "0"; //未缴费 //新增之后立马输出这个学生的身份证,姓名,照片编号,代表此学生已经照相 string sqlStr = string.Format("Insert into info (" + "ID , stuName, stuSex, idCardNum, stuID, stuDepartment, stuProfession, stuClass, stuLevel, years, grade, graduateYear, isPay ,isPhoto , isManual"+ ") Values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}')", maxId, Name, Gender, Code, "", "", "", "", "", "", "", "", isPay, isPhoto, isManual); accessHelper.ExcuteSql(sqlStr); } //填充中间的姓名和照片编号 studentNameLabel.Text = Name.ToString(); PhotoNumberLabel.Text = maxId.ToString(); //展示身份证图片(先清除后展示) //清除图片 pictureBox1.Image = null; pictureBox2.Image = null; //显示身份证图片和采集图片(如果有则显示) //身份证图片绝对路径 string idCardPicture = Utils.FileUtils.ProjectPath + projectName + "\\bmp\\" + Code + ".bmp"; //采集照片的绝对路径 string photo = Utils.FileUtils.ProjectPath + projectName + "\\photo\\" + Code + ".JPG"; if (File.Exists(idCardPicture)) { //pictureBox1.Image = Image.FromFile(idCardPicture); 会占用此图片 System.Drawing.Image img = System.Drawing.Image.FromFile(idCardPicture); System.Drawing.Image bmp = new System.Drawing.Bitmap(img); img.Dispose(); pictureBox1.Image = bmp; } if (File.Exists(photo)) { /*pictureBox2.Load("d:\\DSC_7006.JPG");*/ //pictureBox2.Image = Image.FromFile(photo); System.Drawing.Image img = System.Drawing.Image.FromFile(photo); System.Drawing.Image bmp = new System.Drawing.Bitmap(img); img.Dispose(); pictureBox2.Image = bmp; } //更新展示列表数据源 string sqlStr1 = "select * from info where ID <> 0 order by ID desc;";//筛选出数据库中编号不为0和空的数据 dataTable = accessHelper.GetDataTableFromDB(sqlStr1); //设置datagridview的数据源 dataGridView1.DataSource = dataTable; //第一行显示为红色 dataGridView1.Rows[0].DefaultCellStyle.BackColor = Color.Red; //清除textbox clearTextbox(); //进行弹窗照相操作 string showStr = Code + "\n" + Name + "\n" + maxId; MessageBox.Show(showStr); } catch (Exception exception) { MessageBox.Show(exception.Message); } } }