public void BindGrid() { DataSet ds = AgeCalculationClass.GetList(null, null, null, null, null, null); DataView dv = new DataView(ds.Tables[0]); //if (Securenamespace.SecureData.CheckSecurity(ViewState["AgeCalculation"].ToString()) == null) //{ // ViewState["AgeCalculation"] = "id Desc"; //} //dv.Sort = Securenamespace.SecureData.CheckSecurity(ViewState["AgeCalculation"].ToString()).ToString(); GridView1.DataSource = dv; GridView1.DataBind(); }
protected void BtnSerach_Click1(object sender, EventArgs e) { DataSet ds = AgeCalculationClass.GetList(null, TXTGroupAge.Text, TXTBonSize.Text, DDAgeTypeId.SelectedValue.ToString(), DDTreeType.SelectedValue.ToString(), DDyear.SelectedValue.ToString());// null, null, null,null ); DataView dv = new DataView(ds.Tables[0]); //String StrSort = Securenamespace.SecureData.CheckSecurity(ViewState["AgeCalculation"].ToString()); //if (StrSort != null) //{ // dv.Sort = StrSort; //} GridView1.DataSource = dv; GridView1.DataBind(); }
public void DeleteItem(object sender, System.EventArgs e) { String id = ((HtmlAnchor)sender).HRef.ToString(); int i = AgeCalculationClass.Delete(Convert.ToInt32(id)); if (i == 0) { LblMsg.Text = " error "; ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), Guid.NewGuid().ToString(), "alert('خطا در حذف');", true); } else { BindGrid(); } LightBox.Value = "0"; }
protected void BtnUpdate_Click1(object sender, EventArgs e) { int i = AgeCalculationClass.Update(TXTid.Text, TXTGroupAge.Text, TXTBonSize.Text, DDAgeTypeId.SelectedValue.ToString(), DDTreeType.SelectedValue.ToString(), DDyear.SelectedValue.ToString()); if (i == 0) { LblMsg.ForeColor = System.Drawing.Color.Red; LblMsg.Text = "خطا"; } else { LblMsg.ForeColor = System.Drawing.Color.Green; LblMsg.Text = "ویرایش انجام شد"; BindGrid(); } }
protected void BtnInsert_Click(Object sender, System.EventArgs e) { int t = AgeCalculationClass.insert(TXTGroupAge.Text, TXTBonSize.Text, DDAgeTypeId.SelectedValue.ToString(), DDTreeType.SelectedValue.ToString(), DDyear.SelectedValue.ToString()); if (t == 0) { LblMsg.ForeColor = System.Drawing.Color.Red; LblMsg.Text = "خطا در ثبت"; } else { LblMsg.ForeColor = System.Drawing.Color.Green; LblMsg.Text = "ثبت انجام شد."; BindGrid(); } }
public void UpItem(object sender, EventArgs e) { String id = ((HtmlAnchor)sender).HRef.ToString(); DataSet ds = AgeCalculationClass.GetList(null, null, null, null, null, null); DataRow dr = ds.Tables[0].Rows[0]; TXTid.Text = id; TXTBonSize.Text = dr["BonSize"].ToString(); TXTGroupAge.Text = dr["GroupAge"].ToString(); DDyear.SelectedValue = dr["year"].ToString(); DDTreeType.SelectedValue = dr["TreeType"].ToString(); DDAgeTypeId.SelectedValue = dr["AgeTypeId"].ToString(); EmptyLight(); LightBox.Value = "1"; BtnInsert.Visible = false; BtnSerach.Visible = false; BtnUpdate.Visible = true; }