private void Finddata()
{
DataTable dt = new DataTable();
YuanyuDBTemp db = new YuanyuDBTemp();
switch (formSort)
{
case 1:
dt = db.SelectBitumenDetachData(cmbYear.Text, cmbMonth.Text, cmbProductName.Text, cmbProductmodel.Text);
dataGridView1.DataSource = dt;
dataGridView1.Columns["id"].Visible = false;
dataGridView1.Columns["ekId"].Visible = false;
dataGridView1.Columns["enId"].Visible = false;
dataGridView1.Columns["ecId"].Visible = false;
dataGridView1.Columns["eiId"].Visible = false;
dataGridView1.Columns["pId"].Visible = false;
//dataGridView1.Columns["自动还是手工"].Visible = false;
dataGridView1.Columns["自动还是手工"].ReadOnly = true;
break;
case 2:
dt = db.SelectAlterBitumenDetachData(cmbYear.Text, cmbMonth.Text, cmbProductName.Text, cmbProductmodel.Text);
dataGridView1.DataSource = dt;
dataGridView1.Columns["id"].Visible = false;
dataGridView1.Columns["ekId"].Visible = false;
dataGridView1.Columns["enId"].Visible = false;
dataGridView1.Columns["ecId"].Visible = false;
dataGridView1.Columns["eiId"].Visible = false;
dataGridView1.Columns["pId"].Visible = false;
//dataGridView1.Columns["自动还是手工"].Visible = false;
dataGridView1.Columns["自动还是手工"].ReadOnly = true;
break;
case 3:
dt = db.SelectMixBitumenDetachData(cmbYear.Text, cmbMonth.Text, cmbProductName.Text, cmbProductmodel.Text);
dataGridView1.DataSource = dt;
dataGridView1.Columns["id"].Visible = false;
dataGridView1.Columns["ekId"].Visible = false;
dataGridView1.Columns["enId"].Visible = false;
dataGridView1.Columns["ecId"].Visible = false;
dataGridView1.Columns["eiId"].Visible = false;
dataGridView1.Columns["pId"].Visible = false;
//dataGridView1.Columns["自动还是手工"].Visible = false;
dataGridView1.Columns["自动还是手工"].ReadOnly = true;
break;
}
}
private void button1_Click(object sender, EventArgs e)
{
if (MessageBox.Show("是否确认分滩数据!!", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
YuanyuDBTemp dbLayer = new YuanyuDBTemp();
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
if ((dataGridView1.Rows[i].Cells["Column1"].Value != null) && (dataGridView1.Rows[i].Cells["Column1"].Value.Equals(true)))
{
DataRow row = recDataTable.NewRow();
row["pId"] = dataGridView1.Rows[i].Cells["pId"].Value.ToString();
row["设备编号"] = dataGridView1.Rows[i].Cells["设备编号"].Value.ToString();
row["工时"] = dataGridView1.Rows[i].Cells["工时"].Value.ToString();
row["eiId"] = dbLayer.getEiId(row["设备编号"].ToString());
recDataTable.Rows.Add(row);
}
}
this.DialogResult = DialogResult.OK;
}
}
private void button2_Click(object sender, EventArgs e)
{
FrmDetachOption form = new FrmDetachOption();
form.Year = cmbYear.Text;
form.Month = cmbMonth.Text;
YuanyuDBTemp db = new YuanyuDBTemp();
bool isSelected = false;
switch (formSort)
{
case 1:
form.FormSort = 1;
form.ShowDialog();
//YuanyuDBTemp db = new YuanyuDBTemp();
if (form.RecDataTable.Rows.Count > 0)
{
if (db.ExBitumenDetachData(dataGridView1, form.RecDataTable, isSelected))
{
MessageBox.Show("分滩成功");
}
else
{
MessageBox.Show("分滩失败");
}
}
else
{
MessageBox.Show("请选择要分滩的产品!!");
}
Finddata();
break;
case 2:
form.FormSort = 2;
form.ShowDialog();
//YuanyuDBTemp db = new YuanyuDBTemp();
if (form.RecDataTable.Rows.Count > 0)
{
if (db.ExAlterBitumenDetachData(dataGridView1, form.RecDataTable, isSelected))
{
MessageBox.Show("分滩成功");
}
else
{
MessageBox.Show("分滩失败");
}
}
else
{
MessageBox.Show("请选择要分滩的产品!!");
}
Finddata();
break;
case 3:
form.FormSort = 3;
form.ShowDialog();
//YuanyuDBTemp db = new YuanyuDBTemp();
if (form.RecDataTable.Rows.Count > 0)
{
if (db.ExMixBitumenDetachData(dataGridView1, form.RecDataTable, isSelected))
{
MessageBox.Show("分滩成功");
}
else
{
MessageBox.Show("分滩失败");
}
}
else
{
MessageBox.Show("请选择要分滩的产品!!");
}
Finddata();
break;
}
}