private void InitcboBudget() { cBudget oBudget = new cBudget(); string strMessage = string.Empty, strCriteria = string.Empty; string strYear = cboYear.SelectedValue; string strbudget_code = cboBudget.SelectedValue; DataSet ds = new DataSet(); DataTable dt = new DataTable(); strCriteria = " and budget_year = '" + strYear + "' and c_active='Y' "; strCriteria = strCriteria + " And budget_type ='" + this.BudgetType + "' "; if (oBudget.SP_SEL_BUDGET(strCriteria, ref ds, ref strMessage)) { dt = ds.Tables[0]; cboBudget.Items.Clear(); cboBudget.Items.Add(new ListItem("---- เลือกข้อมูลทั้งหมด ----", "")); int i; for (i = 0; i <= dt.Rows.Count - 1; i++) { cboBudget.Items.Add(new ListItem(dt.Rows[i]["budget_name"].ToString(), dt.Rows[i]["budget_code"].ToString())); } if (cboBudget.Items.FindByValue(strbudget_code) != null) { cboBudget.SelectedIndex = -1; cboBudget.Items.FindByValue(strbudget_code).Selected = true; } } InitcboProduce(); }
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_code = (Label)GridView1.Rows[e.RowIndex].FindControl("lblbudget_code"); cBudget oBudget = new cBudget(); try { if (!oBudget.SP_DEL_BUDGET(lblbudget_code.Text, "N", strUpdatedBy, ref strMessage)) { lblError.Text = strMessage; } } catch (Exception ex) { lblError.Text = ex.Message.ToString(); } finally { oBudget.Dispose(); } BindGridView(0); }
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_code = (Label)GridView1.Rows[e.RowIndex].FindControl("lblbudget_code"); cBudget oBudget = new cBudget(); try { if (!oBudget.SP_DEL_BUDGET(lblbudget_code.Text, "N", strUpdatedBy, ref strMessage)) { lblError.Text = strMessage; } } catch (Exception ex) { if (ex.Message.Contains("REFERENCE constraint")) { MsgBox("ไม่สามารถลบข้อมูลได้เนื่องจากมีการนำไปใช้ในระบบแล้ว"); } else { lblError.Text = ex.Message.ToString(); } } finally { oBudget.Dispose(); } BindGridView(0); }
private void setData() { cBudget oBudget = new cBudget(); DataSet ds = new DataSet(); string strMessage = string.Empty, strCriteria = string.Empty; string strbudget_code = string.Empty, strbudget_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 budget_code = '" + ViewState["budget_code"].ToString() + "' "; if (!oBudget.SP_SEL_BUDGET(strCriteria, ref ds, ref strMessage)) { lblError.Text = strMessage; } else { if (ds.Tables[0].Rows.Count > 0) { #region get Data 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]["budget_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 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(); } }
public DataTable GetDataBudget(string strYear) { cBudget oBudget = new cBudget(); string strMessage = string.Empty, strCriteria = string.Empty; string strbudget_code = string.Empty, strbudget_name = string.Empty; DataSet ds = new DataSet(); DataTable dt = new DataTable(); strCriteria = " and budget_year = '" + strYear + "' and c_active='Y' "; if (oBudget.SP_SEL_BUDGET(strCriteria, ref ds, ref strMessage)) { dt = ds.Tables[0]; } return(dt); }
private void BindGridView(int nPageNo) { cBudget oBudget = new cBudget(); DataSet ds = new DataSet(); string strMessage = string.Empty; string strCriteria = string.Empty; string strbudget_code = string.Empty; string strbudget_name = string.Empty; string strActive = string.Empty; string strbudget_year = string.Empty; strbudget_code = txtbudget_code.Text.Replace("'", "''").Trim(); strbudget_name = txtbudget_name.Text.Replace("'", "''").Trim(); strbudget_year = cboYear.SelectedValue; if (!strbudget_code.Equals("0")) { strCriteria = strCriteria + " And (budget_code like '%" + strbudget_code + "%') "; } if (!strbudget_name.Equals("0")) { strCriteria = strCriteria + " And (budget_name like '%" + strbudget_name + "%')"; } if (!strbudget_year.Equals("0")) { strCriteria = strCriteria + " And (budget_year = '" + strbudget_year + "') "; } 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.SP_SEL_BUDGET(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.Dispose(); ds.Dispose(); if (GridView1.Rows.Count > 0) { GridView1.TopPagerRow.Visible = true; } //if (this.BudgetType == "R") //{ // foreach (Control c in GridView1.Controls) // { // base.SetLabel(c, old_str, new_str); // } //} } }
private void setData() { cBudget oBudget = new cBudget(); DataSet ds = new DataSet(); string strMessage = string.Empty, strCriteria = string.Empty; string strbudget_code = string.Empty, strbudget_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 budget_code = '" + ViewState["budget_code"].ToString() + "' "; if (!oBudget.SP_SEL_BUDGET(strCriteria, ref ds, ref strMessage)) { lblError.Text = strMessage; } else { if (ds.Tables[0].Rows.Count > 0) { #region get Data 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]["budget_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 txtbudget_code.Text = strbudget_code; txtbudget_name.Text = strbudget_name; InitcboYear(); if (cboYear.Items.FindByValue(strYear) != null) { cboYear.SelectedIndex = -1; cboYear.Items.FindByValue(strYear).Selected = true; } if (strC_active.Equals("Y")) { txtbudget_name.ReadOnly = false; txtbudget_name.CssClass = "textbox"; chkStatus.Checked = true; } else { txtbudget_name.ReadOnly = true; txtbudget_name.CssClass = "textboxdis"; chkStatus.Checked = false; } cboYear.Enabled = false; cboYear.CssClass = "textboxdis"; txtUpdatedBy.Text = strUpdatedBy; txtUpdatedDate.Text = strUpdatedDate; #endregion } } } catch (Exception ex) { lblError.Text = ex.Message.ToString(); } }
private bool saveData() { bool blnResult = false; bool blnDup = false; string strMessage = string.Empty; string strbudget_code = string.Empty, strbudget_year = string.Empty, strbudget_name = string.Empty, strActive = string.Empty, strCreatedBy = string.Empty, strUpdatedBy = string.Empty; string strScript = string.Empty; cBudget oBudget = new cBudget(); DataSet ds = new DataSet(); try { #region set Data strbudget_code = txtbudget_code.Text.Trim(); strbudget_name = txtbudget_name.Text; strbudget_year = cboYear.SelectedItem.Value; if (chkStatus.Checked == true) { strActive = "Y"; } else { strActive = "N"; } strCreatedBy = Session["username"].ToString(); strUpdatedBy = Session["username"].ToString(); #endregion if (ViewState["mode"].ToString().ToLower().Equals("edit")) { #region edit if (!blnDup) { if (oBudget.SP_UPD_BUDGET(strbudget_code, strbudget_year, strbudget_name, strActive, strUpdatedBy, this.BudgetType, ref strMessage)) { blnResult = true; } else { lblError.Text = strMessage.ToString(); } } else { ScriptManager.RegisterStartupScript(Page, Page.GetType(), "frMainPage", strScript, true); } #endregion } else { #region check dup string strCheckDup = string.Empty; strCheckDup = " and budget_name = '" + strbudget_name.Trim() + "' and budget_year = '" + strbudget_year + "' "; if (!oBudget.SP_SEL_BUDGET(strCheckDup, ref ds, ref strMessage)) { lblError.Text = strMessage; } else { if (ds.Tables[0].Rows.Count > 0) { strScript = "alert(\"ไม่สามารถเพิ่มข้อมูล เนื่องจากข้อมูล " + strbudget_name.Trim() + " ปี " + strbudget_year.Trim() + " ซ้ำ\");\n"; blnDup = true; } } #endregion #region insert if (!blnDup) { if (oBudget.SP_INS_BUDGET(strbudget_year, strbudget_name, strActive, strCreatedBy, this.BudgetType, ref strMessage)) { string strGetcode = " and budget_name = '" + strbudget_name.Trim() + "' and budget_year = '" + strbudget_year + "' "; if (!oBudget.SP_SEL_BUDGET(strGetcode, ref ds, ref strMessage)) { lblError.Text = strMessage; } if (ds.Tables[0].Rows.Count > 0) { strbudget_code = ds.Tables[0].Rows[0]["budget_code"].ToString(); } ViewState["budget_code"] = strbudget_code; blnResult = true; } else { lblError.Text = strMessage.ToString(); } } else { ScriptManager.RegisterStartupScript(Page, Page.GetType(), "frMainPage", strScript, true); } #endregion } } catch (Exception ex) { lblError.Text = ex.Message.ToString(); } finally { oBudget.Dispose(); } return(blnResult); }