public string Insert(CvSystemSpecificProperty dataItem)
{
string sql = @"INSERT INTO tableName
(
ID
, SYSTEM_ID
, PURCHASE_ID
, KIKUSUI_USB_NAME
, KIKUSUI_ADDRESS
, KIKUSUI_MAX_CURRENT
, KIKUSUI_MAX_VOLTAGE
, IP_ADDRESS
, NAME_ADDRESS
, USER_CREATE
, DESCRIPTION
, INUSE
)
(
SELECT 1 + coalesce((SELECT max(Id) FROM tableName), 0)
, 'dataItem.SYSTEM_ID'
, 'dataItem.PURCHASE_ID'
, 'dataItem.KIKUSUI_USB_NAME'
, 'dataItem.KIKUSUI_ADDRESS'
, 'dataItem.KIKUSUI_MAX_CURRENT'
, 'dataItem.KIKUSUI_MAX_VOLTAGE'
, 'dataItem.IP_ADDRESS'
, 'dataItem.NAME_ADDRESS'
, 'dataItem.USER_CREATE'
, 'dataItem.DESCRIPTION'
, 1
)";
sql = sql.Replace("tableName", tableName);
sql = sql.Replace("dataItem.SYSTEM_ID", dataItem.SYSTEM_ID);
sql = sql.Replace("dataItem.PURCHASE_ID", dataItem.PURCHASE_ID);
sql = sql.Replace("dataItem.KIKUSUI_USB_NAME", dataItem.KIKUSUI_USB_NAME);
sql = sql.Replace("dataItem.KIKUSUI_ADDRESS", dataItem.KIKUSUI_ADDRESS);
sql = sql.Replace("dataItem.KIKUSUI_MAX_CURRENT", dataItem.KIKUSUI_MAX_CURRENT);
sql = sql.Replace("dataItem.KIKUSUI_MAX_VOLTAGE", dataItem.KIKUSUI_MAX_VOLTAGE);
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.DESCRIPTION", dataItem.DESCRIPTION);
sql = sql.Replace("dataItem.CREATE_DATE", dataItem.CREATE_DATE);
sql = sql.Replace("dataItem.LAST_DATE", dataItem.LAST_DATE);
return(sql);
}
public string SearchBySystemIdAndPurchaseId(CvSystemSpecificProperty dataItem)
{
string sql = @" SELECT * FROM tableName
WHERE PURCHASE_ID = 'dataItem.PURCHASE_ID'
AND SYSTEM_ID = 'dataItem.SYSTEM_ID'
AND INUSE = 1 ";
sql = sql.Replace("tableName", tableName);
sql = sql.Replace("dataItem.PURCHASE_ID", dataItem.PURCHASE_ID);
sql = sql.Replace("dataItem.SYSTEM_ID", dataItem.SYSTEM_ID);
return(sql);
}
private void _getDetailKikusuiPowerSupply()
{
//-- Kikusui
CvSystemSpecificProperty itemData = _cvSystemSpecificController.SearchBySystemIdAndPurchaseId(new CvSystemSpecificProperty {
SYSTEM_ID = frmSystem.SYSTEM_ID, PURCHASE_ID = frmSystemSpecificPurchase.PURCHASE_ID
});
if (itemData != null)
{
KIKUSUI_ADDRESS.Text = itemData.KIKUSUI_ADDRESS;
KIKUSUI_USB_NAME.Text = itemData.KIKUSUI_USB_NAME;
KIKUSUI_MAX_CURRENT.Text = itemData.KIKUSUI_MAX_CURRENT;
KIKUSUI_MAX_VOLTAGE.Text = itemData.KIKUSUI_MAX_VOLTAGE;
}
}
public string Delete(CvSystemSpecificProperty dataItem)
{
string sql = @" UPDATE tableName SET INUSE = 0
, USER_UPDATE = 'dataItem.USER_UPDATE'
, LAST_DATE = NOW()
WHERE PURCHASE_ID = 'dataItem.PURCHASE_ID'
AND SYSTEM_ID = 'dataItem.SYSTEM_ID' ";
sql = sql.Replace("tableName", tableName);
sql = sql.Replace("dataItem.PURCHASE_ID", dataItem.PURCHASE_ID);
sql = sql.Replace("dataItem.SYSTEM_ID", dataItem.SYSTEM_ID);
sql = sql.Replace("dataItem.USER_UPDATE", dataItem.USER_UPDATE);
return(sql);
}
public CvSystemSpecificProperty SearchBySystemIdAndPurchaseId(CvSystemSpecificProperty dataItem)
{
CvSystemSpecificProperty _property = null;
try
{
_resultData = _model.SearchBySystemIdAndPurchaseId(dataItem);
if (_resultData.StatusOnDb == true)
{
if (_resultData.ResultOnDb.Rows.Count > 0)
{
_property = new CvSystemSpecificProperty
{
ID = _resultData.ResultOnDb.Rows[0]["ID"].ToString(),
SYSTEM_ID = _resultData.ResultOnDb.Rows[0]["SYSTEM_ID"].ToString(),
PURCHASE_ID = _resultData.ResultOnDb.Rows[0]["PURCHASE_ID"].ToString(),
KIKUSUI_USB_NAME = _resultData.ResultOnDb.Rows[0]["KIKUSUI_USB_NAME"].ToString(),
KIKUSUI_ADDRESS = _resultData.ResultOnDb.Rows[0]["KIKUSUI_ADDRESS"].ToString(),
KIKUSUI_MAX_CURRENT = _resultData.ResultOnDb.Rows[0]["KIKUSUI_MAX_CURRENT"].ToString(),
KIKUSUI_MAX_VOLTAGE = _resultData.ResultOnDb.Rows[0]["KIKUSUI_MAX_VOLTAGE"].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(),
USER_UPDATE = _resultData.ResultOnDb.Rows[0]["USER_UPDATE"].ToString(),
DESCRIPTION = _resultData.ResultOnDb.Rows[0]["DESCRIPTION"].ToString(),
CREATE_DATE = _resultData.ResultOnDb.Rows[0]["CREATE_DATE"].ToString(),
LAST_DATE = _resultData.ResultOnDb.Rows[0]["LAST_DATE"].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 bool InsertAndUpdateInuse(CvSystemSpecificProperty dataItem)
{
bool result = true;
try
{
_resultData = _model.InsertAndUpdateInuse(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);
}
public OutputOnDbProperty SearchBySystemIdAndPurchaseId(CvSystemSpecificProperty dataItem)
{
_resultData = _service.SearchBySystemIdAndPurchaseId(dataItem);
return(_resultData);
}
public OutputOnDbProperty InsertAndUpdateInuse(CvSystemSpecificProperty dataItem)
{
_resultData = _service.InsertAndUpdateInuse(dataItem);
return(_resultData);
}
private void btnSave_Click(object sender, EventArgs e)
{
if (String.IsNullOrWhiteSpace(KIKUSUI_USB_NAME.Text))
{
CommonClassLibraryGlobal.showError("กรุณากรอก kikusui usb name");
KIKUSUI_USB_NAME.Focus();
return;
}
if (String.IsNullOrWhiteSpace(KIKUSUI_ADDRESS.Text))
{
CommonClassLibraryGlobal.showError("กรุณากรอก kikusui address");
KIKUSUI_ADDRESS.Focus();
return;
}
if (!double.TryParse(KIKUSUI_MAX_CURRENT.Text, out CommonClassLibraryGlobal.chkDouble))
{
CommonClassLibraryGlobal.showError("กรุณากรอก kikusui max current เป็นตัวเลขเท่านั้น");
KIKUSUI_MAX_CURRENT.Text = "";
KIKUSUI_MAX_CURRENT.Focus();
return;
}
if (!double.TryParse(KIKUSUI_MAX_VOLTAGE.Text, out CommonClassLibraryGlobal.chkDouble))
{
CommonClassLibraryGlobal.showError("กรุณากรอก kikusui max voltage เป็นตัวเลขเท่านั้น");
KIKUSUI_MAX_VOLTAGE.Text = "";
KIKUSUI_MAX_VOLTAGE.Focus();
return;
}
MessageBoxButtons buttons = MessageBoxButtons.YesNo;
DialogResult result = MessageBox.Show("คุณต้องการบันทึกข้อมูล ?", "Message", buttons, MessageBoxIcon.Warning);
if (result == DialogResult.No)
{
return;
}
CvSystemSpecificProperty itemData = new CvSystemSpecificProperty
{
SYSTEM_ID = frmSystem.SYSTEM_ID,
PURCHASE_ID = frmSystemSpecificPurchase.PURCHASE_ID,
KIKUSUI_USB_NAME = KIKUSUI_USB_NAME.Text,
KIKUSUI_ADDRESS = KIKUSUI_ADDRESS.Text,
KIKUSUI_MAX_CURRENT = KIKUSUI_MAX_CURRENT.Text,
KIKUSUI_MAX_VOLTAGE = KIKUSUI_MAX_VOLTAGE.Text,
IP_ADDRESS = CommonClassLibraryGlobal.IP,
NAME_ADDRESS = CommonClassLibraryGlobal.HOST_NAME,
USER_CREATE = CommonClassLibraryGlobal.OPERATOR_ID,
USER_UPDATE = CommonClassLibraryGlobal.OPERATOR_ID,
};
if (_cvSystemSpecificController.InsertAndUpdateInuse(itemData) == true)
{
CommonClassLibraryGlobal.showSuccess("แก้ไขข้อมูลสำเร็จ");
}
else
{
CommonClassLibraryGlobal.showSuccess("แก้ไขข้อมูลไม่สำเร็จ กรุณาลองใหม่อีกครั้ง");
}
}
