public string SearchBySystemId(CvSystemProperty dataItem) { string sql = @" SELECT * FROM tableName WHERE ID = 'dataItem.ID'"; sql = sql.Replace("tableName", tableName); sql = sql.Replace("dataItem.ID", dataItem.ID); return(sql); }
private void frmSystemSpecSettingCommon_Load(object sender, EventArgs e) { CvSystemProperty CvSystemProperty = _cvSystemController.SearchBySystemId(new CvSystemProperty { ID = frmSystem.SYSTEM_ID }); system_name.Text = CvSystemProperty.SYSTEM_NAME; ip_address_system.Text = CvSystemProperty.IP_ADDRESS_SYSTEM; _getDetail(); }
public string SearchByIpAddressSystem(CvSystemProperty dataItem) { string sql = @" SELECT * FROM tableName WHERE IP_ADDRESS_SYSTEM = 'dataItem.IP_ADDRESS_SYSTEM' AND INUSE = 1"; sql = sql.Replace("tableName", tableName); sql = sql.Replace("dataItem.IP_ADDRESS_SYSTEM", dataItem.IP_ADDRESS_SYSTEM); return(sql); }
private void frmSystemSpecSettingSpecific_Load(object sender, EventArgs e) { CvSystemProperty CvSystemProperty = _cvSystemController.SearchBySystemId(new CvSystemProperty { ID = frmSystem.SYSTEM_ID }); SYSTEM_NAME.Text = CvSystemProperty.SYSTEM_NAME; IP_ADDRESS_SYSTEM.Text = CvSystemProperty.IP_ADDRESS_SYSTEM; PURCHASE_NO.Text = frmSystemSpecificPurchase.PURCHASE_NO; _getDetailKikusuiPowerSupply(); }
private void btnSave_Click(object sender, EventArgs e) { if (_checkData() == true) { CvSystemProperty dataItem = new CvSystemProperty { SYSTEM_NAME = system_name.Text, IP_ADDRESS_SYSTEM = ip_address_system.Text, DESCRIPTION = description.Text, IP_ADDRESS = CommonClassLibraryGlobal.IP, NAME_ADDRESS = CommonClassLibraryGlobal.HOST_NAME, CREATE_USER = CommonClassLibraryGlobal.OPERATOR_ID, }; DialogResult res = MessageBox.Show("ยืนยันการบันทึกข้อมูล ?", "การยืนยัน", MessageBoxButtons.OKCancel, MessageBoxIcon.Information); if (res == DialogResult.Cancel) { return; } CvSystemProperty dataItemCheck = new CvSystemProperty(); dataItemCheck = CvSystemController.SearchByIpAddressSystem(dataItem); if (dataItemCheck != null) { CommonClassLibraryGlobal.showSuccess("ip address system นี้มีข้อมูลอยู่แล้ว"); _clearData(); return; } if (CvSystemController.Insert(dataItem)) { CommonClassLibraryGlobal.showSuccess("เพิ่มข้อมูลสำเร็จ"); this.Close(); return; } else { CommonClassLibraryGlobal.showSuccess("เพิ่มไม่ข้อมูลสำเร็จ กรุณาลองใหม่อีกครั้ง"); return; } } }
public List <CvSystemProperty> Search() { List <CvSystemProperty> listItem = new List <CvSystemProperty>(); try { _resultData = _model.Search(); if (_resultData.StatusOnDb == true) { foreach (DataRow row in _resultData.ResultOnDb.Rows) { CvSystemProperty productProperty = new CvSystemProperty { ID = row["ID"].ToString(), SYSTEM_NAME = row["SYSTEM_NAME"].ToString(), IP_ADDRESS_SYSTEM = row["IP_ADDRESS_SYSTEM"].ToString(), INUSE = row["INUSE"].ToString(), DESCRIPTION = row["DESCRIPTION"].ToString(), CREATE_USER = row["CREATE_USER"].ToString(), LAST_USER = row["LAST_USER"].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(), }; 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 bool Insert(CvSystemProperty dataItem) { bool result = true; try { _resultData = _model.Insert(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 string Insert(CvSystemProperty dataItem) { string sql = @"INSERT INTO tableName ( ID , SYSTEM_NAME , IP_ADDRESS_SYSTEM , INUSE , DESCRIPTION , CREATE_USER , IP_ADDRESS , NAME_ADDRESS ) ( SELECT 1 + coalesce((SELECT max(Id) FROM tableName), 0) , 'dataItem.SYSTEM_NAME' , 'dataItem.IP_ADDRESS_SYSTEM' , 1 , 'dataItem.DESCRIPTION' , 'dataItem.CREATE_USER' , 'dataItem.IP_ADDRESS' , 'dataItem.NAME_ADDRESS' )"; sql = sql.Replace("tableName", tableName); sql = sql.Replace("dataItem.SYSTEM_NAME", dataItem.SYSTEM_NAME); sql = sql.Replace("dataItem.IP_ADDRESS_SYSTEM", dataItem.IP_ADDRESS_SYSTEM); sql = sql.Replace("dataItem.INUSE", dataItem.INUSE); sql = sql.Replace("dataItem.DESCRIPTION", dataItem.DESCRIPTION); sql = sql.Replace("dataItem.CREATE_USER", dataItem.CREATE_USER); sql = sql.Replace("dataItem.LAST_USER", dataItem.LAST_USER); 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); return(sql); }
public CvSystemProperty SearchByIpAddressSystem(CvSystemProperty dataItem) { CvSystemProperty _property = null; try { _resultData = _model.SearchByIpAddressSystem(dataItem); if (_resultData.StatusOnDb == true) { if (_resultData.ResultOnDb.Rows.Count > 0) { _property = new CvSystemProperty { ID = _resultData.ResultOnDb.Rows[0]["ID"].ToString(), SYSTEM_NAME = _resultData.ResultOnDb.Rows[0]["SYSTEM_NAME"].ToString(), IP_ADDRESS_SYSTEM = _resultData.ResultOnDb.Rows[0]["IP_ADDRESS_SYSTEM"].ToString(), INUSE = _resultData.ResultOnDb.Rows[0]["INUSE"].ToString(), DESCRIPTION = _resultData.ResultOnDb.Rows[0]["DESCRIPTION"].ToString(), CREATE_USER = _resultData.ResultOnDb.Rows[0]["CREATE_USER"].ToString(), LAST_USER = _resultData.ResultOnDb.Rows[0]["LAST_USER"].ToString(), CREATE_DATE = _resultData.ResultOnDb.Rows[0]["CREATE_DATE"].ToString(), LAST_DATE = _resultData.ResultOnDb.Rows[0]["LAST_DATE"].ToString(), IP_ADDRESS = _resultData.ResultOnDb.Rows[0]["IP_ADDRESS"].ToString(), NAME_ADDRESS = _resultData.ResultOnDb.Rows[0]["NAME_ADDRESS"].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 Update(CvSystemProperty dataItem) { _resultData = _service.Update(dataItem); return(_resultData); }
public OutputOnDbProperty insert(CvSystemProperty dataItem) { _resultData = _service.Search(); return(_resultData); }
public OutputOnDbProperty SearchBySystemId(CvSystemProperty dataItem) { _resultData = _service.SearchBySystemId(dataItem); return(_resultData); }
public OutputOnDbProperty Insert(CvSystemProperty dataItem) { _resultData = _service.Insert(dataItem); return(_resultData); }