private void PublishResponseSetFocus(XElement publishElt)
{
if (publishElt.Attribute(Common.focusField) != null)
{
string field = publishElt.Attribute(Common.focusField).Value;
if (FixedContext != null)
{
if (field.StartsWith(FixedContext))
{
field = field.Remove(0, FixedContext.Length + 1);
}
}
if (Controls.Count(x => x.FieldId == field) != 0)
{
var control = Controls.First(x => x.FieldId == field) as Control;
if (control != null)
{
control.Focus();
}
}
else if (DataControls.ContainsKey(field))
{
var control = DataControls[field] as Control;
if (control != null)
{
control.Focus();
}
}
}
}
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();
}
}
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 { }
}
public selectlabel_test()
{
InitializeComponent();
dcore = new DataCoreLibrary();
DataControls.LoadComboBoxData(cmbunit, DataDefinition.GetUnitTab(), "UNITNAME", "REFNUM");
cmbunit.SelectedValue = 0;
}
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 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 { }
}
}
}
}
public navy_search(string id13, string name, string sname, string status, string mode)
{
dcore = new DataCoreLibrary();
InitializeComponent();
DataControls.LoadComboBoxData(cmbselectaddress, DataDefinition.GetUnitTab(), "unitname", "REFNUM");
if (!string.IsNullOrEmpty(txtid13.Text.Trim()))
{
id13 = txtid13.Text.Trim();
}
else if (!string.IsNullOrEmpty(id13))
{
txtid13.Text = id13;
}
if (!string.IsNullOrEmpty(txtname.Text.Trim()))
{
name = txtname.Text.Trim();
}
else if (!string.IsNullOrEmpty(name))
{
txtname.Text = name;
}
if (!string.IsNullOrEmpty(txtlname.Text.Trim()))
{
sname = txtlname.Text.Trim();
}
else if (!string.IsNullOrEmpty(sname))
{
txtlname.Text = sname;
}
mode_search = mode;
GetData(id13, name, sname, status);
}
public ReportAddressMore()
{
InitializeComponent();
dcore = new DataCoreLibrary();
DataControls.LoadComboBoxData(cmbselectaddress, DataDefinition.GetUnitTab(), "UNITNAME", "REFNUM");
}
public AddSubUnit()
{
dcore = new DataCoreLibrary();
townnameManage_old = new DataControls.TownnameTab();
InitializeComponent();
townnameManage_old.LoadProvinceToComboBox(cmbprovince_old, "");
DataControls.LoadComboBoxData(cmbUnit, DataDefinition.GetUnitmoreTab(), "unit_name", "unit_id");
}
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 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 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);
}
}
public MoveToAddressUnit(string id, string number)
{
report_number = number;
navyid = id;
dcore = new DataCoreLibrary();
townnameManage = new DataControls.TownnameTab();
InitializeComponent();
GetData(id);
DataControls.LoadComboBoxData(cmbUnit, DataDefinition.GetUnitmoreTab(), "unit_name", "unit_id");
}
protected override void OnInit(EventArgs e)
{
base.OnInit(e);
// Initialize the collection
DataControls.Initialize();
// Subscribe to the Page's Init to register the controls set in the DataControls collection
Page.Init += OnPageInit;
}
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 LoadControlsValue()
{
if (cbbArmtown.DataSource == null)
{
DataControls.LoadComboBoxData(cbbArmtown, DataDefinition.GetArmtownTab(), "ARMNAME", "ARMID");
}
if (cbbOrigin.DataSource == null)
{
DataControls.LoadComboBoxData(cbbOrigin, DataDefinition.GetOriginTab(), "origin", "origincode", "1");
}
}
public ProcessPersonCardForm()
{
InitializeComponent();
searchPersonNivyInputControl1.SearchButtonClick += new EventHandler(SearchPersonNivy_ButtonSubmitClick);
DataControls.LoadComboBoxData(cbbArmtown, DataDefinition.GetArmtownTab(), "ARMNAME", "ARMID");
dcoreSearch = new DataCoreLibrary(System.Configuration.ConfigurationManager.ConnectionStrings["midb"].ConnectionString);
dcoreSave = new DataCoreLibrary();
tableImages.Columns.Add("no", typeof(int));
tableImages.Columns.Add("name", typeof(string));
tableImages.Columns.Add("size", typeof(string));
}
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;
}
}
}
public void LoadControlsValue()
{
cbb.Items.Clear();
cbb.SelectedIndex = -1;
switch (mode)
{
case "addictive": {
DataControls.LoadComboBoxData(cbb, DataDefinition.GetAddictive_Status(), "addname", "addcode", "");
lblText.Text = "กลุ่ม";
} break;
default: {
DataControls.LoadComboBoxData(cbb, DataDefinition.Getkptclass(), "kptclass", "kptcode", "");
lblText.Text = "หลักสูตร";
} break;
}
lblcountkptclass.Text = "";
lblcountsearch.Text = "";
}
public SearchPersonForm()
{
InitializeComponent();
mtxtYearin.Focus();
mtxtYearin.SelectAll();
mTextBoxID8.SelectAll();
textBoxID13.SelectAll();
textBoxRunNum.SelectAll();
textBoxName.SelectAll();
textBoxSname.SelectAll();
cbbCompany.SelectAll();
cbbBatt.SelectAll();
setBattCompanyValue();
AddEnterKeyDown();
btnNextPage.Enabled = false;
btnPrevPage.Enabled = false;
GVsSetAutoSizeColumns();
pgroup = PersonGroups.Prepare;
DataControls.LoadComboBoxData(cbbProvince, DataDefinition.GetArmtownTab(), "ARMNAME", "ARMID");
}
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");
}
/// <summary>
/// This is kind of a hack to work around the issue in Silverlight where you don't know when
/// all the controls have been loaded in a page (so you can *then* make a call to the server).
/// All the XAML pages are parsed when the application is loaded to extract the expanz controls,
/// and here we'll register them *before* they are actually loaded so that requests can be made
/// to the server, and then these entries will be updated with the actual control references
/// when the controls are actually loaded.
/// </summary>
internal void RegisterUnloadedControls(List <ExpanzControlDetails> expanzControls)
{
var controlsToRegister = expanzControls.Where(x => x.IsDataControl);
foreach (ExpanzControlDetails controlDetails in controlsToRegister)
{
if (controlDetails.DataId != null && !DataControls.ContainsKey(controlDetails.DataId))
{
DataControls.Add(controlDetails.DataId, controlDetails); // Add temporary dummy entry
}
}
controlsToRegister = expanzControls.Where(x => x.IsMediaControl);
foreach (ExpanzControlDetails controlDetails in controlsToRegister)
{
if (controlDetails.DataId != null && !DataControls.ContainsKey(controlDetails.DataId))
{
MediaControls.Add(controlDetails.DataId, controlDetails); // Add temporary dummy entry
}
}
}
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 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 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 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;
}
public ReportBC()
{
rcore = new ReportCoreLibrary();
InitializeComponent();
DataControls.LoadComboBoxData(cmbprovince, DataDefinition.GetArmtownTab(), "ARMNAME", "ARMID");
}
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("ออกรายงานสำเร็จ");
}
