protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
GridViewRow gvRow = null;
HiddenField hddloan_id = null;
switch (e.CommandName)
{
case "Pass":
case "Restore":
gvRow = GridView1.Rows[Helper.CInt(e.CommandArgument) - 1];
hddloan_id = (HiddenField)gvRow.FindControl("hddloan_id");
break;
default:
break;
}
cefLoan objefLoan = new cefLoan();
switch (e.CommandName)
{
case "Pass":
try
{
if (objefLoan.SP_LOAN_HEAD_PASS(Helper.CInt(hddloan_id.Value)))
{
BindGridView(0);
}
}
catch (Exception ex)
{
lblError.Text = ex.Message.ToString();
}
finally
{
objefLoan.Dispose();
}
break;
case "Restore":
try
{
if (objefLoan.SP_LOAN_HEAD_RESTORE(Helper.CInt(hddloan_id.Value)))
{
BindGridView(0);
}
}
catch (Exception ex)
{
lblError.Text = ex.Message.ToString();
}
finally
{
objefLoan.Dispose();
}
break;
default:
break;
}
}
private bool saveData()
{
bool blnResult = false;
int intopen_detail_approve_id = 0;
int intopen_head_id = 0;
string strApproveNote = string.Empty;
string strUserName = string.Empty;
string strApprove_status = "P";
cefOpen objEfOpen = new cefOpen();
cefLoan objEfLoan = new cefLoan();
try
{
#region set Data
strUserName = Session["username"].ToString();
intopen_detail_approve_id = Helper.CInt(ViewState["open_detail_approve_id"]);
strApproveNote = txtapprove_note.Text;
strApprove_status = cboApprove_status.SelectedValue;
intopen_head_id = Helper.CInt(ViewState["open_head_id"]);
#endregion
#region update
if (ViewState["type"].ToString() == "open")
{
if (objEfOpen.SP_OPEN_DETAIL_APPROVE_EDIT(intopen_detail_approve_id, strApproveNote,
strApprove_status, strUserName))
{
objEfOpen.SP_OPEN_HEAD_APPROVE_UPD(intopen_head_id, strUserName);
blnResult = true;
}
}
else
{
if (objEfLoan.SP_LOAN_DETAIL_APPROVE_EDIT(intopen_detail_approve_id, strApproveNote,
strApprove_status, strUserName))
{
objEfLoan.SP_LOAN_HEAD_APPROVE_UPD(intopen_head_id, strUserName);
blnResult = true;
}
}
#endregion
}
catch (Exception ex)
{
lblError.Text = ex.Message.ToString();
}
finally
{
objEfOpen.Dispose();
}
return(blnResult);
}
protected void PrintData02()
{
string strCriteria = string.Empty;
string strScript = string.Empty;
strCriteria = " And loan_id =" + ViewState["loan_id"];
cefLoan objcEfLoan = new cefLoan();
DataTable dt;
dt = objcEfLoan.SP_LOAN_HEAD_SEL(strCriteria);
if (dt.Rows.Count > 0)
{
Session["criteria"] = strCriteria;
strScript = "window.open(\"../reportsparameter/open_report_show.aspx?report_code=Rep_loan02&loan_id=" + ViewState["loan_id"] + "&person_code=" +
dt.Rows[0]["person_code"] + "\", \"_blank\");\n";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "OpenPage", strScript, true);
}
else
{
strScript = "alert('ไม่พบข้อมูล โปรดตรวจสอบ');";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "OpenPage", strScript, true);
}
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
var hddloan_id = (HiddenField)GridView1.Rows[e.RowIndex].FindControl("hddloan_id");
var objEfLoan = new cefLoan();
try
{
//if (objEfLoan.SP_LOAN_APPROVE_ALL_DEL(Helper.CInt(hddloan_id.Value)) &&
// objEfLoan.SP_LOAN_DETAIL_ALL_DEL(Helper.CInt(hddloan_id.Value)) &&
if (objEfLoan.SP_LOAN_HEAD_DEL(Helper.CInt(hddloan_id.Value)))
{
BindGridView(0);
}
}
catch (Exception ex)
{
lblError.Text = ex.Message;
}
finally
{
objEfLoan.Dispose();
}
}
private void setData()
{
cefOpen opjEfOpen = new cefOpen();
cefLoan opjEfLoan = new cefLoan();
DataTable dt = new DataTable();
try
{
if (ViewState["mode"].ToString() == "view")
{
imgSaveOnly.Visible = false;
txtapprove_note.ReadOnly = true;
txtapprove_note.CssClass = "textboxdis";
cboApprove_status.Enabled = false;
cboApprove_status.CssClass = "textboxdis";
}
if (ViewState["type"].ToString() == "open")
{
lblopen.Text = "รายการขออนุมัติเบิก :";
lblperson_open_tile.Text = "ผู้ขออนุมัติเบิก :";
_strCriteria = " and open_detail_approve_id= " + ViewState["open_detail_approve_id"].ToString();
dt = opjEfOpen.SP_OPEN_DETAIL_APPROVE_SEL(_strCriteria);
if (dt.Rows.Count > 0)
{
#region get Data
lblopen_title.Text = Helper.CStr(dt.Rows[0]["open_title"]);
lblapprove_person.Text = Helper.CStr(dt.Rows[0]["title_name"]) +
Helper.CStr(dt.Rows[0]["person_thai_name"]) + " " +
Helper.CStr(dt.Rows[0]["person_thai_surname"]);
lblperson_open_name.Text = Helper.CStr(dt.Rows[0]["req_title_name"]) +
Helper.CStr(dt.Rows[0]["req_person_thai_name"]) + " " +
Helper.CStr(dt.Rows[0]["req_person_thai_surname"]);
ViewState["open_head_id"] = dt.Rows[0]["open_head_id"].ToString();
if (cboApprove_status.Items.FindByValue(dt.Rows[0]["approve_status"].ToString()) != null)
{
cboApprove_status.SelectedIndex = -1;
cboApprove_status.Items.FindByValue(dt.Rows[0]["approve_status"].ToString()).Selected = true;
}
txtapprove_note.Text = dt.Rows[0]["approve_note"].ToString();
#endregion
}
}
else
{
lblopen.Text = "รายละเอียดสัญญายืมเงิน :";
lblperson_open_tile.Text = "ผู้ขอยืมเงิน :";
_strCriteria = " and loan_detail_approve_id= " + ViewState["open_detail_approve_id"];
dt = opjEfLoan.SP_LOAN_DETAIL_APPROVE_SEL(_strCriteria);
if (dt.Rows.Count > 0)
{
#region get Data
lblopen_title.Text = Helper.CStr(dt.Rows[0]["loan_reason"]);
lblapprove_person.Text = Helper.CStr(dt.Rows[0]["title_name"]) +
Helper.CStr(dt.Rows[0]["person_thai_name"]) + " " +
Helper.CStr(dt.Rows[0]["person_thai_surname"]);
lblperson_open_name.Text = Helper.CStr(dt.Rows[0]["req_title_name"]) +
Helper.CStr(dt.Rows[0]["req_person_thai_name"]) + " " +
Helper.CStr(dt.Rows[0]["req_person_thai_surname"]);
ViewState["open_head_id"] = dt.Rows[0]["loan_id"].ToString();
if (cboApprove_status.Items.FindByValue(dt.Rows[0]["approve_status"].ToString()) != null)
{
cboApprove_status.SelectedIndex = -1;
cboApprove_status.Items.FindByValue(dt.Rows[0]["approve_status"].ToString()).Selected = true;
}
txtapprove_note.Text = dt.Rows[0]["approve_note"].ToString();
#endregion
}
}
}
catch (Exception ex)
{
lblError.Text = ex.Message.ToString();
}
}
private void BindGridView()
{
var objEfLoan = new cefLoan();
var dt = new DataTable();
string strMessage = string.Empty;
string strCriteria = string.Empty;
string strloan_doc = string.Empty;
string strloan_reason = string.Empty;
string strperson_code = string.Empty;
string strperson_name = string.Empty;
string strScript = string.Empty;
strloan_doc = txtloan_doc.Text.Replace("'", "''").Trim();
strloan_reason = txtloan_reason.Text.Replace("'", "''").Trim();
strperson_code = txtperson_code.Text.Replace("'", "''").Trim();
strperson_name = txtperson_name.Text.Replace("'", "''").Trim();
if (!strloan_doc.Equals(""))
{
strCriteria += " And (loan_doc like '%" + strloan_doc + "%') ";
}
if (!strloan_reason.Equals(""))
{
strCriteria += " And (loan_reason like '%" + strloan_reason + "%') ";
}
if (!strperson_code.Equals(""))
{
strCriteria = strCriteria + " And (person_code= '" + strperson_code + "') ";
}
if (!strperson_name.Equals(""))
{
strCriteria = strCriteria + " And (person_thai_name like '%" + strperson_name + "%' " +
" OR person_thai_surname like '%" + strperson_name + "%' " +
" OR '" + strperson_name + "' like ('%'+person_thai_name+'%'+person_thai_surname+'%')) ";
}
if (ViewState["loan_doc_list"].ToString().Length > 0)
{
strCriteria = strCriteria + " And loan_doc not in (" + ViewState["loan_doc_list"] + ") ";
}
try
{
dt = objEfLoan.SP_LOAN_HEAD_SEL(strCriteria);
//if (dt.Rows.Count == 1)
//{
// string strloan_id = dt.Rows[0]["loan_id"].ToString();
// strloan_doc = dt.Rows[0]["loan_doc"].ToString();
// strloan_reason = dt.Rows[0]["loan_reason"].ToString();
// string strloan_date = cCommon.CheckDate(dt.Rows[0]["loan_date"].ToString());
// string strloan_req = Helper.CDbl(dt.Rows[0]["loan_req"].ToString()).ToString("N2");
// if (!ViewState["show"].ToString().Equals("1"))
// {
// strScript = "window.parent.frames['iframeShow" + (int.Parse(ViewState["show"].ToString()) - 1) + "'].document.getElementById('" + ViewState["ctrl1"] + "').value='" + strloan_id + "';\n " +
// "window.parent.frames['iframeShow" + (int.Parse(ViewState["show"].ToString()) - 1) + "'].document.getElementById('" + ViewState["ctrl2"] + "').value='" + strloan_doc + "';\n" +
// "window.parent.frames['iframeShow" + (int.Parse(ViewState["show"].ToString()) - 1) + "'].document.getElementById('" + ViewState["ctrl3"] + "').value='" + strloan_reason + "';\n" +
// "window.parent.frames['iframeShow" + (int.Parse(ViewState["show"].ToString()) - 1) + "'].document.getElementById('" + ViewState["ctrl4"] + "').value='" + strloan_date + "';\n" +
// "window.parent.frames['iframeShow" + (int.Parse(ViewState["show"].ToString()) - 1) + "'].document.getElementById('" + ViewState["ctrl5"] + "').value='" + strloan_req + "';\n" +
// "ClosePopUp('" + ViewState["show"] + "');";
// if (ViewState["from"].ToString() == "open_control")
// {
// strScript += "window.parent.frames['iframeShow" + (int.Parse(ViewState["show"].ToString()) - 1) + "'].__doPostBack('ctl00$ContentPlaceHolder1$lbkGetOpen','');";
// }
// }
// else
// {
// strScript = "window.parent.document.getElementById('" + ViewState["ctrl1"] + "').value='" + strloan_id + "';\n " +
// "window.parent.document.getElementById('" + ViewState["ctrl2"] + "').value='" + strloan_doc + "';\n" +
// "window.parent.document.getElementById('" + ViewState["ctrl3"] + "').value='" + strloan_reason + "';\n" +
// "window.parent.document.getElementById('" + ViewState["ctrl4"] + "').value='" + strloan_date + "';\n" +
// "window.parent.document.getElementById('" + ViewState["ctrl5"] + "').value='" + strloan_req + "';\n" +
// "ClosePopUp('" + ViewState["show"] + "');";
// }
// ScriptManager.RegisterStartupScript(Page, Page.GetType(), "close", strScript, true);
//}
//else
//{
// dt.DefaultView.Sort = ViewState["sort"] + " " + ViewState["direction"];
// GridView1.DataSource = dt;
// GridView1.DataBind();
//}
dt.DefaultView.Sort = ViewState["sort"] + " " + ViewState["direction"];
GridView1.DataSource = dt;
GridView1.DataBind();
}
catch (Exception ex)
{
lblError.Text = ex.Message;
}
finally
{
objEfLoan.Dispose();
}
}
private void BindGridView(int nPageNo)
{
//InitcboYear();
cefLoan objEfLoan = new cefLoan();
DataTable dt = new DataTable();
string strCriteria = string.Empty;
string strloan_doc = string.Empty;
string strbudget_plan_year = string.Empty;
string strloan_reason = string.Empty;
string strbudget_code = string.Empty;
string strunit_code = string.Empty;
string strdirector_code = string.Empty;
string strbudget_type = string.Empty;
string strLoan_status = string.Empty;
string strperson_code = string.Empty;
string strperson_name = string.Empty;
string strScript = string.Empty;
#region Criteria
strloan_doc = txtloan_doc.Text;
strbudget_plan_year = cboYear.SelectedValue;
strdirector_code = cboDirector.SelectedValue;
strunit_code = cboUnit.SelectedValue;
strloan_reason = txtloan_reason.Text.Trim();
strbudget_type = cboBudget_type.SelectedValue;
strLoan_status = cboLoanStatus.SelectedValue;
strperson_name = txtperson_name.Text.Trim();
strperson_code = txtperson_code.Text.Trim();
var strbegin_date = txtfrom_date.Text.Length > 0 ? cCommon.SeekDate(txtfrom_date.Text) : "";
var strend_date = txtto_date.Text.Length > 0 ? cCommon.SeekDate(txtto_date.Text) : "";
if (!strbudget_plan_year.Equals(""))
{
strCriteria = strCriteria + " And (loan_year = '" + strbudget_plan_year + "') ";
}
if (!strbudget_type.Equals(""))
{
strCriteria = strCriteria + " And (budget_type = '" + strbudget_type + "') ";
}
if (!strloan_doc.Equals(""))
{
strCriteria = strCriteria + " And (loan_doc like '%" + strloan_doc + "%') ";
}
if (!strbudget_code.Equals(""))
{
strCriteria = strCriteria + " And (budget_code ='" + strbudget_code + "') ";
}
if (!strdirector_code.Equals(""))
{
strCriteria = strCriteria + " And (director_code ='" + strdirector_code + "') ";
}
if (!strunit_code.Equals(""))
{
strCriteria = strCriteria + " And (unit_code ='" + strunit_code + "') ";
}
if (!strloan_reason.Equals(""))
{
strCriteria = strCriteria + " And (loan_reason like '%" + strloan_reason + "%') ";
}
if (!strLoan_status.Equals(""))
{
strCriteria = strCriteria + " And (loan_status = '" + strLoan_status + "') ";
}
if (!strperson_code.Equals(""))
{
strCriteria = strCriteria + " And (person_code like '%" + strperson_code + "%') ";
}
if (!strperson_name.Equals(""))
{
strCriteria = strCriteria + " And (person_thai_name like '%" + strperson_name + "%' " +
" OR person_thai_surname like '%" + strperson_name + "%' " +
" OR '" + strperson_name + "' like ('%'+person_thai_name+'%'+person_thai_surname+'%')) ";
}
if (!strbegin_date.Equals(""))
{
strCriteria += " And (loan_date >= '" + strbegin_date + "') ";
}
if (!strend_date.Equals(""))
{
strCriteria += " And (loan_date <= '" + strend_date + "') ";
}
if (base.UserGroupCode == "User" || base.UserGroupCode == "Supervisor")
{
strCriteria += " and person_code IN ('" + base.PersonCode + "','" + base.ApproveFor + "')";
}
#endregion
//strCriteria = strCriteria + " and budget_type ='" + this.BudgetType + "' ";
try
{
dt = objEfLoan.SP_LOAN_HEAD_SEL(strCriteria);
try
{
GridView1.PageIndex = nPageNo;
txthTotalRecord.Value = dt.Rows.Count.ToString();
dt.DefaultView.Sort = ViewState["sort"] + " " + ViewState["direction"];
GridView1.DataSource = dt;
GridView1.DataBind();
}
catch
{
GridView1.PageIndex = 0;
txthTotalRecord.Value = dt.Rows.Count.ToString();
dt.DefaultView.Sort = ViewState["sort"] + " " + ViewState["direction"];
GridView1.DataSource = dt;
GridView1.DataBind();
}
}
catch (Exception ex)
{
lblError.Text = ex.Message;
}
finally
{
objEfLoan.Dispose();
if (GridView1.Rows.Count > 0)
{
GridView1.TopPagerRow.Visible = true;
}
}
}
