/// <summary> /// 删除【black_unusual】表中重复数据 /// </summary> /// <returns></returns> private bool DelBlackSN() { black_unusual black = new black_unusual(); black.SN = txtCheckIn.Text.Trim(); string sqlBlack = string.Format("delete from black_unusual where SN='{0}'", black.SN); return(SqlHelper.modify(sqlBlack)); }
/// <summary> /// 从【cktimeinfo】表,添加所有数据到【black_unusual】表中 /// </summary> /// <returns></returns> private int InsertBlack() { int a = 0; for (int i = 0; i < dgvReport.Rows.Count; i++) { black_unusual black = new black_unusual(); if (dgvReport.Rows[i].Cells[2].Value.ToString() == "0000/00/00 00:00:00") { //MessageBox.Show("表格中有SNCheckOut为空的黑色异常,已终止该部分上传!"); continue; } black.SN = dgvReport.Rows[i].Cells[0].Value.ToString(); black.SNCheckIn = dgvReport.Rows[i].Cells[1].Value.ToString(); black.SNCheckOut = dgvReport.Rows[i].Cells[2].Value.ToString(); black.Minute = dgvReport.Rows[i].Cells[3].Value.ToString(); black.employee_id = dgvReport.Rows[i].Cells[4].Value.ToString(); string sql = string.Format("insert into black_unusual(SN,SNCheckIn,SNCheckOut,Minute,employee_id)values('{0}','{1}','{2}','{3}','{4}')" , black.SN, black.SNCheckIn, black.SNCheckOut, black.Minute, black.employee_id); a = SqlHelper.update(sql); } return(a); }
/// <summary> /// SNCheckIn回车事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void txtCheckIn_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { if (txtCheckIn.Text.Trim() != "") { //string txtText = txtCheckIn.Text; //string regular1 = @"^[A-Za-z0-9]{10}$"; //string regular2 = @"^[A-Za-z0-9]{23}$"; //bool a = Regex.IsMatch(txtText, regular2); //bool b=Regex.IsMatch(txtText,regular1); //if (b==false && a==false) //{ // MessageBox.Show("格式错误!请输入10位或者23位的字母数字组合!"); // txtCheckIn.Text = string.Empty; // return; //} black_unusual black = new black_unusual(); black.SN = txtCheckIn.Text.Trim(); string sqlBlack = "select*from black_unusual where SN='" + black.SN + "'"; DataTable dtBlack = SqlHelper.GetList(sqlBlack); CkTimeInfo ck = new CkTimeInfo(); ck.SN = txtCheckIn.Text.Trim(); string sqlCk = "select*from cktimeinfo where SN='" + ck.SN + "'"; DataTable dtCk = SqlHelper.GetList(sqlCk); if (dtBlack.Rows.Count <= 0 && dtCk.Rows.Count <= 0) { InserSNcheckIn(); if (rdoPersonal.Checked == true) { rdoPersonal_Click(null, null); } else if (rdoPublic.Checked == true) { rdoPublic_Click(null, null); } txtCheckIn.Text = string.Empty; txtCheckOut.Text = string.Empty; return; } else { MessageBoxButtons messButton = MessageBoxButtons.OKCancel; DialogResult dr = MessageBox.Show("该SN已录入,是否删除?", "删除原纪录!!!", messButton); if (dr == DialogResult.OK) { DelCkSN(); DelBlackSN(); if (rdoPersonal.Checked == true) { rdoPersonal_Click(null, null); } else if (rdoPublic.Checked == true) { rdoPublic_Click(null, null); } } else { return; } } } else { MessageBox.Show("SNCheckIn输入值不能为空!"); return; } } }