private void buttonLogin_Click(object sender, EventArgs e)
{
//******************************************
//关闭软键盘
//******************************************
try
{
kbpr.Kill();
}
catch
{
}
if (textBoxID.Text == "")
{
PublicClass.message = "姓名或者工号不能为空！";
messageboxForm = new MessageBoxForm(1);
messageboxForm.Owner = this;
messageboxForm.ShowDialog();
return;
}
if (textBoxPassword.Text == "")
{
PublicClass.message = "密码不能为空！";
messageboxForm = new MessageBoxForm(1);
messageboxForm.Owner = this;
messageboxForm.ShowDialog();
return;
}
//******************************************
//查询数据库，验证登录账户，密码，及用户权限
//******************************************
sqlcmd = "select * from clothemployeedetails where employeeID='" + textBoxID.Text + "'";
mysqlcmd = getSqlCommand(sqlcmd, PublicClass.conn);
mysqldr = mysqlcmd.ExecuteReader();
if (mysqldr.HasRows)
{
mysqldr.Read();
{
if (mysqldr["Password"].ToString() == textBoxPassword.Text)
{
//登录成功
if (Convert.ToInt32(mysqldr["Authority"].ToString()) == 1)
{
//管理员模式
AdminForm adminForm = new AdminForm();
adminForm.ShowDialog();
}
else
{
if (Convert.ToInt32(mysqldr["Department"].ToString()) == 1)
{
//检测部门
// DetectForm detectForm = new DetectForm();
PublicClass.detecterName = mysqldr["employeename"].ToString();
PublicClass.detecterID = textBoxID.Text;
MultiBoardSyncGrabDemoDlg form = new MultiBoardSyncGrabDemoDlg();
Application.Run(form);
// form.ShowDialog();
}
else
{
//销售部门
PublicClass.message = "非检测部门员工不能操作设备！";
messageboxForm = new MessageBoxForm(1);
messageboxForm.Owner = this;
messageboxForm.ShowDialog();
return;
}
}
}
else
{
PublicClass.message = "密码错误！";
messageboxForm = new MessageBoxForm(1);
messageboxForm.Owner = this;
messageboxForm.ShowDialog();
}
}
mysqldr.Close();
}
else
{
mysqldr.Close();
sqlcmd = "select * from clothemployeedetails where employeename='" + textBoxID.Text + "'";
mysqlcmd = getSqlCommand(sqlcmd, PublicClass.conn);
mysqldr = mysqlcmd.ExecuteReader();
if (mysqldr.HasRows)
{
mysqldr.Read();
{
if (mysqldr["Password"].ToString() == textBoxPassword.Text)
{
//登录成功
if (Convert.ToInt32(mysqldr["Authority"].ToString()) == 1)
{
mysqldr.Close();
//管理员模式
AdminForm adminForm = new AdminForm();
adminForm.ShowDialog();
this.Hide();
}
else
{
if (Convert.ToInt32(mysqldr["Department"].ToString()) == 1)
{
//检测部门
this.Hide();
//PublicClass.message = "初始化相机中";
//messageboxForm = new MessageBoxForm(1,1000);
//messageboxForm.Owner = this;
//messageboxForm.ShowDialog();
PublicClass.detecterID = mysqldr["employeeID"].ToString();
PublicClass.detecterName = textBoxID.Text;
MultiBoardSyncGrabDemoDlg form = new MultiBoardSyncGrabDemoDlg();
form.Show();
//System.Threading.Thread.Sleep(1000);
// this.Close();
}
else
{
//销售部门
PublicClass.message = "非检测部门员工不能操作设备！";
messageboxForm = new MessageBoxForm(1);
messageboxForm.Owner = this;
messageboxForm.ShowDialog();
return;
}
}
}
else
{
PublicClass.message = "密码错误！";
messageboxForm = new MessageBoxForm(1);
messageboxForm.Owner = this;
messageboxForm.ShowDialog();
}
}
}
else
{
PublicClass.message = "工号或者姓名不存在！";
messageboxForm = new MessageBoxForm(1);
messageboxForm.Owner = this;
messageboxForm.ShowDialog();
}
mysqldr.Close();
}
}
private void SQLForm_Load(object sender, EventArgs e)
{
/*************************************
* 读取色差等级
*************************************/
PublicClass.conn = new MySqlConnection(PublicClass.mysqlcon);
PublicClass.conn.Open();
PublicClass.message = "数据库连接成功！";
sqlcmd = "select * from clothaberrationgrad";
// sqlcmd = "select * from clothdetectresult where ClothNumber ='" + tempClothNumber + "'";
mysqlcmd = getSqlCommand(sqlcmd, PublicClass.conn);
//mysqlcmd.CommandType = CommandType.Text;
//adastAdapter = new MySqlDataAdapter(mysqlcmd);
//DataTable pdt = new DataTable();
//adastAdapter.Fill(pdt);
//this.dataGridView1.DataSource = pdt;
mysqldr = mysqlcmd.ExecuteReader();
if (mysqldr.HasRows)
{
while (mysqldr.Read())
{
chromaticAberration1 = Convert.ToDouble(mysqldr["clothaberrationgrad1"].ToString());
chromaticAberration2 = Convert.ToDouble(mysqldr["clothaberrationgrad2"].ToString());
chromaticAberration3 = Convert.ToDouble(mysqldr["clothaberrationgrad3"].ToString());
chromaticAberration4 = Convert.ToDouble(mysqldr["clothaberrationgrad4"].ToString());
break;
}
}
mysqldr.Close();
button6.Text = "0.0-" + chromaticAberration4.ToString();
button5.Text = chromaticAberration4.ToString() + "-" + chromaticAberration3.ToString();
button4.Text = chromaticAberration3.ToString() + "-" + chromaticAberration2.ToString();
button3.Text = chromaticAberration2.ToString() + "-" + chromaticAberration1.ToString();
button2.Text = ">" + chromaticAberration1.ToString();
string tempClothNumber = PublicClass.clothNumber;//"201911032321";d
sqlcmd = "select * from clothdetectreport where ClothNumber ='" + tempClothNumber + "'";
mysqlcmd = getSqlCommand(sqlcmd, PublicClass.conn);
mysqlcmd.CommandType = CommandType.Text;
adastAdapter = new MySqlDataAdapter(mysqlcmd);
DataTable pdt = new DataTable();
adastAdapter.Fill(pdt);
this.dataGridView1.DataSource = pdt;
DataTable savepdt = new DataTable();
savepdt = GetDgvToTable(dataGridView1);
ExportToExcel(savepdt, PublicClass.reportpath + "色差检测详细表.xls");
// ExportToExcel(pdt, PublicClass.reportpath + "text1.xls");
tabControl1.Enabled = true;
tempClothNumber = PublicClass.clothNumber; //查询布匹编号string
float standardColor = 0; //定义标准色差
/*************************************
* 查询销售员工名字
*************************************/
string theSourceName = "";
sqlcmd = "select * from clothemployeedetails where employeeID in (select SourceID from clothdetectdetail where ClothNumber =" + tempClothNumber + ")";
mysqlcmd = getSqlCommand(sqlcmd, PublicClass.conn);
mysqldr = mysqlcmd.ExecuteReader();
if (mysqldr.HasRows)
{
while (mysqldr.Read())
{
theSourceName = mysqldr["employeeName"].ToString();
break;
}
}
mysqldr.Close();
/*************************************
* 查询操作员工名字
*************************************/
string theOperatorName = "";
sqlcmd = "select * from clothemployeedetails where employeeID in (select OperatorID from clothdetectdetail where ClothNumber =" + tempClothNumber + ")";
mysqlcmd = getSqlCommand(sqlcmd, PublicClass.conn);
mysqldr = mysqlcmd.ExecuteReader();
if (mysqldr.HasRows)
{
while (mysqldr.Read())
{
theOperatorName = mysqldr["employeeName"].ToString();
break;
}
}
mysqldr.Close();
/*************************************
* 查询布匹检测详情，并加载到tagPage2里面
*************************************/
tabPage2.Invalidate();
sqlcmd = "select * from clothdetectdetail where ClothNumber =" + tempClothNumber;
mysqlcmd = getSqlCommand(sqlcmd, PublicClass.conn);
mysqldr = mysqlcmd.ExecuteReader();
if (mysqldr.HasRows)
{
while (mysqldr.Read())
{
try
{
standardColor = Convert.ToSingle(mysqldr["StandardColorLAB"].ToString());
}
catch
{
}
labelClothNumber.Text = mysqldr["ClothNumber"].ToString();
labelBatchNumber.Text = mysqldr["BatchNumber"].ToString();
labelClassNumber.Text = mysqldr["ClothClassNumber"].ToString();
labelEquipmentNumber.Text = mysqldr["EquipmentNumber"].ToString();
labelVolumn.Text = mysqldr["TotalVolumn"].ToString() + "-" + mysqldr["VolumnNumber"].ToString();
labelCylinderNumber.Text = mysqldr["CylinderNumber"].ToString();
labelSource.Text = theSourceName;
labelOperator.Text = theOperatorName;
labelMeters.Text = mysqldr["LabelMeters"].ToString();
labelActualMeters.Text = mysqldr["ActualMeters"].ToString();
labelActualM1.Text = mysqldr["ActualMeters"].ToString();
labelActualM.Text = mysqldr["ActualMeters"].ToString();
labelMaxWidth.Text = mysqldr["MaxWidth"].ToString();
labelMinWidth.Text = mysqldr["MinWidth"].ToString();
labelMeanWidth.Text = mysqldr["MeanWidth"].ToString();
labelDate.Text = mysqldr["Date"].ToString().Split(' ')[0];
labelStartTime.Text = mysqldr["StartTime"].ToString();
labelEndTime.Text = mysqldr["EndTime"].ToString();
labelStandardL.Text = mysqldr["StandardColorL"].ToString();
labelStandardA.Text = mysqldr["StandardColorA"].ToString();
labelStandardB.Text = mysqldr["StandardColorB"].ToString();
labelStandardLAB.Text = mysqldr["StandardColorLAB"].ToString();
labelMaxDiffL.Text = mysqldr["MaxLDiff"].ToString();
labelMaxDiffA.Text = mysqldr["MaxADiff"].ToString();
labelMaxDiffB.Text = mysqldr["MaxBDiff"].ToString();
labelMaxDiffLAB.Text = mysqldr["MaxLABDiff"].ToString();
labelStandardL1.Text = mysqldr["StandardColorL"].ToString();
labelStandardA1.Text = mysqldr["StandardColorA"].ToString();
labelStandardB1.Text = mysqldr["StandardColorB"].ToString();
labelStandardLAB1.Text = mysqldr["StandardColorLAB"].ToString();
labelMaxDiffL1.Text = mysqldr["MaxLDiff"].ToString();
labelMaxDiffA1.Text = mysqldr["MaxADiff"].ToString();
labelMaxDiffB1.Text = mysqldr["MaxBDiff"].ToString();
labelMaxDiffLAB1.Text = mysqldr["MaxLABDiff"].ToString();
labelDefectNumber.Text = mysqldr["DefectNumber"].ToString();
richTextBox1.Clear();
richTextBox1.AppendText(mysqldr["AberrationDetails"].ToString() + "\r\n");
richTextBox1.AppendText(mysqldr["DefectDetails"].ToString() + "\r\n");
label11.Text = "色差详情：" + mysqldr["AberrationDetails"].ToString() + "\r\n";
label1.Text = "缺陷详情：" + mysqldr["DefectDetails"].ToString() + "\r\n";
try
{
actualMeters = Convert.ToSingle(mysqldr["ActualMeters"].ToString());
qualifiedMeters = Convert.ToSingle(mysqldr["QualifiedMeters"].ToString());
aberrationGrad1Meters = Convert.ToSingle(mysqldr["AberrationGrad1Meters"].ToString());
aberrationGrad2Meters = Convert.ToSingle(mysqldr["AberrationGrad2Meters"].ToString());
aberrationGrad3Meters = Convert.ToSingle(mysqldr["AberrationGrad3Meters"].ToString());
aberrationGrad4Meters = Convert.ToSingle(mysqldr["AberrationGrad4Meters"].ToString());
aberrationGrad5Meters = Convert.ToSingle(mysqldr["AberrationGrad5Meters"].ToString());
}
catch
{
}
ImagePath = mysqldr["ImagePath"].ToString();
break;
}
mysqldr.Close();
}
else
{
PublicClass.message = "没有检测结果";
messageboxForm = new MessageBoxForm(1);
messageboxForm.Owner = this;
messageboxForm.ShowDialog();
mysqldr.Close();
return;
}
/*************************************
* 遍历布匹检测详情数据库
*************************************/
sqlcmd = "select * from clothdetectresult where ClothNumber ='" + tempClothNumber + "'";
mysqlcmd = getSqlCommand(sqlcmd, PublicClass.conn);
mysqldr = mysqlcmd.ExecuteReader();
int j = 0;
while (mysqldr.Read())
{
// intervalMeter = Convert.ToSingle(mysqldr["IntervalMeter"].ToString());//获取间隔米数
label40.Text = "每格米数:" + mysqldr["IntervalMeter"].ToString();
// boxNumber = mysqldr.GetInt32("BoxNumber");
ImageFiles.Add(mysqldr["ImagePath"].ToString());
//double []boxColors = new double[10];
double MaxDiff = 0;
for (int i = 1; i <= 1; i++)
{
double tempColor = mysqldr["Box" + i.ToString() + "Color"] == DBNull.Value ? 0 : Convert.ToSingle(mysqldr["Box" + i.ToString() + "Color"]);
double tempDiff = tempColor;
//Math.Abs(tempColor - standardColor);
if (tempDiff > MaxDiff)
{
MaxDiff = tempDiff;
}
}
MaxDiffList.Add(MaxDiff);
j++;
}
mysqldr.Close();
tabPage1.Invalidate();
/***************************************
* 查询布匹检测详情，将结果放到图片浏览界面
*************************************/
//int ImageNumber =Convert.ToInt32( Math.Ceiling(actualMeters / intervalMeter));
int ImageNumber = ImageFiles.Count;
trackBar1.Value = 0;
if (ImageNumber > 0 && ImageFiles[0] != null)
{
trackBar1.Minimum = 0;
trackBar1.Maximum = ImageNumber - 1;
try
{
// pictureBox1.Image = Image.FromFile(ImageFiles[0]);
string tempstr = System.IO.Path.GetDirectoryName(ImagePath);
string imageFile = ImageFiles[0];
// int Index1 = imageFile.IndexOf(".jpg");
// int Index2 = imageFile.IndexOf("-");
// string currentMeter = imageFile.Substring(Index2, Index1 - Index2);
if (checkBox1.Checked == false)
{
pictureBox1.Image = Image.FromFile(tempstr + "\\检测图\\" + (trackBar1.Value + 1).ToString() + ".jpg");
}
else
{
pictureBox1.Image = Image.FromFile(tempstr + "\\原图\\" + (trackBar1.Value + 1).ToString() + ".jpg");
}
// labelCurrentM.Text = labelActualMeters.Text + currentMeter;
}
catch (Exception ed)
{
}
}
else
{
trackBar1.Enabled = false;
}
tabPage5.Invalidate();
/*************************************
* 查询布匹检测详情，将结果放到图表里面
*************************************/
float qualifiedPercents = (qualifiedMeters / actualMeters);
float unQualifiedPercents = (actualMeters - qualifiedMeters) / actualMeters;
List <string> xData = new List <string>()
{
"合格率:" + (qualifiedPercents * 100).ToString("0.00") + "%", "折损率:" + (unQualifiedPercents * 100).ToString("0.00") + "%"
};
List <float> yData = new List <float>()
{
float.Parse(qualifiedPercents.ToString("0.00")), float.Parse(unQualifiedPercents.ToString("0.00"))
};
//chart1.seri
// chart1.Series[0].Points[0].Color = Color.Green;
chart1.Series[0]["PieLabelStyle"] = "Outside";
chart1.Series[0]["PieLabelStyle"] = "Outside"; //将文字移到外侧
chart1.Series[0]["PieLineColor"] = "Black"; //绘制黑色的连线。
chart1.Series[0].Points.DataBindXY(xData, yData);
labelActualM.Text = actualMeters.ToString("0.00") + "米";
labelQulifiedM.Text = qualifiedMeters.ToString("0.00") + "米";
labelLoseM.Text = (actualMeters - qualifiedMeters).ToString("0.00") + "米";
chart2.Series[0].Points.AddXY("色差等级1", aberrationGrad1Meters);
chart2.Series[0].Points.AddXY("色差等级2", aberrationGrad2Meters);
chart2.Series[0].Points.AddXY("色差等级3", aberrationGrad3Meters);
chart2.Series[0].Points.AddXY("色差等级4", aberrationGrad4Meters);
chart2.Series[0].Points.AddXY("色差等级5", aberrationGrad5Meters);
chart2.Series[0].Points[0].Color = Color.Green;
chart2.Series[0].Points[1].Color = Color.LimeGreen;
chart2.Series[0].Points[2].Color = Color.YellowGreen;
chart2.Series[0].Points[3].Color = Color.Orange;
chart2.Series[0].Points[4].Color = Color.Red;
chart2.ChartAreas[0].AxisY.TitleFont = new System.Drawing.Font("微软雅黑", 15F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
chart2.ChartAreas[0].AxisY.Title = "单位：米数";
chart2.Series[0].IsValueShownAsLabel = true;
chart2.Series[0].Font = new System.Drawing.Font("微软雅黑", 15F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
tabPage4.Invalidate();
}
private void button1_Click(object sender, EventArgs e)
{
try
{
kbpr.Kill();
}
catch
{
}
if (textBoxID.Text == "")
{
PublicClass.message = "姓名或者工号不能为空！";
messageboxForm = new MessageBoxForm(1);
messageboxForm.Owner = this;
messageboxForm.ShowDialog();
return;
}
if (textBoxOldPassword.Text == "" || textBoxNewPassword.Text == "" || textBoxNewPassword1.Text == "")
{
PublicClass.message = "密码不能为空！";
messageboxForm = new MessageBoxForm(1);
messageboxForm.Owner = this;
messageboxForm.ShowDialog();
return;
}
if (textBoxNewPassword.Text != textBoxNewPassword1.Text)
{
PublicClass.message = "两次密码不一致！";
messageboxForm = new MessageBoxForm(1);
messageboxForm.Owner = this;
messageboxForm.ShowDialog();
return;
}
sqlcmd = "select * from clothemployeedetails where employeeID='" + textBoxID.Text + "'";
mysqlcmd = getSqlCommand(sqlcmd, PublicClass.conn);
mysqldr = mysqlcmd.ExecuteReader();
if (mysqldr.HasRows)
{
mysqldr.Read();
if (mysqldr["Password"].ToString() == textBoxOldPassword.Text)
{
ID = mysqldr["employeeID"].ToString();
//登录成功
logSucces = true;
}
else
{
PublicClass.message = "旧密码错误！";
messageboxForm = new MessageBoxForm(1);
messageboxForm.Owner = this;
messageboxForm.ShowDialog();
}
mysqldr.Close();
}
else
{
mysqldr.Close();
sqlcmd = "select * from clothemployeedetails where employeename='" + textBoxID.Text + "'";
mysqlcmd = getSqlCommand(sqlcmd, PublicClass.conn);
mysqldr = mysqlcmd.ExecuteReader();
if (mysqldr.HasRows)
{
mysqldr.Read();
if (mysqldr["Password"].ToString() == textBoxOldPassword.Text)
{
ID = mysqldr["employeeID"].ToString();
//登录成功
logSucces = true;
}
else
{
PublicClass.message = "旧密码错误！";
messageboxForm = new MessageBoxForm(1);
messageboxForm.Owner = this;
messageboxForm.ShowDialog();
}
}
else
{
PublicClass.message = "工号或者姓名不存在！";
messageboxForm = new MessageBoxForm(1);
messageboxForm.Owner = this;
messageboxForm.ShowDialog();
}
mysqldr.Close();
}
if (logSucces)
{
DialogResult result = MessageBox.Show("确定修改密码？", "温馨提示", MessageBoxButtons.YesNo);
if (result == DialogResult.Yes)
{
try
{
sqlcmd = "update clothemployeedetails set password='******' where employeeID = " + ID;
mysqlcmd = getSqlCommand(sqlcmd, PublicClass.conn);
mysqlcmd.ExecuteNonQuery();
PublicClass.message = "密码修改成功！";
messageboxForm = new MessageBoxForm(1);
messageboxForm.Owner = this;
messageboxForm.ShowDialog();
}
catch
{
PublicClass.message = "密码修改失败！";
messageboxForm = new MessageBoxForm(1);
messageboxForm.Owner = this;
messageboxForm.ShowDialog();
}
}
}
logSucces = false;
}