private bool _getInitialVoltage(CvSystemSpecificPurchaseProperty dataItem)
{
bool result = true;
try
{
dataGridView1.Rows.Clear();
CvSystemSpecificPurchaseProperty CvSystemSpecificProcessProperty = _cvSystemSpecificPurchaseController.SearchBySystemIdAndPurchaseId(dataItem);
if (CvSystemSpecificProcessProperty != null)
{
INITIAL_VOLTAGE_OF_INPUT.Text = CvSystemSpecificProcessProperty.INITIAL_VOLTAGE_OF_INPUT;
INITIAL_VOLTAGE_OF_OUTPUT.Text = CvSystemSpecificProcessProperty.INITIAL_VOLTAGE_OF_OUTPUT;
OUTPUT_TEMPERATURE_TARGET_POWER.Text = CvSystemSpecificProcessProperty.OUTPUT_TEMPERATURE_TARGET_POWER;
}
else
{
INITIAL_VOLTAGE_OF_INPUT.Text = "";
INITIAL_VOLTAGE_OF_OUTPUT.Text = "";
OUTPUT_TEMPERATURE_TARGET_POWER.Text = "";
}
}
catch (Exception ex)
{
CommonClassLibraryGlobal.showError(ex.Message);
result = false;
}
return(result);
}
public string Insert(CvSystemSpecificPurchaseProperty dataItem)
{
string sql = @"INSERT INTO tableName
(
ID
, SYSTEM_ID
, PURCHASE_ID
, PROCESS_NAME
, INITIAL_VOLTAGE_OF_INPUT
, INITIAL_VOLTAGE_OF_OUTPUT
, OUTPUT_TEMPERATURE_TARGET_POWER
, IP_ADDRESS
, NAME_ADDRESS
, USER_CREATE
, DESCRIPTION
, INUSE
)
(
SELECT 1 + coalesce((SELECT max(Id) FROM tableName), 0)
, 'dataItem.SYSTEM_ID'
, 'dataItem.PURCHASE_ID'
, 'dataItem.PROCESS_NAME'
, 'dataItem.INITIAL_VOLTAGE_OF_INPUT'
, 'dataItem.INITIAL_VOLTAGE_OF_OUTPUT'
, 'dataItem.OUTPUT_TEMPERATURE_TARGET_POWER'
, '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.PROCESS_NAME", dataItem.PROCESS_NAME);
sql = sql.Replace("dataItem.INITIAL_VOLTAGE_OF_INPUT", dataItem.INITIAL_VOLTAGE_OF_INPUT);
sql = sql.Replace("dataItem.INITIAL_VOLTAGE_OF_OUTPUT", dataItem.INITIAL_VOLTAGE_OF_OUTPUT);
sql = sql.Replace("dataItem.OUTPUT_TEMPERATURE_TARGET_POWER", dataItem.OUTPUT_TEMPERATURE_TARGET_POWER);
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);
sql = sql.Replace("dataItem.INUSE", dataItem.INUSE);
return(sql);
}
private void processClick(object sender, EventArgs e)
{
btnResonatorTest.BackColor = Color.FromArgb(181, 234, 215);
btnThermalScreening.BackColor = Color.FromArgb(181, 234, 215);
btnPreBurnIn1.BackColor = Color.FromArgb(181, 234, 215);
btnPreKinkTest.BackColor = Color.FromArgb(181, 234, 215);
btnSRS1.BackColor = Color.FromArgb(181, 234, 215);
btnPreBurnIn2.BackColor = Color.FromArgb(181, 234, 215);
btnKinkTest.BackColor = Color.FromArgb(181, 234, 215);
btnBurnIn.BackColor = Color.FromArgb(181, 234, 215);
btnPostBI.BackColor = Color.FromArgb(181, 234, 215);
btnSRS2.BackColor = Color.FromArgb(181, 234, 215);
Button btn = (Button)sender;
//txtProcessSelected.Text = btn.Name.Replace("btn", "").Replace("no", "");
txtProcessSelected.Text = btn.Text;
//CommonClass.targetPower = txtTargetPower.Text;
//CommonClass.processName = txtProcess.Text;
flowLayoutPanelProcess.Controls["btn" + btn.Name.Replace("btn", "").Replace("no", "")].BackColor = Color.FromArgb(245, 183, 177);
CvSystemSpecificPurchasePowerOutputProperty CvSystemSpecificProcessPowerOutputProperty = new CvSystemSpecificPurchasePowerOutputProperty
{
SYSTEM_ID = frmSystem.SYSTEM_ID,
PURCHASE_ID = frmSystemSpecificPurchase.PURCHASE_ID,
PROCESS_NAME = txtProcessSelected.Text,
};
CvSystemSpecificPurchaseProperty CvSystemSpecificProcessProperty = new CvSystemSpecificPurchaseProperty()
{
SYSTEM_ID = frmSystem.SYSTEM_ID,
PURCHASE_ID = frmSystemSpecificPurchase.PURCHASE_ID,
PROCESS_NAME = txtProcessSelected.Text,
};
if (_getInitialVoltage(CvSystemSpecificProcessProperty) == false)
{
this.Close();
}
if (_getTargetPower(CvSystemSpecificProcessPowerOutputProperty) == false)
{
this.Close();
}
_backToSet();
}
public string SearchBySystemIdAndPurchaseId(CvSystemSpecificPurchaseProperty dataItem)
{
string sql = @" SELECT * FROM tableName
WHERE PURCHASE_ID = 'dataItem.PURCHASE_ID'
AND SYSTEM_ID = 'dataItem.SYSTEM_ID'
AND PROCESS_NAME = 'dataItem.PROCESS_NAME'
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);
sql = sql.Replace("dataItem.PROCESS_NAME", dataItem.PROCESS_NAME);
return(sql);
}
public string Delete(CvSystemSpecificPurchaseProperty dataItem)
{
string sql = @" UPDATE tableName SET INUSE = 0
, USER_UPDATE = 'dataItem.USER_UPDATE'
, LAST_DATE = NOW()
WHERE PURCHASE_ID = 'dataItem.PURCHASE_ID'
AND PROCESS_NAME = 'dataItem.PROCESS_NAME'
AND SYSTEM_ID = 'dataItem.SYSTEM_ID' ";
sql = sql.Replace("tableName", tableName);
sql = sql.Replace("dataItem.USER_UPDATE", dataItem.USER_UPDATE);
sql = sql.Replace("dataItem.PURCHASE_ID", dataItem.PURCHASE_ID);
sql = sql.Replace("dataItem.SYSTEM_ID", dataItem.SYSTEM_ID);
sql = sql.Replace("dataItem.PROCESS_NAME", dataItem.PROCESS_NAME);
return(sql);
}
public CvSystemSpecificPurchaseProperty SearchBySystemIdAndPurchaseId(CvSystemSpecificPurchaseProperty dataItem)
{
CvSystemSpecificPurchaseProperty _property = null;
try
{
_resultData = _model.SearchBySystemIdAndPurchaseId(dataItem);
if (_resultData.StatusOnDb == true)
{
if (_resultData.ResultOnDb.Rows.Count > 0)
{
_property = new CvSystemSpecificPurchaseProperty
{
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(),
PROCESS_NAME = _resultData.ResultOnDb.Rows[0]["PROCESS_NAME"].ToString(),
INITIAL_VOLTAGE_OF_INPUT = _resultData.ResultOnDb.Rows[0]["INITIAL_VOLTAGE_OF_INPUT"].ToString(),
INITIAL_VOLTAGE_OF_OUTPUT = _resultData.ResultOnDb.Rows[0]["INITIAL_VOLTAGE_OF_OUTPUT"].ToString(),
OUTPUT_TEMPERATURE_TARGET_POWER = _resultData.ResultOnDb.Rows[0]["OUTPUT_TEMPERATURE_TARGET_POWER"].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(CvSystemSpecificPurchaseProperty 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(CvSystemSpecificPurchaseProperty dataItem)
{
_resultData = _service.SearchBySystemIdAndPurchaseId(dataItem);
return(_resultData);
}
public OutputOnDbProperty InsertAndUpdateInuse(CvSystemSpecificPurchaseProperty dataItem)
{
_resultData = _service.InsertAndUpdateInuse(dataItem);
return(_resultData);
}
private void btnSaveInitialVoltage_Click(object sender, EventArgs e)
{
MessageBoxButtons buttons = MessageBoxButtons.YesNo;
DialogResult result = MessageBox.Show("คุณต้องการบันทึกข้อมูล ?", "Message", buttons, MessageBoxIcon.Warning);
if (result == DialogResult.No)
{
return;
}
if (txtProcessSelected.Text == "XXX")
{
CommonClassLibraryGlobal.showError("กรุณาเลือกโปรเซสที่ต้องการ");
return;
}
if (!double.TryParse(INITIAL_VOLTAGE_OF_INPUT.Text, out CommonClassLibraryGlobal.chkDouble))
{
CommonClassLibraryGlobal.showError("กรุณากรอก Initial Voltage Of Input power control เป็นตัวเลขเท่านั้น");
INITIAL_VOLTAGE_OF_INPUT.Text = "";
INITIAL_VOLTAGE_OF_INPUT.Focus();
return;
}
if (double.Parse(INITIAL_VOLTAGE_OF_INPUT.Text) > Properties.Settings.Default.MAX_VOLTAGE || double.Parse(INITIAL_VOLTAGE_OF_INPUT.Text) < Properties.Settings.Default.MIN_VOLTAGE)
{
CommonClassLibraryGlobal.showError("กรุณากรอก Initial Voltage Of Input power control ให้อยู่ระหว่าง " + Properties.Settings.Default.MIN_VOLTAGE + " ถึง " + Properties.Settings.Default.MAX_VOLTAGE);
INITIAL_VOLTAGE_OF_INPUT.Text = "";
INITIAL_VOLTAGE_OF_INPUT.Focus();
return;
}
if (!double.TryParse(INITIAL_VOLTAGE_OF_OUTPUT.Text, out CommonClassLibraryGlobal.chkDouble))
{
CommonClassLibraryGlobal.showError("กรุณากรอก Initial Voltage Of Output power control เป็นตัวเลขเท่านั้น");
INITIAL_VOLTAGE_OF_OUTPUT.Text = "";
INITIAL_VOLTAGE_OF_OUTPUT.Focus();
return;
}
//if (double.Parse(INITIAL_VOLTAGE_OF_OUTPUT.Text) > Properties.Settings.Default.MAX_VOLTAGE || double.Parse(INITIAL_VOLTAGE_OF_OUTPUT.Text) < Properties.Settings.Default.MIN_VOLTAGE)
//{
// CommonClassLibraryGlobal.showError("กรุณากรอก Initial Voltage Of Output power control ให้อยู่ระหว่าง " + Properties.Settings.Default.MIN_VOLTAGE + " ถึง " + Properties.Settings.Default.MAX_VOLTAGE);
// INITIAL_VOLTAGE_OF_OUTPUT.Text = "";
// INITIAL_VOLTAGE_OF_OUTPUT.Focus();
// return;
//}
if (!string.IsNullOrWhiteSpace(OUTPUT_TEMPERATURE_TARGET_POWER.Text))
{
if (!double.TryParse(OUTPUT_TEMPERATURE_TARGET_POWER.Text, out CommonClassLibraryGlobal.chkDouble))
{
CommonClassLibraryGlobal.showError("กรุณากรอก Target Power Of Output Temperature เป็นตัวเลขเท่านั้น");
OUTPUT_TEMPERATURE_TARGET_POWER.Text = "";
OUTPUT_TEMPERATURE_TARGET_POWER.Focus();
return;
}
}
CvSystemSpecificPurchaseProperty dataItem = new CvSystemSpecificPurchaseProperty()
{
SYSTEM_ID = frmSystem.SYSTEM_ID,
PURCHASE_ID = frmSystemSpecificPurchase.PURCHASE_ID,
PROCESS_NAME = txtProcessSelected.Text,
INITIAL_VOLTAGE_OF_INPUT = INITIAL_VOLTAGE_OF_INPUT.Text,
INITIAL_VOLTAGE_OF_OUTPUT = INITIAL_VOLTAGE_OF_OUTPUT.Text,
OUTPUT_TEMPERATURE_TARGET_POWER = OUTPUT_TEMPERATURE_TARGET_POWER.Text,
IP_ADDRESS = CommonClassLibraryGlobal.IP,
NAME_ADDRESS = CommonClassLibraryGlobal.HOST_NAME,
USER_CREATE = CommonClassLibraryGlobal.OPERATOR_ID,
USER_UPDATE = CommonClassLibraryGlobal.OPERATOR_ID,
};
if (_cvSystemSpecificPurchaseController.InsertAndUpdateInuse(dataItem) == true)
{
CommonClassLibraryGlobal.showSuccess("แก้ไขข้อมูลสำเร็จ");
return;
}
else
{
CommonClassLibraryGlobal.showSuccess("แก้ไขข้อมูลไม่สำเร็จ กรุณาลองใหม่อีกครั้ง");
return;
}
}
