private void button1_Click(object sender, EventArgs e) { if (textBox1.Text != "") { var sql = $"SELECT TOP 1 * FROM udbz WHERE name='{textBox1.Text.Trim().ToUpper()}'"; var sdra5 = SqlHelper.ExecuteReader(SqlHelper.GetConnection(), CommandType.Text, sql); if (sdra5.HasRows) { sdra5.Close(); MessageBox.Show($"此工序名称【{textBox1.Text.Trim()}】已存在,请重新输入!!", "提示"); textBox1.Text = ""; textBox1.Focus(); Goiss(); } else { sdra5.Close(); var sqltk = $"insert into udbz(name) values('{textBox1.Text.Trim().ToUpper()}')"; SqlHelper.ExecuteNonQuery(SqlHelper.GetConnection(), CommandType.Text, sqltk); textBox1.Text = ""; textBox1.Focus(); } } else { MessageBox.Show("工序名称不能为空", "提示"); textBox1.Focus(); } }
private void btnAdd_Click(object sender, EventArgs e) { if (btnAdd.Text == Resources.A新增) { btnUpd.Visible = false; btnDel.Visible = false; btnAdd.Text = Resources.A保存; } else { if (textBox2.Text != "" && comboBox1.Text != "") { var sql = $"INSERT INTO PD_ProcCard_Employee(TeamId,Name) VALUES({comboBox1.SelectedValue},'{textBox2.Text.Trim().ToUpper()}')"; SqlHelper.ExecuteNonQuery(SqlHelper.GetConnectionString("dzdj"), CommandType.Text, sql); btnUpd.Visible = true; btnDel.Visible = true; btnAdd.Text = Resources.A新增; textBox2.Text = ""; comboBox1.Text = ""; InitData(); } else { MessageBox.Show("班组与员工都不可为空!", Resources.T提示); } } }
private void button2_Click(object sender, EventArgs e) { var kMMi = dataGridView1.SelectedCells[0].Value.ToString().Trim(); if (MessageBox.Show("是否要删除所选择的行", "警告", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning) == DialogResult.OK) { var sql = $"delete FROM udodt WHERE IDO='{kMMi}'"; SqlHelper.ExecuteNonQuery(SqlHelper.GetConnection(), CommandType.Text, sql); Goiss(); } }
private void btnDel_Click(object sender, EventArgs e) { var id = dataGridView2.SelectedCells[0].Value.ToString().Trim(); if (MessageBox.Show("是否要删除所选择的行", Resources.J警告, MessageBoxButtons.OKCancel, MessageBoxIcon.Warning) == DialogResult.OK) { var sql = $"DELETE FROM PD_ProcCard_Employee WHERE ID='{id}'"; SqlHelper.ExecuteNonQuery(SqlHelper.GetConnectionString("dzdj"), CommandType.Text, sql); InitData(); } }
private void button5_Click(object sender, EventArgs e)//新建保存 { if (textBox2.Text != "") { if (textBox4.Text != "") { if (comboBox1.Text != "") { if (SqlHelper.UserName == "管理" && comboBox1.Text.Trim() == Resources.UT_Admin) { MessageBox.Show("此帐号不可以创建<admin>帐号,请重新输入!!", Resources.T提示); } else { var sql = $"SELECT ID FROM IDPASS WHERE ID='{textBox2.Text.Trim()}'"; var sdddr1Q = SqlHelper.ExecuteReader(SqlHelper.GetConnection(), CommandType.Text, sql); if (sdddr1Q.HasRows) { MessageBox.Show($"此帐号< {textBox2.Text.Trim()} >已存在,请重新输入!!", Resources.T提示); textBox2.Text = ""; sdddr1Q.Close(); } else { sdddr1Q.Close(); sql = $"insert into IDPASS(ID,pass,name,leiq) values('{textBox2.Text.Trim()}','{textBox3.Text.Trim()}','{textBox4.Text.Trim()}','{comboBox1.Text.Trim()}')"; SqlHelper.ExecuteNonQuery(SqlHelper.GetConnection(), CommandType.Text, sql); textBox2.Text = ""; textBox3.Text = ""; textBox4.Text = ""; comboBox1.Text = ""; GetUserInfo(); } } } else { MessageBox.Show("帐号类型不能为空!", Resources.T提示); } } else { MessageBox.Show("姓名不能为空!", Resources.T提示); textBox4.Focus(); } } else { MessageBox.Show("帐号不能为空!", Resources.T提示); textBox2.Focus(); } }
private void button3_Click(object sender, EventArgs e)//导入数据库 { var strSql = ""; if (dgvExcelView.RowCount == 0) { return; } ; var iUpdateCount = 0; using (var conn = SqlHelper.GetConnection()) { conn.Open(); using (var st = conn.BeginTransaction()) { try { for (var i = 0; i < dgvExcelView.RowCount - 1; i++) { var strId1 = dgvExcelView.Rows[i].Cells["工单号"].Value.ToString(); var strId2 = dgvExcelView.Rows[i].Cells["工序号"].Value.ToString(); var strId3 = decimal.Parse(dgvExcelView.Rows[i].Cells["序价"].Value + ""); var strId4 = decimal.Parse(dgvExcelView.Rows[i].Cells["件资合计"].Value + ""); //string strId4 = dgvExcelView.Rows[i].Cells["件资合计"].Value.ToString(); //string strId5 = dgvExcelView.Rows[i].Cells["id5"].Value.ToString(); if (strId1 == "" || strId2 == "") { continue; } strSql = $"UPDATE tf_sgdantwo set xujia={strId3},hezhi='{strId4}' WHERE shigongdanhao='{strId1}' AND xuhao='{strId2}'"; iUpdateCount += SqlHelper.ExecuteNonQuery(st, CommandType.Text, strSql); } st.Commit(); MessageBox.Show($"更新成功{iUpdateCount}条记录"); } catch (Exception ex) { st.Rollback(); MessageBox.Show(ex.Message); } } } }
private void button8_Click(object sender, EventArgs e)//修改保存 { if (textBox7.Text != "") { if (textBox6.Text != "") { if (textBox5.Text != "") { if (comboBox2.Text != "") { if (SqlHelper.UserName == "管理" && comboBox1.Text.Trim() == Resources.UT_Admin) { MessageBox.Show("此帐号不可以修改成<admin>帐号,请重新输入!!", Resources.T提示); } else { var sql = $"UPDATE IDPASS set ID='{textBox7.Text.Trim()}',pass='******',name='{textBox5.Text.Trim()}',leiq='{comboBox2.Text.Trim()}' WHERE lu='{_mMid}'"; SqlHelper.ExecuteNonQuery(SqlHelper.GetConnection(), CommandType.Text, sql); GetUserInfo(); } } else { MessageBox.Show("帐号类型不能为空!", Resources.T提示); } } else { MessageBox.Show("姓名不能为空!", Resources.T提示); textBox5.Focus(); } } else { MessageBox.Show("密码不能为空!", Resources.T提示); textBox6.Focus(); } } else { MessageBox.Show("帐号不能为空!", Resources.T提示); textBox7.Focus(); } }
private void button3_Click(object sender, EventArgs e)//删除 { if (dataGridView1.SelectedRows.Count == 0) { MessageBox.Show("提示:请选择要删除的用户信息!", Resources.J警告); } else { var mMid = dataGridView1.SelectedCells[0].Value.ToString().Trim(); if (MessageBox.Show($"是否要删除< {mMid} >序号用户", Resources.J警告, MessageBoxButtons.OKCancel, MessageBoxIcon.Warning) == DialogResult.OK) { var sql = $"delete FROM IDPASS WHERE lu='{mMid}'"; SqlHelper.ExecuteNonQuery(SqlHelper.GetConnection(), CommandType.Text, sql); GetUserInfo(); } else { GetUserInfo(); } } }
private void btnUpd_Click(object sender, EventArgs e) { if (btnUpd.Text == Resources.X修改) { if (MessageBox.Show("是否已经选择好所要修改的行,若未选好请按取消!", Resources.T提示, MessageBoxButtons.OKCancel, MessageBoxIcon.Warning) == DialogResult.OK) { var employeeId = dataGridView2.SelectedCells[0].Value.ToString().Trim(); var sql = $"SELECT a.ID,b.Team '班组名称',a.Name '员工' FROM PD_ProcCard_Employee a JOIN dbo.PD_ProcCard_Team b ON b.ID=a.TeamId WHERE a.ID='{employeeId}'"; var dr = SqlHelper.ExecuteReader(SqlHelper.GetConnectionString("dzdj"), CommandType.Text, sql); if (dr.HasRows) { dr.Read(); comboBox1.Text = dr[1].ToString().Trim(); textBox2.Text = dr[2].ToString().Trim(); comboBox1.Tag = dr[0].ToString().Trim(); dr.Close(); btnAdd.Visible = false; btnDel.Visible = false; btnUpd.Text = Resources.X保存; } else { dr.Close(); } } } else { var sql = $"UPDATE PD_ProcCard_Employee SET TeamId='{comboBox1.SelectedValue}',Name='{textBox2.Text.Trim().ToUpper()}'WHERE id ={Convert.ToInt32(comboBox1.Tag)}"; SqlHelper.ExecuteNonQuery(SqlHelper.GetConnectionString("dzdj"), CommandType.Text, sql); btnUpd.Text = Resources.X修改; btnAdd.Visible = true; btnDel.Visible = true; textBox2.Text = ""; comboBox1.Text = ""; InitData(); } }
private void button1_Click(object sender, EventArgs e) { var sql = $"SELECT TOP 1 * FROM IDPASS WHERE ID='{textBox1.Text.Trim()}'"; var s5Dr5 = SqlHelper.ExecuteReader(SqlHelper.GetConnection(), CommandType.Text, sql); if (s5Dr5.HasRows) { s5Dr5.Read(); var adss = s5Dr5["pass"].ToString().Trim(); if (textBox2.Text.Trim() == adss) { if (textBox3.Text.Trim() == textBox4.Text.Trim()) { sql = ""; sql = $"UPDATE IDPASS set pass='******' WHERE ID='{textBox1.Text.Trim()}'"; SqlHelper.ExecuteNonQuery(SqlHelper.GetConnection(), CommandType.Text, sql); Close(); } else { MessageBox.Show("新密码输入不一致,请重新输入!", "提示"); textBox3.Text = ""; textBox4.Text = ""; textBox3.Focus(); } } else { MessageBox.Show("当前密码与登录的密码不一致,请重新输入!", "提示"); textBox2.Text = ""; textBox3.Text = ""; textBox4.Text = ""; textBox2.Focus(); } } }