public string Search(CvResonatorSettingProperty dataItem) { string sql = @" SELECT * FROM tableName WHERE PURCHASE_ID = 'dataItem.PURCHASE_ID' AND INUSE = 1 "; sql = sql.Replace("tableName", tableName); sql = sql.Replace("dataItem.PURCHASE_ID", dataItem.PURCHASE_ID); return(sql); }
public string Delete(CvResonatorSettingProperty dataItem) { string sql = @" UPDATE tableName SET INUSE = 0 , USER_UPDATE = 'dataItem.USER_UPDATE' , LAST_DATE = NOW() WHERE PURCHASE_ID = 'dataItem.PURCHASE_ID'"; sql = sql.Replace("tableName", tableName); sql = sql.Replace("dataItem.PURCHASE_ID", dataItem.PURCHASE_ID); sql = sql.Replace("dataItem.USER_UPDATE", dataItem.USER_UPDATE); return(sql); }
public CvResonatorSettingProperty Search(CvResonatorSettingProperty dataItem) { CvResonatorSettingProperty _property = null; try { _resultData = _model.Search(dataItem); if (_resultData.StatusOnDb == true) { if (_resultData.ResultOnDb.Rows.Count > 0) { _property = new CvResonatorSettingProperty { ID = _resultData.ResultOnDb.Rows[0]["ID"].ToString(), PURCHASE_ID = _resultData.ResultOnDb.Rows[0]["PURCHASE_ID"].ToString(), EFF_NEED = _resultData.ResultOnDb.Rows[0]["EFF_NEED"].ToString(), EFF_MIN_SLOPE = _resultData.ResultOnDb.Rows[0]["EFF_MIN_SLOPE"].ToString(), EFF_MAX_SLOPE = _resultData.ResultOnDb.Rows[0]["EFF_MAX_SLOPE"].ToString(), EFF_MIN_R2 = _resultData.ResultOnDb.Rows[0]["EFF_MIN_R2"].ToString(), EFF_MAX_R2 = _resultData.ResultOnDb.Rows[0]["EFF_MAX_R2"].ToString(), OC_TEMP_NEED = _resultData.ResultOnDb.Rows[0]["OC_TEMP_NEED"].ToString(), OC_TEMP_MIN_SLOPE = _resultData.ResultOnDb.Rows[0]["OC_TEMP_MIN_SLOPE"].ToString(), OC_TEMP_MAX_SLOPE = _resultData.ResultOnDb.Rows[0]["OC_TEMP_MAX_SLOPE"].ToString(), OC_TEMP_MIN_R2 = _resultData.ResultOnDb.Rows[0]["OC_TEMP_MIN_R2"].ToString(), OC_TEMP_MAX_R2 = _resultData.ResultOnDb.Rows[0]["OC_TEMP_MAX_R2"].ToString(), HR_TEMP_NEED = _resultData.ResultOnDb.Rows[0]["HR_TEMP_NEED"].ToString(), HR_TEMP_MIN_SLOPE = _resultData.ResultOnDb.Rows[0]["HR_TEMP_MIN_SLOPE"].ToString(), HR_TEMP_MAX_SLOPE = _resultData.ResultOnDb.Rows[0]["HR_TEMP_MAX_SLOPE"].ToString(), HR_TEMP_MIN_R2 = _resultData.ResultOnDb.Rows[0]["HR_TEMP_MIN_R2"].ToString(), HR_TEMP_MAX_R2 = _resultData.ResultOnDb.Rows[0]["HR_TEMP_MAX_R2"].ToString(), COLDPLATE_TEMP_NEED = _resultData.ResultOnDb.Rows[0]["COLDPLATE_TEMP_NEED"].ToString(), COLDPLATE_TEMP_MIN_SLOPE = _resultData.ResultOnDb.Rows[0]["COLDPLATE_TEMP_MIN_SLOPE"].ToString(), COLDPLATE_TEMP_MAX_SLOPE = _resultData.ResultOnDb.Rows[0]["COLDPLATE_TEMP_MAX_SLOPE"].ToString(), COLDPLATE_TEMP_MIN_R2 = _resultData.ResultOnDb.Rows[0]["COLDPLATE_TEMP_MIN_R2"].ToString(), COLDPLATE_TEMP_MAX_R2 = _resultData.ResultOnDb.Rows[0]["COLDPLATE_TEMP_MAX_R2"].ToString(), RESIDUAL_NEED = _resultData.ResultOnDb.Rows[0]["RESIDUAL_NEED"].ToString(), RESIDUAL_MIN_SIGNAL_FW = _resultData.ResultOnDb.Rows[0]["RESIDUAL_MIN_SIGNAL_FW"].ToString(), RESIDUAL_MAX_SIGNAL_FW = _resultData.ResultOnDb.Rows[0]["RESIDUAL_MAX_SIGNAL_FW"].ToString(), RESIDUAL_MIN_SIGNAL_BW = _resultData.ResultOnDb.Rows[0]["RESIDUAL_MIN_SIGNAL_BW"].ToString(), RESIDUAL_MAX_SIGNAL_BW = _resultData.ResultOnDb.Rows[0]["RESIDUAL_MAX_SIGNAL_BW"].ToString(), RESIDUAL_MIN_PUMP_FW = _resultData.ResultOnDb.Rows[0]["RESIDUAL_MIN_PUMP_FW"].ToString(), RESIDUAL_MAX_PUMP_FW = _resultData.ResultOnDb.Rows[0]["RESIDUAL_MAX_PUMP_FW"].ToString(), RESIDUAL_MIN_PUMP_BW = _resultData.ResultOnDb.Rows[0]["RESIDUAL_MIN_PUMP_BW"].ToString(), RESIDUAL_MAX_PUMP_BW = _resultData.ResultOnDb.Rows[0]["RESIDUAL_MAX_PUMP_BW"].ToString(), CENTERPORT_NEED = _resultData.ResultOnDb.Rows[0]["CENTERPORT_NEED"].ToString(), CENTERPORT_SIGNAL_MIN = _resultData.ResultOnDb.Rows[0]["CENTERPORT_SIGNAL_MIN"].ToString(), CENTERPORT_SIGNAL_MAX = _resultData.ResultOnDb.Rows[0]["CENTERPORT_SIGNAL_MAX"].ToString(), CENTERPORT_PUMP_MIN = _resultData.ResultOnDb.Rows[0]["CENTERPORT_PUMP_MIN"].ToString(), CENTERPORT_PUMP_MAX = _resultData.ResultOnDb.Rows[0]["CENTERPORT_PUMP_MAX"].ToString(), INCREASE_STEP = _resultData.ResultOnDb.Rows[0]["INCREASE_STEP"].ToString(), OUTPUT_TEMP_NEED = _resultData.ResultOnDb.Rows[0]["OUTPUT_TEMP_NEED"].ToString(), OUTPUT_TEMP_MIN_POINT1 = _resultData.ResultOnDb.Rows[0]["OUTPUT_TEMP_MIN_POINT1"].ToString(), OUTPUT_TEMP_MAX_POINT1 = _resultData.ResultOnDb.Rows[0]["OUTPUT_TEMP_MAX_POINT1"].ToString(), OUTPUT_TEMP_MIN_POINT2 = _resultData.ResultOnDb.Rows[0]["OUTPUT_TEMP_MIN_POINT2"].ToString(), OUTPUT_TEMP_MAX_POINT2 = _resultData.ResultOnDb.Rows[0]["OUTPUT_TEMP_MAX_POINT2"].ToString(), CREATE_DATE = _resultData.ResultOnDb.Rows[0]["CREATE_DATE"].ToString(), IP_ADDRESS = _resultData.ResultOnDb.Rows[0]["IP_ADDRESS"].ToString(), NAME_ADDRESS = _resultData.ResultOnDb.Rows[0]["NAME_ADDRESS"].ToString(), USER_CREATE = _resultData.ResultOnDb.Rows[0]["USER_CREATE"].ToString(), LAST_DATE = _resultData.ResultOnDb.Rows[0]["LAST_DATE"].ToString(), USER_UPDATE = _resultData.ResultOnDb.Rows[0]["USER_UPDATE"].ToString(), INUSE = _resultData.ResultOnDb.Rows[0]["INUSE"].ToString(), }; } } else { MessageBox.Show(_resultData.MessageOnDb, "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception ex) { MessageBox.Show(ex.Message, "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(_property); }
public OutputOnDbProperty Search(CvResonatorSettingProperty dataItem) { _resultData = _service.Search(dataItem); return(_resultData); }
public string Insert(CvResonatorSettingProperty dataItem) { string sql = @"INSERT INTO tableName ( ID , PURCHASE_ID , EFF_NEED , EFF_MIN_SLOPE , EFF_MAX_SLOPE , EFF_MIN_R2 , EFF_MAX_R2 , OC_TEMP_NEED , OC_TEMP_MIN_SLOPE , OC_TEMP_MAX_SLOPE , OC_TEMP_MIN_R2 , OC_TEMP_MAX_R2 , HR_TEMP_NEED , HR_TEMP_MIN_SLOPE , HR_TEMP_MAX_SLOPE , HR_TEMP_MIN_R2 , HR_TEMP_MAX_R2 , COLDPLATE_TEMP_NEED , COLDPLATE_TEMP_MIN_SLOPE , COLDPLATE_TEMP_MAX_SLOPE , COLDPLATE_TEMP_MIN_R2 , COLDPLATE_TEMP_MAX_R2 , RESIDUAL_NEED , RESIDUAL_MIN_SIGNAL_FW , RESIDUAL_MAX_SIGNAL_FW , RESIDUAL_MIN_SIGNAL_BW , RESIDUAL_MAX_SIGNAL_BW , RESIDUAL_MIN_PUMP_FW , RESIDUAL_MAX_PUMP_FW , RESIDUAL_MIN_PUMP_BW , RESIDUAL_MAX_PUMP_BW , CENTERPORT_NEED , CENTERPORT_SIGNAL_MIN , CENTERPORT_SIGNAL_MAX , CENTERPORT_PUMP_MIN , CENTERPORT_PUMP_MAX , INCREASE_STEP , OUTPUT_TEMP_NEED , OUTPUT_TEMP_MIN_POINT1 , OUTPUT_TEMP_MAX_POINT1 , OUTPUT_TEMP_MIN_POINT2 , OUTPUT_TEMP_MAX_POINT2 , IP_ADDRESS , NAME_ADDRESS , USER_CREATE , INUSE ) ( SELECT 1 + coalesce((SELECT max(Id) FROM tableName), 0) , 'dataItem.PURCHASE_ID' , 'dataItem.EFF_NEED' , 'dataItem.EFF_MIN_SLOPE' , 'dataItem.EFF_MAX_SLOPE' , 'dataItem.EFF_MIN_R2' , 'dataItem.EFF_MAX_R2' , 'dataItem.OC_TEMP_NEED' , 'dataItem.OC_TEMP_MIN_SLOPE' , 'dataItem.OC_TEMP_MAX_SLOPE' , 'dataItem.OC_TEMP_MIN_R2' , 'dataItem.OC_TEMP_MAX_R2' , 'dataItem.HR_TEMP_NEED' , 'dataItem.HR_TEMP_MIN_SLOPE' , 'dataItem.HR_TEMP_MAX_SLOPE' , 'dataItem.HR_TEMP_MIN_R2' , 'dataItem.HR_TEMP_MAX_R2' , 'dataItem.COLDPLATE_TEMP_NEED' , 'dataItem.COLDPLATE_TEMP_MIN_SLOPE' , 'dataItem.COLDPLATE_TEMP_MAX_SLOPE' , 'dataItem.COLDPLATE_TEMP_MIN_R2' , 'dataItem.COLDPLATE_TEMP_MAX_R2' , 'dataItem.RESIDUAL_NEED' , 'dataItem.RESIDUAL_MIN_SIGNAL_FW' , 'dataItem.RESIDUAL_MAX_SIGNAL_FW' , 'dataItem.RESIDUAL_MIN_SIGNAL_BW' , 'dataItem.RESIDUAL_MAX_SIGNAL_BW' , 'dataItem.RESIDUAL_MIN_PUMP_FW' , 'dataItem.RESIDUAL_MAX_PUMP_FW' , 'dataItem.RESIDUAL_MIN_PUMP_BW' , 'dataItem.RESIDUAL_MAX_PUMP_BW' , 'dataItem.CENTERPORT_NEED' , 'dataItem.CENTERPORT_SIGNAL_MIN' , 'dataItem.CENTERPORT_SIGNAL_MAX' , 'dataItem.CENTERPORT_PUMP_MIN' , 'dataItem.CENTERPORT_PUMP_MAX' , 'dataItem.INCREASE_STEP' , 'dataItem.OUTPUT_TEMP_NEED' , 'dataItem.OUTPUT_TEMP_MIN_POINT1' , 'dataItem.OUTPUT_TEMP_MAX_POINT1' , 'dataItem.OUTPUT_TEMP_MIN_POINT2' , 'dataItem.OUTPUT_TEMP_MAX_POINT2' , 'dataItem.IP_ADDRESS' , 'dataItem.NAME_ADDRESS' , 'dataItem.USER_CREATE' , 1 )"; sql = sql.Replace("tableName", tableName); sql = sql.Replace("dataItem.PURCHASE_ID", dataItem.PURCHASE_ID); sql = sql.Replace("dataItem.EFF_NEED", dataItem.EFF_NEED); sql = sql.Replace("dataItem.EFF_MIN_SLOPE", dataItem.EFF_MIN_SLOPE); sql = sql.Replace("dataItem.EFF_MAX_SLOPE", dataItem.EFF_MAX_SLOPE); sql = sql.Replace("dataItem.EFF_MIN_R2", dataItem.EFF_MIN_R2); sql = sql.Replace("dataItem.EFF_MAX_R2", dataItem.EFF_MAX_R2); sql = sql.Replace("dataItem.OC_TEMP_NEED", dataItem.OC_TEMP_NEED); sql = sql.Replace("dataItem.OC_TEMP_MIN_SLOPE", dataItem.OC_TEMP_MIN_SLOPE); sql = sql.Replace("dataItem.OC_TEMP_MAX_SLOPE", dataItem.OC_TEMP_MAX_SLOPE); sql = sql.Replace("dataItem.OC_TEMP_MIN_R2", dataItem.OC_TEMP_MIN_R2); sql = sql.Replace("dataItem.OC_TEMP_MAX_R2", dataItem.OC_TEMP_MAX_R2); sql = sql.Replace("dataItem.HR_TEMP_NEED", dataItem.HR_TEMP_NEED); sql = sql.Replace("dataItem.HR_TEMP_MIN_SLOPE", dataItem.HR_TEMP_MIN_SLOPE); sql = sql.Replace("dataItem.HR_TEMP_MAX_SLOPE", dataItem.HR_TEMP_MAX_SLOPE); sql = sql.Replace("dataItem.HR_TEMP_MIN_R2", dataItem.HR_TEMP_MIN_R2); sql = sql.Replace("dataItem.HR_TEMP_MAX_R2", dataItem.HR_TEMP_MAX_R2); sql = sql.Replace("dataItem.COLDPLATE_TEMP_NEED", dataItem.COLDPLATE_TEMP_NEED); sql = sql.Replace("dataItem.COLDPLATE_TEMP_MIN_SLOPE", dataItem.COLDPLATE_TEMP_MIN_SLOPE); sql = sql.Replace("dataItem.COLDPLATE_TEMP_MAX_SLOPE", dataItem.COLDPLATE_TEMP_MAX_SLOPE); sql = sql.Replace("dataItem.COLDPLATE_TEMP_MIN_R2", dataItem.COLDPLATE_TEMP_MIN_R2); sql = sql.Replace("dataItem.COLDPLATE_TEMP_MAX_R2", dataItem.COLDPLATE_TEMP_MAX_R2); sql = sql.Replace("dataItem.RESIDUAL_NEED", dataItem.RESIDUAL_NEED); sql = sql.Replace("dataItem.RESIDUAL_MIN_SIGNAL_FW", dataItem.RESIDUAL_MIN_SIGNAL_FW); sql = sql.Replace("dataItem.RESIDUAL_MAX_SIGNAL_FW", dataItem.RESIDUAL_MAX_SIGNAL_FW); sql = sql.Replace("dataItem.RESIDUAL_MIN_SIGNAL_BW", dataItem.RESIDUAL_MIN_SIGNAL_BW); sql = sql.Replace("dataItem.RESIDUAL_MAX_SIGNAL_BW", dataItem.RESIDUAL_MAX_SIGNAL_BW); sql = sql.Replace("dataItem.RESIDUAL_MIN_PUMP_FW", dataItem.RESIDUAL_MIN_PUMP_FW); sql = sql.Replace("dataItem.RESIDUAL_MAX_PUMP_FW", dataItem.RESIDUAL_MAX_PUMP_FW); sql = sql.Replace("dataItem.RESIDUAL_MIN_PUMP_BW", dataItem.RESIDUAL_MIN_PUMP_BW); sql = sql.Replace("dataItem.RESIDUAL_MAX_PUMP_BW", dataItem.RESIDUAL_MAX_PUMP_BW); sql = sql.Replace("dataItem.CENTERPORT_NEED", dataItem.CENTERPORT_NEED); sql = sql.Replace("dataItem.CENTERPORT_SIGNAL_MIN", dataItem.CENTERPORT_SIGNAL_MIN); sql = sql.Replace("dataItem.CENTERPORT_SIGNAL_MAX", dataItem.CENTERPORT_SIGNAL_MAX); sql = sql.Replace("dataItem.CENTERPORT_PUMP_MIN", dataItem.CENTERPORT_PUMP_MIN); sql = sql.Replace("dataItem.CENTERPORT_PUMP_MAX", dataItem.CENTERPORT_PUMP_MAX); sql = sql.Replace("dataItem.INCREASE_STEP", dataItem.INCREASE_STEP); sql = sql.Replace("dataItem.OUTPUT_TEMP_NEED", dataItem.OUTPUT_TEMP_NEED); sql = sql.Replace("dataItem.OUTPUT_TEMP_MIN_POINT1", dataItem.OUTPUT_TEMP_MIN_POINT1); sql = sql.Replace("dataItem.OUTPUT_TEMP_MAX_POINT1", dataItem.OUTPUT_TEMP_MAX_POINT1); sql = sql.Replace("dataItem.OUTPUT_TEMP_MIN_POINT2", dataItem.OUTPUT_TEMP_MIN_POINT2); sql = sql.Replace("dataItem.OUTPUT_TEMP_MAX_POINT2", dataItem.OUTPUT_TEMP_MAX_POINT2); 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.USER_CREATE", dataItem.USER_CREATE); sql = sql.Replace("dataItem.LAST_DATE", dataItem.LAST_DATE); sql = sql.Replace("dataItem.USER_UPDATE", dataItem.USER_UPDATE); sql = sql.Replace("dataItem.INUSE", dataItem.INUSE); return(sql); }