Example #1
0
    protected void Button1_Click(object sender, EventArgs e)
    {
        try
        {
            System.Web.HttpFileCollection uploadFiles = Request.Files;
            System.Web.HttpPostedFile     theFile;
            for (int i = 0; i < uploadFiles.Count; i++)
            {
                theFile = uploadFiles[i];
                if (Convert.ToDouble(theFile.ContentLength) / 1024 / 1024 > 10)
                {
                    Tunnel.Common.Message.back("附件大小不能大于10MB");
                    return;
                }
                else
                {
                    continue;
                }
            }
            string curruser = m_value.Value;
            //将当前步骤存入数据库表:Tunnel_exam
            Tunnel.BLL.Tunnel_exam     bte = new Tunnel.BLL.Tunnel_exam();
            Tunnel.Model.Tunnel_exam   mte = new Tunnel.Model.Tunnel_exam();
            Tunnel.Model.Tunnel_Remind tr  = new Tunnel.Model.Tunnel_Remind();
            Tunnel.BLL.Tunnel_Remind   br  = new Tunnel.BLL.Tunnel_Remind();
            mte.e_bid       = 0;
            mte.e_endtime   = DateTime.Now;
            mte.e_gid       = this.sava();
            mte.e_user      = 0;
            mte.e_time      = DateTime.Now;
            mte.e_nextbuser = curruser;
            mte.e_nextbid   = 1;
            bte.Add(mte);
            string[] users = curruser.Split(',');
            foreach (string user in users)
            {
                if (!string.IsNullOrEmpty(user))
                {
                    tr.m_title    = TextBox1.Text.Trim() + "<font color=red>(待审批)</font>";
                    tr.m_url      = "N_WorkFlow/OtherDocument/Other_zSp.aspx?bid=" + mte.e_gid;
                    tr.m_touser   = Convert.ToInt32(user);
                    tr.m_time     = DateTime.Now;
                    tr.m_type     = 1;
                    tr.m_typeid   = mte.e_gid;
                    tr.m_bid      = 1;
                    tr.m_callTime = Convert.ToDateTime("1800-1-1 00:00:00");
                    tr.m_isread   = 0;
                    long messge = br.Add(tr);
                }
            }

            Tunnel.Common.Message.Show("提交成功!");
        }
        catch
        {
            Tunnel.Common.Message.back("流程错误,请与管理员联系!");
        }
    }
Example #2
0
 protected void Button4_Click(object sender, EventArgs e)
 {
     Tunnel.Model.Tunnel_menber tm = ul.GetUserBean(ul.LoginID);
     if (!Tunnel.Data.DESEncrypt.Encrypt(spPassword.Text.Trim()).Equals(tm.m_spassword))
     {
         Tunnel.Common.Message.back("审批密码错误"); return;
     }
     else
     {
         //这里为存储当前步骤
         mtb = btb.GetModel(int.Parse(Request.Params["bid"]));
         mf  = bf.GetModel(mtb.b_sort);
         if (mtb.b_state == 3)
         {
             Tunnel.Common.Message.back("此流程己审批结束,请勿重复审批!"); return;
         }
         else
         {
             //将当前步骤存入数据库表:Tunnel_exam
             Tunnel.BLL.Tunnel_exam   bte = new Tunnel.BLL.Tunnel_exam();
             Tunnel.Model.Tunnel_exam mte = new Tunnel.Model.Tunnel_exam();
             mte.e_bid       = 0;
             mte.e_endtime   = DateTime.Now;
             mte.e_gid       = Convert.ToInt32(Request.Params["bid"]);
             mte.e_user      = ul.LoginID;
             mte.e_nextbuser = m_value.Value;
             string lastendtime = Tunnel.Common.GetValue.getDataValue("Tunnel_exam", "e_endtime", "e_gid=" + Request.Params["bid"] + " order by e_id desc");
             if (!string.IsNullOrEmpty(lastendtime))
             {
                 mte.e_time = Convert.ToDateTime(lastendtime);//取得上一步的最后执行时间
             }
             else
             {
                 mte.e_time = mtb.b_time;
             }
             mte.e_nextbid = 1;
             bte.Add(mte);
             string contents = FCKeditor1.Value;
             //添加审批意见
             if (!string.IsNullOrEmpty(contents))
             {
                 Tunnel.BLL.Tunnel_Advice   ta = new Tunnel.BLL.Tunnel_Advice();
                 Tunnel.Model.Tunnel_Advice ma = new Tunnel.Model.Tunnel_Advice();
                 ma.a_content = contents;
                 ma.a_bid     = Convert.ToInt32(mts.s_id);
                 ma.a_gid     = Convert.ToInt32(mtb.b_id);
                 ma.a_time    = DateTime.Now;
                 ma.a_user    = ul.LoginID;
                 string count = Tunnel.Common.GetValue.getDataValue("Tunnel_Advice", "count(*)", "a_bid=1024 and a_gid=" + Request.Params["bid"]);
                 ta.Add(ma);
             }
             Tunnel.Data.DbHelperSQL.ExecuteSql("UPDATE TUNNEL_BUMF SET B_STATE=3 WHERE B_ID=" + Request.Params["bid"]);                                     //改变公文状态
             Tunnel.Data.DbHelperSQL.ExecuteSql("DELETE TUNNEL_REMIND WHERE m_type=1 and m_bid=1 and m_touser="******" and m_typeid=" + mtb.b_id); //删除待办事项
             Tunnel.Common.Message.Show("流程结束成功!", "../MyApply/Apply_Sp.aspx");
         }
     }
 }
Example #3
0
 protected void Button1_Click(object sender, EventArgs e)
 {
     try
     {
         Tunnel.Model.Tunnel_menber tm = ul.GetUserBean(ul.LoginID);
         mtb = btb.GetModel(int.Parse(Request.Params["bid"]));
         //下一步骤ID
         string currbid  = Tunnel.Common.GetValue.getDataValue("Tunnel_step", "s_id", "s_lid=" + mtb.b_sort + " and s_num=1");
         string curruser = Tunnel.Common.GetValue.getDataValue("Tunnel_step", "s_zid", "s_lid=" + mtb.b_sort + " and s_num=1");
         //如果流程没有预设步骤
         if ("".Equals(currbid))
         {
             Tunnel.Common.Message.back("本流程未预设步骤,请与管理员联系!"); return;
         }
         //将当前步骤存入数据库表:Tunnel_exam
         Tunnel.BLL.Tunnel_exam   bte = new Tunnel.BLL.Tunnel_exam();
         Tunnel.Model.Tunnel_exam mte = new Tunnel.Model.Tunnel_exam();
         mte.e_bid       = 0;
         mte.e_endtime   = DateTime.Now;
         mte.e_gid       = Convert.ToInt32(mtb.b_id);
         mte.e_user      = ul.LoginID;
         mte.e_time      = DateTime.Now;
         mte.e_nextbuser = "";
         mte.e_nextbid   = Convert.ToInt32(currbid);
         bte.Add(mte);
         if (!string.IsNullOrEmpty(curruser))
         {
             Tunnel.Model.Tunnel_Remind tr = new Tunnel.Model.Tunnel_Remind();
             Tunnel.BLL.Tunnel_Remind   br = new Tunnel.BLL.Tunnel_Remind();
             string[] users = curruser.Split(',');
             foreach (string user in users)
             {
                 if (!string.IsNullOrEmpty(user))
                 {
                     tr.m_title    = mtb.b_title + "<font color=red>(待审批)</font>";
                     tr.m_url      = "N_WorkFlow/MyApply/Apply_zSp.aspx?bid=" + mtb.b_id;
                     tr.m_touser   = Convert.ToInt32(user);
                     tr.m_time     = DateTime.Now;
                     tr.m_type     = 1;
                     tr.m_typeid   = Convert.ToInt32(mtb.b_id);
                     tr.m_bid      = Convert.ToInt32(currbid);
                     tr.m_callTime = Convert.ToDateTime("1800-1-1 00:00:00");
                     tr.m_isread   = 0;
                     long messge = br.Add(tr);
                 }
             }
         }
         Tunnel.Data.DbHelperSQL.ExecuteSql("UPDATE TUNNEL_BUMF SET B_STATE=2 WHERE B_ID=" + mtb.b_id);                  //改变公文状态
         Tunnel.Data.DbHelperSQL.ExecuteSql("DELETE TUNNEL_REMIND WHERE m_type=1 and m_bid=0 and m_typeid=" + mtb.b_id); //删除待办事项
         Tunnel.Common.Message.Show("操作成功,审核通过!", "Apply_SP.aspx");
     }
     catch
     {
         Tunnel.Common.Message.back("流程审核错误,请与管理员联系!");
     }
 }
Example #4
0
        /// <summary>
        /// 获得数据列表
        /// </summary>
        public List <Tunnel.Model.Tunnel_exam> DataTableToList(DataTable dt)
        {
            List <Tunnel.Model.Tunnel_exam> modelList = new List <Tunnel.Model.Tunnel_exam>();
            int rowsCount = dt.Rows.Count;

            if (rowsCount > 0)
            {
                Tunnel.Model.Tunnel_exam model;
                for (int n = 0; n < rowsCount; n++)
                {
                    model = new Tunnel.Model.Tunnel_exam();
                    //model.e_id=dt.Rows[n]["e_id"].ToString();
                    if (dt.Rows[n]["e_gid"].ToString() != "")
                    {
                        model.e_gid = int.Parse(dt.Rows[n]["e_gid"].ToString());
                    }
                    if (dt.Rows[n]["e_bid"].ToString() != "")
                    {
                        model.e_bid = int.Parse(dt.Rows[n]["e_bid"].ToString());
                    }
                    if (dt.Rows[n]["e_time"].ToString() != "")
                    {
                        model.e_time = DateTime.Parse(dt.Rows[n]["e_time"].ToString());
                    }
                    if (dt.Rows[n]["e_user"].ToString() != "")
                    {
                        model.e_user = int.Parse(dt.Rows[n]["e_user"].ToString());
                    }
                    if (dt.Rows[n]["e_endtime"].ToString() != "")
                    {
                        model.e_endtime = DateTime.Parse(dt.Rows[n]["e_endtime"].ToString());
                    }
                    //model.e_nextbid=dt.Rows[n]["e_nextbid"].ToString();
                    modelList.Add(model);
                }
            }
            return(modelList);
        }
Example #5
0
 /// <summary>
 /// 更新一条数据
 /// </summary>
 public void Update(Tunnel.Model.Tunnel_exam model)
 {
     dal.Update(model);
 }
Example #6
0
 /// <summary>
 /// 增加一条数据
 /// </summary>
 public int  Add(Tunnel.Model.Tunnel_exam model)
 {
     return(dal.Add(model));
 }
Example #7
0
    protected void Button2_Click(object sender, EventArgs e)
    {
        Tunnel.Model.Tunnel_menber tm = ul.GetUserBean(ul.LoginID);
        if (!Tunnel.Data.DESEncrypt.Encrypt(spPassword.Text.Trim()).Equals(tm.m_spassword))
        {
            Tunnel.Common.Message.back("审批密码错误"); return;
        }
        else
        {
            //这里为存储当前步骤
            mtb = btb.GetModel(int.Parse(Request.Params["bid"]));
            if (mtb.b_state == 3)
            {
                Tunnel.Common.Message.back("此公文己审批结束,请勿重复审批!"); return;
            }
            else
            {
                //将当前步骤存入数据库表:Tunnel_exam
                Tunnel.BLL.Tunnel_exam   bte = new Tunnel.BLL.Tunnel_exam();
                Tunnel.Model.Tunnel_exam mte = new Tunnel.Model.Tunnel_exam();
                mte.e_bid     = 0;
                mte.e_endtime = DateTime.Now;
                mte.e_gid     = Convert.ToInt32(Request.Params["bid"]);
                mte.e_user    = ul.LoginID;
                string lastendtime = Tunnel.Common.GetValue.getDataValue("Tunnel_exam", "e_endtime", "e_gid=" + mtb.b_id + " order by e_id desc");
                if (!string.IsNullOrEmpty(lastendtime))
                {
                    mte.e_time = Convert.ToDateTime(lastendtime);//取得上一步的最后执行时间
                }
                else
                {
                    mte.e_time = mtb.b_time;
                }
                mte.e_nextbid = 0;
                bte.Add(mte);

                #region 消息提示
                Tunnel.Model.Tunnel_Remind tr = new Tunnel.Model.Tunnel_Remind();
                Tunnel.BLL.Tunnel_Remind   br = new Tunnel.BLL.Tunnel_Remind();
                tr.m_title    = mtb.b_title + "<font color=red>(审批没有通过)</font>";
                tr.m_url      = "N_WorkFlow/OtherDocument/Other_Edit.aspx?bid=" + Request.Params["bid"];
                tr.m_touser   = Convert.ToInt32(mtb.b_user);
                tr.m_time     = DateTime.Now;
                tr.m_type     = 1;
                tr.m_typeid   = Convert.ToInt32(mtb.b_id);
                tr.m_bid      = -1;
                tr.m_callTime = Convert.ToDateTime("1800-1-1 00:00:00");
                tr.m_isread   = 0;
                long messge = br.Add(tr);
                #endregion

                string contents = FCKeditor1.Value;
                //添加审批意见
                if (!string.IsNullOrEmpty(contents))
                {
                    Tunnel.BLL.Tunnel_Advice   ta = new Tunnel.BLL.Tunnel_Advice();
                    Tunnel.Model.Tunnel_Advice ma = new Tunnel.Model.Tunnel_Advice();
                    ma.a_content = contents;
                    ma.a_bid     = 1024;//1024代表是其它申请 没有步骤ID的
                    ma.a_gid     = Convert.ToInt32(mtb.b_id);
                    ma.a_time    = DateTime.Now;
                    ma.a_user    = ul.LoginID;
                    string count = Tunnel.Common.GetValue.getDataValue("Tunnel_Advice", "count(*)", "a_bid=1024 and a_gid=" + mtb.b_id);
                    ta.Add(ma);
                }
                Tunnel.Data.DbHelperSQL.ExecuteSql("UPDATE TUNNEL_BUMF SET B_STATE=0 WHERE B_ID=" + mtb.b_id);                                                  //改变公文状态
                Tunnel.Data.DbHelperSQL.ExecuteSql("DELETE TUNNEL_REMIND WHERE m_type=1 and m_bid=1 and m_touser="******" and m_typeid=" + mtb.b_id); //删除待办事项
                Tunnel.Common.Message.Show("操作成功!", "../MyApply/Apply_Sp.aspx");
            }
        }
    }
Example #8
0
    protected void Button5_Click(object sender, EventArgs e)
    {
        //这里为存储当前步骤
        mtb = btb.GetModel(int.Parse(Request.Params["bid"]));
        mf  = bf.GetModel(mtb.b_sort);
        if (mtb.b_state == 3)
        {
            Tunnel.Common.Message.back("此流程己审批结束,请勿重复审批!"); return;
        }
        else
        {
            string currbid = Tunnel.Common.GetValue.getDataValue("Tunnel_exam", "e_nextbid", "e_gid=" + Request.Params["bid"] + " order by e_id desc");
            if ("".Equals(currbid) || "0".Equals(currbid))
            {
                currbid = Tunnel.Common.GetValue.getDataValue("Tunnel_step", "s_id", "s_lid=" + mtb.b_sort + " and s_num=1");
            }
            mts = bts.GetModel(Convert.ToInt32(currbid));
            int    cunum     = mts.s_num;
            bool   iscshened = true;
            int    sum       = bts.GetCount("s_lid=" + mtb.b_sort);
            string curruser  = Tunnel.Common.GetValue.getDataValue("Tunnel_step", "s_zid", "s_id=" + mts.s_id);
            if (!string.IsNullOrEmpty(curruser))
            {
                string[] users = curruser.Split(',');
                foreach (string user in users)
                {
                    if (!string.IsNullOrEmpty(user))
                    {
                        if (user == ul.LoginID.ToString())
                        {
                            iscshened = false;
                        }
                    }
                }
            }
            if (!iscshened || ul.JiaoSe(ul.LoginID) == "系统管理员")
            {
                //将当前步骤存入数据库表:Tunnel_exam
                Tunnel.BLL.Tunnel_exam   bte = new Tunnel.BLL.Tunnel_exam();
                Tunnel.Model.Tunnel_exam mte = new Tunnel.Model.Tunnel_exam();
                mte.e_bid     = Convert.ToInt32(mts.s_id);
                mte.e_endtime = DateTime.Now;
                mte.e_gid     = Convert.ToInt32(Request.Params["bid"]);
                mte.e_user    = ul.LoginID;
                string lastendtime = Tunnel.Common.GetValue.getDataValue("Tunnel_exam", "e_endtime", "e_gid=" + Request.Params["bid"] + " order by e_id desc");
                if (!string.IsNullOrEmpty(lastendtime))
                {
                    mte.e_time = Convert.ToDateTime(lastendtime);//取得上一步的最后执行时间
                }
                else
                {
                    mte.e_time = mtb.b_time;
                }
                //如果为最后一步则结束流程
                if (cunum == sum)
                {
                    mte.e_nextbid = 0;
                    string pid = Tunnel.Common.GetValue.getDataValue("Tunnel_flow", "f_sort", "f_id=" + mtb.b_sort);
                    //插入到公司发文
                    if ("18".Equals(pid))
                    {
                        tmt.Title      = mtb.b_title;
                        tmt.TypeId     = 5;
                        tmt.HtmlSource = fc.From_Content(mtb.b_formcontent, mtb.b_content, true);//取得替换后的表单数据
                        tmt.UserId     = mtb.b_user;
                        Tunnel.BLL.Tunnel_information bllf = new Tunnel.BLL.Tunnel_information();
                        int relt = -1;
                        relt = bllf.Add(tmt);
                    }
                    Tunnel.Data.DbHelperSQL.ExecuteSql("UPDATE TUNNEL_BUMF SET B_STATE=3 WHERE B_ID=" + Request.Params["bid"]);
                    Tunnel.Data.DbHelperSQL.ExecuteSql("DELETE TUNNEL_REMIND WHERE m_type=1 and m_bid=" + currbid + " and m_typeid=" + mtb.b_id);//删除待办事项
                    Tunnel.Common.Message.Show("流程结束成功!", "Apply_Sp.aspx");
                }
                else
                {
                    string currs = "";
                    if (!"".Equals(currbid) || !"0".Equals(currbid))
                    {
                        string nid = Tunnel.Common.GetValue.getDataValue("Tunnel_step", "s_id", "s_lid=" + mtb.b_sort + " and s_num>" + mts.s_num + " order by s_num asc");
                        currs = Tunnel.Common.GetValue.getDataValue("Tunnel_step", "s_zid", "s_lid=" + mtb.b_sort + " and s_num>" + mts.s_num + " order by s_num asc");
                        if (string.IsNullOrEmpty(nid))
                        {
                            nid = "0";
                        }
                        mte.e_nextbid = long.Parse(nid);
                    }
                    else
                    {
                        mte.e_nextbid = 0;
                    }
                    if (!string.IsNullOrEmpty(currs))
                    {
                        Tunnel.Model.Tunnel_Remind tr = new Tunnel.Model.Tunnel_Remind();
                        Tunnel.BLL.Tunnel_Remind   br = new Tunnel.BLL.Tunnel_Remind();
                        string[] users = currs.Split(',');
                        foreach (string user in users)
                        {
                            if (!string.IsNullOrEmpty(user))
                            {
                                tr.m_title    = mtb.b_title + "<font color=red>(待审批)</font>";
                                tr.m_url      = "N_WorkFlow/MyApply/Apply_zSp.aspx?bid=" + mtb.b_id;
                                tr.m_touser   = Convert.ToInt32(user);
                                tr.m_time     = DateTime.Now;
                                tr.m_type     = 1;
                                tr.m_typeid   = Convert.ToInt32(mtb.b_id);
                                tr.m_bid      = Convert.ToInt32(mte.e_nextbid);
                                tr.m_callTime = Convert.ToDateTime("1800-1-1 00:00:00");
                                tr.m_isread   = 0;
                                long messge = br.Add(tr);
                            }
                        }
                    }
                }

                bte.Add(mte);
                string contents = FCKeditor1.Value;
                //添加审批意见
                if (!string.IsNullOrEmpty(contents))
                {
                    Tunnel.BLL.Tunnel_Advice   ta = new Tunnel.BLL.Tunnel_Advice();
                    Tunnel.Model.Tunnel_Advice ma = new Tunnel.Model.Tunnel_Advice();
                    ma.a_content = contents;
                    ma.a_bid     = Convert.ToInt32(mts.s_id);
                    ma.a_gid     = Convert.ToInt32(mtb.b_id);
                    ma.a_time    = DateTime.Now;
                    ma.a_user    = ul.LoginID;
                    string count = Tunnel.Common.GetValue.getDataValue("Tunnel_Advice", "count(*)", "a_bid=" + mf.f_id + " and a_gid=" + Request.Params["bid"]);
                    if (int.Parse(count) > 0)
                    {
                        ta.Update(ma);
                    }
                    else
                    {
                        ta.Add(ma);
                    }
                }
                Tunnel.Data.DbHelperSQL.ExecuteSql("DELETE TUNNEL_REMIND WHERE m_type=1 and m_bid=" + currbid + " and m_typeid=" + mtb.b_id);//删除待办事项
                Tunnel.Common.Message.Show("操作成功!", "Apply_Sp.aspx");
            }
            else
            {
                Tunnel.Common.Message.back("此流程己审批通过,请勿重复审批!"); return;
            }
        }
    }
Example #9
0
    protected void Button2_Click(object sender, EventArgs e)
    {
        Tunnel.Model.Tunnel_menber tm = ul.GetUserBean(ul.LoginID);
        if (!Tunnel.Data.DESEncrypt.Encrypt(spPassword.Text.Trim()).Equals(tm.m_spassword))
        {
            Tunnel.Common.Message.back("审批密码错误"); return;
        }
        else
        {
            //这里为存储当前步骤
            mtb = btb.GetModel(int.Parse(Request.Params["bid"]));
            mf  = bf.GetModel(mtb.b_sort);
            if (mtb.b_state == 3)
            {
                Tunnel.Common.Message.back("此公文己审批结束,请勿重复审批!"); return;
            }
            else
            {
                string currbid = Tunnel.Common.GetValue.getDataValue("Tunnel_exam", "e_nextbid", "e_gid=" + Request.Params["bid"] + " order by e_id desc");
                if ("".Equals(currbid) || "0".Equals(currbid))
                {
                    currbid = Tunnel.Common.GetValue.getDataValue("Tunnel_step", "s_id", "s_lid=" + mtb.b_sort + " and s_num=1");
                }
                mts = bts.GetModel(Convert.ToInt32(currbid));
                bool   iscshened = true;
                int    sum       = bts.GetCount("s_lid=" + mtb.b_sort);
                string curruser  = Tunnel.Common.GetValue.getDataValue("Tunnel_step", "s_zid", "s_id=" + mts.s_id);
                if (!string.IsNullOrEmpty(curruser))
                {
                    string[] users = curruser.Split(',');
                    foreach (string user in users)
                    {
                        if (!string.IsNullOrEmpty(user))
                        {
                            if (user == ul.LoginID.ToString())
                            {
                                iscshened = false;
                            }
                        }
                    }
                }
                if (!iscshened || ul.JiaoSe(ul.LoginID) == "系统管理员")
                {
                    //将当前步骤存入数据库表:Tunnel_exam
                    Tunnel.BLL.Tunnel_exam   bte = new Tunnel.BLL.Tunnel_exam();
                    Tunnel.Model.Tunnel_exam mte = new Tunnel.Model.Tunnel_exam();
                    mte.e_bid     = 0;
                    mte.e_endtime = DateTime.Now;
                    mte.e_gid     = Convert.ToInt32(Request.Params["bid"]);
                    mte.e_user    = ul.LoginID;
                    string lastendtime = Tunnel.Common.GetValue.getDataValue("Tunnel_exam", "e_endtime", "e_gid=" + mtb.b_id + " order by e_id desc");
                    if (!string.IsNullOrEmpty(lastendtime))
                    {
                        mte.e_time = Convert.ToDateTime(lastendtime);//取得上一步的最后执行时间
                    }
                    else
                    {
                        mte.e_time = mtb.b_time;
                    }
                    mte.e_nextbid = 0;
                    bte.Add(mte);

                    #region 消息提示
                    Tunnel.Model.Tunnel_Remind tr = new Tunnel.Model.Tunnel_Remind();
                    Tunnel.BLL.Tunnel_Remind   br = new Tunnel.BLL.Tunnel_Remind();
                    tr.m_title = mtb.b_title + "<font color=red>(审批没有通过)</font>";
                    string flowtype = Tunnel.Common.GetValue.getDataValue("Tunnel_flow", "f_sort", "f_id=" + mtb.b_sort);
                    if ("18".Equals(flowtype))
                    {
                        tr.m_url = "N_WorkFlow/ODocument/Document_Edit.aspx?Bid=" + mtb.b_id;
                    }
                    else
                    {
                        tr.m_url = "N_WorkFlow/MyApply/Apply_Edit.aspx?Bid=" + mtb.b_id + "&Flow=" + mtb.b_sort;
                    }
                    tr.m_touser   = Convert.ToInt32(mtb.b_user);
                    tr.m_time     = DateTime.Now;
                    tr.m_type     = 1;
                    tr.m_typeid   = Convert.ToInt32(mtb.b_id);
                    tr.m_bid      = -1;
                    tr.m_callTime = Convert.ToDateTime("1800-1-1 00:00:00");
                    tr.m_isread   = 0;
                    long messge = br.Add(tr);
                    #endregion

                    string contents = FCKeditor1.Value;
                    //添加审批意见
                    if (!string.IsNullOrEmpty(contents))
                    {
                        Tunnel.BLL.Tunnel_Advice   ta = new Tunnel.BLL.Tunnel_Advice();
                        Tunnel.Model.Tunnel_Advice ma = new Tunnel.Model.Tunnel_Advice();
                        ma.a_content = contents;
                        ma.a_bid     = Convert.ToInt32(mts.s_id);
                        ma.a_gid     = Convert.ToInt32(mtb.b_id);
                        ma.a_time    = DateTime.Now;
                        ma.a_user    = ul.LoginID;
                        string count = Tunnel.Common.GetValue.getDataValue("Tunnel_Advice", "count(*)", "a_bid=" + mf.f_id + " and a_gid=" + mtb.b_id);
                        if (int.Parse(count) > 0)
                        {
                            ta.Update(ma);
                        }
                        else
                        {
                            ta.Add(ma);
                        }
                    }
                    Tunnel.Data.DbHelperSQL.ExecuteSql("DELETE TUNNEL_REMIND WHERE m_type=1 and m_bid=" + currbid + " and m_typeid=" + mtb.b_id); //删除待办事项
                    Tunnel.Data.DbHelperSQL.ExecuteSql("UPDATE TUNNEL_BUMF SET B_STATE=0 WHERE B_ID=" + mtb.b_id);                                //改变公文状态
                    Tunnel.Common.Message.Show("操作成功!", "Apply_Sp.aspx");
                }
                else
                {
                    Tunnel.Common.Message.back("此流程己审批通过,请勿重复审批!"); return;
                }
            }
        }
    }
Example #10
0
 protected void Button1_Click(object sender, EventArgs e)
 {
     try
     {
         System.Web.HttpFileCollection uploadFiles = Request.Files;
         System.Web.HttpPostedFile     theFile;
         for (int i = 0; i < uploadFiles.Count; i++)
         {
             theFile = uploadFiles[i];
             if (Convert.ToDouble(theFile.ContentLength) / 1024 / 1024 > 10)
             {
                 Tunnel.Common.Message.back("附件大小不能大于10MB");
                 return;
             }
             else
             {
                 continue;
             }
         }
         Tunnel.Model.Tunnel_menber tm = ul.GetUserBean(ul.LoginID);
         //下一步骤ID
         string currbid  = Tunnel.Common.GetValue.getDataValue("Tunnel_step", "s_id", "s_lid=" + Request.Params["Flow"] + " and s_num=1");
         string curruser = Tunnel.Common.GetValue.getDataValue("Tunnel_step", "s_zid", "s_lid=" + Request.Params["Flow"] + " and s_num=1");
         //如果流程没有预设步骤
         if ("".Equals(currbid))
         {
             Tunnel.Common.Message.back("本流程未预设步骤,请与管理员联系!"); return;
         }
         Tunnel.Model.Tunnel_Remind tr = new Tunnel.Model.Tunnel_Remind();
         Tunnel.BLL.Tunnel_Remind   br = new Tunnel.BLL.Tunnel_Remind();
         mf = bf.GetModel(int.Parse(Request.Params["Flow"]));
         if (mf.f_state.ToString() == "0")
         {
             isshen = true;
         }
         else
         {
             isshen = false;
         }
         if (!isshen)
         {
             //将当前步骤存入数据库表:Tunnel_exam
             Tunnel.BLL.Tunnel_exam   bte = new Tunnel.BLL.Tunnel_exam();
             Tunnel.Model.Tunnel_exam mte = new Tunnel.Model.Tunnel_exam();
             mte.e_bid     = 0;
             mte.e_endtime = DateTime.Now;
             mte.e_gid     = this.sava();
             mte.e_user    = ul.LoginID;
             mte.e_time    = DateTime.Now;
             mte.e_nextbid = Convert.ToInt32(currbid);
             bte.Add(mte);
             string[] users = curruser.Split(',');
             foreach (string user in users)
             {
                 if (!string.IsNullOrEmpty(user))
                 {
                     tr.m_title    = TextBox1.Text.Trim() + "<font color=red>(待审批)</font>";
                     tr.m_url      = "N_WorkFlow/MyApply/Apply_zSp.aspx?bid=" + mte.e_gid;
                     tr.m_touser   = Convert.ToInt32(user);
                     tr.m_time     = DateTime.Now;
                     tr.m_type     = 1;
                     tr.m_typeid   = mte.e_gid;
                     tr.m_bid      = Convert.ToInt32(currbid);
                     tr.m_callTime = Convert.ToDateTime("1800-1-1 00:00:00");
                     tr.m_isread   = 0;
                     long messge = br.Add(tr);
                 }
             }
         }
         else
         {
             int s = this.sava();
             ul.UsbnLogin = bm.GetModel(ul.LoginID);
             DataSet dss      = bm.GetList("m_bum=" + ul.UsbnLogin.m_bum);
             string  userlist = "";
             foreach (DataRow dr in dss.Tables[0].Rows)
             {
                 if (Tunnel.BLL.Permission.IfHasPrimision(dr["m_id"].ToString(), "流程审核", "我的工作", false))
                 {
                     userlist = dr["m_id"].ToString();
                 }
             }
             tr.m_title    = TextBox1.Text.Trim() + "<font color=red>(待审核)</font>";
             tr.m_url      = "N_WorkFlow/MyApply/Apply_zSh.aspx?bid=" + s;
             tr.m_touser   = (RadioButtonList3.SelectedValue == "1" ? int.Parse(m_value.Value) : Convert.ToInt32(userlist));
             tr.m_time     = DateTime.Now;
             tr.m_type     = 1;
             tr.m_typeid   = s;
             tr.m_bid      = 0;
             tr.m_callTime = Convert.ToDateTime("1800-1-1 00:00:00");
             tr.m_isread   = 0;
             long messge = br.Add(tr);
         }
         Tunnel.Common.Message.Show("提交成功!", "Apply_Add.aspx?Flow=" + Request.Params["Flow"]);
     }
     catch
     {
         Tunnel.Common.Message.back("流程错误,请与管理员联系!");
     }
 }
Example #11
0
    protected void Button1_Click(object sender, EventArgs e)
    {
        try
        {
            System.Web.HttpFileCollection uploadFiles = Request.Files;
            System.Web.HttpPostedFile     theFile;
            for (int i = 0; i < uploadFiles.Count; i++)
            {
                theFile = uploadFiles[i];
                if (Convert.ToDouble(theFile.ContentLength) / 1024 / 1024 > 10)
                {
                    Tunnel.Common.Message.back("附件大小不能大于10MB");
                    return;
                }
                else
                {
                    continue;
                }
            }
            this.sava();
            Tunnel.Model.Tunnel_menber tm = ul.GetUserBean(ul.LoginID);
            mtb = btb.GetModel(Convert.ToInt32(Request.Params["bid"]));
            //下一步骤ID
            string currbid  = Tunnel.Common.GetValue.getDataValue("Tunnel_step", "s_id", "s_lid=" + mtb.b_sort + " and s_num=1");
            string curruser = Tunnel.Common.GetValue.getDataValue("Tunnel_step", "s_zid", "s_lid=" + mtb.b_sort + " and s_num=1");
            //如果流程没有预设步骤
            if ("".Equals(currbid))
            {
                Tunnel.Common.Message.back("本流程未预设步骤,请与管理员联系!"); return;
            }
            //将当前步骤存入数据库表:Tunnel_exam
            Tunnel.BLL.Tunnel_exam   bte = new Tunnel.BLL.Tunnel_exam();
            Tunnel.Model.Tunnel_exam mte = new Tunnel.Model.Tunnel_exam();
            mte.e_bid     = 0;
            mte.e_endtime = DateTime.Now;
            mte.e_gid     = Convert.ToInt32(mtb.b_id);
            mte.e_user    = ul.LoginID;
            mte.e_time    = DateTime.Now;
            mte.e_nextbid = Convert.ToInt32(currbid);
            bte.Add(mte);

            Tunnel.Model.Tunnel_Remind tr = new Tunnel.Model.Tunnel_Remind();
            Tunnel.BLL.Tunnel_Remind   br = new Tunnel.BLL.Tunnel_Remind();
            string[] users = curruser.Split(',');
            foreach (string user in users)
            {
                if (!string.IsNullOrEmpty(user))
                {
                    tr.m_title    = TextBox1.Text.Trim() + "<font color=red>(待审批)</font>";
                    tr.m_url      = "N_WorkFlow/MyApply/Apply_zSp.aspx?bid=" + mte.e_gid;
                    tr.m_touser   = Convert.ToInt32(user);
                    tr.m_time     = DateTime.Now;
                    tr.m_type     = 1;
                    tr.m_typeid   = mte.e_gid;
                    tr.m_bid      = Convert.ToInt32(currbid);
                    tr.m_callTime = Convert.ToDateTime("1800-1-1 00:00:00");
                    tr.m_isread   = 0;
                    long messge = br.Add(tr);
                }
            }
            Tunnel.Data.DbHelperSQL.ExecuteSql("DELETE TUNNEL_REMIND WHERE m_type=1 and m_bid=-1 and m_typeid=" + mtb.b_id);//删除待办事项
            Tunnel.Common.Message.Show("操作成功!", "Document_Add.aspx");
        }
        catch
        {
            Tunnel.Common.Message.back("流程错误,请与管理员联系!");
        }
    }