public string SearchByPurchaseId(CvResonatorSettingStepProperty dataItem)
{
string sql = @"SELECT * FROM tableName
where
inuse = 1
AND PURCHASE_ID = 'dataItem.PURCHASE_ID'
ORDER BY step_number";
sql = sql.Replace("tableName", tableName);
sql = sql.Replace("dataItem.PURCHASE_ID", dataItem.PURCHASE_ID);
return(sql);
}
public string Delete(CvResonatorSettingStepProperty dataItem)
{
string sql = @" UPDATE tableName SET INUSE = 0
, USER_UPDATE = 'dataItem.USER_UPDATE'
, LAST_DATE = NOW()
WHERE PURCHASE_ID = 'dataItem.PURCHASE_ID'
AND inuse = 1";
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 string SearchByPurchaseIdAndStepNo(CvResonatorSettingStepProperty dataItem)
{
string sql = @"SELECT * FROM tableName
where
inuse = 1
AND PURCHASE_ID = 'dataItem.PURCHASE_ID'
AND STEP_NUMBER = 'dataItem.STEP_NUMBER'";
sql = sql.Replace("tableName", tableName);
sql = sql.Replace("dataItem.PURCHASE_ID", dataItem.PURCHASE_ID);
sql = sql.Replace("dataItem.STEP_NUMBER", dataItem.STEP_NUMBER);
return(sql);
}
public string Insert(CvResonatorSettingStepProperty dataItem)
{
string sql = @"INSERT INTO tableName
(
ID
, PURCHASE_ID
, STEP_NUMBER
, VOLTAGE
, IP_ADDRESS
, NAME_ADDRESS
, USER_CREATE
, INUSE
)
(
SELECT 1 + coalesce((SELECT max(Id) FROM tableName), 0)
, 'dataItem.PURCHASE_ID'
, 'dataItem.STEP_NUMBER'
, 'dataItem.VOLTAGE'
, '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.STEP_NUMBER", dataItem.STEP_NUMBER);
sql = sql.Replace("dataItem.VOLTAGE", dataItem.VOLTAGE);
sql = sql.Replace("dataItem.CREATE_DATE", dataItem.CREATE_DATE);
sql = sql.Replace("dataItem.LAST_DATE", dataItem.LAST_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.USER_UPDATE", dataItem.USER_UPDATE);
sql = sql.Replace("dataItem.INUSE", dataItem.INUSE);
return(sql);
}
public List <CvResonatorSettingStepProperty> SearchByPurchaseId(CvResonatorSettingStepProperty dataItem)
{
List <CvResonatorSettingStepProperty> listItem = new List <CvResonatorSettingStepProperty>();
try
{
_resultData = _model.SearchByPurchaseId(dataItem);
if (_resultData.StatusOnDb == true)
{
foreach (DataRow row in _resultData.ResultOnDb.Rows)
{
CvResonatorSettingStepProperty productProperty = new CvResonatorSettingStepProperty
{
ID = row["ID"].ToString(),
PURCHASE_ID = row["PURCHASE_ID"].ToString(),
STEP_NUMBER = row["STEP_NUMBER"].ToString(),
VOLTAGE = row["VOLTAGE"].ToString(),
CREATE_DATE = row["CREATE_DATE"].ToString(),
LAST_DATE = row["LAST_DATE"].ToString(),
IP_ADDRESS = row["IP_ADDRESS"].ToString(),
NAME_ADDRESS = row["NAME_ADDRESS"].ToString(),
USER_CREATE = row["USER_CREATE"].ToString(),
USER_UPDATE = row["USER_UPDATE"].ToString(),
INUSE = row["INUSE"].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);
}
public OutputOnDbProperty SearchByPurchaseId(CvResonatorSettingStepProperty dataItem)
{
_resultData = _service.SearchByPurchaseId(dataItem);
return(_resultData);
}
