protected void GetData(string navyid) { DataRow dr = null; if (!string.IsNullOrEmpty(navyid)) { dr = dcore.GetSearchPeople(navyid); } if (dr != null) { if (!string.IsNullOrEmpty(dr["yearin"].ToString())) { lblyearintext.Text = dr["yearin"].ToString(); } else { lblyearintext.Text = "-"; } if (!string.IsNullOrEmpty(dr["unit3"].ToString())) { lblunittext.Text = dr["unit3"].ToString(); } else { lblunittext.Text = "-"; } if (!string.IsNullOrEmpty(dr["oldyearin"].ToString())) { lbloldyearintext.Text = dr["oldyearin"].ToString(); } else { lbloldyearintext.Text = "-"; } lblname.Text = dr["name"].ToString(); lblsname.Text = dr["sname"].ToString(); label10.Text = dr["id13"].ToString(); if (!string.IsNullOrEmpty(dr["report_number"].ToString())) { txtaddress_old.Text = dr["address_out"].ToString(); txtaddress_mu_old.Text = dr["address_mu_out"].ToString(); txtaddress_soid_old.Text = dr["address_soid_out"].ToString(); txtaddress_road_old.Text = dr["address_road_out"].ToString(); string tcode = dr["towncode_out"].ToString(); try { townnameManage.LoadProvinceToComboBox(cmbprovince_old, tcode); cmbprovince_old.SelectedValue = tcode.Substring(0, 2) + "0000"; townnameManage.LoadCityToComboBox(cmbdistrict_old, tcode.Substring(0, 2) + "0000", tcode.Substring(0, 4) + "00"); townnameManage.LoadTumbonToComboBox(cmbsub_district_old, tcode.Substring(0, 4) + "00", tcode); } catch { } } } }
protected void GetData(string navyid, string selectmove) { DataRow dr = null; if (!string.IsNullOrEmpty(navyid)) { dr = dcore.GetSearchPeople(navyid); } if (dr != null) { if (!string.IsNullOrEmpty(dr["yearin"].ToString())) { lblyearintext.Text = dr["yearin"].ToString(); } else { lblyearintext.Text = "-"; } if (!string.IsNullOrEmpty(dr["unit3"].ToString())) { lblunittext.Text = dr["unit3"].ToString(); } else { lblunittext.Text = "-"; } if (!string.IsNullOrEmpty(dr["oldyearin"].ToString())) { lbloldyearintext.Text = dr["oldyearin"].ToString(); } else { lbloldyearintext.Text = "-"; } lbname.Text = dr["name"].ToString(); lblsname.Text = dr["sname"].ToString(); lblid13.Text = dr["id13"].ToString(); lbladdress_old.Text = dr["address_in"].ToString(); lbladdress_mu_old.Text = dr["address_mu_in"].ToString(); lbladdress_soid_old.Text = dr["address_soid_in"].ToString(); lbladdress_road_old.Text = dr["address_road_in"].ToString(); string tcode = dr["towncode_in"].ToString(); try { DataTable city = DataDefinition.GetTownnameLV2(tcode).Copy(); townnameManage_old.LoadProvinceToComboBox(cmbprovince_old, tcode); cmbprovince_old.SelectedValue = tcode.Substring(0, 2) + "0000"; townnameManage_old.LoadCityToComboBox(cmbdistrict_old, tcode.Substring(0, 2) + "0000", tcode.Substring(0, 4) + "00"); townnameManage_old.LoadTumbonToComboBox(cmbsub_district_old, tcode.Substring(0, 4) + "00", tcode); } catch { } lbladdress.Text = dr["address_out"].ToString(); lbladdress_mu.Text = dr["address_mu_out"].ToString(); lbladdress_soid.Text = dr["address_soid_out"].ToString(); lbladdress_road.Text = dr["address_road_out"].ToString(); string tcode_out = dr["towncode_out"].ToString(); try { DataTable city = DataDefinition.GetTownnameLV2(tcode_out).Copy(); townnameManage.LoadProvinceToComboBox(cmbprovince, tcode); cmbprovince.SelectedValue = tcode_out.Substring(0, 2) + "0000"; townnameManage.LoadCityToComboBox(cmbdistrict, tcode_out.Substring(0, 2) + "0000", tcode_out.Substring(0, 4) + "00"); townnameManage.LoadTumbonToComboBox(cmbsubdistrict, tcode_out.Substring(0, 4) + "00", tcode_out); } catch { } } }
public void GetData(string id13) { DataRow dr = null; if (modes == "new") { if (!string.IsNullOrEmpty(id13)) { dr = dcore.GetSearchPerson(id13); } if (dr != null) { txtname.Text = dr["name"].ToString(); txtlname.Text = dr["sname"].ToString(); txtid13.Text = dr["id13"].ToString(); if (!string.IsNullOrEmpty(dr["yearin"].ToString())) { lblyearintext.Text = dr["yearin"].ToString(); } else { lblyearintext.Text = "-"; } if (!string.IsNullOrEmpty(dr["unit3"].ToString())) { lblunittext.Text = dr["unit3"].ToString(); } else { lblunittext.Text = "-"; } if (!string.IsNullOrEmpty(dr["oldyearin"].ToString())) { lbloldyearintext.Text = dr["oldyearin"].ToString(); } else { lbloldyearintext.Text = "-"; } txtaddress_old.Text = dr["ADDRESS"].ToString(); txtaddress_mu_old.Text = dr["ADDRESS_MU"].ToString(); txtaddress_soid_old.Text = dr["ADDRESS_SOIL"].ToString(); txtaddress_road_old.Text = dr["ADDRESS_ROAD"].ToString(); string tcode = dr["TOWNCODE"].ToString(); try { townnameManage_old.LoadProvinceToComboBox(cmbprovince_old, tcode); cmbprovince_old.SelectedValue = tcode.Substring(0, 2) + "0000"; townnameManage_old.LoadCityToComboBox(cmbdistrict_old, tcode.Substring(0, 2) + "0000", tcode.Substring(0, 4) + "00"); townnameManage_old.LoadTumbonToComboBox(cmbsub_district_old, tcode.Substring(0, 4) + "00", tcode); } catch { } } } else { if (!string.IsNullOrEmpty(id13)) { dr = dcore.GetSearchPeople(id13, "", ""); } if (dr != null) { if (!string.IsNullOrEmpty(dr["yearin"].ToString())) { lblyearintext.Text = dr["yearin"].ToString(); } else { lblyearintext.Text = "-"; } if (!string.IsNullOrEmpty(dr["unit3"].ToString())) { lblunittext.Text = dr["unit3"].ToString(); } else { lblunittext.Text = "-"; } if (!string.IsNullOrEmpty(dr["oldyearin"].ToString())) { lbloldyearintext.Text = dr["oldyearin"].ToString(); } else { lbloldyearintext.Text = "-"; } txtname.Text = dr["name"].ToString(); txtlname.Text = dr["sname"].ToString(); txtpeoole_name.Text = dr["people_name"].ToString(); txtpeople_lname.Text = dr["people_lname"].ToString(); txtid13.Text = dr["id13"].ToString(); txtaddress_old.Text = dr["address_in"].ToString(); txtaddress_mu_old.Text = dr["address_mu_in"].ToString(); txtaddress_soid_old.Text = dr["address_soid_in"].ToString(); txtaddress_road_old.Text = dr["address_road_in"].ToString(); if (dr["people_name"].ToString() != string.Empty || dr["people_lname"].ToString() != string.Empty) { cmbchengename.Checked = true; txtpeoole_name.Enabled = true; txtpeople_lname.Enabled = true; } else { cmbchengename.Checked = false; txtpeoole_name.Enabled = false; txtpeople_lname.Enabled = false; } string tcode = dr["towncode_in"].ToString(); try { townnameManage_old.LoadProvinceToComboBox(cmbprovince_old, tcode); cmbprovince_old.SelectedValue = tcode.Substring(0, 2) + "0000"; townnameManage_old.LoadCityToComboBox(cmbdistrict_old, tcode.Substring(0, 2) + "0000", tcode.Substring(0, 4) + "00"); townnameManage_old.LoadTumbonToComboBox(cmbsub_district_old, tcode.Substring(0, 4) + "00", tcode); } catch { } if (!string.IsNullOrEmpty(dr["in_date"].ToString())) { dp_indate.Value = Convert.ToDateTime(dr["in_date"]); } txtrank.Text = dr["rank"].ToString(); txtbooknumber.Text = dr["book_number"].ToString(); if (dr["status"].ToString() == "1") { chkout.Checked = false; chkout.Enabled = true; lblstatus.Text = "ย้ายเข้า"; } if (dr["status"].ToString() == "2" || dr["status"].ToString() == "3" || dr["status"].ToString() == "4" || dr["status"].ToString() == "5") { DataControls.LoadComboBoxData(cmbselect_out, DataDefinition.Getstatusmore(), "status_name", "status_id", dr["status"].ToString()); chkout.Checked = true; chkout.Enabled = true; lblstatus.Text = DataControls.GetSelectedTextComboBoxToString(cmbselect_out); lblstatus.ForeColor = Color.Red; panel_out.Visible = true; if (dr["out_date"].ToString() != "1/1/0544 0:00:00" && !string.IsNullOrEmpty(dr["out_date"].ToString())) { dp_outdate.Value = Convert.ToDateTime(dr["out_date"]); } // txtaddress.Text = dr["address_out"].ToString(); txtaddress_mu.Text = dr["address_mu_out"].ToString(); txtaddress_soid.Text = dr["address_soid_out"].ToString(); txtaddress_road.Text = dr["address_road_out"].ToString(); DataControls.LoadComboBoxData(cmbselectaddress, DataDefinition.GetUnitmoreTab(), "unit_name", "unit_id", dr["type_out"].ToString()); tcode = dr["towncode_out"].ToString(); try { townnameManage.LoadProvinceToComboBox(cmbprovince, tcode); cmbprovince.SelectedValue = tcode.Substring(0, 2) + "0000"; townnameManage.LoadCityToComboBox(cmbdistrict, tcode.Substring(0, 2) + "0000", tcode.Substring(0, 4) + "00"); townnameManage.LoadTumbonToComboBox(cmbsub_district, tcode.Substring(0, 4) + "00", tcode); } catch { } } } } }