📄 listview.aspx.cs
字号:
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using UDS.Components;
namespace UDS.SubModule.UnitiveDocument.Document
{
/// <summary>
/// ListView 的摘要说明。
/// </summary>
public class ListView : System.Web.UI.Page
{
protected HttpCookie UserCookie;
protected static string Username;
protected string ClassID;
protected System.Web.UI.WebControls.DataGrid dgDocList;
protected string DisplayType="";
protected static string SortRule="Desc",SortBy="DocAddedDate";
protected System.Web.UI.WebControls.Label lblShowMember;
protected System.Web.UI.WebControls.Label lblManageDirectory;
protected System.Web.UI.WebControls.Label lblDeliveryDoc;
protected System.Web.UI.WebControls.Label lblManagePermission;
protected System.Web.UI.WebControls.Label lblRemove;
protected System.Web.UI.WebControls.Label lblCopy;
protected System.Web.UI.WebControls.LinkButton lnkbtnDelete;
private void Page_Load(object sender, System.EventArgs e)
{
ClassID = (Request.QueryString["ClassID"]!=null)?Request.QueryString["ClassID"].ToString():"";
DisplayType = (Request.QueryString["DisplayType"]!=null)?Request.QueryString["DisplayType"].ToString():"0";
UserCookie = Request.Cookies["Username"];
Username = UserCookie.Value.ToString();
this.lnkbtnDelete.Attributes ["onclick"]="javascript:return confirm('您确认要丢弃吗?');";
if(!IsPostBack)
{
BindGrid();
ShowAvailable();
}
}
#region 数据绑定至DataGrid
/// <summary>
/// 将某用户的邮件取出绑定至DataGrid
/// </summary>
protected void BindGrid()
{
UserCookie = Request.Cookies["Username"];
string Username = UserCookie.Value.ToString();
DocumentClass doc = new DocumentClass();
SqlDataReader dr = doc.GetDocListInClass(Int32.Parse(ClassID),Username,Int32.Parse(DisplayType));
DataTable datatable = Tools.ConvertDataReaderToDataTable(dr);
DataView source = datatable.DefaultView;
source.Sort = SortBy+" "+ SortRule;
dgDocList.DataSource = source;
dgDocList.DataBind();
//
// if (datatable.Rows.Count !=0)
// {
// this.lnkbtnDelete.Visible =true;
//
// }
doc = null;
datatable = null;
}
#endregion
#region 翻页事件
public void DataGrid_PageChanged(object sender,DataGridPageChangedEventArgs e)
{
dgDocList.CurrentPageIndex = e.NewPageIndex;
BindGrid();
// ShowAvailable();
}
#endregion
#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN:该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.lnkbtnDelete.Click += new System.EventHandler(this.lnkbtnDelete_Click);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
#region 将数据排序
/// <summary>
/// 将信件按照指定字段进行排序
/// </summary>
protected void DataGrid_Sort(Object Src, DataGridSortCommandEventArgs E)
{
SortRule = (SortRule=="Desc")?"Asc":"Desc";
SortBy = E.SortExpression ;
DocumentClass doc = new DocumentClass();
DataTable datatable = Tools.ConvertDataReaderToDataTable(doc.GetDocListInClass(Int32.Parse(ClassID),Username,Int32.Parse(DisplayType)));
DataView Source = datatable.DefaultView;
Source.Sort = SortBy+" "+ SortRule;
doc = null;
dgDocList.DataSource = Source;
dgDocList.DataBind();
}
#endregion
#region 根据权限显示相关功能标题
// 设置缺省值
public void ShowAvailable()
{
ProjectClass pjt = new ProjectClass ();
UserCookie = Request.Cookies["Username"];
string Username = UserCookie.Value.ToString();
int classID = Int32.Parse(ClassID);
int cstRightToApproveDocument = 2;
int cstRightToViewDocument = 10;
int cstRightToBuildNode = 5;
int cstDisplayMember = 6;
int cstTeamRight = 7;
int cstComposeMail = 11;
int cstDeliveryDoc = 11;
int cstProjectMove = 12;
int cstProjectCopy = 12;
int cstDeleteDocument = 3;
this.lblManageDirectory.Visible = pjt.GetAccessPermission(classID,Username,cstRightToBuildNode);
this.lblDeliveryDoc.Visible = pjt.GetAccessPermission(classID,Username,cstDeliveryDoc);
this.lblShowMember.Visible = pjt.GetAccessPermission(classID,Username,cstDisplayMember);
this.lblManagePermission.Visible= pjt.GetAccessPermission(classID,Username,cstTeamRight);
this.lnkbtnDelete.Visible = pjt.GetAccessPermission(classID,Username,cstDeleteDocument);
this.lblRemove .Visible = pjt.GetAccessPermission(classID,Username,cstProjectMove);
this.lblCopy .Visible = pjt.GetAccessPermission(classID,Username,cstProjectMove);
pjt = null;
}
#endregion
private void lnkbtnDelete_Click(object sender, System.EventArgs e)
{
DocumentClass doc = new DocumentClass();
bool sqlFlag = true;
string sql = "";
foreach(DataGridItem dgi in dgDocList.Items)
{
CheckBox cb=(CheckBox)(dgi.Cells[0].Controls[1]);
if (cb.Checked==true)
{
int i = dgi.ItemIndex;
string id = dgDocList.DataKeys[i].ToString();
if (sqlFlag)
{
sql+=id;
sqlFlag=false;
}
else
{
sql+=" ,";
sql+=id;
}
}
}
//选择为空
if( sql==String.Empty)
{
Response.Write("<script language=javascript>alert('请选择文档!');window.location='ListView.aspx?ClassID="+ClassID+"';</script>");
}
else
{
int deleteFlag = DisplayType.ToString()=="3"?1:0;
if(doc.DocDelete(sql,deleteFlag))
{
Response.Write("<script language=javascript>alert('文档丢弃成功!');window.location='ListView.aspx?ClassID="+ClassID+"';</script>");
}
else
{
Server.Transfer("../../Error.aspx");
}
}
doc=null;
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -