protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string strMessage = string.Empty;
string strCheck = string.Empty;
string strScript = string.Empty;
string strUpdatedBy = Session["username"].ToString();
Label lblactivity_code = (Label)GridView1.Rows[e.RowIndex].FindControl("lblactivity_code");
cActivity oactivity = new cActivity();
try
{
if (!oactivity.SP_DEL_ACTIVITY(lblactivity_code.Text, "N", strUpdatedBy, ref strMessage))
{
lblError.Text = strMessage;
}
else
{
string strScript1 = "RefreshMain('" + ViewState["page"].ToString() + "');";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "OpenPage", strScript1, true);
}
}
catch (Exception ex)
{
lblError.Text = ex.Message.ToString();
}
finally
{
oactivity.Dispose();
}
BindGridView();
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string strMessage = string.Empty;
string strCheck = string.Empty;
string strScript = string.Empty;
string strUpdatedBy = Session["username"].ToString();
Label lblactivity_code = (Label)GridView1.Rows[e.RowIndex].FindControl("lblactivity_code");
cActivity oactivity = new cActivity();
try
{
if (!oactivity.SP_DEL_ACTIVITY(lblactivity_code.Text, "N", strUpdatedBy, ref strMessage))
{
lblError.Text = strMessage;
}
}
catch (Exception ex)
{
lblError.Text = ex.Message.ToString();
}
finally
{
oactivity.Dispose();
}
BindGridView(0);
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string strMessage = string.Empty;
string strCheck = string.Empty;
string strScript = string.Empty;
string strUpdatedBy = Session["username"].ToString();
Label lblactivity_code = (Label)GridView1.Rows[e.RowIndex].FindControl("lblactivity_code");
cActivity oactivity = new cActivity();
try
{
if (!oactivity.SP_DEL_ACTIVITY(lblactivity_code.Text, "N", strUpdatedBy, ref strMessage))
{
lblError.Text = strMessage;
}
}
catch (Exception ex)
{
if (ex.Message.Contains("REFERENCE constraint"))
{
MsgBox("ไม่สามารถลบข้อมูลได้เนื่องจากมีการนำไปใช้ในระบบแล้ว");
}
else
{
lblError.Text = ex.Message.ToString();
}
}
finally
{
oactivity.Dispose();
}
BindGridView(0);
}
/// <summary>
/// Creates a cActivity object. It will be saved in permanent storage only
/// on calling Save()
/// </summary>
/// <returns>cActivity object</returns>
public static cActivity Create()
{
cActivity oObj = new cActivity();
SecurityCheck((int)enActivity_Action.Create);
// Create an object in memory, will be saved to storage on calling Save()
oObj.m_bCreating = true;
oObj.m_bInvalid = false;
return(oObj);
}
/// <summary>
/// Ensures that an object with the specified name exists, while creating other properties are set to their default values
/// </summary>
/// <param name="i_sName">Name</param>
/// <returns>cActivity object</returns>
public static cActivity CreateIfRequiredAndGet(string i_sName)
{
cActivity oObj = cActivity.Get_Name(i_sName);
if (oObj == null)
{
oObj = cActivity.Create();
oObj.sName = i_sName;
oObj.Save();
}
return(oObj);
}
private void InitcboActivity()
{
cActivity oActivity = new cActivity();
string strMessage = string.Empty,
strCriteria = string.Empty,
stractivity_code = string.Empty,
strbudget_code = string.Empty,
strproduce_code = string.Empty;
stractivity_code = cboActivity.SelectedValue;
strbudget_code = cboBudget.SelectedValue;
strproduce_code = cboProduce.SelectedValue;
int i;
DataSet ds = new DataSet();
DataTable dt = new DataTable();
strCriteria = " and activity.c_active='Y' ";
strCriteria = strCriteria + " And activity.budget_type ='" + this.BudgetType + "' ";
//if (!strbudget_code.Equals(""))
//{
strCriteria = strCriteria + " and produce.budget_code= '" + strbudget_code + "' ";
//}
//if (!strproduce_code.Equals(""))
//{
strCriteria = strCriteria + " and activity.produce_code= '" + strproduce_code + "' ";
//}
if (oActivity.SP_SEL_ACTIVITY(strCriteria, ref ds, ref strMessage))
{
dt = ds.Tables[0];
cboActivity.Items.Clear();
cboActivity.Items.Add(new ListItem("---- กรุณาเลือกข้อมูล ----", ""));
for (i = 0; i <= dt.Rows.Count - 1; i++)
{
cboActivity.Items.Add(new ListItem(dt.Rows[i]["activity_name"].ToString(), dt.Rows[i]["activity_code"].ToString()));
}
if (cboActivity.Items.FindByValue(stractivity_code) != null)
{
cboActivity.SelectedIndex = -1;
cboActivity.Items.FindByValue(stractivity_code).Selected = true;
}
}
InitcboPlan();
}
private void BindGridView()
{
cActivity oactivity = new cActivity();
DataSet ds = new DataSet();
string strMessage = string.Empty;
string strCriteria = string.Empty;
string strproduce_code = string.Empty;
strproduce_code = cboProduce.SelectedValue;
strCriteria = strCriteria + " And (activity.produce_code = '" + strproduce_code + "') ";
strCriteria = strCriteria + " And activity.budget_type ='" + this.BudgetType + "' ";
try
{
if (!oactivity.SP_SEL_ACTIVITY(strCriteria, ref ds, ref strMessage))
{
lblError.Text = strMessage;
}
else
{
try
{
ds.Tables[0].DefaultView.Sort = ViewState["sort"] + " " + ViewState["direction"];
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}
catch
{
GridView1.PageIndex = 0;
ds.Tables[0].DefaultView.Sort = ViewState["sort"] + " " + ViewState["direction"];
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}
}
}
catch (Exception ex)
{
lblError.Text = ex.Message.ToString();
}
finally
{
oactivity.Dispose();
ds.Dispose();
}
}
/// <summary>
/// Finds and return cActivity objects matching the specified criteria
/// </summary>
/// <param name="i_oFilter">Filter criteria (WHERE clause)</param>
/// <returns>cActivity objects</returns>
public static List <cActivity> Find(cFilter i_oFilter)
{
DataTable dt = Find_DataTable(i_oFilter, null);
List <cActivity> l = new List <cActivity>();
cActivity oObj;
for (int i = 0; i < dt.Rows.Count; i++)
{
oObj = new cActivity();
oObj.m_iID = Convert.ToInt32(dt.Rows[i]["iID"]);
oObj.m_sName = dt.Rows[i]["sName"].ToString();
oObj.m_dtCreatedOn = Convert.ToDateTime(dt.Rows[i]["dtCreatedOn"]);
oObj.m_dtLastUpdatedOn = Convert.ToDateTime(dt.Rows[i]["dtLastUpdatedOn"]);
oObj.m_sActivityName = Convert.ToString(dt.Rows[i]["sActivityName"]);
oObj.m_sDescription = Convert.ToString(dt.Rows[i]["sDescription"]);
oObj.m_bIsActive = Convert.ToBoolean(dt.Rows[i]["bIsActive"]);
oObj.m_bInvalid = false;
l.Add(oObj);
}
return(l);
}
private void setData()
{
cActivity oactivity = new cActivity();
DataSet ds = new DataSet();
string strMessage = string.Empty, strCriteria = string.Empty;
string stractivity_code = string.Empty,
stractivity_name = string.Empty,
strbudget_code = string.Empty,
strproduce_code = string.Empty,
strYear = string.Empty,
strC_active = string.Empty,
strCreatedBy = string.Empty,
strUpdatedBy = string.Empty,
strCreatedDate = string.Empty,
strUpdatedDate = string.Empty;
try
{
strCriteria = " and activity_code = '" + ViewState["activity_code"].ToString() + "' ";
if (!oactivity.SP_SEL_ACTIVITY(strCriteria, ref ds, ref strMessage))
{
lblError.Text = strMessage;
}
else
{
if (ds.Tables[0].Rows.Count > 0)
{
#region get Data
stractivity_code = ds.Tables[0].Rows[0]["activity_code"].ToString();
stractivity_name = ds.Tables[0].Rows[0]["activity_name"].ToString();
strbudget_code = ds.Tables[0].Rows[0]["budget_code"].ToString();
strproduce_code = ds.Tables[0].Rows[0]["produce_code"].ToString();
strYear = ds.Tables[0].Rows[0]["activity_year"].ToString();
strC_active = ds.Tables[0].Rows[0]["c_active"].ToString();
strCreatedBy = ds.Tables[0].Rows[0]["c_created_by"].ToString();
strUpdatedBy = ds.Tables[0].Rows[0]["c_updated_by"].ToString();
strCreatedDate = ds.Tables[0].Rows[0]["d_created_date"].ToString();
strUpdatedDate = ds.Tables[0].Rows[0]["d_updated_date"].ToString();
#endregion
#region set Control
txtactivity_code.Text = stractivity_code;
txtactivity_name.Text = stractivity_name;
InitcboYear();
if (cboYear.Items.FindByValue(strYear) != null)
{
cboYear.SelectedIndex = -1;
cboYear.Items.FindByValue(strYear).Selected = true;
}
InitcboBudget();
if (cboBudget.Items.FindByValue(strbudget_code) != null)
{
cboBudget.SelectedIndex = -1;
cboBudget.Items.FindByValue(strbudget_code).Selected = true;
}
InitcboProduce();
if (cboProduce.Items.FindByValue(strproduce_code) != null)
{
cboProduce.SelectedIndex = -1;
cboProduce.Items.FindByValue(strproduce_code).Selected = true;
}
if (strC_active.Equals("Y"))
{
txtactivity_name.ReadOnly = false;
txtactivity_name.CssClass = "textbox";
chkStatus.Checked = true;
}
else
{
txtactivity_name.ReadOnly = true;
txtactivity_name.CssClass = "textboxdis";
chkStatus.Checked = false;
}
cboYear.Enabled = false;
cboYear.CssClass = "textboxdis";
cboBudget.Enabled = false;
cboBudget.CssClass = "textboxdis";
cboProduce.Enabled = false;
cboProduce.CssClass = "textboxdis";
txtUpdatedBy.Text = strUpdatedBy;
txtUpdatedDate.Text = strUpdatedDate;
BindGridView();
#endregion
}
}
}
catch (Exception ex)
{
lblError.Text = ex.Message.ToString();
}
}
private bool saveData()
{
// InitcboYear();
InitcboBudget();
InitcboProduce();
bool blnResult = false;
bool blnDup = false;
string strMessage = string.Empty;
string stractivity_code = string.Empty,
stractivity_year = string.Empty,
stractivity_name = string.Empty,
strproduce_code = string.Empty,
strActive = string.Empty,
strCreatedBy = string.Empty,
strUpdatedBy = string.Empty;
string strScript = string.Empty;
cActivity oactivity = new cActivity();
DataSet ds = new DataSet();
try
{
#region set Data
//activity_code
stractivity_code = txtactivity_code.Text;
if (Request.Form["ctl00$ASPxRoundPanel1$ContentPlaceHolder1$ASPxRoundPanel2$txtactivity_code"] != null)
{
stractivity_code = Request.Form["ctl00$ASPxRoundPanel1$ContentPlaceHolder1$ASPxRoundPanel2$txtactivity_code"].ToString();
}
//activity_name
stractivity_name = txtactivity_name.Text;
if (Request.Form["ctl00$ASPxRoundPanel1$ContentPlaceHolder1$ASPxRoundPanel2$txtactivity_name"] != null)
{
stractivity_name = Request.Form["ctl00$ASPxRoundPanel1$ContentPlaceHolder1$ASPxRoundPanel2$txtactivity_name"].ToString();
}
//activity_year
stractivity_year = cboYear.SelectedValue;
//budget_code
strproduce_code = cboProduce.SelectedValue;
if (Request.Form["ctl00$ASPxRoundPanel1$ContentPlaceHolder1$cboProduce"] != null)
{
strproduce_code = Request.Form["ctl00$ASPxRoundPanel1$ContentPlaceHolder1$cboProduce"].ToString();
}
if (chkStatus.Checked == true)
{
strActive = "Y";
}
else
{
strActive = "N";
}
strCreatedBy = Session["username"].ToString();
strUpdatedBy = Session["username"].ToString();
#endregion
string strCheckAdd = " and activity.activity_code = '" + stractivity_code.Trim() + "' ";
if (!oactivity.SP_SEL_ACTIVITY(strCheckAdd, ref ds, ref strMessage))
{
lblError.Text = strMessage;
}
else
{
if (ds.Tables[0].Rows.Count > 0)
{
#region check dup
string strCheckDup = string.Empty;
strCheckDup = " and activity.activity_name = '" + stractivity_name.Trim() + "' and activity.activity_year = '" + stractivity_year.Trim() + "' " +
" and activity.produce_code='" + strproduce_code.Trim() + "' and activity.activity_code <> '" + stractivity_code.Trim() + "' ";
if (!oactivity.SP_SEL_ACTIVITY(strCheckDup, ref ds, ref strMessage))
{
lblError.Text = strMessage;
}
else
{
if (ds.Tables[0].Rows.Count > 0)
{
strScript =
"alert(\"ไม่สามารถแก้ไขข้อมูลได้ เนื่องจาก" +
"\\nข้อมูล : " + stractivity_name.Trim() +
"\\nข้อมูล : " + cboProduce.SelectedItem.Text +
"\\nข้อมูล : " + cboBudget.SelectedItem.Text +
"\\n ปี : " + stractivity_year.Trim() +
"\\nซ้ำ\");\n";
blnDup = true;
}
}
#endregion
#region edit
if (!blnDup)
{
if (oactivity.SP_UPD_ACTIVITY(stractivity_code, stractivity_year, stractivity_name, strproduce_code, strActive, strUpdatedBy, this.BudgetType, ref strMessage))
{
blnResult = true;
}
else
{
lblError.Text = strMessage.ToString();
}
}
else
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "chkdup", strScript, true);
}
#endregion
}
else
{
#region check dup
string strCheckDup = string.Empty;
strCheckDup = " and activity.activity_name = '" + stractivity_name.Trim() + "' and activity.activity_year = '" + stractivity_year + "' " +
" and activity.produce_code='" + strproduce_code.Trim() + "' ";
if (!oactivity.SP_SEL_ACTIVITY(strCheckDup, ref ds, ref strMessage))
{
lblError.Text = strMessage;
}
else
{
if (ds.Tables[0].Rows.Count > 0)
{
strScript =
"alert(\"ไม่สามารถเพิ่มข้อมูลได้ เนื่องจาก" +
"\\nข้อมูล : " + stractivity_name.Trim() +
"\\nข้อมูล : " + cboProduce.SelectedItem.Text +
"\\nข้อมูล : " + cboBudget.SelectedItem.Text +
"\\n ปี : " + stractivity_year.Trim() +
"\\nซ้ำ\");\n";
blnDup = true;
}
}
#endregion
#region insert
if (!blnDup)
{
if (oactivity.SP_INS_ACTIVITY(stractivity_year, stractivity_name, strproduce_code, strActive, strCreatedBy, this.BudgetType, ref strMessage))
{
string strGetcode = " and activity_name = '" + stractivity_name.Trim() + "' and activity_year = '" + stractivity_year + "' " +
" and activity.produce_code='" + strproduce_code.Trim() + " '";
if (!oactivity.SP_SEL_ACTIVITY(strGetcode, ref ds, ref strMessage))
{
lblError.Text = strMessage;
}
if (ds.Tables[0].Rows.Count > 0)
{
stractivity_code = ds.Tables[0].Rows[0]["activity_code"].ToString();
}
ViewState["activity_code"] = stractivity_code;
blnResult = true;
}
else
{
lblError.Text = strMessage.ToString();
}
}
else
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "close", strScript, true);
}
#endregion
}
}
}
catch (Exception ex)
{
lblError.Text = ex.Message.ToString();
}
finally
{
oactivity.Dispose();
}
return(blnResult);
}
private void BindGridView()
{
// InitcboBudget();
cActivity oactivity = new cActivity();
DataSet ds = new DataSet();
string strMessage = string.Empty;
string strCriteria = string.Empty;
string stractivity_code = string.Empty;
string stractivity_name = string.Empty;
string strbudget_code = string.Empty;
string strproduce_code = string.Empty;
string stractivity_year = string.Empty;
string strScript = string.Empty;
stractivity_code = txtactivity_code.Text.Replace("'", "''").Trim();
stractivity_name = txtactivity_name.Text.Replace("'", "''").Trim();
stractivity_year = txtyear.Text;
strbudget_code = "";
if (Request.Form[strPrefixCtr + "cboBudget"] != null)
{
strbudget_code = Request.Form[strPrefixCtr + "cboBudget"].ToString();
}
strproduce_code = "";
if (Request.Form[strPrefixCtr + "cboProduce"] != null)
{
strproduce_code = Request.Form[strPrefixCtr + "cboProduce"].ToString();
}
if (!stractivity_code.Equals(""))
{
strCriteria = strCriteria + " And (activity.activity_code like '%" + stractivity_code + "%') ";
}
if (!stractivity_name.Equals(""))
{
strCriteria = strCriteria + " And (activity.activity_name like '%" + stractivity_name + "%')";
}
if (!stractivity_year.Equals(""))
{
strCriteria = strCriteria + " And (activity.activity_year = '" + stractivity_year + "') ";
}
if (!strbudget_code.Equals(""))
{
strCriteria = strCriteria + " And (produce.budget_code = '" + strbudget_code + "') ";
}
if (!strproduce_code.Equals(""))
{
strCriteria = strCriteria + " And (activity.produce_code = '" + strproduce_code + "') ";
}
strCriteria = strCriteria + " And (activity.c_active ='Y') ";
try
{
if (oactivity.SP_SEL_ACTIVITY(strCriteria, ref ds, ref strMessage))
{
if (ds.Tables[0].Rows.Count == 1)
{
stractivity_code = ds.Tables[0].Rows[0]["activity_code"].ToString();
stractivity_name = ds.Tables[0].Rows[0]["activity_name"].ToString();
if (!ViewState["show"].ToString().Equals("1"))
{
strScript = "window.parent.frames['iframeShow" + (int.Parse(ViewState["show"].ToString()) - 1) + "'].document.getElementById('" + ViewState["ctrl1"].ToString() + "').value='" + stractivity_code + "';\n " +
"window.parent.frames['iframeShow" + (int.Parse(ViewState["show"].ToString()) - 1) + "'].document.getElementById('" + ViewState["ctrl2"].ToString() + "').value='" + stractivity_name + "';\n" +
"ClosePopUp('" + ViewState["show"].ToString() + "');";
}
else
{
strScript = "window.parent.document.forms[0]." + ViewState["ctrl1"].ToString() + ".value='" + stractivity_code + "';\n " +
"window.parent.document.forms[0]." + ViewState["ctrl2"].ToString() + ".value='" + stractivity_name + "';\n" +
"ClosePopUp('" + ViewState["show"].ToString() + "');";
}
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "close", strScript, true);
}
else
{
ds.Tables[0].DefaultView.Sort = ViewState["sort"] + " " + ViewState["direction"];
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}
}
else
{
lblError.Text = strMessage;
}
}
catch (Exception ex)
{
lblError.Text = ex.Message.ToString();
}
finally
{
oactivity.Dispose();
ds.Dispose();
}
}
using System;
private void setData()
{
cActivity oactivity = new cActivity();
DataSet ds = new DataSet();
string strMessage = string.Empty, strCriteria = string.Empty;
string stractivity_code = string.Empty,
stractivity_name = string.Empty,
strbudget_code = string.Empty,
strbudget_name = string.Empty,
strproduce_code = string.Empty,
strproduce_name = string.Empty,
strYear = string.Empty,
strC_active = string.Empty,
strCreatedBy = string.Empty,
strUpdatedBy = string.Empty,
strCreatedDate = string.Empty,
strUpdatedDate = string.Empty;
try
{
strCriteria = " and activity_code = '" + ViewState["activity_code"].ToString() + "' ";
if (!oactivity.SP_SEL_ACTIVITY(strCriteria, ref ds, ref strMessage))
{
lblError.Text = strMessage;
}
else
{
if (ds.Tables[0].Rows.Count > 0)
{
#region get Data
stractivity_code = ds.Tables[0].Rows[0]["activity_code"].ToString();
stractivity_name = ds.Tables[0].Rows[0]["activity_name"].ToString();
strproduce_code = ds.Tables[0].Rows[0]["produce_code"].ToString();
strproduce_name = ds.Tables[0].Rows[0]["produce_name"].ToString();
strbudget_code = ds.Tables[0].Rows[0]["budget_code"].ToString();
strbudget_name = ds.Tables[0].Rows[0]["budget_name"].ToString();
strYear = ds.Tables[0].Rows[0]["activity_year"].ToString();
strC_active = ds.Tables[0].Rows[0]["c_active"].ToString();
strCreatedBy = ds.Tables[0].Rows[0]["c_created_by"].ToString();
strUpdatedBy = ds.Tables[0].Rows[0]["c_updated_by"].ToString();
strCreatedDate = ds.Tables[0].Rows[0]["d_created_date"].ToString();
strUpdatedDate = ds.Tables[0].Rows[0]["d_updated_date"].ToString();
#endregion
#region set Control
txtactivity_code.Text = stractivity_code;
txtactivity_name.Text = stractivity_name;
txtproduce_code.Text = strproduce_code;
txtproduce_name.Text = strproduce_name;
txtbudget_code.Text = strbudget_code;
txtbudget_name.Text = strbudget_name;
txtyear.Text = strYear;
if (strC_active.Equals("Y"))
{
chkStatus.Checked = true;
}
else
{
chkStatus.Checked = false;
}
txtUpdatedBy.Text = strUpdatedBy;
txtUpdatedDate.Text = strUpdatedDate;
#endregion
}
}
}
catch (Exception ex)
{
lblError.Text = ex.Message.ToString();
}
}
private void BindGridView(int nPageNo)
{
//InitcboYear();
//InitcboBudget();
//InitcboProduce();
cActivity oactivity = new cActivity();
DataSet ds = new DataSet();
string strMessage = string.Empty;
string strCriteria = string.Empty;
string stractivity_code = string.Empty;
string stractivity_name = string.Empty;
string strbudget_code = string.Empty;
string strproduce_code = string.Empty;
string strActive = string.Empty;
string stractivity_year = string.Empty;
stractivity_code = txtactivity_code.Text.Replace("'", "''").Trim();
stractivity_name = txtactivity_name.Text.Replace("'", "''").Trim();
stractivity_year = cboYear.SelectedValue;
strbudget_code = "";
if (cboBudget.SelectedValue != "")
{
strbudget_code = cboBudget.SelectedValue;
}
strproduce_code = "";
if (cboProduce.SelectedValue != "")
{
strproduce_code = cboProduce.SelectedValue;
}
if (!stractivity_code.Equals(""))
{
strCriteria = strCriteria + " And (activity.activity_code like '%" + stractivity_code + "%') ";
}
if (!stractivity_name.Equals(""))
{
strCriteria = strCriteria + " And (activity.activity_name like '%" + stractivity_name + "%')";
}
if (!stractivity_year.Equals(""))
{
strCriteria = strCriteria + " And (activity.activity_year = '" + stractivity_year + "') ";
}
if (!strbudget_code.Equals(""))
{
strCriteria = strCriteria + " And (produce.budget_code = '" + strbudget_code + "') ";
}
if (!strproduce_code.Equals(""))
{
strCriteria = strCriteria + " And (activity.produce_code = '" + strproduce_code + "') ";
}
if (RadioActive.Checked)
{
strCriteria = strCriteria + " And (activity.c_active ='Y') ";
}
else if (RadioCancel.Checked)
{
strCriteria = strCriteria + " And (activity.c_active ='N') ";
}
strCriteria = strCriteria + " And activity.budget_type ='" + this.BudgetType + "' ";
try
{
if (!oactivity.SP_SEL_ACTIVITY(strCriteria, ref ds, ref strMessage))
{
lblError.Text = strMessage;
}
else
{
try
{
GridView1.PageIndex = nPageNo;
txthTotalRecord.Value = ds.Tables[0].Rows.Count.ToString();
ds.Tables[0].DefaultView.Sort = ViewState["sort"] + " " + ViewState["direction"];
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}
catch
{
GridView1.PageIndex = 0;
txthTotalRecord.Value = ds.Tables[0].Rows.Count.ToString();
ds.Tables[0].DefaultView.Sort = ViewState["sort"] + " " + ViewState["direction"];
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}
}
}
catch (Exception ex)
{
lblError.Text = ex.Message.ToString();
}
finally
{
//if (this.BudgetType == "R")
//{
// foreach (Control c in Page.Controls)
// {
// base.SetLabel(c, "กิจกรรม", "งานรอง");
// base.SetLabel(c, "แผนงบประมาณ ", "แผนงาน");
// base.SetLabel(c, "ผลผลิต", "งานหลัก");
// }
//}
oactivity.Dispose();
ds.Dispose();
if (GridView1.Rows.Count > 0)
{
GridView1.TopPagerRow.Visible = true;
}
}
}
