private void btnSave_Click(object sender, EventArgs e) { if (ValidateData() == true) { DocTypePara para = new DocTypePara(); para.ID = Convert.ToInt64(txtID.Text); para.DOCTYPE_CODE = txtDocTypeCode.Text; para.DOCTYPE_NAME = txtDoctypeName.Text; DocTypeFunc fnc = new DocTypeFunc(); if (fnc.SaveDocType(para) == true) { getDocTypeAllList(); ClearForm(); MessageBox.Show("บันทึกข้อมูลเรียบร้อย"); txtDocTypeCode.Focus(); } else { MessageBox.Show(fnc.ErrorMessage); txtDocTypeCode.Focus(); txtDocTypeCode.SelectAll(); } } }
private void btnPrintBarcode_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); dt.Columns.Add("BARCODE"); dt.Columns.Add("DOCTYPE_NAME"); bool IsSelect = false; for (int i = 0; i < dgDocType.Rows.Count;i++ ) { if (dgDocType.Rows[i].Cells["colCheckBox"].Value == "Y") { IsSelect = true; DataRow dr = dt.NewRow(); DocTypeFunc fnc = new DocTypeFunc(); DocTypePara para = fnc.GetDocTypePara(Convert.ToInt64(dgDocType.Rows[i].Cells["colID"].Value.ToString()), null); dr["BARCODE"] = "*" + Config.BarcodeStartDigit + para.DOCTYPE_CODE + "*"; dr["DOCTYPE_NAME"] = para.DOCTYPE_CODE + " " + para.DOCTYPE_NAME; dt.Rows.Add(dr); } } if (IsSelect == false) { MessageBox.Show("กรุณาเลือกประเภทเอกสารที่ต้องการพิมพ์"); dgDocType.Focus(); return; } if (dt.Rows.Count > 0) { TableLogOnInfo logonInfo = new TableLogOnInfo(); logonInfo.ConnectionInfo.DatabaseName = Config.DbGetDbName; logonInfo.ConnectionInfo.ServerName = Config.DbGetDataSource; logonInfo.ConnectionInfo.UserID = Config.DbGetUserID; logonInfo.ConnectionInfo.Password = Config.DbGetPwd; crtPrintBarcode rpt = new crtPrintBarcode(); frmPrintPreview frm = new frmPrintPreview(); rpt.SetDataSource(dt); rpt.Database.Tables[0].ApplyLogOnInfo(logonInfo); frm.crystalReportViewer1.ReportSource = rpt; frm.StartPosition = FormStartPosition.CenterScreen; frm.WindowState = FormWindowState.Maximized; frm.Show(); } }
private void btnDel_Click(object sender, EventArgs e) { if (txtID.Text == "0") { MessageBox.Show("กรุณาเลือกรายการที่ต้องการลบ"); return; } DocTypeFunc fnc = new DocTypeFunc(); if (fnc.DeleteDocType(Convert.ToInt16(txtID.Text)) == true) { ClearForm(); getDocTypeAllList(); MessageBox.Show("ลบข้อมูลเรียบร้อย"); } else { MessageBox.Show(fnc.ErrorMessage); } }
private void gvDoctype_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { DataGridViewRow dgv = new DataGridViewRow(); dgv = gvDoctype.Rows[e.RowIndex]; DocTypeFunc fnc = new DocTypeFunc(); DocTypePara para = fnc.GetDocTypePara(Convert.ToInt64(dgv.Cells["colID"].Value), null); txtID.Text = para.ID.ToString(); txtDocTypeCode.Text = para.DOCTYPE_CODE; txtDoctypeName.Text = para.DOCTYPE_NAME; }
private void getDocTypeAllList() { DocTypeFunc fnc = new DocTypeFunc(); gvDoctype.AutoGenerateColumns = false; gvDoctype.DataSource = fnc.GetDocTypeAll(null); }
private bool ValidateData() { bool ret = true; if (txtDocTypeCode.Text.Trim() == "") { ret = false; MessageBox.Show("กรุณาระบุรหัสเอกสาร"); txtDocTypeCode.Focus(); }else if(txtDocTypeCode.Text.Length != Func.Utilities.Config.DocTypeCodeLength){ ret = false; MessageBox.Show("จำนวนหลักของรหัสเอกสารไม่ถูกต้อง"); txtDocTypeCode.Focus(); txtDocTypeCode.SelectAll(); } else if (txtDoctypeName.Text.Trim() == "") { ret = false; MessageBox.Show("กรุณาระบุชื่อเอกสาร"); txtDoctypeName.Focus(); } else{ DocTypePara para = new DocTypePara(); para.ID = Convert.ToInt64(txtID.Text); para.DOCTYPE_CODE = txtDocTypeCode.Text.Trim(); para.DOCTYPE_NAME = txtDoctypeName.Text.Trim(); DocTypeFunc fnc = new DocTypeFunc(); if (fnc.ChkDupData(para) == true) { ret = false; MessageBox.Show(fnc.InfoMessage); txtDocTypeCode.Focus(); txtDocTypeCode.SelectAll(); } } return ret; }
private void txtDocTypeCode_TextChanged(object sender, EventArgs e) { DocTypePara para = new DocTypePara(); DocTypeFunc fnc = new DocTypeFunc(); para = fnc.GetDocTypeByDocTypeCode(txtDocTypeCode.Text.Trim()); txtDocTypeName.Text = para.DOCTYPE_NAME; }
private void SetDoctypeList() { DocTypeFunc fnc = new DocTypeFunc(); DataTable dt = fnc.GetDocTypeAll(null); if (dt.Rows.Count > 0) { dgDocType.AutoGenerateColumns = false; dgDocType.DataSource = dt; } }