/// <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;
}
}
