MES_Client/TGMES/Core.StlMes.Client.Lims.Data.PipeAndOutdec/数据管理/外委实验管理/FrmOutdecLabEngDataParm.cs

using Core.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm.Format;
using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Tool;
using Core.StlMes.Client.Lims.Data.PipeAndOutdec.封装类.实体类;
using CoreFS.CA06;
using Infragistics.Win.UltraWinEditors;
using Infragistics.Win.UltraWinGrid;
using System;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace Core.StlMes.Client.Lims.Data.PipeAndOutdec.数据管理.外委实验管理
{
    //商检力学试验条件
    public partial class FrmOutdecLabEngDataParm : FrmBase
    {
        private string CHECK_NO = "";
        private string SAMPLE_NO = "";
        private string PHY_CODE_MAX = "";
        private OpeBase _ob;

        public FrmOutdecLabEngDataParm(string checkNo, string sampleNo, string phyCodeMax, OpeBase ob)
        {
            InitializeComponent();
            CHECK_NO = checkNo;
            SAMPLE_NO = sampleNo;
            PHY_CODE_MAX = phyCodeMax;
            _ob = ob;

            //ultraGrid1.ClickCellButton += new CellEventHandler(ultraGrid1_ClickCellButton);  //添加缺陷项
            //ultraGrid2.ClickCellButton += new CellEventHandler(ultraGrid2_ClickCellButton);  //添加缺陷项
            Query();
        }

        private void FrmOutdecLabMecDataParm_Load(object sender, EventArgs e)
        {
            if (PHY_CODE_MAX == "C0036" || PHY_CODE_MAX == "C0037" || PHY_CODE_MAX == "C0066") //联合力、密封性能（含静水压）试验报告
            {
                ultraTabControl1.Tabs[1].Visible = false;
                ultraTabControl1.Tabs[2].Visible = false;
            }
            else if (PHY_CODE_MAX == "C0018" || PHY_CODE_MAX == "C0020" || PHY_CODE_MAX == "C0035" || PHY_CODE_MAX == "C0065")// 压溃、爆破、拉力试验报告
            {
                ultraTabControl1.Tabs[0].Visible = false;
                ultraTabControl1.Tabs[2].Visible = false;
            }
            else if (PHY_CODE_MAX == "C0064")// 上卸扣试验报告
            {
                ultraTabControl1.Tabs[0].Visible = false;
                ultraTabControl1.Tabs[1].Visible = false;
            }
           
        }


        /// <summary>
        /// 查询
        /// </summary>
        private void Query()
        {
            ArrayList list = new ArrayList();
            list.Add(CHECK_NO);
            list.Add(SAMPLE_NO);
            list.Add(PHY_CODE_MAX);

            DataTable dt = PublicServer.GetData("com.steering.lims.data.outdec.FrmOutdecLabDateParm.QueryOutdecCheckconsignDetail", new Object[] { list }, _ob);

            if (dt.Rows.Count > 0)
            {
                DataRow ur = dt.Rows[0];
                ShowBaseInfo(ur);
            }


            DataTable dtParm = PublicServer.GetData("com.steering.lims.data.outdec.FrmOutdecLabDateParm.QueryOutdecCheckconsignDetailParm", new Object[] { list }, _ob);
            GridHelper.CopyDataToDatatable(ref dtParm, ref this.dataTable1, true);
            GridHelper.CopyDataToDatatable(ref dtParm, ref this.dataTable2, true);
            //if (PHY_CODE_MAX.Equals("C0064"))
            //{
            //    GridHelper.CopyDataToDatatable(ref dtParm, ref this.dataTable2, true);
            //}
            //else
            //{
            //    GridHelper.CopyDataToDatatable(ref dtParm, ref this.dataTable1, true);
            //}
            
        }




        /// <summary>
        /// 点击Grid编辑区显示基本信息
        /// </summary>
        /// <param name="ur"></param>
        public void ShowBaseInfo(DataRow ur)
        {
            if (ur != null)
            {
                if (PHY_CODE_MAX == "C0036" || PHY_CODE_MAX == "C0037" || PHY_CODE_MAX == "C0066") //联合力、密封性能（含静水压）试验报告
                {
                    foreach (DataColumn uc in ur.Table.Columns)
                    {
                        if (ultraPanel1.ClientArea.Controls.ContainsKey("ultra" + uc.ColumnName) == true)//判定是否存在text
                        {
                            ((UltraTextEditor)ultraPanel1.ClientArea.Controls["ultra" + uc.ColumnName]).Text = ur[uc.ColumnName].ToString();
                        }
                    }
                }
                else if (PHY_CODE_MAX == "C0018" || PHY_CODE_MAX == "C0020" || PHY_CODE_MAX == "C0035" || PHY_CODE_MAX == "C0065")// 压溃、爆破、拉力试验报告
                {
                    foreach (DataColumn uc in ur.Table.Columns)
                    {
                        if (ultraPanel2.ClientArea.Controls.ContainsKey("ls" + uc.ColumnName) == true)//判定是否存在text
                        {
                            ((UltraTextEditor)ultraPanel2.ClientArea.Controls["ls" + uc.ColumnName]).Text = ur[uc.ColumnName].ToString();
                        }
                        //else if (ultraPanel2.ClientArea.Controls.ContainsKey("_txt" + uc.ColumnName) == true)
                        //{
                        //    ((UltraComboEditor)ultraPanel2.ClientArea.Controls["_txt" + uc.ColumnName]).Text = ur[uc.ColumnName].ToString();
                        //}
                    }
                }
                else if (PHY_CODE_MAX == "C0064")// 上卸扣试验报告
                {
                    foreach (DataColumn uc in ur.Table.Columns)
                    {
                        if (ultraPanel3.ClientArea.Controls.ContainsKey("kk" + uc.ColumnName) == true)//判定是否存在text
                        {
                            ((UltraTextEditor)ultraPanel3.ClientArea.Controls["kk" + uc.ColumnName]).Text = ur[uc.ColumnName].ToString();
                        }
                    }
                }
            }
        }

        /// <summary>
        /// 保存联合力、密封性能（含静水压）试验报告
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraButton1_Click(object sender, EventArgs e)
        {

            SaveCombinedStress();
            MessageUtil.ShowTips("保存成功！");

        }

        /// <summary>
        /// 保存联合力、密封性能（含静水压）试验报告
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void SaveCombinedStress()
        {
            OutdecCheckconsignLabResultEntity outdecDetail = new OutdecCheckconsignLabResultEntity();
            outdecDetail.TechnicalStandard = ultraTECHNICAL_STANDARD.Text; //试验标准
            outdecDetail.TestItem = ultraTEST_ITEM.Text; //试验项目
            outdecDetail.TestResults = ultraTEST_RESULTS.Text; //结果评定
            

            outdecDetail.CheckNo = CHECK_NO;
            outdecDetail.SampleNo = SAMPLE_NO;
            outdecDetail.PhyCodeMax = PHY_CODE_MAX;
            string outdecDetailStr = JSONFormat.Format(outdecDetail);

            ultraGrid1.UpdateData();
            ArrayList arrayList = new ArrayList();
            for (int i = 0; i < ultraGrid1.Rows.Count; i++)
            {
                OutdecCheckconsignDtlParmEntity ParmEntity = new OutdecCheckconsignDtlParmEntity();
                ParmEntity.CheckNo = CHECK_NO;
                ParmEntity.SampleNo = SAMPLE_NO;
                ParmEntity.PhyCodeMax = PHY_CODE_MAX;
                ParmEntity.Step = ultraGrid1.Rows[i].Cells["STEP"].Value.ToString();
                ParmEntity.Load = ultraGrid1.Rows[i].Cells["LOAD"].Value.ToString();
                ParmEntity.PressureMedium = ultraGrid1.Rows[i].Cells["PRESSURE_MEDIUM"].Value.ToString();
                ParmEntity.InternalPressure = ultraGrid1.Rows[i].Cells["INTERNAL_PRESSURE"].Value.ToString();
                ParmEntity.DoglegDegree = ultraGrid1.Rows[i].Cells["DOGLEG_DEGREE"].Value.ToString();
                ParmEntity.HoldTime = ultraGrid1.Rows[i].Cells["HOLD_TIME"].Value.ToString();
                ParmEntity.TestResult = ultraGrid1.Rows[i].Cells["TEST_RESULT"].Value.ToString();

                arrayList.Add(JSONFormat.Format(ParmEntity));
            }

            PublicServer.SetData("com.steering.lims.data.outdec.FrmOutdecLabDateParm.SaveCombinedStress",
                    new Object[] { outdecDetailStr, arrayList }, _ob);
        }

        /// <summary>
        /// 保存压溃、爆破、拉力试验报告
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraButton2_Click(object sender, EventArgs e)
        {
            SaveCheckconsignDetailParm();
            MessageUtil.ShowTips("保存成功！");
        }

        /// <summary>
        /// 保存压溃、爆破、拉力试验报告
        /// </summary>
        private void SaveCheckconsignDetailParm()
        {
            OutdecCheckconsignLabResultEntity outdecDetail = new OutdecCheckconsignLabResultEntity();
            outdecDetail.TechnicalStandard = lsTECHNICAL_STANDARD.Text;
            outdecDetail.Note = lsNOTE.Text;   //备注
            outdecDetail.TestResults = lsTEST_RESULTS.Text;   //结果评定
            outdecDetail.TestItem = lsTEST_ITEM.Text;   //结果评定

            outdecDetail.CheckNo = CHECK_NO;
            outdecDetail.SampleNo = SAMPLE_NO;
            outdecDetail.PhyCodeMax = PHY_CODE_MAX;

            string outdecDetailStr = JSONFormat.Format(outdecDetail);
            PublicServer.SetData("com.steering.lims.data.outdec.FrmOutdecLabDateParm.SaveCheckconsignDetailParm",
                    new Object[] { outdecDetailStr }, _ob);
        }

        /// <summary>
        /// 保存上卸扣试验条件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraButton3_Click(object sender, EventArgs e)
        {
            saveAntiGallingTest();
            MessageUtil.ShowTips("保存成功！");
        }

        /// <summary>
        /// 保存上卸扣试验条件
        /// </summary>
        private void saveAntiGallingTest()
        {
            OutdecCheckconsignLabResultEntity outdecDetail = new OutdecCheckconsignLabResultEntity();
            outdecDetail.TechnicalStandard = kkTECHNICAL_STANDARD.Text;
            outdecDetail.Connection = kkCONNECTION.Text;
            outdecDetail.TestResults = kkTEST_RESULTS.Text;

            outdecDetail.CheckNo = CHECK_NO;
            outdecDetail.SampleNo = SAMPLE_NO;
            outdecDetail.PhyCodeMax = PHY_CODE_MAX;

            string outdecDetailStr = JSONFormat.Format(outdecDetail);
            

            ultraGrid2.UpdateData();
            ArrayList arrayList = new ArrayList();
            for (int i = 0; i < ultraGrid2.Rows.Count; i++)
            {
                OutdecCheckconsignDtlParmEntity ParmEntity = new OutdecCheckconsignDtlParmEntity();
                ParmEntity.CheckNo = CHECK_NO;
                ParmEntity.SampleNo = SAMPLE_NO;
                ParmEntity.PhyCodeMax = PHY_CODE_MAX;
                ParmEntity.Step = ultraGrid2.Rows[i].Cells["STEP"].Value.ToString();
                ParmEntity.Pin = ultraGrid2.Rows[i].Cells["PIN"].Value.ToString();
                ParmEntity.Box = ultraGrid2.Rows[i].Cells["BOX"].Value.ToString();
                ParmEntity.CompoundType = ultraGrid2.Rows[i].Cells["COMPOUND_TYPE"].Value.ToString();
                ParmEntity.CompoundWeight = ultraGrid2.Rows[i].Cells["COMPOUND_WEIGHT"].Value.ToString();
                ParmEntity.MakeupTorque = ultraGrid2.Rows[i].Cells["MAKEUP_TORQUE"].Value.ToString();
                ParmEntity.TotalTorque = ultraGrid2.Rows[i].Cells["TOTAL_TORQUE"].Value.ToString();
                ParmEntity.BreakoutTorque = ultraGrid2.Rows[i].Cells["BREAKOUT_TORQUE"].Value.ToString();
                ParmEntity.ObservedThreadResult = ultraGrid2.Rows[i].Cells["OBSERVED_THREAD_RESULT"].Value.ToString();
                ParmEntity.TestCurve1 = ultraGrid2.Rows[i].Cells["TEST_CURVE1"].Value.ToString();
                ParmEntity.TestCurve2 = ultraGrid2.Rows[i].Cells["TEST_CURVE2"].Value.ToString();
                ParmEntity.Photo1 = ultraGrid2.Rows[i].Cells["PHOTO1"].Value.ToString();
                ParmEntity.Photo2 = ultraGrid2.Rows[i].Cells["PHOTO2"].Value.ToString();
                ParmEntity.ShoulderTorque = ultraGrid2.Rows[i].Cells["SHOULDER_TORQUE"].Value.ToString();
                arrayList.Add(JSONFormat.Format(ParmEntity));
            }

            PublicServer.SetData("com.steering.lims.data.outdec.FrmOutdecLabDateParm.SaveAntiGallingTest",
                    new Object[] { outdecDetailStr, arrayList }, _ob);
        }


       

        private void ultraFILE_PATH1_EditorButtonClick(object sender, EditorButtonEventArgs e)
        {

            if (e.Button.Key.ToLower().Equals("select"))
            {
                if (sender.Equals(ultraFILE_PATH1))
                {
                    selectFiel(ultraFILE_PATH1);
                }
                else if (sender.Equals(ultraFILE_PATH2))
                {
                    selectFiel(ultraFILE_PATH2);
                }
                else if (sender.Equals(ultraFILE_PATH3))
                {
                    selectFiel(ultraFILE_PATH3);
                }
                else if (sender.Equals(ultraFILE_PATH4))
                {
                    selectFiel(ultraFILE_PATH4);
                }
                else if (sender.Equals(ultraFILE_PATH5))
                {
                    selectFiel(ultraFILE_PATH5);
                }
                else if (sender.Equals(ultraFILE_PATH6))
                {
                    selectFiel(ultraFILE_PATH6);
                }
                else if (sender.Equals(ultraFILE_PATH7))
                {
                    selectFiel(ultraFILE_PATH7);
                }
                else if (sender.Equals(lsFILE_PATH1))
                {
                    selectFiel(lsFILE_PATH1);
                }
                else if (sender.Equals(lsFILE_PATH2))
                {
                    selectFiel(lsFILE_PATH2);
                }
                else if (sender.Equals(lsFILE_PATH3))
                {
                    selectFiel(lsFILE_PATH3);
                }
                else if (sender.Equals(kkFILE_PATH1))
                {
                    selectFiel(kkFILE_PATH1);
                }
                

            }
            else if (e.Button.Key.ToLower().Equals("update"))
            {
                if (sender.Equals(ultraFILE_PATH1))
                {
                    updateFile("1");
                    SaveCombinedStress();
                }
                else if (sender.Equals(ultraFILE_PATH2))
                {
                    updateFile("2");
                    SaveCombinedStress();
                }
                else if (sender.Equals(ultraFILE_PATH3))
                {
                    updateFile("3");
                    SaveCombinedStress();
                }
                else if (sender.Equals(ultraFILE_PATH4))
                {
                    updateFile("4");
                    SaveCombinedStress();
                }
                else if (sender.Equals(ultraFILE_PATH5))
                {
                    updateFile("5");
                    SaveCombinedStress();
                }
                else if (sender.Equals(ultraFILE_PATH6))
                {
                    updateFile("6");
                    SaveCombinedStress();
                }
                else if (sender.Equals(ultraFILE_PATH7))
                {
                    updateFile("7");
                    SaveCombinedStress();
                }
                else if (sender.Equals(lsFILE_PATH1))
                {
                    updateFile("1");
                    SaveCheckconsignDetailParm();
                }
                else if (sender.Equals(lsFILE_PATH2))
                {
                    updateFile("2");
                    SaveCheckconsignDetailParm();
                }
                else if (sender.Equals(lsFILE_PATH3))
                {
                    updateFile("3");
                    SaveCheckconsignDetailParm();
                }
                else if (sender.Equals(kkFILE_PATH1))
                {
                    updateFile("1");
                    saveAntiGallingTest();
                }
               
                Query();
            }
        }

        /// <summary>
        /// 查看图片
        /// </summary>
        /// <param name="ultra"></param>
        private void selectFiel(UltraTextEditor ultra)
        {
            string filePath = "";
            if (!ultra.Text.Equals(""))
            {
                filePath = ultra.Value.ToString();
            }
            dlgOrderAskDown down = new dlgOrderAskDown(this.ob, filePath);
            down.DeleteButton.Visible = false;
            down.ShowDialog();
        }

        /// <summary>
        /// 上传图片
        /// </summary>
        /// <param name="pathNum"></param>
        private void updateFile(string pathNum)
        {
            string path = "Inspection/" + CHECK_NO + "/" + SAMPLE_NO + "/" + PHY_CODE_MAX + "/";

            List<FileBean> list = new List<FileBean>();
            FileBean bean = new FileBean();
            OpenFileDialog file = new OpenFileDialog();
            file.Filter = "图片文件(*.jpg);(*.gif);(*.png);(*.bmp)|*.jpg;*.gif;*.png;*.bmp";
            file.Title = "选择需要上传的图片";
            file.Multiselect = false;
            DialogResult drStat;
            drStat = file.ShowDialog();

            if (drStat == DialogResult.OK)
            {
                string filePath = file.FileName;
                string fileName = System.IO.Path.GetFileName(filePath);

                bean = new FileBean();
                bean.setFileName(fileName);
                bean.setPathName(path);
                bean.setFile(FileHelper.FileToArray(filePath));
                list.Add(bean);
                bool isSuccess = Core.Mes.Client.Comm.Server.FileHelper.Upload(list);
                if (isSuccess)
                {
                    int count = ServerHelper.SetData("com.steering.lims.data.outdec.PublicOutdecBase.UpdateFilePath", new object[] { CHECK_NO, SAMPLE_NO, PHY_CODE_MAX, pathNum, path + fileName }, _ob);
                    MessageUtil.ShowTips("上传成功！");

                }
                else
                {
                    MessageUtil.ShowTips("上传失败,请重试！");
                }
            }
        }

        private void ultraGrid1_AfterRowInsert(object sender, RowEventArgs e)
        {
            e.Row.Cells["STEP"].Value = dataTable1.Rows.Count + 1;
        }

        private void ultraGrid2_AfterRowInsert(object sender, RowEventArgs e)
        {
            e.Row.Cells["STEP"].Value = dataTable2.Rows.Count + 1;
        }

        private void ultraGrid1_ClickCellButton(object sender, CellEventArgs e)
        {
            if (e.Cell.Column.Key == "BTN_DELETE")
            {
                for (int i = 0; i < dataTable1.Rows.Count; i++)
                {
                    ultraGrid1.Rows[i].Cells["STEP"].Value = i + 1;
                    if (dataTable1.Rows[i]["STEP"].ToString() == e.Cell.Row.Cells["STEP"].Value.ToString())
                    {
                        dataTable1.Rows.RemoveAt(i);
                        break;
                    }
                }
                for (int i = 0; i < dataTable1.Rows.Count; i++)
                {
                    ultraGrid1.Rows[i].Cells["STEP"].Value = i + 1;

                }
                ultraGrid1.DataBind();
            }
        }

        private void ultraGrid2_ClickCellButton(object sender, CellEventArgs e)
        {
            if (e.Cell.Column.Key == "BTN_DELETE")
            {
                for (int i = 0; i < dataTable2.Rows.Count; i++)
                {
                    ultraGrid2.Rows[i].Cells["STEP"].Value = i + 1;
                    if (dataTable2.Rows[i]["STEP"].ToString() == e.Cell.Row.Cells["STEP"].Value.ToString())
                    {
                        dataTable2.Rows.RemoveAt(i);
                        break;
                    }
                }
                for (int i = 0; i < dataTable2.Rows.Count; i++)
                {
                    ultraGrid2.Rows[i].Cells["STEP"].Value = i + 1;

                }
                ultraGrid2.DataBind();
            }
        }

        private void ultraTextEditor1_EditorButtonClick(object sender, EditorButtonEventArgs e)
        {
            UltraGridRow row = ultraGrid2.ActiveRow;
            string step = row.GetValue("STEP");
            if (e.Button.Key.ToLower().Equals("select"))
            {
                string filePath = "";
                if (ultraGrid2.ActiveCell.Column.Key == "TEST_CURVE1")
                {
                     filePath = row.GetValue("TEST_CURVE1");
                }
                else if (ultraGrid2.ActiveCell.Column.Key == "TEST_CURVE2")
                {
                     filePath = row.GetValue("TEST_CURVE2");
                }
                else if (ultraGrid2.ActiveCell.Column.Key == "PHOTO1")
                {
                     filePath = row.GetValue("PHOTO1");
                }
                else if (ultraGrid2.ActiveCell.Column.Key == "PHOTO2")
                {
                     filePath = row.GetValue("PHOTO2");
                }
                dlgOrderAskDown down = new dlgOrderAskDown(this.ob, filePath);
                down.DeleteButton.Visible = false;
                down.ShowDialog();
            }
            else if (e.Button.Key.ToLower().Equals("update"))
            {
                saveAntiGallingTest();
                string pathColumn = ultraGrid2.ActiveCell.Column.Key;
                
                string path = "Inspection/" + CHECK_NO + "/" + SAMPLE_NO + "/" + PHY_CODE_MAX + "/";
                List<FileBean> list = new List<FileBean>();
                FileBean bean = new FileBean();
                OpenFileDialog file = new OpenFileDialog();
                file.Filter = "图片文件(*.jpg);(*.gif);(*.png);(*.bmp)|*.jpg;*.gif;*.png;*.bmp";
                file.Title = "选择需要上传的图片";
                file.Multiselect = false;
                DialogResult drStat;
                drStat = file.ShowDialog();

                if (drStat == DialogResult.OK)
                {
                    string filePath = file.FileName;
                    string fileName = System.IO.Path.GetFileName(filePath);

                    bean = new FileBean();
                    bean.setFileName(fileName);
                    bean.setPathName(path);
                    bean.setFile(FileHelper.FileToArray(filePath));
                    list.Add(bean);
                    bool isSuccess = Core.Mes.Client.Comm.Server.FileHelper.Upload(list);
                    if (isSuccess)
                    {
                        int count = ServerHelper.SetData("com.steering.lims.data.outdec.FrmOutdecLabDateParm.UpdateFilePath", new object[] { CHECK_NO, SAMPLE_NO, PHY_CODE_MAX, step, pathColumn, path + fileName }, _ob);
                        MessageUtil.ShowTips("上传成功！");
                        Query();
                    }
                    else
                    {
                        MessageUtil.ShowTips("上传失败,请重试！");
                    }
                }
            }
        }

       
    }
}