コード例 #1
0
ファイル: RoomArrageService.cs プロジェクト: 262734254/OA
        /// <summary>
        /// 根据会场名称查询会场安排信息
        /// </summary>
        /// <param name="roomName"></param>
        /// <returns></returns>
        public IList <RoomArrage> SearchRoomArrageStateByRoomName(string roomName)
        {
            IList <RoomArrage> list = new List <RoomArrage>();
            string             sql  = "usp_SearchRoomArrageStateByRoomName";

            using (DataTable dt = DBHelper.GetDataTableProc(sql, new SqlParameter("@RoomName", (roomName == null)?"":roomName)))
            {
                foreach (DataRow row in dt.Rows)
                {
                    RoomArrage roomArrage = new RoomArrage();
                    roomArrage.Id             = Convert.ToInt32(row["RID"]);
                    roomArrage.RoomName       = row["RoomName"].ToString();
                    roomArrage.RomeState      = row["RomeState"].ToString();
                    roomArrage.Remark         = row["Remark"].ToString();
                    roomArrage.InstancyDegree = row["InstancyDegree"].ToString();
                    roomArrage.ChargeMan      = row["ChargeMan"].ToString();// userService.GetAllUserById(Convert.ToInt32(row["ChargeMan"]));
                    roomArrage.MeetingType    = row["MeetingType"].ToString();
                    roomArrage.BeginTime      = Convert.ToDateTime(row["BeginTime"]);
                    roomArrage.EndTime        = Convert.ToDateTime(row["EndTime"]);

                    list.Add(roomArrage);
                }
            }
            return(list);
        }
コード例 #2
0
ファイル: RoomArrageService.cs プロジェクト: 262734254/OA
        /// <summary>
        /// 添加会场安排信息
        /// </summary>
        /// <param name="roomArrage"></param>
        public void AddRoomArrage(RoomArrage roomArrage)
        {
            string sql = "usp_addRoomArrage";

            SqlParameter[] para = new SqlParameter[]
            {
                new SqlParameter("@BeginTime", roomArrage.BeginTime),
                new SqlParameter("@EndTime", roomArrage.EndTime),
                new SqlParameter("@RoomName", roomArrage.RoomName),
                new SqlParameter("@MeetingType", roomArrage.MeetingType),
                new SqlParameter("@RomeState", roomArrage.RomeState),
                new SqlParameter("@ChargeMan", roomArrage.ChargeMan),
                new SqlParameter("@InstancyDegree", roomArrage.InstancyDegree),
                new SqlParameter("@Remark", roomArrage.Remark)
            };
            DBHelper.ExecuteNonQueryProc(sql, para);
        }
コード例 #3
0
    /// <summary>
    /// 修改/添加会议申请
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void btnSave_Click(object sender, EventArgs e)
    {
        MeetingApplication meetApplication = new MeetingApplication();

        meetApplication.RoomInfo.RID    = Convert.ToInt32(ddlRoomName.SelectedValue);
        meetApplication.MeetTitle       = txtMeetTitle.Text;
        meetApplication.MeetContent     = Server.HtmlDecode(txtContent.Value);
        meetApplication.MeetingSummary  = txtsummary.Text;
        meetApplication.MeetNumber      = int.Parse(txtMeetNumber.Value);
        meetApplication.InstancyDegree  = ddlInstancyDegree.SelectedItem.Text;
        meetApplication.MeetType        = txtMeetTitle.Text;
        meetApplication.BeginTime       = Convert.ToDateTime(txtbeginTime.Value + " " + sHours.Value + ":" + sSecond.Value);
        meetApplication.EndTime         = Convert.ToDateTime(txtendTime.Value + " " + sHourse2.Value + ":" + sSecond2.Value);
        meetApplication.Compere         = txtcompere.Text;
        meetApplication.DepartmentID.Id = Convert.ToInt32(ddlDepartment.SelectedValue);
        meetApplication.WithinEnlistMan = "admin";  //与会人员
        meetApplication.ApplicationTime = DateTime.Now;
        meetApplication.State           = "未召开";
        meetApplication.RoomInfo.RID    = Convert.ToInt32(ddlRoomName.SelectedValue);

        UserInfo user = Session["user"] as UserInfo;

        meetApplication.ApplicationMan  = "admin";//申请人为当前登录用户
        meetApplication.ApplicationTime = DateTime.Now;


        //为修改
        if (mid > 0)
        {
            try
            {
                meetApplication.MID = mid;
                //调用方法更新会议申请单
                MeetingApplicationManager.UpdateMeetintApplication(meetApplication);

                Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('更新成功');window.location='ApplictionMeetingList.aspx'</script>");
            }
            catch (Exception)
            {
                Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('更新失败')", true);
                return;
            }
        }
        else    //为添加会议申请及会场安排信息
        {
            RoomArrage roomArrage = new RoomArrage();
            roomArrage.BeginTime      = Convert.ToDateTime(txtbeginTime.Value + " " + sHours.Value + ":" + sSecond.Value);  //开始时间
            roomArrage.EndTime        = Convert.ToDateTime(txtendTime.Value + " " + sHourse2.Value + ":" + sSecond2.Value); //结束时间
            roomArrage.ChargeMan      = "admin";                                                                            //会议负责人
            roomArrage.InstancyDegree = ddlInstancyDegree.SelectedItem.Text;
            roomArrage.MeetingType    = txtMeetTitle.Text;                                                                  //会议类型
            roomArrage.RomeState      = "占用中";                                                                              //会场状态
            roomArrage.RoomName       = ddlRoomName.SelectedItem.Text;                                                      //会场名称
            roomArrage.Remark         = txtContent.Value;

            try
            {
                //新增会议申请
                MeetingApplicationManager.AddMeetingApplication(meetApplication);
                //新增会场安排信息
                RoomArrageManager.AddRoomArrage(roomArrage);

                Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('新增成功');window.location='ApplictionMeetingList.aspx'</script>");
            }
            catch (Exception)
            {
                Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('新增失败')", true);
                return;
            }
        }
    }
コード例 #4
0
ファイル: RoomArrageManager.cs プロジェクト: 262734254/OA
 /// <summary>
 /// 添加会场安排信息
 /// </summary>
 /// <param name="roomArrage"></param>
 public static void AddRoomArrage(RoomArrage roomArrage)
 {
     roomArrageService.AddRoomArrage(roomArrage);
 }