private void Search(DataGridView dgv)
{
var watch = Stopwatch.StartNew();
try
{
paramSearch = new ParamSearchPerson();
paramSearch.name = textBoxName.Text;
paramSearch.sname = textBoxSname.Text;
paramSearch.id8 = mTextBoxID8.Text;
paramSearch.id13 = textBoxID13.Text;
paramSearch.yearin = mtxtYearin.Text;
paramSearch.runcode = textBoxRunNum.Text.Trim();
paramSearch.company = cbbCompany.Text.Trim();
paramSearch.batt = cbbBatt.Text.Trim();
if (checkBoxSearchNivyAll.Checked)
{
personTable = dcore.GetSearchPersonTable("", paramSearch, itemsPerPage, page, out count);
dgv.DataSource = personTable;
}
else
{
//personTable = dcore.GetSearchPersonTable("", tempInput, itemsPerPage, page, out count);
personNavyData = dcore.GetSearchPerson("", DataControls.GetSelectedValueComboBoxToString(cbbProvince), paramSearch, itemsPerPage, page, out count);
dgv.DataSource = personNavyData;
try
{
dgv.Columns["navyid"].Visible = false;
dgv.Columns["id13"].Visible = false;
}
catch { }
}
if (count <= itemsPerPage)
{
totalPage = Function.CalTotalPage(count, itemsPerPage);
labelCountSearchRecord.Text = Convert.ToString(count) + " Record(s)";
labelPaging.Text = page.ToString() + "/" + totalPage.ToString();
}
else
{
totalPage = Function.CalTotalPage(count, itemsPerPage);
labelCountSearchRecord.Text = Convert.ToString((page * itemsPerPage) - itemsPerPage + 1) + " - " + Convert.ToString(page * itemsPerPage) + " of " + Convert.ToString(count) + " Record(s)";
labelPaging.Text = page.ToString() + "/" + totalPage.ToString();
}
EnableButtonPage();
dgv.Focus();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
watch.Stop();
label8.Text = String.Format("{0}m {1}s {2}ms", watch.Elapsed.Minutes, watch.Elapsed.Seconds, watch.Elapsed.Milliseconds);
}
protected void ChangeFileNameAndMoveLocation()
{
DataTable dt = null;
int index = 0;
files = Directory.GetFiles(@"D:\ร้อยเตรียม\3x5", "*.jpg", SearchOption.AllDirectories);
dt = dcore.GetSearchPerson("5", "0", "0", "");
foreach (DataRow dr in dt.Rows)
{
File.Copy(files[index], @"D:\3.59.5\" + dr["navyid"].ToString() + ".jpg", true);
index++;
}
MessageBox.Show("Cpmplete");
}
private void Search(DataGridView dgv)
{
try
{
paramSearch = new ParamSearchPerson();
paramSearch.name = TxtBox_Name.Text;
paramSearch.sname = TxtBox_Sname.Text;
paramSearch.id8 = TxtBox_ID8.Text;
paramSearch.id13 = TxtBox_ID13.Text;
paramSearch.yearin = TxtBox_Yearin.Text;
if (chkBox_HaveIndictment.Checked)
{
personNavyData = dcore.GetSearchPersonOnlyIndictment("", "", paramSearch, itemsPerPage, page, out count);
dgv.DataSource = personNavyData;
}
else
{
personNavyData = dcore.GetSearchPerson("", "", paramSearch, itemsPerPage, page, out count);
dgv.DataSource = personNavyData;
}
//เลือกไม่แสดง Column
try
{
dgv.Columns["navyid"].Visible = false;
dgv.Columns["birthdate"].Visible = false;
dgv.Columns["oldyearin"].Visible = false;
}
catch { }
dgv.Focus();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void Search()
{
try
{
ParamSearchPerson param = new ParamSearchPerson();
param.name = textBoxName.Text;
param.sname = textBoxSname.Text;
param.id8 = mTextBoxID8.Text;
param.yearin = mtxtYearin.Text;
if (rbAddNew.Checked)
{
listPerson = dcoreNav.GetSearchPerson("", "", param);
}
else if (rbEditOrDelete.Checked)
{
listPerson = dcoreNavAll.GetSearchPerson("", "", param);
}
gvResult.DataSource = listPerson;
gvResult.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells;
try
{
gvResult.Columns["navyid"].Visible = false;
}
catch { }
count = listPerson.Count;
labelCountSearchRecord.Text = Convert.ToString(count) + " Record(s)";
gvResult.Focus();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
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 { }
}
}
}
}