private void InitcboItem_group_detail() { cItem_group_detail oItem_group_detail = new cItem_group_detail(); string strMessage = string.Empty, strCriteria = string.Empty; string strYear = cboYear.SelectedValue; string strItem_group_detail_id = cboItem_group_detail.SelectedValue; string strItem_group_code = cboItem_group.SelectedValue; DataSet ds = new DataSet(); DataTable dt = new DataTable(); strCriteria = " and Item_group_year = '" + strYear + "' and c_active='Y' "; if (!string.IsNullOrEmpty(strItem_group_code)) { strCriteria += " and item_group_code = '" + strItem_group_code + "' "; } if (oItem_group_detail.SP_ITEM_GROUP_DETAIL_SEL(strCriteria, ref ds, ref strMessage)) { dt = ds.Tables[0]; cboItem_group_detail.Items.Clear(); cboItem_group_detail.Items.Add(new ListItem("---- เลือกข้อมูลทั้งหมด ----", "")); int i; for (i = 0; i <= dt.Rows.Count - 1; i++) { cboItem_group_detail.Items.Add(new ListItem(dt.Rows[i]["Item_group_detail_name"].ToString(), dt.Rows[i]["Item_group_detail_id"].ToString())); } if (cboItem_group_detail.Items.FindByValue(strItem_group_detail_id) != null) { cboItem_group_detail.SelectedIndex = -1; cboItem_group_detail.Items.FindByValue(strItem_group_detail_id).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(); HiddenField hdditem_group_detail_id = (HiddenField)GridView1.Rows[e.RowIndex].FindControl("hdditem_group_detail_id"); cItem_group_detail oItem_group_detail = new cItem_group_detail(); try { if (!oItem_group_detail.SP_ITEM_GROUP_DETAIL_DEL(hdditem_group_detail_id.Value, ref strMessage)) { lblError.Text = strMessage; } else { string strScript1 = "RefreshMain('" + ViewState["page"].ToString() + "');"; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "OpenPage", strScript1, true); } } catch (Exception ex) { lblError.Text = ex.Message.ToString(); } finally { oItem_group_detail.Dispose(); } BindGridView(); }
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(); HiddenField hdditem_group_detail_id = (HiddenField)GridView1.Rows[e.RowIndex].FindControl("hdditem_group_detail_id"); cItem_group_detail oItem_group_detail = new cItem_group_detail(); try { if (!oItem_group_detail.SP_ITEM_GROUP_DETAIL_DEL(hdditem_group_detail_id.Value, ref strMessage)) { lblError.Text = strMessage; } } catch (Exception ex) { lblError.Text = ex.Message.ToString(); } finally { oItem_group_detail.Dispose(); } BindGridView(0); }
private bool saveData() { bool blnResult = false; string strMessage = string.Empty; string strScript = string.Empty; Item_group_detail item_group_detail = new Item_group_detail(); cItem_group_detail oItem_group_detail = new cItem_group_detail(); DataSet ds = new DataSet(); try { #region set Data item_group_detail.item_group_detail_id = string.IsNullOrEmpty(hdditem_group_detail_id.Value) ? 0 : int.Parse(hdditem_group_detail_id.Value); item_group_detail.item_group_detail_code = txtitem_group_detail_code.Text.Trim(); item_group_detail.item_group_detail_name = txtitem_group_detail_name.Text.Trim(); item_group_detail.item_group_code = cboItemGroup.SelectedValue; item_group_detail.c_active = chkStatus.Checked == true ? "Y" : "N"; item_group_detail.c_created_by = Session["username"].ToString(); item_group_detail.c_updated_by = Session["username"].ToString(); #endregion string strCheckAdd = " and item_group_detail_id = '" + item_group_detail.item_group_detail_id + "' "; var item = oItem_group_detail.GET(strCheckAdd); if (item != null) { blnResult = oItem_group_detail.SP_ITEM_GROUP_DETAIL_UPD(item_group_detail); } else { blnResult = oItem_group_detail.SP_ITEM_GROUP_DETAIL_INS(item_group_detail); } } catch (Exception ex) { if (ex.Message.Contains("duplicate key")) { strScript = @"ไม่สามารถแก้ไขข้อมูลได้ เนื่องจาก"; if (ex.Message.Contains("IX_item_group_detail_code")) { strScript += "ข้อมูลรหัสรายละเอียดหมวดค่าใช้จ่าย : " + txtitem_group_detail_code.Text + " ซ้ำ"; } else if (ex.Message.Contains("IX_item_group_detail_name")) { strScript += "ข้อมูลรายละเอียดหมวดค่าใช้จ่าย : " + txtitem_group_detail_name.Text + " ซ้ำ"; } MsgBox(strScript); } else { lblError.Text = ex.Message.ToString(); } } finally { oItem_group_detail.Dispose(); } return(blnResult); }
private void setData() { cItem_group_detail oItem_group_detail = new cItem_group_detail(); string strMessage = string.Empty, strCriteria = string.Empty; try { strCriteria = " and item_group_detail_id = '" + ViewState["item_group_detail_id"].ToString() + "' "; var item = oItem_group_detail.GET(strCriteria); if (item != null) { hdditem_group_detail_id.Value = item.item_group_detail_id.ToString(); txtitem_group_detail_code.Text = item.item_group_detail_code; txtitem_group_detail_name.Text = item.item_group_detail_name; InitcboYear(); if (cboYear.Items.FindByValue(item.item_group_year) != null) { cboYear.SelectedIndex = -1; cboYear.Items.FindByValue(item.item_group_year).Selected = true; } InitcboItemGroup(); if (cboItemGroup.Items.FindByValue(item.item_group_code) != null) { cboItemGroup.SelectedIndex = -1; cboItemGroup.Items.FindByValue(item.item_group_code).Selected = true; } chkStatus.Checked = item.c_active == "Y"; //if (strC_active.Equals("Y")) //{ // txtitem_group_detail_name.ReadOnly = false; // txtitem_group_detail_name.CssClass = "textbox"; // chkStatus.Checked = true; //} //else //{ // txtitem_group_detail_name.ReadOnly = true; // txtitem_group_detail_name.CssClass = "textboxdis"; // chkStatus.Checked = false; //} ////cboItemGroup.Enabled = false; ////cboItemGroup.CssClass = "textboxdis"; //cboYear.Enabled = false; //cboYear.CssClass = "textboxdis"; txtUpdatedBy.Text = item.c_updated_by; txtUpdatedDate.Text = item.d_created_date.ToString(); BindGridView(); } } catch (Exception ex) { lblError.Text = ex.Message.ToString(); } }
private void BindGridView() { cItem_group_detail oItem_group_detail = new cItem_group_detail(); DataSet ds = new DataSet(); string strMessage = string.Empty; string strCriteria = string.Empty; string stritem_group_code = string.Empty; stritem_group_code = cboItemGroup.SelectedValue; strCriteria = strCriteria + " And (item_group_code = '" + stritem_group_code + "') "; try { if (!oItem_group_detail.SP_ITEM_GROUP_DETAIL_SEL(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 { oItem_group_detail.Dispose(); ds.Dispose(); } }
private void InitcboItemGroupDetail() { cItem_group_detail oItem_group_detail = new cItem_group_detail(); string strMessage = string.Empty, strCriteria = string.Empty; var strYear = string.Empty; if (this.BudgetType == "B") { strYear = ((DataSet)Application["xmlconfig"]).Tables["default"].Rows[0]["yearnow"].ToString(); } else { strYear = ((DataSet)Application["xmlconfig"]).Tables["default"].Rows[0]["yearnow2"].ToString(); } string strItem_group_detail_id = cboItem_group_detail.SelectedValue; string strItem_group_code = cboItem_group.SelectedValue; DataSet ds = new DataSet(); DataTable dt = new DataTable(); strCriteria = " and Item_group_year = '" + strYear + "' and c_active='Y' And Item_group_code ='" + strItem_group_code + "' "; if (oItem_group_detail.SP_ITEM_GROUP_DETAIL_SEL(strCriteria, ref ds, ref strMessage)) { dt = ds.Tables[0]; cboItem_group_detail.Items.Clear(); cboItem_group_detail.Items.Add(new ListItem("---- เลือกข้อมูลทั้งหมด ----", "")); int i; for (i = 0; i <= dt.Rows.Count - 1; i++) { cboItem_group_detail.Items.Add(new ListItem(dt.Rows[i]["Item_group_detail_name"].ToString(), dt.Rows[i]["Item_group_detail_id"].ToString())); } if (cboItem_group_detail.Items.FindByValue(strItem_group_detail_id) != null) { cboItem_group_detail.SelectedIndex = -1; cboItem_group_detail.Items.FindByValue(strItem_group_detail_id).Selected = true; } } }
private void BindGridView(int nPageNo) { InitcboYear(); InitcboItem_group(); cItem_group_detail oitem_group_detail = new cItem_group_detail(); DataSet ds = new DataSet(); string strMessage = string.Empty; string strCriteria = string.Empty; string stritem_group_detail_code = string.Empty; string stritem_group_detail_name = string.Empty; string strItem_group_code = string.Empty; string strActive = string.Empty; string stritem_group_year = string.Empty; stritem_group_detail_code = txtitem_group_detail_code.Text.Replace("'", "''").Trim(); stritem_group_detail_name = txtitem_group_detail_name.Text.Replace("'", "''").Trim(); stritem_group_year = cboYear.SelectedValue; strItem_group_code = cboItem_group.SelectedValue; if (!stritem_group_detail_code.Equals("")) { strCriteria = strCriteria + " And (item_group_detail_code like '%" + stritem_group_detail_code + "%') "; } if (!stritem_group_detail_name.Equals("")) { strCriteria = strCriteria + " And (item_group_detail_name like '%" + stritem_group_detail_name + "%')"; } if (!stritem_group_year.Equals("")) { strCriteria = strCriteria + " And (item_group_year = '" + stritem_group_year + "') "; } if (!strItem_group_code.Equals("")) { strCriteria = strCriteria + " And (Item_group_code = '" + strItem_group_code + "') "; } if (RadioActive.Checked) { strCriteria = strCriteria + " And (c_active ='Y') "; } else if (RadioCancel.Checked) { strCriteria = strCriteria + " And (c_active ='N') "; } try { if (!oitem_group_detail.SP_ITEM_GROUP_DETAIL_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 { oitem_group_detail.Dispose(); ds.Dispose(); if (GridView1.Rows.Count > 0) { GridView1.TopPagerRow.Visible = true; } } }