private void toolQuery_Click(object sender, EventArgs e) { strWhere = "1=1"; if (!string.IsNullOrEmpty(lookUpEdit1.Text)) { strWhere = strWhere + " AND BGD002='" + lookUpEdit1.Text + "'"; } if (!string.IsNullOrEmpty(lookUpEdit2.Text)) { strWhere = strWhere + " AND BGD004='" + lookUpEdit2.Text + "'"; } if (!string.IsNullOrEmpty(lookUpEdit3.Text)) { strWhere = strWhere + " AND BGD006='" + lookUpEdit3.Text + "'"; } if (string.IsNullOrEmpty(strWhere)) { strWhere = "''"; } tableQuery = _bll.GetDataTables(strWhere); gridControl1.DataSource = tableQuery; toolEdit.Enabled = toolQuery.Enabled = toolAdd.Enabled = toolClear.Enabled = true; toolSave.Enabled = toolCancel.Enabled = false; StateOfControl.SpliEnableFalse(splitContainer1); button2.Enabled = button1.Enabled = button4.Enabled = true; lookUpEdit1.Enabled = lookUpEdit3.Enabled = true; }
private void Form1_Load(object sender, EventArgs e) { GridViewMoHuSelect.SetFilter(gridView1); personInfor = _bll.GetDataTablePeople( ); lookUpEdit1.Properties.DataSource = personInfor; lookUpEdit1.Properties.DisplayMember = "DBA001"; lookUpEdit1.Properties.ValueMember = "DBA002"; lookUpEdit4.Properties.DataSource = personInfor.Copy( ); lookUpEdit4.Properties.DisplayMember = "DBA001"; lookUpEdit4.Properties.ValueMember = "DBA002"; lookUpEdit5.Properties.DataSource = personInfor.Copy( ); lookUpEdit5.Properties.DisplayMember = "DBA001"; lookUpEdit5.Properties.ValueMember = "DBA002"; toolQuery.Enabled = toolAdd.Enabled = true; toolEdit.Enabled = toolClear.Enabled = toolSave.Enabled = toolCancel.Enabled = false; StateOfControl.SpliEnableFalse(splitContainer1); button2.Enabled = button1.Enabled = button4.Enabled = true; lookUpEdit1.Enabled = lookUpEdit3.Enabled = true; gd = _bll.GetDataTableWorkOrderOne( ); lookUpEdit3.Properties.DataSource = gd; lookUpEdit3.Properties.DisplayMember = "RAC001"; //toolEdit.Visible = false; dateTimePicker1.Value = getDate( ); }
private void toolEdit_Click(object sender, EventArgs e) { /* * DateTime d1 = dateTimePicker1.Value; * DateTime d2 = getDate( ).AddDays( -1 ); * if ( !( DateTime.Now.AddDays( -1 ) <= dateTimePicker1.Value ) ) * { * MessageBox.Show( "只能编辑当天及前一天的记录" ); * return; * } */ if (string.IsNullOrEmpty(gridView1.GetFocusedRowCellValue("idx").ToString())) { MessageBox.Show("请选择需要编辑的内容"); return; } //if ( !_bll.ExistsOfMax( lookUpEdit3.Text ,textBox30.Text ) ) //{ // MessageBox.Show( "只允许更改本工单最后一道工序" ); // return; //} toolEdit.Enabled = toolQuery.Enabled = toolAdd.Enabled = false; toolSave.Enabled = toolCancel.Enabled = true; StateOfControl.SpliEnableTrue(splitContainer1); dateTimePicker1.Enabled = false; sign = "2"; }
private void toolAdd_Click(object sender, EventArgs e) { toolEdit.Enabled = toolQuery.Enabled = toolAdd.Enabled = false; toolClear.Enabled = toolSave.Enabled = toolCancel.Enabled = true; StateOfControl.SpliEnableTrue(splitContainer1); StateOfControl.SpliClear(splitContainer1); dateTimePicker1.Enabled = false; dateTimePicker1.Value = getDate( ); sign = "1"; button11_Click(null, null); }
private void toolCancel_Click(object sender, EventArgs e) { toolQuery.Enabled = toolAdd.Enabled = toolClear.Enabled = toolEdit.Enabled = true; toolSave.Enabled = toolCancel.Enabled = false; StateOfControl.SpliEnableFalse(splitContainer1); button2.Enabled = button1.Enabled = button4.Enabled = true; lookUpEdit1.Enabled = lookUpEdit3.Enabled = true; if (sign == "1") { _model.BGD001 = string.Empty; textBox3.Text = string.Empty; } }
private void toolClear_Click(object sender, EventArgs e) { //dateTimePicker1.Value = DateTime.Now; StateOfControl.SpliClear(splitContainer1); }
private void toolSave_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(textBox3.Text)) { MessageBox.Show("请生成报工单号"); return; } if (string.IsNullOrEmpty(lookUpEdit1.Text)) { MessageBox.Show("员工编号不可为空"); return; } if (string.IsNullOrEmpty(textBox2.Text)) { MessageBox.Show("员工姓名不可为空"); return; } if (string.IsNullOrEmpty(lookUpEdit2.Text)) { MessageBox.Show("工艺不可为空"); return; } if (string.IsNullOrEmpty(textBox4.Text)) { MessageBox.Show("工艺名称不可为空"); return; } if (string.IsNullOrEmpty(lookUpEdit3.Text)) { MessageBox.Show("工单单号不可为空"); return; } if (string.IsNullOrEmpty(textBox8.Text)) { MessageBox.Show("主件品号不可为空"); return; } if (string.IsNullOrEmpty(textBox9.Text)) { MessageBox.Show("主件名称不可为空"); return; } if (string.IsNullOrEmpty(textBox10.Text)) { MessageBox.Show("产出数量不可为空"); return; } if (string.IsNullOrEmpty(textBox18.Text)) { MessageBox.Show("投入数量不可为空"); return; } if (textBox4.Text == "光刻") { if (string.IsNullOrEmpty(textBox27.Text)) { MessageBox.Show("请选择操作工1"); return; } } if (textBox4.Text == "粘片") { if (string.IsNullOrEmpty(textBox27.Text)) { MessageBox.Show("请选择操作工1"); return; } if (string.IsNullOrEmpty(textBox23.Text)) { MessageBox.Show("请选择操作工2"); return; } } variable( ); if (_model.BGD010 > _model.BGD018) { MessageBox.Show("产出数量多于投入数量"); return; } if (sign == "1") { result = _bll.Exists(_model.BGD006, _model.BGD030); if (result == true) { MessageBox.Show("同工单单号、同工序只能存在一条记录"); return; } if (textBox30.Text != "010") { result = _bll.ExistsPrevious(_model.BGD006, _model.BGD030); if (result == false) { MessageBox.Show("不能跳工序新建,请重新选择工序"); return; } } result = _bll.Esits(_model); if (result == true) { button11_Click(null, null); } if (_model.BGD006 == null || _model.BGD004 == null) { variable( ); } _model.BGD032 = _model.BGD034 = getDate( ); result = _bll.InsertTran(_model); if (result == true) { MessageBox.Show("已录入"); toolQuery.Enabled = toolAdd.Enabled = toolEdit.Enabled = toolClear.Enabled = true; toolSave.Enabled = toolCancel.Enabled = false; StateOfControl.SpliEnableFalse(splitContainer1); button2.Enabled = button1.Enabled = button4.Enabled = true; lookUpEdit1.Enabled = lookUpEdit2.Enabled = lookUpEdit3.Enabled = true; strWhere = "1=1"; strWhere = strWhere + " AND BGD006='" + lookUpEdit3.Text + "'"; queryBuild( ); _bll.findAndEidt(_model.BGD006); } else { MessageBox.Show("录入失败"); } } if (sign == "2") { if (gdh != _model.BGD006) { MessageBox.Show("工单单号不允许编辑"); return; } if (gdh != _model.BGD006 && odd != _model.BGD030) { MessageBox.Show("工单单号、工序不可更改"); return; } if (_model.BGD006 == null || _model.BGD004 == null) { variable( ); } result = _bll.UpdateTrans(_model); if (result == true) { MessageBox.Show("编辑成功"); toolQuery.Enabled = toolAdd.Enabled = toolEdit.Enabled = toolClear.Enabled = true; toolSave.Enabled = toolCancel.Enabled = false; StateOfControl.SpliEnableFalse(splitContainer1); button2.Enabled = button1.Enabled = button4.Enabled = true; lookUpEdit1.Enabled = lookUpEdit2.Enabled = lookUpEdit3.Enabled = true; strWhere = "1=1"; strWhere = strWhere + " AND BGD006='" + lookUpEdit3.Text + "'"; query( ); _bll.findAndEidt(_model.BGD006); } else { MessageBox.Show("编辑失败"); } } }