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;
}
}
