//public void queryComboMstGeographies() //{ // MST003Controller mst003Ctrl = new MST003Controller(); // try // { // object[] result = mst003Ctrl.queryComboMstGeographies(); // MsgForm msgForm = (MsgForm)result[0]; // List<MST_GEOGRAPHIES> lstdata = (List<MST_GEOGRAPHIES>)result[1]; // if (msgForm.statusFlag.Equals(1)) // { // cboGeography.DataSource = lstdata; // cboGeography.ValueMember = "GEOGRAPHY_ID"; // cboGeography.DisplayMember = "NAME"; // cboGeography.SelectedValue = ""; // cboGeography.Text = "---กรุณาเลือก---"; // } // else // { // MessageBox.Show("Error : " + msgForm.messageDescription); // } // } // catch (Exception ex) // { // log.Error(ex.ToString(), ex); // MessageBox.Show("Error : " + ex.ToString()); // } //} public void queryComboMstProvinces() { MST003Controller mst003Ctrl = new MST003Controller(); try { object[] result = mst003Ctrl.queryComboMstProvinces(); MsgForm msgForm = (MsgForm)result[0]; List <MST_PROVINCES> lstdata = (List <MST_PROVINCES>)result[1]; if (msgForm.statusFlag.Equals(1)) { cboProvince.DataSource = lstdata; cboProvince.ValueMember = "PROVINCE_ID"; cboProvince.DisplayMember = "NAME_TH"; cboProvince.SelectedValue = ""; } else { MessageBox.Show("Error : " + msgForm.messageDescription); } } catch (Exception ex) { log.Error(ex.ToString(), ex); MessageBox.Show("Error : " + ex.ToString()); } }
public void queryDataMstVendorByVendorId() { MST003Controller mst003Ctrl = new MST003Controller(); try { object[] result = mst003Ctrl.queryDataMstVendorByVendorId(formMstVendor); MsgForm msgForm = (MsgForm)result[0]; MST_VENDOR data = (MST_VENDOR)result[1]; if (msgForm.statusFlag.Equals(1)) { if (Util.isNotEmpty(data)) { txtVendorId.Text = data.VENDOR_ID; txtVendorName.Text = data.VENDOR_NAME; txtVendorAddress.Text = data.VENDOR_ADDRESS; //cboDistricts.SelectedValue = data.VENDOR_DISTRICT; //cboAmphure.SelectedValue = data.VENDOR_AMPHURE; //cboProvince.SelectedValue = data.VENDOR_PROVINCE; txtVendorPostcode.Text = data.VENDOR_POSTCODE; txtVendorTelNo.Text = data.VENDOR_TEL_NO; txtVendorFax.Text = data.VENDOR_FAX; formMstVendor = data; formMstVendor.VENDOR_PROVINCE = data.VENDOR_PROVINCE; formMstVendor.VENDOR_AMPHURE = data.VENDOR_AMPHURE; formMstVendor.VENDOR_DISTRICT = data.VENDOR_DISTRICT; queryComboMstAmphures(); queryComboMstDistricts(); cboDistricts.SelectedValue = data.VENDOR_DISTRICT; cboAmphure.SelectedValue = data.VENDOR_AMPHURE; cboProvince.SelectedValue = data.VENDOR_PROVINCE; } } else { MessageBox.Show("Error : " + msgForm.messageDescription); } } catch (Exception ex) { log.Error(ex.ToString(), ex); MessageBox.Show("Error : " + ex.ToString()); } }
public void queryComboMstDistricts() { MST003Controller mst003Ctrl = new MST003Controller(); MST_DISTRICTS form = new MST_DISTRICTS(); try { if (!formMstVendor.VENDOR_AMPHURE.Equals(0)) { form.AMPHURE_ID = formMstVendor.VENDOR_AMPHURE; } else { form.AMPHURE_ID = Int32.Parse(cboAmphure.SelectedValue.ToString()); } if (Util.isEmpty(form.AMPHURE_ID)) { return; } object[] result = mst003Ctrl.queryComboMstDistricts(form); MsgForm msgForm = (MsgForm)result[0]; //List<MST_DISTRICTS> lstdata = (List<MST_DISTRICTS>)result[1]; lstdataDistricts = (List <MST_DISTRICTS>)result[1]; if (msgForm.statusFlag.Equals(1)) { cboDistricts.DataSource = lstdataDistricts; cboDistricts.ValueMember = "DISTRICT_ID"; cboDistricts.DisplayMember = "NAME_TH"; cboDistricts.SelectedValue = ""; } else { MessageBox.Show("Error : " + msgForm.messageDescription); } } catch (Exception ex) { log.Error(ex.ToString(), ex); MessageBox.Show("Error : " + ex.ToString()); } }
public void searchDataVwMstVendor() { MST003Controller mst003Ctrl = new MST003Controller(); try { object[] result = mst003Ctrl.searchDataVwMstVendor(); MsgForm msgForm = (MsgForm)result[0]; List <VW_MST_VENDOR> lstdata = (List <VW_MST_VENDOR>)result[1]; if (msgForm.statusFlag.Equals(1)) { dataGridView1.DataSource = lstdata; dataGridView1.DefaultCellStyle.Font = new Font("TH SarabunPSK", 16); dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells; dataGridView1.EnableHeadersVisualStyles = false; dataGridView1.ColumnHeadersDefaultCellStyle.BackColor = Color.SkyBlue; dataGridView1.ColumnHeadersHeight = 150; dataGridView1.ColumnHeadersDefaultCellStyle.Font = new Font("TH SarabunPSK", 16, FontStyle.Bold); dataGridView1.RowTemplate.Height = 40; dataGridView1.Columns[0].HeaderCell.Value = "รหัสผู้ขาย"; dataGridView1.Columns[1].HeaderCell.Value = "ชื่อผู้ขาย"; dataGridView1.Columns[2].HeaderCell.Value = "ที่อยู่ผู้ขาย"; dataGridView1.Columns[3].HeaderCell.Value = "ตำบล"; dataGridView1.Columns[4].HeaderCell.Value = "อำเภอ"; dataGridView1.Columns[5].HeaderCell.Value = "จังหวัด"; dataGridView1.Columns[6].HeaderCell.Value = "รหัสไปรษณีย์"; dataGridView1.Columns[7].HeaderCell.Value = "เบอร์โทรศัพท์"; dataGridView1.Columns[8].HeaderCell.Value = "แฟกซ์"; lblCountData.Text = "แสดงข้อมูลทั้งหมด " + lstdata.Count() + " รายการ"; } else { MessageBox.Show("Error : " + msgForm.messageDescription); } } catch (Exception ex) { log.Error(ex.ToString(), ex); MessageBox.Show("Error : " + ex.ToString()); } }
public void deleteDataMstVendor() { MST003Controller mst003Ctrl = new MST003Controller(); MST_VENDOR form = new MST_VENDOR(); try { form.VENDOR_ID = txtVendorId.Text; if (Util.isEmpty(form.VENDOR_ID)) { MessageBox.Show(CommonUtil.SELECT_DATA_DELETE); return; } if (MessageBox.Show(CommonUtil.CONFIRM_DELETE_DATA, CommonUtil.TITLE_DELETE, MessageBoxButtons.YesNo) == DialogResult.Yes) { object[] result = mst003Ctrl.deleteDataMstVendor(form); MsgForm msgForm = (MsgForm)result[0]; if (msgForm.statusFlag.Equals(1)) { resetDataMstVendor(); searchDataVwMstVendor(); MessageBox.Show(CommonUtil.DELETE_DATA_SUCCESS); } else { MessageBox.Show("Error : " + msgForm.messageDescription); } } } catch (Exception ex) { log.Error(ex.ToString(), ex); MessageBox.Show("Error : " + ex.ToString()); } }
public void insertOrUpdateDataMstVendor() { MST003Controller mst003Ctrl = new MST003Controller(); MST_VENDOR form = new MST_VENDOR(); try { if (Util.isEmpty(txtVendorId.Text) || Util.isEmpty(txtVendorName.Text)) { MessageBox.Show(CommonUtil.REQUIRE_MESSAGE); return; } form.VENDOR_ID = txtVendorId.Text; form.VENDOR_NAME = txtVendorName.Text; form.VENDOR_ADDRESS = txtVendorAddress.Text; form.VENDOR_DISTRICT = Int32.Parse(cboDistricts.SelectedValue.ToString()); form.VENDOR_AMPHURE = Int32.Parse(cboAmphure.SelectedValue.ToString()); form.VENDOR_PROVINCE = Int32.Parse(cboProvince.SelectedValue.ToString()); form.VENDOR_POSTCODE = txtVendorPostcode.Text; form.VENDOR_TEL_NO = txtVendorTelNo.Text; form.VENDOR_FAX = txtVendorFax.Text; if (Util.isEmpty(form)) { return; } object[] result = mst003Ctrl.insertOrUpdateDataMstVendor(form, flagAddEdit); MsgForm msgForm = (MsgForm)result[0]; MST_VENDOR data = (MST_VENDOR)result[1]; if (flagAddEdit.Equals("A")) { if (Util.isNotEmpty(data)) { if (msgForm.statusFlag.Equals(1)) { MessageBox.Show(CommonUtil.DUPLICATE_DATA); } else { MessageBox.Show("Error : " + msgForm.messageDescription); } } else { if (msgForm.statusFlag.Equals(1)) { resetDataMstVendor(); searchDataVwMstVendor(); MessageBox.Show(CommonUtil.SAVE_DATA_SUCCESS); } else { MessageBox.Show("Error : " + msgForm.messageDescription); } } } else if (flagAddEdit.Equals("E")) { if (msgForm.statusFlag.Equals(1)) { resetDataMstVendor(); searchDataVwMstVendor(); MessageBox.Show(CommonUtil.SAVE_DATA_SUCCESS); } else { MessageBox.Show("Error : " + msgForm.messageDescription); } } } catch (Exception ex) { log.Error(ex.ToString(), ex); MessageBox.Show("Error : " + ex.ToString()); } }