//修改密码 private void button_add_Click(object sender, EventArgs e) { if (CValidateTools.isNull(textBox_oldPwd.Text)) { CValidateTools.showError("请输入旧密码"); return; } if (CValidateTools.isNull(textBox_new1.Text)) { CValidateTools.showError("请输入新密码"); return; } if (textBox_new1.Text != textBox_new2.Text) { CValidateTools.showError("二次密码输入不一致"); return; } //查询此用户的旧密码是否正确 string str = "select * from userInfo where AdmName = '#username' and AdmPwd = '#pwd' "; str = str.Replace("#username", m_usname); str = str.Replace("#pwd", textBox_oldPwd.Text); ADOHelper db = new ADOHelper(); if (!db.ExecuteRead(str).HasRows) { CValidateTools.showError("旧密码不正确,无法修改新密码"); return; } //替换新密码 string strUpdate = "update userInfo set AdmPwd = '#pwd' where admName = '#admName' "; strUpdate = strUpdate.Replace("#admName", m_usname).Replace("#pwd", textBox_new1.Text); bool result = false; try { ADOHelper db1 = new ADOHelper(); result = db1.ExecuteUpdate(strUpdate); } catch (Exception ex) { CValidateTools.showError(ex.Message); return; } if (result) { CValidateTools.showOK("密码重置成功!"); } }
//保存数据 private void button_save_Click(object sender, EventArgs e) { if (!ClassGlobalUserInfo.checkValidate())//操作员没有权限 { CValidateTools.showError("权限不足"); return; } if (textBox_uTitle.ReadOnly) { return; } if (textBox_uTitle.Text.Length <= 0 || textBox_des.Text.Length <= 0) { CValidateTools.showError("待修改内容不能为空"); return; } string rowID = dview_UploadInfo.Rows[dview_UploadInfo.SelectedCells[0].RowIndex].Cells["编号"].Value.ToString(); if (rowID == null || rowID.Length <= 0) { CValidateTools.showError("请选择要修改的数据"); return; } string strUpdate = "update fileUpload set uploadTitle = '#title' , uploadDes = '#uploadDes' where ID = #ID1 "; strUpdate = strUpdate.Replace("#title", textBox_uTitle.Text).Replace("#uploadDes", textBox_des.Text).Replace("#ID1", rowID); bool result = false; try { ADOHelper db = new ADOHelper(); result = db.ExecuteUpdate(strUpdate); } catch (Exception ex) { CValidateTools.showError(ex.Message); return; } if (result) { CValidateTools.showOK("上传信息修改成功!"); getUploadData(); ChangeDataSoure(srcTable); } textBox_uTitle.ReadOnly = true; textBox_des.ReadOnly = true; }
//添加用户 private void button_add_Click(object sender, EventArgs e) { if (!checkValide()) { return; } //格式化数据 string sid = textBox_id.Text; string admName = textBox_name.Text; string cName = textBox_cname.Text; int roleID = int.Parse(comboBox_role.SelectedValue.ToString()); int depID = int.Parse(comboBox_dep.SelectedValue.ToString()); //查询记录中是否已经有相同记录 string queryString = "select * from userInfo where userNumber = '#user1' or AdmName = '#aname' "; string str1 = queryString.Replace("#user1", sid); str1 = str1.Replace("#aname", admName); ADOHelper db = new ADOHelper(); if (db.ExecuteRead(str1).HasRows) { MessageBox.Show("编号或用户名已存在", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } //插入新用户 string insertString = "insert into userInfo (admname,usernumber,admpwd,roleid,depcid,depid,cname) values( '#admName', '#userNum', '#pwd', #roleID, #depCID, #depID, '#cName' )"; string str = insertString.Replace("#admName", admName); str = str.Replace("#userNum", sid); str = str.Replace("#pwd", "888888"); str = str.Replace("#userNum", sid); str = str.Replace("#roleID", roleID.ToString()); str = str.Replace("#depCID", DevTools.getDepartmentId());//默认用2,2为交管局,1为公安局 str = str.Replace("#depID", depID.ToString()); str = str.Replace("#cName", cName); if (db.ExecuteUpdate(str)) { CValidateTools.showOK("添加用户成功"); clearControlData();//清除录入数据 } else { CValidateTools.showError("添加用户失败"); } }
//保存修改 private void button_save_Click(object sender, EventArgs e) { if (!ClassGlobalUserInfo.checkValidate())//操作员没有权限 { CValidateTools.showError("权限不足"); return; } if (textBox_cname.ReadOnly) { return; } int roleID = int.Parse(comboBox_role.SelectedValue.ToString()); int depID = int.Parse(comboBox_dep.SelectedValue.ToString()); string strUpdate = "update userInfo set cName = '#cname' , depID = #depid , roleID = #roldid where userNumber = '#usernumber'"; strUpdate = strUpdate.Replace("#cname", textBox_cname.Text).Replace("#depid", depID.ToString()).Replace("#roldid", roleID.ToString()).Replace("#usernumber", textBox_id.Text); bool result = false; try { ADOHelper db = new ADOHelper(); result = db.ExecuteUpdate(strUpdate); } catch (Exception ex) { CValidateTools.showError(ex.Message); return; } if (result) { CValidateTools.showOK("用户修改成功!"); } getUserInfo(); textBox_cname.ReadOnly = true; textBox_id.ReadOnly = true; }
//重置密码 private void button1_Click(object sender, EventArgs e) { if (!ClassGlobalUserInfo.checkValidate())//操作员没有权限 { CValidateTools.showError("权限不足"); return; } if (!CValidateTools.checkLength(textBox_id.Text, 1, 20)) { CValidateTools.showError("请先选择一个用户"); return; } if (CValidateTools.showYesNoDialog("确定要重置密码吗?") == DialogResult.Cancel) { return; } string strUpdate = "update userInfo set AdmPwd = '888888' where userNumber = '#usernumber' "; strUpdate = strUpdate.Replace("#usernumber", textBox_id.Text); bool result = false; try { ADOHelper db = new ADOHelper(); result = db.ExecuteUpdate(strUpdate); } catch (Exception ex) { CValidateTools.showError(ex.Message); return; } if (result) { CValidateTools.showOK("密码重置成功!"); } }
void worker_DoWork(object sender, DoWorkEventArgs e) { //根据用户id+日期创建文件夹 string sDir = System.Environment.CurrentDirectory + "\\upload\\" + comboBox_uid1.SelectedValue.ToString() + '\\' + DateTime.Now.ToString("yyyyMMdd"); CValidateTools.createDir(sDir); string strFileName = ""; string strCreateTime = ""; bool isFinish = true; do { strFileName = axMDFtpOcx1.getLocalFirstFile(comboBox_usb.Text + ":\\", true); strFileName = strFileName.Replace("\\\\", "\\"); textBox_cur.Text = CValidateTools.formatLongString(strFileName, 35);//格式化 ex: c:/123/.../33/1.avi strCreateTime = axMDFtpOcx1.getLocalFileCreateTime(strFileName); if (strFileName == null || strFileName == "") { //CValidateTools.showError("USB内无待上传文件"); break; } //copy usb文件至目录 if (axMDFtpOcx1.copyLocalFile(strFileName, sDir) == 0) { CValidateTools.showError("文件上传失败,请重试"); ErrorLog.WriteLog(strFileName + " 上传失败,请重试"); isFinish = false; return; } //获得copy后文件绝对路径及文件名 //for test strFileName = @"c:\123\456\jj\aa\2099\3343\222\123.txt"; string sDirFile = sDir + '\\' + strFileName.Substring(strFileName.LastIndexOf('\\') + 1); //上传 if (!uploadFileToDB(sDirFile, strCreateTime)) { CValidateTools.showError("数据库操作失败,请重试"); isFinish = false; return; } worker.ReportProgress(++completeFileNum); Thread.Sleep(100); //完成操作,删除usb内当前文件 if (axMDFtpOcx1.DelLocalFile(strFileName) == 0) { CValidateTools.showError("文件删除失败,请重试"); ErrorLog.WriteLog(strFileName + " 文件删除失败,请重试"); isFinish = false; return; } } while (true); if (isFinish) { CValidateTools.showOK("本次上传工作全部完成"); //clearControlData();//清除录入数据 } }