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);
}
