示例#1
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public void Update(Dianda.Model.Project_Apply_orderCar model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update Project_Apply_orderCar set ");
            strSql.Append("ApplyID=@ApplyID,");
            strSql.Append("CarID=@CarID,");
            strSql.Append("StartTime=@StartTime,");
            strSql.Append("EndTime=@EndTime,");
            strSql.Append("PeopleNum=@PeopleNum,");
            strSql.Append("FromAddress=@FromAddress,");
            strSql.Append("ToAddress=@ToAddress");
            strSql.Append(" where ID=@ID ");
            SqlParameter[] parameters =
            {
                new SqlParameter("@ID",          SqlDbType.Int,         4),
                new SqlParameter("@ApplyID",     SqlDbType.Int,         4),
                new SqlParameter("@CarID",       SqlDbType.Int,         4),
                new SqlParameter("@StartTime",   SqlDbType.DateTime),
                new SqlParameter("@EndTime",     SqlDbType.DateTime),
                new SqlParameter("@PeopleNum",   SqlDbType.Int,         4),
                new SqlParameter("@FromAddress", SqlDbType.VarChar,   500),
                new SqlParameter("@ToAddress",   SqlDbType.VarChar, 500)
            };
            parameters[0].Value = model.ID;
            parameters[1].Value = model.ApplyID;
            parameters[2].Value = model.CarID;
            parameters[3].Value = model.StartTime;
            parameters[4].Value = model.EndTime;
            parameters[5].Value = model.PeopleNum;
            parameters[6].Value = model.FromAddress;
            parameters[7].Value = model.ToAddress;

            DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
        }
示例#2
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public Dianda.Model.Project_Apply_orderCar GetModel(int ID)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select  top 1 ID,ApplyID,CarID,StartTime,EndTime,PeopleNum,FromAddress,ToAddress from Project_Apply_orderCar ");
            strSql.Append(" where ID=@ID ");
            SqlParameter[] parameters =
            {
                new SqlParameter("@ID", SqlDbType.Int, 4)
            };
            parameters[0].Value = ID;

            Dianda.Model.Project_Apply_orderCar model = new Dianda.Model.Project_Apply_orderCar();
            DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);

            if (ds.Tables[0].Rows.Count > 0)
            {
                if (ds.Tables[0].Rows[0]["ID"].ToString() != "")
                {
                    model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
                }
                if (ds.Tables[0].Rows[0]["ApplyID"].ToString() != "")
                {
                    model.ApplyID = int.Parse(ds.Tables[0].Rows[0]["ApplyID"].ToString());
                }
                if (ds.Tables[0].Rows[0]["CarID"].ToString() != "")
                {
                    model.CarID = int.Parse(ds.Tables[0].Rows[0]["CarID"].ToString());
                }
                if (ds.Tables[0].Rows[0]["StartTime"].ToString() != "")
                {
                    model.StartTime = DateTime.Parse(ds.Tables[0].Rows[0]["StartTime"].ToString());
                }
                if (ds.Tables[0].Rows[0]["EndTime"].ToString() != "")
                {
                    model.EndTime = DateTime.Parse(ds.Tables[0].Rows[0]["EndTime"].ToString());
                }
                if (ds.Tables[0].Rows[0]["PeopleNum"].ToString() != "")
                {
                    model.PeopleNum = int.Parse(ds.Tables[0].Rows[0]["PeopleNum"].ToString());
                }
                model.FromAddress = ds.Tables[0].Rows[0]["FromAddress"].ToString();
                model.ToAddress   = ds.Tables[0].Rows[0]["ToAddress"].ToString();
                return(model);
            }
            else
            {
                return(null);
            }
        }
示例#3
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(Dianda.Model.Project_Apply_orderCar model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into Project_Apply_orderCar(");
            strSql.Append("ApplyID,CarID,StartTime,EndTime,PeopleNum,FromAddress,ToAddress)");
            strSql.Append(" values (");
            strSql.Append("@ApplyID,@CarID,@StartTime,@EndTime,@PeopleNum,@FromAddress,@ToAddress)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters =
            {
                new SqlParameter("@ApplyID",     SqlDbType.Int,         4),
                new SqlParameter("@CarID",       SqlDbType.Int,         4),
                new SqlParameter("@StartTime",   SqlDbType.DateTime),
                new SqlParameter("@EndTime",     SqlDbType.DateTime),
                new SqlParameter("@PeopleNum",   SqlDbType.Int,         4),
                new SqlParameter("@FromAddress", SqlDbType.VarChar,   500),
                new SqlParameter("@ToAddress",   SqlDbType.VarChar, 500)
            };
            parameters[0].Value = model.ApplyID;
            parameters[1].Value = model.CarID;
            parameters[2].Value = model.StartTime;
            parameters[3].Value = model.EndTime;
            parameters[4].Value = model.PeopleNum;
            parameters[5].Value = model.FromAddress;
            parameters[6].Value = model.ToAddress;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);

            if (obj == null)
            {
                return(1);
            }
            else
            {
                return(Convert.ToInt32(obj));
            }
        }
示例#4
0
        /// <summary>
        /// 点击确定按钮触发的事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void Button_sumbit_onclick(object sender, EventArgs e)
        {
            try
            {
                Model.USER_Users user_model = (Model.USER_Users)Session["USER_Users"];
                //ID
                apply_model.ID = apply_bll.GetMaxId();
                //项目ID
                if (null != Request["order"] && Request["order"].ToString().Equals("orderresource"))
                {
                    apply_model.ProjectID = Convert.ToInt16(DDL_Project.SelectedValue.ToString());
                }
                else
                {
                    //if (null == Session["Work_ProjectId"])
                    if (null != Request["apply"])
                    {
                        apply_model.ProjectID = Convert.ToInt16(DDL_Project.SelectedValue.ToString());
                    }
                    else
                    {
                        apply_model.ProjectID = Convert.ToInt16(Session["Work_ProjectId"]);
                    }
                }

                //删除标记
                apply_model.DELFLAG = 0;
                //申请的状态
                apply_model.Status = 0;//初始为0表示待审核

                if (DDL_AppType.SelectedValue.ToString().Equals(""))
                {
                    tag.Text = "请先选择申请类型!";
                    return;
                }

                //申请业务的类型
                apply_model.AppType = DDL_AppType.SelectedValue;

                //用途描述
                apply_model.Overviews = Overviews.Text.ToString();
                //提交的时间
                apply_model.DATETIME = Convert.ToDateTime(DateTime.Now.ToString());
                //提交申请的用户的ID
                apply_model.SendUserID = user_model.ID;
                //申请的部门和申请人
                apply_model.DepartmentID = DDL_Department.SelectedValue;
                //申请人
                apply_model.ApplyUserID  = User_DPList.SelectedValue;
                Session["ApplyUserName"] = "******" + User_DPList.SelectedItem.Text.ToString().Substring(0, User_DPList.SelectedItem.Text.ToString().IndexOf('(')) + ")";
                //联系电话
                apply_model.TelNum = TB_TelNum.Text.ToString();

                //表示选择申请业务类型是订饭申请***************************************
                if (DDL_AppType.SelectedValue.ToString().Equals("orderFood"))
                {
                    Dianda.Model.Project_Apply_orderFood orderfood_model = new Dianda.Model.Project_Apply_orderFood();
                    Dianda.BLL.Project_Apply_orderFood   orderfood_bll   = new Dianda.BLL.Project_Apply_orderFood();

                    if (((HiddenField)orderFood.FindControl("HiddenField2")).Value == "fales")
                    {
                        tag.Text = "定饭日期发生变动!请检查后提交!";
                        return;
                    }

                    //定饭总量
                    int orderFoodNums = int.Parse(ConfigurationSettings.AppSettings["orderFoodNums"]);
                    //获取添写的订饭的数量
                    if (null != orderFood.orderfoodnum && !orderFood.orderfoodnum.Equals(""))
                    {
                        //获取剩余的数量
                        int LimitNum = int.Parse(orderFood.LimitNum);

                        try
                        {
                            int n = Convert.ToInt32(orderFood.orderfoodnum);
                            if (n <= 0)
                            {
                                tag.Text = "预订数量必须大于0!";
                                return;
                            }
                        }
                        catch
                        {
                            tag.Text = "预订数量只能是大于0的数字!";
                            return;
                        }

                        int orderNums = int.Parse(orderFood.orderfoodnum);
                        //预订日期
                        DateTime ordertime = Convert.ToDateTime(orderFood.orderfoodtime);
                        //在当前日期上加二天
                        DateTime now = DateTime.Now.AddDays(2);

                        if (Convert.ToDateTime(ordertime.ToString("yyyy-MM-dd")) < Convert.ToDateTime(now.ToString("yyyy-MM-dd")))
                        {
                            tag.Text = "午餐必须提前二天预订,请电话联系相关人员!";
                            return;
                        }

                        if (orderNums > LimitNum)
                        {
                            tag.Text = "预订的数量不能大于剩余的数量,请修改!";
                        }
                        else
                        {
                            //ID
                            orderfood_model.ID = orderfood_bll.GetMaxId();
                            //申请ID
                            orderfood_model.ApplyID = apply_model.ID;
                            //用饭时间
                            orderfood_model.UserDatetime = Convert.ToDateTime(orderFood.orderfoodtime);
                            //预订份数
                            orderfood_model.OrderNum = int.Parse(orderFood.orderfoodnum);

                            orderfood_bll.Add(orderfood_model);

                            apply_bll.Add(apply_model);

                            Session["Session_Project_linkshow"] = "LinkButton_apply";

                            if (null == Session["Work_ProjectId"])
                            {
                                Session["Work_ProjectId"] = DDL_Project.SelectedValue.ToString();
                            }
                            string coutws = "";
                            string type   = "";

                            if (null != Request["type"] && !(Request["type"].ToString().Equals("")))
                            {
                                type = Request["type"].ToString();
                            }
                            else
                            {
                                type = DDL_AppType.SelectedValue.ToString();
                            }
                            // if (null != Request["order"] && Request["order"].ToString().Equals("orderresource"))
                            if (null != Request["apply"] && Request["apply"].ToString().Equals("orderFood"))
                            {
                                coutws = "<script language=\"javascript\" type=\"text/javascript\">alert(\"操作成功!现在进入列表页面\"); location.href = \"resourceManage.aspx?type=" + type + "&project=" + Request["project"] + "&status=" + "\";</script>";
                            }
                            else
                            {
                                coutws = "<script language=\"javascript\" type=\"text/javascript\">alert(\"操作成功!现在进入列表页面\"); location.href = \"manage.aspx?type=" + DDL_AppType.SelectedValue.ToString() + "&status=" + "\";</script>";
                            }


                            Response.Write(coutws);

                            // ScriptManager.RegisterStartupScript(this, this.GetType(), "ok", "<script>alert('操作成功!现在进入我的项目页面');javascript:location='manage.aspx?projecttype=4&projectStatus=0';</script>", false);

                            //添加操作日志

                            Dianda.BLL.SYS_LogsExt bsyslog = new Dianda.BLL.SYS_LogsExt();
                            bsyslog.addlogs(user_model.REALNAME + "(" + user_model.USERNAME + ")", "业务申请", project_model.NAMES + "项目订饭预约:成功!");
                            //添加操作日志

                            //添加立项申请的前台提醒信息
                            mFaceshowMessage.DATETIME  = DateTime.Now;
                            mFaceshowMessage.FromTable = "客饭预定";
                            mFaceshowMessage.IsRead    = 0;
                            mFaceshowMessage.NewsType  = "客饭预定";
                            mFaceshowMessage.Receive   = "客饭预定";
                            mFaceshowMessage.URLS      = "<a href='/Admin/applyManage/OrderfoodManage/check.aspx?ID=" + apply_model.ID + "&pageindex=1&Status=0' target='_self' title='客饭预定:提交时间" + DateTime.Now.ToString() + "'>" + Convert.ToDateTime(orderfood_model.UserDatetime).ToString("yyyy-MM-dd") + " 客饭预约</a> " + "  数量  " + orderfood_model.OrderNum.ToString() + " " + Session["ApplyUserName"];
                            mFaceshowMessage.DELFLAG   = 0;
                            mFaceshowMessage.ProjectID = apply_model.ProjectID;// Convert.ToInt16(DDL_Project.SelectedValue.ToString());
                            bFaceshowMessage.Add(mFaceshowMessage);
                        }
                    }
                    else
                    {
                        tag.Text = "预订的数量不能为空!";
                    }
                }//表示选择申请业务类型是订车申请***************************************
                else if (DDL_AppType.SelectedValue.ToString().Equals("orderCar"))
                {
                    foreach (GridViewRow item in orderCar.GridView1.Rows)
                    {
                        RadioButton rb    = (RadioButton)item.FindControl("RadioButton_choose");
                        int         Count = int.Parse(orderCar.GridView1.DataKeys[item.RowIndex].Value.ToString());
                        if (rb.Checked == true)
                        {
                            if (int.Parse(orderCar.TB_PeopleNum.Text) > Count)
                            {
                                tag.Text = "乘车人数多于车辆座位数!";
                                return;
                            }
                        }
                    }
                    Dianda.BLL.Project_Apply_orderCar   ordercar_bll   = new Dianda.BLL.Project_Apply_orderCar();
                    Dianda.Model.Project_Apply_orderCar ordercar_model = new Dianda.Model.Project_Apply_orderCar();
                    //用车时间
                    string ordertime = orderCar.ordercartime;
                    if (((HiddenField)orderCar.FindControl("HiddenField2")).Value == "fales")
                    {
                        tag.Text = "由于用车时间发生改变!请点击查看预订情况后再预约!";
                        return;
                    }
                    if (null != ordertime && !ordertime.Equals(""))
                    {
                        if (Convert.ToDateTime(Convert.ToDateTime(ordertime).ToString("yyyy-MM-dd")) < Convert.ToDateTime(DateTime.Now.AddDays(1).ToString("yyyy-MM-dd")))
                        {
                            tag.Text = "车辆必须提前一天预订,请电话联系相关人员!";
                        }
                        else
                        {
                            //所订车辆的ID
                            string carid = orderCar.CarID;
                            if (null != carid && !carid.Equals(""))
                            {
                                //ID
                                ordercar_model.ID = ordercar_bll.GetMaxId();
                                //Project_Apply中申请的ID
                                ordercar_model.ApplyID = apply_model.ID;
                                //车辆的ID
                                ordercar_model.CarID = int.Parse(carid);
                                //用车开始时间
                                string starttime = orderCar.ordercartime + " " + orderCar.starthour + ":" + orderCar.startminute;
                                ordercar_model.StartTime = Convert.ToDateTime(starttime);
                                //用车结束时间
                                string endtime = orderCar.ordercarendtime + " " + orderCar.endhour + ":" + orderCar.endminute;
                                ordercar_model.EndTime = Convert.ToDateTime(endtime);

                                //乘车的人数
                                if (null == orderCar.PeopleNum || orderCar.PeopleNum.ToString().Equals(""))
                                {
                                    ordercar_model.PeopleNum = 0;
                                }
                                else
                                {
                                    try
                                    {
                                        int n = Convert.ToInt32(orderCar.PeopleNum);
                                        if (n <= 0)
                                        {
                                            tag.Text = "乘车人数必须大于0!";
                                            return;
                                        }
                                    }
                                    catch
                                    {
                                        tag.Text = "乘车人数只能是大于0的数字!";
                                        return;
                                    }

                                    ordercar_model.PeopleNum = int.Parse(orderCar.PeopleNum);
                                }
                                //始发地
                                ordercar_model.FromAddress = orderCar.FromAddress;
                                //目的地
                                ordercar_model.ToAddress = orderCar.ToAddress;

                                ordercar_bll.Add(ordercar_model);

                                apply_bll.Add(apply_model);

                                Session["Session_Project_linkshow"] = "LinkButton_apply";

                                if (null == Session["Work_ProjectId"])
                                {
                                    Session["Work_ProjectId"] = DDL_Project.SelectedValue.ToString();
                                }

                                string coutws = "";
                                string type   = "";

                                if (null != Request["type"] && !(Request["type"].ToString().Equals("")))
                                {
                                    type = Request["type"].ToString();
                                }
                                else
                                {
                                    type = DDL_AppType.SelectedValue.ToString();
                                }
                                //if (null != Request["order"] && Request["order"].ToString().Equals("orderresource"))
                                if (null != Request["apply"] && Request["apply"].ToString().Equals("orderCar"))
                                {
                                    coutws = "<script language=\"javascript\" type=\"text/javascript\">alert(\"操作成功!现在进入列表页面\"); location.href = \"resourceManage.aspx?type=" + type + "&project=" + Request["project"] + "&status=" + "\";</script>";
                                }
                                else
                                {
                                    coutws = "<script language=\"javascript\" type=\"text/javascript\">alert(\"操作成功!现在进入列表页面\"); location.href = \"manage.aspx?type=" + DDL_AppType.SelectedValue.ToString() + "&status=" + "\";</script>";
                                }

                                Response.Write(coutws);

                                //添加操作日志

                                Dianda.BLL.SYS_LogsExt bsyslog = new Dianda.BLL.SYS_LogsExt();
                                bsyslog.addlogs(user_model.REALNAME + "(" + user_model.USERNAME + ")", "业务申请", project_model.NAMES + "项目订车预约:成功!");
                                //添加操作日志

                                //添加立项申请的前台提醒信息
                                Model.Project_CarList carlist_model = new Dianda.Model.Project_CarList();
                                BLL.Project_CarList   carlist_bll   = new Dianda.BLL.Project_CarList();

                                carlist_model              = carlist_bll.GetModel(int.Parse(ordercar_model.CarID.ToString()));
                                mFaceshowMessage.DATETIME  = DateTime.Now;
                                mFaceshowMessage.FromTable = "车辆预定";
                                mFaceshowMessage.IsRead    = 0;
                                mFaceshowMessage.NewsType  = "车辆预定";
                                mFaceshowMessage.Receive   = "车辆预定";
                                mFaceshowMessage.URLS      = "<a href='/Admin/applyManage/OrdercarManage/check.aspx?ID=" + apply_model.ID + "&pageindex=1&Status=0' target='_self' title='车辆预定:提交时间" + DateTime.Now.ToString() + "'>" + carlist_model.CarName + " 预约</a> " + Session["ApplyUserName"];
                                mFaceshowMessage.DELFLAG   = 0;
                                mFaceshowMessage.ProjectID = apply_model.ProjectID;// Convert.ToInt16(DDL_Project.SelectedValue.ToString());
                                bFaceshowMessage.Add(mFaceshowMessage);
                            }
                            else
                            {
                                tag.Text = "请先选择您所需要预订的车辆!";
                            }
                        }
                    }
                    else
                    {
                        tag.Text = "用车时间不能为空!";
                    }
                }//表示选择申请业务类型是订会议室申请***************************************
                else if (DDL_AppType.SelectedValue.ToString().Equals("orderRoom"))
                {
                    Dianda.BLL.Project_Apply_orderRoom   orderroom_bll   = new Dianda.BLL.Project_Apply_orderRoom();
                    Dianda.Model.Project_Apply_orderRoom orderroom_model = new Dianda.Model.Project_Apply_orderRoom();
                    if (((HiddenField)orderRoom.FindControl("HiddenField2")).Value == "fales")
                    {
                        tag.Text = "由于会议时间发生改变!请点击查看预订情况后再预约!";
                        return;
                    }
                    string ordertime = orderRoom.orderroomtime;
                    if (null != ordertime && !ordertime.Equals(""))
                    {
                        if (Convert.ToDateTime(Convert.ToDateTime(ordertime).ToString("yyyy-MM-dd")) < Convert.ToDateTime(DateTime.Now.AddDays(2).ToString("yyyy-MM-dd")))
                        {
                            tag.Text = "会议室必须提前二天预订,请电话联系相关人员!";
                        }
                        else
                        {
                            //所订会议室的ID
                            string roomid = orderRoom.RoomID;
                            if (null != roomid && !roomid.Equals(""))
                            {
                                //ID
                                orderroom_model.ID = orderroom_bll.GetMaxId();
                                //Project_Apply中申请的ID
                                orderroom_model.ApplyID = apply_model.ID;
                                //会议室的ID
                                orderroom_model.RoomID = int.Parse(roomid);
                                //会议开始时间
                                string starttime = orderRoom.orderroomtime + " " + orderRoom.starthour + ":" + orderRoom.startminute;
                                orderroom_model.StartTime = Convert.ToDateTime(starttime);
                                //会议结束时间
                                string endtime = orderRoom.ordercarendtime + " " + orderRoom.endhour + ":" + orderRoom.endminute;
                                orderroom_model.EndTime = Convert.ToDateTime(endtime);
                                //会议地址

                                string adress = "";
                                foreach (ListItem item in orderRoom.orderroomadress.Items)
                                {
                                    if (item.Selected)
                                    {
                                        adress = adress + item.Value + ",";
                                    }
                                }
                                if (adress != "")
                                {
                                    adress = adress.Remove(adress.LastIndexOf(","));
                                    orderroom_model.Address = adress;
                                }
                                else
                                {
                                    orderroom_model.Address = null;
                                }
                                //会议名称
                                if (null == orderRoom.MeetingName || orderRoom.MeetingName.ToString().Equals(""))
                                {
                                    tag.Text = "会议名称不能为空!";
                                    return;
                                }
                                orderroom_model.MeetName = orderRoom.MeetingName;

                                //会议的人数
                                if (null == orderRoom.MeetingNum || orderRoom.MeetingNum.ToString().Equals(""))
                                {
                                    orderroom_model.PeopleNum = 0;
                                }
                                else
                                {
                                    try
                                    {
                                        int n = Convert.ToInt32(orderRoom.MeetingNum);
                                        if (n <= 0)
                                        {
                                            tag.Text = "会议人数必须大于0!";
                                            return;
                                        }
                                    }
                                    catch
                                    {
                                        tag.Text = "会议人数只能是大于0的数字!";
                                        return;
                                    }

                                    orderroom_model.PeopleNum = int.Parse(orderRoom.MeetingNum);
                                }
                                //会议地址
                                //orderroom_model.Address = orderRoom.MeetingAddress;

                                orderroom_bll.Add(orderroom_model);

                                apply_bll.Add(apply_model);

                                Session["Session_Project_linkshow"] = "LinkButton_apply";

                                if (null == Session["Work_ProjectId"])
                                {
                                    Session["Work_ProjectId"] = DDL_Project.SelectedValue.ToString();
                                }

                                string coutws = "";
                                string type   = "";

                                if (null != Request["type"] && !(Request["type"].ToString().Equals("")))
                                {
                                    type = Request["type"].ToString();
                                }
                                else
                                {
                                    type = DDL_AppType.SelectedValue.ToString();
                                }

                                //if (null != Request["order"] && Request["order"].ToString().Equals("orderresource"))
                                if (null != Request["apply"] && Request["apply"].ToString().Equals("orderRoom"))
                                {
                                    coutws = "<script language=\"javascript\" type=\"text/javascript\">alert(\"操作成功!现在进入列表页面\"); location.href = \"resourceManage.aspx?type=" + type + "&project=" + Request["project"] + "&status=" + "\";</script>";
                                }
                                else
                                {
                                    coutws = "<script language=\"javascript\" type=\"text/javascript\">alert(\"操作成功!现在进入列表页面\"); location.href = \"manage.aspx?type=" + DDL_AppType.SelectedValue.ToString() + "&status=" + "\";</script>";
                                }


                                Response.Write(coutws);

                                //添加操作日志

                                Dianda.BLL.SYS_LogsExt bsyslog = new Dianda.BLL.SYS_LogsExt();
                                bsyslog.addlogs(user_model.REALNAME + "(" + user_model.USERNAME + ")", "业务申请", project_model.NAMES + "项目订会议室预约:成功!");
                                //添加操作日志

                                //添加立项申请的前台提醒信息
                                Model.Project_RoomList roomlist_model = new Dianda.Model.Project_RoomList();
                                BLL.Project_RoomList   roomlist_bll   = new Dianda.BLL.Project_RoomList();

                                roomlist_model             = roomlist_bll.GetModel(int.Parse(orderroom_model.RoomID.ToString()));
                                mFaceshowMessage.DATETIME  = DateTime.Now;
                                mFaceshowMessage.FromTable = "会议室预定";
                                mFaceshowMessage.IsRead    = 0;
                                mFaceshowMessage.NewsType  = "会议室预定";
                                mFaceshowMessage.Receive   = "会议室预定";
                                mFaceshowMessage.URLS      = "<a href='/Admin/applyManage/OrderroomManage/check.aspx?ID=" + apply_model.ID + "&pageindex=1&Status=0' target='_self' title='会议室预定:提交时间" + DateTime.Now.ToString() + "'>" + roomlist_model.RoomName + "  预约</a> " + Session["ApplyUserName"];
                                mFaceshowMessage.DELFLAG   = 0;
                                mFaceshowMessage.ProjectID = apply_model.ProjectID;// Convert.ToInt16(DDL_Project.SelectedValue.ToString());
                                bFaceshowMessage.Add(mFaceshowMessage);
                            }
                            else
                            {
                                tag.Text = "请先选择您所需要预订的会议室!";
                            }
                        }
                    }
                    else
                    {
                        tag.Text = "会议时间不能为空!";
                    }
                }//表示选择申请业务类型是印章申请***************************************
                else if (DDL_AppType.SelectedValue.ToString().Equals("orderSignet"))
                {
                    //印章ID
                    string SignetID = orderSignet.orderSignetID;
                    //敲章份数
                    string SignetNums = orderSignet.SignetNums;

                    string SHRID = DDList_SHR.SelectedValue.ToString();

                    Button_sumbit.Attributes.Add("onclick", "checksignetnums('" + orderSignet.SignetNums + "')");

                    Dianda.BLL.Project_Apply_signet   signet_bll   = new Dianda.BLL.Project_Apply_signet();
                    Dianda.Model.Project_Apply_signet signet_model = new Dianda.Model.Project_Apply_signet();

                    if (!string.IsNullOrEmpty(SHRID.Trim()))
                    {
                        if (null != SignetID && !SignetID.Equals(""))
                        {
                            if (null != SignetNums && !SignetNums.Equals(""))
                            {
                                try
                                {
                                    int n = Convert.ToInt32(SignetNums);
                                    if (n <= 0)
                                    {
                                        tag.Text = "敲章份数必须大于0!";
                                        return;
                                    }
                                }
                                catch
                                {
                                    tag.Text = "敲章份数只能输入大于0的数字!";
                                    return;
                                }


                                if (orderSignet.FileUp.FileName.Length > 2)
                                {
                                    string[] content = fileup.UpFile_COMMONS(orderSignet.FileUp, "/AllFileUp/fileup", "");
                                    //1-成功;0-失败;2-类型不支持;3-大小不符合;文件的路径;文件名称;文件类型;图标;大小;操作结果
                                    if (content[0] == "0")
                                    {
                                        tag.Text = "文件上传失败,请重新上传!";
                                        return;
                                    }
                                    else if (content[0] == "2")
                                    {
                                        tag.Text = "系统不允许此类文件上传,文件上传失败,请重新上传!";
                                        return;
                                    }
                                    else if (content[0] == "3")
                                    {
                                        tag.Text = "文件上传大小不符合系统规定,文件上传失败,请重新上传!";
                                        return;
                                    }

                                    apply_model.Attachments = content[1];
                                }

                                //ID
                                signet_model.ID = signet_bll.GetMaxId();
                                //Project_Apply中申请的ID
                                signet_model.ApplyID = apply_model.ID;
                                //印章ID
                                signet_model.SignetID = int.Parse(SignetID);
                                //审核人ID
                                apply_model.DoUserID = SHRID;

                                //敲章份数
                                signet_model.Nums = int.Parse(SignetNums);

                                signet_bll.Add(signet_model);

                                apply_bll.Add(apply_model);

                                Session["Session_Project_linkshow"] = "LinkButton_apply";

                                if (null == Session["Work_ProjectId"])
                                {
                                    Session["Work_ProjectId"] = DDL_Project.SelectedValue.ToString();
                                }

                                string coutws = "";
                                string type   = "";

                                if (null != Request["type"] && !(Request["type"].ToString().Equals("")))
                                {
                                    type = Request["type"].ToString();
                                }
                                else
                                {
                                    type = DDL_AppType.SelectedValue.ToString();
                                }

                                //if (null != Request["order"] && Request["order"].ToString().Equals("orderresource"))
                                if (null != Request["apply"] && Request["apply"].ToString().Equals("orderSignet"))
                                {
                                    coutws = "<script language=\"javascript\" type=\"text/javascript\">alert(\"操作成功!现在进入列表页面\"); location.href = \"resourceManage.aspx?type=" + type + "&project=" + Request["project"] + "&status=" + "\";</script>";
                                }
                                else
                                {
                                    coutws = "<script language=\"javascript\" type=\"text/javascript\">alert(\"操作成功!现在进入列表页面\"); location.href = \"manage.aspx?type=" + DDL_AppType.SelectedValue.ToString() + "&status=" + "\";</script>";
                                }


                                Response.Write(coutws);

                                //添加操作日志

                                Dianda.BLL.SYS_LogsExt bsyslog = new Dianda.BLL.SYS_LogsExt();
                                bsyslog.addlogs(user_model.REALNAME + "(" + user_model.USERNAME + ")", "业务申请", project_model.NAMES + "项目印章申请:成功!");
                                //添加操作日志

                                Model.Project_SignetList signetlist_model = new Dianda.Model.Project_SignetList();
                                BLL.Project_SignetList   signetlist_bll   = new Dianda.BLL.Project_SignetList();

                                signetlist_model = signetlist_bll.GetModel(int.Parse(signet_model.SignetID.ToString()));

                                mFaceshowMessage.DATETIME  = DateTime.Now;
                                mFaceshowMessage.FromTable = "印章申请";
                                mFaceshowMessage.IsRead    = 0;
                                mFaceshowMessage.NewsType  = "印章申请";
                                mFaceshowMessage.Receive   = SHRID;
                                mFaceshowMessage.URLS      = "<a href='/Admin/applyManage/OrdersignetManage/check.aspx?ID=" + apply_model.ID + "&pageindex=1&Status=0' target='_self' title='印章申请:提交时间" + DateTime.Now.ToString() + "'>" + signetlist_model.SignetName + "  申请</a>  " + "  数量  " + signet_model.Nums + " " + Session["ApplyUserName"];
                                mFaceshowMessage.DELFLAG   = 0;
                                mFaceshowMessage.ProjectID = apply_model.ProjectID;// Convert.ToInt16(DDL_Project.SelectedValue.ToString());
                                bFaceshowMessage.Add(mFaceshowMessage);
                            }
                            else
                            {
                                tag.Text = "敲章份数不能为空!";
                            }
                        }
                        else
                        {
                            tag.Text = "请先选择需要申请的印章!";
                        }
                    }
                    else
                    {
                        tag.Text = "请选择审核人(确认该项目是否有审核人)!";
                    }
                }
            }
            catch
            {
                tag.Text = "申请过程中发生错误,请检查输入是否正确!";
            }
        }