开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > Windows编程 > .net编程 > 查看源码
ProjectImplement.aspx.cs
资源名称：whpower2007-8-24.rar　[点击查看]
上传用户：tiancihang
上传日期：2014-03-12
资源大小：21387k
文件大小：171k
源码类别：

.net编程

开发平台：

C#

ProjectImplement.aspx.cs：源码内容
  2.             com.etong.DAL.FC.EtongFlyChouWFPrj etongFlyChouWFPrj = new com.etong.DAL.FC.EtongFlyChouWFPrj();
  3.             etongFlyChouWFPrj.sID = this.actinstanceid;
  4.             etongFlyChouWFPrj.PrjID = this.ConID;
  5.             etongFlyChouWFPrj.iID = this.WFInstanceID;
  6.             etongFlyChouWFPrj.aID= this.ActivityID;
  7.             etongFlyChouWFPrj.iStatus = 2;
  8.             //etongFlyChouWFPrj.sBlockReason = WorkFolw.GetBlockReason(this.actinstanceid);
  10.             if (etongFlyChouWFPrj.GetPrevioueTasksStatus() == false)
  11.             {
  12.                 Common.RunScript(this.Page, "工作流上级活动未完成，不能汇总文档");
  13.                 return;
  14.             }
  15.             else
  16.             {
  17.                 //汇总代码
  18.                        
  19.                 //
  21.                 string GcglTransactor = cui.EmpName + "   " + DateTime.Now.ToShortDateString() + " " + DateTime.Now.Hour + ":" + DateTime.Now.Minute;
  22.                 //string GcglFName = "工程进度调整计划、问题和解决方案" + DateTime.Now.Year + DateTime.Now.Month + DateTime.Now.Day + DateTime.Now.Hour + DateTime.Now.Minute + DateTime.Now.Second + ".doc";//工程管理办公室项目实施情况分析，工程项目调整计划（电子文档）-----待续
  23.                 string GcglFName = this.ProjectAnalysis.Value;
  24.                 string sql = "update [Tb_Construct] set [GcglTransactor]='" + GcglTransactor + "' where [ConID]=" + this.ConID;
  26.                 if (SqlServer.RunSql(sql))
  27.                 {
  28.                     //WorkFlowOperation(ConID, "您已审核通过!", false);
  29.                     WFInstADD("您已审核通过！", true);
  30.                     WorkFolw workflow = new WorkFolw();
  31.                     string ActIDtxt = Request.QueryString["ActID"].ToString().Trim();
  32.                     ActID = Convert.ToInt32(ActIDtxt);
  33.                     bool flag = workflow.WFActInsUpdata(ActID, 1, this.userid);
  35.                     if (flag == true)
  36.                     {
  37.                         //WorkFlowOperation(ConID, "您已审核通过!");
  38.                         int RouID = 2;//结束后关联种类条件ID(-1、无条件,1、变更材料,2、废旧物资处理,3、汇总废旧物资,4、施工工作流)
  39.                         //产生项目调整代办任务
  40.                         //begin code
  41.                         int WFID = -1;
  42.                         sql = "select [WFID] from [tb_WorkFlowRouter] where [RouID]=" + RouID;
  43.                         DataView dv = SqlServer.GetDataView(sql);
  44.                         if (dv.Count > 0)
  45.                         {
  46.                             WFID = Convert.ToInt32(dv[0]["WFID"].ToString());
  47.                         }
  48.                         if (WFID != -1)
  49.                         {
  50.                             dv = GetConstructInfo(this.ConID);
  51.                             string bgFName = dv[0]["JcWZFName"].ToString();
  52.                             PrjOldMatManager prjOldMatManager = new PrjOldMatManager();
  53.                             //PrjOldMatInfo prjOldMatInfo = new PrjOldMatInfo(this.ConID, Convert.ToInt32(consort), -1, "", "", "", "",bgFName, "", "", "", "", "", "", "", "", "", "", 1);
  54.                             PrjOldMatInfo prjOldMatInfo = new PrjOldMatInfo(this.ConID, Convert.ToInt32(consort), -1, "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", 1);
  55.                             int NewMatID = prjOldMatManager.AddPrjOldMat(prjOldMatInfo);
  56.                             if (NewMatID > 0)
  57.                             {
  58.                                 EtongZwf etongzwf = new EtongZwf();
  59.                                 DateTime SuccessDate = Convert.ToDateTime(DateTime.Now.ToShortDateString().Trim());
  60.                                 //添加工作流实例 (将添加成功的constructid添加到工作流实例表里,注意是加到该表的PrjID字段中)
  61.                                 WFInstanceInfo wfinstanceinfo = new WFInstanceInfo(-1, Convert.ToDateTime(DateTime.Now.ToShortDateString()),
  62.                                         userid, -1, -1, DateTime.Now, 5, SuccessDate, WFID, NewMatID);
  63.                                 int ReInstanceValue = etongzwf.WFInstanceADD(wfinstanceinfo);
  64.                                 this.WFInstanceID = ReInstanceValue;
  65.                                 if (this.WFInstanceID > 0)
  66.                                 {
  67.                                     sql = "select [ActivityID] from [tb_WF_Activity] where [WorkFlowID]=" + WFID + " and [StartEnd]=0";
  68.                                     dv = SqlServer.GetDataView(sql);
  69.                                     if (dv.Count > 0)
  70.                                     {
  71.                                         this.ActivityID = Convert.ToInt32(dv[0]["ActivityID"].ToString());
  72.                                         int OpRoleID = -1;
  73.                                         sql = "select [RoleID] from [tb_Colony_User] where [ActivityID]=" + this.ActivityID;
  74.                                         dv = SqlServer.GetDataView(sql);
  75.                                         if (dv.Count > 0)
  76.                                             OpRoleID = Convert.ToInt32(dv[0]["RoleID"].ToString());
  78.                                         if (OpRoleID > 0)
  79.                                         {
  80.                                             WFActInsInfo wfactinsinfo = new WFActInsInfo(-1, this.ActivityID, Convert.ToDateTime(DateTime.Now.ToShortDateString()), Convert.ToDateTime(DateTime.Now.ToShortDateString()),
  81.                                                                                                                 0, SuccessDate, this.WFInstanceID, "99", -1, OpRoleID);
  83.                                             int ReActInsValue = etongzwf.WFActInsADD(wfactinsinfo);
  84.                                         }
  85.                                     }
  86.                                 }
  87.                             }
  88.                         }
  89.                         //end code
  90.                     }
  92.                     sql = "update [tb_construct] set [Status]=2 where [ConID]=" + this.ConID;
  93.                     if (SqlServer.RunSql(sql))
  94.                     {
  95.                         string script = "<script>alert('系统提示：您已审核通过，转到废旧物资管理流程处理！');top.location.href='../Main.aspx';</script>";
  96.                         Common.RunScriptString(this.Page, script);
  97.                     }
  98.                 }
  99.                 else
  100.                 {
  101.                     Common.RunScript(this.Page, "操作失败，请检查数据!");
  102.                 }
  103.             }
  104.         }
  106.         //**************************************************************上缴废旧物资**************************************************************
  107.        /* if (MustChooseItem == 28)
  108.         {
  110.             string JcSJTransactor = cui.EmpName + "   " + DateTime.Now.ToShortDateString() + " " + DateTime.Now.Hour + ":" + DateTime.Now.Minute;
  111.             //string JcSJFName = "废旧物资" + DateTime.Now.Year + DateTime.Now.Month + DateTime.Now.Day + DateTime.Now.Hour + DateTime.Now.Minute + DateTime.Now.Second + ".doc";//基层部门上缴废旧物资清单（电子文档）-----待续
  112.             string JcSJFName = this.TurnInOldMaterial.Value;
  113.             string sql = "update [Tb_Construct] set [JcSJTransactor]='" + JcSJTransactor + "',[JcSJFName]='" + JcSJFName + "' where [ConID]=" + this.ConID;
  115.             if (SqlServer.RunSql(sql))
  116.             {
  119.             }
  120.             else
  121.             {
  122.                 Common.RunScript(this.Page, "操作失败，请检查数据!");
  123.             }
  125.         }*/
  127.         //************************************************************废旧物资管理流程*************************************************************
  128.         /*if (MustChooseItem == 29)
  129.         {
  131.             string WZFjTransactor = cui.EmpName + "   " + DateTime.Now.ToShortDateString() + " " + DateTime.Now.Hour + ":" + DateTime.Now.Minute;
  132.             //string WZFjFName = "剩余材料统计" + DateTime.Now.Year + DateTime.Now.Month + DateTime.Now.Day + DateTime.Now.Hour + DateTime.Now.Minute + DateTime.Now.Second + ".doc";//物资部门废旧物资接受清单（电子文档）-----待续
  133.             //string WZFjFName = this.OldMaterialManagement.Value;
  134.             string WZFjIdea = this.TB_OldMaterialManagement.Text.Trim();
  135.             string sql = "update [Tb_Construct] set [WZFjTransactor]='" + WZFjTransactor + "',[WZFjFName]='" + WZFjIdea + "',[Status]=2 where [ConID]=" + this.ConID;
  136.             string sql1 = "update [tb_WF_ActIns] set [Status]=1,[UserID]=" + this.userid + " where [ActInsID]=" + this.actinstanceid;
  137.             if (SqlServer.RunSql(sql) && SqlServer.RunSql(sql1))
  138.             {
  139.                 sql = "select [StartEnd] from [tb_WF_Activity] where [ActivityID]=" + ActivityID;
  140.                 DataView dv = SqlServer.GetDataView(sql);
  141.                 if (dv.Count > 0)
  142.                 {
  143.                     startEnd = Convert.ToInt32(dv[0]["StartEnd"].ToString());
  144.                     if (startEnd == 2)//最终任务
  145.                     {
  146.                         string script = "<script language='javascript'>alert('系统提示：您已审核通过,本工程项目实施流程结束！');top.location.href='../Main.aspx';</script>";
  147.                         Common.RunScriptString(this.Page, script);
  148.                     }
  149.                 }
  150.                 else
  151.                 {
  152.                     WorkFlowOperation(ConID, "您已审核通过,本工程项目实施流程结束!");
  153.                 }
  154.             }
  155.             else
  156.             {
  157.                 Common.RunScript(this.Page, "操作失败，请检查数据!");
  158.             }
  159.         }*/
  161.         //************************************************************工程计划流程*************************************************************
  162.         if (MustChooseItem == 30)
  163.         {
  164.             int RouID = 1;//结束后关联种类条件ID(-1、无条件,1、变更材料,2、废旧物资处理,3、汇总废旧物资,4、施工工作流)
  165.             DataView dv = GetConstructInfo(this.ConID);
  166.             string BgFName = dv[0]["WZFName"].ToString();
  167.             string altername = this.TB_ConName.Text.ToString() + "材料变更";
  168.             string sql = "";
  169.             //string sql = "insert into [tb_PrjAlert]([ConID],[BgFName]) values (" + this.ConID + ",'" + BgFName + "')";
  170.             PrjAlertInfo prjAlertInfo = new PrjAlertInfo(this.ConID, consort, altername, BgFName, "", "", "", "", "", "", "","", 1);
  171.             PrjAlertManager prjAlertManager = new PrjAlertManager();
  172.             int newPrjAlertID = prjAlertManager.AddPrjAlert(prjAlertInfo);
  173.             if (newPrjAlertID>0)
  174.             {
  175.                 //产生项目调整代办任务
  176.                 //begin code
  177.                 int WFID = -1;
  178.                 sql = "select [WFID] from [tb_WorkFlowRouter] where [RouID]=" + RouID;
  179.                 dv = SqlServer.GetDataView(sql);
  180.                 if (dv.Count > 0)
  181.                 {
  182.                     WFID = Convert.ToInt32(dv[0]["WFID"].ToString());
  183.                 }
  184.                 if (WFID != -1)
  185.                 {
  186.                     EtongZwf etongzwf = new EtongZwf();
  187.                     DateTime SuccessDate = Convert.ToDateTime(DateTime.Now.ToShortDateString().Trim());
  188.                     //添加工作流实例 (将添加成功的constructid添加到工作流实例表里,注意是加到该表的PrjID字段中)
  189.                     WFInstanceInfo wfinstanceinfo = new WFInstanceInfo(-1, Convert.ToDateTime(DateTime.Now.ToShortDateString()),
  190.                             userid, -1, -1, DateTime.Now, 4, SuccessDate, WFID,newPrjAlertID);
  191.                     int ReInstanceValue = etongzwf.WFInstanceADD(wfinstanceinfo);
  192.                     this.WFInstanceID = ReInstanceValue;
  193.                     if (this.WFInstanceID > 0)
  194.                     {
  195.                         sql = "select [ActivityID] from [tb_WF_Activity] where [WorkFlowID]=" + WFID + " and [StartEnd]=0";
  196.                         dv = SqlServer.GetDataView(sql);
  197.                         if (dv.Count > 0)
  198.                         {
  199.                             this.ActivityID = Convert.ToInt32(dv[0]["ActivityID"].ToString());
  200.                             int OpRoleID = -1;
  201.                             sql = "select [RoleID] from [tb_Colony_User] where [ActivityID]=" + this.ActivityID;
  202.                             dv = SqlServer.GetDataView(sql);
  203.                             if (dv.Count > 0)
  204.                                 OpRoleID = Convert.ToInt32(dv[0]["RoleID"].ToString());
  206.                             if (OpRoleID > 0)
  207.                             {
  208.                                 WFActInsInfo wfactinsinfo = new WFActInsInfo(-1, this.ActivityID, Convert.ToDateTime(DateTime.Now.ToShortDateString()), Convert.ToDateTime(DateTime.Now.ToShortDateString()),
  209.                                                                                                     0, SuccessDate, this.WFInstanceID, "", -1, OpRoleID);
  211.                                 int ReActInsValue = etongzwf.WFActInsADD(wfactinsinfo);
  212.                             }
  213.                         }
  214.                     }
  215.                 }
  216.                 //end code
  218.                 sql = "update [tb_construct] set [Status]=2 where [ConID]=" + this.ConID;
  219.                 if (SqlServer.RunSql(sql))
  220.                 {
  221.                     string script = "<script>alert('系统提示：您已审核通过，转到废旧物资管理流程！');top.location.href='../Main.aspx';</script>";
  222.                     Common.RunScriptString(this.Page, script);
  223.                 }
  224.             }
  225.         }
  226.     }
  229.     /*============================================================对并发活动的特殊处理======================================================
  230.      * 
  231.      *                                                 工作流操作,分3步
  232.      * 1.产生工作流实例纪录,注意constructid必须真实存在 
  233.      * 2.更新当前活动实例状态 由WFInstADD中的WFActInsUpdata执行
  234.      * 3.产生新的工作流实例纪录,即产生下一个活动实例并提交到下一个部门的用户申核,由NextColonyRole操作完成                                
  235.      * 
  236.      *=====================================================================================================================================*/
  237.     protected void WorkFlowOperation(int conid, bool isMaster)
  238.     {
  239.         EtongZwf etongzwf = new EtongZwf();
  240.         ProjectImplment projectImplment = new ProjectImplment();
  241.         
  242.         //int count = dv.Count;
  244.         string sql = " select * from [tb_WF_Instance] where [Status]=2 and [PrjID]=" + this.ConID;
  245.         DataView dv = SqlServer.GetDataView(sql);
  246.         if (dv.Count == 0)//如果实例存在则不添加
  247.         {
  248.             DateTime SuccessDate = Convert.ToDateTime(DateTime.Now.ToShortDateString().Trim());
  249.             //添加工作流实例 (将添加成功的constructid添加到工作流实例表里,注意是加到该表的PrjID字段中)
  250.             WFInstanceInfo wfinstanceinfo = new WFInstanceInfo(-1, Convert.ToDateTime(DateTime.Now.ToShortDateString()),
  251.                     userid, -1, -1, DateTime.Now, 2, SuccessDate, wfid, conid);
  253.             int ReInstanceValue = etongzwf.WFInstanceADD(wfinstanceinfo);
  255.             //产生当前工作流实例ID
  256.             WFInstanceID = ReInstanceValue;
  257.         }
  259.         string nextCheckDepartment = "";
  260.         dv = etongzwf.ColonyUserGetByActId(ActivityID);
  263.         if (dv.Count > 0)
  264.         {
  265.             /*int ParentOrgID = Convert.ToInt32(dv[0]["ParentRoleID"].ToString().Trim());
  266.             //DataView dvRoleName = etongzwf.RoleGetName(ParentRoleID);
  267.             DataTable dataTable = projectImplment.GetDepartmentByID(ParentOrgID);
  268.             if (dataTable.Rows.Count == 0)
  269.             {
  270.                 ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('系统提示：项目施工停滞，没有上级申核人！(请联系相关部门或系统管理员)');</script>");
  271.                 return;
  272.             }*/
  273.             for (int i = 0; i < dv.Count; i++)//找到所有部门
  274.             {
  275.                 int ParentRoleID = Convert.ToInt32(dv[i]["ParentRoleID"].ToString().Trim());
  276.                 ProjectImplment pi = new ProjectImplment();
  277.                 //DataTable dt = pi.GetDepartmentByID(ParentRoleID);
  278.                 DataTable dt = pi.GetNextOperatorRole(ParentRoleID);
  279.                 nextCheckDepartment += dt.Rows[0]["OpName"].ToString() + "、";
  280.             }
  282.             for (int i = 0; i < dv.Count; i++)
  283.             {
  284.                 int CurrentRoleID = Convert.ToInt32(dv[i]["CurrentRoleID"].ToString().Trim());
  285.                 int ParentActID = Convert.ToInt32(dv[i]["ParentActID"].ToString().Trim());
  286.                 int ParentRoleID = Convert.ToInt32(dv[i]["ParentRoleID"].ToString().Trim());
  288.                 if (WFInstanceID > 0)
  289.                 {
  290.                     /*WorkFolw workflow = new WorkFolw();
  291.                     string ActIDtxt = Request.QueryString["ActID"].ToString().Trim();
  292.                     ActID = Convert.ToInt32(ActIDtxt);
  293.                     bool returnvalue = false;
  294.                     //产生当前活动实例  如果是不是第一个活动,只需 修改 UserID 和 Status
  295.                     int ReActInsValue = 0;
  297.                     //returnvalue = etongzwf.WFActInsUpdata(ActID, userid, 1);
  298.                     returnvalue = workflow.WFActInsUpdata(ActID, 1, userid);
  299.                     if (returnvalue == true)
  300.                         ReActInsValue = ActID;
  302.                     if (ReActInsValue > 0)
  303.                     {*/
  304.                     if (ParentActID != -1)
  305.                     {
  306.                         NextColonyRole(ParentActID, ParentRoleID, "您已审核通过", nextCheckDepartment, isMaster);  //(ReActInsValue);     //产生下一个活动实例并提交到下一个角色的用户申核
  307.                     }
  308.                     else   // 不存在上级活动，将 活动状态(Status) 改为 "完成"   注:Status状态(0、正常；1、完成；2、回退；3、回退并完成；4、作废)
  309.                     {
  310.                         /*bool ReValueAIUpdata = false;
  311.                         //ReValueAIUpdata = etongzwf.WFActInsUpdata(ReActInsValue, userid, 1);
  312.                         ReValueAIUpdata = workflow.WFActInsUpdata(ReActInsValue, 1, userid);
  314.                         if (ReValueAIUpdata == true)
  315.                         {
  316.                             ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('系统提示：项目施工完成！');top.location.href='../Main.aspx';</script>");
  317.                         }
  318.                         else
  319.                         {*/
  320.                             ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('系统提示：操作失败！');top.location.href='../Main.aspx';</script>");
  321.                     }
  322.                 }
  323.             }
  324.         }
  325.     }
  330.     /*===========================================================================================================================
  331.      * 
  332.      *                                    工作流操作,分3步 
  333.      * 1.产生工作流实例纪录,注意constructid必须真实存在 
  334.      * 2.更新当前活动实例状态 由WFInstADD中的WFActInsUpdata执行
  335.      * 3.产生新的工作流实例纪录,即产生下一个活动实例并提交到下一个部门的用户申核,由NextColonyRole操作完成                                
  336.      * 
  337.      *==========================================================================================================================*/
  338.     protected void WorkFlowOperation(int conid, string showmessage, bool isMaster)
  339.     {
  340.         EtongZwf etongzwf = new EtongZwf();
  341.         ProjectImplment projectImplment = new ProjectImplment();
  343.          string sql = "select * from [tb_WF_Instance] where [Status]=2 and [PrjID]=" + this.ConID;
  344.         DataView dv = SqlServer.GetDataView(sql);
  345.         if (dv.Count == 0)//如果实例存在则不添加
  346.         {
  347.             DateTime SuccessDate = Convert.ToDateTime(DateTime.Now.ToShortDateString().Trim());
  348.             //添加工作流实例 (将添加成功的constructid添加到工作流实例表里,注意是加到该表的PrjID字段中)
  349.             WFInstanceInfo wfinstanceinfo = new WFInstanceInfo(-1, Convert.ToDateTime(DateTime.Now.ToShortDateString()),
  350.                 userid, -1, -1, DateTime.Now, 2, SuccessDate, wfid, conid);
  352.             int ReInstanceValue = etongzwf.WFInstanceADD(wfinstanceinfo);
  354.             //产生当前工作流实例ID
  355.             WFInstanceID = ReInstanceValue;
  356.         }
  358.         dv = etongzwf.ColonyUserGetByActId(ActivityID);
  360.         if (dv.Count > 0)
  361.         {
  362.             //int ParentRoleID = Convert.ToInt32(dv[0]["ParentRoleID"].ToString().Trim());
  363.             ////DataView dvRoleName = etongzwf.RoleGetName(ParentRoleID);
  364.             //DataTable dt = projectImplment.GetDepartmentByID(ParentRoleID);
  365.             //if (dt.Rows.Count == 0)
  366.             //{
  367.             //    ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('系统提示：项目施工停滞，没有上级申核人！(请联系相关部门或系统管理员)');</script>");
  368.             //    return;
  369.             //}
  371.             //获取当前工作流启始活动    为什么要获取当前工作流启始活动?            
  372.             //DataView dvActID = etongzwf.GetActivityByWFID(wfid);
  374.             //ActivityID = Convert.ToInt32(dvActID[0][0].ToString().Trim());
  376.             if (WFInstanceID > 0)
  377.             {
  378.                 WFInstADD(showmessage, isMaster);
  379.             }
  380.         }
  381.     }
  383.     /// <summary>
  384.     /// 改变工作流活动实例状态   
  385.     /// </summary>
  386.     /// 
  387.     protected void WFInstADD(string showMessage, bool isMaster)
  388.     {
  389.         if (WFInstanceID > 0)
  390.         {
  391.             com.etong.DAL.WorkFolw workflow = new com.etong.DAL.WorkFolw();
  392.             DateTime SuccessDate = Convert.ToDateTime(DateTime.Now.ToShortDateString().Trim());
  393.             EtongZwf etongzwf = new EtongZwf();
  394.             DataView dv = etongzwf.ColonyUserGetByActId(ActivityID);
  395.             // int CurrentActID = -1;
  396.             int CurrentRoleID = -1;
  397.             int ParentActID = -1;
  398.             int ParentRoleID = -1;
  399.             string nextCheckDepartment = null;
  401.             if (dv.Count > 0)
  402.             {
  403.                 if (dv.Count == 1)//不分流
  404.                 {
  405.                     CurrentRoleID = Convert.ToInt32(dv[0]["CurrentRoleID"].ToString().Trim());
  406.                     ParentActID = Convert.ToInt32(dv[0]["ParentActID"].ToString().Trim());
  407.                     ParentRoleID = Convert.ToInt32(dv[0]["ParentRoleID"].ToString().Trim());
  408.                 }
  409.                 else//分流
  410.                 {
  411.                     for (int i = 0; i < dv.Count; i++)
  412.                     {
  413.                         if (Convert.ToInt32(dv[i]["shuntflag"]) == shuntFlag)
  414.                         {
  415.                             CurrentRoleID = Convert.ToInt32(dv[i]["CurrentRoleID"].ToString().Trim());
  416.                             ParentActID = Convert.ToInt32(dv[i]["ParentActID"].ToString().Trim());
  417.                             ParentRoleID = Convert.ToInt32(dv[i]["ParentRoleID"].ToString().Trim());
  418.                         }
  419.                     }
  420.                 }
  421.             }
  423.             //产生当前活动实例  如果是不是第一个活动,只需 修改 UserID 和 Status
  424.             int ReActInsValue = 0;
  425.             int tempStatus = WorkFolw.GetCurrentActivityInstanceStatus(this.actinstanceid);//当前活动实例状态
  427.             if (MustChooseItem == 69)//对起始活动的操作
  428.             {
  429.                 if (tempStatus == 2)//回退活动
  430.                 {
  431.                     string ActIDtxt = Request.QueryString["ActID"].ToString().Trim();
  432.                     ActID = Convert.ToInt32(ActIDtxt);
  433.                     bool returnvalue = false;
  434.                     //returnvalue = etongzwf.WFActInsUpdata(ActID, userid, 1);
  435.                     returnvalue = workflow.WFActInsUpdata(ActID, 1, userid);
  436.                     if (returnvalue == true)
  437.                         ReActInsValue = ActID;
  438.                     if (ReActInsValue > 0)
  439.                     {
  440.                         if (ParentActID != -1)
  441.                         {
  442.                             ProjectImplment pi = new ProjectImplment();
  443.                             //DataTable dt = pi.GetDepartmentByID(ParentRoleID);
  444.                             DataTable dt = pi.GetNextOperatorRole(ParentRoleID);
  445.                             nextCheckDepartment = dt.Rows[0]["OpName"].ToString();
  446.                             NextColonyRole(ParentActID, ParentRoleID, showMessage, nextCheckDepartment, isMaster);  //(ReActInsValue);     //产生下一个活动实例并提交到下一个角色的用户申核
  447.                         }
  448.                         else//不存在上级活动，将 活动状态(Status) 改为 "完成"   注:Status状态(0、正常；1、完成；2、回退；3、回退并完成；4、作废)
  449.                         {
  450.                             bool ReValueAIUpdata = false;
  451.                             //ReValueAIUpdata = etongzwf.WFActInsUpdata(ReActInsValue, userid, 1);
  452.                             ReValueAIUpdata = workflow.WFActInsUpdata(ReActInsValue, 1, userid);
  454.                             if (ReValueAIUpdata == true)
  455.                             {
  456.                                 ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('系统提示：项目施工完成！');top.location.href='../Main.aspx';</script>");
  457.                             }
  458.                             else
  459.                             {
  460.                                 ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('系统提示：操作失败！');top.location.href='../Main.aspx';</script>");
  461.                             }
  462.                         }
  463.                     }
  464.                 }
  465.                 else
  466.                 {
  467.                     WFActInsInfo wfactinsinfo = new WFActInsInfo(-1, ActivityID, Convert.ToDateTime(DateTime.Now.ToShortDateString()), Convert.ToDateTime(DateTime.Now.ToShortDateString()),
  468.                                                                      1, SuccessDate, WFInstanceID, "", userid, CurrentRoleID);
  470.                     ReActInsValue = etongzwf.WFActInsADD(wfactinsinfo);
  471.                     ProjectImplment pi = new ProjectImplment();
  472.                     //DataTable dt = pi.GetDepartmentByID(ParentRoleID);
  473.                     DataTable dt = pi.GetNextOperatorRole(ParentRoleID);
  474.                     if (dt.Rows.Count > 0)
  475.                     {
  476.                         nextCheckDepartment = dt.Rows[0]["OpName"].ToString();
  477.                         //ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('系统提示：计划下达成功,转到『" + nextCheckDepartment + "』申核处理！');top.location.href='../Main.aspx';</script>");
  478.                     }
  480.                     NextColonyRole(ParentActID, ParentRoleID, showMessage, nextCheckDepartment, isMaster);//提交给下一部门用户审核
  481.                 }
  482.             }
  483.             else//对不是起始活动的操作
  484.             {
  485.                 string ActIDtxt = Request.QueryString["ActID"].ToString().Trim();
  486.                 ActID = Convert.ToInt32(ActIDtxt);
  487.                 bool returnvalue = false;
  488.                 //returnvalue = etongzwf.WFActInsUpdata(ActID, userid, 1);
  489.                 returnvalue = workflow.WFActInsUpdata(ActID, 1, userid);
  490.                 if (returnvalue == true)
  491.                     ReActInsValue = ActID;
  493.                 if (ReActInsValue > 0)
  494.                 {
  495.                     if (ParentActID != -1)
  496.                     {
  497.                         ProjectImplment pi = new ProjectImplment();
  498.                         //DataTable dt = pi.GetDepartmentByID(ParentRoleID);
  499.                         DataTable dt = pi.GetNextOperatorRole(ParentRoleID);
  500.                         nextCheckDepartment = dt.Rows[0]["OpName"].ToString();
  501.                         NextColonyRole(ParentActID, ParentRoleID, showMessage, nextCheckDepartment, isMaster);  //(ReActInsValue);     //产生下一个活动实例并提交到下一个角色的用户申核
  502.                     }
  503.                     else   // 不存在上级活动，将 活动状态(Status) 改为 "完成"   注:Status状态(0、正常；1、完成；2、回退；3、回退并完成；4、作废)
  504.                     {
  505.                         bool ReValueAIUpdata = false;
  506.                         //ReValueAIUpdata = etongzwf.WFActInsUpdata(ReActInsValue, userid, 1);
  507.                         ReValueAIUpdata = workflow.WFActInsUpdata(ReActInsValue, 1, userid);
  509.                         if (ReValueAIUpdata == true)
  510.                         {
  511.                             ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('系统提示：工程项目实施工作流活动完成！');top.location.href='../Main.aspx';</script>");
  512.                         }
  513.                         else
  514.                         {
  515.                             ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('系统提示：操作失败！');top.location.href='../Main.aspx';</script>");
  516.                         }
  517.                     }
  518.                 }
  519.             }
  520.         }
  521.     }
  523.     /// <summary>
  524.     /// 起始活动.
  525.     /// </summary>
  526.     protected int ActivityIDGetByWFID(int WfId)
  527.     {
  528.         EtongZwf etongzwf = new EtongZwf();
  529.         DataView dvActivity = etongzwf.GetActivityByWFID(WfId);
  530.         if (dvActivity.Count != 0)
  531.         {
  532.             int activity = Convert.ToInt32(dvActivity[0][0].ToString().Trim());
  533.             return activity;
  534.         }
  535.         else
  536.             return 0;
  537.     }
  539.     /// <summary>
  540.     /// 提交到上级部门用户申核
  541.     /// </summary>
  542.     protected void NextColonyRole(int ParentActID, int ParentRoleID, string showMessage, string nextCheckDepartment, bool isMaster)
  543.     {
  544.         EtongZwf etongzwf = new EtongZwf();
  545.         WFActInsInfo wfactinsinfo = null;
  546.         if (isMaster == false)
  547.         {
  548.             wfactinsinfo = new WFActInsInfo(-1, ParentActID, Convert.ToDateTime(DateTime.Now.ToShortDateString()), Convert.ToDateTime(DateTime.Now.ToShortDateString()),
  550.                                                                      0, Convert.ToDateTime(DateTime.Now.ToShortDateString()), WFInstanceID, WorkFolw.GetOrgOpRoleType(ParentRoleID), -1, ParentRoleID);
  551.         }
  552.         else
  553.         {
  554.             CheckUserInfo cui = null;
  555.             if (Session["checkuserinfo"] != null)
  556.             {
  557.                 cui = (CheckUserInfo)Session["checkuserinfo"];
  558.             }
  559.             string type = ProjectImplment.GetEmpType(cui.EmpID);
  561.             wfactinsinfo = new WFActInsInfo(-1, ParentActID, Convert.ToDateTime(DateTime.Now.ToShortDateString()), Convert.ToDateTime(DateTime.Now.ToShortDateString()),
  562.                                                                 0, Convert.ToDateTime(DateTime.Now.ToShortDateString()), WFInstanceID, type, -1, ParentRoleID);
  563.         }
  565.         int ReActInsValue = etongzwf.WFActInsADD(wfactinsinfo);
  566.         if (ReActInsValue > 0)
  567.         {
  568.             //DataView dvRoleName = etongzwf.RoleGetName(ParentRoleID);
  569.             //if (dvRoleName.Count != 0)
  570.             //{
  571.             //InitializePage();        //初始化当前页面
  572.             ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('系统提示：" + showMessage + ",转到『" + nextCheckDepartment + "』申核处理！');top.location.href='../Main.aspx';</script>");
  573.             //}
  574.             //else
  575.             //ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('系统提示：项目施工停滞，没有上级申核人！');</script>");
  576.         }
  577.         else
  578.         {
  579.             ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('系统提示：操作失败！');top.location.href='../Main.aspx';</script>");
  580.         }
  581.     }
  583.     protected void BT_Revoke_Click(object sender, ImageClickEventArgs e)
  584.     {
  585.         string sql = "update tb_WF_ACtIns set Status=4  where [WfInstanceID]=" + WFInstanceID + " and [ActivityID]=" + ActivityID;
  586.         string sql1 = "update [tb_construct] set [Status]=3 where [ConID]=" + this.ConID;
  588.         if (SqlServer.RunSql(sql) && SqlServer.RunSql(sql1))
  589.         {
  590.             ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('系统提示：作废操作成功！');top.location.href='../Main.aspx';</script>");
  591.         }
  592.         else
  593.         {
  594.             ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('系统提示：作废操作失败！');top.location.href='../Main.aspx';</script>");
  595.         }
  596.     }
  598.     //protected void BT_OpenDocument_Click(object sender, EventArgs e)
  599.     //{
  600.     //    this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script language='javascript'>window.open('DaiBan.aspx?strFName='" + this.lblReportMaterialPlan.Text + ".doc')</script>");
  601.     //}
  603.     protected void BT_NotPass_Click(object sender, ImageClickEventArgs e)
  604.     {
  605.         //******************************************************监督实施*************************************************************
  606.         if (MustChooseItem == 23)
  607.         {
  608.             int RouID = 1;//结束后关联种类条件ID(-1、无条件,1、变更材料,2、废旧物资处理,3、汇总废旧物资,4、施工工作流)
  609.             DataView dv = GetConstructInfo(this.ConID);
  610.             string BgFName = dv[0]["JcWZFName"].ToString();
  611.             string altername = this.TB_ConName.Text.ToString() + "材料变更";
  612.             string sql = "";
  613.             string consort = "";
  614.             CheckUserInfo cui = null;
  615.             if (Session["checkuserinfo"] != null)
  616.             {
  617.                 cui = (CheckUserInfo)Session["checkuserinfo"];
  618.             }
  619.             consort = ProjectImplment.GetEmpType(cui.EmpID);
  621.             //string sql = "insert into [tb_PrjAlert]([ConID],[BgFName]) values (" + this.ConID + ",'" + BgFName + "')";
  622.             PrjAlertInfo prjAlertInfo = new PrjAlertInfo(this.ConID, consort, altername, BgFName, "", "", "", "", "", "", "", "", 1);
  623.             PrjAlertManager prjAlertManager = new PrjAlertManager();
  624.             int newPrjAlertID = prjAlertManager.AddPrjAlert(prjAlertInfo);
  625.             if (newPrjAlertID > 0)
  626.             {
  627.                 //产生项目调整代办任务
  628.                 //begin code
  629.                 int WFID = -1;
  630.                 sql = "select [WFID] from [tb_WorkFlowRouter] where [RouID]=" + RouID;
  631.                 dv = SqlServer.GetDataView(sql);
  632.                 if (dv.Count > 0)
  633.                 {
  634.                     WFID = Convert.ToInt32(dv[0]["WFID"].ToString());
  635.                 }
  636.                 if (WFID != -1)
  637.                 {
  638.                     EtongZwf etongzwf = new EtongZwf();
  639.                     DateTime SuccessDate = Convert.ToDateTime(DateTime.Now.ToShortDateString().Trim());
  640.                     //添加工作流实例 (将添加成功的constructid添加到工作流实例表里,注意是加到该表的PrjID字段中)
  641.                     WFInstanceInfo wfinstanceinfo = new WFInstanceInfo(-1, Convert.ToDateTime(DateTime.Now.ToShortDateString()),
  642.                             userid, -1, -1, DateTime.Now, 4, SuccessDate, WFID, newPrjAlertID);
  643.                     int ReInstanceValue = etongzwf.WFInstanceADD(wfinstanceinfo);
  644.                     this.WFInstanceID = ReInstanceValue;
  645.                     if (this.WFInstanceID > 0)
  646.                     {
  647.                         sql = "select [ActivityID] from [tb_WF_Activity] where [WorkFlowID]=" + WFID + " and [StartEnd]=0";
  648.                         dv = SqlServer.GetDataView(sql);
  649.                         if (dv.Count > 0)
  650.                         {
  651.                             this.ActivityID = Convert.ToInt32(dv[0]["ActivityID"].ToString());
  652.                             int OpRoleID = -1;
  653.                             sql = "select [RoleID] from [tb_Colony_User] where [ActivityID]=" + this.ActivityID;
  654.                             dv = SqlServer.GetDataView(sql);
  655.                             if (dv.Count > 0)
  656.                                 OpRoleID = Convert.ToInt32(dv[0]["RoleID"].ToString());
  658.                             if (OpRoleID > 0)
  659.                             {
  660.                                 WFActInsInfo wfactinsinfo = new WFActInsInfo(-1, this.ActivityID, Convert.ToDateTime(DateTime.Now.ToShortDateString()), Convert.ToDateTime(DateTime.Now.ToShortDateString()),
  661.                                                                                                     0, SuccessDate, this.WFInstanceID, consort, -1, OpRoleID);
  663.                                 int ReActInsValue = etongzwf.WFActInsADD(wfactinsinfo);
  664.                             }
  665.                         }
  666.                     }
  667.                 }
  668.                 //end code
  669.                 WorkFolw workflow = new WorkFolw();
  670.                 workflow.WFActInsUpdata(actinstanceid, 1, userid);
  671.                 string script = "<script>alert('系统提示：您已确认审核不通过，转到物资并更物资管理流程！');top.location.href='../Main.aspx';</script>";
  672.                 Common.RunScriptString(this.Page, script);
  674.                 //sql = "update [tb_construct] set [Status]=2 where [ConID]=" + this.ConID;
  675.                 //if (SqlServer.RunSql(sql))
  676.                 //{
  677.                 //    string script = "<script>alert('系统提示：您已审核通过，转到废旧物资管理流程！');top.location.href='../Main.aspx';</script>";
  678.                 //    Common.RunScriptString(this.Page, script);
  679.                 //}
  680.             }
  681.             //CheckUserInfo cui = (CheckUserInfo)Session["checkuserinfo"];
  682.             ////string ZgJdTransaction = cui.EmpName + "   " + DateTime.Now.ToShortDateString() + " " + DateTime.Now.Hour + ":" + DateTime.Now.Minute;
  683.             //string ZgJdTransactor = cui.EmpName;
  684.             //this.TB_ZgJdIdea.Text = "审核不通过";
  685.             //string ZgJdIdea = this.TB_ZgJdIdea.Text.Trim() + "  " + DateTime.Now.ToShortDateString() + " " + DateTime.Now.Hour + ":" + DateTime.Now.Minute;//主管部门监督实施审核意见和审核时间
  686.             //string sql = "update [Tb_Construct] set [ZgJdTransactor]='" + ZgJdTransactor + "',[ZgJdIdea]='" + ZgJdIdea + "' where [ConID]=" + this.ConID;
  688.             //if (SqlServer.RunSql(sql))
  689.             //{
  690.             //    this.shuntFlag = 2;
  691.             //    //WorkFlowOperation(ConID, "您审核未通过!",false);
  692.             //}
  693.             //else
  694.             //{
  695.             //    Common.RunScript(this.Page, "操作失败，请检查数据!");
  696.             //}
  697.         }
  698.     }
  700.     //******************************************************得到指定活动的文档名称*************************************************************
  701.     protected string GetDocumentFileName(int activityid)
  702.     {
  703.         string sql = "select [FName] from [tb_Colony_FileName1] a,[tb_Sys_FileName] b where a.[FID]=b.[FID] and [ActivityID]=" + activityid;
  704.         string filename = "";
  705.         //string tempfilename = "";
  706.         DataView dv = SqlServer.GetDataView(sql);
  707.         if (dv != null && dv.Count > 0)
  708.         {
  709.             filename = dv[0]["FName"].ToString();
  710.             //if (filename.Length >= 2)
  711.                 //tempfilename = filename.Substring(filename.LastIndexOf("\\") + 2);
  712.         }
  713.         return filename;
  714.     }
  716.     protected string GetDocumentFileName(int activityid, int index)
  717.     {
  718.         string sql = "select [FName] from [tb_Colony_FileName1] a,[tb_Sys_FileName] b where a.[FID]=b.[FID] and [ActivityID]=" + activityid;
  719.         string filename = "";
  720.         //string tempfilename = "";
  721.         DataView dv = SqlServer.GetDataView(sql);
  722.         if (dv != null && dv.Count > 0)
  723.         {
  724.             filename = dv[index]["FName"].ToString();
  725.             //if (filename.Length >= 2)
  726.                 //tempfilename = filename.Substring(filename.LastIndexOf("\\") + 2);
  727.         }
  728.         return filename;
  729.     }
  730.     ////******************************************************用最新日期生成最新文档*************************************************************
  731.     protected string MakeNewFileNameWithDate(string filename)
  732.     {
  733.         if (filename.Length > 0 && filename.Contains("."))
  734.         {
  735.             string[] a = filename.Split('.');
  736.             return a[0] + DateTime.Now.Year + DateTime.Now.Month + DateTime.Now.Day + DateTime.Now.Hour + DateTime.Now.Minute + DateTime.Now.Second + "." + a[1];
  737.         }
  738.         else
  739.             return "";
  740.     }
  742.     ////******************************************************找到员工类型的汇总文档*************************************************************
  743.     protected string GetEmpTypeDocument_MaterialPlan()
  744.     {
  745.         string EmpTypeFileName = "";
  746.         string path = Server.MapPath("doc").Replace("\", "\\");      //获取项目所在路径
  747.         CheckUserInfo cui = null;
  748.         if (Session["checkuserinfo"] != null)
  749.         {
  750.             cui = (CheckUserInfo)Session["checkuserinfo"];
  751.         }
  753.         string EmpType = ProjectImplment.GetEmpType(cui.EmpID);
  754.         string filename = GetConstructInfo(this.ConID)[0]["WZFName"].ToString();
  756.         if (filename != "")
  757.         {
  758.             string xmlFileName = path + "\DocTemplateCon\" + filename;
  760.             XML xml = new XML(xmlFileName);
  761.             //ArrayList list = xml.ReadNode("Documents", EmpType, true);
  762.             ArrayList nodename=new ArrayList ();
  763.             nodename.Add("FileName");
  764.             ArrayList list = xml.ReadNode(nodename, "Documents");
  765.             if (list.Count > 0)
  766.             {
  767.                 //DocumentNode node = (DocumentNode)list[0];
  768.                 //EmpTypeFileName = node.FileName;
  769.                 string[] a = (string[])list[0];
  770.                 EmpTypeFileName = a[0].ToString();
  771.             }
  772.         }
  773.         return EmpTypeFileName;
  774.     }
  776.     protected string GetEmpTypeDocument_SetupExecution()
  777.     {
  778.         string EmpTypeFileName = "";
  779.         string path = Server.MapPath("doc").Replace("\", "\\");      //获取项目所在路径
  780.         CheckUserInfo cui = null;
  781.         if (Session["checkuserinfo"] != null)
  782.         {
  783.             cui = (CheckUserInfo)Session["checkuserinfo"];
  784.         }
  786.         string EmpType = ProjectImplment.GetEmpType(cui.EmpID);
  787.         string filename = GetConstructInfo(this.ConID)[0]["JcZFName"].ToString();
  789.         if (filename != "")
  790.         {
  791.             string xmlFileName = path + "\DocTemplateCon\" + filename;
  793.             XML xml = new XML(xmlFileName);
  794.             ArrayList list = xml.ReadNode("Documents", EmpType, true);
  795.             if (list.Count > 0)
  796.             {
  797.                 DocumentNode node = (DocumentNode)list[0];
  798.                 EmpTypeFileName = node.FileName;
  799.             }
  800.         }
  801.         return EmpTypeFileName;
  802.     }
  804.     protected string GetEmpTypeDocument_JDExecution()
  805.     {
  806.         string EmpTypeFileName = "";
  807.         string path = Server.MapPath("doc").Replace("\", "\\");      //获取项目所在路径
  808.         CheckUserInfo cui = null;
  809.         if (Session["checkuserinfo"] != null)
  810.         {
  811.             cui = (CheckUserInfo)Session["checkuserinfo"];
  812.         }
  814.         string EmpType = ProjectImplment.GetEmpType(cui.EmpID);
  815.         string filename = GetConstructInfo(this.ConID)[0]["ZgJdDocumentXml"].ToString();
  817.         if (filename != "")
  818.         {
  819.             string xmlFileName = path + "\DocTemplateCon\" + filename;
  821.             XML xml = new XML(xmlFileName);
  822.             ArrayList list = xml.ReadNode("Documents", EmpType, true);
  823.             if (list.Count > 0)
  824.             {
  825.                 DocumentNode node = (DocumentNode)list[0];
  826.                 EmpTypeFileName = node.FileName;
  827.             }
  828.         }
  829.         return EmpTypeFileName;
  830.     }
  832.     protected string GetEmpTypeDocument_ProjectPlan()
  833.     {
  834.         string EmpTypeFileName = "";
  835.         string path = Server.MapPath("doc").Replace("\", "\\");      //获取项目所在路径
  836.         CheckUserInfo cui = null;
  837.         if (Session["checkuserinfo"] != null)
  838.         {
  839.             cui = (CheckUserInfo)Session["checkuserinfo"];
  840.         }
  842.         string EmpType = ProjectImplment.GetEmpType(cui.EmpID);
  843.         string filename = GetConstructInfo(this.ConID)[0]["ZgHzFName"].ToString();
  845.         if (filename != "")
  846.         {
  847.             string xmlFileName = path + "\DocTemplateCon\" + filename;
  849.             XML xml = new XML(xmlFileName);
  850.             ArrayList list = xml.ReadNode("Documents", EmpType, true);
  851.             if (list.Count > 0)
  852.             {
  853.                 DocumentNode node = (DocumentNode)list[0];
  854.                 EmpTypeFileName = node.FileName;
  855.             }
  856.         }
  857.         return EmpTypeFileName;
  858.     }
  861.     protected void ViewLog_Click(object sender, ImageClickEventArgs e)
  862.     {
  863.         string ProjectID = ((HtmlInputHidden)this.FindControl("txt_ProjectID")).Value.Trim();
  864.         string sURL = "WFLog.aspx?ProjectID=" + ProjectID;
  865.         Response.Redirect(sURL);
  866.     }
  868.     protected void IB_Back_Click(object sender, ImageClickEventArgs e)
  869.     {
  870.         ClientScript.RegisterStartupScript(this.GetType(), "", "<script> window.location.href='../SearchP/StructureSearch.aspx';</script>");
  871.     }
  873.     protected void IB_Collect_Click(object sender, ImageClickEventArgs e)
  874.     {
  875.         string path = Server.MapPath("doc").Replace("\", "\\");      //获取项目所在路径
  877.         CheckUserInfo cui = null;
  878.         if (Session["checkuserinfo"] != null)
  879.         {
  880.             cui = (CheckUserInfo)Session["checkuserinfo"];
  881.         }
  884.         /*com.etong.DAL.FC.EtongFlyChouWFPrj etongFlyChouWFPrj = new com.etong.DAL.FC.EtongFlyChouWFPrj();
  885.         etongFlyChouWFPrj.sID = this.actinstanceid;
  886.         etongFlyChouWFPrj.PrjID = this.MatID;
  887.         etongFlyChouWFPrj.wID = this.wfid;
  888.         etongFlyChouWFPrj.iStatus = 5;
  889.         etongFlyChouWFPrj.sBlockReason = WorkFolw.GetBlockReason(this.actinstanceid);
  891.         if (etongFlyChouWFPrj.CheckUpActCompleteSort() == false)
  892.         {
  893.             Common.RunScript(this.Page, "工作流上级所属(同类型的)活动未完成，不能汇总文档");
  894.             return;
  895.         }
  896.         else
  897.         {*/
  898.         string EmpType = ProjectImplment.GetEmpType(cui.EmpID);
  899.         string filename = "型物资计划汇总表";
  900.         string filename1 = "型进度计划汇总表";
  901.         string filename2 = "型工程进度汇总表";
  902.         string filename3 = "型工程进度汇总总表";
  903.         string filename4 = "型进度计划汇总表";
  904.         /*switch (EmpType)
  905.         {
  906.             case "1": filename = "科技" + filename + DateTime.Now.Year + DateTime.Now.Month + DateTime.Now.Day + DateTime.Now.Hour + DateTime.Now.Minute + DateTime.Now.Second + ".doc";
  907.                 break;
  908.             case "2": filename = "生产" + filename + DateTime.Now.Year + DateTime.Now.Month + DateTime.Now.Day + DateTime.Now.Hour + DateTime.Now.Minute + DateTime.Now.Second + ".doc";
  909.                 break;
  910.             case "3": filename = "营销" + filename + DateTime.Now.Year + DateTime.Now.Month + DateTime.Now.Day + DateTime.Now.Hour + DateTime.Now.Minute + DateTime.Now.Second + ".doc";
  911.                 break;
  912.         }*/
  914.         filename = EmpType + "-" + filename + DateTime.Now.Year + DateTime.Now.Month + DateTime.Now.Day + DateTime.Now.Hour + DateTime.Now.Minute + DateTime.Now.Second;
  915.         filename1 = EmpType + "-" + filename1 + DateTime.Now.Year + DateTime.Now.Month + DateTime.Now.Day + DateTime.Now.Hour + DateTime.Now.Minute + DateTime.Now.Second;
  916.         filename2 = EmpType + "-" + filename2 + DateTime.Now.Year + DateTime.Now.Month + DateTime.Now.Day + DateTime.Now.Hour + DateTime.Now.Minute + DateTime.Now.Second;
  917.         filename3 = EmpType + "-" + filename3 + DateTime.Now.Year + DateTime.Now.Month + DateTime.Now.Day + DateTime.Now.Hour + DateTime.Now.Minute + DateTime.Now.Second;
  918.         filename4 = EmpType + "-" + filename4 + DateTime.Now.Year + DateTime.Now.Month + DateTime.Now.Day + DateTime.Now.Hour + DateTime.Now.Minute + DateTime.Now.Second;
  919.   
  920.         string checker = cui.EmpName;
  921.         string time = DateTime.Now.ToString();
  922.         DataView dv = GetConstructInfo(this.ConID);
  925.         if (this.MustChooseItem == 21)//物资采购汇总
  926.         {
  927.             com.etong.DAL.FC.EtongFlyChouWFPrj etongFlyChouWFPrj = new com.etong.DAL.FC.EtongFlyChouWFPrj();
  928.             etongFlyChouWFPrj.sID = this.actinstanceid;
  929.             etongFlyChouWFPrj.PrjID = this.ConID;
  930.             etongFlyChouWFPrj.wID = this.wfid;
  931.             etongFlyChouWFPrj.iStatus = 2;
  932.             //etongFlyChouWFPrj.sBlockReason = WorkFolw.GetBlockReason(this.actinstanceid);
  934.             //if (etongFlyChouWFPrj.CheckUpActComplete() == false)
  935.             if (WorkFolw.ParentActivitysIsCompleted(this.ConID, this.ActivityID) == false)
  936.             {
  937.                 Common.RunScript(this.Page, "工作流上级活动未完成，不能汇总文档");
  938.                 return;
  939.             }
  940.             else
  941.             {
  942.                 string xmlFileName = path + "\DocTemplateCon\" + dv[0]["WZFName"].ToString();
  943.                 XML xml = new XML(xmlFileName);
  945.                 XML jcXml = new XML(path + "\DocTemplateCon\" + dv[0]["JcWZFName"].ToString());
  946.                 //ArrayList list = jcXml.ReadNode("Documents", EmpType, true);
  947.                 //ArrayList list = jcXml.ReadNode("Documents");
  948.                 ArrayList nodesname = new ArrayList();
  949.                 nodesname.Add("FileName");
  950.                 ArrayList list = jcXml.ReadNode(nodesname, "Documents");
  951.                 string[] filecopy = new string[list.Count];
  952.                 ArrayList materiallist = new ArrayList();
  954.                 XML jcXml1 = new XML(path + "\DocTemplateCon\" + dv[0]["JcKgName"].ToString());
  955.                 ArrayList nodesname1 = new ArrayList();
  956.                 nodesname1.Add("FileName");
  957.                 ArrayList list1 = jcXml1.ReadNode(nodesname1, "Documents");
  958.                 string[] filecopy1 = new string[list.Count];
  959.                 ArrayList materiallist1 = new ArrayList();
  961.                 if (filecopy.Length > 0&&filecopy1 .Length >0)
  962.                 {
  963.                     for (int i = 0; i < filecopy.Length; i++)
  964.                     {
  965.                         //DocumentNode documentNode = (DocumentNode)list[i];
  966.                         string[] a = (string[])list[i];
  967.                         filecopy[i] = path + "\\DocTemplateCon\\" + a[0].ToString();
  968.                         materiallist.Add(Server.MapPath("doc\\DocTemplateCon\\" + a[0].ToString()));
  969.                     }
  970.                     for (int i = 0; i < filecopy1.Length; i++)
  971.                     {
  972.                         //DocumentNode documentNode = (DocumentNode)list[i];
  973.                         string[] a = (string[])list1[i];
  974.                         filecopy1[i] = path + "\\DocTemplateCon\\" + a[0].ToString();
  975.                         materiallist1.Add(Server.MapPath("doc\\DocTemplateCon\\" + a[0].ToString()));
  976.                     }
  978.                     string[] houzhui = filecopy[0].Split('.');
  979.                     string[] houzhui1 = filecopy1[0].Split('.');
  981.                     MyDocMerger myDocMerger = new MyDocMerger();
  982.                     string orgDocName = path + "\\DocTemplateCon\\" + filename4 + "." + houzhui1[1];
  983.                     Util.Copyfile(path + "\\空文档.doc", orgDocName);
  984.                     //this.txt_ZgHZFName.Value = filename + "." + houzhui[1];
  986.                     if (xml.AddXmlNode(new DocumentNode(filename + "." + houzhui[1], checker, time, EmpType))&&xml.AddXmlNode(new DocumentNode(filename4 + "." + houzhui1[1], checker, time, EmpType)))
  987.                     {
  989.                         // if (Util.Copyfile(path + "\" + orgfilename, orgDocName))
  990.                         // {
  991.                         /*------------------------文档汇总----------------------*/
  992.                         //myDocMerger.MergeDocArray(orgDocName, filecopy, orgDocName);
  994.                         /*---------------改变按钮组为可用状态-------------------*/
  995.                         //this.TB_OpenDocument_ZGdFName.Enabled = true;
  996.                         //this.TB_OpenDocument_ZgHZFName.Enabled = true;
  997.                         //this.TB_OpenDocument_ZGxFName.Enabled = true;
  998.                         //this.TB_OpenDocument_ZgHZFName.Text = "浏览电子文档";
  999.                         //this.TB_OpenDocument_ZgHZFName.Attributes.Add("onclick", "javascript:SetLinkUrl('DocTemplateCon/'+document.all('txt_ZgHZFName').value,'" + cui.EmpName + "');");
  1000.                         try
  1001.                         {
  1002.                             myDocMerger.MergeDocArray(orgDocName, filecopy1, orgDocName);
  1004.                             EtongExcel EExcel = new EtongExcel(Server.MapPath("doc\\空工作表.xls"), Server.MapPath("doc\\DocTemplateCon\\" + filename + "." + houzhui[1]));
  1005.                             EExcel.RangeCellSet(materiallist, 3, 10);
  1006.                             EExcel.SaveAsFile();
  1007.                             //EExcel.KillExcelProcess();
  1008.                             //this.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('系统提示：信息合并成功!');", true);
  1009.                             Common.RunScript(this.Page, "汇总成功！");
  1010.                             this.BT_OpenDocument_MaterialStock.Enabled = true;
  1011.                             this.MaterialStock.Value = filename + "." + houzhui[1];
  1012.                             this.BT_OpenDocument_ProjectPlan.Enabled = true;
  1013.                             this.ProjectPlan.Value = filename4 + "." + houzhui1[1];
  1014.                         }
  1015.                         catch (Exception ex)
  1016.                         {
  1017.                             //ClientScript.RegisterStartupScript(this.GetType(), "errorMessage", "<script>alert('" + ex.Message.Replace("'", "").Replace("rn", "") + "');</script>");
  1018.                             Common.RunScript(this.Page, ex.Message);
  1019.                         }
  1021.                         //this.IsCollect = true;
  1022.                         //this.IB_Collect.Enabled = false;
  1023.                         //  }
  1024.                         // else
  1025.                         // {
  1026.                         //  Common.RunScript(this.Page, "打开文档失败！");
  1027.                         // }
  1028.                     }
  1029.                     else
  1030.                     {
  1031.                         Common.RunScript(this.Page, "汇总失败，请检查相关数据！");
  1032.                     }
  1033.                 }
  1034.                 else
  1035.                 {
  1036.                     Common.RunScript(this.Page, "没有文档，不能汇总！");
  1037.                 }
  1038.             }
  1039.         }
  1041.         if (this.MustChooseItem == 23)//监督实施汇总
  1042.         {
  1043.             com.etong.DAL.FC.EtongFlyChouWFPrj etongFlyChouWFPrj = new com.etong.DAL.FC.EtongFlyChouWFPrj();
  1044.             etongFlyChouWFPrj.sID = this.actinstanceid;
  1045.             etongFlyChouWFPrj.PrjID = this.ConID;
  1046.             etongFlyChouWFPrj.wID = this.wfid;
  1047.             etongFlyChouWFPrj.iStatus = 2;
  1048.             etongFlyChouWFPrj.sBlockReason = WorkFolw.GetBlockReason(this.actinstanceid);
  1050.             if (etongFlyChouWFPrj.CheckUpActCompleteSort() == false)
  1051.             {
  1052.                 Common.RunScript(this.Page, "工作流上级所属(同类型的)活动未完成，不能汇总文档");
  1053.                 return;
  1054.             }
  1056.             else
  1057.             {
  1058.                 string xmlFileName = path + "\DocTemplateCon\" + dv[0]["ZgJdDocumentXml"].ToString();
  1059.                 XML xml = new XML(xmlFileName);
  1060.                 string xmlProjectSchedule = path + "\DocTemplateCon\" + dv[0]["JcZFName"].ToString();
  1062.                 XML jcXml = new XML(xmlProjectSchedule);
  1063.                 ArrayList list = jcXml.ReadNode("Documents", EmpType, true);
  1064.                 string[] filecopy = new string[list.Count];
  1065.                 ArrayList materiallist = new ArrayList();
  1067.                 if (filecopy.Length > 0)
  1068.                 {
  1069.                     for (int i = 0; i < filecopy.Length; i++)
  1070.                     {
  1071.                         DocumentNode documentNode = (DocumentNode)list[i];
  1072.                         filecopy[i] = path + "\\DocTemplateCon\\" + documentNode.FileName;
  1073.                         materiallist.Add(Server.MapPath("doc\\DocTemplateCon\\" + documentNode.FileName));
  1074.                     }
  1076.                     string[] houzhui = filecopy[0].Split('.');
  1078.                     MyDocMerger myDocMerger = new MyDocMerger();
  1079.                     string orgDocName = path + "\\DocTemplateCon\\" + filename1 + "." + houzhui[1];
  1080.                     //this.txt_ZgHZFName.Value = filename + "." + houzhui[1];
  1082.                     if (xml.AddXmlNode(new DocumentNode(filename1 + "." + houzhui[1], checker, time, EmpType)))
  1083.                     {
  1085.                         // if (Util.Copyfile(path + "\" + orgfilename, orgDocName))
  1086.                         // {
  1087.                         /*------------------------文档汇总----------------------*/
  1088.                         //myDocMerger.MergeDocArray(orgDocName, filecopy, orgDocName);
  1090.                         /*---------------改变按钮组为可用状态-------------------*/
  1091.                         //this.TB_OpenDocument_ZGdFName.Enabled = true;
  1092.                         //this.TB_OpenDocument_ZgHZFName.Enabled = true;
  1093.                         //this.TB_OpenDocument_ZGxFName.Enabled = true;
  1094.                         //this.TB_OpenDocument_ZgHZFName.Text = "浏览电子文档";
  1095.                         //this.TB_OpenDocument_ZgHZFName.Attributes.Add("onclick", "javascript:SetLinkUrl('DocTemplateCon/'+document.all('txt_ZgHZFName').value,'" + cui.EmpName + "');");
  1096.                         try
  1097.                         {
  1098.                             EtongExcel EExcel = new EtongExcel(Server.MapPath("doc\\空工作表.xls"), Server.MapPath("doc\\DocTemplateCon\\" + filename1 + "." + houzhui[1]));
  1099.                             EExcel.RangeCellSet(materiallist, 3, 10);
  1100.                             EExcel.SaveAsFile();
  1101.                             //EExcel.KillExcelProcess();
  1102.                             //this.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('系统提示：信息合并成功!');", true);
  1103.                             Common.RunScript(this.Page, "汇总成功！");
  1104.                             this.BT_OpenDocument_CollectSetupExecution.Enabled = true;
  1105.                             this.BT_OpenDocument_CollectSetupExecution.Attributes.Add("onclick", "javascript:SetLinkUrl2('DocTemplateCon/'+document.all('CollectSetupExecution').value,'" + cui.EmpName + "');");
  1106.                             this.CollectSetupExecution.Value = filename1 + "." + houzhui[1];
  1107.                         }
  1108.                         catch (Exception ex)
  1109.                         {
  1110.                             //ClientScript.RegisterStartupScript(this.GetType(), "errorMessage", "<script>alert('" + ex.Message.Replace("'", "").Replace("rn", "") + "');</script>");
  1111.                             Common.RunScript(this.Page, ex.Message);
  1112.                         }
  1113.                         //this.IsCollect = true;
  1114.                         //this.IB_Collect.Enabled = false;
  1115.                         //  }
  1116.                         // else
  1117.                         // {
  1118.                         //  Common.RunScript(this.Page, "打开文档失败！");
  1119.                         // }
  1120.                     }
  1121.                     else
  1122.                     {
  1123.                         Common.RunScript(this.Page, "汇总失败，请检查相关数据！");
  1124.                     }
  1125.                 }
  1126.                 else
  1127.                 {
  1128.                     Common.RunScript(this.Page, "没有文档，不能汇总！");
  1129.                 }
  1130.             }
  1131.         }
  1133.         if (this.MustChooseItem == 26)//工程进度汇总
  1134.         {
  1135.             com.etong.DAL.FC.EtongFlyChouWFPrj etongFlyChouWFPrj = new com.etong.DAL.FC.EtongFlyChouWFPrj();
  1136.             etongFlyChouWFPrj.sID = this.actinstanceid;
  1137.             etongFlyChouWFPrj.PrjID = this.ConID;
  1138.             etongFlyChouWFPrj.wID = this.wfid;
  1139.             etongFlyChouWFPrj.iStatus = 2;
  1140.             etongFlyChouWFPrj.sBlockReason = WorkFolw.GetBlockReason(this.actinstanceid);
  1142.             if (etongFlyChouWFPrj.CheckUpActCompleteSort() == false)
  1143.             //if (WorkFolw.ParentActivitysIsCompleted(this.ConID, this.ActivityID) == false)
  1144.             {
  1145.                 Common.RunScript(this.Page, "工作流上级所属(同类型的)活动未完成，不能汇总文档");
  1146.                 return;
  1147.             }
  1148.             else
  1149.             {
  1150.                 string xmlFileName = path + "\DocTemplateCon\" + dv[0]["JcSBFName"].ToString();
  1151.                 XML xml = new XML(xmlFileName);
  1152.                 string xmlProjectSchedule = Server.MapPath("doc\DocTemplateCon\" + dv[0]["ZgHzFName"].ToString());
  1154.                 XML jcXml = new XML(xmlProjectSchedule);
  1155.                 ArrayList list = xml.ReadNode("Documents", EmpType, true);
  1156.                 string[] filecopy = new string[list.Count];
  1157.                 ArrayList materiallist = new ArrayList();
  1159.                 if (filecopy.Length > 0)
  1160.                 {
  1161.                     for (int i = 0; i < filecopy.Length; i++)
  1162.                     {
  1163.                         DocumentNode documentNode = (DocumentNode)list[i];
  1164.                         filecopy[i] = path + "\\DocTemplateCon\\" + documentNode.FileName;
  1165.                         materiallist.Add(Server.MapPath("doc\\DocTemplateCon\\" + documentNode.FileName));
  1166.                     }
  1168.                     string[] houzhui = filecopy[0].Split('.');
  1170.                     MyDocMerger myDocMerger = new MyDocMerger();
  1171.                     string orgDocName = path + "\\DocTemplateCon\\" + filename1 + "." + houzhui[1];
  1172.                     //this.txt_ZgHZFName.Value = filename + "." + houzhui[1];
  1174.                     if (jcXml.AddXmlNode(new DocumentNode(filename2 + "." + houzhui[1], checker, time, EmpType)))
  1175.                     {
  1177.                         // if (Util.Copyfile(path + "\" + orgfilename, orgDocName))
  1178.                         // {
  1179.                         /*------------------------文档汇总----------------------*/
  1180.                         //myDocMerger.MergeDocArray(orgDocName, filecopy, orgDocName);
  1182.                         /*---------------改变按钮组为可用状态-------------------*/
  1183.                         //this.TB_OpenDocument_ZGdFName.Enabled = true;
  1184.                         //this.TB_OpenDocument_ZgHZFName.Enabled = true;
  1185.                         //this.TB_OpenDocument_ZGxFName.Enabled = true;
  1186.                         //this.TB_OpenDocument_ZgHZFName.Text = "浏览电子文档";
  1187.                         //this.TB_OpenDocument_ZgHZFName.Attributes.Add("onclick", "javascript:SetLinkUrl('DocTemplateCon/'+document.all('txt_ZgHZFName').value,'" + cui.EmpName + "');");
  1188.                         try
  1189.                         {
  1190.                             EtongExcel EExcel = new EtongExcel(Server.MapPath("doc\\芜湖供电公司工程进度表.xls"), Server.MapPath("doc\\DocTemplateCon\\" + filename2 + "." + houzhui[1]));
  1191.                             EExcel.RangeCellSet(materiallist, 3, 10);
  1192.                             EExcel.SaveAsFile();
  1193.                             //EExcel.KillExcelProcess();
  1194.                             //this.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('系统提示：信息合并成功!');", true);
  1195.                             Common.RunScript(this.Page, "汇总成功！");
  1196.                             //this.BT_OpenDocument_MaterialStock.Enabled = true;
  1197.                             this.BT_OpenDocument_GatherProjectSchedule.Enabled = true;
  1198.                             this.GatherProjectSchedule.Value = filename2 + "." + houzhui[1];
  1200.                             string xmlfilename = GetConstructInfo(this.ConID)[0]["GcglFName"].ToString();
  1201.                             if (xmlfilename != "")
  1202.                             {
  1203.                                 string filename11 = this.GatherProjectSchedule.Value;
  1204.                                 checker = cui.EmpName;
  1205.                                 time = DateTime.Now.ToString();
  1206.                                 string type = ProjectImplment.GetEmpType(cui.EmpID);
  1208.                                 XML xml1 = new XML(path + "\DocTemplateCon\" + xmlfilename);
  1209.                                 xml1.AddXmlNode(new DocumentNode(filename11, checker, time, type));//将基层上报的文档信息写入XML文档
  1210.                             }
  1211.                         }
  1212.                         catch (Exception ex)
  1213.                         {
  1214.                             //ClientScript.RegisterStartupScript(this.GetType(), "errorMessage", "<script>alert('" + ex.Message.Replace("'", "").Replace("rn", "") + "');</script>");
  1215.                             Common.RunScript(this.Page, ex.Message);
  1216.                         }
  1220.                         //this.IsCollect = true;
  1221.                         //this.IB_Collect.Enabled = false;
  1222.                         //  }
  1223.                         // else
  1224.                         // {
  1225.                         //  Common.RunScript(this.Page, "打开文档失败！");
  1226.                         // }
  1227.                     }
  1228.                     else
  1229.                     {
  1230.                         Common.RunScript(this.Page, "汇总失败，请检查相关数据！");
  1231.                     }
  1232.                 }
  1233.                 else
  1234.                 {
  1235.                     Common.RunScript(this.Page, "没有文档，不能汇总！");
  1236.                 }
  1237.             }
  1238.         }
  1240.         if (this.MustChooseItem == 27)//工程总进度汇总
  1241.         {
  1242.             com.etong.DAL.FC.EtongFlyChouWFPrj etongFlyChouWFPrj = new com.etong.DAL.FC.EtongFlyChouWFPrj();
  1243.             etongFlyChouWFPrj.sID = this.actinstanceid;
  1244.             etongFlyChouWFPrj.PrjID = this.ConID;
  1245.             etongFlyChouWFPrj.iID = this.WFInstanceID;
  1246.             etongFlyChouWFPrj.aID = this.ActivityID;
  1247.             etongFlyChouWFPrj.iStatus = 2;
  1248.             //etongFlyChouWFPrj.sBlockReason = WorkFolw.GetBlockReason(this.actinstanceid);
  1250.             if (etongFlyChouWFPrj.GetPrevioueTasksStatus() == false)
  1251.             {
  1252.                 Common.RunScript(this.Page, "工作流上级活动未完成，不能汇总文档");
  1253.                 return;
  1254.             }
  1255.             else
  1256.             {
  1257.                 //string xmlFileName = path + "\DocTemplateCon\" + dv[0]["GcglFName"].ToString();
  1258.                 //XML xml = new XML(xmlFileName);
  1259.                 string xmlpth = Server.MapPath("doc\\DocTemplateCon\\" + dv[0]["GcglFName"].ToString());
  1260.                 XML jcXml = new XML(path + "\\DocTemplateCon\\" + dv[0]["GcglFName"].ToString());
  1261.                 //ArrayList list = jcXml.ReadNode("Documents", EmpType, true);
  1262.                 //ArrayList list = jcXml.ReadNode("Documents");
  1263.                 ArrayList nodesname = new ArrayList();
  1264.                 nodesname.Add("FileName");
  1265.                 ArrayList list = jcXml.ReadNode(nodesname, "Documents");
  1266.                 string[] filecopy = new string[list.Count];
  1267.                 ArrayList materiallist = new ArrayList();
  1269.                 if (filecopy.Length > 0)
  1270.                 {
  1271.                     for (int i = 0; i < filecopy.Length; i++)
  1272.                     {
  1273.                         //DocumentNode documentNode = (DocumentNode)list[i];
  1274.                         string[] a = (string[])list[i];
  1275.                         filecopy[i] = path + "\\DocTemplateCon\\" + a[0].ToString();
  1276.                         materiallist.Add(Server.MapPath("doc\\DocTemplateCon\\" + a[0].ToString()));
  1277.                     }
  1279.                     string[] houzhui = filecopy[0].Split('.');
  1281.                     MyDocMerger myDocMerger = new MyDocMerger();
  1282.                     string orgDocName = path + "\\DocTemplateCon\\" + filename3 + "." + houzhui[1];
  1283.                     //this.txt_ZgHZFName.Value = filename + "." + houzhui[1];
  1285.                     //if (xml.AddXmlNode(new DocumentNode(filename + "." + houzhui[1], checker, time, EmpType)))
  1286.                     // {
  1288.                     // if (Util.Copyfile(path + "\" + orgfilename, orgDocName))
  1289.                     // {
  1290.                     /*------------------------文档汇总----------------------*/
  1291.                     //myDocMerger.MergeDocArray(orgDocName, filecopy, orgDocName);
  1293.                     /*---------------改变按钮组为可用状态-------------------*/
  1294.                     //this.TB_OpenDocument_ZGdFName.Enabled = true;
  1295.                     //this.TB_OpenDocument_ZgHZFName.Enabled = true;
  1296.                     //this.TB_OpenDocument_ZGxFName.Enabled = true;
  1297.                     //this.TB_OpenDocument_ZgHZFName.Text = "浏览电子文档";
  1298.                     //this.TB_OpenDocument_ZgHZFName.Attributes.Add("onclick", "javascript:SetLinkUrl('DocTemplateCon/'+document.all('txt_ZgHZFName').value,'" + cui.EmpName + "');");
  1299.                     try
  1300.                     {
  1301.                         EtongExcel EExcel = new EtongExcel(Server.MapPath("doc\\空工作表.xls"), Server.MapPath("doc\\DocTemplateCon\\" + filename3 + "." + houzhui[1]));
  1302.                         EExcel.RangeCellSet(materiallist, 3, 10);
  1303.                         EExcel.SaveAsFile();
  1304.                         //EExcel.KillExcelProcess();
  1305.                         //this.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('系统提示：信息合并成功!');", true);
  1306.                         Common.RunScript(this.Page, "汇总成功！");
  1307.                         this.BT_OpenDocument_ProjectAnalysis.Enabled = true;
  1308.                         this.ProjectAnalysis.Value = filename3 + "." + houzhui[1];
  1309.                     }
  1310.                     catch (Exception ex)
  1311.                     {
  1312.                         //ClientScript.RegisterStartupScript(this.GetType(), "errorMessage", "<script>alert('" + ex.Message.Replace("'", "").Replace("rn", "") + "');</script>");
  1313.                         Common.RunScript(this.Page, ex.Message);
  1314.                     }
  1315.                     //}
  1316.                     //else
  1317.                     //{
  1318.                     //   Common.RunScript(this.Page, "汇总失败，请检查相关数据！");
  1319.                     //}
  1320.                 }
  1321.                 else
  1322.                 {
  1323.                     Common.RunScript(this.Page, "没有文档，不能汇总！");
  1324.                 }
  1325.             }
  1326.         }
  1327.         //}
  1328.     }
  1330.     //
  1331.     protected bool CheckEmpTypeIsEqualBlockReason()
  1332.     {
  1333.         bool flag = false;
  1334.         int wfid = -1;
  1335.         int actid = -1;
  1337.         CheckUserInfo cui = null;
  1338.         if (Session["checkuserinfo"] != null)
  1339.         {
  1340.             cui = (CheckUserInfo)Session["checkuserinfo"];
  1341.         }
  1343.         string type = ProjectImplment.GetEmpType(cui.EmpID);
  1345.         string sql = "select * from [tb_WF_Instance] where [Status]=2 and [PrjID]=" + this.ConID;
  1347.         DataView dv = SqlServer.GetDataView(sql);
  1349.         wfid = Convert.ToInt32(dv[0]["WFInstanceID"].ToString());
  1350.         EtongZwf etongzwf = new EtongZwf();
  1351.         dv = etongzwf.ColonyUserGetByActId(ActivityID);
  1352.         if (dv.Count > 0)
  1353.         {
  1354.             actid = Convert.ToInt32(dv[0]["ParentActID"].ToString().Trim());
  1355.             sql = "select [BlockReason] from [tb_WF_ActIns] where [ActivityID]=" + actid + " and [WfInstanceID]=" + wfid;
  1356.             dv = SqlServer.GetDataView(sql);
  1357.             if (dv.Count > 0)
  1358.             {
  1359.                 if (type == dv[0]["BlockReason"].ToString())
  1360.                     flag = true;
  1361.             } 
  1362.         }
  1363.         return flag;
  1364.     }
  1366.     protected bool IsExsitNextWaitActivity()
  1367.     {
  1368.         bool flag = false;
  1369.         int wfid = -1;
  1370.         int actid = -1;
  1372.         string sql = "select * from [tb_WF_Instance] where [Status]=2 and [PrjID]=" + this.ConID;
  1374.         DataView dv = SqlServer.GetDataView(sql);
  1376.         wfid = Convert.ToInt32(dv[0]["WFInstanceID"].ToString());
  1377.         EtongZwf etongzwf = new EtongZwf();
  1378.         dv = etongzwf.ColonyUserGetByActId(ActivityID);
  1379.         if (dv.Count > 0)
  1380.         {
  1381.             actid = Convert.ToInt32(dv[0]["ParentActID"].ToString().Trim());
  1382.             sql = "select * from [tb_WF_ActIns] where [ActivityID]=" + actid + " and [WfInstanceID]=" + wfid;
  1383.             dv = SqlServer.GetDataView(sql);
  1384.             if (dv.Count > 0)
  1385.             {
  1386.                // if (type == dv[0]["BlockReason"].ToString())
  1387.                 flag = true;
  1388.             }
  1389.         }
  1390.         return flag;
  1391.     }
  1392. }