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

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

.net编程

开发平台：

C#

EtongZwf.cs：源码内容
  1. using System;
  2. using System.Text;
  3. using System.Data.SqlClient;
  4. using com.etong.SqlDataConnect;
  5. using System.Data;
  6. using com.etong.DBUtility;
  7. using com.etong.Model;
  8. using System.Configuration;
  9. using System.Collections;
  10. using System.Xml;
  12. namespace com.etong.BusinessRule.Zwf
  13. {
  14.     public class EtongZwf
  15.     {
  16.         private MSSqlDataAccess MSDA = new MSSqlDataAccess(0);
  17.         public EtongZwf()
  18.         {
  19.             //
  20.             // TODO: 在此处添加构造函数逻辑
  21.             //
  22.         }
  23.         #region  用户管理
  24.         /*************************************************************************************************************  
  25.                                              * Module： 用户管理
  26.                                              * Desc： 添加、更新、删除、查询记录
  27.                                              * Author：朱皖峰
  28.                                              * Date： 2007-03
  29.         **************************************************************************************************************/
  30.         /// <summary>
  31.         /// 添加用户记录
  32.         /// </summary>
  33.         /// <returns>返回一bool类型值</returns>
  34.         public bool UserAdd(int empid, string useraccount, string usercode, string userdecs, int ordinal, string userpwd, int islock,
  35.                            string ipaddress,int isipbound,DateTime editdate,DateTime fromdate,DateTime todate)
  36.         {
  37.             QueryParameterCollection Params = new QueryParameterCollection();
  38.             Params.Clear();
  39.             Params.Add("@empid", empid);
  40.             Params.Add("@useraccount", useraccount);
  41.             Params.Add("@usercode", usercode);
  42.             Params.Add("@userdecs", userdecs);
  43.             Params.Add("@ordinal", ordinal);
  45.             Params.Add("@userpwd", userpwd);
  46.             Params.Add("@islock", islock);
  47.             Params.Add("@ipaddress", ipaddress);
  48.             Params.Add("@isipbound", isipbound);
  50.             Params.Add("@editdate", editdate);
  51.             Params.Add("@fromdate", fromdate);
  53.             Params.Add("@todate", todate);
  55.             string sSQL = "insert into Tb_Sys_User([EmpID],[UserAccount],[UserCode],[UserDecs],[OrdInal],[UserPwd],[IsLock],[IPAddress],[IsIPBound],[EditDate],[FromDate],[ToDate]) values(" +
  56.                            "@empid ,@useraccount,@usercode,@userdecs,@ordinal,@userpwd,@islock,@ipaddress,@isipbound,@editdate,@fromdate,@todate)";
  57.             MSDA.Open();
  58.      
  59.             NewObj newobject=new NewObj();
  60.             bool returnvalue =newobject.insert(sSQL, Params, CommandType.Text);
  62.             MSDA.Close();
  63.             return returnvalue;
  64.         }
  66.         /// <summary>
  67.         /// 更新用户记录
  68.         /// </summary>
  69.         /// <returns>返回bool类型参数</returns>
  70.         public bool UserUpdata(int @userid, int empid, string useraccount, string usercode, string userdecs, int ordinal, string userpwd, int islock,
  71.                            string ipaddress, int isipbound, DateTime editdate, DateTime fromdate, DateTime todate)
  72.         {
  73.             QueryParameterCollection Params = new QueryParameterCollection();
  74.             Params.Clear();
  75.             Params.Add("@userid", @userid);
  76.             Params.Add("@empid", empid);
  77.             Params.Add("@useraccount", useraccount);
  78.             Params.Add("@usercode", usercode);
  79.             Params.Add("@userdecs", userdecs);
  80.             Params.Add("@ordinal", ordinal);
  82.             Params.Add("@userpwd", userpwd);
  83.             Params.Add("@islock", islock);
  84.             Params.Add("@ipaddress", ipaddress);
  85.             Params.Add("@isipbound", isipbound);
  87.             Params.Add("@editdate", editdate);
  88.             Params.Add("@fromdate", fromdate);
  90.             Params.Add("@todate", todate);
  92.             string sSQL = "update  Tb_Sys_User Set EmpID =@empid,UserAccount=@useraccount,UserCode=@usercode,UserDecs=@userdecs,OrdInal=@ordinal,UserPwd=@userpwd,IsLock=@islock," +
  93.             "IPAddress=@ipaddress,IsIPBound=@isipbound,EditDate=@editdate,FromDate=@fromdate,ToDate=@todate  where UserID=@userid";
  94.             MSDA.Open();
  95.            NewObj newobject=new NewObj();
  96.            bool returnvalue = newobject.Update(sSQL, Params, CommandType.Text);
  97.             MSDA.Close();
  98.             return returnvalue;
  99.         }
  101.        /// <summary>
  102.        /// 删除用户记录
  103.        /// </summary>
  104.        /// <param name="userid">用户ID</param>
  105.         public void UserDelete(int UserID)
  106.         {
  107.             string sSQL = "delete from Tb_Sys_User where [UserID]='" + UserID + "'";
  108.             MSDA.Open();
  109.             MSDA.ExecuteNonQuery(CommandType.Text, sSQL, null);
  110.             MSDA.Close();
  111.         }
  112.         /// <summary>
  113.         /// 查询指定或全部用户记录
  114.         /// </summary>
  115.         /// <param name="SearchTxt">查找内容</param>
  116.         /// <param name="IsSearch">是否精确查询</param>
  117.         /// <param name="i">查找关键字,例:1:帐号；2:用户名；3:组织机构；4:用户id；非1,2,3,4且SearchTxt为空:查找全部</param>
  118.         public DataView  UserSearch(string SearchTxt, string i,bool IsSearch)
  119.         {
  120.             string sSQL = "select * from Tb_Sys_User a ,Tb_Sys_Employee b,Tb_Sys_Organization c  where  ";
  121.             
  122.          if(SearchTxt!="")
  123.          {
  124.              if (IsSearch == true)
  125.              {
  126.                  switch (i)
  127.                  {
  128.                      case "1":
  129.                          sSQL = sSQL + "  a.UserAccount like '%" + SearchTxt + "%' and ";
  130.                          break;
  131.                      case "2":
  132.                          sSQL = sSQL + "  b.EmpName like '%" + SearchTxt + "%' and ";
  133.                          break;
  134.                      case "3":
  135.                          sSQL = sSQL + "  c.OrgName like '%" + SearchTxt + "%' and ";
  136.                          break;
  137.                      case "4":
  138.                          sSQL = sSQL + "  a.UserID like '%" + SearchTxt + "%' and ";
  139.                          break;
  140.                  }
  141.              }
  142.              else
  143.              { //精确查询
  144.                  switch (i)
  145.                  {
  146.                      case "1":
  147.                          sSQL = sSQL + "  a.UserAccount='" + SearchTxt + "' and ";
  148.                          break;
  149.                      case "2":
  150.                          sSQL = sSQL + " b.EmpName='" + SearchTxt + "'  and ";
  151.                          break;
  152.                      case "3":
  153.                          sSQL = sSQL + " c.OrgName='" + SearchTxt + "'  and ";
  154.                          break;
  155.                      case "4":
  156.                          sSQL = sSQL + "a.UserID='" + SearchTxt + "'  and ";
  157.                          break;
  158.                  }
  159.              }
  160.          }
  161.          sSQL=sSQL+" b.EmpID=a.EmpID and c.OrgID=b.PrimaryOrgID";
  163.           
  164.             MSDA.Open();
  165.             NewObj newobject = new NewObj();
  166.            // bool returnvalue = newobject.Update(sSQL, Params, CommandType.Text);
  167.             DataView dv;
  168.             try
  169.             {
  170.                  dv = newobject.Search(sSQL, null, CommandType.Text).Tables[0].DefaultView;
  171.             }
  172.             catch
  173.             {
  174.                 dv = null;
  175.             }
  176.             // MSDA.ExecuteDataset(CommandType.Text, sSQL, null, ds, "");
  177.             finally
  178.             {
  179.                 MSDA.Close();
  181.             }
  182.             return dv; //ds.Tables[0].DefaultView;
  183.            
  184.         }
  186.         /// <summary>
  187.         /// 获取所有角色列表
  188.         /// </summary>
  189.         public DataView RoleGetAll()
  190.         {
  191.             string sSQL = "select  RoleID ,RoleName from Tb_Sys_Role";
  192.            
  193.             MSDA.Open();
  194.             NewObj newobject = new NewObj();
  195.             DataView dv = newobject.Search(sSQL, null, CommandType.Text).Tables[0].DefaultView;
  196.           
  197.             MSDA.Close();
  198.             return dv; 
  199.         }
  200.         /// <summary>
  201.         /// 添加用户权限记录
  202.         /// </summary>
  203.         /// <returns>返回一bool类型值</returns>
  204.         public bool UserRoleAdd(int userid, int roleid, DateTime editdate)
  205.         {
  206.             QueryParameterCollection Params = new QueryParameterCollection();
  207.             Params.Clear();
  208.             Params.Add("@userid", userid);
  209.             Params.Add("@roleid", roleid);
  210.             Params.Add("@editdate", editdate);
  213.             string sSQL = "insert into Tb_Sys_UserRole([UserID],[RoleID],[EditDate]) values(@userid,@roleid,@editdate)";
  214.             MSDA.Open();
  216.             NewObj newobject = new NewObj();
  217.             bool returnvalue = newobject.insert(sSQL, Params, CommandType.Text);
  219.             MSDA.Close();
  220.             return returnvalue;
  221.         }
  222.         /// <summary>
  223.         ///清除用户对应的权限记录
  224.         /// </summary>
  225.         /// <param name="userid">用户ID</param>
  226.         public void UserRoleDelete(int UserID)
  227.         {
  228.             string sSQL = "delete from Tb_Sys_UserRole where [UserID]='" + UserID + "'";
  229.             MSDA.Open();
  230.             MSDA.ExecuteNonQuery(CommandType.Text, sSQL, null);
  231.             MSDA.Close();
  232.         }
  234.         /// <summary>
  235.         /// 获取某个用户角色
  236.         /// </summary>
  237.         public DataView RoleGetByID(int userid)
  238.         {
  239.             //string sSQL = "select  RoleID ,RoleName from Tb_Sys_Role where  UserID='" + userid + "'";
  240.             string sSQL = "select * from Tb_Sys_Role where  RoleID in(select RoleID from Tb_Sys_UserRole where UserID='" + userid + "')";
  241.             MSDA.Open();
  242.             NewObj newobject = new NewObj();
  243.             DataView dv = newobject.Search(sSQL, null, CommandType.Text).Tables[0].DefaultView;
  245.             MSDA.Close();
  246.             return dv;
  247.         }
  249.         /// <summary>
  250.         /// 初始化用户密码
  251.         /// </summary>
  252.         /// <returns>返回bool类型参数</returns>
  253.         public bool UserPwdUpdata(int @userid)
  254.         {
  255.             QueryParameterCollection Params = new QueryParameterCollection();
  256.             Params.Clear();
  257.             Params.Add("@userid", @userid);
  259.             //string sSQL = "update  Tb_Sys_User Set UserPwd='111111'  where UserID=@userid";
  260.             string sSQL = "update  Tb_Sys_User Set UserPwd='1'  where UserID=@userid";
  261.             MSDA.Open();
  262.             NewObj newobject = new NewObj();
  263.             bool returnvalue = newobject.Update(sSQL, Params, CommandType.Text);
  264.             MSDA.Close();
  265.             return returnvalue;
  266.         }
  267.         /// <summary>
  268.         /// 获取某个角色信息 
  269.         /// </summary>
  270.         public DataView RoleGetName(int roleid)
  271.         {
  272.             string sSQL = "select  RoleName from Tb_Sys_Role where  RoleID='" + roleid + "'";
  273.          
  274.             MSDA.Open();
  275.             NewObj newobject = new NewObj();
  276.             DataView dv = newobject.Search(sSQL, null, CommandType.Text).Tables[0].DefaultView;
  278.             MSDA.Close();
  279.             return dv;
  280.         }
  282.         /// <summary>
  283.         /// 得到某个业务角色的所有用户
  284.         /// </summary>
  285.         /// <param name="SOrgID">业务角色ID</param>
  286.         public DataView GetOrgzation(int  OpID)
  287.         {
  288.             //string sSQL = "select OrgName from Tb_Sys_Organization where OrgID=" + orgid;
  289.            // string sSQL = "select * from tb_sys_empoprole where OpID=" + OpID;
  290.             string sSQL = "select OpName,OpID from tb_sys_oprole where OpID=" + OpID;
  291.           
  293.             MSDA.Open();
  294.             NewObj newobject = new NewObj();
  295.             DataView dv;
  296.             try
  297.             {
  298.                  dv = newobject.Search(sSQL, null, CommandType.Text).Tables[0].DefaultView;
  299.             }
  300.             catch
  301.             {
  302.                 dv = null;
  303.             }
  304.             finally
  305.             {
  306.                 MSDA.Close();
  307.             }
  308.            return dv;
  309.         }
  312.         /// <summary>
  313.         /// 根据用户ID得到组织机构ID
  314.         /// </summary>
  315.       
  316.         public int  GetOrgID(int userid)
  317.         {
  318.             string sSQL = "select PrimaryOrgID from Tb_Sys_Employee where EmpID =(select EmpID from Tb_Sys_User where UserID='" + userid +"')";
  320.             MSDA.Open();
  321.             NewObj newobject = new NewObj();
  322.          
  323.             int orgid;
  324.             try
  325.             {
  326.                 DataView dv;
  327.                 dv = newobject.Search(sSQL, null, CommandType.Text).Tables[0].DefaultView;
  328.                 orgid = Convert.ToInt16(dv[0][0].ToString().Trim());
  329.             }
  330.             catch
  331.             {
  332.                 orgid = -1;
  333.             }
  334.             finally
  335.             {
  336.                 MSDA.Close();
  337.             }
  338.             return orgid;
  339.         }
  341.         #endregion
  343.         #region  项目分类
  344.         /*************************************************************************************************************  
  345.                                            * Module： 项目分类
  346.                                            * Desc：添加、更新、删除、查询记录
  347.                                            * Author：朱皖峰
  348.                                            * Date： 2007-03
  349.        **************************************************************************************************************/
  350.         /// <summary>
  351.         /// 添加项目分类
  352.         /// </summary>
  353.         /// <returns>返回一bool类型值</returns>
  354.         public bool ProjectAdd(string serialname)
  355.         {
  356.             QueryParameterCollection Params = new QueryParameterCollection();
  357.             Params.Clear();
  359.             Params.Add("@SerialName", serialname);
  361.             string sSQL = "insert into tb_Project_Serial([SerialName]) values(@SerialName)";
  362.             MSDA.Open();
  364.             NewObj newobject = new NewObj();
  365.             bool returnvalue = newobject.insert(sSQL, Params, CommandType.Text);
  367.             MSDA.Close();
  368.             return returnvalue;
  369.         }
  371.         /// <summary>
  372.         /// 更新项目分类
  373.         /// </summary>
  374.         /// <returns>返回bool类型参数</returns>
  375.         public bool ProjectUpdata(int serialid, string serialname)
  376.         {
  377.             QueryParameterCollection Params = new QueryParameterCollection();
  378.             Params.Clear();
  379.             Params.Add("@serialid", serialid);
  380.             Params.Add("@serialname", serialname);
  382.             string sSQL = "update  tb_Project_Serial Set SerialName =@serialname  where SerialID=@serialid";
  383.             MSDA.Open();
  384.             NewObj newobject = new NewObj();
  385.             bool returnvalue = newobject.Update(sSQL, Params, CommandType.Text);
  386.             MSDA.Close();
  387.             return returnvalue;
  388.         }
  389.         /// <summary>
  390.         /// 删除项目分类
  391.         /// </summary>
  392.         /// <param name="userid">项目分类ID</param>
  393.         public void ProjectDelete(int serialid)
  394.         {
  395.             string sSQL = "delete from tb_Project_Serial where [SerialID]='" + serialid + "'";
  396.             MSDA.Open();
  397.             MSDA.ExecuteNonQuery(CommandType.Text, sSQL, null);
  398.             MSDA.Close();
  399.         }
  401.         /// <summary>
  402.         /// 获取项目分类记录
  403.         /// </summary>
  404.         public DataView ProjectSearch(int serialid)
  405.         {
  406.             string sSQL = "select * from tb_Project_Serial";
  408.             if (serialid != -1)
  409.                 sSQL = sSQL + "  where   SerialID='" + serialid + "'"; 
  410.       
  411.             MSDA.Open();
  412.             NewObj newobject = new NewObj();
  413.             DataView dv = newobject.Search(sSQL, null, CommandType.Text).Tables[0].DefaultView;
  414.          
  415.             MSDA.Close();
  416.             return dv;
  417.         }
  418.       /// <summary>
  419.         /// 根据项目名称获取项目分类记录
  420.       /// </summary>
  421.       /// <param name="serialid">项目名称</param>
  422.       /// <returns></returns>
  423.         public int ProjectSearchByName(string serialname)
  424.         {
  425.             string sSQL = "select * from tb_Project_Serial where   SerialName='" + serialname + "'";
  426.       
  427.             MSDA.Open();
  428.             NewObj newobject = new NewObj();
  429.             DataView dv = newobject.Search(sSQL, null, CommandType.Text).Tables[0].DefaultView;
  430.             MSDA.Close();
  431.             int returnvalue=0;
  432.             returnvalue = dv.Count;
  433.             return returnvalue;
  434.         }
  435.         /// <summary>
  436.         /// 获取全部项目分类记录
  437.         /// </summary>
  438.         public DataTable ProjectSerialGetAll()
  439.         {
  440.             string sSQL = "select * from tb_Project_Serial";
  441.             MSDA.Open();
  442.             NewObj newobject = new NewObj();
  443.             DataTable dt = new DataTable();
  444.             dt = null;
  445.             dt = newobject.Search(sSQL, null, CommandType.Text).Tables[0];
  446.             MSDA.Close();
  448.             return dt;
  449.         }
  451.         #endregion
  453.         #region  工作流
  454.         /***************************************************************************************************************  
  455.                                               * Module： 工作流
  456.                                               * Desc：项目申请
  457.                                               * Author：朱皖峰
  458.                                               * Date： 2007-04
  459.         ****************************************************************************************************************/
  460.         ///// <summary>
  461.         ///// 启动工作流
  462.         ///// </summary>
  463.         ///// <param name="UserId">用户ID</param>
  464.         ///// <param name="WFId">启动工作流ID</param>
  465.         ///// <returns>返回string类型数据:流水号</returns>
  466.         //public bool WorkFlowStart(out WFStartReValue[] WF_StartReValue, int UserId, int WFId)
  467.         //{
  468.         //    string StrProjcetLsh = DateTime.Now.ToString("yyyyMMdd");//例如:20070410   
  469.         //    int Lsh = 1;
  471.         //    //取tb_Project 中字段ProjcetLsh的最大值
  472.         //    MSDA.Open();
  473.         //    DataTable dt = SqlHelper.ExecuteDataTable(SqlHelper.connectionString, CommandType.StoredProcedure, "P_WF_ProjectMaxLsh", null);
  474.         //    if (dt.Rows.Count > 0 && dt.Rows[0]["ProjcetLsh"].ToString() != "")
  475.         //    {
  476.         //        string ProjcetLsh = dt.Rows[0]["ProjcetLsh"].ToString().Trim();
  477.         //        Lsh = Convert.ToInt32(ProjcetLsh.Substring(8).Trim().ToString()) + 1;
  478.         //    }
  480.         //    int strlen = Lsh.ToString().Trim().Length;
  481.         //    for (int i = 1; i <= 5 - strlen; i++)
  482.         //    {
  483.         //        StrProjcetLsh = StrProjcetLsh + "0";  //格式化流水号后五位，补0
  484.         //    }
  485.         //    StrProjcetLsh = StrProjcetLsh + Lsh.ToString();   //记录中最大值 化为int型后 +1  
  487.         //    //向tb_Project中添加空项目记录
  488.         //    WFStartReValue[] returnvalue=new WFStartReValue[1];
  489.         //    if (StrProjcetLsh != "")
  490.         //    {
  491.         //        returnvalue[0].LSH = StrProjcetLsh;
  492.         //        WF_StartReValue = returnvalue;
  493.         //        return true;
  494.         //    }
  495.         //    else
  496.         //    {
  497.         //        returnvalue[0].LSH = "";
  498.         //        WF_StartReValue = returnvalue;
  499.         //        return false;
  500.         //    }
  501.         //}
  502.         /// <summary>
  503.         /// 工作流启动返回信息结构
  504.         /// </summary>
  505.         public struct WFStartReValue   
  506.         {
  507.             public string LSH;          //流水号
  508.           //  public int PROJECTID;      //项目ID
  509.         }
  511.         /// <summary>
  512.         /// 获取项目记录
  513.         /// </summary>
  514.         public DataView ProjectGetAll(int prjid)
  515.         {
  516.            string sSQL = "select * from tb_Project  where  ProjectID='"+ prjid +"'";
  517.             MSDA.Open();
  518.             NewObj newobject = new NewObj();
  519.             DataView dv = null;
  520.             dv = newobject.Search(sSQL, null, CommandType.Text).Tables[0].DefaultView;
  521.             MSDA.Close();
  523.             return dv;
  524.         }
  525.         /// <summary>
  526.         /// 获取变更项目记录
  527.         /// </summary>
  528.         public DataView PrjAlertGetAll(int alertid)
  529.         {
  530.             string sSQL = "select * from tb_PrjAlert  where  AlertID='" + alertid + "'";
  531.             MSDA.Open();
  532.             NewObj newobject = new NewObj();
  533.             DataView dv = null;
  534.             dv = newobject.Search(sSQL, null, CommandType.Text).Tables[0].DefaultView;
  535.             MSDA.Close();
  537.             return dv;
  538.         }
  539.         /// <summary>
  540.         /// 获取工作流实例信息
  541.         /// </summary>
  542.         /// <param name="WFInstanceID"></param>
  543.         /// <returns></returns>
  544.         public DataView WFInstanceGetAll(int WFInstanceID)
  545.         {
  546.             string sSQL = "select * from tb_WF_Instance where WFInstanceID='"  + WFInstanceID + "' ";
  547.             MSDA.Open();
  548.             NewObj newobject = new NewObj();
  549.             DataView dv = null;
  550.             dv = newobject.Search(sSQL, null, CommandType.Text).Tables[0].DefaultView;
  551.             MSDA.Close();
  553.             return dv;
  554.         }
  556.         /// <summary>
  557.         ///添加项目
  558.         /// </summary>
  559.         public int  WFProjectAdd(ProjectInfo projectinfo)
  560.         {
  561.           
  562.             SqlParameter[] parameters ={ 
  563.                 new SqlParameter ("@ProjectID",SqlDbType.Int ,4),
  564.                 new SqlParameter ("@ProjectName" ,SqlDbType.VarChar,200),
  565.                 new SqlParameter ("@PrjSort" ,SqlDbType.VarChar,2),
  566.                 new SqlParameter ("@JcTransactor" ,SqlDbType.VarChar,30),
  567.                 new SqlParameter ("@JcFName" ,SqlDbType.VarChar,100),
  569.                 new SqlParameter ("@QuestOrg" ,SqlDbType.VarChar,100),  
  570.                 new SqlParameter ("@ZgTransactor" ,SqlDbType.VarChar,30),
  571.                 new SqlParameter ("@ZgFName" ,SqlDbType.VarChar,100),
  572.                 new SqlParameter ("@JqbXTransactor" ,SqlDbType.VarChar,30),
  574.                 new SqlParameter ("@JqbXFName" ,SqlDbType.VarChar,100),
  575.                 new SqlParameter ("@GcglXTransactor" ,SqlDbType.VarChar,30),
  576.                 new SqlParameter ("@GcglXFName" ,SqlDbType.VarChar,100), 
  577.                 new SqlParameter ("@JqbBTransactor" ,SqlDbType.VarChar,30),
  578.                 new SqlParameter ("@JqbBFName" ,SqlDbType.VarChar,100),
  580.                 new SqlParameter ("@GcglHTransactor" ,SqlDbType.VarChar,30),
  581.                 new SqlParameter ("@GcglHFName" ,SqlDbType.VarChar,100),
  582.                 new SqlParameter ("@FgTransactor" ,SqlDbType.VarChar,20),
  583.                 new SqlParameter ("@FgIdea" ,SqlDbType.VarChar,200),
  584.                 new SqlParameter ("@ZjwyhTransactor" ,SqlDbType.VarChar,20),
  586.                 new SqlParameter ("@ZjwyhIdea" ,SqlDbType.VarChar,200), 
  587.                 new SqlParameter ("@GsTransactor" ,SqlDbType.VarChar,20),
  588.                 new SqlParameter ("@GsIdea" ,SqlDbType.VarChar,400),
  589.                 new SqlParameter ("@GcglQTransactor" ,SqlDbType.VarChar,20),
  590.                 new SqlParameter ("@GcglQIdea" ,SqlDbType.VarChar,200),
  592.                 new SqlParameter ("@JqbZTransactor" ,SqlDbType.VarChar,30),
  593.                 new SqlParameter ("@JqbZFName" ,SqlDbType.VarChar,100),
  594.                 new SqlParameter ("@Status" ,SqlDbType.Int,2),
  595.             };
  596.           
  597.             parameters[0].Direction = ParameterDirection.Output;
  598.             parameters[1].Value = projectinfo.ProjectName;
  599.             parameters[2].Value = projectinfo.PrjSort;
  600.             parameters[3].Value = projectinfo.JcTransactor;
  601.             parameters[4].Value = projectinfo.JcFName;
  602.             parameters[5].Value = projectinfo.QuestOrg;
  604.             parameters[6].Value = projectinfo.ZgTransactor;
  605.             parameters[7].Value = projectinfo.ZgFName;
  606.             parameters[8].Value = projectinfo.JqbxTransactor;
  607.             parameters[9].Value = projectinfo.JqbxFName;
  608.             parameters[10].Value = projectinfo.GcglxTransactor;
  610.             parameters[11].Value = projectinfo.GcglxFName;
  611.             parameters[12].Value = projectinfo.JqbbTransactor;
  612.             parameters[13].Value = projectinfo.JqbbFName;
  613.             parameters[14].Value = projectinfo.GcglhTransactor;
  614.             parameters[15].Value = projectinfo.GcglhFName;
  616.             parameters[16].Value = projectinfo.FgTransactor;
  617.             parameters[17].Value = projectinfo.FgIdea;
  618.             parameters[18].Value = projectinfo.ZjwyhTransactor;
  619.             parameters[19].Value = projectinfo.ZjwyhIdea;
  620.             parameters[20].Value = projectinfo.GsTransactor;
  622.             parameters[21].Value = projectinfo.GsIdea;
  623.             parameters[22].Value = projectinfo.GcglqTransactor;
  624.             parameters[23].Value = projectinfo.GcglqIdea;
  625.             parameters[24].Value = projectinfo.JqbzTransactor;
  626.             parameters[25].Value = projectinfo.JqbzFName;
  628.             parameters[26].Value = projectinfo.Status;
  629.             int rv = 0;
  630.             try
  631.             { 
  632.                 SqlHelper.ExecuteScalar(SqlHelper.connectionString, CommandType.StoredProcedure, "P_Project_ADD", parameters);
  633.                 rv = Convert.ToInt32(parameters[0].Value.ToString().Trim());
  634.             }
  635.             catch 
  636.             {
  637.                rv = 0;
  638.             }
  639.             return rv;
  640.         }
  641.         /// <summary>
  642.         /// 添加工作流实例记录
  643.         /// </summary>
  644.         /// <param name="wfinstanceinfo"></param>
  645.         /// <returns></returns>
  646.         public int  WFInstanceADD(WFInstanceInfo wfinstanceinfo)
  647.         {
  649.             SqlParameter[] parameters ={ 
  650.                 new SqlParameter ("@WFInstanceID",SqlDbType.Int,4),
  651.                 new SqlParameter ("@CreateDate",SqlDbType.DateTime ,8),
  652.                 new SqlParameter ("@CreateUserID",SqlDbType.Int ,4),
  653.                 new SqlParameter ("@TargetRoleID",SqlDbType.Int ,4),
  654.                 new SqlParameter ("@ClientID",SqlDbType.Int ,4),
  655.                 new SqlParameter ("@RealEndDate",SqlDbType.DateTime ,8),
  656.                 new SqlParameter ("@Status",SqlDbType.Int ,4),
  658.                 new SqlParameter ("@TheoryEndDate",SqlDbType.DateTime ,8),
  659.                 new SqlParameter ("@WorkFlowID",SqlDbType.Int ,4),
  660.                 new SqlParameter ("@PrjID",SqlDbType.Int ,4),
  661.             };
  662.             parameters[0].Direction = ParameterDirection.Output;
  663.             parameters[1].Value = wfinstanceinfo.CreateDate;
  664.             parameters[2].Value = wfinstanceinfo.CreateUserID;
  665.             parameters[3].Value = wfinstanceinfo.TargetRoleID;
  666.             parameters[4].Value = wfinstanceinfo.ClientID;
  667.             parameters[5].Value = wfinstanceinfo.RealEndDate;
  668.             parameters[6].Value = wfinstanceinfo.Status;   
  669.             parameters[7].Value = wfinstanceinfo.TheoryEndDate;
  670.             parameters[8].Value = wfinstanceinfo.WorkflowID;
  671.             parameters[9].Value = wfinstanceinfo.PrjID;
  673.             int WFInstanceID = 0;
  674.             try
  675.             {
  676.                 SqlHelper.ExecuteScalar(SqlHelper.connectionString, CommandType.StoredProcedure, "P_WF_Instance_ADD", parameters);
  677.                  WFInstanceID = Convert.ToInt32(parameters[0].Value.ToString().Trim());
  678.             }
  679.             catch
  680.             {
  681.             
  682.                 WFInstanceID = 0;
  683.             }
  684.             return WFInstanceID;
  685.         }
  687.         /// <summary>
  688.         /// 提交申请项目记录
  689.         /// </summary>
  690.         /// <param name="projectinfo"></param>
  691.         /// <returns>返回类型:int 返回值:0:表示不成功，-1:成功</returns>
  692.         public int  WFProjectUpdata(ProjectInfo projectinfo)
  693.         {
  695.             //SqlParameter[] parameters ={ 
  696.             //    new SqlParameter ("@ProjectID",SqlDbType.Int ,4),
  697.             //    new SqlParameter ("@AuditIdea" ,SqlDbType.VarChar,20),
  698.             //    new SqlParameter ("@ChargeMachine" ,SqlDbType.Decimal,14),
  699.             //    new SqlParameter ("@ChargeManPower" ,SqlDbType.Decimal,14),
  700.             //    new SqlParameter ("@ChargeOther" ,SqlDbType.Decimal,14),
  701.             //    new SqlParameter("@ChargeStuff" ,SqlDbType.Decimal ,14),
  703.             //    new SqlParameter ("@ChargeSum" ,SqlDbType.Decimal,15),
  704.             //    new SqlParameter ("@CreateDate" ,SqlDbType.DateTime,8),
  705.             //    new SqlParameter ("@Yw_ChargeMachine" ,SqlDbType.Decimal,14),
  706.             //    new SqlParameter ("@Yw_ChargeManPower" ,SqlDbType.Decimal,14),
  708.             //    new SqlParameter ("@Yw_ChargeOther" ,SqlDbType.Decimal,14),
  709.             //    new SqlParameter ("@Yw_ChargeStuff" ,SqlDbType.Decimal,14),
  710.             //    new SqlParameter ("@Yw_ChargeSum" ,SqlDbType.Decimal,15),
  712.             //    new SqlParameter ("@Yw_ExpenseChannel" ,SqlDbType.VarChar,200),
  713.             //    new SqlParameter ("@Yw_ProjectNumber" ,SqlDbType.VarChar,100),
  714.             //    new SqlParameter ("@Yw_TransactorIdea" ,SqlDbType.VarChar,200),
  716.             //    new SqlParameter ("@Yw_TransactorSignature" ,SqlDbType.VarChar,20),
  717.             //    new SqlParameter ("@DirectorGeneralIdea" ,SqlDbType.VarChar,200),
  718.             //    new SqlParameter ("@EditUnit" ,SqlDbType.VarChar,100),
  719.             //    new SqlParameter ("@GeneralManagerIdea" ,SqlDbType.VarChar,200),
  720.             //    new SqlParameter ("@Fg_ChargeMachine" ,SqlDbType.Decimal,14),
  721.             //    new SqlParameter ("@Fg_ChargeManPower" ,SqlDbType.Decimal,14),
  722.             //    new SqlParameter ("@Fg_ChargeOther" ,SqlDbType.Decimal,14),
  724.             //    new SqlParameter ("@Fg_ChargeStuff" ,SqlDbType.Decimal,14),
  725.             //    new SqlParameter ("@Fg_ChargeSum" ,SqlDbType.Decimal,15),
  727.             //    new SqlParameter ("@Fg_ExpenseChannel" ,SqlDbType.VarChar,200),
  728.             //    new SqlParameter ("@Fg_ProjectNumber" ,SqlDbType.VarChar,100),
  729.             //    new SqlParameter ("@Fg_TransactorIdea" ,SqlDbType.VarChar,200),
  731.             //    new SqlParameter ("@Fg_TransactorSignature" ,SqlDbType.VarChar,20),
  732.             //    new SqlParameter ("@Zjl_ChargeMachine" ,SqlDbType.Decimal,14),
  733.             //    new SqlParameter ("@Zjl_ChargeManPower" ,SqlDbType.Decimal,14),
  734.             //    new SqlParameter ("@Zjl_ChargeOther" ,SqlDbType.Decimal,14),
  736.             //    new SqlParameter ("@Zjl_ChargeStuff" ,SqlDbType.Decimal,14),
  737.             //    new SqlParameter ("@Zjl_ChargeSum" ,SqlDbType.Decimal,15),
  740.             //    new SqlParameter ("@Zjl_ExpenseChannel" ,SqlDbType.VarChar,200),
  741.             //    new SqlParameter ("@Zjl_ProjectNumber" ,SqlDbType.VarChar,100),
  742.             //    new SqlParameter ("@Zjl_TransactorIdea" ,SqlDbType.VarChar,200),
  744.             //    new SqlParameter ("@Zjl_TransactorSignature" ,SqlDbType.VarChar,20),
  745.             //    new SqlParameter ("@OfficeLeadIdea" ,SqlDbType.VarChar,100),
  746.             //    new SqlParameter ("@ProjectManager" ,SqlDbType.VarChar,20),
  748.             //    new SqlParameter ("@ProjectName" ,SqlDbType.VarChar,20),
  749.             //    new SqlParameter ("@ProjectReason" ,SqlDbType.VarChar,200),
  751.             //    new SqlParameter ("@SuccessDate" ,SqlDbType.DateTime,8),
  752.             //    new SqlParameter ("@Transactor" ,SqlDbType.VarChar,20),
  753.             //    new SqlParameter ("@UnitManager" ,SqlDbType.VarChar,200),
  755.             //    new SqlParameter ("@ProjectType" ,SqlDbType.Int,4),
  756.             //    new SqlParameter ("@wi_id" ,SqlDbType.Int,4),
  757.             //    new SqlParameter ("@ProjectSort" ,SqlDbType.VarChar,200),
  758.             //    new SqlParameter ("@Dynamic_Wi_ID" ,SqlDbType.Int,4),
  759.             //    new SqlParameter ("@Status" ,SqlDbType.Int,2),
  762.             //    new SqlParameter ("@ProjectNumber" ,SqlDbType.VarChar,200),
  763.             //    new SqlParameter ("@CurrentDate" ,SqlDbType.DateTime,8),
  764.             //    new SqlParameter ("@FactCharge" ,SqlDbType.Decimal,16),
  765.             //    new SqlParameter ("@Memo" ,SqlDbType.VarChar,200),
  766.             //    new SqlParameter ("@PlanCharge" ,SqlDbType.Decimal,15),
  768.             //    new SqlParameter ("@SuccessedDate" ,SqlDbType.DateTime,8),
  769.             //    new SqlParameter ("@TakeDepartment" ,SqlDbType.VarChar,200),
  770.             //    new SqlParameter ("@ProjcetLsh" ,SqlDbType.VarChar,15),
  772.             //    new SqlParameter ("@Jqb_TransactorSignature" ,SqlDbType.VarChar,20),
  773.             //    new SqlParameter ("@Jqb_Idea" ,SqlDbType.VarChar,200),
  775.             //    new SqlParameter ("@cw_TransactorSignature" ,SqlDbType.VarChar,20),
  776.             //    new SqlParameter ("@cw_Idea" ,SqlDbType.VarChar,200),
  778.             //    new SqlParameter ("@Ld_TransactorSignature" ,SqlDbType.VarChar,20),
  779.             //    new SqlParameter ("@Ld_Idea" ,SqlDbType.VarChar,200),
  780.             //    new SqlParameter ("@Jqb2_TransactorSignature" ,SqlDbType.VarChar,20),
  782.             //    new SqlParameter ("returnValue",SqlDbType.Int ,2)
  784.             //};
  785.             //parameters[0].Value = projectinfo.ProjectID;
  786.             //parameters[1].Value = projectinfo.AuditIdea;
  787.             //parameters[2].Value = projectinfo.Chargemachine;
  788.             //parameters[3].Value = projectinfo.ChargeManPower;
  789.             //parameters[4].Value = projectinfo.ChargeOther;
  790.             //parameters[5].Value = projectinfo.ChargeStuff;
  792.             //parameters[6].Value = projectinfo.ChargeSum;
  793.             //parameters[7].Value = projectinfo.CreateDate;
  794.             //parameters[8].Value = projectinfo.Yw_ChargeMachine;
  795.             //parameters[9].Value = projectinfo.Yw_ChargeManPower;
  796.             //parameters[10].Value = projectinfo.Yw_ChargeOther;
  798.             //parameters[11].Value = projectinfo.Yw_ChargeStuff;
  799.             //parameters[12].Value = projectinfo.Yw_ChargeSum;
  800.             //parameters[13].Value = projectinfo.Yw_ExpenseChannel;
  801.             //parameters[14].Value = projectinfo.Yw_ProjectNumber;
  802.             //parameters[15].Value = projectinfo.Yw_TransactorIdea;
  804.             //parameters[16].Value = projectinfo.Yw_TransactorSignature;
  805.             //parameters[17].Value = projectinfo.DirectorGeneralIdea;
  806.             //parameters[18].Value = projectinfo.EditUnit;
  807.             //parameters[19].Value = projectinfo.GeneralManagerIdea;
  808.             //parameters[20].Value = projectinfo.Fg_ChargeMachine;
  810.             //parameters[21].Value = projectinfo.Fg_ChargeManPower;
  811.             //parameters[22].Value = projectinfo.Fg_ChargeOther;
  812.             //parameters[23].Value = projectinfo.Fg_ChargeStuff;
  813.             //parameters[24].Value = projectinfo.Fg_ChargeSum;
  814.             //parameters[25].Value = projectinfo.Fg_ExpenseChannel;
  815.             //parameters[26].Value = projectinfo.Fg_ProjectNumber;
  817.             //parameters[27].Value = projectinfo.Fg_TransactorIdea;
  818.             //parameters[28].Value = projectinfo.Fg_TransactorSignature;
  819.             //parameters[29].Value = projectinfo.Zjl_ChargeMachine;
  820.             //parameters[30].Value = projectinfo.Zjl_ChargeManPower;
  821.             //parameters[31].Value = projectinfo.Zjl_ChargeOther;
  822.             //parameters[32].Value = projectinfo.Zjl_ChargeStuff;
  824.             //parameters[33].Value = projectinfo.Zjl_ChargeSum;
  825.             //parameters[34].Value = projectinfo.Zjl_ExpenseChannel;
  826.             //parameters[35].Value = projectinfo.Zjl_ProjectNumber;
  827.             //parameters[36].Value = projectinfo.Zjl_TransactorIdea;
  828.             //parameters[37].Value = projectinfo.Zjl_TransactorSignature;
  829.             //parameters[38].Value = projectinfo.OfficeLeadIdea;
  831.             //parameters[39].Value = projectinfo.ProjectManager;
  832.             //parameters[40].Value = projectinfo.ProjectName;
  833.             //parameters[41].Value = projectinfo.ProjectReason;
  834.             //parameters[42].Value = projectinfo.SuccessDate;
  835.             //parameters[43].Value = projectinfo.Transactor;
  836.             //parameters[44].Value = projectinfo.UnitManager;
  838.             //parameters[45].Value = projectinfo.ProjectType;
  839.             //parameters[46].Value = projectinfo.Wi_Id;
  840.             //parameters[47].Value = projectinfo.ProjectSort;
  841.             //parameters[48].Value = projectinfo.Dynamic_Wi_ID;
  842.             //parameters[49].Value = projectinfo.Status;
  843.             //parameters[50].Value = projectinfo.ProjectNumber;
  845.             //parameters[51].Value = projectinfo.CurrentDate;
  846.             //parameters[52].Value = projectinfo.FactCharge;
  847.             //parameters[53].Value = projectinfo.Memo;
  848.             //parameters[54].Value = projectinfo.PlanCharge;
  849.             //parameters[55].Value = projectinfo.SuccessedDate;
  850.             //parameters[56].Value = projectinfo.TakeDepartment;
  851.             //parameters[57].Value = projectinfo.ProjcetLsh;
  853.             //parameters[58].Value = projectinfo.Jqb_TransactorSignature;
  854.             //parameters[59].Value = projectinfo.Jqb_Idea;
  856.             //parameters[60].Value = projectinfo.cw_TransactorSignature;
  857.             //parameters[61].Value = projectinfo.cw_Idea;
  859.             //parameters[62].Value = projectinfo.Jqb_Idea;
  860.             //parameters[63].Value = projectinfo.cw_TransactorSignature;
  861.             //parameters[64].Value = projectinfo.cw_Idea;
  863.             //parameters[65].Direction = ParameterDirection.ReturnValue;
  865.             int rv = 0;
  866.             //try
  867.             //{
  868.             //    SqlHelper.ExecuteScalar(SqlHelper.connectionString, CommandType.StoredProcedure, "P_Project_Updata", parameters);
  869.             //    rv = Convert.ToInt32(parameters[65].Value.ToString().Trim());
  870.             //}
  871.             //catch
  872.             //{
  873.             //    rv = 0;
  874.             //}
  875.           
  876.             return rv;
  877.         }
  879.         /// <summary>
  880.         /// 添加工作流活动记录
  881.         /// </summary>
  882.         /// <param name="wfinstanceinfo"></param>
  883.         /// <returns></returns>
  884.         public int WFActivityADD(WFActivityInfo wfactivityinfo)
  885.         {
  887.             SqlParameter[] parameters ={ 
  888.                 new SqlParameter ("@ActivityID",SqlDbType.Int,4),
  889.                 new SqlParameter ("@Unit",SqlDbType.VarChar ,200),
  890.                 new SqlParameter ("@UnitType",SqlDbType.Int ,4),
  891.                 new SqlParameter ("@ActDesc",SqlDbType.VarChar ,200),
  892.                 new SqlParameter ("@ActName",SqlDbType.VarChar ,200),
  893.                 new SqlParameter ("@WorkFlowID",SqlDbType.Int ,4),
  894.                 new SqlParameter ("@PageID",SqlDbType.Int,4),
  896.                 new SqlParameter ("@DecisionTitle",SqlDbType.VarChar ,200),
  897.                 new SqlParameter ("@DecisionName",SqlDbType.VarChar ,200),
  898.                 new SqlParameter ("@StartEnd",SqlDbType.Int ,4),
  900.                 new SqlParameter ("@BlockFlag",SqlDbType.Int ,4),
  901.                 new SqlParameter ("@ShuntFlag",SqlDbType.Int ,4),
  902.                 new SqlParameter ("@ModeFlag",SqlDbType.Int ,4),
  903.             };
  904.             parameters[0].Direction = ParameterDirection.Output;
  905.             parameters[1].Value = wfactivityinfo.Unit;
  906.             parameters[2].Value = wfactivityinfo.UnitType;
  907.             parameters[3].Value = wfactivityinfo.ActDesc;
  908.             parameters[4].Value = wfactivityinfo.ActName;
  909.             parameters[5].Value = wfactivityinfo.WorkFlowID;
  910.             parameters[6].Value = wfactivityinfo.PageID;
  911.             parameters[7].Value = wfactivityinfo.DecisionTitle;
  912.             parameters[8].Value = wfactivityinfo.DecisionName;
  913.             parameters[9].Value = wfactivityinfo.StartEnd;
  915.             parameters[10].Value = wfactivityinfo.BlockFlag;
  916.             parameters[11].Value = wfactivityinfo.ShuntFlag;
  917.             parameters[12].Value = wfactivityinfo.ModeFlag;
  919.             //  MSDA.Open();
  920.             //  DataTable dataTable = SqlHelper.ExecuteDataTable(SqlHelper.connectionString, CommandType.StoredProcedure, "P_WF_Instance_ADD", parameters);
  921.             //  int WFInstanceID = Convert.ToInt32(parameters[0].Value.ToString().Trim());
  922.             int ActivityID =0;
  923.             try
  924.             {
  925.                 SqlHelper.ExecuteScalar(SqlHelper.connectionString, CommandType.StoredProcedure, "P_WF_Activity_ADD", parameters);
  926.                 ActivityID = Convert.ToInt32(parameters[0].Value.ToString().Trim());
  927.             }
  928.             catch
  929.             { 
  930.                 ActivityID = 0;
  931.             }
  932.             return ActivityID;
  933.         }
  935.         /// <summary>
  936.         /// 添加工作流活动实例记录
  937.         /// </summary>
  938.         /// <param name="wfinstanceinfo"></param>
  939.         /// <returns></returns>
  940.         public int WFActInsADD(WFActInsInfo wfactinsinfo)
  941.         {
  942.             SqlParameter[] parameters ={ 
  943.                 new SqlParameter ("@ActInsID",SqlDbType.Int,4),
  944.                 new SqlParameter ("@ActivityID",SqlDbType.Int ,4),
  945.                 new SqlParameter ("@CreateDate",SqlDbType.DateTime ,8),
  946.                 new SqlParameter ("@RealEndDate",SqlDbType.DateTime ,8),
  947.                 new SqlParameter ("@Status",SqlDbType.Int ,2),
  948.                 new SqlParameter ("@TheoryEndDate",SqlDbType.DateTime ,8),
  950.                 new SqlParameter ("@WfInstanceID",SqlDbType.Int,4),
  951.                 new SqlParameter ("@BlockReason",SqlDbType.VarChar ,2000),
  952.                 new SqlParameter ("@UserID",SqlDbType.Int ,4),
  953.                 new SqlParameter ("@RoleID",SqlDbType.Int ,4),
  954.             };
  956.             parameters[0].Direction = ParameterDirection.Output;
  957.             parameters[1].Value = wfactinsinfo.ActivityID;
  958.             parameters[2].Value = wfactinsinfo.CreateDate;
  959.             parameters[3].Value = wfactinsinfo.RealEndDate;
  960.             parameters[4].Value = wfactinsinfo.Status;
  961.             parameters[5].Value = wfactinsinfo.TheoryEndDate;
  962.             parameters[6].Value = wfactinsinfo.WfInstanceID;
  963.             parameters[7].Value = wfactinsinfo.BlockReason;
  964.             parameters[8].Value = wfactinsinfo.UserID;
  965.             parameters[9].Value = wfactinsinfo.RoleID;
  967.             //  MSDA.Open();
  968.              int ActInsID =0;
  969.             try
  970.             {
  971.                 SqlHelper.ExecuteScalar(SqlHelper.connectionString, CommandType.StoredProcedure, "P_WF_ActIns_ADD", parameters);
  972.                  ActInsID = Convert.ToInt32(parameters[0].Value.ToString().Trim());
  973.             }
  974.             catch
  975.             {
  976.                 ActInsID = 0;
  977.             }
  979.             return ActInsID;
  980.         }
  983.         /// <summary>
  984.         /// 改变当前工作流活动实例状态
  985.         /// </summary>
  986.         /// <param name="wfinstanceinfo"></param>
  987.         /// <returns></returns>
  988.         public bool WFActInsUpdata(int actinsid,int userid, int status)
  989.         {
  991.             QueryParameterCollection Params = new QueryParameterCollection();
  992.             Params.Clear();
  993.             Params.Add("@actinsid", actinsid);
  994.             Params.Add("@UserID", userid);
  995.             Params.Add("@status", status);
  998.             string sSQL = "update  tb_WF_ActIns  Set Status=@status,UserID=@UserID  where  ActInsID=@actinsid";
  999.             MSDA.Open();
  1000.             NewObj newobject = new NewObj();
  1001.             bool returnvalue = newobject.Update(sSQL, Params, CommandType.Text);
  1002.             MSDA.Close();
  1003.             return returnvalue;
  1004.           
  1006.         }
  1008.         /// <summary>
  1009.         /// 获到当前活动实例对的活动
  1010.         /// </summary>
  1011.         /// <returns></returns>
  1012.         public DataView GetWFAct(int actinsid)
  1013.         {
  1014.             string sSQL = "select * from  tb_WF_ActIns  where ActInsID=" + actinsid;
  1015.             DataView dv = null;
  1016.             try
  1017.             {
  1018.                 NewObj newobject = new NewObj();
  1019.                 dv = newobject.Search(sSQL, null, CommandType.Text).Tables[0].DefaultView;
  1021.             }
  1022.             catch
  1023.             {
  1024.                 dv = null;
  1025.             }
  1026.             finally
  1027.             {
  1028.                 MSDA.Close();
  1029.             }
  1030.             return dv;
  1033.         }
  1035.         /// <summary>
  1036.         /// 改变当前工作流活动实例状态
  1037.         /// </summary>
  1038.         /// <param name="wfinstanceinfo"></param>
  1039.         /// <returns></returns>
  1040.         public bool WFActInsUpdata(int actinsid, int status)
  1041.         {
  1043.             QueryParameterCollection Params = new QueryParameterCollection();
  1044.             Params.Clear();
  1045.             Params.Add("@actinsid", actinsid);
  1046.             Params.Add("@status", status);
  1049.             string sSQL = "update  tb_WF_ActIns  Set Status=@status where  ActInsID=@actinsid";
  1050.             MSDA.Open();
  1051.             NewObj newobject = new NewObj();
  1052.             bool returnvalue = newobject.Update(sSQL, Params, CommandType.Text);
  1053.             MSDA.Close();
  1054.             return returnvalue;
  1056.         } 
  1058.       /// <summary>
  1059.       /// 根据当前活动id获取当前部门与上级角色 
  1060.       /// </summary>
  1061.       /// <param name="activityid">活动ID</param>
  1062.       /// <returns></returns>
  1063.         public DataView ColonyUserGetByActId(int actid)
  1064.         {
  1065.             //string sSQL = "select a.ActivityID CurrentActID,a.RoleID CurrentRoleID,b.ActivityID ParentActID,b.RoleID ParentRoleID  " +
  1066.             //            "   from tb_Colony_User a,tb_Colony_User  b  where a.ActivityID='" + actid + "'  and a.ActivityID=b.ParentActID";
  1068.             SqlParameter parameter = new SqlParameter("@ActivityID", SqlDbType.Int, 4);
  1069.             parameter.Value = actid;
  1070.             DataView dv = null;
  1071.             try
  1072.             {
  1073.                 MSDA.Open();
  1074.                 dv = SqlHelper.ExecuteDataTable(SqlHelper.connectionString, CommandType.StoredProcedure, "P_WF_Activity_GetByActID", parameter).DefaultView;  
  1075.                 MSDA.Close();
  1076.             }
  1077.             catch
  1078.             {
  1079.                   dv = null;
  1080.             }
  1081.             return dv;
  1083.         }
  1084.         public string GetEmpType(int EmpID)
  1085.         {
  1086.             string strEmpType = "";
  1087.             DataView dv = SqlHelper.ExecuteDataTable(SqlHelper.connectionString, CommandType.Text, "select [EmpType] from [Tb_Sys_Employee] where [EmpID]=" + EmpID, null).DefaultView;
  1088.             if (dv.Count > 0)
  1089.             {
  1090.                 strEmpType = dv[0]["EmpType"].ToString();
  1091.             }
  1092.             return strEmpType;
  1093.         }
  1095.         /// <summary>
  1096.         /// 根据当前活动id获取下级活动 
  1097.         /// </summary>
  1098.         /// <param name="actid">活动ID</param>
  1099.         /// <returns></returns>
  1100.         public DataView ColonyUserGetByAct(int actid)
  1101.         {
  1102.             string sSQL = "select CU2.ActivityID,CU2.ParentActID,CU2.RoleID  from  tb_Colony_User CU1,tb_Colony_User CU2 where CU1.ParentActID=CU2.ActivityID and CU1.ActivityID='" + actid + "' ";
  1103.             DataView dv = null;
  1104.             try
  1105.             {
  1106.                 NewObj newobject = new NewObj();
  1107.                 dv = newobject.Search(sSQL, null, CommandType.Text).Tables[0].DefaultView;
  1108.             }
  1109.             catch
  1110.             {
  1111.                 dv = null;
  1112.             }
  1113.             finally
  1114.             {
  1115.                 MSDA.Close();
  1116.             }
  1117.             return dv;
  1119.         }
  1120.         /// <summary>
  1121.         /// 获取某一工作流的起始活动
  1122.         /// </summary>
  1123.         /// <param name="wfid"></param>
  1124.         /// <returns></returns>
  1125.         public DataView GetActivityByWFID(int wfid)
  1126.         {
  1127.             string sSQL = "select  ActivityID from tb_WF_Activity where StartEnd='0' and WorkFlowID='" + wfid + "' ";
  1129.             DataView dv = null;
  1130.             try
  1131.             {
  1132.                 NewObj newobject = new NewObj();
  1133.                 dv = newobject.Search(sSQL, null, CommandType.Text).Tables[0].DefaultView;
  1134.                
  1135.             }
  1136.             catch
  1137.             {
  1138.                 dv = null;
  1139.             }
  1140.             finally
  1141.             {
  1142.                 MSDA.Close();
  1143.             }
  1144.             return dv;
  1145.         }
  1147.         /// <summary>
  1148.         /// 获取某一角色所应启动的活动
  1149.         /// </summary>
  1150.         /// <param name="wfid"></param>
  1151.         /// <returns></returns>
  1152.        public DataView GetActivityPage(int wfid,int roleid)
  1153.         {
  1154.            // string sSQL = "select *  from tb_WF_Activity  where WorkFlowID='" + wfid +"'  and ActivityID in(select ActivityID from tb_Colony_User  where RoleID='" + roleid +"')";
  1155.             string sSQL = "select *  from tb_WF_Activity a,tb_WF_StaticPage s  where WorkFlowID='" +  wfid + "' and s.StaticPageID=a.PageID and ActivityID" + 
  1156.                          "  in(select ActivityID from tb_Colony_User  where RoleID='" + roleid+"') ";
  1157.             DataView dv = null;
  1158.             try
  1159.             {
  1160.                 MSDA.Open();
  1161.                 NewObj newobject = new NewObj();
  1162.                 dv = newobject.Search(sSQL, null, CommandType.Text).Tables[0].DefaultView;
  1163.                 MSDA.Close();
  1164.             }
  1165.             catch
  1166.             {
  1167.                 dv = null;
  1168.             }
  1169.             return dv;
  1170.         }
  1173.         /// <summary>
  1174.         /// 基层部门提交
  1175.         /// </summary>
  1176.         /// <returns>返回bool类型参数</returns>
  1177.         public bool Project_JC(int projectid,string JcFName, int status)
  1178.         {
  1179.             QueryParameterCollection Params = new QueryParameterCollection();
  1180.             Params.Clear();
  1181.             Params.Add("@projectid", projectid);
  1182.             Params.Add("@JcFName", JcFName);
  1183.             Params.Add("@status", status);
  1185.             string sSQL = "update  tb_Project Set JcFName=@JcFName,Status=@status  where ProjectID=@projectid";
  1186.             MSDA.Open();
  1187.             NewObj newobject = new NewObj();
  1188.             bool returnvalue = newobject.Update(sSQL, Params, CommandType.Text);
  1189.             MSDA.Close();
  1190.             return returnvalue;
  1191.         }
  1193.         /// <summary>
  1194.         /// 主管部门提交
  1195.         /// </summary>
  1196.         /// <returns>返回bool类型参数</returns>
  1197.         public bool Project_Zg(int projectid, string ZgTransactor,
  1198.                      string ZgFName, int status)
  1199.         {
  1200.             QueryParameterCollection Params = new QueryParameterCollection();
  1201.             Params.Clear();
  1202.             Params.Add("@projectid", projectid);
  1203.             Params.Add("@ZgTransactor", ZgTransactor);
  1204.             Params.Add("@ZgFName", ZgFName);
  1205.             Params.Add("@status", status);
  1208.             string sSQL = "update  tb_Project Set ZgTransactor=@ZgTransactor,ZgFName=@ZgFName,Status=@status  where ProjectID=@projectid";
  1209.             MSDA.Open();
  1210.             NewObj newobject = new NewObj();
  1211.             bool returnvalue = newobject.Update(sSQL, Params, CommandType.Text);
  1212.             MSDA.Close();
  1213.             return returnvalue;
  1214.         }
  1216.         /// <summary>
  1217.         /// 计企部项目汇总
  1218.         /// </summary>
  1219.         /// <returns>返回bool类型参数</returns>
  1220.         public bool Project_JqbX(int projectid, string JqbXTransactor,
  1221.                         string JqbXFName, int status)
  1222.         {
  1223.             QueryParameterCollection Params = new QueryParameterCollection();
  1224.             Params.Clear();
  1225.             Params.Add("@projectid", projectid);
  1226.             Params.Add("@JqbXTransactor", JqbXTransactor);
  1227.             Params.Add("@JqbXFName", JqbXFName);
  1228.        
  1229.             Params.Add("@status", status);
  1232.             string sSQL = "update  tb_Project Set JqbXTransactor=@JqbXTransactor,JqbXFName=@JqbXFName,Status=@status where ProjectID=@projectid";
  1233.             MSDA.Open();
  1234.             NewObj newobject = new NewObj();
  1235.             bool returnvalue = newobject.Update(sSQL, Params, CommandType.Text);
  1236.             MSDA.Close();
  1237.             return returnvalue;
  1238.         }
  1240.         /// <summary>
  1241.         /// 职能部门回退
  1242.         /// </summary>
  1243.         /// <returns>返回bool类型参数</returns>
  1244.         public bool Project_FG_Untread(int projectid, string fg_transactoridea, string fg_transactorsignature, int status)
  1245.         {
  1246.             QueryParameterCollection Params = new QueryParameterCollection();
  1247.             Params.Clear();
  1248.             Params.Add("@projectid", projectid);
  1249.            
  1250.             Params.Add("@fg_transactoridea", fg_transactoridea);
  1251.             Params.Add("@fg_transactorsignature", fg_transactorsignature);
  1253.             Params.Add("@status", status);
  1255.             string sSQL = "update  tb_Project Set  Fg_TransactorIdea=@fg_transactoridea,Fg_TransactorSignature=@fg_transactorsignature,Status=@status where ProjectID=@projectid";
  1256.             MSDA.Open();
  1257.             NewObj newobject = new NewObj();
  1258.             bool returnvalue = newobject.Update(sSQL, Params, CommandType.Text);
  1259.             MSDA.Close();
  1260.             return returnvalue;
  1261.         }
  1262.         /// <summary>
  1263.         ///计企部计划清单
  1264.         /// </summary>
  1265.         /// <returns>返回bool类型参数</returns>
  1266.         public bool Project_JqbB(int projectid, string JqbBTransactor, string JqbBFName, int status)
  1267.         {
  1268.             QueryParameterCollection Params = new QueryParameterCollection();
  1269.             Params.Clear();
  1270.             Params.Add("@projectid", projectid);
  1271.             Params.Add("@JqbBTransactor", JqbBTransactor);
  1272.             Params.Add("@JqbBFName", JqbBFName);
  1273.             Params.Add("@status", status);
  1275.             string sSQL = "update  tb_Project Set   JqbBTransactor=@JqbBTransactor,JqbBFName=@JqbBFName,status=@status   where ProjectID=@projectid";
  1276.             MSDA.Open();
  1277.             NewObj newobject = new NewObj();
  1278.             bool returnvalue = newobject.Update(sSQL, Params, CommandType.Text);
  1279.             MSDA.Close();
  1280.             return returnvalue;
  1281.         }
  1283.         /// <summary>
  1284.         ///财务部回退
  1285.         /// </summary>
  1286.         /// <returns>返回bool类型参数</returns>
  1287.         public bool Project_CW_Untread(int projectid, string cw_TransactorSignature, string cw_Idea)
  1288.         {
  1289.             QueryParameterCollection Params = new QueryParameterCollection();
  1290.             Params.Clear();
  1291.             Params.Add("@projectid", projectid);
  1293.             Params.Add("@cw_TransactorSignature", cw_TransactorSignature);
  1294.             Params.Add("@cw_Idea", cw_Idea);
  1296.             string sSQL = "update  tb_Project Set   cw_TransactorSignature=@cw_TransactorSignature,cw_Idea=@cw_Idea where ProjectID=@projectid";
  1297.             MSDA.Open();
  1298.             NewObj newobject = new NewObj();
  1299.             bool returnvalue = newobject.Update(sSQL, Params, CommandType.Text);
  1300.             MSDA.Close();
  1301.             return returnvalue;
  1302.         }
  1303.         /// <summary>
  1304.         /// 分管领导审核
  1305.         /// </summary>
  1306.         /// <returns>返回bool类型参数</returns>
  1307.         public bool Project_Gcgl(int projectid, string GcglHTransactor, string GcglHFName, int status)
  1308.         {
  1309.             QueryParameterCollection Params = new QueryParameterCollection();
  1310.             Params.Clear();
  1311.             Params.Add("@projectid", projectid);
  1313.             Params.Add("@GcglHTransactor", GcglHTransactor);
  1314.             Params.Add("@GcglHFName", GcglHFName);
  1316.             Params.Add("@status", status);
  1319.             string sSQL = "update  tb_Project Set  GcglHTransactor=@GcglHTransactor,GcglHFName=@GcglHFName,Status=@status where ProjectID=@projectid";
  1320.             MSDA.Open();
  1321.             NewObj newobject = new NewObj();
  1322.             bool returnvalue = newobject.Update(sSQL, Params, CommandType.Text);
  1323.             MSDA.Close();
  1324.             return returnvalue;
  1325.         }
  1327.         /// <summary>
  1328.         /// 分管领导回退
  1329.         /// </summary>
  1330.         /// <returns>返回bool类型参数</returns>
  1331.         public bool Project_ZJL_Untread(int projectid, string zjl_transactoridea, string zjl_transactorsignature, int status)
  1332.         {
  1333.             QueryParameterCollection Params = new QueryParameterCollection();
  1334.             Params.Clear();
  1335.             Params.Add("@projectid", projectid);
  1336.            
  1337.             Params.Add("@zjl_transactoridea", zjl_transactoridea);
  1338.             Params.Add("@zjl_transactorsignature", zjl_transactorsignature);
  1340.             Params.Add("@status", status);
  1343.             string sSQL = "update  tb_Project Set Zjl_TransactorIdea=@zjl_transactoridea,Zjl_TransactorSignature=@zjl_transactorsignature,Status=@status where ProjectID=@projectid";
  1344.             MSDA.Open();
  1345.             NewObj newobject = new NewObj();
  1346.             bool returnvalue = newobject.Update(sSQL, Params, CommandType.Text);
  1347.             MSDA.Close();
  1348.             return returnvalue;
  1349.         }
  1350.         /// <summary>
  1351.         ///分管领导审核
  1352.         /// </summary>
  1353.         /// <returns>返回bool类型参数</returns>
  1354.         public bool Project_Fg(int projectid, string FgTransactor, string FgIdea, int status)
  1355.         {
  1356.             QueryParameterCollection Params = new QueryParameterCollection();
  1357.             Params.Clear();
  1358.             Params.Add("@projectid", projectid);
  1360.             Params.Add("@FgTransactor", FgTransactor);
  1361.             Params.Add("@FgIdea", FgIdea);
  1363.             Params.Add("@status", status);
  1364.             string sSQL = "update  tb_Project Set  FgTransactor=@FgTransactor,FgIdea=@FgIdea,status=@status where ProjectID=@projectid";
  1365.             MSDA.Open();
  1366.             NewObj newobject = new NewObj();
  1367.             bool returnvalue = newobject.Update(sSQL, Params, CommandType.Text);
  1368.             MSDA.Close();
  1369.             return returnvalue;
  1370.         }
  1371.         /// <summary>
  1372.         ///工程预算委员会审批
  1373.         /// </summary>
  1374.         /// <returns>返回bool类型参数</returns>
  1375.         public bool Project_Zjwyh(int projectid, string ZjwyhTransactor, string ZjwyhIdea, int status)
  1376.         {
  1377.             QueryParameterCollection Params = new QueryParameterCollection();
  1378.             Params.Clear();
  1379.             Params.Add("@projectid", projectid);
  1380.             Params.Add("@ZjwyhTransactor", ZjwyhTransactor);
  1381.             Params.Add("@ZjwyhIdea", ZjwyhIdea);
  1382.             Params.Add("@status", status);
  1384.             string sSQL = "update  tb_Project Set  ZjwyhTransactor=@ZjwyhTransactor,ZjwyhIdea=@ZjwyhIdea,status=@status where ProjectID=@projectid";
  1385.             MSDA.Open();
  1386.             NewObj newobject = new NewObj();
  1387.             bool returnvalue = newobject.Update(sSQL, Params, CommandType.Text);
  1388.             MSDA.Close();
  1389.             return returnvalue;
  1390.         }
  1393.         /// <summary>
  1394.         ///公司领导回退
  1395.         /// </summary>
  1396.         /// <returns>返回bool类型参数</returns>
  1397.         public bool Project_LD_Untread(int projectid, string Ld_TransactorSignature, string Ld_Idea)
  1398.         {
  1399.             QueryParameterCollection Params = new QueryParameterCollection();
  1400.             Params.Clear();
  1401.             Params.Add("@projectid", projectid);
  1403.             Params.Add("@Ld_TransactorSignature", Ld_TransactorSignature);
  1404.             Params.Add("@Ld_Idea", Ld_Idea);
  1406.             string sSQL = "update  tb_Project Set  Ld_TransactorSignature=@Ld_TransactorSignature,Ld_Idea=@Ld_Idea where ProjectID=@projectid";
  1407.             MSDA.Open();
  1408.             NewObj newobject = new NewObj();
  1409.             bool returnvalue = newobject.Update(sSQL, Params, CommandType.Text);
  1410.             MSDA.Close();
  1411.             return returnvalue;
  1412.         }
  1413.         /// <summary>
  1414.         ///计企部初次审核
  1415.         /// </summary>
  1416.         /// <returns>返回bool类型参数</returns>
  1417.         public bool Project_JQP_GcglX(int projectid, string GcglXTransactor, string GcglXFName, int  status)
  1418.         {
  1419.             QueryParameterCollection Params = new QueryParameterCollection();
  1420.             Params.Clear();
  1421.             Params.Add("@projectid", projectid);
  1423.             Params.Add("@GcglXTransactor", GcglXTransactor);
  1424.             Params.Add("@GcglXFName", GcglXFName);
  1427.             Params.Add("@status", status);
  1429.             string sSQL = "update  tb_Project Set  GcglXTransactor=@GcglXTransactor,GcglXFName=@GcglXFName,status=@status where ProjectID=@projectid";
  1430.             MSDA.Open();
  1431.             NewObj newobject = new NewObj();
  1432.             bool returnvalue = newobject.Update(sSQL, Params, CommandType.Text);
  1433.             MSDA.Close();
  1434.             return returnvalue;
  1435.         }
  1437.         /// <summary>
  1438.         ///计企部回退
  1439.         /// </summary>
  1440.         /// <returns>返回bool类型参数</returns>
  1441.         public bool Project_JQP_Untread(int projectid, string Jqb_TransactorSignature, string Jqb_Idea)
  1442.         {
  1443.             QueryParameterCollection Params = new QueryParameterCollection();
  1444.             Params.Clear();
  1445.             Params.Add("@projectid", projectid);
  1447.             Params.Add("@Jqb_TransactorSignature", Jqb_TransactorSignature);
  1448.             Params.Add("@Jqb_Idea", Jqb_Idea);
  1450.             string sSQL = "update  tb_Project Set  Jqb_TransactorSignature=@Jqb_TransactorSignature,Jqb_Idea=@Jqb_Idea where ProjectID=@projectid";
  1451.             MSDA.Open();
  1452.             NewObj newobject = new NewObj();
  1453.             bool returnvalue = newobject.Update(sSQL, Params, CommandType.Text);
  1454.             MSDA.Close();
  1455.             return returnvalue;
  1456.         }
  1459.         /// <summary>
  1460.         ///公司领导审批
  1461.         /// </summary>
  1462.         /// <returns>返回bool类型参数</returns>
  1463.         public bool Project_Gs(int projectid, string GsTransactor, string GsIdea, int status)
  1464.         {
  1465.             QueryParameterCollection Params = new QueryParameterCollection();
  1466.             Params.Clear();
  1467.             Params.Add("@projectid", projectid);
  1468.             Params.Add("@GsTransactor", GsTransactor);
  1469.             Params.Add("@GsIdea", GsIdea);
  1470.             Params.Add("@status", status);
  1473.             string sSQL = "update  tb_Project Set GsTransactor=@GsTransactor,GsIdea=@GsIdea,Status=@status where ProjectID=@projectid";
  1474.             MSDA.Open();
  1475.             NewObj newobject = new NewObj();
  1476.             bool returnvalue = newobject.Update(sSQL, Params, CommandType.Text);
  1477.             MSDA.Close();
  1478.             return returnvalue;
  1479.         }
  1480.         /// <summary>
  1481.         ///工程办公室领导审批
  1482.         /// </summary>
  1483.         /// <returns>返回bool类型参数</returns>
  1484.         public bool Project_GcglQ(int projectid, string GcglQTransactor, string GcglQIdea, int status)
  1485.         {
  1486.             QueryParameterCollection Params = new QueryParameterCollection();
  1487.             Params.Clear();
  1488.             Params.Add("@projectid", projectid);
  1489.             Params.Add("@GcglQTransactor", GcglQTransactor);
  1490.             Params.Add("@GcglQIdea", GcglQIdea);
  1491.             Params.Add("@status", status);
  1494.             string sSQL = "update  tb_Project Set GcglQTransactor=@GcglQTransactor,GcglQIdea=@GcglQIdea,Status=@status where ProjectID=@projectid";
  1495.             MSDA.Open();
  1496.             NewObj newobject = new NewObj();
  1497.             bool returnvalue = newobject.Update(sSQL, Params, CommandType.Text);
  1498.             MSDA.Close();
  1499.             return returnvalue;
  1500.         }
  1501.         /// <summary>
  1502.         ///计企部正式发文
  1503.         /// </summary>
  1504.         /// <returns>返回bool类型参数</returns>
  1505.         public bool Project_JqbZ(int projectid, string JqbZTransactor, string JqbZFName, int status)
  1506.         {
  1507.             QueryParameterCollection Params = new QueryParameterCollection();
  1508.             Params.Clear();
  1509.             Params.Add("@projectid", projectid);
  1510.             Params.Add("@JqbZTransactor", JqbZTransactor);
  1511.             Params.Add("@JqbZFName", JqbZFName);
  1512.             Params.Add("@status", status);
  1515.             string sSQL = "update  tb_Project Set JqbZTransactor=@JqbZTransactor,JqbZFName=@JqbZFName,Status=@status where ProjectID=@projectid";
  1516.             MSDA.Open();
  1517.             NewObj newobject = new NewObj();
  1518.             bool returnvalue = newobject.Update(sSQL, Params, CommandType.Text);
  1519.             MSDA.Close();
  1520.             return returnvalue;
  1521.         }
  1523.         /// <summary>
  1524.         /// 获取上级活动记录
  1525.         /// </summary>
  1526.         /// <param name="activityid">当前活动事例ID</param>
  1527.         /// <returns></returns>
  1528.         public DataView ActivityGetByActInsId(int ActInsID)
  1529.         {
  1530.             string sSQL = " select AC1.ActivityID PreviousActID,AC1.UserID PreviousUserID,AC1.RoleID  PreviousRoleID,AC1.ActInsID PreviousActInsID from tb_wf_actins AC1 where AC1.ActivityID in( " +
  1531.                   "select ActivityID   from tb_Colony_User where  ParentActID in(" +
  1532.                   "select AC.ActivityID from tb_wf_actins AC where AC.ActInsID='" + ActInsID+ "')) and AC1.WfInstanceID in" +
  1533.                    "(select AC2.WfInstanceID from tb_wf_actins AC2 where AC2.ActInsID='" + ActInsID + "')";
  1534.             DataView dv = null;
  1535.             try
  1536.             {
  1537.                 MSDA.Open();
  1538.                 dv = SqlHelper.ExecuteDataTable(SqlHelper.connectionString, CommandType.Text,sSQL, null).DefaultView;
  1539.                 MSDA.Close();
  1540.             }
  1541.             catch
  1542.             {
  1543.                 dv = null;
  1544.             }
  1545.             return dv;
  1547.         }
  1549.         /// <summary>
  1550.         /// 获取基层部门员工提交申请人业务角色
  1551.         /// </summary>
  1552.         /// <param name="activityid">当前活动ID</param>
  1553.         /// <returns></returns>
  1554.         public DataView ActDeptIDGetByActId(int ActID)
  1555.         {
  1556.             string sSQL = "  select CU1.ActivityID,CU1.RoleID   from tb_Colony_User CU1,tb_Colony_User CU2  " +
  1557.                       " where CU1.ActivityID=CU2.ParentActID and CU2.ActivityID='" + ActID + "' ";
  1558.             DataView dv = null;
  1559.             try
  1560.             {
  1561.                 MSDA.Open();
  1562.                 dv = SqlHelper.ExecuteDataTable(SqlHelper.connectionString, CommandType.Text, sSQL, null).DefaultView;
  1563.                 MSDA.Close();
  1564.             }
  1565.             catch
  1566.             {
  1567.                 dv = null;
  1568.             }
  1569.             return dv;
  1571.         }
  1574.         /// <summary>
  1575.         /// 退回时,改变前一活动状态
  1576.         /// </summary>
  1577.         /// <param name="Status">0、正常；1、完成；2、回退；3、回退并完成；4、作废</param>
  1578.         /// <returns></returns>
  1579.         public bool ActInsStatusChange(int WfInstanceID, int ActivityID, int Status)
  1580.         {
  1581.             QueryParameterCollection Params = new QueryParameterCollection();
  1582.             Params.Clear();
  1583.             Params.Add("@WfInstanceID", WfInstanceID);
  1584.             Params.Add("@ActivityID", ActivityID);
  1585.             Params.Add("@Status", Status);
  1587.             string sSQL = "update tb_WF_ACtIns set Status=@Status  where WfInstanceID=@WfInstanceID and ActivityID=@ActivityID";
  1588.             MSDA.Open();
  1589.             NewObj newobject = new NewObj();
  1590.             bool returnvalue = newobject.Update(sSQL, Params, CommandType.Text);
  1591.             MSDA.Close();
  1592.             return returnvalue;
  1593.         }
  1595.         ///// <summary>
  1596.         ///// 获取物资第一下拉列表
  1597.         ///// </summary>
  1598.         //public SqlDataReader WZGetAll()
  1599.         //{
  1600.         //    string connStr = ConfigurationSettings.AppSettings["SqlConnection2"].ToString();
  1601.         //    SqlConnection conn = new SqlConnection(connStr);
  1602.         //    //  绑定第一级下拉列表
  1603.         //    string commStr1 = string.Format("select wz_code1,wz_namecode1 from wz_code1");
  1604.         //    SqlCommand comm1 = new SqlCommand(commStr1, conn);
  1605.         //    conn.Open();
  1607.         //    //DataView dv = SqlHelper.ExecuteDataTable(SqlHelper.connectionString, CommandType.Text, commStr1, null).DefaultView;
  1608.         
  1609.         //    SqlDataReader dr = comm1.ExecuteReader();
  1610.           
  1611.             
  1612.         //    return dr;
  1613.          
  1614.         //}
  1616.         ///// <summary>
  1617.         ///// 获取物资第一下拉列表
  1618.         ///// </summary>
  1619.         //public SqlDataReader WZGetByCode1(int wz_code1)
  1620.         //{
  1621.         //    string connStr = ConfigurationSettings.AppSettings["SqlConnection2"].ToString();
  1622.         //    string sSQL = "select wz_code1,wz_namecode2 from wz_code2 where wz_code1='" + wz_code1 + "'";
  1623.         //    SqlConnection conn = new SqlConnection(connStr);
  1624.         //    SqlCommand comm1 = new SqlCommand(sSQL, conn);
  1625.         //    conn.Open();
  1626.         //    SqlDataReader dr = comm1.ExecuteReader();
  1628.         //    return dr;
  1629.         //}
  1631.         /// <summary>
  1632.         /// 添加设备费记录
  1633.         /// </summary>
  1634.         /// <returns>返回一bool类型值</returns>
  1635.         public bool ProEquAdd(string UnitName, int wz_id, string EquipmentName, int Number, int ProjectID, decimal Price, string EquipmentSize, string NumberHistory, string PriceHistory)
  1636.         {
  1638.             string sSQL = "insert into tb_Project_Equipment([UnitName],[wz_id],[EquipmentName],[Number],[ProjectID],[Price],[EquipmentSize],[NumberHistory],[PriceHistory]) values  " +
  1639.                 "('" + UnitName + "', '" + wz_id + "','" + EquipmentName + "','" + Number + "','" + ProjectID + "','" + Price + "','" + EquipmentSize + "','" + NumberHistory + "','" + PriceHistory + "')";
  1640.             MSDA.Open();
  1642.             NewObj newobject = new NewObj();
  1643.             bool returnvalue = newobject.insert(sSQL, null, CommandType.Text);
  1645.             MSDA.Close();
  1646.             return returnvalue;
  1647.         }
  1649.         /// <summary>
  1650.         /// 修改设备费记录
  1651.         /// </summary>
  1652.         /// <returns>返回一bool类型值</returns>
  1653.         public bool ProEquUpdata(int EquipmentID,string UnitName, int wz_id, string EquipmentName, int Number, int ProjectID, decimal Price, string EquipmentSize, string NumberHistory, string PriceHistory)
  1654.         {
  1656.             string sSQL = "update  tb_Project_Equipment Set UnitName='" + UnitName + "'," + "wz_id='" + wz_id + "'," + "EquipmentName='" + EquipmentName + "'," + "Number='" + Number + "'," +
  1657.                       "ProjectID='" + ProjectID + "'," + "Price='" + Price + "'," + "EquipmentSize='" + EquipmentSize + "'," + "NumberHistory='" +
  1658.                       NumberHistory + "'," + "PriceHistory='" + PriceHistory + "'   where  EquipmentID='" + EquipmentID + "'";
  1660.             
  1661.             MSDA.Open();
  1663.             NewObj newobject = new NewObj();
  1664.             bool returnvalue = newobject.Update(sSQL, null, CommandType.Text);
  1666.             MSDA.Close();
  1667.             return returnvalue;
  1668.         }
  1670.         /// <summary>
  1671.         /// 获取设备费记录
  1672.         /// </summary>
  1673.         //////public DataView ProEquGetById(int ProjectID)
  1674.         //////{
  1675.         //////    string sSQL = "select * from tb_Project_Equipment  where ProjectID='" + ProjectID + "'";
  1677.         //////    MSDA.Open();
  1678.         //////    NewObj newobject = new NewObj();
  1679.         //////    DataView dv = newobject.Search(sSQL, null, CommandType.Text).Tables[0].DefaultView;
  1681.         //////    MSDA.Close();
  1682.         //////    return dv;
  1683.         //////}
  1685.         /// <summary>
  1686.         /// 删除设备费记录
  1687.         /// </summary>
  1688.         /// <param name="userid">设备ID</param>
  1689.         public bool ProEquDelete(int EquipmentID)
  1690.         {
  1691.             string sSQL = "delete from tb_Project_Equipment where [EquipmentID]=" + EquipmentID;
  1692.             bool bl = false;
  1693.             try
  1694.             {
  1695.                 MSDA.Open();
  1696.                 MSDA.ExecuteNonQuery(CommandType.Text, sSQL, null);
  1697.                 bl = true;
  1698.             }
  1699.             catch (Exception ex)
  1700.             {
  1701.                 throw ex;
  1702.             }
  1703.             finally
  1704.             {
  1705.                 MSDA.Close();
  1706.             }
  1707.             return bl;
  1708.         }
  1710.         /// <summary>
  1711.         /// 添加材料费记录
  1712.         /// </summary>
  1713.         /// <returns>返回一bool类型值</returns>
  1714.         public bool ProMaterialAdd(decimal BudGetPrice, decimal DifferencePrice, decimal DifferencePriceSum, decimal MarketPrice,
  1715.                                       string Memo, string MeterialName, int Number, string UnitName,int  ProjectID)
  1716.         {
  1718.             string sSQL = "insert into tb_Project_Material([BudGetPrice],[DifferencePrice],[DifferencePriceSum],[MarketPrice],[Memo],[MeterialName],[Number],[UnitName],[ProjectID]) values  " +
  1719.                 "('" + BudGetPrice + "', '" + DifferencePrice + "','" + DifferencePriceSum + "','" + MarketPrice + "','" + Memo + "','" + MeterialName + "','" + Number + "','" + UnitName + "','" + ProjectID + "')";
  1720.             MSDA.Open();
  1722.             NewObj newobject = new NewObj();
  1723.             bool returnvalue = newobject.insert(sSQL, null, CommandType.Text);
  1725.             MSDA.Close();
  1726.             return returnvalue;
  1727.         }
  1729.         /// <summary>
  1730.         /// 修改材料费记录
  1731.         /// </summary>
  1732.         /// <returns>返回一bool类型值</returns>
  1733.         public bool ProMaterialUpdata(int MaterialID, decimal BudGetPrice, decimal DifferencePrice, decimal DifferencePriceSum, decimal MarketPrice,
  1734.                                       string Memo, string MeterialName, int Number, string UnitName, int ProjectID)
  1735.         {
  1737.             string sSQL = "update  tb_Project_Material Set BudGetPrice='" + BudGetPrice + "'," + "DifferencePrice='" + DifferencePrice + "'," + "DifferencePriceSum='" + DifferencePriceSum + "'," + "MarketPrice='" + MarketPrice + "'," +
  1738.                       "Memo='" + Memo + "'," + "MeterialName='" + MeterialName + "'," + "Number='" + Number + "'," + "UnitName='" +
  1739.                       UnitName + "'," + "ProjectID='" + ProjectID + "'   where  MaterialID='" + MaterialID + "'";
  1742.             MSDA.Open();
  1744.             NewObj newobject = new NewObj();
  1745.             bool returnvalue = newobject.Update(sSQL, null, CommandType.Text);
  1747.             MSDA.Close();
  1748.             return returnvalue;
  1749.         }
  1751.         /// <summary>
  1752.         /// 删除材料费记录
  1753.         /// </summary>
  1754.         /// <param name="userid">设备ID</param>
  1755.         public bool ProMaterialDelete(int MaterialID)
  1756.         {
  1757.             string sSQL = "delete from tb_Project_Material where [MaterialID]=" + MaterialID;
  1758.             bool bl = false;
  1759.             try
  1760.             {
  1761.                 MSDA.Open();
  1762.                 MSDA.ExecuteNonQuery(CommandType.Text, sSQL, null);
  1763.                 bl = true;
  1765.               }
  1766.             catch (Exception ex)
  1767.             {
  1768.                 throw ex;
  1769.             }
  1770.             finally
  1771.             {
  1772.                 MSDA.Close();
  1773.             }
  1774.             return bl;
  1775.               
  1776.         }
  1779.   
  1780.         /// <summary>
  1781.         /// 材料费记录
  1782.         /// </summary>
  1783.         public DataView ProMaterialGetById(int ProjectID)
  1784.         {
  1785.             string sSQL = "select * from tb_Project_Material  where ProjectID=" + ProjectID;
  1787.             MSDA.Open();
  1788.             NewObj newobject = new NewObj();
  1789.             DataView dv = newobject.Search(sSQL, null, CommandType.Text).Tables[0].DefaultView;
  1791.             MSDA.Close();
  1792.             return dv;
  1793.         }
  1796.         ///// <summary>
  1797.         ///// 获取材料费记录
  1798.         ///// </summary>
  1799.         //public string BudGetPriceGetByWzId(int wzid)
  1800.         //{
  1801.         //    string connStr = ConfigurationSettings.AppSettings["SqlConnection2"].ToString();
  1802.         //    string sSQL = "select * from material_name where wz_id='" + wzid + "'";
  1803.         //    SqlConnection conn = new SqlConnection(connStr);
  1804.         //    SqlCommand comm1 = new SqlCommand(sSQL, conn);
  1805.         //    conn.Open();
  1806.         //    SqlDataReader dr = comm1.ExecuteReader();
  1807.         //    string wz_plan = "";
  1808.         //    while (dr.Read())
  1809.         //    {
  1810.         //        wz_plan=dr["wz_plan"].ToString();
  1812.         //    }
  1813.         //    dr.Close();
  1814.         //    return wz_plan;
  1815.         //}
  1818.         /// <summary>
  1819.         /// 添加其它费用记录
  1820.         /// </summary>
  1821.         /// <returns>返回一bool类型值</returns>
  1822.         public bool ProOtherAdd(string Explain, string OtherName, string Memo, decimal Price, int ProjectID)
  1823.         {
  1824.             string sSQL = "insert into tb_Project_Other([Explain],[OtherName],[Memo],[Price],[ProjectID]) values  " +
  1825.                 "('" + Explain + "', '" + OtherName + "','" + Memo + "','" + Price + "','" + ProjectID + "')";
  1826.             MSDA.Open();
  1828.             NewObj newobject = new NewObj();
  1829.             bool returnvalue = newobject.insert(sSQL, null, CommandType.Text);
  1831.             MSDA.Close();
  1832.             return returnvalue;
  1833.         }
  1835.         /// <summary>
  1836.         /// 修改其它费用记录
  1837.         /// </summary>
  1838.         /// <returns>返回一bool类型值</returns>
  1839.         public bool ProOtherUpdata(int OtherID, string Explain, string OtherName, string Memo, decimal Price, int ProjectID)
  1840.         {
  1842.             string sSQL = "update  tb_Project_Other Set Explain='" + Explain + "'," + "OtherName='" + OtherName + "'," + "Memo='" + Memo + "'," + "Price='" + Price + "'," +
  1843.                       "ProjectID='" + ProjectID + "'   where  OtherID='" + OtherID + "'";
  1846.             MSDA.Open();
  1848.             NewObj newobject = new NewObj();
  1849.             bool returnvalue = newobject.Update(sSQL, null, CommandType.Text);
  1851.             MSDA.Close();
  1852.             return returnvalue;
  1853.         }
  1855.         /// <summary>
  1856.         /// 删除其它费用记录
  1857.         /// </summary>
  1858.         /// <param name="userid">设备ID</param>
  1859.         public void ProOtherDelete(int OtherID)
  1860.         {
  1861.             string sSQL = "delete from tb_Project_Other where [OtherID]='" + OtherID + "'";
  1862.             MSDA.Open();
  1863.             MSDA.ExecuteNonQuery(CommandType.Text, sSQL, null);
  1864.             MSDA.Close();
  1865.         }
  1867.         /// <summary>
  1868.         /// 其它费用记录集合
  1869.         /// </summary>
  1870.         public DataView ProOtherGetAll(int ProjectID)
  1871.         {
  1872.             string sSQL = "select * from tb_Project_Other  where ProjectID='" + ProjectID + "'";
  1874.             MSDA.Open();
  1875.             NewObj newobject = new NewObj();
  1876.             DataView dv = newobject.Search(sSQL, null, CommandType.Text).Tables[0].DefaultView;
  1878.             MSDA.Close();
  1879.             return dv;
  1880.         }
  1882.         /// <summary>
  1883.         /// 其它费用单条记录
  1884.         /// </summary>
  1885.         public DataView ProOtherGetById(int OtherID)
  1886.         {
  1887.             string sSQL = "select * from tb_Project_Other  where OtherID='" + OtherID + "'";
  1889.             MSDA.Open();
  1890.             NewObj newobject = new NewObj();
  1891.             DataView dv = newobject.Search(sSQL, null, CommandType.Text).Tables[0].DefaultView;
  1893.             MSDA.Close();
  1894.             return dv;
  1895.         }
  1896.         /// <summary>
  1897.         /// 查找设备费用
  1898.         /// </summary>
  1899.         /// <param name="projectid">项目ID</param>
  1900.         /// <param name="WZType">查找类型,1:物资代码;2:规格型号</param>
  1901.         /// <param name="searchContent">查找内容</param>
  1902.         /// <returns></returns>
  1903.         public DataView GetWZByConditions(int projectid, string WZType, string searchContent)
  1904.         {
  1905.             string strSqlText = "select * from tb_Project_Equipment  where  ProjectID='" + projectid +"'  " ;
  1907.             switch (WZType)
  1908.             {
  1909.                 case "1":
  1910.                     strSqlText = strSqlText + "  and wz_id  like  '%" + searchContent + "%'";
  1911.                     goto Label_00B9;
  1912.                 case "2":
  1913.                     strSqlText = strSqlText + "   and EquipmentSize  like  '%" + searchContent + "%'";
  1914.                     goto Label_00B9;
  1916.                 }
  1917.            
  1918.            
  1919.         Label_00B9:
  1920.             return SqlHelper.ExecuteDataTable(SqlHelper.connectionString, CommandType.Text, strSqlText, null).DefaultView;
  1921.         }
  1924.         /// <summary>
  1925.         /// 获取当前用户所在部门OrgcID记录
  1926.         /// </summary>
  1927.         /// <param name="OrgID"></param>
  1928.         /// <returns></returns>
  1929.         public string GetOrgcID(int UserID)
  1930.         {
  1931.             SqlParameter parameter = new SqlParameter("@UserID", SqlDbType.Int, 4);
  1932.             parameter.Value = UserID;
  1933.             string str = "";
  1934.             try
  1935.             {
  1936.                 DataView dv = null;
  1937.                 dv = SqlHelper.ExecuteDataTable(SqlHelper.connectionString, CommandType.StoredProcedure, "P_WF_GetOrgcID", parameter).DefaultView;
  1938.                 str = dv[0]["OrgcID"].ToString();
  1939.             }
  1940.             catch
  1941.             {
  1942.                 str = "";
  1943.             }
  1944.             finally
  1945.             {
  1946.                 MSDA.Close();
  1947.             }
  1948.             return str;
  1950.         }
  1952.         /// <summary>
  1953.         /// 工作流任务完成
  1954.         /// </summary>
  1955.         /// <returns>返回一bool类型值</returns>
  1956.         public bool WF_End(string EndDesc, string EndName, int EndX, int EndY, int WorkFlowID, int STATUS, int PrjID)
  1957.         {
  1959.             string sSQL = "insert into tb_WF_End([EndDesc],[EndName],[EndX],[EndY],[WorkFlowID],[STATUS],[PrjID]) values  " +
  1960.                 "('" + EndDesc + "', '" + EndName + "','" + EndX + "','" + EndY + "','" + WorkFlowID + "','" + STATUS + "','" + PrjID + "')";
  1961.             bool returnvalue=false;
  1962.             try
  1963.             {
  1964.                 MSDA.Open();
  1965.                 NewObj newobject = new NewObj();
  1966.                 returnvalue = newobject.insert(sSQL, null, CommandType.Text);
  1967.             }
  1968.             catch
  1969.             {
  1970.                 returnvalue = false;
  1971.             }
  1972.             finally 
  1973.             { 
  1974.               MSDA.Close();
  1975.             }
  1976.            
  1977.             return returnvalue;
  1979.         }
  1980.        /// <summary>
  1981.        /// 获取某一普通员工的业务主管
  1982.        /// </summary>
  1983.        /// <returns></returns>
  1984.         public DataView GetParentEmp(int EmpID)
  1985.         {
  1986.            // string sSQL = "select * from Tb_Sys_Employee where  EmpID=" + EmpID; 
  1987.             string sSQL = "select * from tb_Sys_User where EmpID in (select ParentEmp from Tb_Sys_Employee where  EmpID=" + EmpID +")";
  1989.             DataView dv = null;
  1990.              MSDA.Open();
  1991.             try
  1992.             {
  1993.                 NewObj newobject = new NewObj();
  1994.                 dv = newobject.Search(sSQL, null, CommandType.Text).Tables[0].DefaultView;
  1995.             }
  1996.             catch (Exception ex)
  1997.             {
  1998.                 dv = null;
  1999.                 throw ex;
  2000.             }
  2001.             finally
  2002.             {
  2003.                 MSDA.Close(); 
  2004.             }
  2005.             return dv;
  2006.         }
  2007.         /// <summary>
  2008.         ///判断某一员工是否是业务主管
  2009.         /// </summary>
  2010.         /// <returns>返回bool类型</returns>
  2011.         public bool ParentEmp(int UserID)
  2012.         {
  2013.             string sSQL = "select * from tb_sys_Employee  where ParentEmp=(select EmpID from tb_sys_user where userid=" + UserID + ")";
  2015.             DataView dv = null;
  2016.             MSDA.Open();
  2017.             try
  2018.             {
  2019.                 NewObj newobject = new NewObj();
  2020.                 dv = newobject.Search(sSQL, null, CommandType.Text).Tables[0].DefaultView;
  2021.                 if (dv.Count == 0)
  2022.                     dv = null;
  2023.             }
  2024.             catch (Exception ex)
  2025.             {
  2026.                 dv = null;
  2027.                 throw ex;
  2028.             }
  2029.             finally
  2030.             {
  2031.                 MSDA.Close();
  2032.             }
  2033.             if (dv != null)
  2034.                 return true;
  2035.             else
  2036.                 return false;
  2037.            
  2038.         }
  2040.         /// <summary>
  2041.         /// 获取领导名单
  2042.         /// </summary>
  2043.         /// <returns></returns>
  2044.         public DataView GetEmpLD(int OpID)
  2045.         {
  2046.             //string sSQL = "select  UserID,EmpID from tb_Sys_User where  EmpID in (select EmpID from tb_Sys_EmpOpRole where OpID=7)";
  2047.             string sSQL = "select UserID,EmpName from tb_Sys_User U,Tb_Sys_Employee E where  U.EmpID in (select EmpID from tb_Sys_EmpOpRole where OpID=" + OpID + ")  and U.EmpID=E.EmpID";
  2048.             DataView dv = null;
  2049.             MSDA.Open();
  2050.             try
  2051.             {
  2052.                 NewObj newobject = new NewObj();
  2053.                 dv = newobject.Search(sSQL, null, CommandType.Text).Tables[0].DefaultView;
  2054.             }
  2055.             catch (Exception ex)
  2056.             {
  2057.                 dv = null;
  2058.                 throw ex;
  2059.             }
  2060.             finally
  2061.             {
  2062.                 MSDA.Close();
  2063.             }
  2064.             return dv;
  2065.         }
  2067.         public DataTable GetWFPerissionList()
  2068.         {
  2069.            string strSqlText= "select p.[PermID],p.[DisplayName],p.[DefaultPage] from Tb_Sys_Permission p where ParentresCode='2'";
  2070.             return SqlHelper.ExecuteDataTable(SqlHelper.connectionString, CommandType.Text, strSqlText, null);
  2071.         }
  2073.         /// <summary>
  2074.         ///返回某活动实例状态
  2075.         /// </summary>
  2076.         /// <returns></returns>
  2077.         public DataView GetActInsStatus(int actinsid)
  2078.         {
  2079.             string sSQL = "select * from tb_wf_actins  where ActInsID=" + actinsid;
  2080.             DataView dv = null;
  2081.             MSDA.Open();
  2082.             try
  2083.             {
  2084.                 NewObj newobject = new NewObj();
  2085.                 dv = newobject.Search(sSQL, null, CommandType.Text).Tables[0].DefaultView;
  2086.             }
  2087.             catch (Exception ex)
  2088.             {
  2089.                 dv = null;
  2090.                 throw ex;
  2091.             }
  2092.             finally
  2093.             {
  2094.                 MSDA.Close();
  2095.             }
  2096.             return dv;
  2097.         }
  2098.         /// <summary>
  2099.         ///返回某活动状态
  2100.         /// </summary>
  2101.         /// <returns></returns>
  2102.         public DataView GetActMustChooseItem(int actid)
  2103.         {
  2104.             string sSQL = "select * from tb_WF_Activity AC,tb_WF_StaticPage SP where AC.PageID=SP.StaticPageID and ActivityID=" + actid;
  2105.             DataView dv = null;
  2106.             MSDA.Open();
  2107.             try
  2108.             {
  2109.                 NewObj newobject = new NewObj();
  2110.                 dv = newobject.Search(sSQL, null, CommandType.Text).Tables[0].DefaultView;
  2111.             }
  2112.             catch (Exception ex)
  2113.             {
  2114.                 dv = null;
  2115.                 throw ex;
  2116.             }
  2117.             finally
  2118.             {
  2119.                 MSDA.Close();
  2120.             }
  2121.             return dv;
  2122.         }
  2124.         /// <summary>
  2125.         ///清除未提交申请
  2126.         /// </summary>
  2127.         /// <param name="ActivityID">起始活动</param>
  2128.         public void ProInit(int ActivityID)
  2129.         {
  2130.             string strSQL = "select ActInsID,CreateDate,WFInstanceID from  tb_WF_ActIns  where  ActivityID=" + ActivityID + " and Status=0";
  2131.             MSDA.Open();
  2132.             SqlTransaction tran = MSDA.BeginTransaction();
  2133.             try
  2134.             {
  2135.                 NewObj newobject = new NewObj();
  2136.                 DataView dv = null;
  2137.                 dv= newobject.Search(strSQL, null, CommandType.Text).Tables[0].DefaultView;
  2138.                 for (int i = 0; i < dv.Count; i++)
  2139.                 {
  2140.                     DateTime CreateDate = DateTime.Parse(dv[i]["CreateDate"].ToString().Trim());
  2141.                     TimeSpan ts = DateTime.Parse(DateTime.Now.ToShortDateString()) - CreateDate;
  2142.                     if ( ts.Days>= 7)
  2143.                     {
  2144.                         int WFInstanceID = Convert.ToInt16(dv[i]["WFInstanceID"].ToString().Trim());
  2145.                        
  2146.                         string strSQLIns = "select * from tb_WF_Instance  where  WFInstanceID=" + WFInstanceID;
  2147.                         DataView dvInstance = null;
  2148.                         dvInstance = newobject.Search(strSQLIns, null, CommandType.Text).Tables[0].DefaultView;
  2149.                         if (dvInstance.Count == 0)
  2150.                             continue;
  2151.                         int PrjID=Convert.ToInt16(dvInstance[0]["PrjID"].ToString().Trim());
  2152.                        //删除项目记录
  2153.                         string strSQLProject = "delete from tb_Project  where ProjectID=" + PrjID;
  2154.                         MSDA.ExecuteNonQuery(CommandType.Text, strSQLProject, null);
  2155.                        //删除设备费用记录
  2156.                         string strSQLPrjEquipment = "delete from tb_Project_Equipment where ProjectID=" + PrjID;
  2157.                         MSDA.ExecuteNonQuery(CommandType.Text, strSQLPrjEquipment, null);
  2158.                        //删除材料费用记录
  2159.                         string strSQLPrjMaterialt = "delete  from tb_Project_Material where ProjectID=" + PrjID;
  2160.                         MSDA.ExecuteNonQuery(CommandType.Text, strSQLPrjMaterialt, null);
  2161.                        //删除其它费用记录
  2162.                         string strSQLPrjOther = "delete from tb_Project_Other where ProjectID=" + PrjID;
  2163.                         MSDA.ExecuteNonQuery(CommandType.Text, strSQLPrjOther, null);
  2164.                         //删除工作流实例
  2165.                         string strSQLInstance = "delete from tb_WF_Instance  where  WFInstanceID=" + WFInstanceID;
  2166.                         MSDA.ExecuteNonQuery(CommandType.Text, strSQLInstance, null);
  2167.                         //删除活动实例
  2168.                         int ActInsID = Convert.ToInt16(dv[i]["ActInsID"].ToString().Trim());
  2169.                         string strSQLActIns = "delete  from  tb_WF_ActIns  where  ActInsID=" + ActInsID;
  2170.                         MSDA.ExecuteNonQuery(CommandType.Text, strSQLActIns, null);
  2171.                     }
  2172.                  }
  2173.               
  2174.               
  2175.                 tran.Commit();
  2176.             }
  2177.             catch (Exception ex)
  2178.             {
  2179.                 tran.Rollback();
  2180.                 throw ex;
  2181.             }
  2182.             finally
  2183.             {
  2184.                 MSDA.Close();
  2185.             }
  2186.         }
  2187.         /// <summary>
  2188.         ///返回项目分类情况
  2189.         /// </summary>
  2190.         /// <returns></returns>
  2191.         public DataView GetPrjSerial()
  2192.         {
  2193.             string sSQL = "select P.ProjectSort SerialName, count(*) num,sum(ChargeSum) ChargeSum  from tb_Project P,tb_Project_Serial PS  where  P.ProjectSort=PS.SerialName   group by  P.ProjectSort ";
  2194.             DataView dv = null;
  2195.             MSDA.Open();
  2196.             try
  2197.             {
  2198.                 NewObj newobject = new NewObj();
  2199.                 dv = newobject.Search(sSQL, null, CommandType.Text).Tables[0].DefaultView;
  2200.             }
  2201.             catch (Exception ex)
  2202.             {
  2203.                 dv = null;
  2204.                 throw ex;
  2205.             }
  2206.             finally
  2207.             {
  2208.                 MSDA.Close();
  2209.             }
  2210.             return dv;
  2211.         }
  2214.         /// <summary>
  2215.         ///返回工程项目预算表（电子文档）
  2216.         /// </summary>
  2217.         /// <returns></returns>
  2218.         public DataView GetSFileName(int activityid)
  2219.         {
  2220.             string sSQL = "select * from  tb_Colony_FileName  where ActivityID=" + activityid;
  2221.             DataView dv = null;
  2222.             MSDA.Open();
  2223.             try
  2224.             {
  2225.                 NewObj newobject = new NewObj();
  2226.                 dv = newobject.Search(sSQL, null, CommandType.Text).Tables[0].DefaultView;
  2227.             }
  2228.             catch (Exception ex)
  2229.             {
  2230.                 dv = null;
  2231.                 throw ex;
  2232.             }
  2233.             finally
  2234.             {
  2235.                 MSDA.Close();
  2236.             }
  2237.             return dv;
  2238.         }
  2240.         /// <summary>
  2241.         /// 回退时,更改项目状态
  2242.         /// </summary>
  2243.         /// <returns>返回bool类型参数</returns>
  2244.         public bool Project_Untread(int projectid,int status)
  2245.         {
  2246.             QueryParameterCollection Params = new QueryParameterCollection();
  2247.             Params.Clear();
  2248.             Params.Add("@projectid", projectid);
  2250.             Params.Add("@status", status);
  2252.             string sSQL = "update  tb_Project Set Status=@status where ProjectID=@projectid";
  2253.             MSDA.Open();
  2254.             NewObj newobject = new NewObj();
  2255.             bool returnvalue = newobject.Update(sSQL, Params, CommandType.Text);
  2256.             MSDA.Close();
  2257.             return returnvalue;
  2258.         }
  2260.         ///// <summary>
  2261.         /////判断是否有同名项目
  2262.         ///// </summary>
  2263.         ///// <returns>返回bool类型值</returns>
  2264.         //public bool IfSnPrjName(string PrjName)
  2265.         //{
  2266.         //    string sSQL = "select * from tb_Project where ProjectName='" + PrjName + "'";
  2267.         //    DataView dv = null;
  2268.         //    bool re=true;
  2269.         //    MSDA.Open();
  2270.         //    try
  2271.         //    {
  2272.         //        NewObj newobject = new NewObj();
  2273.         //        dv = newobject.Search(sSQL, null, CommandType.Text).Tables[0].DefaultView;
  2274.         //        if (dv != null)
  2275.         //            re = true;
  2276.         //        else
  2277.         //            re = false;
  2278.         //    }
  2279.         //    catch (Exception ex)
  2280.         //    {
  2281.         //        re = true;
  2282.         //        throw ex;
  2283.         //    }
  2284.         //    finally
  2285.         //    {
  2286.         //        MSDA.Close();
  2287.         //    }
  2288.         //    return re;
  2289.         //}
  2291.         //项目查询根据状态和类型
  2292.         public DataView PrjQueryZ(int  PrjSort,int Status)
  2293.         {
  2294.             DataView dv = new DataView();
  2295.             string strSQL;
  2296.             MSSqlDataAccess MSDA = new MSSqlDataAccess(0);
  2297.             if (PrjSort < -1 || PrjSort == 0)
  2298.             {
  2299.                 PrjSort = -212;              //没有数据
  2300.             }
  2301.             if (Status < -1)
  2302.             {
  2303.                 Status = -212;            //没有数据
  2304.             }
  2305.             strSQL = "select * from tb_Project";
  2306.             if (PrjSort != -1)
  2307.                 strSQL = strSQL + " where PrjSort=" + PrjSort;
  2308.             if (Status != -1)
  2309.             {
  2310.                 if (PrjSort != -1)
  2311.                     strSQL = strSQL + " and Status=" + Status;
  2312.                 else
  2313.                     strSQL = strSQL + " where Status=" + Status;
  2314.             }
  2315.             try
  2316.             {
  2317.                 MSDA.Open();
  2318.                 dv = MSDA.ExecuteDataView(CommandType.Text, strSQL, null);
  2319.             }
  2320.             catch (Exception ex)
  2321.             {
  2322.                 throw ex;
  2323.             }
  2324.             finally
  2325.             {
  2326.                 MSDA.Close();
  2327.             }
  2328.             return dv;
  2329.         }
  2330.        
  2331.         /// <summary>
  2332.         /// 起始活动.
  2333.         /// </summary>
  2334.         /// <returns></returns>
  2335.         public static  int ActivityIDGetByWFID(int WfId)
  2336.         {
  2337.             EtongZwf etongzwf = new EtongZwf();
  2338.             DataView dvActivity = etongzwf.GetActivityByWFID(WfId);
  2339.             if (dvActivity.Count != 0)
  2340.             {
  2341.                 int activity = Convert.ToInt32(dvActivity[0][0].ToString().Trim());
  2342.                 return activity;
  2343.             }
  2344.             else
  2345.                 return 0;
  2346.         }
  2347.         /// <summary>
  2348.         /// 用最新日期生成最新文档
  2349.         /// </summary>
  2350.         /// <param name="filename"></param>
  2351.         /// <returns></returns>
  2352.         public static string MakeNewFileNameWithDate(string filename)
  2353.         {
  2354.             if (filename.Length > 0)
  2355.             {
  2356.                 string[] a = filename.Split('.');
  2357.                 return a[0] + DateTime.Now.Year + DateTime.Now.Month + DateTime.Now.Day + DateTime.Now.Hour + DateTime.Now.Minute + DateTime.Now.Second + "." + a[1];
  2358.             }
  2359.             else
  2360.                 return "";
  2361.         }
  2362.         /// <summary>
  2363.         /// 得到指定活动的文档名称
  2364.         /// </summary>
  2365.         /// <param name="activityid"></param>
  2366.         /// <returns></returns>
  2367.         public static ArrayList GetDocumentFileName(int activityid)
  2368.         {
  2369.           //  string sql = "select [SFileName] from [tb_Colony_FileName] where [ActivityID]=" + activityid;
  2370.             string sql = "select * from [tb_Sys_FileName]  where [FID]  in (select FID  from  tb_Colony_FileName1 where ActivityID=" +activityid +")";
  2371.            // string tempfilename = "";
  2372.             DataView dv = SqlServer.GetDataView(sql);
  2373.             ArrayList al = new ArrayList();
  2374.             if (dv != null && dv.Count > 0)
  2375.             {
  2376.                 for (int i = 0; i < dv.Count; i++)
  2377.                 {
  2378.                     string filename = dv[i]["FName"].ToString();
  2379.                     if (filename.Length >= 5)
  2380.                     {
  2381.                        // tempfilename = filename.Substring(filename.LastIndexOf("\\") + 2);
  2382.                         al.Add(filename);
  2383.                     }
  2384.                 }
  2385.             }
  2386.             return al;
  2387.         }
  2388.         /// <summary>
  2389.         /// 获取当前活动状态
  2390.         /// </summary>
  2391.         /// <param name="ActID"></param>
  2392.         /// <returns></returns>
  2393.         public static string GetStatus(int ActID)
  2394.         {
  2395.             EtongZwf etongzwf = new EtongZwf();
  2396.             try
  2397.             {
  2398.                 DataView dvAct = etongzwf.GetWFAct(ActID);
  2399.                 string Status = dvAct[0]["Status"].ToString().Trim();
  2400.                 return Status;
  2401.             }
  2402.             catch
  2403.             { return ""; }
  2404.         }
  2405.         /// <summary>
  2406.         /// 获取 工程变更和调整 项目
  2407.         /// </summary>
  2408.         /// <param name="wfid"></param>
  2409.         /// <returns></returns>
  2410.         public DataView GetPrjAlert(int wfinstanceid)
  2411.         {
  2412.             //string sSQL = "select C.ConName,P.* from tb_construct C,tb_PrjAlert P where C.ConID  " +
  2413.             //        "in(select PrjID from tb_WF_Instance where WFInstanceID=" + wfinstanceid + ") and C.ConID=P.ConID";
  2414.             string sSQL = "select  * from tb_PrjAlert  where AlertID  in(select PrjID from tb_WF_Instance where WFInstanceID=" + wfinstanceid + ")";
  2415.             DataView dv = null;
  2416.             try
  2417.             {
  2418.                 MSDA.Open();
  2419.                 NewObj newobject = new NewObj();
  2420.                 dv = newobject.Search(sSQL, null, CommandType.Text).Tables[0].DefaultView;
  2421.                 MSDA.Close();
  2422.             }
  2423.             catch
  2424.             {
  2425.                 dv = null;
  2426.             }
  2427.             return dv;
  2428.         }
  2429.         /// <summary>
  2430.         /// 获取 工程计划项目
  2431.         /// </summary>
  2432.         /// <param name="wfid"></param>
  2433.         /// <returns></returns>
  2434.         public DataView GetProject(int wfinstanceid)
  2435.         {
  2436.             string sSQL = "select  * from tb_Project  where PrjSort  in(select PrjID from tb_WF_Instance where WFInstanceID=" + wfinstanceid  + ")";
  2437.             DataView dv = null;
  2438.             try
  2439.             {
  2440.                 MSDA.Open();
  2441.                 NewObj newobject = new NewObj();
  2442.                 dv = newobject.Search(sSQL, null, CommandType.Text).Tables[0].DefaultView;
  2443.                 MSDA.Close();
  2444.             }
  2445.             catch
  2446.             {
  2447.                 dv = null;
  2448.             }
  2449.             return dv;
  2450.         }
  2451.         /// <summary>
  2452.         ///工程变更和调整 基层部门
  2453.         /// </summary>
  2454.         /// <returns>返回bool类型参数</returns>
  2455.         public bool PrjAlert_JC(int AlertID, string JcTransactor, string JcFName, int status)
  2456.         {
  2457.             QueryParameterCollection Params = new QueryParameterCollection();
  2458.             Params.Clear();
  2459.             Params.Add("@AlertID", AlertID);
  2460.             Params.Add("@JcTransactor", JcTransactor);
  2461.             Params.Add("@JcFName", JcFName);
  2462.             Params.Add("@status", status);
  2465.             string sSQL = "update  tb_PrjAlert Set JcTransactor=@JcTransactor,JcFName=@JcFName,Status=@status where AlertID=@AlertID";
  2466.             MSDA.Open();
  2467.             NewObj newobject = new NewObj();
  2468.             bool returnvalue = newobject.Update(sSQL, Params, CommandType.Text);
  2469.             MSDA.Close();
  2470.             return returnvalue;
  2471.         }
  2472.         /// <summary>
  2473.         ///工程变更和调整 主管部门
  2474.         /// </summary>
  2475.         /// <returns>返回bool类型参数</returns>
  2476.         public bool PrjAlert_Zg(int AlertID, string ZgTransactor, string ZgFName, int status)
  2477.         {
  2478.             QueryParameterCollection Params = new QueryParameterCollection();
  2479.             Params.Clear();
  2480.             Params.Add("@AlertID", AlertID);
  2481.             Params.Add("@ZgTransactor", ZgTransactor);
  2482.             Params.Add("@ZgFName", ZgFName);
  2483.             Params.Add("@status", status);
  2486.             string sSQL = "update  tb_PrjAlert Set ZgTransactor=@ZgTransactor,ZgFName=@ZgFName,Status=@status where AlertID=@AlertID";
  2487.             MSDA.Open();
  2488.             NewObj newobject = new NewObj();
  2489.             bool returnvalue = newobject.Update(sSQL, Params, CommandType.Text);
  2490.             MSDA.Close();
  2491.             return returnvalue;
  2492.         }
  2493.         /// <summary>
  2494.         ///工程变更和调整 工程管理办公室
  2495.         /// </summary>
  2496.         /// <returns>返回bool类型参数</returns>
  2497.         public bool PrjAlert_Gcgl(int AlertID, string GcglTransactor, string GcglIdea, int status)
  2498.         {
  2499.             QueryParameterCollection Params = new QueryParameterCollection();
  2500.             Params.Clear();
  2501.             Params.Add("@AlertID", AlertID);
  2502.             Params.Add("@GcglTransactor", GcglTransactor);
  2503.             Params.Add("@GcglIdea", GcglIdea);
  2504.             Params.Add("@status", status);
  2507.             string sSQL = "update  tb_PrjAlert Set GcglTransactor=@GcglTransactor,GcglIdea=@GcglIdea,Status=@status where AlertID=@AlertID";
  2508.             MSDA.Open();
  2509.             NewObj newobject = new NewObj();
  2510.             bool returnvalue = newobject.Update(sSQL, Params, CommandType.Text);
  2511.             MSDA.Close();
  2512.             return returnvalue;
  2513.         }
  2514.         /// <summary>
  2515.         ///工程变更和调整 分管领导审批
  2516.         /// </summary>
  2517.         /// <returns>返回bool类型参数</returns>
  2518.         public bool PrjAlert_Fg(int AlertID, string FgTransactor, string FgIdea, int status)
  2519.         {
  2520.             QueryParameterCollection Params = new QueryParameterCollection();
  2521.             Params.Clear();
  2522.             Params.Add("@AlertID", AlertID);
  2523.             Params.Add("@FgTransactor", FgTransactor);
  2524.             Params.Add("@FgIdea", FgIdea);
  2525.             Params.Add("@status", status);
  2528.             string sSQL = "update  tb_PrjAlert Set FgTransactor=@FgTransactor,FgIdea=@FgIdea,Status=@status where AlertID=@AlertID";
  2529.             MSDA.Open();
  2530.             NewObj newobject = new NewObj();
  2531.             bool returnvalue = newobject.Update(sSQL, Params, CommandType.Text);
  2532.             MSDA.Close();
  2533.             return returnvalue;
  2534.         }
  2536.         /// <summary>
  2537.         /// 获取项目施工流程ID
  2538.         /// </summary>
  2539.         /// <param name="OrgID"></param>
  2540.         /// <returns></returns>
  2541.         public int  GetConWfID()
  2542.         {
  2543.             string sql = " select  WFID from  tb_WorkFlowRouter  where RouID=4";
  2544.             int wfid = -1;
  2545.             DataView dv = SqlServer.GetDataView(sql);
  2546.             if (dv != null && dv.Count > 0)
  2547.             {
  2548.                 wfid = Convert.ToInt16(dv[0]["WFID"].ToString().Trim());
  2550.             }
  2551.             return wfid;
  2552.         }
  2553.         /// <summary>
  2554.         /// 变更项目查询
  2555.         /// </summary>
  2556.         /// <returns>返回DataView类型</returns>
  2557.         public DataView StatusSearchPrjAlert()
  2558.         {
  2559.             DataView dv=null;
  2560.             try
  2561.             {
  2562.                 MSDA.Open();
  2563.                 DataSet ds = SqlHelper.ExecuteDataSet(SqlHelper.connectionString, CommandType.StoredProcedure, "P_GetStatusPrjAlert", null);
  2564.                 dv = ds.Tables[0].DefaultView;
  2565.             }
  2566.             catch
  2567.             {
  2568.                  dv=null;
  2569.             }
  2570.             finally
  2571.             {
  2572.                MSDA.Close();
  2573.             }
  2574.         
  2575.             return dv;
  2576.         }
  2577.         /// <summary>
  2578.         /// 查询PrjAlert
  2579.         /// </summary>
  2580.         /// <returns>返回一dataset类型值</returns>
  2581.         public DataView AllStatusSearchPrjAlert(int AlertID)
  2582.         {
  2583.             DataView dv = null;
  2584.             try
  2585.             {
  2586.                 MSDA.Open();
  2587.                 SqlParameter paramter = new SqlParameter("@PrjID", SqlDbType.Int, 4);
  2588.                 paramter.Value = AlertID;
  2589.                 DataSet ds = SqlHelper.ExecuteDataSet(SqlHelper.connectionString, CommandType.StoredProcedure, "P_GetAllStatusPrjAlert", paramter);
  2590.                 dv = ds.Tables[0].DefaultView;
  2591.             }
  2592.             catch
  2593.             {
  2594.                 dv = null;
  2595.             }
  2596.             finally
  2597.             {
  2598.                 MSDA.Close();
  2599.             }
  2601.             return dv;
  2602.         }
  2603.         public DataView AllStatusSearch(int PrjID)
  2604.         {
  2605.             DataView dv = null;
  2606.             try
  2607.             {
  2608.                 MSDA.Open();
  2609.                 SqlParameter paramter = new SqlParameter("@PrjID", SqlDbType.Int, 4);
  2610.                 paramter.Value = PrjID;
  2611.                 DataSet ds = SqlHelper.ExecuteDataSet(SqlHelper.connectionString, CommandType.StoredProcedure, "P_GetAllStatus",paramter);
  2612.                 dv = ds.Tables[0].DefaultView;
  2613.             }
  2614.             catch
  2615.             {
  2616.                 dv = null;
  2617.             }
  2618.             finally
  2619.             {
  2620.                 MSDA.Close();
  2621.             }
  2623.             return dv;
  2624.         }
  2625.         /// <summary>
  2626.         /// 获取指定流程的启始活动
  2627.         /// </summary>
  2628.         /// <param name="RouID">1:变更材料 4:施工工作流</param>
  2629.         /// <returns></returns>
  2630.         public DataView ActivityColony_User(int RouID)
  2631.         {
  2632.             string sSQL = "select * from tb_Colony_User where ActivityID in(select ActivityID from  tb_WF_Activity  where   "
  2633.             + "WorkFlowID in(select  WFID from  tb_WorkFlowRouter  where RouID=" + RouID + ")  and   StartEnd=0) ";
  2634.             DataView dv = null;
  2635.             try
  2636.             {
  2637.                 MSDA.Open();
  2638.                 dv = SqlHelper.ExecuteDataTable(SqlHelper.connectionString, CommandType.Text, sSQL, null).DefaultView;
  2639.                 MSDA.Close();
  2640.             }
  2641.             catch
  2642.             {
  2643.                 dv = null;
  2644.             }
  2645.             return dv;
  2647.         }
  2648.         /// <summary>
  2649.         /// 获取指定活动所属类型
  2650.         /// </summary>
  2651.         /// <param name="RouID">1: 4:施工工作流</param>
  2652.         /// <returns></returns>
  2653.         public DataView ActInsSort(int actinsid)
  2654.         {
  2655.             string sSQL = "select * from  tb_WF_ActIns where ActInsID=" + actinsid;
  2656.             DataView dv = null;
  2657.             try
  2658.             {
  2659.                 MSDA.Open();
  2660.                 dv = SqlHelper.ExecuteDataTable(SqlHelper.connectionString, CommandType.Text, sSQL, null).DefaultView;
  2661.                 MSDA.Close();
  2662.             }
  2663.             catch
  2664.             {
  2665.                 dv = null;
  2666.             }
  2667.             return dv;
  2669.         }
  2670.         /// <summary>
  2671.         /// 操作电子文档权限
  2672.         /// </summary>
  2673.         /// <param name="EmpID">员工ID</param>
  2674.         /// <returns></returns>
  2675.         public static ArrayList GetSFileNamePerm(int EmpID)
  2676.         {
  2677.             string sSQL = "select * from  tb_Sys_FileName where FID in(select FID from  tb_WF_RoleFName where OpID "
  2678.                         + " in(select OpID from   Tb_Sys_EmpOpRole where EmpID= " + EmpID + "))";
  2679.             DataView dv = SqlServer.GetDataView(sSQL);
  2680.             ArrayList al = new ArrayList();
  2681.             if (dv != null && dv.Count > 0)
  2682.             {
  2683.                 for (int i = 0; i < dv.Count; i++)
  2684.                 {
  2685.                     string FileId = dv[i]["FName"].ToString();
  2686.                     al.Add(FileId);
  2687.                 }
  2688.             }
  2689.             return al;
  2690.         }
  2691.         /// <summary>
  2692.         /// 获取某业务角色对应的类型
  2693.         /// </summary>
  2694.         /// <param name="opid">业务角色ID</param>
  2695.         /// <returns></returns>
  2696.         public static string  GetOpRole(int opid)
  2697.         {
  2698.             string str = "";
  2699.             string sSQL = "select * from   Tb_Sys_OpRole Where OpID=" + opid;
  2700.             try
  2701.             {
  2702.                 DataView dv = SqlServer.GetDataView(sSQL);
  2703.                 if (dv != null && dv.Count > 0)
  2704.                 {
  2705.                     str = dv[0]["OrgDesc"].ToString();
  2706.                 }
  2707.             }
  2708.             catch
  2709.             {
  2710.                 str = "";
  2711.             }
  2712.             return str;
  2714.         }
  2715.         /// <summary>
  2716.         /// 写数据到XML文件中
  2717.         /// </summary>
  2718.         /// <param name="XMLFileName">要打开的XML文件</param>
  2719.         /// <param name="DocFileName">写入DOC文件名</param>
  2720.         /// <param name="EmpName">操作人用户名</param>
  2721.         /// <param name="Date">操作日期时间</param>
  2722.         public void WriteXML(string XMLFileName, string DocFileName, string EmpName, string OpSort, string Date)
  2723.         {
  2724.             //初始化XML文档操作类
  2725.             XmlDocument mydoc = new XmlDocument();
  2726.             //加载指定的XML文件
  2727.             mydoc.Load(XMLFileName);
  2729.             //添加元素-DOC文件名
  2730.             XmlElement ele = mydoc.CreateElement("DocFileName");
  2731.             XmlText text = mydoc.CreateTextNode(DocFileName);
  2732.             //添加元素-操作人用户名
  2733.             XmlElement ele1 = mydoc.CreateElement("EmpName");
  2734.             XmlText text1 = mydoc.CreateTextNode(EmpName);
  2735.             //添加元素-操作人类型
  2736.             XmlElement ele3 = mydoc.CreateElement("OpSort");
  2737.             XmlText text3 = mydoc.CreateTextNode(OpSort);
  2738.             //添加元素-操作日期时间
  2739.             XmlElement ele2 = mydoc.CreateElement("Date");
  2740.             XmlText text2 = mydoc.CreateTextNode(Date);
  2741.         
  2742.             //添加文件的节点-msgrecord
  2743.             XmlNode newElem = mydoc.CreateNode("element", "XMLrecord", "");
  2744.             //在节点中添加元素
  2745.             newElem.AppendChild(ele);
  2746.             newElem.LastChild.AppendChild(text);
  2747.             newElem.AppendChild(ele1);
  2748.             newElem.LastChild.AppendChild(text1);
  2749.             newElem.AppendChild(ele3);
  2750.             newElem.LastChild.AppendChild(text3);
  2751.             newElem.AppendChild(ele2);
  2752.             newElem.LastChild.AppendChild(text2);
  2753.             //将节点添加到文档中
  2754.             XmlElement root = mydoc.DocumentElement;
  2755.             root.AppendChild(newElem);
  2757.             //保存所有修改
  2758.             mydoc.Save(XMLFileName);
  2759.         }
  2763.         /// <summary>
  2764.         /// 判断 (或同类型的) 上级活动实例是否产生
  2765.         /// </summary>
  2766.         /// <param name="Actid">当前活动ID</param>
  2767.         /// <param name="WfInstanceID">当前工作流实例</param>
  2768.         /// <param name="IOpsort">是否要据类型查找</param>
  2769.         /// <param name="Opsort">类型</param>
  2770.         /// <returns>返回bool类型值</returns>
  2771.         public bool CheckUpActCompleteActIns(int Actid, int WfInstanceID, bool IOpsort, string Opsort)
  2772.         {
  2773.             bool bl = true;
  2774.             DataView dv = new DataView();
  2775.             MSSqlDataAccess MSDA = new MSSqlDataAccess(0);
  2776.             try
  2777.             {
  2778.                 string sSQL = "select  * from tb_WF_ActIns where ActivityID in (select ActivityID from tb_Colony_User where ParentActID=" + Actid + ") and WfInstanceID=" + WfInstanceID;
  2779.                 MSDA.Open();
  2780.                 if(IOpsort==true)
  2781.                     sSQL = "select  * from tb_WF_ActIns where ActivityID in (select ActivityID from tb_Colony_User where ParentActID=" + Actid + ") and WfInstanceID=" + WfInstanceID + " and BlockReason='"  + Opsort +"'";
  2782.                 
  2783.                 dv = MSDA.ExecuteDataView(CommandType.Text, sSQL, null);
  2784.                 if (dv.Table.Rows.Count > 0)
  2785.                 {
  2786.                     for (int i = 0; i < dv.Table.Rows.Count; i++)
  2787.                     {
  2788.                         if (Convert.ToInt32(dv.Table.Rows[i][0].ToString()) == 0) bl = false;
  2789.                     }
  2790.                 }
  2791.                 else
  2792.                 {
  2793.                     bl = false;
  2794.                 }
  2795.             }
  2796.             catch (Exception ex)
  2797.             {
  2798.                 bl = false;
  2799.                 throw ex;
  2800.             }
  2801.             finally
  2802.             {
  2803.                 MSDA.Close();
  2804.             }
  2805.             return bl;
  2806.         }
  2808.   
  2809.    #endregion
  2810.     }
  2812. }