public view_Budget_money_major GETMAJOR(string strCriteria) { view_Budget_money_major result = null; var strMessage = string.Empty; DataSet ds = null; if (SP_BUDGET_MONEY_MAJOR_SEL(strCriteria, ref ds, ref strMessage)) { result = Helper.ToClassInstanceCollection <view_Budget_money_major>(ds.Tables[0]).FirstOrDefault(); } return(result); }
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(); } }