private void setData() { view_Budget_money_head budget_money_head = null; cBudget_money oBudget_money = new cBudget_money(); try { _strCriteria = " and budget_money_doc = '" + ViewState["budget_money_doc"].ToString() + "' "; budget_money_head = oBudget_money.GET(_strCriteria); if (budget_money_head != null) { #region set Control TabContainer1.Tabs[1].Visible = true; //Tab 1 txtUpdatedBy.Text = budget_money_head.c_updated_by; txtUpdatedDate.Text = budget_money_head.d_updated_date.ToString(); chkStatus.Checked = budget_money_head.c_active == "Y"; txtbudget_money_doc.Text = budget_money_head.budget_money_doc; InitcboYear(); if (cboYear.Items.FindByValue(budget_money_head.budget_money_year) != null) { cboYear.SelectedIndex = -1; cboYear.Items.FindByValue(budget_money_head.budget_money_year).Selected = true; } InitcboDegree(); if (cboDegree.Items.FindByValue(budget_money_head.degree_code) != null) { cboDegree.SelectedIndex = -1; cboDegree.Items.FindByValue(budget_money_head.degree_code).Selected = true; } InitcboBudgetType(); if (cboBudget_type.Items.FindByValue(budget_money_head.budget_type) != null) { cboBudget_type.SelectedIndex = -1; cboBudget_type.Items.FindByValue(budget_money_head.budget_type).Selected = true; } txtbudget_plan_code.Text = budget_money_head.budget_plan_code; txtbudget_name.Text = budget_money_head.budget_name; txtproduce_name.Text = budget_money_head.produce_name; txtactivity_name.Text = budget_money_head.activity_name; txtplan_name.Text = budget_money_head.plan_name; txtwork_name.Text = budget_money_head.work_name; txtfund_name.Text = budget_money_head.fund_name; txtdirector_name.Text = budget_money_head.director_name; txtunit_name.Text = budget_money_head.unit_name; txtcomment.Text = budget_money_head.comments; BindGridViewDetail(); #endregion } } catch (Exception ex) { lblError.Text = ex.Message.ToString(); } }
private bool DeleteDetail(string pbudget_money_detail_id) { var oBudget_money = new cBudget_money(); try { return(oBudget_money.SP_BUDGET_MONEY_DETAIL_DEL(pbudget_money_detail_id)); } catch (Exception ex) { if (ex.Message.Contains("REFERENCE constraint")) { MsgBox("ไม่สามารถลบข้อมูลได้เนื่องจากมีการนำไปใช้ในระบบแล้ว"); } else { lblError.Text = ex.Message.ToString(); } } finally { oBudget_money.Dispose(); } return(false); }
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; } } }
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 lblbudget_money_doc = (Label)GridView1.Rows[e.RowIndex].FindControl("lblbudget_money_doc"); cBudget_money oBudget_money = new cBudget_money(); try { oBudget_money.SP_BUDGET_MONEY_HEAD_DEL(lblbudget_money_doc.Text); } catch (Exception ex) { if (ex.Message.Contains("REFERENCE constraint")) { MsgBox("ไม่สามารถลบข้อมูลได้เนื่องจากมีการนำไปใช้ในระบบแล้ว"); } else { lblError.Text = ex.Message.ToString(); } } finally { oBudget_money.Dispose(); } BindGridView(0); }
protected void lbkRefresh_Click(object sender, EventArgs e) { cBudget_money oBudget_money = new cBudget_money(); string strMessage = string.Empty, strCriteria = string.Empty; try { strCriteria = " and budget_money_doc = '" + txtbudget_money_doc.Text + "' "; var item = oBudget_money.GET(strCriteria); if (item != null) { txtbudget_money_doc.Text = item.budget_money_doc; txtbudget_plan_code.Text = item.budget_plan_code; txtdirector_name.Text = item.director_name; txtunit_name.Text = item.unit_name; txtbudget_name.Text = item.budget_name; txtproduce_name.Text = item.produce_name; txtactivity_name.Text = item.activity_name; txtplan_name.Text = item.plan_name; txtwork_name.Text = item.work_name; txtfund_name.Text = item.fund_name; InitcboMajor(); InitcboItem_group_detail(); } } catch (Exception ex) { //lblError.Text = ex.Message.ToString(); } }
protected void GridViewMajor_RowDeleting(object sender, GridViewDeleteEventArgs e) { string strScript = string.Empty; HiddenField hddbudget_money_major_id = (HiddenField)GridViewMajor.Rows[e.RowIndex].FindControl("hddbudget_money_major_id"); cBudget_money oBudget_money = new cBudget_money(); try { oBudget_money.SP_BUDGET_MONEY_MAJOR_DEL(hddbudget_money_major_id.Value); setData(); strScript = "window.parent.__doPostBack('ctl00$ContentPlaceHolder1$LinkButton1','');"; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "OpenPage", strScript, true); } catch (Exception ex) { if (ex.Message.Contains("REFERENCE constraint")) { MsgBox("ไม่สามารถลบข้อมูลได้เนื่องจากมีการนำไปใช้ในระบบแล้ว"); } else { lblError.Text = ex.Message.ToString(); } } finally { oBudget_money.Dispose(); } BindGridView(); }
private bool saveData() { bool blnResult = false; string strScript = string.Empty; cBudget_money oBudget_money = new cBudget_money(); DataSet ds = new DataSet(); try { #region set Data var budget_money_detail = new Budget_money_detail() { budget_money_doc = ViewState["budget_money_doc"].ToString(), item_detail_id = int.Parse(hdditem_detail_id.Value), budget_money_detail_plan = decimal.Parse(txtbudget_money_detail_plan.Value.ToString()), budget_money_detail_contribute = decimal.Parse(txtbudget_money_detail_contribute.Value.ToString()), budget_money_detail_use = decimal.Parse(txtbudget_money_detail_contribute.Value.ToString()), budget_money_detail_comment = txtbudget_money_detail_comment.Text.Trim(), c_created_by = Session["username"].ToString(), c_updated_by = Session["username"].ToString() }; #endregion if (ViewState["mode"].ToString().ToLower().Equals("edit")) { if (oBudget_money.SP_BUDGET_MONEY_DETAIL_UPD(budget_money_detail)) { saveDataDetail(); } ; } else { oBudget_money.SP_BUDGET_MONEY_DETAIL_INS(budget_money_detail); ViewState["budget_money_detail_id"] = budget_money_detail.budget_money_detail_id; } blnResult = true; } catch (Exception ex) { if (ex.Message.Contains("duplicate key")) { MsgBox("ข้อมูลซ้ำโปรดตรวจสอบ"); } else { lblError.Text = ex.Message.ToString(); } } finally { oBudget_money.Dispose(); } return(blnResult); }
private void setData() { cBudget_money oBudget_money = new cBudget_money(); string strMessage = string.Empty, strCriteria = string.Empty; try { strCriteria = " and budget_money_detail_id = '" + ViewState["budget_money_detail_id"].ToString() + "' "; var item = oBudget_money.GETDETAIL(strCriteria); if (item != null) { #region set Control InitcboLot(); if (cboLot.Items.FindByValue(item.lot_code) != null) { cboLot.SelectedIndex = -1; cboLot.Items.FindByValue(item.lot_code).Selected = true; } InitcboItem_group(); if (cboItem_group.Items.FindByValue(item.item_group_code) != null) { cboItem_group.SelectedIndex = -1; cboItem_group.Items.FindByValue(item.item_group_code).Selected = true; } InitcboItemGroupDetail(); if (cboItem_group_detail.Items.FindByValue(item.item_group_detail_id.ToString()) != null) { cboItem_group_detail.SelectedIndex = -1; cboItem_group_detail.Items.FindByValue(item.item_group_detail_id.ToString()).Selected = true; } ViewState["budget_money_doc"] = item.budget_money_doc; hdditem_detail_id.Value = item.item_detail_id.ToString(); txtitem_detail_code.Text = item.item_detail_code; txtitem_detail_name.Text = item.item_detail_name; txtitem_name.Text = item.item_name; txtbudget_money_detail_comment.Text = item.budget_money_detail_comment; txtbudget_money_detail_plan.Value = item.budget_money_detail_plan; txtbudget_money_detail_contribute.Value = item.budget_money_detail_contribute; txtbudget_money_detail_transfer.Value = item.budget_money_detail_transfer; txtbudget_money_detail_use.Value = item.budget_money_detail_use; txtbudget_money_detail_remain.Value = item.budget_money_detail_remain; txtUpdatedBy.Text = item.c_updated_by; txtUpdatedDate.Text = item.d_updated_date.ToString(); #endregion } } catch (Exception ex) { lblError.Text = ex.Message.ToString(); } }
private bool saveDataDetail() { bool blnResult = false; string strScript = string.Empty; cBudget_money oBudget_money = new cBudget_money(); HiddenField hddbudget_money_major_id = null; AwNumeric txtbudget_money_major_plan = null; AwNumeric txtbudget_money_major_plan2 = null; AwNumeric txtbudget_money_major_plan3 = null; Budget_money_major budget_money_major = null; try { #region set Data //GridViewRow item = (GridViewRow)GridView1.Controls[0].Controls[0]; for (var index = 0; index < GridViewMajor.Rows.Count; index++) { hddbudget_money_major_id = (HiddenField)GridViewMajor.Rows[index].FindControl("hddbudget_money_major_id"); txtbudget_money_major_plan = (AwNumeric)GridViewMajor.Rows[index].FindControl("txtbudget_money_major_plan"); txtbudget_money_major_plan2 = (AwNumeric)GridViewMajor.Rows[index].FindControl("txtbudget_money_major_plan2"); txtbudget_money_major_plan3 = (AwNumeric)GridViewMajor.Rows[index].FindControl("txtbudget_money_major_plan3"); budget_money_major = new Budget_money_major { budget_money_major_id = long.Parse(hddbudget_money_major_id.Value), budget_money_major_plan = decimal.Parse(txtbudget_money_major_plan.Value.ToString()), budget_money_major_plan2 = decimal.Parse(txtbudget_money_major_plan2.Value.ToString()), budget_money_major_plan3 = decimal.Parse(txtbudget_money_major_plan3.Value.ToString()), c_updated_by = Session["username"].ToString() }; oBudget_money.SP_BUDGET_MONEY_MAJOR_UPD(budget_money_major); } blnResult = true; } catch (Exception ex) { if (ex.Message.Contains("duplicate key")) { MsgBox("ข้อมูลซ้ำโปรดตรวจสอบ"); } else { lblError.Text = ex.Message.ToString(); } } finally { oBudget_money.Dispose(); } return(blnResult); }
private bool saveData() { bool blnResult = false; Budget_money_head budget_money_head = new Budget_money_head(); cBudget_money oBudget_money = new cBudget_money(); try { #region set Data budget_money_head.budget_money_doc = txtbudget_money_doc.Text; budget_money_head.budget_money_year = cboYear.SelectedValue; budget_money_head.budget_type = cboBudget_type.SelectedValue; budget_money_head.budget_plan_code = txtbudget_plan_code.Text; budget_money_head.degree_code = cboDegree.SelectedValue; budget_money_head.comments = txtcomment.Text.Trim(); budget_money_head.c_active = chkStatus.Checked == true ? "Y" : "N"; budget_money_head.c_created_by = Session["username"].ToString(); budget_money_head.c_updated_by = Session["username"].ToString(); #endregion if (ViewState["mode"].ToString().ToLower().Equals("edit")) { oBudget_money.SP_BUDGET_MONEY_HEAD_UPD(budget_money_head); } else { oBudget_money.SP_BUDGET_MONEY_HEAD_INS(budget_money_head); ViewState["budget_money_doc"] = budget_money_head.budget_money_doc; } blnResult = true; } catch (Exception ex) { if (ex.Message.Contains("duplicate key")) { MsgBox("ข้อมูลซ้ำโปรดตรวจสอบ"); } else { lblError.Text = ex.Message.ToString(); } } finally { oBudget_money.Dispose(); } return(blnResult); }
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 bool saveData() { bool blnResult = false; string strUpdatedBy = string.Empty; strUpdatedBy = Session["username"].ToString(); CheckBox chkSelect; Label lblmajor_code; var oBudget_money = new cBudget_money(); Budget_money_major budget_money_major = null; try { foreach (GridViewRow gvRow in GridView1.Rows) { chkSelect = (CheckBox)gvRow.FindControl("chkSelect"); if (chkSelect.Checked) { lblmajor_code = (Label)gvRow.FindControl("lblmajor_code"); budget_money_major = new Budget_money_major() { budget_money_detail_id = long.Parse(ViewState["budget_money_detail_id"].ToString()), major_code = lblmajor_code.Text, c_created_by = strUpdatedBy }; oBudget_money.SP_BUDGET_MONEY_MAJOR_INS(budget_money_major); } } blnResult = true; } catch (Exception ex) { lblError.Text = ex.Message; } finally { oBudget_money.Dispose(); } return(blnResult); }
private void SetBudgetMoneyMajor_to() { cBudget_money oBudget_money = new cBudget_money(); string strMessage = string.Empty, strCriteria = string.Empty; try { strCriteria = " and budget_money_year = '" + BudgetYear + "' and budget_type='" + this.BudgetType + "' " + " and degree_code = '" + MyBudgetTransferHead.degree_code_to + "' " + " and major_code = '" + MyBudgetTransferHead.major_code_to + "' " + " and budget_plan_code = '" + MyBudgetTransferHead.budget_plan_code_to + "' " + " and item_detail_id = '" + cboItem_detail_to.SelectedValue + "' "; var item = oBudget_money.GETMAJOR(strCriteria); hddbudget_money_major_id_to.Value = string.Empty; if (item != null) { hddbudget_money_major_id_to.Value = item.budget_money_major_id.ToString(); } } catch (Exception ex) { lblError.Text = ex.Message.ToString(); } }
private void BindGridView(int nPageNo) { var oBudget_money = new cBudget_money(); DataSet ds = new DataSet(); string strMessage = string.Empty; string strCriteria = string.Empty; var budget_money_head = new view_Budget_money_head(); string strScript = string.Empty; #region Criteria budget_money_head.degree_code = cboDegree.SelectedValue; budget_money_head.budget_money_year = cboYear.SelectedValue; budget_money_head.budget_money_doc = txtbudget_money_doc.Text.Replace("'", "''").Trim(); budget_money_head.budget_plan_code = txtbudget_plan_code.Text.Replace("'", "''").Trim(); budget_money_head.budget_code = cboBudget.SelectedValue; budget_money_head.produce_code = cboProduce.SelectedValue; budget_money_head.director_code = cboDirector.SelectedValue; budget_money_head.unit_code = cboUnit.SelectedValue; budget_money_head.activity_code = cboActivity.SelectedValue; budget_money_head.plan_code = cboPlan_code.SelectedValue; if (!budget_money_head.budget_money_year.Equals("")) { strCriteria = strCriteria + " And (budget_money_year = '" + budget_money_head.budget_money_year + "') "; } if (!budget_money_head.budget_money_doc.Equals("")) { strCriteria = strCriteria + " And (budget_money_doc ='" + budget_money_head.budget_money_doc + "') "; } if (!budget_money_head.budget_plan_code.Equals("")) { strCriteria = strCriteria + " And (budget_plan_code ='" + budget_money_head.budget_plan_code + "') "; } if (!budget_money_head.degree_code.Equals("")) { strCriteria = strCriteria + " And (degree_code ='" + budget_money_head.degree_code + "') "; } if (!budget_money_head.produce_code.Equals("")) { strCriteria = strCriteria + " And (produce_code ='" + budget_money_head.produce_code + "') "; } if (!budget_money_head.budget_code.Equals("")) { strCriteria = strCriteria + " And (budget_code ='" + budget_money_head.budget_code + "') "; } if (!budget_money_head.director_code.Equals("")) { strCriteria = strCriteria + " And (director_code ='" + budget_money_head.director_code + "') "; } if (!budget_money_head.unit_code.Equals("")) { strCriteria = strCriteria + " And (unit_code ='" + budget_money_head.unit_code + "') "; } if (!budget_money_head.activity_code.Equals("")) { strCriteria = strCriteria + " And (activity_code = '" + budget_money_head.activity_code + "') "; } if (!budget_money_head.plan_code.Equals("")) { strCriteria = strCriteria + " And (plan_code = '" + budget_money_head.plan_code + "') "; } //if (!budget_money_head.work_code.Equals("")) //{ // strCriteria = strCriteria + " And (work_code like '%" + budget_money_head.work_code + "%') "; //} if (DirectorLock == "Y") { strCriteria += " and substring(director_code,4,2) = substring('" + DirectorCode + "',4,2) "; } #endregion if (RadioActive.Checked) { strCriteria = strCriteria + " And (c_active ='Y') "; } else if (RadioCancel.Checked) { strCriteria = strCriteria + " And (c_active ='N') "; } strCriteria = strCriteria + " and budget_type ='" + this.BudgetType + "' "; try { if (!oBudget_money.SP_BUDGET_MONEY_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_money.Dispose(); ds.Dispose(); if (GridView1.Rows.Count > 0) { GridView1.TopPagerRow.Visible = true; } } }
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(); } }
private bool saveRecvDetail() { bool blnResult = false; cBudget_receive oBudget_receive = new cBudget_receive(); cBudget_money oBudget_money = new cBudget_money(); cCommon oCommon = new cCommon(); var ds = new DataSet(); DataTable dt = null; var major_director_code = string.Empty; oCommon.SEL_SQL("select g_code from General where g_type = 'main_director_code'", ref ds, ref _strMessage); dt = ds.Tables[0]; if (dt.Rows.Count > 0) { major_director_code = "M" + cboYear.SelectedValue.Substring(2, 2) + dt.Rows[0]["g_code"].ToString(); } _strCriteria = " and budget_money_doc = '" + txtbudget_money_doc.Text + "' "; _strCriteria += " and major_code in (select '" + major_director_code + "' union all select '" + cboMajor.SelectedValue + "') "; var listBudget_major = oBudget_money.GETMONEYDETAILS(_strCriteria); if (listBudget_major != null) { List <Budget_receive_detail> listBudget_receive_detail = new List <Budget_receive_detail>(); try { decimal detail_contribute = 0; foreach (var row in listBudget_major) { if (row.major_code == major_director_code) { detail_contribute = decimal.Parse(txtdeduct_total_reduce_director.Value.ToString()); } else { detail_contribute = decimal.Parse(txtdeduct_total_remain.Value.ToString()); } listBudget_receive_detail.Add(new Budget_receive_detail { budget_receive_doc = txtbudget_receive_doc.Text, budget_money_major_id = row.budget_money_major_id, budget_receive_detail_contribute = detail_contribute, c_created_by = Session["username"].ToString(), c_updated_by = Session["username"].ToString() }); } DeleteRecvDetail(txtbudget_receive_doc.Text); if (listBudget_receive_detail.Any()) { foreach (var major in listBudget_receive_detail) { oBudget_receive.SP_BUDGET_RECEIVE_DETAIL_INS(major); } } blnResult = true; } catch (Exception ex) { if (ex.Message.Contains("duplicate key")) { MsgBox("ข้อมูลซ้ำโปรดตรวจสอบ"); } else { lblError.Text = ex.Message.ToString(); } } finally { oBudget_receive.Dispose(); } } return(blnResult); }
private void BindGridView() { cBudget_money oBudget_money = new cBudget_money(); DataSet ds = new DataSet(); string strMessage = string.Empty; string strCriteria = string.Empty; string strbudget_year = string.Empty; string strbudget_money_doc = string.Empty; string strbudget_plan_code = string.Empty; string strbudget_code = string.Empty; string strproduce_code = string.Empty; string strunit_code = string.Empty; string strdirector_code = string.Empty; string stractivity_code = string.Empty; string strplan_code = string.Empty; string strwork_code = string.Empty; string strwork_name = string.Empty; string stractive = string.Empty; string strScript = string.Empty; #region Criteria strbudget_year = txtyear.Text.Replace("'", "''").Trim(); strbudget_money_doc = txtbudget_money_doc.Text.Replace("'", "''").Trim(); strbudget_plan_code = txtbudget_plan_code.Text.Replace("'", "''").Trim(); strbudget_code = cboBudget.SelectedValue; strproduce_code = cboProduce.SelectedValue; strdirector_code = cboDirector.SelectedValue; strunit_code = cboUnit.SelectedValue; stractivity_code = cboActivity.SelectedValue; strplan_code = cboPlan_code.SelectedValue; strwork_code = txtwork_code.Text.Replace("'", "''").Trim(); strwork_name = txtwork_name.Text.Replace("'", "''").Trim(); if (!strbudget_year.Equals("")) { strCriteria = strCriteria + " And (budget_money_year = '" + strbudget_year + "') "; } if (!strbudget_plan_code.Equals("")) { strCriteria = strCriteria + " And (budget_plan_code ='" + strbudget_plan_code + "') "; } if (!strproduce_code.Equals("")) { strCriteria = strCriteria + " And (produce_code ='" + strproduce_code + "') "; } 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 (!stractivity_code.Equals("")) { strCriteria = strCriteria + " And (activity_code = '" + stractivity_code + "') "; } if (!strplan_code.Equals("")) { strCriteria = strCriteria + " And (plan_code = '" + strplan_code + "') "; } if (!strwork_code.Equals("")) { strCriteria = strCriteria + " And (work_code like '%" + strwork_code + "%') "; } if (!strwork_name.Equals("")) { strCriteria = strCriteria + " And (work_name like '%" + strwork_name + "%') "; } strCriteria = strCriteria + " And (c_active ='Y') "; if (ViewState["from_page"].ToString().Equals("budgetmoney")) { strCriteria = strCriteria + " And budget_type='" + this.BudgetType + "' "; } else { if (this.BudgetType != "M") { strCriteria = strCriteria + " and budget_type ='" + this.BudgetType + "' "; } } if (DirectorLock == "Y") { strCriteria += " and substring(director_code,4,2) = substring('" + DirectorCode + "',4,2) "; } //budget_type #endregion try { if (oBudget_money.SP_BUDGET_MONEY_HEAD_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 { //if (this.BudgetType == "R") //{ // foreach (Control c in Page.Controls) // { // base.SetLabel(c, "แผนงาน", "งานย่อย"); // base.SetLabel(c, "กิจกรรม", "งานรอง"); // base.SetLabel(c, "แผนงบประมาณ ", "แผนงาน"); // base.SetLabel(c, "ผลผลิต", "งานหลัก"); // } //} oBudget_money.Dispose(); ds.Dispose(); } }