void btnNonApprove_Click(object sender, EventArgs e)
{
if (MessageBox.Show("คุณไม่ต้องการอนุมัติเอกสาร : " + txtDocId.Text + " ใช่หรือไม่", "HRDOCS", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
using (ConfirmReject frm = new ConfirmReject())
{
frm.Text = "อนุมัติ";
if (ClassForm.ShowDialog(frm) == DialogResult.Yes)
{
if (con.State == ConnectionState.Open) con.Close();
con.Open();
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.Connection = con;
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(sqlCommand);
SqlTransaction tr = con.BeginTransaction();
sqlCommand.Transaction = tr;
if (txtDocId.Text != "")
{
try
{
sqlCommand.CommandText = string.Format(
@" UPDATE SPC_JN_CHANGHOLIDAYHD SET HEADAPPROVED = 2
,HEADAPPROVEDBY = '{0}'
,HEADAPPROVEDBYNAME = '{1}'
,HEADAPPROVEDDATE = convert(varchar, getdate(), 23)
,HEADAPPORVEREMARK = '{2}'
WHERE SPC_JN_CHANGHOLIDAYHD.DOCID = @DOCID
AND DOCSTAT = 1 "
, ClassCurUser.LogInEmplId
, ClassCurUser.LogInEmplName
, frm.Remark);
sqlCommand.Parameters.AddWithValue("@DOCID", txtDocId.Text);
sqlCommand.ExecuteNonQuery();
tr.Commit();
this.IsSaveOnce = true;
// MessageBox.Show("เอกสารเลขที่เอกสาร : " + txtDocId.Text + " ทำรายการเรียบร้อยแล้ว");
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
if (con.State == ConnectionState.Open) con.Close();
this.Close();
this.DialogResult = DialogResult.Yes;
}
}
}
}
}
void Btn_Reject_Click(object sender, EventArgs e)
{
if (MessageBox.Show("ต้องการไม่อนุมัติเอกสารนี้ ?", "HRDOCS", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
using (ConfirmReject frm = new ConfirmReject())
{
frm.Text = "ไม่อนุมัติ";
if (ClassForm.ShowDialog(frm) == DialogResult.Yes)
{
DataTable dataTable = new DataTable();
SqlTransaction INSTrans = null;
SqlConnection sqlConnectionINS = new SqlConnection(DatabaseConfig.ServerConStr);
INSTrans = null;
sqlConnectionINS.Open();
INSTrans = sqlConnectionINS.BeginTransaction();
#region UpdateModified
using (SqlCommand sqlCommand = new SqlCommand())
{
sqlCommand.Connection = sqlConnectionINS;
sqlCommand.CommandText = @"update SPC_CM_SHIFTHD set HRAPPROVED = 2 ,HRAPPORVEREMARK = @HRAPPORVEREMARK ,
HRAPPROVEDBY = @HRAPPROVEDBY ,HRAPPROVEDDATE = @HRAPPROVEDDATE
,HRAPPROVEDBYNAME = @HRAPPROVEDBYNAME
where SPC_CM_SHIFTHD.DSDOCNO = @DSDOCNO ";
sqlCommand.Transaction = INSTrans;
sqlCommand.Parameters.AddWithValue("@DSDOCNO", DSDOCNO);
sqlCommand.Parameters.AddWithValue("@HRAPPORVEREMARK", frm.Remark);
sqlCommand.Parameters.AddWithValue("@HRAPPROVEDBY", ClassCurUser.LogInEmplId);
sqlCommand.Parameters.AddWithValue("@HRAPPROVEDBYNAME", ClassCurUser.LogInEmplName);
sqlCommand.Parameters.AddWithValue("@HRAPPROVEDDATE", MyTime.GetDateTime());
sqlCommand.ExecuteNonQuery();
}
#endregion
#region Submit
INSTrans.Commit();
sqlConnectionINS.Close();
#endregion
this.DialogResult = DialogResult.Yes;
}
}
}
void ApproveDL()
{
if (MessageBox.Show("คุณต้องการบันทึกเอกสาร ?", "Confirm ", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
{
return;
}
using (ConfirmReject frm = new ConfirmReject())
{
frm.Text = "อนุมัติ";
if (ClassForm.ShowDialog(frm) == DialogResult.Yes)
{
if (con.State == ConnectionState.Open) con.Close();
con.Open();
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.Connection = con;
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(sqlCommand);
SqlTransaction tr = con.BeginTransaction();
sqlCommand.Transaction = tr;
if (lbl_DocId.Text != "")
{
try
{
sqlCommand.CommandText = string.Format(
@"UPDATE SPC_JN_CANCLEDOCHD SET HEADAPPROVED = '1'
,HEADAPPROVEDBY = @HEADAPPROVEDBY
,HEADAPPROVEDBYNAME = @HEADAPPROVEDBYNAME
,HEADAPPROVEDDATE = convert(varchar, getdate(), 23)
,HEADAPPORVEREMARK = '{0}'
WHERE DOCID = @DOCID
AND DOCSTAT = 1 ", frm.Remark);
sqlCommand.Parameters.AddWithValue("@DOCID", _docid);
sqlCommand.Parameters.AddWithValue("@HEADAPPROVEDBY", ClassCurUser.LogInEmplId);
sqlCommand.Parameters.AddWithValue("@HEADAPPROVEDBYNAME", ClassCurUser.LogInEmplName);
sqlCommand.ExecuteNonQuery();
tr.Commit();
this.IsSaveOnce = true;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
if (con.State == ConnectionState.Open) con.Close();
this.Close();
this.DialogResult = DialogResult.Yes;
}
}
}
}
}
