private void InitcboMajor()
{
cBudget_money oMajor = new cBudget_money();
string strMessage = string.Empty, strCriteria = string.Empty;
string strYear = cboYear.SelectedValue;
string strmajor_code = cboMajor.SelectedValue;
DataSet ds = new DataSet();
DataTable dt = new DataTable();
strCriteria = " and budget_money_doc = '" + txtbudget_money_doc.Text + "' ";
if (MajorLock == "Y")
{
strCriteria += " and major_code = '" + PersonMajorCode + "' ";
}
if (oMajor.SP_BUDGET_MONEY_MAJOR_SEL(strCriteria, ref ds, ref strMessage))
{
dt = ds.Tables[0];
cboMajor.Items.Clear();
cboMajor.Items.Add(new ListItem("---- กรุณาเลือกข้อมูล ----", ""));
int i;
for (i = 0; i <= dt.Rows.Count - 1; i++)
{
cboMajor.Items.Add(new ListItem(dt.Rows[i]["major_name"].ToString(), dt.Rows[i]["major_code"].ToString()));
}
if (cboMajor.Items.FindByValue(strmajor_code) != null)
{
cboMajor.SelectedIndex = -1;
cboMajor.Items.FindByValue(strmajor_code).Selected = true;
}
}
}
private void BindGridView()
{
cBudget_money oBudget_money = new cBudget_money();
DataSet ds = new DataSet();
string strMessage = string.Empty;
string strCriteria = string.Empty;
strCriteria = " And (budget_money_detail_id = '" + ViewState["budget_money_detail_id"].ToString() + "') ";
try
{
if (!oBudget_money.SP_BUDGET_MONEY_MAJOR_SEL(strCriteria, ref ds, ref strMessage))
{
lblError.Text = strMessage;
}
else
{
try
{
GridViewMajor.PageIndex = 0;
ds.Tables[0].DefaultView.Sort = ViewState["sort"] + " " + ViewState["direction"];
GridViewMajor.DataSource = ds.Tables[0];
GridViewMajor.DataBind();
}
catch
{
GridViewMajor.PageIndex = 0;
ds.Tables[0].DefaultView.Sort = ViewState["sort"] + " " + ViewState["direction"];
GridViewMajor.DataSource = ds.Tables[0];
GridViewMajor.DataBind();
}
}
}
catch (Exception ex)
{
lblError.Text = ex.Message.ToString();
}
finally
{
if (GridViewMajor.Rows.Count == 0)
{
EmptyGridFix(GridViewMajor);
}
oBudget_money.Dispose();
ds.Dispose();
}
}
private void BindGridView()
{
cBudget_money oBudget_money = new cBudget_money();
DataSet ds = new DataSet();
string strMessage = string.Empty;
string strCriteria = string.Empty;
view_Budget_money_major item = new view_Budget_money_major();
string strScript = string.Empty;
item.item_year = ViewState["year"].ToString();
item.item_group_code = cboItem_group.SelectedValue;
item.item_group_detail_id = string.IsNullOrEmpty(cboItem_group_detail.SelectedValue) ? 0 : int.Parse(cboItem_group_detail.SelectedValue);
item.item_code = cboItem.SelectedValue;
item.item_detail_code = txtitem_detail_code.Text.Replace("'", "''").Trim();
item.item_detail_name = txtitem_detail_name.Text.Replace("'", "''").Trim();
item.budget_plan_code = ViewState["budget_plan_code"].ToString();
item.degree_code = ViewState["degree_code"].ToString();
item.major_code = ViewState["major_code"].ToString();
if (!item.item_year.Equals(""))
{
strCriteria = strCriteria + " And (item_year = '" + item.item_year + "') ";
}
if (!item.item_group_code.Equals(""))
{
strCriteria = strCriteria + " And (item_group_code = '" + item.item_group_code + "') ";
}
if (item.item_group_detail_id.GetValueOrDefault() > 0)
{
strCriteria = strCriteria + " And (item_group_detail_id = '" + item.item_group_detail_id.GetValueOrDefault() + "') ";
}
if (!item.item_code.Equals(""))
{
strCriteria = strCriteria + " And (item_code = '" + item.item_code + "') ";
}
if (!item.item_detail_code.Equals(""))
{
strCriteria = strCriteria + " And (item_detail_code like '%" + item.item_detail_code + "%') ";
}
if (!item.item_detail_name.Equals(""))
{
strCriteria = strCriteria + " And (item_detail_name like '%" + item.item_detail_name + "%') ";
}
if (!item.budget_plan_code.Equals(""))
{
strCriteria = strCriteria + " And (budget_plan_code like '%" + item.budget_plan_code + "%') ";
}
if (!item.degree_code.Equals(""))
{
strCriteria = strCriteria + " And (degree_code like '%" + item.degree_code + "%') ";
}
if (!item.major_code.Equals(""))
{
strCriteria = strCriteria + " And (major_code like '%" + item.major_code + "%') ";
}
strCriteria = strCriteria + " And budget_money_major_id not in (select budget_money_major_id from Budget_open_detail where budget_open_doc = '" + ViewState["budget_open_doc"].ToString() + "' ) ";
try
{
if (oBudget_money.SP_BUDGET_MONEY_MAJOR_SEL(strCriteria, ref ds, ref strMessage))
{
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
{
oBudget_money.Dispose();
ds.Dispose();
}
}
private void BindGridView()
{
cBudget_money oBudget_money = new cBudget_money();
DataSet ds = new DataSet();
string strMessage = string.Empty;
string strCriteria = string.Empty;
view_Budget_money_major item = new view_Budget_money_major();
string strScript = string.Empty;
if (this.BudgetType == "B")
{
item.item_year = ((DataSet)Application["xmlconfig"]).Tables["default"].Rows[0]["yearnow"].ToString();
}
else
{
item.item_year = ((DataSet)Application["xmlconfig"]).Tables["default"].Rows[0]["yearnow2"].ToString();
}
item.item_group_code = cboItem_group.SelectedValue;
item.item_group_detail_id = string.IsNullOrEmpty(cboItem_group_detail.SelectedValue) ? 0 : int.Parse(cboItem_group_detail.SelectedValue);
item.item_code = cboItem.SelectedValue;
item.item_detail_code = txtitem_detail_code.Text.Replace("'", "''").Trim();
item.item_detail_name = txtitem_detail_name.Text.Replace("'", "''").Trim();
item.budget_plan_code = ViewState["budget_plan_code"].ToString();
item.degree_code = ViewState["degree_code"].ToString();
item.major_code = ViewState["major_code"].ToString();
if (!item.item_year.Equals(""))
{
strCriteria = strCriteria + " And (item_year = '" + item.item_year + "') ";
}
if (!item.item_group_code.Equals(""))
{
strCriteria = strCriteria + " And (item_group_code = '" + item.item_group_code + "') ";
}
if (item.item_group_detail_id.GetValueOrDefault() > 0)
{
strCriteria = strCriteria + " And (item_group_detail_id = '" + item.item_group_detail_id.GetValueOrDefault() + "') ";
}
if (!item.item_code.Equals(""))
{
strCriteria = strCriteria + " And (item_code = '" + item.item_code + "') ";
}
if (!item.item_detail_code.Equals(""))
{
strCriteria = strCriteria + " And (item_detail_code like '%" + item.item_detail_code + "%') ";
}
if (!item.item_detail_name.Equals(""))
{
strCriteria = strCriteria + " And (item_detail_name like '%" + item.item_detail_name + "%') ";
}
if (!item.budget_plan_code.Equals(""))
{
strCriteria = strCriteria + " And (budget_plan_code like '%" + item.budget_plan_code + "%') ";
}
if (!item.degree_code.Equals(""))
{
strCriteria = strCriteria + " And (degree_code like '%" + item.degree_code + "%') ";
}
if (!item.major_code.Equals(""))
{
strCriteria = strCriteria + " And (major_code like '%" + item.major_code + "%') ";
}
strCriteria = strCriteria + " And budget_money_major_id not in (select budget_money_major_id from Budget_open_detail where budget_open_doc = '" + ViewState["budget_open_doc"].ToString() + "' ) ";
try
{
if (oBudget_money.SP_BUDGET_MONEY_MAJOR_SEL(strCriteria, ref ds, ref strMessage))
{
//if (ds.Tables[0].Rows.Count == 1)
//{
// if (!ViewState["show"].ToString().Equals("1"))
// {
// strScript = "window.parent.frames['iframeShow" + (int.Parse(ViewState["show"].ToString()) - 1) + "'].document.getElementById('" + ViewState["hddbudget_money_major_id"].ToString() + "').value='" + ds.Tables[0].Rows[0]["budget_money_major_id"].ToString() + "';\n " +
// "window.parent.frames['iframeShow" + (int.Parse(ViewState["show"].ToString()) - 1) + "'].document.getElementById('" + ViewState["txtitem_detail_code"].ToString() + "').value='" + ds.Tables[0].Rows[0]["item_detail_code"].ToString() + "';\n " +
// "window.parent.frames['iframeShow" + (int.Parse(ViewState["show"].ToString()) - 1) + "'].document.getElementById('" + ViewState["txtitem_detail_name"].ToString() + "').value='" + ds.Tables[0].Rows[0]["item_detail_name"].ToString() + "';\n " +
// "window.parent.frames['iframeShow" + (int.Parse(ViewState["show"].ToString()) - 1) + "'].document.getElementById('" + ViewState["txtlot_name"].ToString() + "').value='" + ds.Tables[0].Rows[0]["lot_name"].ToString() + "';\n " +
// "window.parent.frames['iframeShow" + (int.Parse(ViewState["show"].ToString()) - 1) + "'].document.getElementById('" + ViewState["txtitem_group_detail_name"].ToString() + "').value='" + ds.Tables[0].Rows[0]["item_group_detail_name"].ToString() + "';\n ";
// }
// else
// {
// strScript = "window.parent.document.getElementById('" + ViewState["hddbudget_money_major_id"].ToString() + "').value='" + ds.Tables[0].Rows[0]["budget_money_major_id"].ToString() + "';\n " +
// "window.parent.document.getElementById('" + ViewState["txtitem_detail_code"].ToString() + "').value='" + ds.Tables[0].Rows[0]["item_detail_code"].ToString() + "';\n " +
// "window.parent.document.getElementById('" + ViewState["txtitem_detail_name"].ToString() + "').value='" + ds.Tables[0].Rows[0]["item_detail_name"].ToString() + "';\n " +
// "window.parent.document.getElementById('" + ViewState["txtlot_name"].ToString() + "').value='" + ds.Tables[0].Rows[0]["lot_name"].ToString() + "';\n " +
// "window.parent.document.getElementById('" + ViewState["txtitem_group_detail_name"].ToString() + "').value='" + ds.Tables[0].Rows[0]["item_group_detail_name"].ToString() + "';\n ";
// }
// strScript += "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
{
oBudget_money.Dispose();
ds.Dispose();
}
}
