/// <summary> /// 注册 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button1_Click(object sender, EventArgs e) { try { if (CheckResutOut()) { Dictionary <string, object> dic = new Dictionary <string, object>(); dic.Add("@username", txtUserName.Text); string sql = "Select * from Users where enable='1' and username=@username "; DataTable userdt = DbHelperOleDb.Query(sql, dic).Tables[0]; if (userdt == null || userdt.Rows.Count == 0) { Users user = new Users(); user.username = txtUserName.Text; user.password = DESJiaMi.Encrypt(txtpassword.Text); user.createtime = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"); user.enable = "1"; if (DbHelperOleDb.Add(user, "Users", null)) { MessageBox.Show("注册成功!\r\n账号:" + user.username + "\r\n密码:" + DESJiaMi.Decrypt(user.password) + "\r\n请牢记登陆账号密码!", "注册", MessageBoxButtons.OK, MessageBoxIcon.Information); this.DialogResult = DialogResult.OK; } else { MessageBox.Show("注册失败!", "注册", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { MessageBox.Show("该用户名已经存在,请重新输入其他的用户名!", "注册", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } } catch (Exception ee) { MessageBox.Show("注册失败!\r\n错误信息:\r\n" + ee.Message.ToString(), "注册", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
/// <summary> /// 【保存】 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btn_Save_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(labName.Text)) { if (flowLayoutPanel1.Controls.Count > 0) { List <WorkingHours> worktimes = new List <WorkingHours>(); foreach (timeInfo item in flowLayoutPanel1.Controls) { string error = ""; if (item.CheckResult(out error)) { WorkingHours times = item.GetTimeResult(); times.workername = DESJiaMi.Encrypt(this.gWorkerName); times.workdate = dateWorkDate.Value.ToString("yyyy-MM-dd"); times.isdelete = "1"; worktimes.Add(times); } else { MessageBox.Show("保存失败!\r\n" + error, "保存", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } } //判断时间段是否存在交叉 if (worktimes.Count > 0) { string msg = ""; if (ListTimesJiaoCha(worktimes, out msg)) { #region 判断添加的是否已经存在 string selectStr = "Select * from WorkingHours where workername='" + DESJiaMi.Encrypt(this.gWorkerName) + "' and workdate='" + dateWorkDate.Value.ToString("yyyy-MM-dd") + "' and isdelete='1' ;"; DataTable dt = DbHelperOleDb.Query(selectStr, new Dictionary <string, object>()).Tables[0]; if (dt != null && dt.Rows.Count > 0) { if (MessageBox.Show("该工作人员在" + dateWorkDate.Value.ToString("yyyy-MM-dd") + "已经存在工作记录。是否覆盖添加???", "", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK) { return; } //删除该人员当天的已经添加的数据 try { string deleteSql = " Delete from WorkingHours where workername='" + DESJiaMi.Encrypt(this.gWorkerName) + "' and workdate='" + dateWorkDate.Value.ToString("yyyy-MM-dd") + "' and isdelete='1' ;"; DbHelperOleDb.ExecuteSql(deleteSql, new Dictionary <string, object>()); } catch (Exception) { } } #endregion foreach (WorkingHours item in worktimes) { item.createtime = DateTime.Now.ToString(); item.createusername = UserInfo.userName; if (!DbHelperOleDb.Add(item, "WorkingHours", null)) { MessageBox.Show("保存失败", "保存", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } } MessageBox.Show("保存完成", "保存", MessageBoxButtons.OK, MessageBoxIcon.Information); isAddSuccess = true; if (checkLianxu.Checked) { //清空 btn_Clearn_Click(null, null); } else { this.Close(); } } else { MessageBox.Show(msg + "\r\n保存失败!!!", "保存", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } } else { MessageBox.Show("未添加待保存的时间信息,保存失败!!!", "保存", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { MessageBox.Show("姓名信息错误,保存失败!!!", "保存", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
/// <summary> /// 新增信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btn_Add_Click(object sender, EventArgs e) { if (btn_Add.Text == "新 增") { //设置按钮状态 SetButtonStatus(false, false, true); btn_Add.Text = "保 存"; //清空数据 ClearnNeiRong(); //可编辑状态 IsAddNeiRong(true); //创建时间 labCreateTime.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); } else //(btn_Add.Text == "保存") { if (!string.IsNullOrEmpty(txtName.Text.Trim())) { //判断姓名是否重复 string sql = "Select * from Personnel where enable='1' and name='" + DESJiaMi.Encrypt(txtName.Text.Trim()) + "';"; DataTable userUpdate = DbHelperOleDb.Query(sql, new Dictionary <string, object>()).Tables[0]; if (userUpdate != null && userUpdate.Rows.Count > 0) { MessageBox.Show("该姓名信息已经存在,不能重复添加!", "保存", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } else { //执行更新 Personnel personnel = new Personnel(); personnel.name = DESJiaMi.Encrypt(txtName.Text.Trim()); personnel.gender = cboxGender.Text != "" ? DESJiaMi.Encrypt(cboxGender.Text.Trim()) : ""; personnel.lxdh = txtLxdh.Text != "" ? DESJiaMi.Encrypt(txtLxdh.Text.Trim()) : ""; personnel.mainwork = richMainjob.Text; personnel.createtime = labCreateTime.Text; personnel.createusername = UserInfo.userName; personnel.enable = "1"; if (DbHelperOleDb.Add(personnel, "Personnel", null)) { updateORAddSuccess = true; MessageBox.Show("保存成功!", "修改", MessageBoxButtons.OK, MessageBoxIcon.Information); ClearnNeiRong(); //清空内容 SetButtonStatus(true, true, true); //重置按钮状态 LoadPersonelInfo(); //重新加载职工列表 btn_Update.Text = "新 增"; } else { MessageBox.Show("保存失败!", "修改", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } else { MessageBox.Show("请先输入有效的“姓名”信息!!!", "保存", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } }