private void btnSave_Click(object sender, EventArgs e)
        {
            MessageBoxButtons buttons      = MessageBoxButtons.YesNo;
            DialogResult      resultDialog = MessageBox.Show("ยืนยันการบันทึกข้อมูล ?", "message", buttons, MessageBoxIcon.Warning);

            if (resultDialog == DialogResult.No)
            {
                return;
            }


            CvSystemCommonProperty data = new CvSystemCommonProperty();

            data.IP_ADDRESS   = CommonClassLibraryGlobal.IP;
            data.NAME_ADDRESS = CommonClassLibraryGlobal.HOST_NAME;
            data.SYSTEM_ID    = frmSystem.SYSTEM_ID;
            data.USER_CREATE  = CommonClassLibraryGlobal.OPERATOR_ID;
            data.USER_UPDATE  = CommonClassLibraryGlobal.OPERATOR_ID;

            foreach (Control toolBox in this.Controls)
            {
                if (toolBox is SettingSpec_Text_Value_Without_Panel)
                {
                    SettingSpec_Text_Value_Without_Panel tool = (SettingSpec_Text_Value_Without_Panel)toolBox;

                    if (!SettingSpec_Text_Value_Without_Panel.checkData(tool))
                    {
                        return;
                    }
                    else
                    {
                        PropertyInfo prop = null;

                        prop = data.GetType().GetProperty(toolBox.Name, BindingFlags.Public | BindingFlags.Instance);
                        if (null != prop && prop.CanWrite)
                        {
                            prop.SetValue(data, tool.TextBoxValue);
                        }
                        else
                        {
                            CommonClassLibraryGlobal.showError("ไม่สามารถเก็บค่าตัวแปรได้ '" + toolBox.Name + "' กรุณาติดต่อโปรแกรมเมอร์");
                            return;
                        }
                    }
                }
            }

            if (_cvSystemCommonController.Insert(data))
            {
                CommonClassLibraryGlobal.showSuccess("แก้ไขข้อมูลสำเร็จ");
                return;
            }
            else
            {
                CommonClassLibraryGlobal.showSuccess("แก้ไขข้อมูลไม่สำเร็จ กรุณาลองใหม่อีกครั้ง");
                return;
            }
        }
Пример #2
0
        public string SearchBySystemId(CvSystemCommonProperty dataItem)
        {
            string sql = @"SELECT * FROM tableName 
                             where 
                              SYSTEM_ID = 'dataItem.SYSTEM_ID'
                             AND INUSE = 1";

            sql = sql.Replace("tableName", tableName);

            sql = sql.Replace("dataItem.SYSTEM_ID", dataItem.SYSTEM_ID);
            return(sql);
        }
Пример #3
0
        public string Delete(CvSystemCommonProperty dataItem)
        {
            string sql = @" UPDATE tableName SET INUSE = 0 
                            , USER_UPDATE = 'dataItem.USER_UPDATE' 
                            , LAST_DATE = NOW()
                             WHERE SYSTEM_ID = 'dataItem.SYSTEM_ID' 
                             AND INUSE = 1 ";

            sql = sql.Replace("tableName", tableName);

            sql = sql.Replace("dataItem.SYSTEM_ID", dataItem.SYSTEM_ID);
            sql = sql.Replace("dataItem.USER_UPDATE", dataItem.USER_UPDATE);

            return(sql);
        }
        private void setOldValue(CvSystemCommonProperty data)
        {
            foreach (Control toolBox in this.Controls)
            {
                if (toolBox is SettingSpec_Text_Value_Without_Panel)
                {
                    SettingSpec_Text_Value_Without_Panel tool = (SettingSpec_Text_Value_Without_Panel)toolBox;

                    tool.TextBoxValue = GetPropValue(data, tool.Name.ToString()).ToString();


                    //var propInfo = data.GetType().GetProperty(tool.Name);
                    //if (propInfo != null)
                    //{
                    //    propInfo.SetValue(info, value, null);
                    //}
                }
            }
        }
Пример #5
0
        public bool Insert(CvSystemCommonProperty dataItem)
        {
            bool result = true;

            try
            {
                _resultData = _model.Insert(dataItem);
                if (_resultData.StatusOnDb == false)
                {
                    MessageBox.Show(_resultData.MessageOnDb, "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    result = false;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
                result = false;
            }

            return(result);
        }
Пример #6
0
        public List <CvSystemCommonProperty> SearchBySystemId(CvSystemCommonProperty dataItem)
        {
            List <CvSystemCommonProperty> listItem = new List <CvSystemCommonProperty>();

            try
            {
                _resultData = _model.SearchBySystemId(dataItem);
                if (_resultData.StatusOnDb == true)
                {
                    foreach (DataRow row in _resultData.ResultOnDb.Rows)
                    {
                        CvSystemCommonProperty productProperty = new CvSystemCommonProperty
                        {
                            ID                = row["ID"].ToString(),
                            SYSTEM_ID         = row["SYSTEM_ID"].ToString(),
                            OSA_GPIB_ADDRESS  = row["OSA_GPIB_ADDRESS"].ToString(),
                            DIO_COM_PORT      = row["DIO_COM_PORT"].ToString(),
                            RESIDUAL_COM_PORT = row["RESIDUAL_COM_PORT"].ToString(),
                            OPHIR_OUTPUT_POWER_METER_ADDRESS       = row["OPHIR_OUTPUT_POWER_METER_ADDRESS"].ToString(),
                            OPHIR_FW_METER_ADDRESS                 = row["OPHIR_FW_METER_ADDRESS"].ToString(),
                            OPHIR_BW_METER_ADDRESS                 = row["OPHIR_BW_METER_ADDRESS"].ToString(),
                            OPHIR_CENTER_PORT_FW_TFB_METER_ADDRESS = row["OPHIR_CENTER_PORT_FW_TFB_METER_ADDRESS"].ToString(),
                            GL840_SAFETY_PD_CHANNEL                = row["GL840_SAFETY_PD_CHANNEL"].ToString(),
                            GL840_COLD_PLATE_TEMP_CHANNEL          = row["GL840_COLD_PLATE_TEMP_CHANNEL"].ToString(),
                            GL840_MS_IN_TEMP_CHANNEL               = row["GL840_MS_IN_TEMP_CHANNEL"].ToString(),
                            GL840_BASEPLATE_TEMP_CHANNEL           = row["GL840_BASEPLATE_TEMP_CHANNEL"].ToString(),
                            GL840_MS_OUT_TEMP_CHANNEL              = row["GL840_MS_OUT_TEMP_CHANNEL"].ToString(),
                            GL840_CAVITY_PD_CHANNEL                = row["GL840_CAVITY_PD_CHANNEL"].ToString(),
                            SAFETY_SHUT_DOWN_THRESHOLD             = row["SAFETY_SHUT_DOWN_THRESHOLD"].ToString(),
                            SAFETY_OFFSET                            = row["SAFETY_OFFSET"].ToString(),
                            SAFETY_MIN_PD_OUTPUT                     = row["SAFETY_MIN_PD_OUTPUT"].ToString(),
                            SAFETY_MIN_OUTPUT_POWER                  = row["SAFETY_MIN_OUTPUT_POWER"].ToString(),
                            SAFETY_OUTPUT_CHECK_TIME                 = row["SAFETY_OUTPUT_CHECK_TIME"].ToString(),
                            SAFETY_MAX_COLDPLATE_TEMP                = row["SAFETY_MAX_COLDPLATE_TEMP"].ToString(),
                            OFFSET_SLOP_EFFICIENCY_RESONATOR         = row["OFFSET_SLOP_EFFICIENCY_RESONATOR"].ToString(),
                            OFFSET_SLOP_EFFICIENCY_THERMAL_SCREENING = row["OFFSET_SLOP_EFFICIENCY_THERMAL_SCREENING"].ToString(),
                            OFFSET_SLOP_EFFICIENCY_PRE_BURNIN_1      = row["OFFSET_SLOP_EFFICIENCY_PRE_BURNIN_1"].ToString(),
                            OFFSET_SLOP_EFFICIENCY_PRE_BURNIN_2      = row["OFFSET_SLOP_EFFICIENCY_PRE_BURNIN_2"].ToString(),
                            OFFSET_SLOP_EFFICIENCY_MONITOR_CAL       = row["OFFSET_SLOP_EFFICIENCY_MONITOR_CAL"].ToString(),
                            OFFSET_SLOP_EFFICIENCY_POST_BURNIN       = row["OFFSET_SLOP_EFFICIENCY_POST_BURNIN"].ToString(),
                            DESCRIPTION  = row["DESCRIPTION"].ToString(),
                            LAST_DATE    = row["LAST_DATE"].ToString(),
                            USER_UPDATE  = row["USER_UPDATE"].ToString(),
                            CREATE_DATE  = row["CREATE_DATE"].ToString(),
                            IP_ADDRESS   = row["IP_ADDRESS"].ToString(),
                            NAME_ADDRESS = row["NAME_ADDRESS"].ToString(),
                            INUSE        = row["INUSE"].ToString(),
                            USER_CREATE  = row["USER_CREATE"].ToString(),
                        };

                        listItem.Add(productProperty);
                    }
                }
                else
                {
                    MessageBox.Show(_resultData.MessageOnDb, "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }

            return(listItem);
        }
Пример #7
0
 public OutputOnDbProperty SearchBySystemId(CvSystemCommonProperty dataItem)
 {
     _resultData = _service.SearchBySystemId(dataItem);
     return(_resultData);
 }
Пример #8
0
 public OutputOnDbProperty Insert(CvSystemCommonProperty dataItem)
 {
     _resultData = _service.Insert(dataItem);
     return(_resultData);
 }
Пример #9
0
        public string Insert(CvSystemCommonProperty dataItem)
        {
            string sql = @"INSERT INTO tableName
                                        (
                                          ID
                                        , SYSTEM_ID
                                        , OSA_GPIB_ADDRESS
                                        , DIO_COM_PORT
                                        , RESIDUAL_COM_PORT
                                        , OPHIR_OUTPUT_POWER_METER_ADDRESS
                                        , OPHIR_FW_METER_ADDRESS
                                        , OPHIR_BW_METER_ADDRESS
                                        , OPHIR_CENTER_PORT_FW_TFB_METER_ADDRESS
                                        , GL840_SAFETY_PD_CHANNEL
                                        , GL840_COLD_PLATE_TEMP_CHANNEL
                                        , GL840_MS_IN_TEMP_CHANNEL
                                        , GL840_BASEPLATE_TEMP_CHANNEL
                                        , GL840_MS_OUT_TEMP_CHANNEL
                                        , GL840_CAVITY_PD_CHANNEL
                                        , SAFETY_SHUT_DOWN_THRESHOLD
                                        , SAFETY_OFFSET
                                        , SAFETY_MIN_PD_OUTPUT
                                        , SAFETY_MIN_OUTPUT_POWER
                                        , SAFETY_OUTPUT_CHECK_TIME
                                        , SAFETY_MAX_COLDPLATE_TEMP
                                        , OFFSET_SLOP_EFFICIENCY_RESONATOR
                                        , OFFSET_SLOP_EFFICIENCY_THERMAL_SCREENING
                                        , OFFSET_SLOP_EFFICIENCY_PRE_BURNIN_1
                                        , OFFSET_SLOP_EFFICIENCY_PRE_BURNIN_2
                                        , OFFSET_SLOP_EFFICIENCY_MONITOR_CAL
                                        , OFFSET_SLOP_EFFICIENCY_POST_BURNIN
                                        , DESCRIPTION
                                        , IP_ADDRESS
                                        , NAME_ADDRESS
                                        , INUSE
                                        , USER_CREATE
                                        )
                                        (
                                          SELECT 1 + coalesce((SELECT max(Id) FROM tableName), 0) 
                                        , 'dataItem.SYSTEM_ID'
                                        , 'dataItem.OSA_GPIB_ADDRESS'
                                        , 'dataItem.DIO_COM_PORT'
                                        , 'dataItem.RESIDUAL_COM_PORT'
                                        , 'dataItem.OPHIR_OUTPUT_POWER_METER_ADDRESS'
                                        , 'dataItem.OPHIR_FW_METER_ADDRESS'
                                        , 'dataItem.OPHIR_BW_METER_ADDRESS'
                                        , 'dataItem.OPHIR_CENTER_PORT_FW_TFB_METER_ADDRESS'
                                        , 'dataItem.GL840_SAFETY_PD_CHANNEL'
                                        , 'dataItem.GL840_COLD_PLATE_TEMP_CHANNEL'
                                        , 'dataItem.GL840_MS_IN_TEMP_CHANNEL'
                                        , 'dataItem.GL840_BASEPLATE_TEMP_CHANNEL'
                                        , 'dataItem.GL840_MS_OUT_TEMP_CHANNEL'
                                        , 'dataItem.GL840_CAVITY_PD_CHANNEL'
                                        , 'dataItem.SAFETY_SHUT_DOWN_THRESHOLD'
                                        , 'dataItem.SAFETY_OFFSET'
                                        , 'dataItem.SAFETY_MIN_PD_OUTPUT'
                                        , 'dataItem.SAFETY_MIN_OUTPUT_POWER'
                                        , 'dataItem.SAFETY_OUTPUT_CHECK_TIME'
                                        , 'dataItem.SAFETY_MAX_COLDPLATE_TEMP'
                                        , 'dataItem.OFFSET_SLOP_EFFICIENCY_RESONATOR'
                                        , 'dataItem.OFFSET_SLOP_EFFICIENCY_THERMAL_SCREENING'
                                        , 'dataItem.OFFSET_SLOP_EFFICIENCY_PRE_BURNIN_1'
                                        , 'dataItem.OFFSET_SLOP_EFFICIENCY_PRE_BURNIN_2'
                                        , 'dataItem.OFFSET_SLOP_EFFICIENCY_MONITOR_CAL'
                                        , 'dataItem.OFFSET_SLOP_EFFICIENCY_POST_BURNIN'
                                        , 'dataItem.DESCRIPTION'
                                        , 'dataItem.IP_ADDRESS'
                                        , 'dataItem.NAME_ADDRESS'
                                        , 1
                                        , 'dataItem.USER_CREATE'
                                        )";

            sql = sql.Replace("tableName", tableName);

            sql = sql.Replace("dataItem.SYSTEM_ID", dataItem.SYSTEM_ID);
            sql = sql.Replace("dataItem.OSA_GPIB_ADDRESS", dataItem.OSA_GPIB_ADDRESS);
            sql = sql.Replace("dataItem.DIO_COM_PORT", dataItem.DIO_COM_PORT);
            sql = sql.Replace("dataItem.RESIDUAL_COM_PORT", dataItem.RESIDUAL_COM_PORT);
            sql = sql.Replace("dataItem.OPHIR_OUTPUT_POWER_METER_ADDRESS", dataItem.OPHIR_OUTPUT_POWER_METER_ADDRESS);
            sql = sql.Replace("dataItem.OPHIR_FW_METER_ADDRESS", dataItem.OPHIR_FW_METER_ADDRESS);
            sql = sql.Replace("dataItem.OPHIR_BW_METER_ADDRESS", dataItem.OPHIR_BW_METER_ADDRESS);
            sql = sql.Replace("dataItem.OPHIR_CENTER_PORT_FW_TFB_METER_ADDRESS", dataItem.OPHIR_CENTER_PORT_FW_TFB_METER_ADDRESS);
            sql = sql.Replace("dataItem.GL840_SAFETY_PD_CHANNEL", dataItem.GL840_SAFETY_PD_CHANNEL);
            sql = sql.Replace("dataItem.GL840_COLD_PLATE_TEMP_CHANNEL", dataItem.GL840_COLD_PLATE_TEMP_CHANNEL);
            sql = sql.Replace("dataItem.GL840_MS_IN_TEMP_CHANNEL", dataItem.GL840_MS_IN_TEMP_CHANNEL);
            sql = sql.Replace("dataItem.GL840_BASEPLATE_TEMP_CHANNEL", dataItem.GL840_BASEPLATE_TEMP_CHANNEL);
            sql = sql.Replace("dataItem.GL840_MS_OUT_TEMP_CHANNEL", dataItem.GL840_MS_OUT_TEMP_CHANNEL);
            sql = sql.Replace("dataItem.GL840_CAVITY_PD_CHANNEL", dataItem.GL840_CAVITY_PD_CHANNEL);
            sql = sql.Replace("dataItem.SAFETY_SHUT_DOWN_THRESHOLD", dataItem.SAFETY_SHUT_DOWN_THRESHOLD);
            sql = sql.Replace("dataItem.SAFETY_OFFSET", dataItem.SAFETY_OFFSET);
            sql = sql.Replace("dataItem.SAFETY_MIN_PD_OUTPUT", dataItem.SAFETY_MIN_PD_OUTPUT);
            sql = sql.Replace("dataItem.SAFETY_MIN_OUTPUT_POWER", dataItem.SAFETY_MIN_OUTPUT_POWER);
            sql = sql.Replace("dataItem.SAFETY_OUTPUT_CHECK_TIME", dataItem.SAFETY_OUTPUT_CHECK_TIME);
            sql = sql.Replace("dataItem.SAFETY_MAX_COLDPLATE_TEMP", dataItem.SAFETY_MAX_COLDPLATE_TEMP);
            sql = sql.Replace("dataItem.OFFSET_SLOP_EFFICIENCY_RESONATOR", dataItem.OFFSET_SLOP_EFFICIENCY_RESONATOR);
            sql = sql.Replace("dataItem.OFFSET_SLOP_EFFICIENCY_THERMAL_SCREENING", dataItem.OFFSET_SLOP_EFFICIENCY_THERMAL_SCREENING);
            sql = sql.Replace("dataItem.OFFSET_SLOP_EFFICIENCY_PRE_BURNIN_1", dataItem.OFFSET_SLOP_EFFICIENCY_PRE_BURNIN_1);
            sql = sql.Replace("dataItem.OFFSET_SLOP_EFFICIENCY_PRE_BURNIN_2", dataItem.OFFSET_SLOP_EFFICIENCY_PRE_BURNIN_2);
            sql = sql.Replace("dataItem.OFFSET_SLOP_EFFICIENCY_MONITOR_CAL", dataItem.OFFSET_SLOP_EFFICIENCY_MONITOR_CAL);
            sql = sql.Replace("dataItem.OFFSET_SLOP_EFFICIENCY_POST_BURNIN", dataItem.OFFSET_SLOP_EFFICIENCY_POST_BURNIN);
            sql = sql.Replace("dataItem.DESCRIPTION", dataItem.DESCRIPTION);
            sql = sql.Replace("dataItem.LAST_DATE", dataItem.LAST_DATE);
            sql = sql.Replace("dataItem.USER_UPDATE", dataItem.USER_UPDATE);
            sql = sql.Replace("dataItem.CREATE_DATE", dataItem.CREATE_DATE);
            sql = sql.Replace("dataItem.IP_ADDRESS", dataItem.IP_ADDRESS);
            sql = sql.Replace("dataItem.NAME_ADDRESS", dataItem.NAME_ADDRESS);
            sql = sql.Replace("dataItem.INUSE", dataItem.INUSE);
            sql = sql.Replace("dataItem.USER_CREATE", dataItem.USER_CREATE);

            return(sql);
        }