protected void SaveRight(object sender, EventArgs e) { string result = "-1"; string Permission = ""; string SelectVaue = ListChoice.SelectedValue; string AllPermission = ""; if (ckRead.Checked) { Permission = "1"; //可读 AllPermission = AllPermission + Permission + ","; } if (ckWrite.Checked) { Permission = "2"; //可写 AllPermission = AllPermission + Permission + ","; } if (ckDelete.Checked) { Permission = "3"; //可删除 AllPermission = AllPermission + Permission + ","; } if (ckCancel.Checked) // 可作废 { Permission = "4"; AllPermission = AllPermission + Permission + ","; } if (SelectVaue == "1") { DocUserRight _docUser = new DocUserRight(); _docUser.UserID = Int32.Parse(MyList.SelectedValue); _docUser.FolderID = FolderId; _docUser.Permission = AllPermission; if (DbHelper.GetInstance().GetFolderPermissFromID(Int32.Parse(MyList.SelectedValue), FolderId).Rows.Count > 0) result = DbHelper.GetInstance().UpDateFolderPermission(_docUser); else result = DbHelper.GetInstance().AddNewsFolderPermission(_docUser); } else if (SelectVaue == "2") { DocDepartRight _docDepartRight = new DocDepartRight(); _docDepartRight.DepartMentID = Int32.Parse(MyList.SelectedValue); _docDepartRight.FolderID = FolderId; _docDepartRight.Permission = AllPermission; if (DbHelper.GetInstance().GetFolderPermissFromDepart(Int32.Parse(MyList.SelectedValue), FolderId).Rows.Count > 0) result = DbHelper.GetInstance().UpDateFolderPermissionByDepart(_docDepartRight); else result = DbHelper.GetInstance().AddNewFolderPermissionByDepart(_docDepartRight); } else if (SelectVaue == "3") { DocSysRoleRight _docSysRoleRight = new DocSysRoleRight(); _docSysRoleRight.SysRoldID = Int32.Parse(MyList.SelectedValue); _docSysRoleRight.FolderID = FolderId; _docSysRoleRight.Permission = AllPermission; if (DbHelper.GetInstance().GetFolderPermissFromSysRole(Int32.Parse(MyList.SelectedValue), FolderId).Rows.Count > 0) result = DbHelper.GetInstance().UpDateFolderPermissionBySysRole(_docSysRoleRight); else result = DbHelper.GetInstance().AddNewFolderPermissionBySysRole(_docSysRoleRight); } if (result != "-1") { lblMsg.Text = "数据保存成功"; lblMsg.ForeColor = System.Drawing.Color.Blue; } else { lblMsg.Text = "数据保存失败"; lblMsg.ForeColor = System.Drawing.Color.Red; } }
public string AddNewsFolderPermission(DocUserRight _DocUserRight) { DbParameter[] pramsInsert = { MakeInParam("@UserSerialID",(DbType)SqlDbType.Int,4,_DocUserRight.UserID), MakeInParam("@FolderID",(DbType)SqlDbType.Int,4,_DocUserRight.FolderID), MakeInParam("@Permission",(DbType)SqlDbType.VarChar,50,_DocUserRight.Permission), }; StringBuilder sb = new StringBuilder(); sb.Append("INSERT INTO [dbo].[Doc_UserRight]"); sb.Append("([UserSerialID]"); sb.Append(",[FolderID]"); sb.Append(",[Permission]"); sb.Append(")"); sb.Append("VALUES"); sb.Append("(@UserSerialID"); sb.Append(",@FolderID"); sb.Append(",@Permission"); sb.Append(")"); sb.Append(" select @@identity;"); return ExecuteScalar(CommandType.Text, sb.ToString(), pramsInsert).ToString(); }
public bool LoadChildNode(TreeNode node, string path) { if (Directory.Exists(path) == false) { return false; } DirectoryInfo dirInfo = new DirectoryInfo(path); int allNum = dirInfo.GetDirectories().Length + dirInfo.GetFiles("*.*").Length; if (allNum == 0) { TreeNode empty = new TreeNode(); empty.Text = "(空白)"; empty.Value = ""; empty.ImageUrl = ""; node.ChildNodes.Add(empty); return false; } foreach (DirectoryInfo folder in dirInfo.GetDirectories()) { if (folder.Name != "FileTemp") { int FolderId = 0; TreeNode folderNode = new TreeNode(); DocFolderRight _docFolder = new DocFolderRight(); _docFolder.FolderName = folder.Name; _docFolder.FullFolderName = folder.FullName; DataTable dtt = DbHelper.GetInstance().GetFolderFromName(folder.FullName); if (dtt.Rows.Count == 0) { //if (RootID == 0) // _docFolder.FatherID = RootID; //else //{ //int iLast = path.LastIndexOf('\\')+1; //path = path.Substring(iLast); DataTable dt = DbHelper.GetInstance().GetFolderFromName(path); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) _docFolder.FatherID = Int16.Parse(dt.Rows[i]["FolderSerialID"].ToString()); } // } FolderId = DbHelper.GetInstance().AddNewsFolder(_docFolder); ArrayList arylst = GetSearchParameter(); DataTable dtUser = DbHelper.GetInstance().sp_userList_1(arylst, 200, 1); for (int i = 0; i < dtUser.Rows.Count; i++) { // UserList.Items.Add(new ListItem(dt.Rows[i]["UserID"].ToString() + "--" + dt.Rows[i]["UserName"].ToString(), dt.Rows[i]["UserSerialID"].ToString())); DocUserRight _docUser = new DocUserRight(); _docUser.FolderID = FolderId; _docUser.UserID = Int16.Parse(dtUser.Rows[i]["UserSerialID"].ToString()); _docUser.Permission = "0"; DbHelper.GetInstance().AddNewsFolderPermission(_docUser); } } else { FolderId = Int16.Parse(dtt.Rows[0]["FolderSerialID"].ToString()); } folderNode.Text = folder.Name; folderNode.Value = folder.FullName; folderNode.ToolTip = folder.Name; folderNode.PopulateOnDemand = true; folderNode.NavigateUrl = "javascript:SetPermission('" + FolderId + "')"; node.ChildNodes.Add(folderNode); } // TraversingCatalog(tn.ChildNodes[folderIndex], path + "/" + folder.Name); //递归遍历其它文件夹 } //foreach (FileInfo file in dirInfo.GetFiles("*.*")) //{ // TreeNode fileNode = new TreeNode(); // fileNode.Text = file.Name; // fileNode.Value = file.FullName; // string pathName = file.FullName.Replace("\\", "/"); // fileNode.ToolTip = file.Name; // fileNode.Expanded = false; // fileNode.NavigateUrl = "javascript:GetValue('" + pathName + "')"; // node.ChildNodes.Add(fileNode); //} return true; }
public string UpDateFolderPermission(DocUserRight _DocUserRight) { DbParameter[] pramsUpDate = { MakeInParam("@UserSerialID",(DbType)SqlDbType.Int,4,_DocUserRight.UserID), MakeInParam("@FolderID",(DbType)SqlDbType.Int,4,_DocUserRight.FolderID), MakeInParam("@Permission",(DbType)SqlDbType.VarChar,50,_DocUserRight.Permission), }; StringBuilder sb = new StringBuilder(); sb.Append("UpDate [dbo].[Doc_UserRight]"); sb.Append(" set "); sb.Append(" [UserSerialID]=@UserSerialID,"); sb.Append(" [FolderID]=@FolderID,"); sb.Append(" [Permission]=@Permission"); sb.Append(" where [UserSerialID]=@UserSerialID and [FolderID]=@FolderID"); sb.Append(" select @UserSerialID "); return ExecuteScalar(CommandType.Text, sb.ToString(), pramsUpDate).ToString(); }