private void TextForm_Load(object sender, EventArgs e)
{
DataSet DSet = SQLClass.getDataSet("select measure_id,measure_text from measure where measure_id = '" + data_id + "'", "数据库信息表");
DataTable dt = DSet.Tables["数据库信息表"]; //创建一个DataTable对象
if (dt.Rows.Count > 0)
{
txt_measure_text.Text = dt.Rows[0][1].ToString();
}
switch (Form_Type)
{
case 0:
break;
case 1:
break;
case 2:
txt_measure_text.ReadOnly = true;
btn_reset.Visible = false;
btn_ok.Visible = false;
break;
}
}
public int UpdateMeasure(float measure, int process_id)
{
DataSet DSet = SQLClass.getDataSet("select process_ucl,process_lcl from process where process_id = '" + process_id + "'", "数据库信息表");
DataTable dt = DSet.Tables["数据库信息表"]; //创建一个DataTable对象
if (dt.Rows.Count > 0)
{
string ucl = dt.Rows[0][0].ToString();
string lcl = dt.Rows[0][1].ToString();
if (ucl == "absoluteness" && lcl == "absoluteness")
{
state = 3;
}
else if (ucl == "absoluteness")
{
float process_lcl = Convert.ToSingle(lcl);
if (measure >= process_lcl)
{
state = 3;
}
else
{
state = 0;
}
}
else if (lcl == "absoluteness")
{
float process_ucl = Convert.ToSingle(ucl);
if (measure <= process_ucl)
{
state = 3;
}
else
{
state = 0;
}
}
else
{
float process_ucl = Convert.ToSingle(ucl);
float process_lcl = Convert.ToSingle(lcl);
if (measure >= process_lcl && measure <= process_ucl)
{
state = 3;
}
else
{
state = 0;
}
}
}
else
{
}
return(state);
}
private void btn_ok_Click(object sender, EventArgs e)
{
lab_message.Text = "正在尝试登陆，请稍后......";
if (regexclass.IsNumAndEnCh(txt_username.Text) && txt_username.Text != "请输入用户名")
{
if (txt_password.Text != "请输入密码")
{
if (txt_username.Text != null && txt_password.Text != null)
{
DataSet DSet = SQLClass.getDataSet("select admin_name,admin_username,admin_password from admin where admin_username = '******' and admin_password = '******'", "员工信息表");
DataTable dt = DSet.Tables["员工信息表"];
if (dt.Rows.Count > 0)
{
Form_OK = true;
name = dt.Rows[0][0].ToString();
lab_message.Text = "登陆成功！";
lab_message.ForeColor = Color.Black;
MessageBox.Show(dt.Rows[0][0] + "，欢迎回来！！", "登陆成功", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
else
{
lab_message.Text = "用户名或密码不正确！";
}
}
else
{
lab_message.Text = "请检查您的用户名是否正确。";
}
}
else
{
lab_message.Text = "请输入正确的密码。";
}
}
else
{
lab_message.Text = "请输入正确的用户名。";
}
}
private void SetForm_Load(object sender, EventArgs e)
{
DataSet DSet = SQLClass.getDataSet("select v_vid,v_static,v_text from v", "数据库信息表");
DataTable dt = DSet.Tables["数据库信息表"]; //创建一个DataTable对象
if (dt.Rows.Count >= 8)
{
checkBox1.Tag = dt.Rows[0][0].ToString();
if (dt.Rows[0][1].ToString() == "true")
{
checkBox1.Checked = true;
}
else
{
checkBox1.Checked = false;
}
checkBox1.Text = dt.Rows[0][2].ToString();
checkBox2.Tag = dt.Rows[1][0].ToString();
if (dt.Rows[1][1].ToString() == "true")
{
checkBox2.Checked = true;
}
else
{
checkBox2.Checked = false;
}
checkBox2.Text = dt.Rows[1][2].ToString();
checkBox3.Tag = dt.Rows[2][0].ToString();
if (dt.Rows[2][1].ToString() == "true")
{
checkBox3.Checked = true;
}
else
{
checkBox3.Checked = false;
}
checkBox3.Text = dt.Rows[2][2].ToString();
checkBox4.Tag = dt.Rows[3][0].ToString();
if (dt.Rows[3][1].ToString() == "true")
{
checkBox4.Checked = true;
}
else
{
checkBox4.Checked = false;
}
checkBox4.Text = dt.Rows[3][2].ToString();
checkBox5.Tag = dt.Rows[4][0].ToString();
if (dt.Rows[4][1].ToString() == "true")
{
checkBox5.Checked = true;
}
else
{
checkBox5.Checked = false;
}
checkBox5.Text = dt.Rows[4][2].ToString();
checkBox6.Tag = dt.Rows[5][0].ToString();
if (dt.Rows[5][1].ToString() == "true")
{
checkBox6.Checked = true;
}
else
{
checkBox6.Checked = false;
}
checkBox6.Text = dt.Rows[5][2].ToString();
checkBox7.Tag = dt.Rows[6][0].ToString();
if (dt.Rows[6][1].ToString() == "true")
{
checkBox7.Checked = true;
}
else
{
checkBox7.Checked = false;
}
checkBox7.Text = dt.Rows[6][2].ToString();
checkBox8.Tag = dt.Rows[7][0].ToString();
if (dt.Rows[7][1].ToString() == "true")
{
checkBox8.Checked = true;
}
else
{
checkBox8.Checked = false;
}
checkBox8.Text = dt.Rows[7][2].ToString();
}
else
{
MessageBox.Show("八大判异规则数据库数据不齐全！", "警告", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void SearchForm_Load(object sender, EventArgs e)
{
DataSet DSet1 = SQLClass.getDataSet("select product_name from product", "数据库信息表");
DataTable dt1 = DSet1.Tables["数据库信息表"]; //创建一个DataTable对象
cBox_product.Items.Add("全部");
cBox_product.SelectedIndex = 0;
if (dt1.Rows.Count > 0)
{
for (int i = 0; i < dt1.Rows.Count; i++)
{
cBox_product.Items.Add(dt1.Rows[i][0]);
}
}
else
{
}
DataSet DSet2 = SQLClass.getDataSet("select workshop_name from workshop", "数据库信息表");
DataTable dt2 = DSet2.Tables["数据库信息表"]; //创建一个DataTable对象
cBox_workshop.Items.Add("全部");
cBox_workshop.SelectedIndex = 0;
if (dt2.Rows.Count > 0)
{
for (int i = 0; i < dt2.Rows.Count; i++)
{
cBox_workshop.Items.Add(dt2.Rows[i][0]);
}
}
else
{
}
DataSet DSet3 = SQLClass.getDataSet("select machine_name from machine", "数据库信息表");
DataTable dt3 = DSet3.Tables["数据库信息表"]; //创建一个DataTable对象
cBox_machine.Items.Add("全部");
cBox_machine.SelectedIndex = 0;
if (dt3.Rows.Count > 0)
{
for (int i = 0; i < dt3.Rows.Count; i++)
{
cBox_machine.Items.Add(dt3.Rows[i][0]);
}
}
else
{
}
DataSet DSet4 = SQLClass.getDataSet("select worker_name from worker", "数据库信息表");
DataTable dt4 = DSet4.Tables["数据库信息表"]; //创建一个DataTable对象
cBox_worker.Items.Add("全部");
cBox_worker.SelectedIndex = 0;
if (dt4.Rows.Count > 0)
{
for (int i = 0; i < dt4.Rows.Count; i++)
{
cBox_worker.Items.Add(dt4.Rows[i][0]);
}
}
else
{
}
DataSet DSet5 = SQLClass.getDataSet("select process_name from process", "数据库信息表");
DataTable dt5 = DSet5.Tables["数据库信息表"]; //创建一个DataTable对象
cBox_process.Items.Add("全部");
cBox_process.SelectedIndex = 0;
if (dt4.Rows.Count > 0)
{
for (int i = 0; i < dt5.Rows.Count; i++)
{
cBox_process.Items.Add(dt5.Rows[i][0]);
}
}
else
{
}
}
private void MeasureForm_Load(object sender, EventArgs e)
{
int machine_num = 0;
int process_num = 0;
DataSet DSet = SQLClass.getDataSet("select measure_id,measure_data,measure_machine,measure_process from measure where measure_id = '" + data_id + "'", "数据库信息表");
DataTable dt = DSet.Tables["数据库信息表"]; //创建一个DataTable对象
DataSet machineDSet = SQLClass.getDataSet("select machine_id,machine_name from machine", "数据库信息表");
DataTable machinedt = machineDSet.Tables["数据库信息表"]; //创建一个DataTable对象
DataSet processDSet = SQLClass.getDataSet("select process_id,process_name from process", "数据库信息表");
DataTable processdt = processDSet.Tables["数据库信息表"]; //创建一个DataTable对象
if (machinedt.Rows.Count > 0 && processdt.Rows.Count > 0)
{
if (dt.Rows.Count > 0)
{
txt_measure_data.Text = dt.Rows[0][1].ToString();
txt_measure_data.Tag = "1";
cBox_measure_machine.Tag = dt.Rows[0][2].ToString();
cBox_measure_process.Tag = dt.Rows[0][3].ToString();
for (int i = 0; i < machinedt.Rows.Count; i++)
{
if (dt.Rows[0][2].ToString() == machinedt.Rows[i][0].ToString())
{
machine_num = i;
}
cBox_measure_machine.Items.Add(machinedt.Rows[i][1].ToString());
}
for (int i = 0; i < processdt.Rows.Count; i++)
{
if (dt.Rows[0][3].ToString() == processdt.Rows[i][0].ToString())
{
process_num = i;
}
cBox_measure_process.Items.Add(processdt.Rows[i][1].ToString());
}
}
else
{
for (int i = 0; i < machinedt.Rows.Count; i++)
{
cBox_measure_machine.Items.Add(machinedt.Rows[i][1].ToString());
}
for (int i = 0; i < processdt.Rows.Count; i++)
{
cBox_measure_process.Items.Add(processdt.Rows[i][1].ToString());
}
}
cBox_measure_machine.SelectedIndex = machine_num;
cBox_measure_process.SelectedIndex = process_num;
}
else
{
MessageBox.Show("还没有机床或工序信息，请先添加！", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
switch (Form_Type)
{
case 0:
break;
case 1:
break;
case 2:
txt_measure_data.ReadOnly = true;
cBox_measure_machine.Enabled = false;
cBox_measure_process.Enabled = false;
btn_reset.Visible = false;
btn_ok.Visible = false;
break;
}
checkForm();
}
