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(); } }
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(); } }
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; } } }