using System; using System.Collections.Generic; using System.ComponentModel; using System.Drawing; using System.Windows.Forms; using System.Data; using System.Linq; using System.Text; using System.Windows.Forms; using ICSSoft.Base.Config.AppConfig; using DevExpress.XtraEditors; using ICSSoft.Frame.Data.BLL; using System.Data.SqlClient; using ICSSoft.Base.Config.DBHelper; using System.IO; namespace ICSSoft.Frame.APP { public partial class UserControlDrawShow : UserControl { public string EQPType; string itemCode = ""; string routeCode = ""; string itemname = ""; string itemstd = ""; String guid = AppConfig.GetGuid(); //WorkPointBLL workBll = new WorkPointBLL(); public UserControlDrawShow() { InitializeComponent(); rdoLOTNO.Checked = true; //rdoFileID.Checked = true; txtLOTNO.Focus(); txtType.Items.Clear(); txtType.Items.Add(FileDrawing.TuZhi); //txtType.Items.Add(FileDrawing.WuLiao); txtType.Items.Add(FileDrawing.CuJiaGong); txtType.Items.Add(FileDrawing.ZuoYeZhiDao); //txtType.Items.Add(FileDrawing.YaoSu); //txtType.Items.Add(FileDrawing.GuanCha); //txtType.Items.Add(FileDrawing.ZuHe); txtType.Items.Add(FileDrawing.SZuoYeZhiDao); txtType.Items.Add(FileDrawing.SheBei); txtType.Items.Add(FileDrawing.WPS); txtType.Items.Add(FileDrawing.ChengXu); //txtType.Items.Add(FileDrawing.ShiPin); txtType.Items.Add(FileDrawing.ZhuYi); txtType.Items.Add(FileDrawing.GuiFan); txtType.Items.Add(FileDrawing.WenTi); txtType.Items.Add(FileDrawing.PeiXun); } #region 移动窗体 private const int WM_NCHITTEST = 0x84; private const int HTCLIENT = 0x1; private const int HTCAPTION = 0x2; //首先必须了解Windows的消息传递机制，当有鼠标活动消息时， //系统发送WM_NCHITTEST 消息给窗体作为判断消息发生地的根据。 nchittest //假如你点击的是标题栏，窗体收到的消息值就是 HTCAPTION ， //同样地，若接受到的消息是 HTCLIENT，说明用户点击的是客户区，也就是鼠标消息发生在客户区。 //重写窗体，使窗体可以不通过自带标题栏实现移动 protected override void WndProc(ref Message m) { //当重载窗体的 WndProc 方法时，可以截获 WM_NCHITTEST 消息并改些该消息， //当判断鼠标事件发生在客户区时，改写改消息，发送 HTCAPTION 给窗体， //这样，窗体收到的消息就时 HTCAPTION ，在客户区通过鼠标来拖动窗体就如同通过标题栏来拖动一样。 //注意：当你重载 WndProc 并改写鼠标事件后，整个窗体的鼠标事件也就随之改变了。 switch (m.Msg) { case WM_NCHITTEST: base.WndProc(ref m); if ((int)m.Result == HTCLIENT) m.Result = (IntPtr)HTCAPTION; return; } //拦截双击标题栏、移动窗体的系统消息 if (m.Msg != 0xA3) { base.WndProc(ref m); } } #endregion private void btnDownload_Click(object sender, EventArgs e) { SimpleButton btntemp = (SimpleButton)sender; //if (AppConfig.GetUserExcuteRight(this.Tag.ToString(), btntemp.Name) == false) //{ // ICSBaseSimpleCode.AppshowMessageBox("对不起您没有:" + btntemp.Text + "权限,请联系系统管理员！"); // return; //} if (string.IsNullOrEmpty(this.txtLOTNO.Text.Trim()) && string.IsNullOrEmpty(this.txtFileID.Text.Trim())) { ICSBaseSimpleCode.AppshowMessageBox("请输入条件！"); return; } if (!string.IsNullOrEmpty(this.txtLOTNO.Text.Trim())) { MOByMoCode(this.txtLOTNO.Text.Trim()); } else { SearchItem(this.txtFileID.Text.Trim()); } } #region 根据存货编码产品信息 private void SearchItem(string itemcode) { try { string sql = @"SELECT ItemName, ItemStd,ROUTECODE FROM Base_Inventory a LEFT JOIN (SELECT h.ItemCode, CASE WHEN i.ROUTECODE IS NULL THEN j.ROUTECODE ELSE i.ROUTECODE END AS ROUTECODE FROM Base_Inventory h LEFT JOIN (SELECT * FROM ICSITEM2ROUTE WHERE ISREF = '是') i ON h.ItemCode = i.ITEMCODE LEFT JOIN (SELECT * FROM ICSMODEL2ROUTE WHERE ISREF = '是') j ON h.ItemMainCategoryCode=j.MODELCODE) d ON a.ItemCode=d.ItemCode WHERE a.ItemCode='{0}' "; sql = string.Format(sql, itemcode); SqlDataReader rd = DBHelper.ExecuteReader(AppConfig.AppConnectString, CommandType.Text, sql); while (rd.Read()) { itemCode = itemcode; itemname = rd["ItemName"].ToString(); itemstd = rd["ItemStd"].ToString(); routeCode = rd["ROUTECODE"].ToString(); } if (string.IsNullOrEmpty(itemCode)) { ICSBaseSimpleCode.AppshowMessageBox("未查到对应的产品！"); return; } else { BandData(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } } #endregion #region 根据存货编码查询列表信息 private void BandData() { try { #region 查询数据 //图纸 string sqlTUZHI = @"SELECT DISTINCT A.CDOCUMENTNAME AS [FileName], A.CDOCUMENTID AS FileID, A.CDOCUMENTVER AS FileVer, A.CDFORMAT AS FileFormat, A.CDOCUMENTID, '' as ItemCode, '' as ItemName, '' as ItemStd FROM DOC_008 A LEFT JOIN BOM_026 B ON A.CDOCUMENTID = B.CDOCUMENTID And A.CDOCUMENTVER = B.CDOCUMENTVER LEFT JOIN DOC_017 C ON A.CMKINDID=C.CMKINDID WHERE B.PARTID like '%{1}%' AND A.CDFORMAT in ({0})"; //工艺、视频、--规范 string sqlGONGYI = @"SELECT DISTINCT CDOCUMENTNAME as [FileName], CDOCUMENTID as FileID, CDOCUMENTVER as FileVer, CDFORMAT as FileFormat, CDOCUMENTID, '' as ItemCode, '' as ItemName, '' as ItemStd from DOC_008 where CDOCUMENTID like '%{1}%' AND CDFORMAT in ({0})"; //作业指导书 string sqlZuoYeZhiDao = @"SELECT DISTINCT CDOCUMENTNAME as [FileName], CDOCUMENTID as FileID, CDOCUMENTVER as FileVer, CDFORMAT as FileFormat, CDOCUMENTID, '' as ItemCode, '' as ItemName, '' as ItemStd from DOC_008 where CDOCUMENTNAME like '%{1}%' AND CDFORMAT in ({0})"; #endregion string suffix = ""; string sql = ""; if (chkType.Checked) { string type = txtType.Text.Trim(); if (string.IsNullOrWhiteSpace(type)) { suffix = "'pdf','mp4','dwg','CNC'"; sql = string.Format(sqlTUZHI, suffix, itemCode); sql += " UNION " + string.Format(sqlGONGYI, suffix, "%" + routeCode + "%' OR CDOCUMENTID like '" + itemCode); sql += " UNION " + string.Format(sqlZuoYeZhiDao, suffix, "%" + routeCode); } else if (type.Equals(FileDrawing.ZuoYeZhiDao)) { suffix = "'pdf'"; sql = string.Format(sqlZuoYeZhiDao, suffix, routeCode); } else if (type.Equals(FileDrawing.ZuHe) || type.Equals(FileDrawing.YaoSu) || type.Equals(FileDrawing.GuanCha) || type.Equals(FileDrawing.WPS)) { string newRouteCode=""; if (type.Equals(FileDrawing.YaoSu)) newRouteCode = "YS-" + routeCode; else if (type.Equals(FileDrawing.GuanCha)) newRouteCode = "GC-" + routeCode; else if (type.Equals(FileDrawing.ZuHe)) newRouteCode = "ZH-" + routeCode; else if (type.Equals(FileDrawing.WPS)) newRouteCode = "WPS-" + itemCode; suffix = "'pdf'"; sql = string.Format(sqlGONGYI, suffix, newRouteCode); } else if (type.Equals(FileDrawing.ChengXu)) { suffix = "'CNC'"; sql = string.Format(sqlGONGYI, suffix, itemCode); } else if (type.Equals(FileDrawing.ShiPin)) { suffix = "'mp4'"; sql = string.Format(sqlGONGYI,suffix,routeCode); } else if (type.Equals(FileDrawing.TuZhi) || type.Equals(FileDrawing.CuJiaGong)) { suffix = "'pdf','dwg'"; sql = string.Format(sqlTUZHI, suffix, itemCode); if (type.Equals(FileDrawing.CuJiaGong)) sql += " AND C.CMKINDNAME = 'CJ-粗加工'"; } else { if (string.IsNullOrWhiteSpace(EQPType)) { ICSBaseSimpleCode.AppshowMessageBox("请先扫描设备条码！"); return; } else { if (type.Equals(FileDrawing.SZuoYeZhiDao)) { string newEQPType = "5S-" + EQPType; suffix = "'pdf'"; sql = string.Format(sqlGONGYI, suffix, newEQPType); } else if (type.Equals(FileDrawing.SheBei)) { string newEQPType = "SG-" + EQPType; suffix = "'pdf'"; sql = string.Format(sqlGONGYI, suffix, newEQPType); } } } } else { suffix = "'pdf','mp4','dwg','CNC'"; sql = string.Format(sqlTUZHI, suffix, itemCode); sql += " UNION " + string.Format(sqlGONGYI, suffix, "%" + routeCode + "%' OR CDOCUMENTID like '" + itemCode); sql += " UNION " + string.Format(sqlZuoYeZhiDao, suffix, "%" + routeCode); } #region new // string sql = @"SELECT DISTINCT // T.CDOCUMENTNAME as [FileName], // T.CDOCUMENTID as FileID, // T.CDOCUMENTVER as FileVer, // T.CDFORMAT as FileFormat, // '' as ItemCode, // '' as ItemName, // '' as ItemStd // // FROM // DOC_008 T // LEFT OUTER JOIN DOC_030 S ON (T.SECRECYGRADEID = S.SECRECYGRADEID) // LEFT OUTER JOIN SYS_057 SORT ON (T.SORTID = SORT.SORTID) // LEFT OUTER JOIN SYS_019 Q ON (T.CMODIFIER = Q.CPERSONID), // DOC_026 T_ADD, // SYS_019 P, // DOC_017 K, // BOM_026 M // WHERE // T.CDOCUMENTID = M.CDOCUMENTID // AND T.CDOCUMENTVER = M.CDOCUMENTVER // AND T.CDOCUMENTID = T_ADD.CDOCUMENTID // AND T.CDOCUMENTVER = T_ADD.CDOCUMENTVER // AND T.CCREATORID = P.CPERSONID // AND T.CMKINDID = K.CMKINDID // AND M.PARTVAR = 'A1' "; // if (!string.IsNullOrEmpty(itemCode)) // { // sql += "and M.PARTID like '%" + itemCode + "%' "; // } #endregion #region old // string sql = @"SELECT A.CDOCUMENTID as FileID, // A.CDOCUMENTVER as FileVer, // A.CDOCUMENTNAME as [FileName], // A.CDFORMAT as FileFormat // FROM DOC_008 A // LEFT OUTER JOIN DOC_030 D ON(A.SECRECYGRADEID=D.SECRECYGRADEID) // LEFT OUTER JOIN SYS_057 E ON (A.SORTID = E.SORTID) // LEFT OUTER JOIN SYS_019 Q ON (A.CMODIFIER = Q.CPERSONID) // LEFT OUTER JOIN DOC_026 B ON(A.CDOCUMENTID=B.CDOCUMENTID AND A.CDOCUMENTVER=B.CDOCUMENTVER) // LEFT OUTER JOIN (SELECT A.CDOCUMENTID, A.CDOCUMENTVER, C.CANAME, D.CPERSONNAME,E.CSTATENAME FROM DOC_011 A, PRJ_001 C, DOC_025 B LEFT JOIN SYS_019 D ON (B.CPERSONID = D.CPERSONID), DOC_013 E // WHERE E.INTERNATIONKEY = 'zh_CN' AND A.CTASKID = B.CTASKID AND B.CACTIVEID = C.CACTIVEID AND E.CSTATEID = B.CSTATEID AND ISNULL(A.CDOCUMENTID,'') <> '' AND ISNULL(A.CDOCUMENTVER,'') <> '' AND (B.CSTATEID = '2' OR B.CSTATEID = '3') AND A.CSTATEID <> '4' AND A.CSTATEID <> '5' AND E.INTERNATIONKEY = 'zh_CN') AS CHK // ON (A.CDOCUMENTID = CHK.CDOCUMENTID AND A.CDOCUMENTVER = CHK.CDOCUMENTVER), SYS_019 C ,DOC_017 F // WHERE A.CCREATORID=C.CPERSONID and A.CMKINDID=F.CMKINDID "; // if (!string.IsNullOrEmpty(itemCode)) // { // sql += "and a.CDOCUMENTID like '%" + itemCode + "%' "; // } #endregion // string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["PLM"].ConnectionString.ToString(); // string connectionString = "Data Source=ICSSERVER01\\MSSQLSERVER2012;Database=yonyou20160331153618;Uid=sa;Pwd=aA123456;"; string connectionString = AppConfig.GetDataBaseConnectStringByKey("[DB.PLM]"); DataTable dt = DBHelper.ExecuteDataset(connectionString, CommandType.Text, sql).Tables[0]; if (dt != null && dt.Rows.Count <= 0) { ICSBaseSimpleCode.AppshowMessageBox("未查到该产品对应的文件信息！"); } else { foreach (DataRow dr in dt.Rows) { dr["ItemCode"] = itemCode; dr["ItemName"] = itemname; dr["ItemStd"] = itemstd; } } this.grdDetail.DataSource = dt; this.grvDetail.BestFitColumns(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } #endregion #region 根据批次号查询工单产品信息 private void MOByMoCode(string MOCode) { try { string sql = @"SELECT a.MOCODE, a.ITEMCODE, c.ItemName, c.ItemStd,ROUTECODE FROM ICSMO a INNER JOIN ICSMO2Lot b ON a.MOCODE = b.MOCODE LEFT JOIN Base_Inventory c on a.ITEMCODE=c.ItemCode LEFT JOIN (SELECT h.ItemCode, CASE WHEN i.ROUTECODE IS NULL THEN j.ROUTECODE ELSE i.ROUTECODE END AS ROUTECODE FROM Base_Inventory h LEFT JOIN (SELECT * FROM ICSITEM2ROUTE WHERE ISREF = '是') i ON h.ItemCode = i.ITEMCODE LEFT JOIN (SELECT * FROM ICSMODEL2ROUTE WHERE ISREF = '是') j ON h.ItemMainCategoryCode=j.MODELCODE) d ON c.ItemCode=d.ItemCode WHERE LOTNO='{0}' "; sql = string.Format(sql, MOCode); SqlDataReader rd = DBHelper.ExecuteReader(AppConfig.AppConnectString, CommandType.Text, sql); while (rd.Read()) { itemCode = rd["ITEMCODE"].ToString(); itemname = rd["ItemName"].ToString(); itemstd = rd["ItemStd"].ToString(); routeCode = rd["ROUTECODE"].ToString(); } //DataTable dt = DBHelper.ExecuteDataset(AppConfig.AppConnectString, CommandType.Text, sql).Tables[0]; //foreach (DataRow dr in dt.Rows) //{ // itemCode = dr["ITEMCODE"].ToString(); //} if (string.IsNullOrEmpty(itemCode)) { ICSBaseSimpleCode.AppshowMessageBox("未查到对应的产品！"); return; } else { BandData(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } } #endregion private void UserControlDrawShow_Load(object sender, EventArgs e) { //DeleteFile(); } public void DeleteFile() { try { //获取文件夹 //string path = Server.MapPath("Image"); string filePath = System.IO.Path.GetTempPath() + "\\tempfiles"; //获取文件夹中所有图片 if (Directory.GetFileSystemEntries(filePath).Length > 0) { //遍历文件夹中所有文件 foreach (string file in Directory.GetFiles(filePath)) { try { //文件己存在 if (File.Exists(file)) { FileInfo fi = new FileInfo(file); //判断当前文件属性是否是只读 if (fi.Attributes.ToString().IndexOf("ReadyOnly") >= 0) { fi.Attributes = FileAttributes.Normal; } //删除文件 File.Delete(file); } } catch (Exception ex) { } } //删除文件夹 //Directory.Delete(path); } } catch (Exception ex) { } } private void txtFileID_KeyPress(object sender, System.Windows.Forms.KeyPressEventArgs e) { if (e.KeyChar == 13) { if (string.IsNullOrEmpty(this.txtLOTNO.Text.Trim()) && string.IsNullOrEmpty(this.txtFileID.Text.Trim())) { ICSBaseSimpleCode.AppshowMessageBox("请输入条件！"); return; } if (!string.IsNullOrEmpty(this.txtLOTNO.Text.Trim())) { MOByMoCode(this.txtLOTNO.Text.Trim()); } else { SearchItem(this.txtFileID.Text.Trim()); } } } private void fileRead_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e) { try { DevExpress.XtraGrid.Views.Grid.GridView view = ((DevExpress.XtraGrid.Views.Grid.GridView)(grdDetail.MainView)); int rowhandle = view.FocusedRowHandle; DataRow dr = view.GetDataRow(rowhandle); string connectionString = AppConfig.GetDataBaseConnectStringByKey("[DB.FTP]"); string[] ftps = connectionString.Split(';'); string ftpServerIP = ftps[0].Split('=')[1]; string ftpRemotePath = ftps[1].Split('=')[1]; string ftpUserID = ftps[2].Split('=')[1]; string ftpPassword = ftps[3].Split('=')[1]; string viewerApp = "C:\\Program Files (x86)\\CADSeePlus\\CADSee.exe"; //string ftpServerIP = System.Configuration.ConfigurationManager.AppSettings["FtpServerIP"]; //string ftpRemotePath = System.Configuration.ConfigurationManager.AppSettings["FtpRemotePath"]; //string ftpUserID = System.Configuration.ConfigurationManager.AppSettings["FtpUserID"]; //string ftpPassword = System.Configuration.ConfigurationManager.AppSettings["FtpPassword"]; //string viewerApp = System.Configuration.ConfigurationManager.AppSettings["ViewerApp"]; FtpWeb ftpWeb = new FtpWeb(ftpServerIP, ftpRemotePath, ftpUserID, ftpPassword); string filePath = System.IO.Path.GetTempPath() + "\\tempfiles"; if (!Directory.Exists(filePath)) { Directory.CreateDirectory(filePath); } //文件名称有 ID + “$” + 版本 + 文件格式组成 string fileName = dr["FileID"].ToString() + "$" + dr["FileVer"].ToString() + "." + dr["FileFormat"].ToString(); fileName = fileName.Replace("/", ""); ftpWeb.Download(filePath + "\\", fileName); string filePathName = filePath + "\\" + fileName; if (dr["FileFormat"].ToString().Equals("pdf")) { FileDrawing.LoadPDF(filePathName); } else if(dr["FileFormat"].ToString().Equals("dwg")) { //MyProcess myPro = new MyProcess(); //myPro.OpenWithStartInfo(filePathName, viewerApp); } else if (dr["FileFormat"].ToString().Equals("mp4")) { FormICSMedia draw = new FormICSMedia(filePathName); draw.ShowDialog(); } //else if (dr["FileFormat"].ToString().Equals("CNC")) //{ // string downPath = "C:\\mesjk"; // string downName = downPath + "\\NC.txt"; // if (!Directory.Exists(downPath)) // { // Directory.CreateDirectory(downPath); // } // if (!File.Exists(downName)) // { // File.Create(downName); // } // //StreamReader reader = new StreamReader(filePathName, Encoding.Default); // //string text = reader.ReadToEnd(); // //reader.Close(); // StreamWriter writer = new StreamWriter(downName); // string text = LotNo + "_" + OPCode + "_" + EQPCode; // writer.Write(text); // writer.Close(); //} } catch (Exception ex) { MessageBox.Show(ex.Message); } } private void rdoLOTNO_CheckedChanged(object sender, EventArgs e) { if (rdoLOTNO.Checked) { txtFileID.Text = ""; txtFileID.Enabled = false; txtLOTNO.Enabled = true; txtLOTNO.Focus(); } } private void rdoFileID_CheckedChanged(object sender, EventArgs e) { if (rdoFileID.Checked) { txtLOTNO.Text = ""; txtLOTNO.Enabled = false; txtFileID.Enabled = true; txtFileID.Focus(); } } } }