//开始上传
private void button_upload_Click(object sender, EventArgs e)
{
//for test
//uploadFileToDB(@"c:\11\22\44\1.txt","2010000000");
//return;
//for test
if (textBox_select.Text == "未选择")
{
CValidateTools.showError("请选择一个USB驱动器");
return;
}
short fileNum = axMDFtpOcx1.getLocalDirFilesNum(textBox_select.Text + ":\\", true);
if (fileNum <= 0)
{
CValidateTools.showError("选择的驱动器内没有相关数据文件");
return;
}
if (DialogResult.OK != CValidateTools.showYesNoDialog("上传开始后请勿进行任何操作\n确定开始上传吗?"))
{
return;
}
worker.WorkerReportsProgress = true;
worker.RunWorkerAsync();
fDiallog = new FormProgress(fileNum);
fDiallog.ShowDialog();
}
private bool checkValide()
{
if (!CValidateTools.checkLength(textBox_id.Text, 1, 20))
{
CValidateTools.showError("编号 长度必须大于0且小于20");
return(false);
}
if (!CValidateTools.isNumber(textBox_id.Text))
{
CValidateTools.showError("编号 必须是全数字");
return(false);
}
if (!CValidateTools.checkLength(textBox_name.Text, 1, 20))
{
CValidateTools.showError("用户名 长度必须大于0且小于20");
return(false);
}
if (!CValidateTools.checkLength(textBox_cname.Text, 1, 20))
{
CValidateTools.showError("姓名 长度必须大于0且小于20");
return(false);
}
return(true);
}
private bool uploadFileToDB(string filename, string strCreateTime)
{
string uploadString = @"insert into fileUpload (uid1,uid2,uploadTime,uploadTitle,uploadDes,createTime,fileDir)
values ( '#uid1', '#uid2', '#uploadTime', '#uploadTitle','#uploadDes','#createTime','#fileDir')";
uploadString = uploadString.Replace("#uid1", comboBox_uid1.SelectedValue.ToString()).Replace("#uid2", ClassGlobalUserInfo.userNumber);
uploadString = uploadString.Replace("#uploadTime", dateTimePicker1.Value.ToString("yyyy/MM/dd HH:mm:ss"));
uploadString = uploadString.Replace("#uploadTitle", textBox_uTitle.Text);
uploadString = uploadString.Replace("#uploadDes", textBox_des.Text);
uploadString = uploadString.Replace("#createTime", strCreateTime);
uploadString = uploadString.Replace("#fileDir", filename);
try
{
ADOHelper db = new ADOHelper();
//for (int i = 0; i < 800; i++ )//for test
db.ExecuteUpdate(uploadString);
}
catch (Exception ex)
{
ErrorLog.WriteLog(ex);
CValidateTools.showError(ex.Message);
return(false);
}
return(true);
}
//修改密码
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_ok_Click(object sender, EventArgs e)
{
if (!checkLogin())
{
CValidateTools.showError("登录失败，请检查用户名及密码");
return;
}
this.DialogResult = DialogResult.OK;
this.Close();
}
//添加用户
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 bool checkLogin()
{
//防止sql注入 类似 where user='******' and pwd ='123' or 'a' = 'a'
if (textBox_uname.Text.IndexOf(" ") > 0 || textBox_upwd.Text.IndexOf(" ") > 0)
{
return(false);
}
//ADOHelper db = new ADOHelper();
string str = m_strLoginStr;
str = str.Replace("#username", textBox_uname.Text);
str = str.Replace("#pwd", textBox_upwd.Text);
try
{
ADOHelper db = new ADOHelper();
OleDbDataReader result = db.ExecuteRead(str);
if (!result.HasRows)
{
return(false);
}
while (result.Read())//保存全局用户信息
{
ClassGlobalUserInfo.cName = result["cName"].ToString();
ClassGlobalUserInfo.amdName = result["AdmName"].ToString();
ClassGlobalUserInfo.userNumber = result["userNumber"].ToString();
ClassGlobalUserInfo.roleID = result["roleID"].ToString();
ClassGlobalUserInfo.depId = result["depId"].ToString();
ClassGlobalUserInfo.depCId = result["depCId"].ToString();
}
}
catch (Exception se)
{
CValidateTools.showError(se.ToString());
return(false);
}
return(true);
}
//扫描USB驱动设备
private void button1_Click(object sender, EventArgs e)
{
comboBox_usb.Items.Clear();
string drivers = axMDFtpOcx1.getUsbDriver();
if (drivers.Length <= 0)
{
CValidateTools.showError("未找到USB设备");
textBox_select.Text = "未选择";
return;
}
string[] a1 = drivers.Split('*');
comboBox_usb.Items.AddRange(a1);
comboBox_usb.SelectedIndex = 0;
}
//数据上传
private void button_dataUpload_Click(object sender, EventArgs e)
{
if (!CValidateTools.isOcxReg(""))
{
CValidateTools.ocxReg();
}
FormUploadFile f1 = (FormUploadFile)checkFormsIsOpen("FormUploadFile");
if (f1 == null)
{
FormUploadFile us = new FormUploadFile(this.Left, this.Top);
us.Show();
}
else
{
f1.Activate();
}
}
//重置密码
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("密码重置成功!");
}
}
//添加新用户
private void button_addUser_Click(object sender, EventArgs e)
{
if (!ClassGlobalUserInfo.checkValidate())//操作员没有权限
{
CValidateTools.showError("权限不足");
return;
}
FormuserAdd f1 = (FormuserAdd)checkFormsIsOpen("FormuserAdd");
if (f1 == null)
{
FormuserAdd us = new FormuserAdd(this.Left, this.Top);
us.Show();
}
else
{
f1.Activate();
}
}
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();//清除录入数据
}
}
//条件查询
private void button_inquery_Click(object sender, EventArgs e)
{
if (CValidateTools.containsBlank(textBox_QueryKey.Text))
{
CValidateTools.showError("关键字不合法！");
return;
}
/* 一种过滤数据的方法
*
* string strQuery = @" select u1.AdmName as 用户名, u1.cName as 姓名, u1.userNumber as 编号, d1.depName as 所属部门, r1.roleName as 角色, u1.AddDate as 创建时间 from userInfo u1, department d1, role r1
* where u1.roleID = r1.ID and u1.depCID = d1.categroyID and u1.depID = d1.depID and d1.categroyID = 2 and #col like '%#value%' and depCID = 2 ";
* string str = strQuery;
* if (comboBox_queryCol.SelectedIndex == 0)
* str = str.Replace("#col", "userNumber").Replace("#value", textBox_QueryKey.Text );
* else if(comboBox_queryCol.SelectedIndex == 1)
* str = str.Replace("#col", "admName").Replace("#value", textBox_QueryKey.Text);
* else
* str = str.Replace("#col", "cName").Replace("#value", textBox_QueryKey.Text);
*
*
* dview_UserInfo.rows
*
* ADOHelper db = new ADOHelper();
* if (db.ExecuteGet(str) == null)
* return;
*
* dview_UserInfo.DataBindings.Clear();
* dview_UserInfo.DataSource = db.ExecuteGet(str).Tables[0];
*
*
* */
//另一种过滤数据的方法
string str = "#col like '%#value%' ";
if (comboBox_queryCol.SelectedIndex == 0)
{
str = str.Replace("#col", "编号").Replace("#value", textBox_QueryKey.Text);
}
else if (comboBox_queryCol.SelectedIndex == 1)
{
str = str.Replace("#col", "用户名").Replace("#value", textBox_QueryKey.Text);
}
else
{
str = str.Replace("#col", "姓名").Replace("#value", textBox_QueryKey.Text);
}
string strQuery = @" select u1.AdmName as 用户名, u1.cName as 姓名, u1.userNumber as 编号, d1.depName as 所属部门, r1.roleName as 角色, u1.AddDate as 创建时间 from userInfo u1, department d1, role r1
where u1.roleID = r1.ID and u1.depCID = d1.categroyID and u1.depID = d1.depID and d1.categroyID = " + DevTools.getDepartmentId();
ADOHelper db = new ADOHelper();
DataView dvNewDataViewObject = new DataView();
dvNewDataViewObject.Table = db.ExecuteGet(strQuery).Tables[0];
dvNewDataViewObject.RowFilter = str;
dview_UserInfo.DataBindings.Clear();
dview_UserInfo.DataSource = dvNewDataViewObject;
}
//播放、预览
private void imageButton_play_Click(object sender, EventArgs e)
{
string sName = dview_UploadInfo.Rows[dview_UploadInfo.SelectedCells[0].RowIndex].Cells["保存路径"].Value.ToString();
CValidateTools.PlayVideo(sName);
}
