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("编辑失败");
}
}
}
