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

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

.net编程

开发平台：

C#

OldMaterialManagement.aspx.cs：源码内容
  1. using System;
  2. using System.Data;
  3. using System.Configuration;
  4. using System.Collections;
  5. using System.Web;
  6. using System.Web.Security;
  7. using System.Web.UI;
  8. using System.Web.UI.WebControls;
  9. using System.Web.UI.WebControls.WebParts;
  10. using System.Web.UI.HtmlControls;
  11. using com.etong.DAL;
  12. using com.etong.DBUtility;
  13. using com.etong.Inform;
  14. using com.etong.BusinessRule;
  15. using com.etong.BusinessRule.Zwf;
  16. using com.etong.Model;
  17. using com.etong.Utility;
  18. using DocMergerComponent;
  20. public partial class Workflow_OldMaterialManagement : System.Web.UI.Page
  21. {
  22.     protected int userid = -1;
  23.     protected int wfid = -1;//当前工作流ID
  25.     protected int MustChooseItem = -1;//必选项
  26.     protected int ActivityID = -1;//活动ID
  27.     protected int WFInstanceID = -1;//工作流实例ID
  28.     protected int actinstanceid = -1;//活动实例ID
  29.     protected int ActID = -1;//活动实例ID
  30.     protected bool IsUntread = true;//是否回退
  31.     protected int shuntFlag = 0;//分流标志(0、不分流；1、小件；2、大件；)
  32.     protected int MatID = -1;
  33.     protected bool IsCollect = false;
  35.     protected string rolestr()
  36.     {
  37.         string rolestr = "";
  38.         if (userid != -1)
  39.         {
  40.             EtongZwf etongzwf = new EtongZwf();
  41.             DataView dvrole = etongzwf.RoleGetByID(userid);
  43.             for (int i = 0; i < dvrole.Count; i++)
  44.             {
  45.                 rolestr = rolestr + dvrole[i][0].ToString().Trim() + ",";
  47.             }
  48.         }
  49.         return rolestr;
  50.     }
  52.     protected void Page_Load(object sender, EventArgs e)
  53.     {
  54.         //------------------------------------------变量定义-----------------------------------------------
  55.         DataView dv = null;
  56.         CheckUserInfo cui = null;
  58.         if (Request.QueryString["MustChooseItem"] != null)
  59.         {
  60.             string MustChooseItemtxt = "";
  61.             MustChooseItemtxt = Request.QueryString["MustChooseItem"].ToString().Trim();
  62.             MustChooseItem = Convert.ToInt16(MustChooseItemtxt);
  63.         }
  65.         string ActivityIDtxt = "";
  66.         if (Request.QueryString["ActivityID"] != null)
  67.         {
  69.             ActivityIDtxt = Request.QueryString["ActivityID"].ToString().Trim();
  70.             ActivityID = Convert.ToInt32(ActivityIDtxt);
  71.         }
  73.         string WFInstanceIDtxt = "";
  74.         if (Request.QueryString["WFInstanceID"] != null)
  75.         {
  77.             WFInstanceIDtxt = Request.QueryString["WFInstanceID"].ToString().Trim();
  78.         }
  80.         string WFIDtxt = "";
  81.         if (Request.QueryString["WFID"] != null)
  82.         {
  84.             WFIDtxt = Request.QueryString["WFID"].ToString().Trim();
  85.             wfid = Convert.ToInt16(WFIDtxt);
  86.         }
  87.         if (Request.QueryString["ActID"] != null)
  88.         {
  89.             actinstanceid = Convert.ToInt32(Request.QueryString["ActID"].ToString());
  90.         }
  94.         //----------------------------------------对象定义--------------------------------------------------
  95.         if (Session["checkuserinfo"] != null)
  96.         {
  97.             cui = (CheckUserInfo)Session["checkuserinfo"];
  98.             userid = cui.UserID;
  99.         }
  101.         if (ActivityIDtxt != "" && WFInstanceIDtxt != "")
  102.         {
  103.             if (Convert.ToInt32(ActivityIDtxt) != -1 && Convert.ToInt32(WFInstanceIDtxt) != -1)
  104.             {
  105.                 WFInstanceID = Convert.ToInt32(WFInstanceIDtxt);
  106.                 string sql = "select * from [tb_WF_Instance] where [WFInstanceID]=" + WFInstanceID;
  107.                 dv = SqlServer.GetDataView(sql);
  108.                 if (dv.Count > 0)
  109.                 {
  110.                     wfid = Convert.ToInt32(dv[0][8].ToString().Trim());
  111.                     this.MatID = Convert.ToInt32(dv[0][9].ToString().Trim());
  112.                 }
  113.             }
  114.         }
  116.         string path = Server.MapPath("doc").Replace("\", "\\");      //获取项目所在路径
  117.         int tempStatus = WorkFolw.GetCurrentActivityInstanceStatus(this.actinstanceid);//当前活动实例状态
  120.         switch (MustChooseItem)
  121.         {
  122.             /*==============================================================================================
  123.              * 
  124.              *                                  废旧物资开始
  125.              * 
  126.              *=============================================================================================*/
  127.             case 69:
  128.                 SetAllPanelsVisibility(true, false, false, false, false, false, false, false, false, false, true);
  129.                 IsUntread = false;//起始活动不可回退
  130.                 break;
  132.             /*==============================================================================================
  133.              * 
  134.              *                                基层单位上报废旧物资
  135.              * 
  136.              *=============================================================================================*/
  137.             case 70:
  138.                 SetAllPanelsVisibility(true, true, false, false, false, false, false, false, false, false, true);
  139.                 if (!this.Page.IsPostBack)
  140.                 {
  141.                     BindPrjOldMatInfoToPageControls();
  142.                     string filename_MaterialRemove = GetDocumentFileName(this.ActivityID);
  143.                     this.txt_MaterialRemove.Value = MakeNewFileNameWithDate(filename_MaterialRemove);
  145.                     /*-------------------------------文档拷贝-------------------------------*/
  146.                     if (!(Util.Copyfile(path + "\" + filename_MaterialRemove, path + "\DocTemplateMat\" + this.txt_MaterialRemove.Value)))
  147.                     {
  148.                         Common.RunScript(this.Page, "打开模板失败,请检查相关设置!");
  149.                         return;
  150.                     }
  151.                     this.ShowOperatorAndTime_ReportOldMaterial.InnerHtml = "<div align='center'>上报人/上报时间:<font color='red'>&nbsp;&nbsp;&nbsp;&nbsp;" + cui.EmpName + "   " + DateTime.Now.ToShortDateString() + " " + DateTime.Now.Hour + ":" + DateTime.Now.Minute + "</font></div>";
  152.                     this.BT_OpenDocument_MaterialRemove.Attributes.Add("onclick", "javascript:SetLinkUrl('DocTemplateMat/'+document.all('txt_MaterialRemove').value,'" + cui.EmpName + "');");
  153.                 }
  154.                 break;
  155.             /*==============================================================================================
  156.              * 
  157.              *                                主管部门废旧物资汇总
  158.              * 
  159.              *=============================================================================================*/
  160.             case 77:
  161.                 SetAllPanelsVisibility(true, true, true, false, false, false, false, false, false, false, true);
  162.                 if (!this.Page.IsPostBack)
  163.                 {
  164.                     BindPrjOldMatInfoToPageControls();
  165.                     this.TB_OpenDocument_ZGdFName.Enabled = false;
  166.                     this.TB_OpenDocument_ZgHZFName.Enabled = false;
  167.                     this.TB_OpenDocument_ZGxFName.Enabled = false;
  168.                     this.IB_Collect.Visible = true;
  170.                     string filename_DJ = "废旧物资汇总大件表" + DateTime.Now.Year + DateTime.Now.Month + DateTime.Now.Day + DateTime.Now.Hour + DateTime.Now.Minute + DateTime.Now.Second + ".doc";
  171.                     string filename_XJ = "废旧物资汇总表" + DateTime.Now.Year + DateTime.Now.Month + DateTime.Now.Day + DateTime.Now.Hour + DateTime.Now.Minute + DateTime.Now.Second + ".doc";
  172.                     this.txt_ZGxFName.Value = filename_XJ;
  173.                     this.txt_ZGdFName.Value = filename_DJ;
  175.                     /*-------------------------------文档(大件、小件文档)拷贝-------------------------------*/
  176.                     if (!(Util.Copyfile(path + "\大件汇总表.doc", path + "\DocTemplateMat\" + filename_DJ) && Util.Copyfile(path + "\小件汇总表.doc", path + "\DocTemplateMat\" + filename_XJ)))
  177.                     {
  178.                         Common.RunScript(this.Page, "打开模板失败,请检查相关设置!");
  179.                         return;
  180.                     }
  182.                     this.TB_OpenDocument_ZGxFName.Attributes.Add("onclick", "javascript:SetLinkUrl('DocTemplateMat/'+document.all('txt_ZGxFName').value,'" + cui.EmpName + "');");
  183.                     this.TB_OpenDocument_ZGdFName.Attributes.Add("onclick", "javascript:SetLinkUrl('DocTemplateMat/'+document.all('txt_ZGdFName').value,'" + cui.EmpName + "');");
  184.                 }
  185.                 break;
  186.             /*==============================================================================================
  187.              * 
  188.              *                                废旧物资大件
  189.              * 
  190.              *=============================================================================================*/
  191.             case 71:
  192.                 SetAllPanelsVisibility(true, false, true, false, false, false, false, false, false, false, true);
  193.                 if (!this.Page.IsPostBack)
  194.                 {
  195.                     BindPrjOldMatInfoToPageControls();
  196.                     this.TB_OpenDocument_ZGxFName.Enabled = false;
  197.                     this.TB_OpenDocument_ZgHZFName.Text = "浏览电子文档";
  198.                     this.TB_OpenDocument_ZgHZFName.Attributes.Add("onclick", "javascript:SetLinkUrl('DocTemplateMat/'+document.all('txt_ZgHZFName').value,'" + cui.EmpName + "');");
  199.                     this.TB_OpenDocument_ZGxFName.Text = "浏览电子文档";
  200.                     this.TB_OpenDocument_ZGxFName.Attributes.Add("onclick", "javascript:SetLinkUrl('DocTemplateMat/'+document.all('txt_ZGxFName').value,'" + cui.EmpName + "');");
  201.                     this.TB_OpenDocument_ZGdFName.Text = "浏览电子文档";
  202.                     this.TB_OpenDocument_ZGdFName.Attributes.Add("onclick", "javascript:SetLinkUrl('DocTemplateMat/'+document.all('txt_ZGdFName').value,'" + cui.EmpName + "');");
  203.                 }
  204.                 break;
  205.             /*==============================================================================================
  206.              * 
  207.              *                                废旧物资小件
  208.              * 
  209.              *=============================================================================================*/
  210.             case 72:
  211.                 SetAllPanelsVisibility(true, false, true, false, false, false, false, false, false, false, true);
  212.                 if (!this.Page.IsPostBack)
  213.                 {
  214.                     BindPrjOldMatInfoToPageControls();
  215.                     this.TB_OpenDocument_ZgHZFName.Text = "浏览电子文档";
  216.                     this.TB_OpenDocument_ZgHZFName.Attributes.Add("onclick", "javascript:SetLinkUrl('DocTemplateMat/'+document.all('txt_ZgHZFName').value,'" + cui.EmpName + "');");
  217.                     this.TB_OpenDocument_ZGxFName.Text = "浏览电子文档";
  218.                     this.TB_OpenDocument_ZGdFName.Enabled = false;
  219.                     this.TB_OpenDocument_ZGxFName.Attributes.Add("onclick", "javascript:SetLinkUrl('DocTemplateMat/'+document.all('txt_ZGxFName').value,'" + cui.EmpName + "');");
  220.                     this.TB_OpenDocument_ZGdFName.Text = "浏览电子文档";
  221.                     this.TB_OpenDocument_ZGdFName.Attributes.Add("onclick", "javascript:SetLinkUrl('DocTemplateMat/'+document.all('txt_ZGdFName').value,'" + cui.EmpName + "');");
  222.                 }
  223.                 break;
  224.             /*==============================================================================================
  225.              * 
  226.              *                                物资公司收集汇总材料
  227.              * 
  228.              *=============================================================================================*/
  229.             case 73:
  230.                 SetAllPanelsVisibility(true, false, true, true, false, false, false, false, false, false, true);
  231.                 if (!this.Page.IsPostBack)
  232.                 {
  233.                     BindPrjOldMatInfoToPageControls();
  234.                     this.TB_WZjIdea.Text = "同意";
  235.                     this.TB_OpenDocument_ZgHZFName.Text = "浏览电子文档";
  236.                     this.TB_OpenDocument_ZgHZFName.Attributes.Add("onclick", "javascript:SetLinkUrl('DocTemplateMat/'+document.all('txt_ZgHZFName').value,'" + cui.EmpName + "');");
  237.                     this.TB_OpenDocument_ZGxFName.Text = "浏览电子文档";
  238.                     this.TB_OpenDocument_ZGdFName.Enabled = false;
  239.                     this.TB_OpenDocument_ZGxFName.Attributes.Add("onclick", "javascript:SetLinkUrl('DocTemplateMat/'+document.all('txt_ZGxFName').value,'" + cui.EmpName + "');");
  240.                     this.TB_OpenDocument_ZGdFName.Text = "浏览电子文档";
  241.                     this.TB_OpenDocument_ZGdFName.Attributes.Add("onclick", "javascript:SetLinkUrl('DocTemplateMat/'+document.all('txt_ZGdFName').value,'" + cui.EmpName + "');");
  242.                 }
  243.                 break;
  244.             /*==============================================================================================
  245.              * 
  246.              *                                物资公司汇总
  247.              * 
  248.              *=============================================================================================*/
  249.             case 78:
  250.                 SetAllPanelsVisibility(true, false, true, true, true, false, false, false, false, false, true);
  251.                 if (!this.Page.IsPostBack)
  252.                 {
  253.                     BindPrjOldMatInfoToPageControls();
  254.                     this.TB_WZjIdea.Enabled = false;
  255.                     this.TB_OpenDocument_ZgHZFName.Text = "浏览电子文档";
  256.                     this.TB_OpenDocument_ZgHZFName.Attributes.Add("onclick", "javascript:SetLinkUrl('DocTemplateMat/'+document.all('txt_ZgHZFName').value,'" + cui.EmpName + "');");
  257.                     this.TB_OpenDocument_ZGxFName.Text = "浏览电子文档";
  258.                     this.TB_OpenDocument_ZGdFName.Enabled = false;
  259.                     this.TB_OpenDocument_ZGxFName.Attributes.Add("onclick", "javascript:SetLinkUrl('DocTemplateMat/'+document.all('txt_ZGxFName').value,'" + cui.EmpName + "');");
  260.                     this.TB_OpenDocument_ZGdFName.Text = "浏览电子文档";
  261.                     this.TB_OpenDocument_ZGdFName.Attributes.Add("onclick", "javascript:SetLinkUrl('DocTemplateMat/'+document.all('txt_ZGdFName').value,'" + cui.EmpName + "');");
  263.                     string filename_MaterialCollect = "物资汇总表.doc";
  264.                     this.txt_MaterialCollect.Value = MakeNewFileNameWithDate(filename_MaterialCollect);
  265.                     if (!(Util.Copyfile(path + "\小件汇总表.doc", path + "\DocTemplateMat\" + this.txt_MaterialCollect.Value)))
  266.                     {
  267.                         Common.RunScript(this.Page, "打开模板失败,请检查相关设置!");
  268.                         return;
  269.                     }
  271.                     this.BT_OpenDocument_MaterialCollect.Attributes.Add("onclick", "javascript:SetLinkUrl('DocTemplateMat/'+document.all('txt_MaterialCollect').value,'" + cui.EmpName + "');");
  272.                 }
  273.                 break;
  274.             /*==============================================================================================
  275.              * 
  276.              *                                编写废旧物资
  277.              * 
  278.              *=============================================================================================*/
  279.             case 79:
  280.                 SetAllPanelsVisibility(true, false, true, true, false, true, false, false, false, false, true);
  281.                 if (!this.Page.IsPostBack)
  282.                 {
  283.                     BindPrjOldMatInfoToPageControls();
  284.                     this.TB_WZjIdea.Enabled = false;
  285.                     this.TB_OpenDocument_ZgHZFName.Text = "浏览电子文档";
  286.                     this.TB_OpenDocument_ZgHZFName.Attributes.Add("onclick", "javascript:SetLinkUrl('DocTemplateMat/'+document.all('txt_ZgHZFName').value,'" + cui.EmpName + "');");
  287.                     this.TB_OpenDocument_ZGxFName.Text = "浏览电子文档";
  288.                     this.TB_OpenDocument_ZGdFName.Enabled = false;
  289.                     this.TB_OpenDocument_ZGxFName.Attributes.Add("onclick", "javascript:SetLinkUrl('DocTemplateMat/'+document.all('txt_ZGxFName').value,'" + cui.EmpName + "');");
  290.                     this.TB_OpenDocument_ZGdFName.Text = "浏览电子文档";
  291.                     this.TB_OpenDocument_ZGdFName.Attributes.Add("onclick", "javascript:SetLinkUrl('DocTemplateMat/'+document.all('txt_ZGdFName').value,'" + cui.EmpName + "');");
  293.                     string filename_OldMaterial = GetDocumentFileName(this.ActivityID);
  294.                     this.txt_WZqFName.Value =MakeNewFileNameWithDate (filename_OldMaterial );
  295.                     if (!(Util.Copyfile(path + "\" + filename_OldMaterial, path + "\DocTemplateMat\" + this.txt_WZqFName.Value)))
  296.                     {
  297.                         Common.RunScript(this.Page, "打开模板失败,请检查相关设置!");
  298.                         return;
  299.                     }
  301.                     this.BT_OpenDocument_OldMaterialBill.Attributes.Add("onclick", "javascript:SetLinkUrl('DocTemplateMat/'+document.all('txt_WZqFName').value,'" + cui.EmpName + "');");
  302.                 }
  303.                 break;
  304.             /*==============================================================================================
  305.              * 
  306.              *                                工程管理办公室审核
  307.              * 
  308.              *=============================================================================================*/
  309.             case 75:
  310.                 SetAllPanelsVisibility(true, false, true, true, true, false, true, false, false, false, true);
  311.                 if (!this.Page.IsPostBack)
  312.                 {
  313.                     BindPrjOldMatInfoToPageControls();
  314.                     this.TB_GcglIdea.Text = "同意";
  315.                     this.TB_WZjIdea.Enabled = false;
  316.                     this.TB_OpenDocument_ZgHZFName.Text = "浏览电子文档";
  317.                     this.TB_OpenDocument_ZgHZFName.Attributes.Add("onclick", "javascript:SetLinkUrl('DocTemplateMat/'+document.all('txt_ZgHZFName').value,'" + cui.EmpName + "');");
  318.                     this.TB_OpenDocument_ZGxFName.Text = "浏览电子文档";
  319.                     this.TB_OpenDocument_ZGdFName.Enabled = false;
  320.                     this.TB_OpenDocument_ZGxFName.Attributes.Add("onclick", "javascript:SetLinkUrl('DocTemplateMat/'+document.all('txt_ZGxFName').value,'" + cui.EmpName + "');");
  321.                     this.TB_OpenDocument_ZGdFName.Text = "浏览电子文档";
  322.                     this.TB_OpenDocument_ZGdFName.Attributes.Add("onclick", "javascript:SetLinkUrl('DocTemplateMat/'+document.all('txt_ZGdFName').value,'" + cui.EmpName + "');");
  324.                     //string filename_MaterialCollect = "物资汇总表.doc";
  325.                     //this.txt_MaterialCollect.Value = MakeNewFileNameWithDate(filename_MaterialCollect);
  326.                     //if (!(Util.Copyfile(path + "\小件汇总表.doc", path + "\DocTemplateMat\" + this.txt_MaterialCollect.Value)))
  327.                     //{
  328.                     //    Common.RunScript(this.Page, "打开模板失败,请检查相关设置!");
  329.                     //    return;
  330.                     //}
  332.                     this.BT_OpenDocument_MaterialCollect.Text = "浏览电子文档";
  333.                     this.BT_OpenDocument_MaterialCollect.Attributes.Add("onclick", "javascript:SetLinkUrl('DocTemplateMat/'+document.all('txt_MaterialCollect').value,'" + cui.EmpName + "');");
  334.                 }
  335.                 break;
  336.             /*==============================================================================================
  337.              * 
  338.              *                                  公司领导审核
  339.              * 
  340.              *=============================================================================================*/
  341.             case 74:
  342.                 SetAllPanelsVisibility(true, false, true, true, true, false, true, true, false, false, true);
  343.                 if (!this.Page.IsPostBack)
  344.                 {
  345.                     BindPrjOldMatInfoToPageControls();
  346.                     this.TB_GcglIdea.Enabled = false;
  347.                     this.TB_GSldIdea.Text = "同意";
  348.                     this.TB_WZjIdea.Enabled = false;
  349.                     this.TB_OpenDocument_ZgHZFName.Text = "浏览电子文档";
  350.                     this.TB_OpenDocument_ZgHZFName.Attributes.Add("onclick", "javascript:SetLinkUrl('DocTemplateMat/'+document.all('txt_ZgHZFName').value,'" + cui.EmpName + "');");
  351.                     this.TB_OpenDocument_ZGxFName.Text = "浏览电子文档";
  352.                     this.TB_OpenDocument_ZGdFName.Enabled = false;
  353.                     this.TB_OpenDocument_ZGxFName.Attributes.Add("onclick", "javascript:SetLinkUrl('DocTemplateMat/'+document.all('txt_ZGxFName').value,'" + cui.EmpName + "');");
  354.                     this.TB_OpenDocument_ZGdFName.Text = "浏览电子文档";
  355.                     this.TB_OpenDocument_ZGdFName.Attributes.Add("onclick", "javascript:SetLinkUrl('DocTemplateMat/'+document.all('txt_ZGdFName').value,'" + cui.EmpName + "');");
  357.                     //string filename_MaterialCollect = "物资汇总表.doc";
  358.                     //this.txt_MaterialCollect.Value = MakeNewFileNameWithDate(filename_MaterialCollect);
  359.                     //if (!(Util.Copyfile(path + "\小件汇总表.doc", path + "\DocTemplateMat\" + this.txt_MaterialCollect.Value)))
  360.                     //{
  361.                     //    Common.RunScript(this.Page, "打开模板失败,请检查相关设置!");
  362.                     //    return;
  363.                     //}
  365.                     this.BT_OpenDocument_MaterialCollect.Text = "浏览电子文档";
  366.                     this.BT_OpenDocument_MaterialCollect.Attributes.Add("onclick", "javascript:SetLinkUrl('DocTemplateMat/'+document.all('txt_MaterialCollect').value,'" + cui.EmpName + "');");
  367.                 }
  368.                 break;
  370.             /*==============================================================================================
  371.              * 
  372.              *                                  物资公司审核
  373.              * 
  374.              *=============================================================================================*/
  375.             case 76:
  376.                 SetAllPanelsVisibility(true, false, true, true, true, false, true, true, true, false, true);
  377.                 if (!this.Page.IsPostBack)
  378.                 {
  379.                     BindPrjOldMatInfoToPageControls();
  380.                     this.TB_GcglIdea.Enabled = false;
  381.                     this.TB_GSldIdea.Enabled = false;
  382.                     this.TB_WZjIdea.Enabled = false;
  383.                     this.TB_WZfIdea.Text = "同意";
  384.                     this.TB_OpenDocument_ZgHZFName.Text = "浏览电子文档";
  385.                     this.TB_OpenDocument_ZgHZFName.Attributes.Add("onclick", "javascript:SetLinkUrl('DocTemplateMat/'+document.all('txt_ZgHZFName').value,'" + cui.EmpName + "');");
  386.                     this.TB_OpenDocument_ZGxFName.Text = "浏览电子文档";
  387.                     this.TB_OpenDocument_ZGdFName.Enabled = false;
  388.                     this.TB_OpenDocument_ZGxFName.Attributes.Add("onclick", "javascript:SetLinkUrl('DocTemplateMat/'+document.all('txt_ZGxFName').value,'" + cui.EmpName + "');");
  389.                     this.TB_OpenDocument_ZGdFName.Text = "浏览电子文档";
  390.                     this.TB_OpenDocument_ZGdFName.Attributes.Add("onclick", "javascript:SetLinkUrl('DocTemplateMat/'+document.all('txt_ZGdFName').value,'" + cui.EmpName + "');");
  392.                     //string filename_MaterialCollect = "物资汇总表.doc";
  393.                     //this.txt_MaterialCollect.Value = MakeNewFileNameWithDate(filename_MaterialCollect);
  394.                     //if (!(Util.Copyfile(path + "\小件汇总表.doc", path + "\DocTemplateMat\" + this.txt_MaterialCollect.Value)))
  395.                     //{
  396.                     //    Common.RunScript(this.Page, "打开模板失败,请检查相关设置!");
  397.                     //    return;
  398.                     //}
  400.                     this.BT_OpenDocument_MaterialCollect.Text = "浏览电子文档";
  401.                     this.BT_OpenDocument_MaterialCollect.Attributes.Add("onclick", "javascript:SetLinkUrl('DocTemplateMat/'+document.all('txt_MaterialCollect').value,'" + cui.EmpName + "');");
  402.                 }
  403.                 break;
  405.             /*==============================================================================================
  406.         　　 * 
  407.          　　*                                  竣工材料存档
  408.              * 
  409.              *=============================================================================================*/
  410.             case 100:
  411.                 SetAllPanelsVisibility(true, false, true, true, true, false, true, true, true, true, true);
  412.                 if (!this.Page.IsPostBack)
  413.                 {
  414.                     BindPrjOldMatInfoToPageControls();
  415.                     this.TB_GcglIdea.Enabled = false;
  416.                     this.TB_GSldIdea.Enabled = false;
  417.                     this.TB_WZjIdea.Enabled = false;
  418.                     this.TB_WZfIdea.Enabled = false;
  419.                     this.TB_ZGgIdea.Text="同意";
  420.                     this.TB_OpenDocument_ZgHZFName.Text = "浏览电子文档";
  421.                     this.TB_OpenDocument_ZgHZFName.Attributes.Add("onclick", "javascript:SetLinkUrl('DocTemplateMat/'+document.all('txt_ZgHZFName').value,'" + cui.EmpName + "');");
  422.                     this.TB_OpenDocument_ZGxFName.Text = "浏览电子文档";
  423.                     this.TB_OpenDocument_ZGdFName.Enabled = false;
  424.                     this.TB_OpenDocument_ZGxFName.Attributes.Add("onclick", "javascript:SetLinkUrl('DocTemplateMat/'+document.all('txt_ZGxFName').value,'" + cui.EmpName + "');");
  425.                     this.TB_OpenDocument_ZGdFName.Text = "浏览电子文档";
  426.                     this.TB_OpenDocument_ZGdFName.Attributes.Add("onclick", "javascript:SetLinkUrl('DocTemplateMat/'+document.all('txt_ZGdFName').value,'" + cui.EmpName + "');");
  428.                     //string filename_MaterialCollect = "物资汇总表.doc";
  429.                     //this.txt_MaterialCollect.Value = MakeNewFileNameWithDate(filename_MaterialCollect);
  430.                     //if (!(Util.Copyfile(path + "\小件汇总表.doc", path + "\DocTemplateMat\" + this.txt_MaterialCollect.Value)))
  431.                     //{
  432.                     //    Common.RunScript(this.Page, "打开模板失败,请检查相关设置!");
  433.                     //    return;
  434.                     //}
  435.                     this.BT_OpenDocument_MaterialCollect.Text = "浏览电子文档";
  436.                     this.BT_OpenDocument_MaterialCollect.Attributes.Add("onclick", "javascript:SetLinkUrl('DocTemplateMat/'+document.all('txt_MaterialCollect').value,'" + cui.EmpName + "');");
  437.                 }
  438.                 break;
  439.         }
  442.         if (!this.Page.IsPostBack)
  443.         {
  444.             CreateYearToBindDropDownList_Year();
  445.             this.UpdateMaterialName.Attributes.Add("href", "javascript:winOpen(" + this.MatID + ",'" + GetPrjOldMatInfo(this.MatID)[0]["MatName"].ToString() + "')");
  446.         }
  447.     }
  450.     private void BindPrjOldMatInfoToPageControls()
  451.     {
  452.         DataView dv = GetPrjOldMatInfo(this.MatID);
  453.         if (dv.Count > 0)
  454.         {
  455.             this.DDL_Year.SelectedValue = dv[0]["nf"].ToString();
  456.             this.DDL_Year.Enabled = false;
  457.             this.DDL_Quarter.SelectedValue = dv[0]["jd"].ToString();
  458.             this.DDL_Quarter.Enabled = false;
  460.             //this.txt_MaterialRemove.Value = dv[0][""].ToString();
  461.             this.ShowOperatorAndTime_ReportOldMaterial.InnerHtml = "<div align='center'>上报人/上报时间:<font color='red'>&nbsp;&nbsp;&nbsp;&nbsp;" + dv[0]["JcTransactor"].ToString() + "</font></div>";
  463.             this.txt_ZgHZFName.Value = GetEmpTypeDocument();
  464.             this.txt_ZGdFName.Value = dv[0]["ZGdFName"].ToString();
  465.             this.txt_ZGxFName.Value = dv[0]["ZGxFName"].ToString();
  466.             this.ShowOperatorAndTime_ZgTransactor.InnerHtml = "<div align='center'>审核人/审核时间:<font color='red'>&nbsp;&nbsp;&nbsp;&nbsp;" + dv[0]["ZgTransactor"].ToString() + "</font></div>";
  468.             this.TB_WZjIdea.Text = dv[0]["WZjIdea"].ToString();
  469.             this.ShowOperatorAndTime_WZjTransactor.InnerHtml = "<div align='center'>审核人/审核时间:<font color='red'>&nbsp;&nbsp;&nbsp;&nbsp;" + dv[0]["WZjTransactor"].ToString() + "</font></div>";
  471.             this.txt_MaterialCollect.Value = dv[0]["WZhFName"].ToString();
  472.             this.ShowOperatorAndTime_WZhTransactor.InnerHtml = "<div align='center'>审核人/审核时间:<font color='red'>&nbsp;&nbsp;&nbsp;&nbsp;" + dv[0]["WZhTransactor"].ToString() + "</font></div>";
  474.             this.txt_WZqFName.Value = dv[0]["WZqFName"].ToString();
  475.             this.ShowOperatorAndTime_WZqTransactor.InnerHtml = "<div align='center'>审核人/审核时间:<font color='red'>&nbsp;&nbsp;&nbsp;&nbsp;" + dv[0]["WZqTransactor"].ToString() + "</font></div>";
  477.             this.TB_GcglIdea.Text = dv[0]["GcglIdea"].ToString();
  478.             this.ShowOperatorAndTime_GcglTransactor.InnerHtml = "<div align='center'>审核人/审核时间:<font color='red'>&nbsp;&nbsp;&nbsp;&nbsp;" + dv[0]["GcglTransactor"].ToString() + "</font></div>";
  480.             this.TB_GSldIdea.Text = dv[0]["GSldIdea"].ToString();
  481.             this.ShowOperatorAndTime_GSldTansactor.InnerHtml = "<div align='center'>审核人/审核时间:<font color='red'>&nbsp;&nbsp;&nbsp;&nbsp;" + dv[0]["GSldTansactor"].ToString() + "</font></div>";
  483.             this.TB_WZfIdea.Text = dv[0]["WZfIdea"].ToString();
  484.             this.ShowOperatorAndTime_WZfTransactor.InnerHtml = "<div align='center'>审核人/审核时间:<font color='red'>&nbsp;&nbsp;&nbsp;&nbsp;" + dv[0]["WZfTransactor"].ToString() + "</font></div>";
  486.             this.TB_ZGgIdea.Text = dv[0]["ZGgIdea"].ToString();
  487.             this.ShowOperatorAndTime_ZGgTransactor.InnerHtml = "<div align='center'>审核人/审核时间:<font color='red'>&nbsp;&nbsp;&nbsp;&nbsp;" + dv[0]["ZGgTransactor"].ToString() + "</font></div>";
  488.         }
  489.     }
  491.     private DataView GetPrjOldMatInfo(int matid)
  492.     {
  493.         string sql = "select * from [tb_PrjOldMat] where [MatID]=" + matid;
  494.         DataView dv = SqlServer.GetDataView(sql);
  495.         return dv;
  496.     }
  498.     private void SetAllPanelsVisibility(
  499.         bool flag_BeginOldMaterialManagement, bool flag_ReportOldMaterial, bool flag_MasterDepartCollectOldMaterial, bool flag_CollectOldMaterial,
  500.         bool flag_MaterialCompanyCollect, bool flag_EditOldMaterialBill, bool flag_ProjectManagementOfficeCheck, bool flag_CompanyLeaderCheck,
  501.         bool flag_MaterialCompanyCheck, bool flag_SaveCompleteMaterial, bool flag_Button)
  502.     {
  503.         this.Panel_BeginOldMaterialManagement.Visible = flag_BeginOldMaterialManagement;
  504.         this.Panel_ReportOldMaterial.Visible = flag_ReportOldMaterial;
  505.         this.Panel_MasterDepartCollectOldMaterial.Visible = flag_MasterDepartCollectOldMaterial;
  506.         this.Panel_CollectOldMaterial.Visible = flag_CollectOldMaterial;
  507.         this.Panel_MaterialCompanyCollect.Visible = flag_MaterialCompanyCollect;
  508.         this.Panel_EditOldMaterialBill.Visible = flag_EditOldMaterialBill;
  509.         this.Panel_ProjectManagementOfficeCheck.Visible = flag_ProjectManagementOfficeCheck;
  510.         this.Panel_CompanyLeaderCheck.Visible = flag_CompanyLeaderCheck;
  511.         this.Panel_MaterialCompanyCheck.Visible = flag_MaterialCompanyCheck;
  512.         this.Panel_SaveCompleteMaterial.Visible = flag_SaveCompleteMaterial;
  513.         this.Panel_Button.Visible = flag_Button;
  514.     }
  516.     private void CreateYearToBindDropDownList_Year()
  517.     {
  518.         int year = DateTime.Now.Year;
  519.         for (int i = year ; i >= year-10; i--)
  520.         {
  521.             this.DDL_Year.Items.Add(new ListItem(i.ToString(), i.ToString()));
  522.         }
  523.     }
  524.     protected void BT_Pass_Click(object sender, ImageClickEventArgs e)
  525.     {
  526.         if (Request.QueryString["MustChooseItem"] != null)
  527.         {
  528.             string MustChooseItemtxt = "";
  529.             MustChooseItemtxt = Request.QueryString["MustChooseItem"].ToString().Trim();
  530.             MustChooseItem = Convert.ToInt16(MustChooseItemtxt);
  531.         }
  532.         string path = Server.MapPath("doc").Replace("\", "\\");      //获取项目所在路径
  534.         CheckUserInfo cui = (CheckUserInfo)Session["checkuserinfo"];
  535.         string sql = "";
  536.         switch (MustChooseItem)
  537.         {
  538.             /*==============================================================================================
  539.              * 
  540.              *                                 废旧物资开始(审核通过code)
  541.              * 
  542.              *=============================================================================================*/
  543.             case 69:
  544.                 int tempStatus = WorkFolw.GetCurrentActivityInstanceStatus(this.actinstanceid);//当前活动实例状态
  545.                 if (tempStatus == 2)
  546.                 {
  547.                     WFInstADD("您已审核通过!",false);
  548.                 }
  549.                 else
  550.                 {
  551.                     string xmlFileName = "CollectDocument" + DateTime.Now.Year + DateTime.Now.Month + DateTime.Now.Day + DateTime.Now.Hour + DateTime.Now.Minute + DateTime.Now.Second + ".xml";
  552.                     string year = this.DDL_Year.SelectedValue;
  553.                     string quarter = this.DDL_Quarter.SelectedValue;
  555.                     sql = "update [tb_PrjOldMat] set [nf]='" + year + "',[jd]='" + quarter + "',[DocumentXML]='" + xmlFileName + "' where [MatID]=" + this.MatID;
  557.                     if (SqlServer.RunSql(sql))
  558.                     {
  559.                         XML xml = new XML();
  560.                         if (xml.CreateXMLDocument(path + "\DocTemplateMat\" + xmlFileName))
  561.                             WorkFlowOperation(this.MatID,false);
  562.                         else
  563.                             Common.RunScript(this.Page, "XML文档创建失败，请检查相关设置");
  564.                     }
  565.                 }
  566.                 break;
  567.             /*==============================================================================================
  568.              * 
  569.              *                                基层单位上报废旧物资
  570.              * 
  571.              *=============================================================================================*/
  572.             case 70:
  573.                 //string jcTransactor = cui.EmpName + "   " + DateTime.Now.ToShortDateString() + " " + DateTime.Now.Hour + ":" + DateTime.Now.Minute;
  574.                 string jcTransactor = DateTime.Now.ToShortDateString() + " " + DateTime.Now.Hour + ":" + DateTime.Now.Minute;
  575.                 sql = "update [tb_PrjOldMat] set [JcTransactor]='" + jcTransactor + "' where [MatID]=" + this.MatID;
  577.                 if (SqlServer.RunSql(sql))
  578.                 {
  579.                     string xmlFileName = GetPrjOldMatInfo(this.MatID)[0]["DocumentXML"].ToString();
  581.                     string filename = this.txt_MaterialRemove.Value;
  582.                     string checker = cui.EmpName;
  583.                     string time = DateTime.Now.ToString();
  584.                     string type = ProjectImplment.GetEmpType(cui.EmpID);
  586.                     XML xml1 = new XML(path + "\DocTemplateMat\" + xmlFileName);
  587.                     xml1.AddXmlNode(new DocumentNode(filename, checker, time, type));//将基层上报的文档信息写入XML文档
  589.                     string xmlMasterFileName = GetPrjOldMatInfo(this.MatID)[0]["ZgHZFName"].ToString();
  590.                     if (xmlMasterFileName == "")//如果XML文档不存在，则创建，否则不创建
  591.                     {
  592.                         xmlMasterFileName = "MasterDepartDocument" + DateTime.Now.Year + DateTime.Now.Month + DateTime.Now.Day + DateTime.Now.Hour + DateTime.Now.Minute + DateTime.Now.Second + ".xml";
  593.                         sql = "update [tb_PrjOldMat] set [ZgHZFName]='" + xmlMasterFileName + "' where [MatID]=" + this.MatID;
  594.                         if (SqlServer.RunSql(sql))
  595.                         {
  596.                             if (xml1.CreateXMLDocument(path + "\DocTemplateMat\" + xmlMasterFileName) == false)
  597.                             {
  598.                                 Common.RunScript(this.Page, "XML文档创建失败，请检查相关设置");
  599.                             }
  600.                         }
  601.                     }
  603.                     if (CheckEmpTypeIsEqualBlockReason() == false)
  604.                     {
  605.                         WFInstADD("您已审核通过！",true);
  606.                     }
  607.                     else
  608.                     {
  609.                         WorkFolw workflow = new WorkFolw();
  610.                         if (workflow.WFActInsUpdata(actinstanceid, 1, userid))
  611.                         {
  612.                             EtongZwf etongzwf = new EtongZwf();
  613.                             DataView dv = etongzwf.ColonyUserGetByActId(ActivityID);
  614.                             int ParentRoleID = -1;
  615.                             if (dv.Count > 0)
  616.                             {
  617.                                 ParentRoleID = Convert.ToInt32(dv[0]["ParentRoleID"].ToString().Trim());
  618.                                 ProjectImplment pi = new ProjectImplment();
  619.                                 DataTable dt = pi.GetNextOperatorRole(ParentRoleID);
  620.                                 string nextCheckDepartment = dt.Rows[0]["OpName"].ToString();
  621.                                 ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('系统提示：您已经审核通过,转到『" + nextCheckDepartment + "』申核处理！');top.location.href='../Main.aspx';</script>");
  622.                             }
  623.                         }
  624.                     }
  625.                 }
  626.                 else
  627.                 {
  628.                     Common.RunScript(this.Page, "操作失败，请检查数据!");
  629.                 }
  630.                 break;
  631.             /*==============================================================================================
  632.              * 
  633.              *                                主管部门废旧物资汇总
  634.              * 
  635.              *=============================================================================================*/
  636.             case 77:
  637.                 //if (this.IsCollect == false)
  638.                 if ((this.TB_OpenDocument_ZGdFName.Enabled == false) && (this.TB_OpenDocument_ZgHZFName.Enabled == false) && (this.TB_OpenDocument_ZGxFName.Enabled == false))
  639.                 {
  640.                     Common.RunScript(this.Page, "您尚未汇总废旧物资，不能审核通过！");
  641.                 }
  642.                 else
  643.                 {
  644.                     string zgTransactor = cui.EmpName + "   " + DateTime.Now.ToShortDateString() + " " + DateTime.Now.Hour + ":" + DateTime.Now.Minute;
  645.                     //sql = "update [tb_PrjOldMat] set [ZgTransactor]='" + zgTransactor + "',[ZgHZFName]='" + this.txt_ZgHZFName.Value + "',[ZGxFName]='" + this.txt_ZGxFName.Value + "',[ZGdFName]='" + this.txt_ZGdFName.Value + "' where [MatID]=" + this.MatID;
  646.                     sql = "update [tb_PrjOldMat] set [ZgTransactor]='" + zgTransactor + "',[ZGxFName]='" + this.txt_ZGxFName.Value + "',[ZGdFName]='" + this.txt_ZGdFName.Value + "' where [MatID]=" + this.MatID;
  647.                     if (SqlServer.RunSql(sql))
  648.                     {
  649.                         WorkFlowOperation(this.MatID,true);
  650.                     }
  651.                 }
  652.                 break;
  653.             /*==============================================================================================
  654.              * 
  655.              *                                废旧物资大件
  656.              * 
  657.              *=============================================================================================*/
  658.             case 71:
  659.                 WFInstADD("您已审核通过！",true);
  660.                 break;
  661.             /*==============================================================================================
  662.              * 
  663.              *                                废旧物资小件
  664.              * 
  665.              *=============================================================================================*/
  666.             case 72:
  667.                 WFInstADD("您已审核通过！",true);
  668.                 break;
  669.             /*==============================================================================================
  670.              * 
  671.              *                                物资公司收集汇总材料
  672.              * 
  673.              *=============================================================================================*/
  674.             case 73:
  675.                 string WZjIdea = this.TB_WZjIdea.Text.Trim();
  676.                 string WZjTransactor = cui.EmpName + "   " + DateTime.Now.ToShortDateString() + " " + DateTime.Now.Hour + ":" + DateTime.Now.Minute;
  677.                 sql = "update [tb_PrjOldMat] set [WZjIdea]='" + WZjIdea + "',[WZjTransactor]='" + WZjTransactor + "' where [MatID]=" + this.MatID;
  678.                 if (SqlServer.RunSql(sql))
  679.                 {
  680.                     WorkFlowOperation(this.MatID,false);
  681.                 }
  682.                 else
  683.                 {
  684.                     Common.RunScript(this.Page, "操作失败，请检查数据!");
  685.                 }
  686.                 break;
  687.             /*==============================================================================================
  688.              * 
  689.              *                                物资公司汇总
  690.              * 
  691.              *=============================================================================================*/
  692.             case 78:
  693.                 /*com.etong.DAL.FC.EtongFlyChouWFPrj etongFlyChouWFPrj = new com.etong.DAL.FC.EtongFlyChouWFPrj();
  694.                 etongFlyChouWFPrj.sID = this.actinstanceid;
  695.                 etongFlyChouWFPrj.PrjID = this.MatID;
  696.                 etongFlyChouWFPrj.wID = this.wfid;
  697.                 etongFlyChouWFPrj.iStatus = 5;
  698.                 //etongFlyChouWFPrj.sBlockReason = WorkFolw.GetBlockReason(this.actinstanceid);
  700.                 if (etongFlyChouWFPrj.CheckUpActComplete() == false)
  701.                 {
  702.                     Common.RunScript(this.Page, "工作流上级所属活动未完成，不能审核通过！");
  703.                 }
  704.                 else
  705.                 {*/
  706.                     //string path = Server.MapPath("doc").Replace("\", "\\");      //获取项目所在路径
  707.                 string xmlDoc = path + "\DocTemplateMat\" + GetPrjOldMatInfo(this.MatID)[0]["ZgHZFName"].ToString();
  709.                     XML xmlxml = new XML(xmlDoc);
  710.                     ArrayList list = xmlxml.ReadNode("Documents", "",false);
  712.                     string[] filename1 = new string[list.Count];
  713.                     for (int i = 0; i < filename1.Length; i++)
  714.                     {
  715.                         DocumentNode node = (DocumentNode)list[i];
  716.                         filename1[i] = path + "\DocTemplateMat\" + node.FileName;
  717.                     }
  719.                     MyDocMerger myDocMeger = new MyDocMerger();
  721.                     string orgDocName = path + "\DocTemplateMat\" + this.txt_MaterialCollect.Value;
  722.                     myDocMeger.MergeDocArray(orgDocName, filename1, orgDocName);
  724.                     string WZhFName = this.txt_MaterialCollect.Value;
  725.                     string WZhTransactor = cui.EmpName + "   " + DateTime.Now.ToShortDateString() + " " + DateTime.Now.Hour + ":" + DateTime.Now.Minute;
  726.                     sql = "update [tb_PrjOldMat] set [WZhFName]='" + WZhFName + "',[WZhTransactor]='" + WZhTransactor + "',[hz]='2' where [MatID]=" + this.MatID;
  727.                     if (SqlServer.RunSql(sql))
  728.                     {
  729.                         WFInstADD("您已审核通过！",false);
  730.                     }
  731.                     else
  732.                     {
  733.                         Common.RunScript(this.Page, "操作失败，请检查数据!");
  734.                     }
  735.                // }
  736.                 break;
  737.             /*==============================================================================================
  738.              * 
  739.              *                                编写废旧物资
  740.              * 
  741.              *=============================================================================================*/
  742.             case 79:
  743.                 string WZqFName = this.txt_WZqFName.Value;
  744.                 string WZqTransactor = cui.EmpName + "   " + DateTime.Now.ToShortDateString() + " " + DateTime.Now.Hour + ":" + DateTime.Now.Minute;
  745.                 sql = "update [tb_PrjOldMat] set [WZqFName]='" + WZqFName + "',[WZqTransactor]='" + WZqTransactor + "' where [MatID]=" + this.MatID;
  746.                 if (SqlServer.RunSql(sql))
  747.                 {
  748.                     WFInstADD("您已审核通过！",false);
  749.                 }
  750.                 else
  751.                 {
  752.                     Common.RunScript(this.Page, "操作失败，请检查数据!");
  753.                 }
  754.                 break;
  755.             /*==============================================================================================
  756.              * 
  757.              *                                工程管理办公室审核
  758.              * 
  759.              *=============================================================================================*/
  760.             case 75:
  761.                 string GcglIdea = this.TB_GcglIdea.Text;
  762.                 string GcglTransactor = cui.EmpName + "   " + DateTime.Now.ToShortDateString() + " " + DateTime.Now.Hour + ":" + DateTime.Now.Minute;
  763.                 sql = "update [tb_PrjOldMat] set [GcglIdea]='" + GcglIdea + "',[GcglTransactor]='" + GcglTransactor + "' where [MatID]=" + this.MatID;
  764.                 if (SqlServer.RunSql(sql))
  765.                 {
  766.                     WFInstADD("您已审核通过！",false);
  767.                 }
  768.                 else
  769.                 {
  770.                     Common.RunScript(this.Page, "操作失败，请检查数据!");
  771.                 }
  772.                 break;
  773.             /*==============================================================================================
  774.              * 
  775.              *                                  公司领导审核
  776.              * 
  777.              *=============================================================================================*/
  778.             case 74:
  779.                 string GSldIdea = this.TB_GSldIdea.Text;
  780.                 string GSldTansactor = cui.EmpName + "   " + DateTime.Now.ToShortDateString() + " " + DateTime.Now.Hour + ":" + DateTime.Now.Minute;
  781.                 sql = "update [tb_PrjOldMat] set [GSldIdea]='" + GSldIdea + "',[GSldTansactor]='" + GSldTansactor + "' where [MatID]=" + this.MatID;
  782.                 if (SqlServer.RunSql(sql))
  783.                 {
  784.                     WFInstADD("您已审核通过！",false);
  785.                 }
  786.                 else
  787.                 {
  788.                     Common.RunScript(this.Page, "操作失败，请检查数据!");
  789.                 }
  790.                 break;
  792.             /*==============================================================================================
  793.              * 
  794.              *                                  物资公司审核
  795.              * 
  796.              *=============================================================================================*/
  797.             case 76:
  798.                 string WZfIdea = this.TB_WZfIdea.Text;
  799.                 string WZfTransactor = cui.EmpName + "   " + DateTime.Now.ToShortDateString() + " " + DateTime.Now.Hour + ":" + DateTime.Now.Minute;
  800.                 sql = "update [tb_PrjOldMat] set [WZfIdea]='" + WZfIdea + "',[WZfTransactor]='" + WZfTransactor + "' where [MatID]=" + this.MatID;
  801.                 if (SqlServer.RunSql(sql))
  802.                 {
  803.                    // WFInstADD("您已审核通过！",false);
  804.                     WorkFlowOperation(this.MatID, false);
  805.                 }
  806.                 else
  807.                 {
  808.                     Common.RunScript(this.Page, "操作失败，请检查数据!");
  809.                 }
  810.                 break;
  812.             /*==============================================================================================
  813.         　　 * 
  814.          　　*                                  竣工材料存档
  815.              * 
  816.              *=============================================================================================*/
  817.             case 100:
  818.                 string ZGgIdea = this.TB_ZGgIdea.Text;
  819.                 string ZGgTransactor = cui.EmpName + "   " + DateTime.Now.ToShortDateString() + " " + DateTime.Now.Hour + ":" + DateTime.Now.Minute;
  820.                 sql = "update [tb_PrjOldMat] set [ZGgIdea]='" + ZGgIdea + "',[ZGgTransactor]='" + ZGgTransactor + "',[status]=2 where [MatID]=" + this.MatID;
  821.                 if (SqlServer.RunSql(sql))
  822.                 {
  823.                     WFInstADD("您已审核通过！",false);
  824.                 }
  825.                 else
  826.                 {
  827.                     Common.RunScript(this.Page, "操作失败，请检查数据!");
  828.                 }
  829.                 break;
  830.         }
  831.     }
  834.     /*============================================================对并发活动的特殊处理======================================================
  835.      * 
  836.      *                                                 工作流操作,分3步
  837.      * 1.产生工作流实例纪录,注意matid必须真实存在 
  838.      * 2.更新当前活动实例状态 由WFInstADD中的WFActInsUpdata执行
  839.      * 3.产生新的工作流实例纪录,即产生下一个活动实例并提交到下一个部门的用户申核,由NextColonyRole操作完成                                
  840.      * 
  841.      *=====================================================================================================================================*/
  842.     protected void WorkFlowOperation(int matid,bool isMaster)
  843.     {
  844.         EtongZwf etongzwf = new EtongZwf();
  845.         ProjectImplment projectImplment = new ProjectImplment();
  847.         string sql = " select * from [tb_WF_Instance] where [Status]=5 and [PrjID]=" + this.MatID;
  848.         DataView dv = SqlServer.GetDataView(sql);
  849.         if (dv.Count == 0)//如果实例存在则不添加
  850.         {
  851.             DateTime SuccessDate = Convert.ToDateTime(DateTime.Now.ToShortDateString().Trim());
  852.             //添加工作流实例 (将添加成功的constructid添加到工作流实例表里,注意是加到该表的PrjID字段中)
  853.             WFInstanceInfo wfinstanceinfo = new WFInstanceInfo(-1, Convert.ToDateTime(DateTime.Now.ToShortDateString()),
  854.                     userid, -1, -1, DateTime.Now, 5, SuccessDate, wfid,matid);
  856.             int ReInstanceValue = etongzwf.WFInstanceADD(wfinstanceinfo);
  858.             //产生当前工作流实例ID
  859.             WFInstanceID = ReInstanceValue;
  860.         }
  862.         dv = etongzwf.ColonyUserGetByActId(ActivityID);
  864.         if (dv.Count > 0)
  865.         {
  866.             /*int ParentOrgID = Convert.ToInt32(dv[0]["ParentRoleID"].ToString().Trim());
  867.             //DataView dvRoleName = etongzwf.RoleGetName(ParentRoleID);
  868.             DataTable dataTable = projectImplment.GetDepartmentByID(ParentOrgID);
  869.             if (dataTable.Rows.Count == 0)
  870.             {
  871.                 ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('系统提示：项目施工停滞，没有上级申核人！(请联系相关部门或系统管理员)');</script>");
  872.                 return;
  873.             }*/
  875.             /*DateTime SuccessDate = Convert.ToDateTime(DateTime.Now.ToShortDateString().Trim());
  876.             //添加工作流实例 (将添加成功的constructid添加到工作流实例表里,注意是加到该表的PrjID字段中)
  877.             WFInstanceInfo wfinstanceinfo = new WFInstanceInfo(-1, Convert.ToDateTime(DateTime.Now.ToShortDateString()),
  878.                     userid, -1, -1, DateTime.Now, 5, SuccessDate, wfid, matid);
  880.             int ReInstanceValue = etongzwf.WFInstanceADD(wfinstanceinfo);
  882.             //产生当前工作流实例ID
  883.             WFInstanceID = ReInstanceValue;*/
  884.             string nextCheckDepartment = "";
  886.             for (int i = 0; i < dv.Count; i++)//找到所有部门
  887.             {
  888.                 int ParentRoleID = Convert.ToInt32(dv[i]["ParentRoleID"].ToString().Trim());
  889.                 ProjectImplment pi = new ProjectImplment();
  890.                 //DataTable dt = pi.GetDepartmentByID(ParentRoleID);
  891.                 DataTable dt = pi.GetNextOperatorRole(ParentRoleID);
  892.                 nextCheckDepartment += dt.Rows[0]["OpName"].ToString()+"、";
  893.             }
  895.             for (int i = 0; i < dv.Count; i++)
  896.             {
  897.                 int CurrentRoleID = Convert.ToInt32(dv[i]["CurrentRoleID"].ToString().Trim());
  898.                 int ParentActID = Convert.ToInt32(dv[i]["ParentActID"].ToString().Trim());
  899.                 int ParentRoleID = Convert.ToInt32(dv[i]["ParentRoleID"].ToString().Trim());
  900.               
  901.                 if (WFInstanceID > 0)
  902.                 {
  903.                     WorkFolw workflow = new WorkFolw();
  904.                     string ActIDtxt = Request.QueryString["ActID"].ToString().Trim();
  905.                     ActID = Convert.ToInt32(ActIDtxt);
  906.                     bool returnvalue = false;
  907.                     //产生当前活动实例  如果是不是第一个活动,只需 修改 UserID 和 Status
  908.                     int ReActInsValue = 0;
  909.                     
  910.                     //returnvalue = etongzwf.WFActInsUpdata(ActID, userid, 1);
  911.                     returnvalue = workflow.WFActInsUpdata(ActID, 1, userid);
  912.                     if (returnvalue == true)
  913.                         ReActInsValue = ActID;
  915.                     if (ReActInsValue > 0)
  916.                     {
  917.                         if (ParentActID != -1)
  918.                         {
  919.                             NextColonyRole(ParentActID, ParentRoleID, "您已审核通过", nextCheckDepartment,isMaster);  //(ReActInsValue);     //产生下一个活动实例并提交到下一个角色的用户申核
  920.                         }
  921.                         else   // 不存在上级活动，将 活动状态(Status) 改为 "完成"   注:Status状态(0、正常；1、完成；2、回退；3、回退并完成；4、作废)
  922.                         {
  923.                             bool ReValueAIUpdata = false;
  924.                             //ReValueAIUpdata = etongzwf.WFActInsUpdata(ReActInsValue, userid, 1);
  925.                             ReValueAIUpdata = workflow.WFActInsUpdata(ReActInsValue, 1, userid);
  927.                             if (ReValueAIUpdata == true)
  928.                             {
  929.                                 ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('系统提示：项目施工完成！');top.location.href='../Main.aspx';</script>");
  930.                             }
  931.                             else
  932.                             {
  933.                                 ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('系统提示：操作失败！');top.location.href='../Main.aspx';</script>");
  934.                             }
  935.                         }
  936.                     }
  937.                 }
  938.             }
  939.         }
  940.     }
  944.     /*===========================================================================================================================
  945.      * 
  946.      *                                    工作流操作,分3步 
  947.      * 1.产生工作流实例纪录,注意constructid必须真实存在 
  948.      * 2.更新当前活动实例状态 由WFInstADD中的WFActInsUpdata执行
  949.      * 3.产生新的工作流实例纪录,即产生下一个活动实例并提交到下一个部门的用户申核,由NextColonyRole操作完成                                
  950.      * 
  951.      *==========================================================================================================================*/
  952.     protected void WorkFlowOperation(int matid, string showmessage,bool isMaster)
  953.     {
  954.         EtongZwf etongzwf = new EtongZwf();
  955.         ProjectImplment projectImplment = new ProjectImplment();
  957.         string sql = " select * from [tb_WF_Instance] where [Status]=2 and [PrjID]=" + this.MatID;
  958.         DataView dv = SqlServer.GetDataView(sql);
  959.         if (dv.Count == 0)//如果实例存在则不添加
  960.         {
  961.             DateTime SuccessDate = Convert.ToDateTime(DateTime.Now.ToShortDateString().Trim());
  962.             //添加工作流实例 (将添加成功的constructid添加到工作流实例表里,注意是加到该表的PrjID字段中)
  963.             WFInstanceInfo wfinstanceinfo = new WFInstanceInfo(-1, Convert.ToDateTime(DateTime.Now.ToShortDateString()),
  964.                     userid, -1, -1, DateTime.Now, 5, SuccessDate, wfid,matid);
  966.             int ReInstanceValue = etongzwf.WFInstanceADD(wfinstanceinfo);
  968.             //产生当前工作流实例ID
  969.             WFInstanceID = ReInstanceValue;
  970.         }
  972.         dv = etongzwf.ColonyUserGetByActId(ActivityID);
  974.         if (dv.Count > 0)
  975.         {
  976.             //int ParentRoleID = Convert.ToInt32(dv[0]["ParentRoleID"].ToString().Trim());
  977.             ////DataView dvRoleName = etongzwf.RoleGetName(ParentRoleID);
  978.             //DataTable dt = projectImplment.GetDepartmentByID(ParentRoleID);
  979.             //if (dt.Rows.Count == 0)
  980.             //{
  981.             //    ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('系统提示：项目施工停滞，没有上级申核人！(请联系相关部门或系统管理员)');</script>");
  982.             //    return;
  983.             //}
  985.             //获取当前工作流启始活动    为什么要获取当前工作流启始活动?            
  986.             //DataView dvActID = etongzwf.GetActivityByWFID(wfid);
  988.             //ActivityID = Convert.ToInt32(dvActID[0][0].ToString().Trim());
  990.             if (WFInstanceID > 0)
  991.             {
  992.                 WFInstADD(showmessage,isMaster);
  993.             }
  994.         }
  995.     }
  997.     /// <summary>
  998.     /// 改变工作流活动实例状态   
  999.     /// </summary>
  1000.     /// 
  1001.     protected void WFInstADD(string showMessage,bool isMaster)
  1002.     {
  1003.         if (WFInstanceID > 0)
  1004.         {
  1005.             com.etong.DAL.WorkFolw workflow = new com.etong.DAL.WorkFolw();
  1006.             DateTime SuccessDate = Convert.ToDateTime(DateTime.Now.ToShortDateString().Trim());
  1007.             EtongZwf etongzwf = new EtongZwf();
  1008.             DataView dv = etongzwf.ColonyUserGetByActId(ActivityID);
  1009.             // int CurrentActID = -1;
  1010.             int CurrentRoleID = -1;
  1011.             int ParentActID = -1;
  1012.             int ParentRoleID = -1;
  1013.             string nextCheckDepartment = null;
  1015.             if (dv.Count > 0)
  1016.             {
  1017.                 if (dv.Count ==1)//不分流
  1018.                 {
  1019.                     CurrentRoleID = Convert.ToInt32(dv[0]["CurrentRoleID"].ToString().Trim());
  1020.                     ParentActID = Convert.ToInt32(dv[0]["ParentActID"].ToString().Trim());
  1021.                     ParentRoleID = Convert.ToInt32(dv[0]["ParentRoleID"].ToString().Trim());
  1022.                 }
  1023.                 else//分流
  1024.                 {
  1025.                     for (int i = 0; i < dv.Count; i++)
  1026.                     {
  1027.                         if (Convert.ToInt32(dv[i]["shuntflag"]) == shuntFlag)
  1028.                         {
  1029.                             CurrentRoleID = Convert.ToInt32(dv[i]["CurrentRoleID"].ToString().Trim());
  1030.                             ParentActID = Convert.ToInt32(dv[i]["ParentActID"].ToString().Trim());
  1031.                             ParentRoleID = Convert.ToInt32(dv[i]["ParentRoleID"].ToString().Trim());
  1032.                         }
  1033.                     }
  1034.                 }
  1035.             }
  1037.             //产生当前活动实例  如果是不是第一个活动,只需 修改 UserID 和 Status
  1038.             int ReActInsValue = 0;
  1039.             int tempStatus = WorkFolw.GetCurrentActivityInstanceStatus(this.actinstanceid);//当前活动实例状态
  1041.             if (MustChooseItem == 69)//对起始活动的操作
  1042.             {
  1043.                 if (tempStatus == 2)//回退活动
  1044.                 {
  1045.                     string ActIDtxt = Request.QueryString["ActID"].ToString().Trim();
  1046.                     ActID = Convert.ToInt32(ActIDtxt);
  1047.                     bool returnvalue = false;
  1048.                     //returnvalue = etongzwf.WFActInsUpdata(ActID, userid, 1);
  1049.                     returnvalue = workflow.WFActInsUpdata(ActID, 1, userid);
  1050.                     if (returnvalue == true)
  1051.                         ReActInsValue = ActID;
  1052.                     if (ReActInsValue > 0)
  1053.                     {
  1054.                         if (ParentActID != -1)
  1055.                         {
  1056.                             ProjectImplment pi = new ProjectImplment();
  1057.                             //DataTable dt = pi.GetDepartmentByID(ParentRoleID);
  1058.                             DataTable dt = pi.GetNextOperatorRole(ParentRoleID);
  1059.                             nextCheckDepartment = dt.Rows[0]["OpName"].ToString();
  1060.                             NextColonyRole(ParentActID, ParentRoleID, showMessage, nextCheckDepartment,isMaster);  //(ReActInsValue);     //产生下一个活动实例并提交到下一个角色的用户申核
  1061.                         }
  1062.                         else//不存在上级活动，将 活动状态(Status) 改为 "完成"   注:Status状态(0、正常；1、完成；2、回退；3、回退并完成；4、作废)
  1063.                         {
  1064.                             bool ReValueAIUpdata = false;
  1065.                             //ReValueAIUpdata = etongzwf.WFActInsUpdata(ReActInsValue, userid, 1);
  1066.                             ReValueAIUpdata = workflow.WFActInsUpdata(ReActInsValue, 1, userid);
  1068.                             if (ReValueAIUpdata == true)
  1069.                             {
  1070.                                 ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('系统提示：项目施工完成！');top.location.href='../Main.aspx';</script>");
  1071.                             }
  1072.                             else
  1073.                             {
  1074.                                 ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('系统提示：操作失败！');top.location.href='../Main.aspx';</script>");
  1075.                             }
  1076.                         }
  1077.                     }
  1078.                 }
  1079.                 else
  1080.                 {
  1081.                     WFActInsInfo wfactinsinfo = new WFActInsInfo(-1, ActivityID, Convert.ToDateTime(DateTime.Now.ToShortDateString()), Convert.ToDateTime(DateTime.Now.ToShortDateString()),
  1082.                                                                      1, SuccessDate, WFInstanceID, "", userid, CurrentRoleID);
  1084.                     ReActInsValue = etongzwf.WFActInsADD(wfactinsinfo);
  1085.                     ProjectImplment pi = new ProjectImplment();
  1086.                     //DataTable dt = pi.GetDepartmentByID(ParentRoleID);
  1087.                     DataTable dt = pi.GetNextOperatorRole(ParentRoleID);
  1088.                     if (dt.Rows.Count > 0)
  1089.                     {
  1090.                         nextCheckDepartment = dt.Rows[0]["OpName"].ToString();
  1091.                         //ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('系统提示：计划下达成功,转到『" + nextCheckDepartment + "』申核处理！');top.location.href='../Main.aspx';</script>");
  1092.                     }
  1093.                     NextColonyRole(ParentActID, ParentRoleID, showMessage, nextCheckDepartment,isMaster);//提交给下一部门用户审核
  1094.                 }
  1095.             }
  1096.             else//对不是起始活动的操作
  1097.             {
  1098.                 string ActIDtxt = Request.QueryString["ActID"].ToString().Trim();
  1099.                 ActID = Convert.ToInt32(ActIDtxt);
  1100.                 bool returnvalue = false;
  1101.                 //returnvalue = etongzwf.WFActInsUpdata(ActID, userid, 1);
  1102.                 returnvalue = workflow.WFActInsUpdata(ActID, 1, userid);
  1103.                 if (returnvalue == true)
  1104.                     ReActInsValue = ActID;
  1106.                 if (ReActInsValue > 0)
  1107.                 {
  1108.                     if (ParentActID != -1)
  1109.                     {
  1110.                         ProjectImplment pi = new ProjectImplment();
  1111.                         //DataTable dt = pi.GetDepartmentByID(ParentRoleID);
  1112.                         DataTable dt = pi.GetNextOperatorRole(ParentRoleID);
  1113.                         nextCheckDepartment = dt.Rows[0]["OpName"].ToString();
  1114.                         NextColonyRole(ParentActID, ParentRoleID, showMessage, nextCheckDepartment,isMaster);  //(ReActInsValue);     //产生下一个活动实例并提交到下一个角色的用户申核
  1115.                     }
  1116.                     else   // 不存在上级活动，将 活动状态(Status) 改为 "完成"   注:Status状态(0、正常；1、完成；2、回退；3、回退并完成；4、作废)
  1117.                     {
  1118.                         bool ReValueAIUpdata = false;
  1119.                         //ReValueAIUpdata = etongzwf.WFActInsUpdata(ReActInsValue, userid, 1);
  1120.                         ReValueAIUpdata = workflow.WFActInsUpdata(ReActInsValue, 1, userid);
  1122.                         if (ReValueAIUpdata == true)
  1123.                         {
  1124.                             ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('系统提示：废旧物资工作流活动完成！');top.location.href='../Main.aspx';</script>");
  1125.                         }
  1126.                         else
  1127.                         {
  1128.                             ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('系统提示：操作失败！');top.location.href='../Main.aspx';</script>");
  1129.                         }
  1130.                     }
  1131.                 }
  1132.             }
  1133.         }
  1134.     }
  1136.     /// <summary>
  1137.     /// 起始活动.
  1138.     /// </summary>
  1139.     protected int ActivityIDGetByWFID(int WfId)
  1140.     {
  1141.         EtongZwf etongzwf = new EtongZwf();
  1142.         DataView dvActivity = etongzwf.GetActivityByWFID(WfId);
  1143.         if (dvActivity.Count != 0)
  1144.         {
  1145.             int activity = Convert.ToInt32(dvActivity[0][0].ToString().Trim());
  1146.             return activity;
  1147.         }
  1148.         else
  1149.             return 0;
  1150.     }
  1152.     /// <summary>
  1153.     /// 提交到上级部门用户申核
  1154.     /// </summary>
  1155.     protected void NextColonyRole(int ParentActID, int ParentRoleID, string showMessage, string nextCheckDepartment,bool isMaster)
  1156.     {
  1157.         EtongZwf etongzwf = new EtongZwf();
  1158.         WFActInsInfo wfactinsinfo = null;
  1159.         if (isMaster == false)
  1160.         {
  1161.             wfactinsinfo = new WFActInsInfo(-1, ParentActID, Convert.ToDateTime(DateTime.Now.ToShortDateString()), Convert.ToDateTime(DateTime.Now.ToShortDateString()),
  1163.                                                                      0, Convert.ToDateTime(DateTime.Now.ToShortDateString()), WFInstanceID, WorkFolw.GetOrgOpRoleType(ParentRoleID), -1, ParentRoleID);
  1164.         }
  1165.         else
  1166.         {
  1167.             CheckUserInfo cui = null;
  1168.             if (Session["checkuserinfo"] != null)
  1169.             {
  1170.                 cui = (CheckUserInfo)Session["checkuserinfo"];
  1171.             }
  1172.             string type = ProjectImplment.GetEmpType(cui.EmpID);
  1174.             wfactinsinfo = new WFActInsInfo(-1, ParentActID, Convert.ToDateTime(DateTime.Now.ToShortDateString()), Convert.ToDateTime(DateTime.Now.ToShortDateString()),
  1175.                                                                 0, Convert.ToDateTime(DateTime.Now.ToShortDateString()), WFInstanceID, type, -1, ParentRoleID);
  1176.         }
  1178.         int ReActInsValue = etongzwf.WFActInsADD(wfactinsinfo);
  1179.         if (ReActInsValue > 0)
  1180.         {
  1181.             //DataView dvRoleName = etongzwf.RoleGetName(ParentRoleID);
  1182.             //if (dvRoleName.Count != 0)
  1183.             //{
  1184.             //InitializePage();        //初始化当前页面
  1185.             ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('系统提示：" + showMessage + ",转到『" + nextCheckDepartment + "』申核处理！');top.location.href='../Main.aspx';</script>");
  1186.             //}
  1187.             //else
  1188.             //ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('系统提示：项目施工停滞，没有上级申核人！');</script>");
  1189.         }
  1190.         else
  1191.         {
  1192.             ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('系统提示：操作失败！');top.location.href='../Main.aspx';</script>");
  1193.         }
  1194.     }
  1195.     protected void BT_Untread_Click(object sender, ImageClickEventArgs e)
  1196.     {
  1197.         if (IsUntread == false)
  1198.         {
  1199.             Common.RunScript(this.Page, "起始活动不可回退!");
  1200.             return;
  1201.         }
  1202.         else
  1203.         {
  1204.             EtongZwf etongzwf = new EtongZwf();
  1206.             bool ReActInsValue = false;
  1207.             string ActIDtxt = Request.QueryString["ActID"].ToString().Trim();
  1208.             ActID = Convert.ToInt32(ActIDtxt);
  1209.             //ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + ActID.ToString() + "');</script>");
  1210.             //return;
  1211.             ReActInsValue = etongzwf.WFActInsUpdata(ActID, userid, 3);
  1212.             if (ReActInsValue == true)
  1213.             {
  1214.                 //产生回退活动事例
  1215.                 // 注:Status状态(0、正常；1、完成；2、回退；3、回退并完成；4、作废)
  1216.                 int ReActInsValue2 = 0;
  1217.                 DataView dvAct = etongzwf.ActivityGetByActInsId(ActID);
  1218.                 // DataView dvAct = etongzwf.ColonyUserGetByAct(ActivityID);    
  1219.                 int PreviousActID = -1;
  1220.                 int PreviousUserID = -1;
  1221.                 int PreviousRoleID = -1;
  1222.                 if (dvAct != null)
  1223.                 {
  1224.                     PreviousActID = Convert.ToInt16(dvAct[0]["PreviousActID"].ToString().Trim());
  1225.                     PreviousUserID = Convert.ToInt16(dvAct[0]["PreviousUserID"].ToString().Trim());
  1226.                     PreviousRoleID = Convert.ToInt16(dvAct[0]["PreviousRoleID"].ToString().Trim());
  1227.                 }
  1229.                 WFActInsInfo wfactinsinfo2 = new WFActInsInfo(-1, PreviousActID, Convert.ToDateTime(DateTime.Now.ToShortDateString()), Convert.ToDateTime(DateTime.Now.ToShortDateString()),
  1230.                                                                     2, Convert.ToDateTime(DateTime.Now.ToShortDateString()), WFInstanceID, "", PreviousUserID, PreviousRoleID);
  1231.                 ReActInsValue2 = etongzwf.WFActInsADD(wfactinsinfo2);
  1234.                 if (ReActInsValue2 != 0)
  1235.                     ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('系统提示：回退成功！');top.location.href='../Main.aspx';</script>");
  1236.                 else
  1237.                     ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('系统提示：回退失败！');top.location.href='../Main.aspx';</script>");
  1238.             }
  1239.         }
  1240.     }
  1241.     protected void BT_Revoke_Click(object sender, ImageClickEventArgs e)
  1242.     {
  1243.         string sql = "update tb_WF_ACtIns set Status=4  where [WfInstanceID]=" + WFInstanceID + " and [ActivityID]=" + ActivityID;
  1244.         string sql1 = "update [tb_PrjOldMat] set [Status]=3 where [MatID]=" + this.MatID;
  1246.         if (SqlServer.RunSql(sql) && SqlServer.RunSql(sql1))
  1247.         {
  1248.             ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('系统提示：作废操作成功！');top.location.href='../Main.aspx';</script>");
  1249.         }
  1250.         else
  1251.         {
  1252.             ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('系统提示：作废操作失败！');top.location.href='../Main.aspx';</script>");
  1253.         }
  1254.     }
  1257.     //******************************************************得到指定活动的文档名称*************************************************************
  1258.     protected string GetDocumentFileName(int activityid)
  1259.     {
  1260.         string sql = "select [FName] from [tb_Colony_FileName1] a,[tb_Sys_FileName] b where a.[FID]=b.[FID] and [ActivityID]=" + activityid;
  1261.         string filename = "";
  1262.         //string tempfilename = "";
  1263.         DataView dv = SqlServer.GetDataView(sql);
  1264.         if (dv != null && dv.Count > 0)
  1265.         {
  1266.             filename = dv[0]["FName"].ToString();
  1267.             //if (filename.Length >= 2)
  1268.                // tempfilename = filename.Substring(filename.LastIndexOf("\\") + 2);
  1269.         }
  1270.         return filename;
  1271.     }
  1273.     protected string GetDocumentFileName(int activityid, int index)
  1274.     {
  1275.         string sql = "select [FName] from [tb_Colony_FileName1] a,[tb_Sys_FileName] b where a.[FID]=b.[FID] and [ActivityID]=" + activityid;
  1276.         string filename = "";
  1277.       //  string tempfilename = "";
  1278.         DataView dv = SqlServer.GetDataView(sql);
  1279.         if (dv != null && dv.Count > 0)
  1280.         {
  1281.             filename = dv[index]["FName"].ToString();
  1282.             //if (filename.Length >= 2)
  1283.               //  tempfilename = filename.Substring(filename.LastIndexOf("\\") + 2);
  1284.         }
  1285.         return filename;
  1286.     }
  1288.     ////******************************************************用最新日期生成最新文档*************************************************************
  1289.     protected string MakeNewFileNameWithDate(string filename)
  1290.     {
  1291.         if (filename.Length > 0)
  1292.         {
  1293.             string[] a = filename.Split('.');
  1294.             return a[0] + DateTime.Now.Year + DateTime.Now.Month + DateTime.Now.Day + DateTime.Now.Hour + DateTime.Now.Minute + DateTime.Now.Second + "." + a[1];
  1295.         }
  1296.         else
  1297.             return "";
  1298.     }
  1299.     ////******************************************************找到员工类型的汇总文档*************************************************************
  1300.     protected string GetEmpTypeDocument()
  1301.     {
  1302.         string EmpTypeFileName = "";
  1303.         string path = Server.MapPath("doc").Replace("\", "\\");      //获取项目所在路径
  1304.         CheckUserInfo cui = null;
  1305.         if (Session["checkuserinfo"] != null)
  1306.         {
  1307.             cui = (CheckUserInfo)Session["checkuserinfo"];
  1308.         }
  1310.         string EmpType = ProjectImplment.GetEmpType(cui.EmpID);
  1311.         string filename = GetPrjOldMatInfo(this.MatID)[0]["ZgHZFName"].ToString();
  1313.         if (filename != "")
  1314.         {
  1315.             string xmlFileName = path + "\DocTemplateMat\" + filename;
  1317.             XML xml = new XML(xmlFileName);
  1318.             ArrayList list = xml.ReadNode("Documents", EmpType, true);
  1319.             if (list.Count > 0)
  1320.             {
  1321.                 DocumentNode node = (DocumentNode)list[0];
  1322.                 EmpTypeFileName = node.FileName;
  1323.             }
  1324.         }
  1325.         return EmpTypeFileName;
  1326.     }
  1328.     protected void IB_Collect_Click(object sender, ImageClickEventArgs e)
  1329.     {
  1330.         string path = Server.MapPath("doc").Replace("\", "\\");      //获取项目所在路径
  1332.         CheckUserInfo cui = null;
  1333.         if (Session["checkuserinfo"] != null)
  1334.         {
  1335.             cui = (CheckUserInfo)Session["checkuserinfo"];
  1336.         }
  1339.         com.etong.DAL.FC.EtongFlyChouWFPrj etongFlyChouWFPrj = new com.etong.DAL.FC.EtongFlyChouWFPrj();
  1340.         etongFlyChouWFPrj.sID = this.actinstanceid;
  1341.         etongFlyChouWFPrj.PrjID = this.MatID;
  1342.         etongFlyChouWFPrj.wID = this.wfid;
  1343.         etongFlyChouWFPrj.iStatus = 5;
  1344.         etongFlyChouWFPrj.sBlockReason = WorkFolw.GetBlockReason(this.actinstanceid);
  1346.         if (etongFlyChouWFPrj.CheckUpActCompleteSort() == false)
  1347.         {
  1348.             Common.RunScript(this.Page, "工作流上级所属(同类型的)活动未完成，不能汇总文档");
  1349.             return;
  1350.         }
  1351.         else
  1352.         {
  1353.             string EmpType = ProjectImplment.GetEmpType(cui.EmpID);
  1354.             string orgfilename = GetDocumentFileName(this.ActivityID);
  1355.             string filename = "型物资汇总表";
  1357.             /*switch (EmpType)
  1358.             {
  1359.                 case "1": filename = "科技" + filename + DateTime.Now.Year + DateTime.Now.Month + DateTime.Now.Day + DateTime.Now.Hour + DateTime.Now.Minute + DateTime.Now.Second + ".doc";
  1360.                     break;
  1361.                 case "2": filename = "生产" + filename + DateTime.Now.Year + DateTime.Now.Month + DateTime.Now.Day + DateTime.Now.Hour + DateTime.Now.Minute + DateTime.Now.Second + ".doc";
  1362.                     break;
  1363.                 case "3": filename = "营销" + filename + DateTime.Now.Year + DateTime.Now.Month + DateTime.Now.Day + DateTime.Now.Hour + DateTime.Now.Minute + DateTime.Now.Second + ".doc";
  1364.                     break;
  1365.             }*/
  1367.             filename = EmpType + "-" + filename + DateTime.Now.Year + DateTime.Now.Month + DateTime.Now.Day + DateTime.Now.Hour + DateTime.Now.Minute + DateTime.Now.Second;
  1369.             string checker = cui.EmpName;
  1370.             string time = DateTime.Now.ToString();
  1372.             string xmlFileName = path + "\DocTemplateMat\" + GetPrjOldMatInfo(this.MatID)[0]["ZgHZFName"].ToString();
  1373.             XML xml = new XML(xmlFileName);
  1375.             XML jcXml = new XML(path + "\DocTemplateMat\" + GetPrjOldMatInfo(this.MatID)[0]["DocumentXML"].ToString());
  1376.             ArrayList list = jcXml.ReadNode("Documents", EmpType, true);
  1377.             string[] filecopy = new string[list.Count];
  1379.             if (filecopy.Length > 0)
  1380.             {
  1381.                 for (int i = 0; i < filecopy.Length; i++)
  1382.                 {
  1383.                     DocumentNode documentNode = (DocumentNode)list[i];
  1384.                     filecopy[i] = path + "\DocTemplateMat\" + documentNode.FileName;
  1385.                 }
  1387.                 string[] houzhui = filecopy[0].Split('.');
  1389.                 MyDocMerger myDocMerger = new MyDocMerger();
  1390.                 string orgDocName = path + "\DocTemplateMat\" + filename + "." + houzhui[1];
  1391.                 this.txt_ZgHZFName.Value = filename + "." + houzhui[1];
  1393.                 if (xml.AddXmlNode(new DocumentNode(this.txt_ZgHZFName.Value, checker, time, EmpType)))
  1394.                 {
  1396.                     if (Util.Copyfile(path + "\" + orgfilename, orgDocName))
  1397.                     {
  1398.                         /*------------------------文档汇总----------------------*/
  1399.                         myDocMerger.MergeDocArray(orgDocName, filecopy, orgDocName);
  1401.                         /*---------------改变按钮组为可用状态-------------------*/
  1402.                         this.TB_OpenDocument_ZGdFName.Enabled = true;
  1403.                         this.TB_OpenDocument_ZgHZFName.Enabled = true;
  1404.                         this.TB_OpenDocument_ZGxFName.Enabled = true;
  1405.                         this.TB_OpenDocument_ZgHZFName.Text = "浏览电子文档";
  1406.                         this.TB_OpenDocument_ZgHZFName.Attributes.Add("onclick", "javascript:SetLinkUrl('DocTemplateMat/'+document.all('txt_ZgHZFName').value,'" + cui.EmpName + "');");
  1408.                         Common.RunScript(this.Page, "汇总成功！");
  1410.                         this.IsCollect = true;
  1411.                         this.IB_Collect.Enabled = false;
  1412.                     }
  1413.                     else
  1414.                     {
  1415.                         Common.RunScript(this.Page, "打开文档失败！");
  1416.                     }
  1417.                 }
  1418.                 else
  1419.                 {
  1420.                     Common.RunScript(this.Page, "汇总失败，请检查相关数据！");
  1421.                 }
  1422.             }
  1423.             else
  1424.             {
  1425.                 Common.RunScript(this.Page, "没有文档，不能汇总！");
  1426.             }
  1427.         }
  1428.     }
  1432.     //
  1433.     protected bool CheckEmpTypeIsEqualBlockReason()
  1434.     {
  1435.         bool flag = false;
  1436.         int wfid = -1;
  1437.         int actid = -1;
  1439.         CheckUserInfo cui = null;
  1440.         if (Session["checkuserinfo"] != null)
  1441.         {
  1442.             cui = (CheckUserInfo)Session["checkuserinfo"];
  1443.         }
  1444.         string type = ProjectImplment.GetEmpType(cui.EmpID);
  1446.         string sql = "select * from [tb_WF_Instance] where [Status]=5 and [PrjID]=" + this.MatID;
  1447.         DataView dv = SqlServer.GetDataView(sql);
  1448.         if (dv != null && dv.Count > 0)
  1449.         {
  1450.             wfid = Convert.ToInt32(dv[0]["WFInstanceID"].ToString());
  1451.             EtongZwf etongzwf = new EtongZwf();
  1452.             dv = etongzwf.ColonyUserGetByActId(ActivityID);
  1453.             if (dv.Count > 0)
  1454.             {
  1455.                 actid = Convert.ToInt32(dv[0]["ParentActID"].ToString().Trim());
  1456.                 sql = "select [BlockReason] from [tb_WF_ActIns] where [ActivityID]=" + actid + " and [WfInstanceID]=" + wfid;
  1457.                 dv = SqlServer.GetDataView(sql);
  1458.                 if (dv.Count > 0)
  1459.                 {
  1460.                     if (type == dv[0]["BlockReason"].ToString())
  1461.                         flag = true;
  1462.                 }
  1463.             }
  1464.         }
  1465.         return flag;
  1466.     }
  1467. }