protected void BtnUpdate_Click(object sender, EventArgs e) { string sql = ""; int tt = 0; ClUserPermission cl = new ClUserPermission(); for (int i = 0; i < GridView1.Rows.Count - 1; i++) { GridViewRow gr = GridView1.Rows[i]; Label lblup = (Label)gr.FindControl("LblUpID"); CheckBox chview = (CheckBox)gr.FindControl("chview"); CheckBox chInsert = (CheckBox)gr.FindControl("chInsert"); CheckBox chUpdate = (CheckBox)gr.FindControl("chUpdate"); CheckBox chDel = (CheckBox)gr.FindControl("chDel"); cl.UserPermissinID = Convert.ToInt32(lblup.Text); cl.CanView = chview.Checked; cl.CanUpdate = chUpdate.Checked; cl.CanInsert = chInsert.Checked; cl.CanDel = chDel.Checked; tt += UserPermissionClass.Update(cl); // sql += "update Tbl_UserPermission set CanDel=" + CSharp.PublicFunction.BTS(chDel.Checked) + ",CanInsert=" + CSharp.PublicFunction.BTS(chInsert.Checked) + ",CanUpdate=" + CSharp.PublicFunction.BTS(chUpdate.Checked) + ",CanView=" + CSharp.PublicFunction.BTS(chUpdate.Checked) + " where UserPermissinID=" + lblup.Text + ""; } if (tt != 0) { BindGrid(); } else { ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), Guid.NewGuid().ToString(), "alert('خطا در ویرایش');", true); } }
protected void BtnInsert_Click(Object sender, System.EventArgs e) { ClUserPermission cl = Data; int t = 0; if (CSharp.PublicFunction.ModeInsert(cl.UserPermissinID.ToString())) { t = UserPermissionClass.insert(cl); } else { t = UserPermissionClass.Update(cl); } if (t == 0) { LblMsg.ForeColor = System.Drawing.Color.Red; LblMsg.Text = "خطا در ثبت"; } else { LblMsg.ForeColor = System.Drawing.Color.Green; LblMsg.Text = "ثبت انجام شد."; BindPermission(); BindGrid(); } }
public void UpItem(object sender, EventArgs e) { String UserPermissinID = ((HtmlAnchor)sender).HRef.ToString(); ClUserPermission cl = new ClUserPermission(); cl.UserPermissinID = Convert.ToInt32(UserPermissinID); Data = cl; LightBox.Value = "1"; }
private void BindPermission() { ClUserPermission cl = new ClUserPermission(); cl.UserID = Convert.ToInt32(DDUserID.SelectedValue); DDPermissionID.DataSource = UserPermissionClass.GetUserNotPermission(cl); DDPermissionID.DataTextField = "PermissianName"; DDPermissionID.DataValueField = "PermissionID"; DDPermissionID.DataBind(); }
//--------------------------------------------------------------------------------------------------------- public static DataSet GetList(ClUserPermission c) { SqlCommand cmd = new SqlCommand("PRC_UserPermission_GetList", cnn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("PageIndex", SqlDbType.NVarChar)).Value = c.PageIndex; cmd.Parameters.Add(new SqlParameter("PageSize", SqlDbType.NVarChar)).Value = c.PageSize; cmd.Parameters.Add(new SqlParameter("Order", SqlDbType.NVarChar)).Value = c.OrderDirection; cmd.Parameters.Add(new SqlParameter("OrderBy", SqlDbType.NVarChar)).Value = c.OrderBy; cmd.Parameters.Add(new SqlParameter("UserPermissinID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.UserPermissinID); cmd.Parameters.Add(new SqlParameter("UserID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.UserID); cmd.Parameters.Add(new SqlParameter("PermissionID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.PermissionID); cmd.Parameters.Add(new SqlParameter("CanView", SqlDbType.Bit)).Value = Securenamespace.SecureData.CheckSecurity(c.CanView); cmd.Parameters.Add(new SqlParameter("CanUpdate", SqlDbType.Bit)).Value = Securenamespace.SecureData.CheckSecurity(c.CanUpdate); cmd.Parameters.Add(new SqlParameter("CanDel", SqlDbType.Bit)).Value = Securenamespace.SecureData.CheckSecurity(c.CanDel); cmd.Parameters.Add(new SqlParameter("CanInsert", SqlDbType.Bit)).Value = Securenamespace.SecureData.CheckSecurity(c.CanInsert); cmd.Parameters.Add(new SqlParameter("PageName", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.PageName); SqlParameter prmResult = new SqlParameter("Result", SqlDbType.Int); prmResult.Direction = ParameterDirection.Output; cmd.Parameters.Add(prmResult); DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(cmd); try { cnn.Open(); da.Fill(ds); return(ds); } catch (Exception ex) { return(null); } finally { cnn.Close(); } }
public static int insert(ClUserPermission c) { SqlCommand cmd = new SqlCommand("PRC_UserPermission_Insert", cnn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("UserIDLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetUserID(); cmd.Parameters.Add(new SqlParameter("IpLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetIPAddress(); cmd.Parameters.Add(new SqlParameter("OSLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetOS(); cmd.Parameters.Add(new SqlParameter("OSVerLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetBrowser() + CSharp.PublicFunction.GetBrowserVersion(); cmd.Parameters.Add(new SqlParameter("URLLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetURL(); cmd.Parameters.Add(new SqlParameter("UserID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.UserID); cmd.Parameters.Add(new SqlParameter("PermissionID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.PermissionID); cmd.Parameters.Add(new SqlParameter("CanView", SqlDbType.Bit)).Value = Securenamespace.SecureData.CheckSecurity(c.CanView); cmd.Parameters.Add(new SqlParameter("CanUpdate", SqlDbType.Bit)).Value = Securenamespace.SecureData.CheckSecurity(c.CanUpdate); cmd.Parameters.Add(new SqlParameter("CanDel", SqlDbType.Bit)).Value = Securenamespace.SecureData.CheckSecurity(c.CanDel); cmd.Parameters.Add(new SqlParameter("CanInsert", SqlDbType.Bit)).Value = Securenamespace.SecureData.CheckSecurity(c.CanInsert); SqlParameter prmResult = new SqlParameter("Result", SqlDbType.Int); prmResult.Direction = ParameterDirection.Output; cmd.Parameters.Add(prmResult); try { cnn.Open(); cmd.ExecuteNonQuery(); return(Convert.ToInt32(prmResult.Value)); } catch (Exception ex) { return(0); } finally { cnn.Close(); } }
public void BindGrid() { ClUserPermission cl = new ClUserPermission(); cl.UserID = Convert.ToInt32(DDUserID.SelectedValue); DataSet ds = UserPermissionClass.GetList(cl); DataView dv = new DataView(ds.Tables[0]); if (ViewState["UserPermission"] == null) { ViewState["UserPermission"] = "UserPermissinID Desc"; } dv.Sort = Securenamespace.SecureData.CheckSecurity(ViewState["UserPermission"].ToString()).ToString(); GridView1.DataSource = dv; GridView1.DataBind(); if (GridView1.Rows.Count > 0) { BtnUpdate.Visible = true; } else { BtnUpdate.Visible = false; } }