public view_Budget_receive_head GET(string strCriteria)
{
view_Budget_receive_head result = null;
var strMessage = string.Empty;
DataSet ds = null;
if (SP_BUDGET_RECEIVE_HEAD_SEL(strCriteria, ref ds, ref strMessage))
{
result = Helper.ToClassInstanceCollection <view_Budget_receive_head>(ds.Tables[0]).FirstOrDefault();
}
return(result);
}
private void BindGridView(int nPageNo)
{
var obudget_receive = new cBudget_receive();
DataSet ds = new DataSet();
string strMessage = string.Empty;
string strCriteria = string.Empty;
var budget_receive_head = new view_Budget_receive_head();
string strScript = string.Empty;
#region Criteria
budget_receive_head.budget_receive_year = cboYear.SelectedValue;
budget_receive_head.degree_code = cboDegree.SelectedValue;
budget_receive_head.budget_receive_doc = txtbudget_receive_doc.Text.Replace("'", "''").Trim();
budget_receive_head.budget_plan_code = txtbudget_plan_code.Text.Replace("'", "''").Trim();
budget_receive_head.unit_code = cboUnit.SelectedValue;
budget_receive_head.budget_code = cboBudget.SelectedValue;
budget_receive_head.produce_code = cboProduce.SelectedValue;
budget_receive_head.activity_code = cboActivity.SelectedValue;
budget_receive_head.plan_code = cboPlan_code.SelectedValue;
budget_receive_head.item_group_code = cboItem_group.SelectedValue;
budget_receive_head.item_group_detail_code = cboItem_group_detail.SelectedValue;
if (!budget_receive_head.budget_receive_year.Equals(""))
{
strCriteria = strCriteria + " And (budget_receive_year = '" + budget_receive_head.budget_receive_year + "') ";
}
if (!budget_receive_head.degree_code.Equals(""))
{
strCriteria = strCriteria + " And (degree_code = '" + budget_receive_head.degree_code + "') ";
}
if (!string.IsNullOrEmpty(txtdate_begin.Text))
{
strCriteria = strCriteria + " And (budget_receive_date >= '" + cCommon.SeekDate(txtdate_begin.Text) + "') ";
}
if (!string.IsNullOrEmpty(txtdate_end.Text))
{
strCriteria = strCriteria + " And (budget_receive_date <= '" + cCommon.SeekDate(txtdate_end.Text) + "') ";
}
if (!budget_receive_head.budget_receive_doc.Equals(""))
{
strCriteria = strCriteria + " And (budget_receive_doc LIKE '%" + budget_receive_head.budget_receive_doc + "%') ";
}
if (!budget_receive_head.budget_plan_code.Equals(""))
{
strCriteria = strCriteria + " And (budget_plan_code ='" + budget_receive_head.budget_plan_code + "') ";
}
if (!budget_receive_head.unit_code.Equals(""))
{
strCriteria = strCriteria + " And (unit_code ='" + budget_receive_head.unit_code + "') ";
}
if (!budget_receive_head.budget_code.Equals(""))
{
strCriteria = strCriteria + " And (budget_code ='" + budget_receive_head.budget_code + "') ";
}
if (!budget_receive_head.produce_code.Equals(""))
{
strCriteria = strCriteria + " And (produce_code ='" + budget_receive_head.produce_code + "') ";
}
if (!budget_receive_head.activity_code.Equals(""))
{
strCriteria = strCriteria + " And (activity_code = '" + budget_receive_head.activity_code + "') ";
}
if (!budget_receive_head.plan_code.Equals(""))
{
strCriteria = strCriteria + " And (plan_code = '" + budget_receive_head.plan_code + "') ";
}
if (!budget_receive_head.item_group_code.Equals(""))
{
strCriteria = strCriteria + " And (item_group_code = '" + budget_receive_head.item_group_code + "') ";
}
if (!budget_receive_head.item_group_detail_code.Equals(""))
{
strCriteria = strCriteria + " And (item_group_detail_code = '" + budget_receive_head.item_group_detail_code + "') ";
}
if (DirectorLock == "Y")
{
strCriteria += " and substring(director_code,4,2) = substring('" + DirectorCode + "',4,2) ";
}
#endregion
strCriteria = strCriteria + " and budget_type ='" + this.BudgetType + "' ";
try
{
if (!obudget_receive.SP_BUDGET_RECEIVE_HEAD_SEL(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
{
obudget_receive.Dispose();
ds.Dispose();
if (GridView1.Rows.Count > 0)
{
GridView1.TopPagerRow.Visible = true;
}
}
}
