private void btnSave_Click(object sender, EventArgs e) { DataRow param = dcore.GetSearchPeople(navyid); param["address_out"] = txtaddress_old.Text.Trim(); param["address_mu_out"] = txtaddress_mu_old.Text.Trim(); param["address_soid_out"] = txtaddress_soid_old.Text.Trim(); param["address_road_out"] = txtaddress_road_old.Text.Trim(); if (!string.IsNullOrEmpty(DataControls.GetSelectedValueComboBoxToString(cmbsub_district_old))) { param["towncode_out"] = DataControls.GetSelectedValueComboBoxToString(cmbsub_district_old); } else if (!string.IsNullOrEmpty(DataControls.GetSelectedValueComboBoxToString(cmbdistrict_old))) { param["towncode_out"] = DataControls.GetSelectedValueComboBoxToString(cmbdistrict_old); } else if (!string.IsNullOrEmpty(DataControls.GetSelectedValueComboBoxToString(cmbprovince_old))) { param["towncode_out"] = DataControls.GetSelectedValueComboBoxToString(cmbprovince_old); } param["report_number"] = report_number; if (dcore.UpdatePeople(param)) { MessageBox.Show("บันทึกสำเร็จ"); this.Close(); } else { MessageBox.Show("บันทึกผิดพลาด"); } }
private void btnsave_Click(object sender, EventArgs e) { if (!Ischeck()) { #region ADD/EDIT if (modes == "new") { DataRow dr = dcore.GetSearchPeople("", txtrank.Text.Trim(), txtbooknumber.Text.Trim()); if (dr != null) { if (dr["rank"].ToString() == txtrank.Text.Trim() && dr["book_number"].ToString() == txtbooknumber.Text.Trim()) { MessageBox.Show("ลำดับเล่มที่" + txtbooknumber.Text.Trim() + " ลำดับที่" + txtrank.Text.Trim() + "มีอยู่แล้วในระบบ"); } } else { DataRow param = dcore.GetListPeople("", "", "").NewRow(); param["id13"] = txtid13.Text.Trim(); param["navyid"] = navyid; param["people_name"] = txtpeoole_name.Text.Trim(); param["people_lname"] = txtpeoole_name.Text.Trim(); param["address_in"] = txtaddress_old.Text.Trim(); param["address_in"] = txtaddress_old.Text.Trim(); param["address_mu_in"] = txtaddress_mu_old.Text.Trim(); param["address_soid_in"] = txtaddress_soid_old.Text.Trim(); param["address_road_in"] = txtaddress_road_old.Text.Trim(); if (!string.IsNullOrEmpty(DataControls.GetSelectedValueComboBoxToString(cmbsub_district_old))) { param["towncode_in"] = DataControls.GetSelectedValueComboBoxToString(cmbsub_district_old); } else if (!string.IsNullOrEmpty(DataControls.GetSelectedValueComboBoxToString(cmbdistrict_old))) { param["towncode_in"] = DataControls.GetSelectedValueComboBoxToString(cmbdistrict_old); } else if (!string.IsNullOrEmpty(DataControls.GetSelectedValueComboBoxToString(cmbprovince_old))) { param["towncode_in"] = DataControls.GetSelectedValueComboBoxToString(cmbprovince_old); } param["book_number"] = txtbooknumber.Text.Trim(); param["rank"] = txtrank.Text.Trim(); param["status"] = "1"; param["type_out"] = "26"; if (this.dp_indate.CustomFormat != " " && dp_indate.Value.Date != DateTime.Now) { param["in_date"] = dp_indate.Value.Date; } if (dcore.InsertPeople(param)) { MessageBox.Show("บันทึกสำเร็จ"); ClearControl(); } else { MessageBox.Show("บันทึกผิดพลาด"); } } } else { DataRow param = dcore.GetSearchPeople(cardid, "", ""); if (param != null) { param["id13"] = txtid13.Text.Trim(); param["navyid"] = param["navyid"].ToString(); param["people_name"] = txtpeoole_name.Text.Trim(); param["people_lname"] = txtpeople_lname.Text.Trim(); param["address_in"] = txtaddress_old.Text.Trim(); param["address_mu_in"] = txtaddress_mu_old.Text.Trim(); param["address_soid_in"] = txtaddress_soid_old.Text.Trim(); param["address_road_in"] = txtaddress_road_old.Text.Trim(); if (!string.IsNullOrEmpty(DataControls.GetSelectedValueComboBoxToString(cmbsub_district_old))) { param["towncode_in"] = DataControls.GetSelectedValueComboBoxToString(cmbsub_district_old); } else if (!string.IsNullOrEmpty(DataControls.GetSelectedValueComboBoxToString(cmbdistrict_old))) { param["towncode_in"] = DataControls.GetSelectedValueComboBoxToString(cmbdistrict_old); } else if (!string.IsNullOrEmpty(DataControls.GetSelectedValueComboBoxToString(cmbprovince_old))) { param["towncode_in"] = DataControls.GetSelectedValueComboBoxToString(cmbprovince_old); } param["book_number"] = txtbooknumber.Text.Trim(); param["rank"] = txtrank.Text.Trim(); param["type_out"] = "26"; param["status"] = "1"; if (chkout.Checked) { param["address_out"] = txtaddress.Text.Trim(); param["address_mu_out"] = txtaddress_mu.Text.Trim(); param["address_soid_out"] = txtaddress_soid.Text.Trim(); param["address_road_out"] = txtaddress_road.Text.Trim(); if (!string.IsNullOrEmpty(DataControls.GetSelectedValueComboBoxToString(cmbsub_district))) { param["towncode_out"] = DataControls.GetSelectedValueComboBoxToString(cmbsub_district); } else if (!string.IsNullOrEmpty(DataControls.GetSelectedValueComboBoxToString(cmbdistrict))) { param["towncode_out"] = DataControls.GetSelectedValueComboBoxToString(cmbdistrict); } else if (!string.IsNullOrEmpty(DataControls.GetSelectedValueComboBoxToString(cmbprovince))) { param["towncode_out"] = DataControls.GetSelectedValueComboBoxToString(cmbprovince); } param["status"] = DataControls.GetSelectedValueComboBoxToString(cmbselect_out); if (this.dp_outdate.CustomFormat != " " && dp_indate.Value.Date != DateTime.Now) { param["out_date"] = dp_outdate.Value.Date; } param["type_out"] = DataControls.GetSelectedValueComboBoxToString(cmbselectaddress); } if (dcore.UpdatePeople(param)) { MessageBox.Show("บันทึกสำเร็จ"); this.Close(); } else { MessageBox.Show("บันทึกผิดพลาด"); } } } #endregion } }