/// <summary> /// 更新一条数据 /// </summary> public bool Update(SeatManage.ClassModel.StudyRoomInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update T_SM_StudyRoom set "); strSql.Append("StudyRoomName=@StudyRoomName,"); strSql.Append("StudyRoomSetting=@StudyRoomSetting,"); strSql.Append("Remark=@Remark,"); strSql.Append("RoomImage=@RoomImage"); strSql.Append(" where StudyRoomNo=@StudyRoomNo "); SqlParameter[] parameters = { new SqlParameter("@StudyRoomName", SqlDbType.NVarChar, 50), new SqlParameter("@StudyRoomSetting", SqlDbType.Text), new SqlParameter("@Remark", SqlDbType.Text), new SqlParameter("@RoomImage", SqlDbType.Text), new SqlParameter("@StudyRoomNo", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.StudyRoomName; parameters[1].Value = model.Setting.ToString(); parameters[2].Value = model.Remark; parameters[3].Value = model.RoomImage; parameters[4].Value = model.StudyRoomNo; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
//提交按钮点击事件 protected void btnSubmit_OnClick(object sender, EventArgs e) { string flag = Request.QueryString["flag"]; string no = Request.QueryString["srid"]; SeatManage.ClassModel.StudyRoomInfo modelStudyRoom = SeatManage.Bll.StudyRoomOperation.GetSingleStudyRoonInfo(no); if (modelStudyRoom == null) { modelStudyRoom = new SeatManage.ClassModel.StudyRoomInfo(); modelStudyRoom.Setting = new SeatManage.ClassModel.StudyRoomSetting(); } string RoomNo = txtStudyRoomNo.Text; string RoomName = txtStudyRoomName.Text; string RoomRemark = txtRemark.Text; modelStudyRoom.StudyRoomNo = RoomNo; modelStudyRoom.StudyRoomName = RoomName; modelStudyRoom.Remark = RoomRemark; if (!string.IsNullOrEmpty(uploadImage.PostedFile.FileName)) { modelStudyRoom.RoomImage = uploadImage.PostedFile.FileName; } { switch (flag) { case "add": if (SeatManage.Bll.StudyRoomOperation.GetSingleStudyRoonInfo(RoomNo) != null) { FineUI.Alert.ShowInTop("研习间编号重复!"); return; } if (SeatManage.Bll.StudyRoomOperation.AddNewStudyRoom(modelStudyRoom)) { PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); FineUI.Alert.ShowInTop("添加成功!"); } else { FineUI.Alert.ShowInTop("添加失败!"); } break; case "edit": if (SeatManage.Bll.StudyRoomOperation.UpdateStudyRoom(modelStudyRoom)) { PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); FineUI.Alert.ShowInTop("修改成功!"); } else { FineUI.Alert.ShowInTop("修改失败!"); } break; default: FineUI.Alert.ShowInTop("未执行任何操作"); break; } } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(SeatManage.ClassModel.StudyRoomInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into T_SM_StudyRoom("); strSql.Append("StudyRoomNo,StudyRoomName,StudyRoomSetting,Remark,RoomImage)"); strSql.Append(" values ("); strSql.Append("@StudyRoomNo,@StudyRoomName,@StudyRoomSetting,@Remark,@RoomImage)"); SqlParameter[] parameters = { new SqlParameter("@StudyRoomNo", SqlDbType.NVarChar, 50), new SqlParameter("@StudyRoomName", SqlDbType.NVarChar, 50), new SqlParameter("@StudyRoomSetting", SqlDbType.Text), new SqlParameter("@Remark", SqlDbType.Text), new SqlParameter("@RoomImage", SqlDbType.Text) }; parameters[0].Value = model.StudyRoomNo; parameters[1].Value = model.StudyRoomName; parameters[2].Value = model.Setting.ToString(); parameters[3].Value = model.Remark; parameters[4].Value = model.RoomImage; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
protected void GridStudyRoom_RowCommand(object sender, FineUI.GridCommandEventArgs e) { if (e.CommandName == "ActionDelete") { SeatManage.ClassModel.StudyRoomInfo room = new SeatManage.ClassModel.StudyRoomInfo(); room.StudyRoomNo = GridStudyRoom.Rows[e.RowIndex].DataKeys[0].ToString(); if (!SeatManage.Bll.StudyRoomOperation.DeleteStudyRoom(room)) { FineUI.Alert.ShowInTop("删除失败!"); } else { FineUI.Alert.ShowInTop("删除完成!"); BindStudyRoom(); } } }
/// <summary> /// 显示阅览室信息 /// </summary> protected void EditReadRoomShow() { string no = Request.QueryString["srid"]; SeatManage.ClassModel.StudyRoomInfo modelStudyRoom = SeatManage.Bll.StudyRoomOperation.GetSingleStudyRoonInfo(no); if (modelStudyRoom != null) { txtStudyRoomName.Text = modelStudyRoom.StudyRoomName; txtStudyRoomNo.Text = modelStudyRoom.StudyRoomNo; txtRemark.Text = modelStudyRoom.Remark; txtStudyRoomNo.Readonly = true; txtStudyRoomNo.Enabled = false; if (!string.IsNullOrEmpty(modelStudyRoom.RoomImage)) { imgRoomImage.ImageUrl = "~/StudyImage/" + modelStudyRoom.RoomImage; } } }
/// <summary> /// 得到一个对象实体 /// </summary> public SeatManage.ClassModel.StudyRoomInfo GetModel(string StudyRoomNo) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 StudyRoomNo,StudyRoomName,StudyRoomSetting,Remark,RoomImage from T_SM_StudyRoom "); strSql.Append(" where StudyRoomNo=@StudyRoomNo "); SqlParameter[] parameters = { new SqlParameter("@StudyRoomNo", SqlDbType.NVarChar, 50) }; parameters[0].Value = StudyRoomNo; SeatManage.ClassModel.StudyRoomInfo model = new SeatManage.ClassModel.StudyRoomInfo(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["StudyRoomNo"] != null && ds.Tables[0].Rows[0]["StudyRoomNo"].ToString() != "") { model.StudyRoomNo = ds.Tables[0].Rows[0]["StudyRoomNo"].ToString(); } if (ds.Tables[0].Rows[0]["StudyRoomName"] != null && ds.Tables[0].Rows[0]["StudyRoomName"].ToString() != "") { model.StudyRoomName = ds.Tables[0].Rows[0]["StudyRoomName"].ToString(); } if (ds.Tables[0].Rows[0]["StudyRoomSetting"] != null && ds.Tables[0].Rows[0]["StudyRoomSetting"].ToString() != "") { model.Setting = model.Setting = new ClassModel.StudyRoomSetting(ds.Tables[0].Rows[0]["StudyRoomSetting"].ToString()); } if (ds.Tables[0].Rows[0]["Remark"] != null && ds.Tables[0].Rows[0]["Remark"].ToString() != "") { model.Remark = ds.Tables[0].Rows[0]["Remark"].ToString(); } if (ds.Tables[0].Rows[0]["RoomImage"] != null && ds.Tables[0].Rows[0]["RoomImage"].ToString() != "") { model.RoomImage = ds.Tables[0].Rows[0]["RoomImage"].ToString(); } return(model); } else { return(null); } }
/// <summary> /// 数据绑定 /// </summary> private void DataBind() { SeatManage.ClassModel.StudyRoomInfo room = SeatManage.Bll.StudyRoomOperation.GetSingleStudyRoonInfo(Request.QueryString["no"]); if (room == null) { room = new SeatManage.ClassModel.StudyRoomInfo(); } SeatManage.ClassModel.StudyRoomSetting roomSet = room.Setting; if (roomSet == null) { roomSet = new SeatManage.ClassModel.StudyRoomSetting(); } chkUseStudyRoom.Checked = roomSet.IsUseStudyRoom; txtApplicationInfo.Text = roomSet.ApplicationInfo; txtFacilities.Text = roomSet.FacilitiesRenmark; txtPrecautions.Text = roomSet.Precautions; txtOpenTime_H.Text = roomSet.OpenTime.ToShortTimeString().Split(':')[0]; txtOpenTime_M.Text = roomSet.OpenTime.ToShortTimeString().Split(':')[1]; txtEndTime_H.Text = roomSet.CloseTime.ToShortTimeString().Split(':')[0]; txtEndTime_M.Text = roomSet.CloseTime.ToShortTimeString().Split(':')[1]; txtMaxTime.Text = roomSet.MaxBookTime.ToString(); txtCanUse.Text = roomSet.CanUseFacilities; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request.ServerVariables["HTTP_REFERER"] != null) { string url = Request.ServerVariables["HTTP_REFERER"].Trim(); string pageName = SeatManage.SeatManageComm.SeatComm.GetPageName(url); if (pageName != "StudyRoomList.aspx" && pageName != "FormSYS.aspx") { WriteLogs(url); Response.Write("请通过正确方式访问网站!"); Response.End(); return; } } else { WriteLogs(HttpContext.Current.Request.Url.AbsoluteUri); Response.Write("请通过正确方式访问网站!"); Response.End(); return; } } if (Request.QueryString["flag"] == "edit") { if (!IsPostBack) { DataBind(); } extform.Hidden = false; remarkform.Hidden = true; btnApp.Hidden = true; btnSubmit.Hidden = false; } else { string roomNo = Request.QueryString["roomNo"]; if (string.IsNullOrEmpty(roomNo)) { PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); FineUI.Alert.ShowInTop("数据获取失败!"); } else { SeatManage.ClassModel.StudyRoomInfo room = SeatManage.Bll.StudyRoomOperation.GetSingleStudyRoonInfo(roomNo); if (room == null) { PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); FineUI.Alert.ShowInTop("数据获取失败!"); } else { if (!IsPostBack) { DateTime nowT = SeatManage.Bll.ServiceDateTime.Now; tpBookingTime.MinTime = room.Setting.OpenTime; tpBookingTime.MaxTime = room.Setting.CloseTime; tpBookingTime.SelectedDate = room.Setting.OpenTime; dpBookingDate.MinDate = nowT; dpBookingDate.SelectedDate = nowT; nbUseTime.MinValue = 1; string[] cbul = room.Setting.CanUseFacilities.Split(';'); if (cbul.Length > 0) { cbUse.Items.Clear(); foreach (string item in cbul) { if (string.IsNullOrEmpty(item)) { continue; } cbUse.Items.Add(new CheckItem(item, item)); } } txtFacilitiesRenmark.InnerHtml = room.Setting.FacilitiesRenmark.Replace("\r\n", "<br/>").Replace(" ", " "); txtPrecautions.InnerHtml = room.Setting.Precautions.Replace("\r\n", "<br/>").Replace(" ", " "); txtApplicationInfo.InnerHtml = room.Setting.ApplicationInfo.Replace("\r\n", "<br/>").Replace(" ", " "); imgRoomImage.ImageUrl = "~/StudyImage/" + room.RoomImage; string u = Server.UrlEncode(imgRoomImage.ImageUrl); btnImage.OnClientClick = WindowImage.GetShowReference(string.Format("BigImage.aspx?imageurl={0}", u), "大图"); extform.Hidden = true; remarkform.Hidden = false; btnSubmit.Hidden = true; btnApp.Hidden = false; SeatManage.ClassModel.UserInfo user = SeatManage.Bll.Users_ALL.GetUserInfo(this.LoginId); txtApplicantCardNo.Text = this.LoginId; txtApplicantName.Text = user.UserName; } } } } }
protected void btnSubmit_OnClick(object sender, EventArgs e) { string roomNo = Request.QueryString["roomNo"]; int id = -1; SeatManage.ClassModel.StudyBookingLog model = null;; if (Request.QueryString["id"] != null) { id = int.Parse(Request.QueryString["id"]); model = SeatManage.Bll.StudyRoomOperation.GetStudyBookingLogByID(id); } if (model == null) { model = new SeatManage.ClassModel.StudyBookingLog(); } model.Application.ApplicantCardNo = txtApplicantCardNo.Text; model.Application.ApplicantDept = txtApplicantDept.Text; model.Application.ApplicantName = txtApplicantName.Text; model.Application.ApplicantPhoneNum = txtApplicantPhoneNum.Text; model.Application.ApplicantType = txtApplicantType.Text; model.Application.HeadPerson = txtHeadPerson.Text; model.Application.HeadPersonPhoneNum = txtHeadPersonPhoneNum.Text; model.Application.HeadPersonType = txtHeadPersonType.Text; model.Application.MeetingName = txtMeetingName.Text; model.Application.MembersCount = int.Parse(txtMembersCount.Text); model.Application.UseProjector = ""; foreach (CheckItem ci in cbUse.Items) { if (ci.Selected) { model.Application.UseProjector += ci.Value + ";"; } } model.BespeakTime = DateTime.Parse(dpBookingDate.Text + " " + tpBookingTime.Text); model.UseTime = int.Parse(nbUseTime.Text); if (Request.QueryString["flag"] != "edit") { model.StudyRoomNo = roomNo; } model.SubmitTime = SeatManage.Bll.ServiceDateTime.Now; model.CheckState = SeatManage.EnumType.CheckStatus.Checking; model.CardNo = txtApplicantCardNo.Text; model.Application.EmailAddress = txtemail.Text; string errorMessage = SeatManage.Bll.StudyRoomOperation.CheckBookTime(model.BespeakTime, model.UseTime, model.StudyRoomNo, model.StudyID); if (!string.IsNullOrEmpty(errorMessage)) { FineUI.Alert.ShowInTop(errorMessage); return; } SeatManage.ClassModel.StudyRoomInfo room = SeatManage.Bll.StudyRoomOperation.GetSingleStudyRoonInfo(roomNo); if (!room.Setting.IsUseStudyRoom) { btnSubmit.Enabled = false; return; } if (Request.QueryString["flag"] == "edit") { if (SeatManage.Bll.StudyRoomOperation.UpdateStudyBookingLog(model)) { PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); FineUI.Alert.ShowInTop("提交成功!"); } else { FineUI.Alert.ShowInTop("保存失败!"); } } else { if (SeatManage.Bll.StudyRoomOperation.AddStudyBookingLog(model)) { PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); FineUI.Alert.ShowInTop("提交成功!"); } else { FineUI.Alert.ShowInTop("保存失败!"); } } }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["flag"] == "edit") { if (!IsPostBack) { DataBind(); } extform.Hidden = false; remarkform.Hidden = true; btnApp.Hidden = true; btnSubmit.Hidden = false; } else { string roomNo = Request.QueryString["roomNo"]; if (string.IsNullOrEmpty(roomNo)) { PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); FineUI.Alert.ShowInTop("数据获取失败!"); } else { SeatManage.ClassModel.StudyRoomInfo room = SeatManage.Bll.StudyRoomOperation.GetSingleStudyRoonInfo(roomNo); if (room == null) { PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); FineUI.Alert.ShowInTop("数据获取失败!"); } else { if (!IsPostBack) { DateTime nowT = SeatManage.Bll.ServiceDateTime.Now; tpBookingTime.MinTime = room.Setting.OpenTime; tpBookingTime.MaxTime = room.Setting.CloseTime; tpBookingTime.SelectedDate = room.Setting.OpenTime; dpBookingDate.MinDate = nowT; dpBookingDate.SelectedDate = nowT; nbUseTime.MinValue = 1; string[] cbul = room.Setting.CanUseFacilities.Split(';'); if (cbul.Length > 0) { cbUse.Items.Clear(); foreach (string item in cbul) { if (string.IsNullOrEmpty(item)) { continue; } cbUse.Items.Add(new CheckItem(item, item)); } } txtFacilitiesRenmark.InnerHtml = room.Setting.FacilitiesRenmark.Replace("\r\n", "<br/>").Replace(" ", " "); txtPrecautions.InnerHtml = room.Setting.Precautions.Replace("\r\n", "<br/>").Replace(" ", " "); txtApplicationInfo.InnerHtml = room.Setting.ApplicationInfo.Replace("\r\n", "<br/>").Replace(" ", " "); string imageWebUrl = ConfigurationManager.AppSettings["imageUrl"]; imgRoomImage.ImageUrl = imageWebUrl + "StudyImage/" + room.RoomImage; string u = Server.UrlEncode(imgRoomImage.ImageUrl); btnImage.OnClientClick = WindowImage.GetShowReference(string.Format("BigImage.aspx?imageurl={0}", u), "大图"); extform.Hidden = true; remarkform.Hidden = false; btnSubmit.Hidden = true; btnApp.Hidden = false; if (!room.Setting.IsUseStudyRoom) { btnApp.Enabled = false; btnApp.ToolTip = "本研习间暂不开放"; } } } } } }
protected void Submit_OnClick(object sender, EventArgs e) { SeatManage.ClassModel.StudyRoomInfo room = SeatManage.Bll.StudyRoomOperation.GetSingleStudyRoonInfo(Request.QueryString["no"]); if (room == null) { FineUI.Alert.Show("设置保存失败!"); return; } SeatManage.ClassModel.StudyRoomSetting roomSet = room.Setting; if (roomSet == null) { roomSet = new SeatManage.ClassModel.StudyRoomSetting(); } roomSet.IsUseStudyRoom = chkUseStudyRoom.Checked; roomSet.ApplicationInfo = txtApplicationInfo.Text; roomSet.FacilitiesRenmark = txtFacilities.Text; roomSet.Precautions = txtPrecautions.Text; roomSet.CanUseFacilities = txtCanUse.Text; int maxTime = 0; if (int.TryParse(txtMaxTime.Text, out maxTime)) { if (maxTime > 0) { roomSet.MaxBookTime = maxTime; } else { FineUI.Alert.Show("最大使用时长要大于0!"); return; } } else { FineUI.Alert.Show("最大使用时长格式错误!"); return; } DateTime oTime = new DateTime(); if (DateTime.TryParse(txtOpenTime_H.Text + ":" + txtOpenTime_M.Text, out oTime)) { roomSet.OpenTime = oTime; } else { FineUI.Alert.Show("开放时间格式错误!"); return; } DateTime eTime = new DateTime(); if (DateTime.TryParse(txtEndTime_H.Text + ":" + txtEndTime_M.Text, out eTime)) { roomSet.CloseTime = eTime; } else { FineUI.Alert.Show("关闭时间格式错误!"); return; } if (roomSet.CloseTime <= roomSet.OpenTime) { FineUI.Alert.Show("开放时间不能大于关闭时间!"); return; } try { room.Setting = roomSet; if (SeatManage.Bll.StudyRoomOperation.UpdateStudyRoom(room)) { FineUI.PageContext.RegisterStartupScript(FineUI.ActiveWindow.GetHidePostBackReference()); FineUI.Alert.ShowInTop("保存成功!"); } else { FineUI.Alert.Show("保存失败!"); return; } } catch (Exception ex) { SeatManage.SeatManageComm.WriteLog.Write(ex.Message); FineUI.Alert.Show("保存失败!"); return; } }