private void btncopy_Click(object sender, EventArgs e)
{
txtaddress.Text = txtaddress_old.Text;
txtaddress_mu.Text = txtaddress_mu_old.Text;
txtaddress_soid.Text = txtaddress_soid_old.Text;
txtaddress_road.Text = txtaddress_road_old.Text;
string tcode = string.Empty;
if (!string.IsNullOrEmpty(DataControls.GetSelectedValueComboBoxToString(cmbsub_district_old)))
{
tcode = DataControls.GetSelectedValueComboBoxToString(cmbsub_district_old);
}
else if (!string.IsNullOrEmpty(DataControls.GetSelectedValueComboBoxToString(cmbdistrict_old)))
{
tcode = DataControls.GetSelectedValueComboBoxToString(cmbdistrict_old);
}
else if (!string.IsNullOrEmpty(DataControls.GetSelectedValueComboBoxToString(cmbprovince_old)))
{
tcode = DataControls.GetSelectedValueComboBoxToString(cmbprovince_old);
}
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 { }
}
private void cmbUnit_SelectedIndexChanged(object sender, EventArgs e)
{
cmbSubUnit.DataSource = null;
object value = ((ComboBox)sender).SelectedValue;
if (value != null)
{
DataControls.LoadComboBoxData(cmbSubUnit, DataDefinition.GetSubUnitmoreTab(DataControls.GetSelectedValueComboBoxToString(cmbUnit)), "unit_name", "subunit_id");
DataRow dr = dcore.GetAddress(DataControls.GetSelectedValueComboBoxToString(cmbUnit));
if (dr != null)
{
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();
if (!string.IsNullOrEmpty(tcode))
{
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 { }
}
}
}
}
private void Search()
{
try
{
string armid = DataControls.GetSelectedValueComboBoxToString(cbbProvince);
DataTable dt = new DataTable();
pSD18 = new List <PersonSD18>();
string sql = query.reportPrintNewPerson(armid);
MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(sql, dcore.getConnection());
dcore.getConnection().Open();
using (MySql.Data.MySqlClient.MySqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
pSD18.Add(new PersonSD18(reader));
}
}
dt = Function.ConvertToDataTable <PersonSD18>(pSD18);
DisplayReport(dt);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
dcore.getConnection().Close();
}
}
protected void GetData()
{
string text = string.Empty;
string select = string.Empty;
personTable = dcore.GetTotalselectunit(DataControls.GetSelectedValueComboBoxToString(cmbunit), out count);
NlabelTable = dcore.GetNlabelInUnit(DataControls.GetSelectedValueComboBoxToString(cmbunit), out count);
SelectNlabelTable = dcore.GetNlabelInUnit("", out count);
foreach (DataRow dr in SelectNlabelTable.Rows)
{
select = select + dr["NLABEL"].ToString() + " ";
}
lblselectol.Text = select;
foreach (DataRow dr in NlabelTable.Rows)
{
text = text + dr["NLABEL"].ToString() + " ";
}
txtselect_number.Text = text;
lbltotal.Text = personTable.Rows.Count.ToString();
txtnummerperlabel.Text = string.Empty;
txtnumberlaber.Text = string.Empty;
}
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 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);
}
private void btnSave_Click(object sender, EventArgs e)
{
string newsubid = string.Empty;
string str = dcore.GetMaxSubUnit(DataControls.GetSelectedValueComboBoxToString(cmbUnit));
if (string.IsNullOrEmpty(str))
{
newsubid = DataControls.GetSelectedValueComboBoxToString(cmbUnit) + "01";
}
else
{
newsubid = DataControls.GetSelectedValueComboBoxToString(cmbUnit) + string.Format("{0:00}", Convert.ToInt32(str) + 1);
}
DataRow param = dcore.GetListAddress("").NewRow();
param["unit_id"] = DataControls.GetSelectedValueComboBoxToString(cmbUnit);
param["unit_name"] = txtsubunit.Text.Trim();
param["subunit_id"] = newsubid;
param["ADDRESS"] = txtaddress_old.Text.Trim();
param["ADDRESS_MU"] = txtaddress_mu_old.Text.Trim();
param["ADDRESS_SOIL"] = txtaddress_soid_old.Text.Trim();
param["ADDRESS_ROAD"] = txtaddress_road_old.Text.Trim();
param["level"] = "1";
string s = string.Empty;
if (!string.IsNullOrEmpty(DataControls.GetSelectedValueComboBoxToString(cmbsub_district_old)))
{
param["TOWNCODE"] = DataControls.GetSelectedValueComboBoxToString(cmbsub_district_old);
s = DataControls.GetSelectedValueComboBoxToString(cmbsub_district_old);
}
else if (!string.IsNullOrEmpty(DataControls.GetSelectedValueComboBoxToString(cmbdistrict_old)))
{
param["TOWNCODE"] = DataControls.GetSelectedValueComboBoxToString(cmbdistrict_old);
s = DataControls.GetSelectedValueComboBoxToString(cmbdistrict_old);
}
else if (!string.IsNullOrEmpty(DataControls.GetSelectedValueComboBoxToString(cmbprovince_old)))
{
param["TOWNCODE"] = DataControls.GetSelectedValueComboBoxToString(cmbprovince_old);
s = DataControls.GetSelectedValueComboBoxToString(cmbprovince_old);
}
//if (dcore.InsertSubunit(param))
//{
// MessageBox.Show("บันทึกสำเร็จ");
// this.Close();
//}
//else
//{
// MessageBox.Show("บันทึกผิดพลาด");
//}
}
private void cbbArmtown_SelectedIndexChanged(object sender, EventArgs e)
{
dtpComeDate.Value = dtpRegisDate.Value;
string value = DataControls.GetSelectedValueComboBoxToString(cbbArmtown);
if (DataDefinition.GetArmtownLegion(value) == "4")
{
dtpComeDate.Value = dtpRegisDate.Value.AddDays(1);
}
}
private bool updateDoc()
{
dcore = new DataCoreLibrary();
string cbbcode;
cbbcode = DataControls.GetSelectedValueComboBoxToString(cbb);
if (cbbcode != "" && cbbcode != null)
{
switch (mode)
{
case "addictive":
{
dcore.UpdateAddictive(navyid, cbbcode);
}
break;
default:
{
if (gvSearch.SelectedRows[0].Cells["คพท"].Value.ToString() != "")
{
DialogResult dialogResult = MessageBox.Show(
"พลฯ " + gvSearch.SelectedRows[0].Cells["ชื่อ"].Value.ToString()
+ " " + gvSearch.SelectedRows[0].Cells["นามสกุล"].Value.ToString()
+ " มีสาขาอาชีพ" + gvSearch.SelectedRows[0].Cells["คพท"].Value.ToString()
+ " ยืนยันการเปลี่ยนสาขาอาชีพหรือไม่?", "แจ้งเตือน", MessageBoxButtons.YesNo);
/*if (dialogResult == DialogResult.Yes)
* {
* updateDoc();
* }*/
if (dialogResult == DialogResult.No)
{
return(false);
}
}
dcore.UpdateKptclass(navyid, cbbcode);
}
break;
}
MessageBox.Show("เสร็จสิีน");
load();
txtname.Text = "";
txtsname.Text = "";
mtxtid8.Text = "";
txtname.Focus();
return(true);
}
else
{
MessageBox.Show("เลือกสาขาอาชีพก่อน");
cbb.Focus();
return(false);
}
}
private void btnclear_Click(object sender, EventArgs e)
{
if (MessageBox.Show("ต้องการล้างล้างข้อมูลหมายเลขฉลากใช่หรือไม่", "ล้างข้อมูล", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
dcoreUpdateUsedPerson = new DataCoreLibrary();
dcoreUpdateUsedPerson.ClearNLabelPerson(DataControls.GetSelectedValueComboBoxToString(cmbunit));
GetData();
MessageBox.Show("ล้างข้อมูลสำเร็จ", "ล้างข้อมูล", MessageBoxButtons.OK);
// System.Windows.Forms.Application.Exit();
}
else
{
this.Activate();
}
}
private void load()
{
string cbbcode;
if (cbb.SelectedIndex != -1)
{
dcore = new DataCoreLibrary();
if (cbb.Text.Trim() != "" && cbb.Text.Trim() != "System.Data.DataRowView")
{
cbbcode = DataControls.GetSelectedValueComboBoxToString(cbb);
switch (mode)
{
case "addictive":
{
dtUpdate = dcore.getaddictive(cbbcode, out count);
Set_dtColumnName(dtUpdate);
}
break;
default:
{
dtUpdate = dcore.getkptclass(cbbcode, out count);
Set_dtColumnName(dtUpdate);
}
break;
}
lblcountkptclass.Text = count.ToString() + " Record";
gvKptclass.DataSource = dtUpdate;
gvKptclass.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
gvKptclass.MultiSelect = false;
gvKptclass.ReadOnly = true;
for (int i = 0; i <= gvKptclass.Columns.Count - 1; i++)
{
int colw = gvKptclass.Columns[i].Width;
gvKptclass.Columns[i].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
}
}
else
{
cbbcode = null;
}
}
}
private void InitialControls()
{
//hide some value for lite mode
if (!Constants.fullMode)
{
label5.Visible = false;
tbRemark2.Visible = false;
////////////
label3.Visible = false;
cbbNUM.Visible = false;
////////////
tabControl1.Controls.Remove(tabPage2);
personShortDetailView1.HideDataForLiteMode();
}
//Load person detail
personShortDetailView1.InitialValue(personShortDetailData);
personShortDetailView1.Dock = DockStyle.Fill;
//Load data into ComboBox
if (cbbUnit.DataSource == null)
{
DataControls.LoadComboBoxData(cbbUnit, DataDefinition.GetUnitTab(), "UNITNAME", "REFNUM", personShortDetailData.request.unit);
}
if (cbbRequester1.DataSource == null)
{
DataControls.LoadComboBoxData(cbbRequester1, DataDefinition.GetAskByTab(), "ask", "ask", String.IsNullOrWhiteSpace(personShortDetailData.request.askby) ? "" : personShortDetailData.request.askby.Substring(0, 2));
}
//Load new copy data into ComboBox
if (cbbUnit2.DataSource == null)
{
DataControls.LoadComboBoxData(cbbUnit2, DataDefinition.GetUnitTab().Copy(), "UNITNAME", "REFNUM", personShortDetailData.person.unit3);
}
DataControls.LoadComboBoxData(cbbNUM, DataDefinition.GetAskByNUMTab(DataControls.GetSelectedValueComboBoxToString(cbbRequester1), personShortDetailData.person.yearin), "NUM", "NUM");
}
private void btnSubmit2_Click(object sender, EventArgs e)
{
try
{
bool isSuccess = dcore.UpdatePersonUnit3(personShortDetailData.person.navyid, DataControls.GetSelectedValueComboBoxToString(cbbUnit2));
if (isSuccess == true)
{
MessageBox.Show("แก้ไขข้อมูลสำเร็จ");
personShortDetailData = dcore.GetPersonRequestDetail(navyid);
InitialzeForm();
//this.Close();
}
else
{
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void button1_Click(object sender, EventArgs e)
{
ShowData();
rcore.ShowReportListPersonOut(mtxtYearin.Text, DataControls.GetSelectedValueComboBoxToString(cmbprovince), numBatt.Text.Trim(), numcompany.Text.Trim(), numP.Text.Trim(), numPseq.Text.Trim(), mid8.Text, chkoldyearin.Checked);
}
private void btnSave_Click(object sender, EventArgs e)
{
string str = txtselect_number.Text;
bool check = false;
arr = new string[] {};
int counts = 0;
arr = str.Trim().Split(' ');
for (int i = 0; i < arr.Length; i++)
{
if (arr[i].Trim() != "")
{
counts++;
}
}
arr_new = new string[counts];
counts = 0;
string textlabel = string.Empty;
string textNlabel = string.Empty;
for (int j = 0; j < arr.Length; j++)
{
if (arr[j].Trim() != "")
{
textlabel = arr[j];
NlabelNotInUnit = dcore.GetNlabelNotInUnit(DataControls.GetSelectedValueComboBoxToString(cmbunit), out count);
if (NlabelNotInUnit.Rows.Count > 0)
{
foreach (DataRow dr in NlabelNotInUnit.Rows)
{
if (textlabel.Equals(dr["NLABEL"].ToString()))
{
check = true;
textNlabel += textlabel + " ";
}
}
}
arr_new[counts] = textlabel;
counts++;
}
}
if (check)
{
MessageBox.Show("ฉลากหมายเลข" + textNlabel + "ถูกใช้งานไปแล้ว");
}
else if (ConverValuetoInt(txtnumberlaber.Text) != counts && counts != 0)
{
MessageBox.Show("กรุณากรอกหมายเลขฉลากให้เท่ากับจำนวนฉลาก");
}
else if (txtnummerperlabel.Text == string.Empty)
{
MessageBox.Show("กรุณากรอกจำนวนคนต่อฉลาก");
}
else if (txtnumberlaber.Text == string.Empty)
{
MessageBox.Show("กรุณากรอกจำนวนฉลาก");
}
else if (txtselect_number.Text == string.Empty)
{
MessageBox.Show("กรุณากรอกหมายเลขฉลาก");
}
else
{
UpdateNLabel();
GetData();
MessageBox.Show("บันทึกข้อมูลสำเร็จ");
}
counts = 0;
}
private void cbbRequester1_SelectedIndexChanged(object sender, EventArgs e)
{
DataControls.LoadComboBoxData(cbbNUM, DataDefinition.GetAskByNUMTab(DataControls.GetSelectedValueComboBoxToString(cbbRequester1), personShortDetailData.person.yearin), "NUM", "NUM");
cbbNUM.SelectedIndex = cbbNUM.Items.Count - 1;
}
private void cbbArmtown_SelectedIndexChanged(object sender, EventArgs e)
{
string path = Function.SelectProvinceDirectory(DataControls.GetSelectedValueComboBoxToString(cbbArmtown), Constants.ImagePath.PersonCardPreValidate);
GetAllImagePathInFolder(path);
}
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
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
int recodeperpage = 20;
Warning[] warnings;
string[] streamids;
string mimeType;
string encoding;
string filenameExtension;
//ถ้าไม่มี Folder ไว้เก็บข้อมูลที่ desktop จะสร้าง Folder นั้นขึ้นมาก่อน
string FilePathDesktopForOutputData = Environment.GetFolderPath(Environment.SpecialFolder.Desktop) + "//" + mtxtYearin.Text.Trim().Replace('/', '.');
if (!Directory.Exists(FilePathDesktopForOutputData))
{
Directory.CreateDirectory(FilePathDesktopForOutputData);
}
try
{
Reports.ReportDisplay f = new Reports.ReportDisplay();
DataTable dataSource = dcore.GetReportListAddressmore(mtxtYearin.Text.Trim(), DataControls.GetSelectedValueComboBoxToString(cmbselectaddress));
List <ReportParameter> reportParam = new List <ReportParameter>();
//reportParam.Add(new ReportParameter("unit_name", "test"));
reportViewer1.Reset();
if (dataSource.Rows.Count > 0)
{
while ((dataSource.Rows.Count % recodeperpage) > 20 || (dataSource.Rows.Count % recodeperpage) == 0)
{
recodeperpage--;
}
string str = string.Empty;
//Setup Report Value
string[] str1 = dpdateR.Text.Split(' ');
// ============== Export Image Checked =============
if (chkimage.Checked)
{
try
{
//Create Folder for image output
string FilePath = Environment.GetFolderPath(Environment.SpecialFolder.Desktop) + "//" + mtxtYearin.Text.Trim().Replace('/', '.') + "//" + DataControls.GetSelectedTextComboBoxToString(cmbselectaddress);
if (!Directory.Exists(FilePath))
{
Directory.CreateDirectory(FilePath);
}
else
{
System.IO.Directory.Delete(FilePath, true);
System.IO.Directory.CreateDirectory(FilePath);
}
//Copy Image file in to folder
foreach (DataRow dr in dataSource.Rows)
{
//string path = @"\\192.168.0.1\NavyImages\" + dr["YEARIN"].ToString().Replace('/', '.') + @"\" + dr["NAVYID"].ToString() + ".jpg";
//if (File.Exists(path))
//{
//
// System.IO.File.Copy(@"\\192.168.0.1\NavyImages\" + dr["YEARIN"].ToString().Replace('/', '.') + @"\" + dr["NAVYID"].ToString() + ".jpg"
// , Environment.GetFolderPath(Environment.SpecialFolder.Desktop) + @"//" + dr["unitname"].ToString() + @"//" + dr["NAME"].ToString() + " " + dr["SNAME"].ToString() + " " + dr["NAVYID"].ToString() + ".jpg", true);
// }
string path = @"\\192.168.0.1\NavyImages\" + dr["YEARIN"].ToString().Replace('/', '.') + @"\" + dr["NAVYID"].ToString() + ".jpg";
if (File.Exists(path))
{
{
System.IO.File.Copy(@"\\192.168.0.1\NavyImages\" + dr["YEARIN"].ToString().Replace('/', '.') + @"\" + dr["NAVYID"].ToString() + ".jpg"
, Environment.GetFolderPath(Environment.SpecialFolder.Desktop) + "//" + mtxtYearin.Text.Trim().Replace('/', '.') + "//" + dr["unitname"].ToString() + @"//" + dr["NAME"].ToString() + " " + dr["SNAME"].ToString() + " " + dr["NAVYID"].ToString() + ".jpg", true);
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
// ============== Export Report PDF Checked =============
if (chk.Checked)
{
// string str11 = dpdateR.Text.Replace("มีนาคม","มี.ค.");
if (checkBox1.Checked)
{
reportViewer1.LocalReport.ReportEmbeddedResource = "Navy.Reports.Report2.rdlc";
reportParam.Add(new ReportParameter("Title", string.Format("บัญชีรายชื่อทหารกองประจำการจัดแบ่งให้หน่วย {0}", DataControls.GetSelectedTextComboBoxToString(cmbselectaddress))));
reportParam.Add(new ReportParameter("date", string.Format("วันที่ส่งมอบ {0} {1} {2}", str1[0], ConvertM(str1[1]), (Convert.ToInt32(str1[2])) - 2500).ToString()));
reportParam.Add(new ReportParameter("TitleNotation", "หมายเหตุ"));
reportParam.Add(new ReportParameter("notationaddict", "ผลการคัดกรองสารเสพติด " +
"กลุ่ม 1 = ผู้ไม่เคยใช้สารเสพติด " +
"กลุ่ม 2 = กลุ่มเสี่ยง(เคยทดลอง) " +
"กลุ่ม 3 = กลุ่มผู้เสพ " +
"กลุ่ม 4 = กลุ่มผู้ติด"));
reportParam.Add(new ReportParameter("text", txttext.Text.Trim()));
reportParam.Add(new ReportParameter("rank", txtrank.Text.Trim()));
reportParam.Add(new ReportParameter("name", txtname.Text.Trim()));
reportParam.Add(new ReportParameter("position", txtposition.Text.Trim()));
reportParam.Add(new ReportParameter("day", dpday.Text.Trim()));
reportParam.Add(new ReportParameter("recodeperpage", recodeperpage.ToString()));
this.reportViewer1.LocalReport.SetParameters(reportParam);
}
else
{
reportViewer1.LocalReport.ReportEmbeddedResource = "Navy.Reports.Report2None.rdlc";
reportParam.Add(new ReportParameter("Title", string.Format("บัญชีรายชื่อทหารกองประจำการจัดแบ่งให้หน่วย {0}", DataControls.GetSelectedTextComboBoxToString(cmbselectaddress))));
reportParam.Add(new ReportParameter("date", string.Format("วันที่ส่งมอบ {0} {1} {2}", str1[0], ConvertM(str1[1]), (Convert.ToInt32(str1[2])) - 2500).ToString()));
reportParam.Add(new ReportParameter("TitleNotation", "หมายเหตุ"));
reportParam.Add(new ReportParameter("notationaddict", "ผลการคัดกรองสารเสพติด " +
"กลุ่ม 1 = ผู้ไม่เคยใช้สารเสพติด " +
"กลุ่ม 2 = กลุ่มเสี่ยง(เคยทดลอง) " +
"กลุ่ม 3 = กลุ่มผู้เสพ " +
"กลุ่ม 4 = กลุ่มผู้ติด"));
reportParam.Add(new ReportParameter("recodeperpage", recodeperpage.ToString()));
this.reportViewer1.LocalReport.SetParameters(reportParam);
}
reportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", dataSource));
byte[] bytes = reportViewer1.LocalReport.Render(
"PDF", null, out mimeType, out encoding, out filenameExtension,
out streamids, out warnings);
try
{
using (FileStream fs = new FileStream(Environment.GetFolderPath(Environment.SpecialFolder.Desktop) + "//" + mtxtYearin.Text.Trim().Replace('/', '.') + "//" + DataControls.GetSelectedTextComboBoxToString(cmbselectaddress) + ".pdf", FileMode.Create))
{
fs.Write(bytes, 0, bytes.Length);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
// reportViewer1.LocalReport.Refresh();
// reportViewer1.RefreshReport();
// ============== Export Excel Checked =============
if (chkexport.Checked)
{
Reports.ReportDisplay f1 = new Reports.ReportDisplay();
DataTable dataSource1 = dcore.GetReportExportToExcel(mtxtYearin.Text.Trim(), DataControls.GetSelectedValueComboBoxToString(cmbselectaddress));
List <ReportParameter> reportParam1 = new List <ReportParameter>();
//reportParam.Add(new ReportParameter("unit_name", "test"));
reportViewer1.Reset();
reportViewer1.LocalReport.ReportEmbeddedResource = "Navy.Reports.ExportToExcel.rdlc";
reportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", dataSource1));
Warning[] warningsE;
string[] streamidsE;
string mimeTypeE;
string encodingE;
string extensionE;
byte[] bytesE = reportViewer1.LocalReport.Render(
"Excel", null, out mimeTypeE, out encodingE,
out extensionE,
out streamidsE, out warningsE);
try
{
using (FileStream fs = new FileStream(Environment.GetFolderPath(Environment.SpecialFolder.Desktop) + "//" + mtxtYearin.Text.Trim().Replace('/', '.') + "//" + DataControls.GetSelectedTextComboBoxToString(cmbselectaddress) + ".xls", FileMode.Create))
{
fs.Write(bytesE, 0, bytesE.Length);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
//Reports.ReportDisplay f1 = new Reports.ReportDisplay();
//DataTable dataSource1 = dcore.GetReportExportToExcel(mtxtYearin.Text.Trim(), DataControls.GetSelectedValueComboBoxToString(cmbselectaddress));
//List<ReportParameter> reportParam1 = new List<ReportParameter>();
////reportParam.Add(new ReportParameter("unit_name", "test"));
//reportViewer1.Reset();
//reportViewer1.LocalReport.ReportEmbeddedResource = "Navy.Reports.ExportToExcel.rdlc";
//reportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", dataSource1));
//Warning[] warningsE;
//string[] streamidsE;
//string mimeTypeE;
//string encodingE;
//string extensionE;
//byte[] bytesE = reportViewer1.LocalReport.Render(
// "Excel", null, out mimeTypeE, out encodingE,
// out extensionE,
// out streamidsE, out warningsE);
//try
//{
// using (FileStream fs = new FileStream(Environment.GetFolderPath(Environment.SpecialFolder.Desktop) + "//" + DataControls.GetSelectedTextComboBoxToString(cmbselectaddress) + ".xls", FileMode.Create))
// {
// fs.Write(bytesE, 0, bytesE.Length);
// }
// MessageBox.Show("สร้าง Excel สำเร็จ");
// }
//catch (Exception ex)
//{
// MessageBox.Show(ex.Message.ToString());
//}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
MessageBox.Show("ออกรายงานสำเร็จ");
}
public void GetData(string id13, string name, string sname, string status)
{
if (string.IsNullOrEmpty(id13) && string.IsNullOrEmpty(name) && string.IsNullOrEmpty(sname) && string.IsNullOrEmpty(status) &&
string.IsNullOrEmpty(txtbook_number.Text) && string.IsNullOrEmpty(txtrank.Text) && mtxtYearin.Text.Equals(" /") && !chkmove_in.Checked && string.IsNullOrEmpty(DataControls.GetSelectedValueComboBoxToString(cmbselectaddress)))
{
// grdData.DataSource = dcore.GetSearchPerson(id13, name, sname, status, mode_search);
}
else
{
switch (mode_search)
{
case "new":
// grdData.DataSource = dcore.GetSearchPerson(id13, name, sname, status, mode_search);
grdData.DataSource = dcore.GetSearchListPreAddressmore(txtname.Text, txtlname.Text, "", txtbook_number.Text, txtrank.Text, id13, mtxtYearin.Text, chkmove_in.Checked, DataControls.GetSelectedValueComboBoxToString(cmbselectaddress));
lblcount.Text = string.Format("{0} {1}", grdData.RowCount, "Record");
break;
case "edit":
// if (!(string.IsNullOrEmpty(id13) && string.IsNullOrEmpty(name) && string.IsNullOrEmpty(sname)))
// {
// grdData.DataSource = dcore.GetSearchPerson(id13, name, sname, status, mode_search);
// }
grdData.DataSource = dcore.GetSearchListPreAddressmore(txtname.Text, txtlname.Text, "", txtbook_number.Text, txtrank.Text, id13, mtxtYearin.Text, chkmove_in.Checked, DataControls.GetSelectedValueComboBoxToString(cmbselectaddress));
lblcount.Text = string.Format("{0:0,0} {1}", grdData.RowCount, "Record");
break;
}
DataGridViewCellStyle columnHeaderStyle = new DataGridViewCellStyle();
columnHeaderStyle.BackColor = Color.Beige;
columnHeaderStyle.Font = new Font("Bookman Old Style", 8, FontStyle.Bold);
grdData.ColumnHeadersDefaultCellStyle = columnHeaderStyle;
grdData.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
grdData.Columns[0].HeaderText = "ชื่อ";
grdData.Columns[1].HeaderText = "สกุล";
grdData.Columns[2].HeaderText = "NAVYID";
grdData.Columns[3].HeaderText = "ผลัด";
grdData.Columns[4].HeaderText = "ทะเบียน";
grdData.Columns[5].HeaderText = "หน่วย";
grdData.Columns[6].HeaderText = "สถานะ";
grdData.Columns[7].HeaderText = "ครั้งที่พิมพ์";
grdData.Columns[8].HeaderText = "ID13";
grdData.Columns[9].HeaderText = "เล่มที่";
grdData.Columns[10].HeaderText = "ลำดับที่";
//if (grdData.Rows.Count == 1 && (mode_search == "new" || mode_search == "out"))
//{
// MessageBox.Show("ไม่มีข้อมูล");
// this.Close();
//}
}
txtname.Focus();
mtxtYearin.SelectAll();
txtname.SelectAll();
txtlname.SelectAll();
txtid13.SelectAll();
txtrank.SelectAll();
txtbook_number.SelectAll();
}
private void Search(MyControls.GridviewResultControl dgv)
{
var watch = Stopwatch.StartNew();
try
{
paramSearch = new ParamSearchPerson();
paramSearch.name = textBoxName.Text;
paramSearch.sname = textBoxSname.Text;
paramSearch.id8 = mTextBoxID8.Text;
paramSearch.yearin = mtxtYearin.Text;
paramSearch.id13 = textBoxID13.Text;
paramSearch.runcode = textBoxRunNum.Text.Trim();
if (checkBoxSearchNivyAll.Checked)
{
if (dgv.EnablePagingData)
{
personTable = dcore.GetSearchPersonTable("", paramSearch, dgv.itemsPerPage, dgv.page, out dgv.count);
dgv.BindDataToGridView(personTable);
dgv.ConfigButtonPage();
}
else
{
personTable = dcore.GetSearchPersonTable("", paramSearch, out dgv.count);
dgv.BindDataToGridView(personTable);
}
}
else
{
if (dgv.EnablePagingData)
{
personNavyData = dcore.GetSearchPerson("", DataControls.GetSelectedValueComboBoxToString(cbbProvince), paramSearch, dgv.itemsPerPage, dgv.page, out dgv.count);
dgv.BindDataToGridView(Function.ConvertToDataTable <PersonSearch>(personNavyData));
dgv.BindDataPaging(dgv.page);
dgv.ConfigButtonPage();
}
else
{
personNavyData = dcore.GetSearchPerson("", DataControls.GetSelectedValueComboBoxToString(cbbProvince), paramSearch);
dgv.count = personNavyData.Count;
dgv.BindDataToGridView(Function.ConvertToDataTable <PersonSearch>(personNavyData));
}
try
{
dgv.Columns["navyid"].Visible = false;
dgv.Columns["id13"].Visible = false;
}
catch { }
}
dgv.CalculatePaging();
dgv.Refresh();
dgv.Focus();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
watch.Stop();
dgv.LbTimeExecute.Text = String.Format("{0}m {1}s {2}ms", watch.Elapsed.Minutes, watch.Elapsed.Seconds, watch.Elapsed.Milliseconds);
}