protected void btnSave_Click2(object sender, EventArgs e) { MeetingsBLL meetingbll = new MeetingsBLL(); string Opera = Request.QueryString["Opera"]; if (CheckValue()) { if (Opera == "Add") { //新增与会人员 MeetingModel.attend attend = new MeetingModel.attend(); //int PARTICIPATORId = int.Parse(Request.QueryString["PARTICIPATORId"]); int MId = int.Parse(Request.QueryString["MId"]); //meeting.m_id = meetingbll.GetMeetingCount(); //meeting.m_id = meetingbll.max(m_id); attend.m_id = MId; attend.participator_id = int.Parse(TxtID.Text); //attend.m_id=int.Parse(TxtNumber.Text); attend.arrive_date = DateTime.Parse(TxtArriveTime.Text); attend.arrive_way = TxtArriveWay.Text; attend.leave_date = DateTime.Parse(TxtLeaveTime.Text); attend.leave_way = TxtLeaveWay.Text; attend.h_name = TxtHotelName.Text; attend.room_number = int.Parse(TxtRoomNumber.Text); if (meetingbll.AddAttend(attend) > 0) { Response.Write("<script>alert('添加成功')</script>"); } else { Response.Write("<script>alert('添加失败')</script>"); } } else { //更改与会人员信息 int PARTICIPATORId = int.Parse(Request.QueryString["PARTICIPATORId"]); int MId = int.Parse(Request.QueryString["MId"]); MeetingModel.attend attend = meetingbll.GetAttendInfo(PARTICIPATORId, MId); //attend.participator_id = int.Parse(TxtID.Text); //attend.m_id=int.Parse(TxtNumber.Text); attend.arrive_date = DateTime.Parse(TxtArriveTime.Text); attend.arrive_way = TxtArriveWay.Text; attend.leave_date = DateTime.Parse(TxtLeaveTime.Text); attend.leave_way = TxtLeaveWay.Text; attend.h_name = TxtHotelName.Text; attend.room_number = int.Parse(TxtRoomNumber.Text); if (meetingbll.UpdateAttend(attend) > 0) { Response.Write("<script>alert('修改成功')</script>"); } else { Response.Write("<script>alert('修改失败')</script>"); } } } }
protected void btnSave_Click3(object sender, EventArgs e) { MeetingsBLL meetingbll = new MeetingsBLL(); string Opera = Request.QueryString["Opera"]; if (CheckValue()) { if (Opera == "Add") { //新增陪同人员 MeetingModel.accompany accompany = new MeetingModel.accompany(); int MId = int.Parse(Request.QueryString["MId"]); int PARTICIPATORId = int.Parse(Request.QueryString["PARTICIPATORId"]); //int MId = 6; ; // int PARTICIPATORId = 1414; //int REId = int.Parse(Request.QueryString["REId"]); //meeting.m_id = meetingbll.GetMeetingCount(); //meeting.m_id = meetingbll.max(m_id); accompany.participator_id = PARTICIPATORId; accompany.m_id = MId; accompany.re_id = int.Parse(TxtID2.Text); accompany.h_name = TxtHotelName.Text; accompany.roomnumber = int.Parse(TxtRoomNumber.Text); if (meetingbll.AddAccompany(accompany) > 0) { Response.Write("<script>alert('添加成功')</script>"); } else { Response.Write("<script>alert('添加失败')</script>"); } } else { //更改陪同人员信息 int PARTICIPATORId = int.Parse(Request.QueryString["PARTICIPATORId"]); int MId = int.Parse(Request.QueryString["MId"]); int REId = int.Parse(Request.QueryString["REId"]); MeetingModel.accompany accompany = meetingbll.GetAccompanyInfo(PARTICIPATORId, MId, REId); //accompany.participator_id = int.Parse(TxtID1.Text); //accompany.m_id = int.Parse(TxtNumber.Text); //accompany.re_id = int.Parse(TxtID2.Text); accompany.h_name = TxtHotelName.Text; accompany.roomnumber = int.Parse(TxtRoomNumber.Text); if (meetingbll.UpdateAccompany(accompany) > 0) { Response.Write("<script>alert('修改成功')</script>"); } else { Response.Write("<script>alert('修改失败')</script>"); } } } }
protected void btnSave_Click(object sender, EventArgs e) { MeetingsBLL meetingbll = new MeetingsBLL(); string Opera = Request.QueryString["Opera"]; if (CheckValue()) { if (Opera == "Edit") { string MId = Request.QueryString["MId"]; Meetings meeting = meetingbll.GetMeetingInfo(MId); meeting.m_id = txtrank.Text; meeting.m_name = txtTitle.Text; meeting.pre_num = int.Parse(txtpnum.Text); meeting.max_num = int.Parse(txtmnum.Text); meeting.theme = txttheme.Text; meeting.begin_date = DateTime.Parse(txtbd.Text); meeting.end_date = DateTime.Parse(txted.Text); meeting.m_city = txtcity.Text; meeting.m_address = txtaddress.Text; meeting.h_name = txthotel.Text; if (meetingbll.UpdateMeeting(meeting) > 0) { Response.Write("<script>alert('修改成功!')</script>"); } else { Response.Write("<script>alert('修改失败!')</script>"); } } else { Meetings meeting = new Meetings(); meeting.m_id = txtrank.Text; meeting.m_name = txtTitle.Text; meeting.pre_num = int.Parse(txtpnum.Text); meeting.max_num = int.Parse(txtmnum.Text); meeting.theme = txttheme.Text; meeting.begin_date = DateTime.Parse(txtbd.Text); meeting.end_date = DateTime.Parse(txted.Text); meeting.m_city = txtcity.Text; meeting.m_address = txtaddress.Text; meeting.h_name = txthotel.Text; if (meetingbll.AddMeeting(meeting) > 0) { Response.Write("<script>alert('增加成功!')</script>"); } else { Response.Write("<script>alert('增加失败!')</script>"); } } } }
protected void btnSave_Click(object sender, EventArgs e) { MeetingsBLL meetingbll = new MeetingsBLL(); string Opera = Request.QueryString["Opera"]; if (CheckValue()) { if (Opera == "Add") { //新增会议 MeetingModel.Meeting meeting = new MeetingModel.Meeting(); //meeting.m_id = meetingbll.GetMeetingCount(); //meeting.m_id = meetingbll.max(m_id); meeting.m_name = TxtName.Text; meeting.theme = TxtTheme.Text; meeting.begin_time = DateTime.Parse(TxtStartTime.Text); meeting.end_time = DateTime.Parse(TxtEndTime.Text); meeting.m_city = TxtCity.Text; meeting.m_street = TxtStreet.Text; meeting.m_number = int.Parse(TxtNumber.Text); meeting.dept_id = TxtDept.Text; if (meetingbll.AddMeeting(meeting) > 0) { Response.Write("<script>alert('添加成功')</script>"); } else { Response.Write("<script>alert('添加失败')</script>"); } } else { //更改会议信息 int MId = int.Parse(Request.QueryString["MId"]); MeetingModel.Meeting meeting = meetingbll.GetMeetingInfo(MId); meeting.m_name = TxtName.Text; meeting.theme = TxtTheme.Text; meeting.begin_time = DateTime.Parse(TxtStartTime.Text); meeting.end_time = DateTime.Parse(TxtEndTime.Text); meeting.m_city = TxtCity.Text; meeting.m_street = TxtStreet.Text; meeting.m_number = int.Parse(TxtNumber.Text); meeting.dept_id = TxtDept.Text; if (meetingbll.UpdateMeeting(meeting) > 0) { Response.Write("<script>alert('修改成功')</script>"); } else { Response.Write("<script>alert('修改失败')</script>"); } } } }
protected void btnSave_Click(object sender, EventArgs e) { MeetingsBLL meetingbll = new MeetingsBLL(); string Opera = Request.QueryString["Opera"]; if (CheckValue()) { if (Opera == "Add") { //新增宾馆 MeetingModel.Hotel hotel = new MeetingModel.Hotel(); hotel.h_name = Txth_name.Text; hotel.h_street = Txtstreet.Text; hotel.phone_number = Txtphone_number.Text; if (meetingbll.AddHotel(hotel) > 0) { Response.Write("<script>alert('添加成功')</script>"); } else { Response.Write("<script>alert('添加失败')</script>"); } } else { //更改宾馆信息 string HId = Request.QueryString["HId"]; MeetingModel.Hotel hotel = meetingbll.GetHotelInfo(HId); hotel.h_name = Txth_name.Text; hotel.h_street = Txtstreet.Text; hotel.phone_number = Txtphone_number.Text; if (meetingbll.UpdateHotel(hotel) > 0) { Response.Write("<script>alert('修改成功')</script>"); } else { Response.Write("<script>alert('修改失败')</script>"); } } } }
protected void btnSave_Click(object sender, EventArgs e) { MeetingsBLL meetingbll = new MeetingsBLL(); string Opera = Request.QueryString["Opera"]; if (CheckValue()) { if (Opera == "Add") { //新增子管理员 MeetingModel.Orduser ord = new MeetingModel.Orduser(); ord.id = int.Parse(Txtid.Text); ord.e_mail = Txtpsw.Text; ord.gender = Txtgender.Text; if (meetingbll.AddOrduser(ord) > 0) { Response.Write("<script>alert('添加成功')</script>"); } else { Response.Write("<script>alert('添加失败')</script>"); } } else { //更改子管理员信息 int OId = int.Parse(Request.QueryString["OId"]); MeetingModel.Orduser ord = meetingbll.GetOrduserInfo(OId); ord.id = int.Parse(Txtid.Text); ord.e_mail = Txtpsw.Text; ord.gender = Txtgender.Text; if (meetingbll.UpdateOrduser(ord) > 0) { Response.Write("<script>alert('修改成功')</script>"); } else { Response.Write("<script>alert('修改失败')</script>"); } } } }
protected void btnSave_Click(object sender, EventArgs e) { MeetingsBLL meetingbll = new MeetingsBLL(); string Opera = Request.QueryString["Opera"]; if (CheckValue()) { if (Opera == "Add") { //新增子管理员 MeetingModel.Department dept = new MeetingModel.Department(); dept.dept_id = Txtdept_id.Text; dept.dept_name = Txtdept_name.Text; if (meetingbll.AddDepartment(dept) > 0) { Response.Write("<script>alert('添加成功')</script>"); } else { Response.Write("<script>alert('添加失败')</script>"); } } else { //更改子管理员信息 string DId = Request.QueryString["DId"]; MeetingModel.Department dept = meetingbll.GetDepartmentInfo(DId); dept.dept_id = Txtdept_id.Text; dept.dept_name = Txtdept_name.Text; if (meetingbll.UpdateDepartment(dept) > 0) { Response.Write("<script>alert('修改成功')</script>"); } else { Response.Write("<script>alert('修改失败')</script>"); } } } }
protected void btnSave_Click(object sender, EventArgs e) { MeetingsBLL meetingbll = new MeetingsBLL(); string Opera = Request.QueryString["Opera"]; if (CheckValue()) { if (Opera == "Add") { //新增子管理员 MeetingModel.Admin admin = new MeetingModel.Admin(); admin.id = int.Parse(Txtid.Text); admin.psw = Txtpsw.Text; admin.dept_id = Txtdept_id.Text; if (meetingbll.AddAdmin(admin) > 0) { Response.Write("<script>alert('添加成功')</script>"); } else { Response.Write("<script>alert('添加失败')</script>"); } } else { //更改子管理员信息 int AId = int.Parse(Request.QueryString["AId"]); MeetingModel.Admin admin = meetingbll.GetAdminInfo(AId); admin.id = int.Parse(Txtid.Text); admin.psw = Txtpsw.Text; admin.dept_id = Txtdept_id.Text; if (meetingbll.UpdateAdmin(admin) > 0) { Response.Write("<script>alert('修改成功')</script>"); } else { Response.Write("<script>alert('修改失败')</script>"); } } } }