int pageSize = 50;//SystemSet._PAGESIZE;
protected void Page_Load(object sender, EventArgs e)
{
Ajax.Utility.RegisterTypeForAjax(typeof(Zxyys));
singleProjectID = DNTRequest.GetQueryString("SingleProjectID");
workFlowID = DNTRequest.GetQueryString("WorkFlowID");
if (!IsPostBack)
{
if (!PublicModel.isCompany() || PublicModel.isLeader())
{
ddlCompany.DataBindEx(singleProjectID, string.Concat(SystemSet._JSCOMPANYINFO, ",",
SystemSet._JLCOMPANYINFO, ",", SystemSet._SGCOMPANYINFO));
}
else
{
ddlCompany.DataBindEx(singleProjectID, Common.Session.GetSessionInt("CompanyID"));
}
ctrlProjectBaseInfo1.DataBindEx(singleProjectID); //工程信息
rdbFileStatus.DataBindEx(true);
ddlFileType.DataBindEx(Common.ConvertEx.ToInt(singleProjectID), "0", "BH");
if (!String.IsNullOrWhiteSpace(DNTRequest.GetQueryString("ddlCompany")))
{
ddlCompany.SelectValue = Server.UrlDecode(DNTRequest.GetQueryString("ddlCompany"));
}
if (!String.IsNullOrWhiteSpace(DNTRequest.GetQueryString("ddlChangeFile")))
{
ddlChangeFile.SelectedValue = Server.UrlDecode(DNTRequest.GetQueryString("ddlChangeFile"));
}
if (!String.IsNullOrWhiteSpace(DNTRequest.GetQueryString("ddlFileType")))
{
ddlFileType.SelectValue = Server.UrlDecode(DNTRequest.GetQueryString("ddlFileType")).ToUpper();
}
if (!String.IsNullOrWhiteSpace(DNTRequest.GetQueryString("txtTitle")))
{
txtTitle.Text = Server.UrlDecode(DNTRequest.GetQueryString("txtTitle"));
}
if (!String.IsNullOrWhiteSpace(DNTRequest.GetQueryString("txtMyCode")))
{
txtMyCode.Text = Server.UrlDecode(DNTRequest.GetQueryString("txtMyCode"));
}
if (!String.IsNullOrWhiteSpace(DNTRequest.GetQueryString("fileStatus")))
{
rdbFileStatus.SelectValue = Server.UrlDecode(DNTRequest.GetQueryString("fileStatus"));
}
BindGridView(1);
}
}
/// <summary>
/// 绑定工程下所有业务单位
/// </summary>
protected void ddlSingleProject_MySelectChanged()
{
if (ddlSingleProject.SelectValue != "")
{
if (PublicModel.isLeader() || !PublicModel.isCompany())
{
ddlCompany.DataBindEx(ddlSingleProject.SelectValue, string.Concat(SystemSet._JSCOMPANYINFO, ",",
SystemSet._JLCOMPANYINFO, ",", SystemSet._SGCOMPANYINFO));
}
else
{
ddlCompany.DataBindEx(ddlSingleProject.SelectValue, Common.Session.GetSessionInt("CompanyID"));
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
//ddlCompany.MySelectChange += new DigiPower.Onlinecol.Standard.Web.CommonCtrl.ctrlDropDownCompanyInfo.SelectChange(ddlCompany_SelectedIndexChanged);
Ajax.Utility.RegisterTypeForAjax(typeof(ZJList));
singleProjectID = DNTRequest.GetQueryString("SingleProjectID");
workFlowID = DNTRequest.GetQueryString("WorkFlowID");
projectType = DNTRequest.GetQueryString("ProjectType");
if (!this.IsPostBack)
{
if (!PublicModel.isCompany() || PublicModel.isLeader())
{
ddlCompany.DataBindEx(singleProjectID, string.Concat(SystemSet._JSCOMPANYINFO, ",",
SystemSet._JLCOMPANYINFO, ",", SystemSet._SGCOMPANYINFO));
}
else
{
ddlCompany.DataBindEx(singleProjectID, Common.Session.GetSessionInt("CompanyID"));
}
ctrlProjectBaseInfo1.DataBindEx(singleProjectID); //工程信息
string CompanyID = Common.Session.GetSession("CompanyID");
if (CompanyID != "")
{
ddlCompany.SelectValue = CompanyID;
DataBindExMyCode(null);
}
boxType.DataBindEx();
ajlx.DataBindEx();
//mj.DataBindEx();
//bgqx.DataBindEx();
BindFileList();
BindTreeYZJ();
}
}
/// <summary>
/// 绑定归档目录
/// </summary>
/// <param name="pageIndex"></param>
private void BindGridView(int pageIndex)
{
T_SingleProject_MDL spMDL = spBLL.GetModel(Common.ConvertEx.ToInt(singleProjectID));
if (spMDL != null)
{
projectType = spMDL.ProjectType;
string strWhere = " SingleProjectID=" + singleProjectID;
strWhere += " AND BH not like '%S%' "; //不显示声像节点
if (PublicModel.isSuperAdmin() || !PublicModel.isCompany()) //Leo 超级管理员看全部
{
}
else if (spMDL != null && spMDL.CompanyUserID == Common.ConvertEx.ToInt(Common.Session.GetSession("UserID"))) //Leo 工程管理员也看全部,档案馆的人也可以看全部
{
}
else
{
strWhere += " AND operateuserid=" + Common.Session.GetSession("UserID");
}
if (!String.IsNullOrWhiteSpace(txtMyCode.Text.Trim()))
{
strWhere += " AND MyCode LIKE '%" + txtMyCode.Text.Trim() + "%'";
}
if (!String.IsNullOrWhiteSpace(txtTitle.Text.Trim()))
{
strWhere += " AND TITLE LIKE '%" + txtTitle.Text.Trim() + "%'";
}
if (!String.IsNullOrWhiteSpace(rdbFileStatus.SelectValue) && rdbFileStatus.SelectValue != "0")
{
strWhere += " AND Status=" + rdbFileStatus.SelectValue;
}
if (!String.IsNullOrWhiteSpace(ddlCompany.SelectValue) && ddlCompany.SelectValue != "0")
{
T_Company_BLL compBLL = new T_Company_BLL();
T_Company_MDL compMDL = compBLL.GetModel(ConvertEx.ToInt(ddlCompany.SelectValue));
if (compMDL != null)
{
strWhere += " AND DefaultCompanyType=" + compMDL.CompanyType + "";
}
}
if (!String.IsNullOrWhiteSpace(ddlFileType.SelectValue) && ddlFileType.SelectValue != "0")
{
strWhere += " AND BH like '" + ddlFileType.SelectValue + "%' ";
}
if (!String.IsNullOrWhiteSpace(ddlChangeFile.SelectedValue))
{
var changeFile = ddlChangeFile.SelectedValue;
if (changeFile == "1") //有变更
{
strWhere += " AND ISNULL(version,0)=(SELECT TOP 1 ISNULL(f.RollBackCount,0)from T_WorkFlowDefine f where f.SingleProjectID=" + singleProjectID + " ";
strWhere += "AND f.WorkFlowID=" + PublicModel.getWorkFlowIdByWorkFlowCode(SystemSet.EumWorkFlowCode.FILEREG.ToString()) + ") ";
}
if (changeFile == "0") //无变更
{
strWhere += " AND ISNULL(version,0) !=(SELECT TOP 1 ISNULL(f.RollBackCount,0)from T_WorkFlowDefine f where f.SingleProjectID=" + singleProjectID + " ";
strWhere += "AND f.WorkFlowID=" + PublicModel.getWorkFlowIdByWorkFlowCode(SystemSet.EumWorkFlowCode.FILEREG.ToString()) + ") ";
}
}
if (ViewState["CurrentPageIndex"] == null && Common.ConvertEx.ToInt(DNTRequest.GetQueryString("PageIndex")) > 0)
{
pageIndex = Common.ConvertEx.ToInt(DNTRequest.GetQueryString("PageIndex"));
ViewState["CurrentPageIndex"] = pageIndex;
}
else
{
pageIndex = ConvertEx.ToInt(ViewState["CurrentPageIndex"]);
}
DataTable dt = fileListBLL.GetListPaging(strWhere, pageSize, pageIndex, out itemCount);
AspNetPager.AlwaysShow = true;
AspNetPager.PageSize = pageSize;
AspNetPager.RecordCount = itemCount;
AspNetPager.CurrentPageIndex = pageIndex;
rpData.DataSource = dt;
rpData.DataBind();
}
}
//绑定归档目录
private void BindGridView(int pageIndex)
{
T_SingleProject_MDL spMDL = spBLL.GetModel(Common.ConvertEx.ToInt(singleProjectID));
if (spMDL != null)
{
singleProjectNo = spMDL.gcbm;
projecttype = spMDL.ProjectType;
//取当前工程的所有归档目录
string strWhere = " SingleProjectID=" + singleProjectID;
//不显示声像节点 //jdk 2014.11.16
strWhere += " AND BH not like '%S%' ";
if (PublicModel.isCompany() && !PublicModel.isLeader()) //监理或施工只能看到自己的
{
strWhere += " and operateuserid=" + Common.Session.GetSession("UserID");
}
if (ConvertEx.ToBool(SystemSet._ISIGNATUREPDF))
{
if (!string.IsNullOrWhiteSpace(ddliSignaturePdf.SelectedValue))
{
strWhere += " AND iSignaturePdf=" + ddliSignaturePdf.SelectedValue + ""; //是否需要签章
}
if (!string.IsNullOrWhiteSpace(ddlSignatureFinishFlag.SelectedValue)) //签章完成状态
{
string tempStrWhere = " and iSignaturePdf=1 and IsFolder=0 and (SELECT COUNT(1) from T_FileList_SignatureTmp f1 where f1.FileListID=T_FileList.OldRecID)>0 ";
int signatureFinishFlag = ConvertEx.ToInt(ddlSignatureFinishFlag.SelectedValue); //签章是否完成标记 那已签章完成的记录跟需要签章的记录比对.
if (signatureFinishFlag == 1) //签章完成
{
tempStrWhere += "and (SELECT COUNT(1) from T_FileList_SignatureLog f0 where f0.FileListID=T_FileList.FileListID and f0.SignatureFinishFlag=1)";
tempStrWhere += ">=(SELECT COUNT(1) from T_FileList_SignatureTmp f1 where f1.FileListID=T_FileList.OldRecID) ";
strWhere += tempStrWhere;
}
else if (signatureFinishFlag == 0) //签章未完成
{
tempStrWhere += "and (SELECT COUNT(1) from T_FileList_SignatureLog f0 where f0.FileListID=T_FileList.FileListID and f0.SignatureFinishFlag=1)";
tempStrWhere += "<(SELECT COUNT(1) from T_FileList_SignatureTmp f1 where f1.FileListID=T_FileList.OldRecID) ";
strWhere += tempStrWhere;
}
}
}
if (!String.IsNullOrWhiteSpace(txtMyCode.Text.Trim()))
{
strWhere += " AND MyCode LIKE '%" + txtMyCode.Text.Trim() + "%'";
}
if (!String.IsNullOrWhiteSpace(txtTitle.Text.Trim()))
{
strWhere += " AND TITLE LIKE '%" + txtTitle.Text.Trim() + "%'";
}
if (!String.IsNullOrWhiteSpace(rdbFileStatus.SelectValue) && rdbFileStatus.SelectValue != "0")
{
strWhere += " AND Status=" + rdbFileStatus.SelectValue;
}
if (!String.IsNullOrWhiteSpace(ddlCompany.SelectValue) && ddlCompany.SelectValue != "0")
{
T_Company_BLL compBLL = new T_Company_BLL();
T_Company_MDL compMDL = compBLL.GetModel(ConvertEx.ToInt(ddlCompany.SelectValue));
if (compMDL != null)
{
strWhere += " AND DefaultCompanyType=" + compMDL.CompanyType + "";
}
}
if (!String.IsNullOrWhiteSpace(ddlFileType.SelectValue) && ddlFileType.SelectValue != "0")
{
strWhere += " AND BH like '" + ddlFileType.SelectValue + "%' ";
}
Session["FileInfostrWhere"] = strWhere;
if (ViewState["CurrentPageIndex"] == null && Common.ConvertEx.ToInt(DNTRequest.GetQueryString("PageIndex")) > 0)
{
pageIndex = Common.ConvertEx.ToInt(DNTRequest.GetQueryString("PageIndex"));
ViewState["CurrentPageIndex"] = pageIndex;
}
else
{
pageIndex = ConvertEx.ToInt(ViewState["CurrentPageIndex"]);
}
DataTable dt = fileListBLL.GetListPaging(strWhere, pageSize, pageIndex, out itemCount);;
AspNetPager.AlwaysShow = true;
AspNetPager.PageSize = pageSize;
AspNetPager.RecordCount = itemCount;
AspNetPager.CurrentPageIndex = pageIndex;
rpData.DataSource = dt;
rpData.DataBind();
}
}
