/// <summary>
/// 生产问题图片
/// </summary>
private void LoadPDPic()
{
PictureBox[] pb;
ArrayList JpgList = new ArrayList();
ArrayList pdnumList = new ArrayList();
DataTable dtTime;
// 检测路径是否存在
//MessageBox.Show(floCoding);
string strPDnum = @"SELECT PDtime FROM [YouliData].[dbo].[PDnotes] WHERE PDcoding='" + floPDCoding + "' AND PDover ='F'";
dtTime = SQLHelper2.GetDataSet(strPDnum).Tables[0];
for (int i = 0; i < dtTime.Rows.Count; i++)
{
pdnumList.Add(dtTime.Rows[i][0].ToString());
}
//MessageBox.Show(pdnumList[0].ToString());
for (int i = 0; i < pdnumList.Count; i++)
{
//通过查找当前页面的txtflocoding 找不到值
// string imagePath = @"C:\Users\Administrator\Desktop\优力资料云享版";
string imagePath = @"\\192.168.1.104\Youli_Server\ProblemFile\PDnote" + "\\" + pdnumList[i].ToString() + "\\" + " " + floPDCoding + "\\";
//MessageBox.Show(imagePath);
// OpenFileDialog openFileDialog = new OpenFileDialog();
// openFileDialog.InitialDirectory = imagePath;
//if(openFileDialog.ShowDialog() == DialogResult.OK)
// {
// }
if (Directory.Exists(imagePath))
{
DirectoryInfo dir = new DirectoryInfo(@"\\192.168.1.104\Youli_Server\ProblemFile\PDnote" + "\\" + pdnumList[i].ToString() + "\\" + " " + floPDCoding);
foreach (var file in dir.GetFiles("*.jpg"))
{
//MessageBox.Show(file.FullName);
JpgList.Add(file.FullName);
}
}
else
{
// MessageBox.Show("读取图片路径出错");
}
}
pb = new PictureBox[JpgList.Count];
for (int j = 0; j < JpgList.Count; j++)
{
pb[j] = new System.Windows.Forms.PictureBox();
pb[j].BorderStyle = BorderStyle.FixedSingle;
pb[j].SizeMode = PictureBoxSizeMode.StretchImage;
pb[j].Image = Image.FromFile(JpgList[j].ToString());
pb[j].Size = new System.Drawing.Size(370, 280);
flowLayoutPanel2.Controls.Add(pb[j]);
}
// MessageBox.Show(JpgList.Count.ToString());
}
private void LoadTableQCnotes()
{
string strnotes = @"SELECT * FROM [dbo].[QCnotes] WHERE QCcoding = (SELECT flo_coding FROM [YouliData].[dbo].[flow] WHERE flo_num = '" + editValue + "' ) AND QCover ='F'";
string strnotesCount = @"SELECT count(*) FROM [dbo].[QCnotes] WHERE QCcoding = (SELECT flo_coding FROM [YouliData].[dbo].[flow] WHERE flo_num = '" + editValue + "' ) AND QCover ='F'";
//MessageBox.Show(txtflocoding.Text);
//string strnotes = @"SELECT * FROM [dbo].[QCnotes] WHERE QCcoding = '"+this.txtflocoding.Text.Trim()+"' AND QCover ='F'";
if (SQLHelper2.GetSingleResult(strnotesCount).ToString() != "0")
{
dgvQCnotes.AutoGenerateColumns = false;
dgvQCnotes.DataSource = SQLHelper2.GetDataSet(strnotes).Tables[0];
floQCCoding = dgvQCnotes.Rows[0].Cells[2].Value.ToString();
}
}
private void loading()
{
string Sqlstr = "SELECT * FROM flow WHERE flo_num = '" + this.editValue + "'";
dt = SQLHelper2.GetDataSet(Sqlstr).Tables[0];
#region 读取sql数据存入txt文本框
txtflotime.Text = dt.Rows[0]["flo_time"].ToString();
txtflostate.Text = dt.Rows[0]["flo_state"].ToString();
txtfloclient.Text = dt.Rows[0]["flo_client"].ToString();
txtflofactory.Text = dt.Rows[0]["flo_factory"].ToString();
txtfloline.Text = dt.Rows[0]["flo_line"].ToString();
txtflonum.Text = dt.Rows[0]["flo_num"].ToString();
txtflorecord.Text = dt.Rows[0]["flo_record"].ToString();
txtflocoding.Text = dt.Rows[0]["flo_coding"].ToString();
txtflocilentID.Text = dt.Rows[0]["flo_cilentID"].ToString();
txtflomodel.Text = dt.Rows[0]["flo_model"].ToString();
txtflologo.Text = dt.Rows[0]["flo_logo"].ToString();
txtfloproname.Text = dt.Rows[0]["flo_proname"].ToString();
txtflorange.Text = dt.Rows[0]["flo_range"].ToString();
txtflounit.Text = dt.Rows[0]["flo_unit"].ToString();
txtfloreunit.Text = dt.Rows[0]["flo_reunit"].ToString();
txtflomemunit.Text = dt.Rows[0]["flo_memunit"].ToString();
txtfloframes.Text = dt.Rows[0]["flo_frames"].ToString();
txtflobackcolor.Text = dt.Rows[0]["flo_backcolor"].ToString();
txtfloclosetime.Text = dt.Rows[0]["flo_closetime"].ToString();
txtflobacktime.Text = dt.Rows[0]["flo_backtime"].ToString();
txtflorevise.Text = dt.Rows[0]["flo_revise"].ToString();
txtflocleRange.Text = dt.Rows[0]["flo_cleRange"].ToString();
txtflocleShutdown.Text = dt.Rows[0]["flo_cleShutdown"].ToString();
txtflogravity.Text = dt.Rows[0]["flo_gravity"].ToString();
txtflolevFacSet.Text = dt.Rows[0]["flo_levFacSet"].ToString();
txtflocell.Text = dt.Rows[0]["flo_cell"].ToString();
txtfloplastic.Text = dt.Rows[0]["flo_plastic"].ToString();
txtfloquantity.Text = dt.Rows[0]["flo_quantity"].ToString();
txtflodelivery.Text = dt.Rows[0]["flo_delivery"].ToString();
txtfloencase.Text = dt.Rows[0]["flo_encase"].ToString();
txtflobox.Text = dt.Rows[0]["flo_box"].ToString();
txtfloask.Text = dt.Rows[0]["flo_ask"].ToString();
txtflowback.Text = dt.Rows[0]["flo_back"].ToString();
if (dt.Rows[0]["flo_pic"].ToString() == "1")
{
chkflopic.Checked = true;
}
txtflomodibom1.Text = dt.Rows[0]["flo_modibom1"].ToString();
txtflomodibom2.Text = dt.Rows[0]["flo_modibom2"].ToString();
if (dt.Rows[0]["flo_bomVerify"].ToString() == "1")
{
chkflobomVerify.Checked = true;
}
txtflostarv.Text = dt.Rows[0]["flo_starv"].ToString();
txtfloonline.Text = dt.Rows[0]["flo_online"].ToString();
txtflooliquan.Text = dt.Rows[0]["flo_oliquan"].ToString();
txtfloelequan.Text = dt.Rows[0]["flo_elequan"].ToString();
txtfloelsequan.Text = dt.Rows[0]["flo_elsequan"].ToString();
txtflofacAlter.Text = dt.Rows[0]["flo_facAlter"].ToString();
txtflofristMake.Text = dt.Rows[0]["flo_fristMake"].ToString();
txtflofristChk.Text = dt.Rows[0]["flo_fristChk"].ToString();
txtfloProSum.Text = dt.Rows[0]["flo_ProSum"].ToString();
txtflospotChk.Text = dt.Rows[0]["flo_spotChk"].ToString();
if (dt.Rows[0]["flo_out"].ToString() == "Y")
{
chkout.Checked = true;
}
if (dt.Rows[0]["flo_finish"].ToString() == "Y")
{
checkBox1.Checked = true;
}
if (dt.Rows[0]["flo_finishTo"].ToString() == "Y")
{
chkfinish.Checked = true;
}
#endregion
}