RuiTengJb/ICSSoft.AppSln/ICSSoft.Frame.APP/DataCollect/FormICSHeatTreatment.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.Linq;
using System.Linq;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using DevExpress.XtraEditors;
using DevExpress.XtraGrid.Views.BandedGrid;
using DevExpress.XtraGrid.Columns;
using DevExpress.XtraGrid;
using System.IO;
using System.Threading;
using ICSSoft.Base.Language.Tool;
using ICSSoft.Base.Config.AppConfig;
using ICSSoft.Base.UserControl.MessageControl;
using ICSSoft.Base.Config.DBHelper;
using ICSSoft.Base.Report.Filter;
using ICSSoft.Base.UserControl.FormControl;
using ICSSoft.Base.Report.GridReport;
using ICSSoft.Base.ReferForm.AppReferForm;
using ICSSoft.Frame.Data.BLL;
using ICSSoft.Frame.Data.Entity;
using ICSSoft.Frame.Data.DAL;
using ICSSoft.Base.Log;

namespace ICSSoft.Frame.APP
{
    public partial class FormICSHeatTreatment : DevExpress.XtraEditors.XtraForm
    {
        private string sqltxt = "";
        private string sqlconn = "";
        string path = "";
        List<string> barList = new List<string>();
        string errorBar = "";
        String guid = AppConfig.GetGuid();
        private DataTable dataSource = null;
        private DataTable dataSource1 = null;
        private DataTable BodySource = null;
        DataSet ds = new DataSet();
        DataTable HandDt;
        DataTable BodyDt;
        public bool isNew = false;
        public string LotNO = "";
        public string MOVER = "";

        #region 构造函数
        public FormICSHeatTreatment()
        {
            InitializeComponent();
            this.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
            this.WindowState = FormWindowState.Maximized;
            isNew = true;
        }

        public FormICSHeatTreatment(string _LotNO, string _VenderLotNO)
        {
            InitializeComponent();
            this.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
            this.WindowState = FormWindowState.Maximized;
            isNew = false;
            LotNO = _LotNO;
            MOVER = _VenderLotNO;
        }
        #endregion

        #region 操作权限
        /// <summary>
        /// 操作权限
        /// </summary>
        /// <returns></returns>
        public DataTable RightOfExute()
        {
            DataTable rData = new DataTable();
            rData.Columns.Add("BtnName");
            rData.Columns.Add("ActionName");
            //查看权限（必须有）
            DataRow seeRow = rData.NewRow();
            seeRow["BtnName"] = "see";
            seeRow["ActionName"] = "查看";
            rData.Rows.Add(seeRow);

            List<Control> ControlList = new List<Control>();
            ControlList.Add(btnStove);
            ControlList.Add(btnOutPut);
            ControlList.Add(simpleButton1);
            ControlList.Add(btnStove);
            ControlList.Add(btnSample);
            ControlList.Add(btnModify);
            foreach (Control ctr in ControlList)
            {
                if (ctr.GetType() == typeof(SimpleButton))
                {
                    DataRow dr = rData.NewRow();
                    dr["BtnName"] = ctr.Name;
                    dr["ActionName"] = ctr.Text;
                    rData.Rows.Add(dr);
                }
            }
            rData.AcceptChanges();
            return rData;
        }
        /// <summary>
        /// 数据权限
        /// </summary>
        /// <returns></returns>
        public DataTable RightOfData()
        {
            DataTable rData = new DataTable();
            rData.Columns.Add("BodyName");
            rData.Columns.Add("ControlName");
            rData.Columns.Add("ControlCaption");

            rData.AcceptChanges();
            return rData;
        }
        #endregion

        #region 退出
        private void btnClose_Click(object sender, EventArgs e)
        {
            AppConfig.CloseFormShow(this.Text);
            this.Close();
        }

        private void btnExit_Click(object sender, EventArgs e)
        {
            AppConfig.CloseFormShow(this.Text);
            this.Close();
        }

        #endregion

        #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

        #region dataSet绑定
        private DataSet dataSetTool(DataTable hand, DataTable body)
        {
            DataColumn[] relations_dt, relations_ds;
            hand.TableName = "Hand";
            body.TableName = "Body";
            HandDt = hand.Copy();
            BodyDt = body.Copy();
            ds.Tables.Add(HandDt);
            ds.Tables.Add(BodyDt);
            relations_dt = new DataColumn[] { ds.Tables["Hand"].Columns["TransNo"] };
            relations_ds = new DataColumn[] { ds.Tables["Body"].Columns["TransNO"] };
            ds.Relations.Add("详情", relations_dt, relations_ds, false);
            return ds;
        }
        #endregion

        #region 过滤
        private string tempTableName = "";
        private void btnFilter_Click(object sender, EventArgs e)
        {
            if (isNew)
            {
                FormFilter filter = new FormFilter(AppConfig.GetSourceId(this.Tag.ToString(), btnConfig.Name));
                filter.OldTempTableName = tempTableName;
                if (filter.ShowDialog() == DialogResult.OK)
                {
                    DevExpress.Utils.WaitDialogForm _wait = new DevExpress.Utils.WaitDialogForm("正在查找...请稍等...");
                    try
                    {
                        BodyDt = null;
                        BodySource = null;
                        ds.Reset();
                        _wait.Show();
                        tempTableName = filter.NewTempTableName;
                        sqltxt = filter.SqlText;
                        sqlconn = filter.FilterConnectString;
                        dataSource = filter.FilterData.Tables[0];
                        dataSource1 = filter.FilterData.Tables[1];
                        ds = dataSetTool(dataSource, dataSource1);
                        grdDetail.DataSource = ds.Tables["Hand"];
                        grvDetail.BestFitColumns();
                        rptPage.RecordNum = dataSource.Rows.Count;
                        rptPage.PageIndex = 1;
                        rptPage.ReLoad();
                        _wait.Close();
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show("异常:" + ex.Message, "异常", MessageBoxButtons.OK, MessageBoxIcon.Error);
                        _wait.Close();
                    }
                }
            }
            else
            {
                try
                {
                    BodyDt = null;
                    BodySource = null;
                    ds.Reset();
                    sqltxt = @"
SELECT '' AS isSelect, A.ID AS ID, A.TransNO AS TransNo, A.MOCODE AS MOCODE, B.MOVER AS MOVER, A.LOTNOs AS LOTNO,
A.EQPCode AS EQPCode, C.EQPName AS EQPName, A.MUSERName AS MuserName, A.MTIME AS Mtime FROM ICSOpFile A
LEFT JOIN ICSMO B ON A.MOCODE = B.MOCODE AND A.MOSEQ = B.MOSEQ LEFT JOIN ICSEquipment C ON A.EQPCode = C.EQPCode
WHERE ISNULL(A.EATTRIBUTE2, '') LIKE '{0}' ORDER BY A.TransNO

SELECT DISTINCT B.ID AS ID, A.TransNO AS TransNO, A.EnumText AS FileType, B.FileName, B.FileType, B.MUSERName AS MuserName,
B.MTIME AS Mtime FROM (SELECT A.TransNO AS TransNO, B.EnumText, A.ID AS ID FROM ICSOpFile A,
(SELECT DISTINCT EnumText FROM Sys_EnumValues  WHERE  EnumKey = '00007') B) A
LEFT JOIN ICSOpFileDetail B ON A.TransNO = B.TransNO AND A.EnumText = B.FileType";
                    if (MOVER == null || MOVER == "")
                    {
                        MOVER = "";
                    }
                    else
                    {
                        MOVER = "%" + MOVER + "%";
                    }
                    sqltxt = string.Format(sqltxt, MOVER);
                    dataSource = DBHelper.ExecuteDataset(AppConfig.AppConnectString, CommandType.Text, sqltxt).Tables[0];
                    dataSource1 = DBHelper.ExecuteDataset(AppConfig.AppConnectString, CommandType.Text, sqltxt).Tables[1];
                    ds = dataSetTool(dataSource, dataSource1);
                    grdDetail.DataSource = ds.Tables["Hand"];
                    grvDetail.BestFitColumns();
                    rptPage.RecordNum = dataSource.Rows.Count;
                    rptPage.PageIndex = 1;
                    rptPage.ReLoad();

                    this.btnConfig.Enabled = false;
                    this.btnFilter.Enabled = false;
                    this.btnStove.Enabled = false;
                    this.btnSample.Enabled = false;
                    this.btnOutPut.Enabled = false;
                }
                catch (Exception ex)
                {
                    MessageBox.Show("异常:" + ex.Message, "异常", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
        }
        #endregion     

        #region 绑定数据源
        private void btnConfig_Click(object sender, EventArgs e)
        {
            if (AppConfig.UserCode.ToLower() != "demo")
            {
                ICSBaseSimpleCode.AppshowMessageBox("您没有权限设置数据源，请联系软件提供商！");
                return;
            }
            FormDataSource fdata = new FormDataSource(AppConfig.GetMenuId(this.Tag.ToString()), btnConfig.Name);
            fdata.ShowDialog();
        }
        #endregion

        #region 分页
        private void rptPage_PageIndexChanged(object Sender, EventArgs e)
        {
            DataTable data = AppConfig.GetPageData(dataSource, rptPage.PageIndex, rptPage.PageSize).Copy();
            ds = dataSetTool(data, dataSource1);
            grdDetail.DataSource = ds.Tables["Hand"];
            //DataTable data = AppConfig.GetPageDataByDb(tempTableName, "pagerowindex", rptPage.PageSize, rptPage.PageIndex, dataSource.Rows.Count);
            //grdDetail.DataSource = data;
        }
        #endregion

        #region 过滤方法
        private void FormContainerManager_FormClosing(object sender, FormClosingEventArgs e)
        {
            AppConfig.DropTemTable(tempTableName);
        }
        #endregion

        #region 全选
        private void btnSelectAll_Click(object sender, EventArgs e)
        {
            grvDetail.PostEditor();
            this.Validate();
            for (int i = 0; i < grvDetail.RowCount; i++)
            {
                grvDetail.SetRowCellValue(i, colSelect, "Y");
            }
        }
        #endregion

        #region 全消
        private void btnCancelAll_Click(object sender, EventArgs e)
        {
            grvDetail.PostEditor();
            this.Validate();
            for (int i = 0; i < grvDetail.RowCount; i++)
            {
                grvDetail.SetRowCellValue(i, colSelect, "");
            }
        }
        #endregion

        #region 双击
        private void grvDetail_DoubleClick(object sender, EventArgs e)
        {
            if (grvDetail.FocusedRowHandle < 0)
            {
                return;
            }
            if (grvDetail.FocusedColumn == colSelect)
            {
                if (grvDetail.GetRowCellValue(grvDetail.FocusedRowHandle, colSelect).ToString() == "")
                {
                    grvDetail.SetRowCellValue(grvDetail.FocusedRowHandle, colSelect, "Y");
                }
                else
                {
                    grvDetail.SetRowCellValue(grvDetail.FocusedRowHandle, colSelect, "");
                }

            }
        }
        #endregion       

        #region 导出
        private void btnOutPut_Click(object sender, EventArgs e)
        {
            SimpleButton btntemp = (SimpleButton)sender;
            if (AppConfig.GetUserExcuteRight(this.Tag.ToString(), btntemp.Name) == false)
            {
                ICSBaseSimpleCode.AppshowMessageBox("对不起您没有:" + btntemp.Text + "权限,请联系系统管理员！");
                return;
            }
            FormOutExcel foe = new FormOutExcel(this.Tag.ToString(), grdDetail);
            foe.ShowDialog();
        }
        #endregion

        #region 刷新
        private void btnRefresh_Click(object sender, EventArgs e)
        {
            if (isNew)
            {
                DevExpress.Utils.WaitDialogForm _wait = new DevExpress.Utils.WaitDialogForm("正在查找...请稍等...");
                try
                {
                    BodyDt = null;
                    BodySource = null;
                    ds.Reset();
                    _wait.Show();
                    FormFilter filter = new FormFilter(AppConfig.GetSourceId(this.Tag.ToString(), btnConfig.Name), false);
                    filter.OldTempTableName = tempTableName; ;
                    //tempTableName = filter.NewTempTableName;
                    //DataTable data = DBHelper.ExecuteDataset(AppConfig.FrameConnectString, CommandType.Text, "select  *  from  " + tempTableName).Tables[0];
                    //dataSource = DBHelper.ExecuteDataset(sqlconn, CommandType.Text, sqltxt).Tables[0];
                    DataSet dataset = DBHelper.ExecuteDataset(sqlconn, CommandType.Text, sqltxt);
                    dataSource = dataset.Tables[0];
                    dataSource1 = dataset.Tables[1];
                    ds = dataSetTool(dataSource, dataSource1);
                    grdDetail.DataSource = ds.Tables["Hand"];
                    grvDetail.BestFitColumns();
                    rptPage.RecordNum = dataSource.Rows.Count;
                    rptPage.PageIndex = 1;
                    rptPage.ReLoad();
                    _wait.Close();
                }
                catch (Exception ex)
                {
                    MessageBox.Show("异常:" + ex.Message, "异常", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    _wait.Close();
                }
            }
            else
            {
                try
                {
                    BodyDt = null;
                    BodySource = null;
                    ds.Reset();
                    sqltxt = @"
SELECT '' AS isSelect, A.ID AS ID, A.TransNO AS TransNo, A.MOCODE AS MOCODE, B.MOVER AS MOVER, A.LOTNOs AS LOTNO,
A.EQPCode AS EQPCode, C.EQPName AS EQPName, A.MUSERName AS MuserName, A.MTIME AS Mtime FROM ICSOpFile A
LEFT JOIN ICSMO B ON A.MOCODE = B.MOCODE AND A.MOSEQ = B.MOSEQ LEFT JOIN ICSEquipment C ON A.EQPCode = C.EQPCode
WHERE ISNULL(A.EATTRIBUTE2, '') = '{0}' ORDER BY A.TransNO

SELECT DISTINCT B.ID AS ID, A.TransNO AS TransNO, A.EnumText AS FileType, B.FileName, B.FileType, B.MUSERName AS MuserName,
B.MTIME AS Mtime FROM (SELECT A.TransNO AS TransNO, B.EnumText, A.ID AS ID FROM ICSOpFile A,
(SELECT DISTINCT EnumText FROM Sys_EnumValues  WHERE  EnumKey = '00007') B) A
LEFT JOIN ICSOpFileDetail B ON A.TransNO = B.TransNO AND A.EnumText = B.FileType";
                    sqltxt = string.Format(sqltxt, MOVER);
                    dataSource = DBHelper.ExecuteDataset(AppConfig.AppConnectString, CommandType.Text, sqltxt).Tables[0];
                    dataSource1 = DBHelper.ExecuteDataset(AppConfig.AppConnectString, CommandType.Text, sqltxt).Tables[1];
                    ds = dataSetTool(dataSource, dataSource1);
                    grdDetail.DataSource = ds.Tables["Hand"];
                    grvDetail.BestFitColumns();
                    rptPage.RecordNum = dataSource.Rows.Count;
                    rptPage.PageIndex = 1;
                    rptPage.ReLoad();

                    this.btnConfig.Enabled = false;
                    this.btnFilter.Enabled = false;
                    this.btnStove.Enabled = false;
                    this.btnSample.Enabled = false;
                    this.btnOutPut.Enabled = false;
                }
                catch (Exception ex)
                {
                    MessageBox.Show("异常:" + ex.Message, "异常", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
        }

        #endregion

        #region 删除
        private void btnDelete_Click(object sender, EventArgs e)
        {
            grvDetail.PostEditor();
            this.Validate();
            if (grvDetail.RowCount == 0)
                return;
            SimpleButton btntemp = (SimpleButton)sender;
            if (AppConfig.GetUserExcuteRight(this.Tag.ToString(), btntemp.Name) == false)
            {
                ICSBaseSimpleCode.AppshowMessageBox("对不起您没有:" + btntemp.Text + "权限,请联系系统管理员！");
            }

            List<string> guidList = new List<string>();
            List<string> codeList = new List<string>();
            for (int i = 0; i < grvDetail.RowCount; i++)
            {
                if (grvDetail.GetRowCellValue(i, colSelect).ToString() == "Y")
                {
                    guidList.Add(grvDetail.GetRowCellValue(i, ID).ToString());
                    //codeList.Add(grvDetail.GetRowCellValue(i, MODELCODE).ToString());
                }

            }
            if (guidList.Count == 0)
            {
                ICSBaseSimpleCode.AppshowMessageBox("请选择数据！");
                return;
            }
            if (ICSBaseSimpleCode.AppshowMessageBoxRepose("确定删除该数据吗？数据删除后无法恢复!!") != DialogResult.OK)
                return;
            try
            {
                ICSMODELBLL.delete(guidList, codeList);
                ICSBaseSimpleCode.AppshowMessageBox(0, "删除成功");
                btnRefresh_Click(null, null);
            }
            catch (Exception ex)
            {
                ICSBaseSimpleCode.AppshowMessageBox(ex.Message);
            }
        }
        #endregion

        #region 上传下载PDF
        //上传事件
        private void repositoryItemButtonEdit1_Click(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
        {
            OpenFileDialog openFileDialog1 = new OpenFileDialog();  //显示选择文件对话框  
            openFileDialog1.InitialDirectory = "c:\\";
            openFileDialog1.Filter = "pdf files (*.pdf)|*.pdf"; //所有的文件格式
            //openFileDialog1.Filter = "pdf files (*.pdf)|*.pdf|All files (*.*)|*.*"; //所有的文件格式  
            openFileDialog1.FilterIndex = 2;
            openFileDialog1.RestoreDirectory = true;
            string Pid = grvDetail.GetFocusedRowCellValue(colID).ToString();
            string transno = grvDetail.GetFocusedRowCellValue(colTransNo).ToString();
            string filetype = gridView1.GetFocusedRowCellValue(colFileType).ToString();
            string filePath = "";
            if (openFileDialog1.ShowDialog() == DialogResult.OK)
            {
                filePath = openFileDialog1.FileName;   //显示文件路径
            }
            else
                return;
            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];
            FtpWeb ftpWeb = new FtpWeb(ftpServerIP, ftpRemotePath, ftpUserID, ftpPassword);
            try
            {
                try
                {
                    Log.WriteLogForVisit(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType + "." + System.Reflection.MethodBase.GetCurrentMethod().Name,
                        filePath, "");
                    int cout = filePath.Split('\\').Length;

                    string fname = filePath.Split('\\')[cout - 1];
                    Log.WriteLogForVisit(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType + "." + System.Reflection.MethodBase.GetCurrentMethod().Name,
                        fname, "");

                    fname = fname.Split('.')[0];
                    Log.WriteLogForVisit(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType + "." + System.Reflection.MethodBase.GetCurrentMethod().Name,
                        fname, "");

                    ftpWeb.Upload(filePath, fname, fname);
                    Log.WriteLogForVisit(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType + "." + System.Reflection.MethodBase.GetCurrentMethod().Name,
                        Pid, "");

                    Log.WriteLogForVisit(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType + "." + System.Reflection.MethodBase.GetCurrentMethod().Name,
                        AppConfig.AppConnectString, "");
                    ICSHeatTreatmentBLL.AddPDF(Pid, transno, filetype,fname, AppConfig.AppConnectString);

                }
                catch (Exception ex)
                {
                    throw new Exception(ex.Message + "   上传出错！");
                    Log.WriteLogForException(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType + "." + System.Reflection.MethodBase.GetCurrentMethod().Name, "", ex.ToString());
                }
                string filename = "";
                string ftpURL = "ftp://" + ftpServerIP + "/" + ftpRemotePath + "/";
                string[] list = filePath.Split('\\');
                filename = list[list.Length - 1];
                ICSBaseSimpleCode.AppshowMessageBox("上传成功 !");
                btnRefresh_Click(null, null);
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }

        //下载事件
        private void repositoryItemButtonEdit2_Click(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
        {
            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];

            FtpWeb ftpWeb = new FtpWeb(ftpServerIP, ftpRemotePath, ftpUserID, ftpPassword);

            try
            {
                ICSOpFileDetail model = ICSHeatTreatmentBLL.GetModel1(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, ID).ToString(), AppConfig.AppConnectString);
                if (model==null||string.IsNullOrEmpty(model.FileName))
                {
                    ICSBaseSimpleCode.AppshowMessageBox("暂无文档！");
                    return;
                }
                string path = System.Windows.Forms.Application.StartupPath + @"\PDF";
                DirectoryInfo directoryInfo = new DirectoryInfo(path);
                if (!Directory.Exists(path))
                {
                    Directory.CreateDirectory(path);
                }

                string filePaths = path + @"\" + model.FileName + ".pdf";
                ftpWeb.Download(path, model.FileName + ".pdf", model.FileName);
                FileDrawing.LoadPDF(filePaths);
                ////string filePaths = @"C:\Users\Administrator.UX7663JVU2X64C5\Desktop\123.pdf";
                //AxAcroPDFLib.AxAcroPDF axAcroPDF = new AxAcroPDFLib.AxAcroPDF();
                //((System.ComponentModel.ISupportInitialize)(axAcroPDF)).BeginInit();
                //axAcroPDF.Dock = DockStyle.Fill;
                //this.Controls.Add(axAcroPDF);
                //axAcroPDF.Location = new System.Drawing.Point(0, 24);
                //((System.ComponentModel.ISupportInitialize)(axAcroPDF)).EndInit();
                //axAcroPDF.LoadFile(filePaths);
                //axAcroPDF.setShowToolbar(true);
                //axAcroPDF.setPageMode("thumbs");
                //axAcroPDF.setPageMode("none");
                //axAcroPDF.Show();
                ////System.Diagnostics.Process.Start(filePaths);

            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }

        /// 删除文件  
        private void repositoryItemButtonEdit5_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
        {
            if (MessageBox.Show("是否要删除文件", "删除文件", MessageBoxButtons.OKCancel, MessageBoxIcon.Asterisk, MessageBoxDefaultButton.Button1) == DialogResult.OK)
            {
                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];

                FtpWeb ftpWeb = new FtpWeb(ftpServerIP, ftpRemotePath, ftpUserID, ftpPassword);
                try
                {
                    ICSOpFileDetail model = ICSHeatTreatmentBLL.GetModel(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, ID).ToString(), AppConfig.AppConnectString);
                    if (model == null || string.IsNullOrEmpty(model.FileName))
                    {
                        ICSBaseSimpleCode.AppshowMessageBox("暂无文档！");
                        return;
                    }
                    ftpWeb.Delete(model.FileName, model.FileName + ".pdf");
                    ftpWeb.RemoveDirectory(model.FileName);
                    //ftpWeb.RemoveDirectory(model.FileName);
                    ICSHeatTreatmentBLL.DeletePDF(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, ID).ToString(), AppConfig.AppConnectString);
                    //string path = System.Windows.Forms.Application.StartupPath + @"\PDF";
                    //DirectoryInfo directoryInfo = new DirectoryInfo(path);
                    //if (!Directory.Exists(path))
                    //{
                    //    Directory.CreateDirectory(path);
                    //}

                    //string filePaths = path + @"\" + model.FileName + ".pdf";

                    ICSBaseSimpleCode.AppshowMessageBox("删除成功 !");
                    btnRefresh_Click(null, null);
                    //FileDrawing.LoadPDF(filePaths);
                }
                catch (Exception ex)
                {
                    throw new Exception(ex.Message);
                }
            }
        }
        #endregion

        private void FormICSItemLot_FormClosing(object sender, FormClosingEventArgs e)
        {
            AppConfig.DropTemTable(tempTableName);
        }

        private void FormICSItemLot_Load(object sender, EventArgs e)
        {
            btnFilter_Click(sender, e);
        }

        private void grvDetail_MasterRowExpanded(object sender, DevExpress.XtraGrid.Views.Grid.CustomMasterRowEventArgs e)
        {
            gridView1 = grvDetail.GetDetailView(e.RowHandle, e.RelationIndex) as DevExpress.XtraGrid.Views.Grid.GridView;
            gridView1.BestFitColumns();
        }

        private void gridView1_MasterRowExpanded(object sender, DevExpress.XtraGrid.Views.Grid.CustomMasterRowEventArgs e)
        {
            DevExpress.XtraGrid.Views.Grid.GridView aView = grvDetail.GetDetailView(e.RowHandle, e.RelationIndex) as DevExpress.XtraGrid.Views.Grid.GridView;
        }

        #region 新增炉号
        private void btnStove_Click(object sender, EventArgs e)
        {
            SimpleButton btntemp = (SimpleButton)sender;
            if (AppConfig.GetUserExcuteRight(this.Tag.ToString(), btntemp.Name) == false)
            {
                ICSBaseSimpleCode.AppshowMessageBox("对不起您没有:" + btntemp.Text + "权限,请联系系统管理员！");
                return;
            }
            FormICSHeatTreatmentAddNew add = new FormICSHeatTreatmentAddNew();
            add.ShowDialog();
            btnRefresh_Click(null, null);
        }
        #endregion

        #region 新增试样号
        private void btnSample_Click(object sender, EventArgs e)
        {
            String id = "";
            string transno = "";
            string eqpcode = "";//设备号
            string opcode = "";
            SimpleButton btntemp = (SimpleButton)sender;
            if (AppConfig.GetUserExcuteRight(this.Tag.ToString(), btntemp.Name) == false)
            {
                ICSBaseSimpleCode.AppshowMessageBox("对不起您没有:" + btntemp.Text + "权限,请联系系统管理员！");
                return;
            }
            List<string> editList = new List<string>();
            for (int i = 0; i < grvDetail.RowCount; i++)
            {
                if (grvDetail.GetRowCellValue(i, colSelect).ToString() == "Y")
                {
                    id = grvDetail.GetRowCellValue(i, colID).ToString();
                    transno = grvDetail.GetRowCellValue(i, colTransNo).ToString();
                    eqpcode = grvDetail.GetRowCellValue(i, colEQPCode).ToString();
                    opcode = grvDetail.GetRowCellValue(i, colOpCode).ToString();
                    editList.Add(id);
                }
            }
            if (editList.Count != 1)
            {
                ICSBaseSimpleCode.AppshowMessageBox("请选择单据号,且只能选择新增一条数据!!!");
                return;
            }
            try
            {
                FormICSHeatTreatmentAddNew add = new FormICSHeatTreatmentAddNew(id, transno, eqpcode,opcode);
                add.ShowDialog();
                btnRefresh_Click(null,null);
            }
            catch (Exception ex)
            {
                ICSBaseSimpleCode.AppshowMessageBox(ex.Message);
            }
        }
        #endregion

        #region 删除
        private void btnDel_Click(object sender, EventArgs e)
        {

                List<string> guidList = new List<string>();
                for (int i = 0; i < grvDetail.RowCount; i++)
                {
                    if (grvDetail.GetRowCellValue(i, colSelect).ToString() == "Y")
                    {
                        //guidList.Add(grvDetail.GetRowCellValue(i, colID).ToString());
                        guidList.Add(grvDetail.GetRowCellValue(i, colTransNo).ToString());
                    }
                }
                if (guidList.Count == 0 || guidList == null)
                {
                    ICSBaseSimpleCode.AppshowMessageBox("请选择数据");
                    return;
                }
                if (ICSBaseSimpleCode.AppshowMessageBoxRepose("确定删除该单据号吗？删除后无法恢复") != DialogResult.OK)
                {
                    for (int i = 0; i < grvDetail.RowCount; i++)
                    {
                        grvDetail.SetRowCellValue(i, colSelect, "");
                    }
                    return;
                }
            try
            {
                ICSHeatTreatmentBLL.delete(guidList, AppConfig.AppConnectString);
                ICSBaseSimpleCode.AppshowMessageBox("删除成功");
                btnRefresh_Click(null, null);
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }
        #endregion

        private void simpleButton1_Click(object sender, EventArgs e)
        {
            SimpleButton btntemp = (SimpleButton)sender;
            if (AppConfig.GetUserExcuteRight(this.Tag.ToString(), btntemp.Name) == false)
            {
                ICSBaseSimpleCode.AppshowMessageBox("对不起您没有:" + btntemp.Text + "权限,请联系系统管理员！");
                return;
            }
            if (ICSBaseSimpleCode.AppshowMessageBoxRepose("确定清除该文件吗？清除后无法恢复") != DialogResult.OK)
            {
                for (int i = 0; i < grvDetail.RowCount; i++)
                {
                    grvDetail.SetRowCellValue(i, colSelect, "");
                }
                return;
            }
            int count = 0;
            for (int i = 0; i < grvDetail.RowCount; i++)
            {
                if (grvDetail.GetRowCellValue(i, colSelect).ToString() == "Y")
                {
                    count++;
                }
            }
            if (count == 0)
            {
                ICSBaseSimpleCode.AppshowMessageBox("请选择数据！");
                return;
            }
            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];

            FtpWeb ftpWeb = new FtpWeb(ftpServerIP, ftpRemotePath, ftpUserID, ftpPassword);
            try
            {
                for (int i = 0; i < grvDetail.RowCount; i++)
                {
                    if (grvDetail.GetRowCellValue(i, colSelect).ToString() == "Y")
                    {
                        DataTable dt = ICSHeatTreatmentBLL.GetModeldt(grvDetail.GetRowCellValue(i, colTransNo).ToString(), AppConfig.AppConnectString);
                        if (dt.Rows.Count == 0)
                        {
                            ICSBaseSimpleCode.AppshowMessageBox("暂无文档！");
                            return;
                        }
                        foreach (DataRow dr in dt.Rows)
                        {
                            if (dr["FileName"].ToString() != "")
                            {
                                ftpWeb.Delete(dr["FileName"].ToString(), dr["FileName"].ToString() + ".pdf");
                                ftpWeb.RemoveDirectory(dr["FileName"].ToString());
                                ICSHeatTreatmentBLL.DeletePDFAll(grvDetail.GetRowCellValue(i, colTransNo).ToString(), AppConfig.AppConnectString);
                            }
                        }
                    }
                }
                ICSBaseSimpleCode.AppshowMessageBox("清除成功 !");
                btnRefresh_Click(null, null);
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }

        #region 修改
        private void btnModify_Click(object sender, EventArgs e)
        {
            SimpleButton btntemp = (SimpleButton)sender;
            if (AppConfig.GetUserExcuteRight(this.Tag.ToString(), btntemp.Name) == false)
            {
                ICSBaseSimpleCode.AppshowMessageBox("对不起您没有:" + btntemp.Text + "权限,请联系系统管理员！");
                return;
            }
            int count = 0;
            for (int i = 0; i < grvDetail.RowCount; i++)
            {
                if (grvDetail.GetRowCellValue(i, colSelect).ToString()=="Y")
                {
                    count++;
                }
            }
            if (count != 1)
            {
                ICSBaseSimpleCode.AppshowMessageBox("请选择数据,且只能选择一条进行编辑!!!");
                return;
            }
            try
            {
                string Type = "";
                string transno = grvDetail.GetRowCellValue(grvDetail.FocusedRowHandle,colTransNo).ToString();
                string id = grvDetail.GetRowCellValue(grvDetail.FocusedRowHandle, colID).ToString();
                string eqpcode = grvDetail.GetRowCellValue(grvDetail.FocusedRowHandle, colEQPCode).ToString();
                string opcode = grvDetail.GetRowCellValue(grvDetail.FocusedRowHandle, colOpCode).ToString();
                if (opcode == "")
                {
                    ICSBaseSimpleCode.AppshowMessageBox("工序不能为空,不能修改,请联系系统管理员!!!");
                    return;
                }
                //判断类型
                string sql = "SELECT EATTRIBUTE1 from ICSOpFile WHERE ID='{0}'";
                sql = string.Format(sql,id);
                DataTable dt = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sql).Tables[0];
                if (dt != null && dt.Rows.Count > 0)
                {
                    Type = dt.Rows[0]["EATTRIBUTE1"].ToString();
                }
                FormICSHeatTreatmentAddNew add = new FormICSHeatTreatmentAddNew(id,eqpcode,opcode,Type,transno);
                add.ShowDialog();
                btnRefresh_Click(null, null);
            }
            catch (Exception ex)
            {
                ICSBaseSimpleCode.AppshowMessageBox(ex.Message);
            }
        }
        #endregion
    }
}