private void ClassRoomRemove_Click(object sender, EventArgs e)//删除按钮
{
var rows = ClassRoomList.SelectedRows;
if (rows.Count > 0)
{
DialogResult result = MessageBox.Show("确定要删除吗？", "提示", MessageBoxButtons.OKCancel);
if (result == DialogResult.Cancel)
{
return;
}
string clno = rows[0].Cells[0].Value.ToString();
ClassRoomBLL classRoomBLL = new ClassRoomBLL();
if (classRoomBLL.Remove(clno))
{
MessageBox.Show("删除成功");
LoadClassRoomList();
}
else
{
MessageBox.Show("删除失败");
}
}
else
{
MessageBox.Show("请选择要删除的行");
}
}
private void comboBox2_SelectedIndexChanged(object sender, EventArgs e)
{
TeachBuildingBLL mibll = new TeachBuildingBLL();
string bname = comboBox2.Text;
ClassRoomBLL miBll = new ClassRoomBLL();
comboBox1.DataSource = miBll.bnoGetClno(mibll.BuildingsNameToNoumber(bname));
}
private void clnoLoadList(string clno)
{
BorrowClassRoomBLL miBll = new BorrowClassRoomBLL();
dgvList.DataSource = miBll.clnoGetList(clno);
ClassRoomBLL classRoomBLL = new ClassRoomBLL();
dataGridView5.DataSource = classRoomBLL.clnoGetList(clno);
//dgvList.Columns["usestatus"].Visible = false;
}
protected void btnDelete_Click(object sender, EventArgs e)
{
Int32 records = ClassRoomBLL.getInstance().delete(classRoom_id);
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "confirmMessage", "$('#confirmMessage').modal('toggle');", true);
if (records > 0)
{
lblMessage.Text = "Sede eliminada correctamente.";
}
loadData();
}
protected void loadData()
{
int code = oUser.oProgram.code;
if (code == 1)
{
gvClassRoom.DataSource = ClassRoomBLL.getInstance().getAll();
}
else
{
gvClassRoom.DataSource = ClassRoomBLL.getInstance().getAllByProgram(code);
}
gvClassRoom.DataBind();
}
private void Weekday_Period_LoadList()//通过星期和时间段的选择，跟新表的数据源
{
if (xq.Text != "" && jysj.Text != "")
{
TeacherCourseBLL teacherCourseBLL = new TeacherCourseBLL();
BorrowClassRoomBLL borrowClassRoomBLL = new BorrowClassRoomBLL();
ClassRoomBLL classRoomBLL = new ClassRoomBLL();
List <string> clnolist = borrowClassRoomBLL.Weekday_Period_GetClnoList(xq.Text, jysj.Text);
foreach (string clno in teacherCourseBLL.Weekday_Period_GetClnoList(xq.Text, jysj.Text))
{
clnolist.Add(clno);
}
dataGridView3.DataSource = classRoomBLL.GetListExptClno(clnolist);
jyjs.DataSource = classRoomBLL.GetClnoListExptClno(clnolist);
}
}
private void ClassRoomAdd_Click(object sender, EventArgs e)//添加、修改按钮
{
ClassRoom classRoom = new ClassRoom()
{
clno = Clno.Text,
bno = Bno.Text,
floor = Floor.Text
};
ClassRoomBLL classRoomBLL = new ClassRoomBLL();
#region 添加
if (ClassRoomAdd.Text.Equals("添加"))
{
if (classRoomBLL.Add(classRoom))
{
MessageBox.Show("添加成功");
LoadClassRoomList();
}
else
{
MessageBox.Show("添加失败");
}
}
#endregion
#region 修改
else
{
if (classRoomBLL.Edit(classRoom))
{
MessageBox.Show("修改成功");
LoadClassRoomList();
Clno.ReadOnly = false;
ClassRoomAdd.Text = "添加";
}
else
{
MessageBox.Show("修改失败");
}
}
#endregion
Clno.Text = "";
Bno.Text = "";
Floor.Text = "";
}
protected void gvClassRoom_RowEditing(object sender, GridViewEditEventArgs e)
{
unlockControls();
Int32 code = Convert.ToInt32(gvClassRoom.Rows[e.NewEditIndex].Cells[0].Text);
Entities.ClassRoom oClassRoom = ClassRoomBLL.getInstance().getClassRoom(code);
txtCode.Text = oClassRoom.code.ToString();
txtDescription.Text = oClassRoom.num_room;
txtSize.Text = oClassRoom.size.ToString();
cboState.SelectedValue = oClassRoom.state.ToString();
try
{
cboClassRoomType.SelectedValue = oClassRoom.oClassRoomsType.code.ToString();
}
catch (Exception)
{
cboClassRoomType.SelectedValue = "0";
}
try
{
cboLocation.SelectedValue = oClassRoom.oLocation.code.ToString();
}
catch (Exception)
{
cboLocation.SelectedValue = "0";
}
try
{
cboprogram.SelectedValue = oClassRoom.oProgram.code.ToString();
}
catch (Exception)
{
cboprogram.SelectedValue = "0";
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "redirect", "$('html, body').animate({ scrollTop: $('body').offset().top });", true);
}
protected void btnSave_Click(object sender, ImageClickEventArgs e)
{
Int32 records = 0;
if (validateData())
{
Entities.ClassRoom oClassRoom = new Entities.ClassRoom();
Entities.ClassRoomsType oClassRoomsType = new Entities.ClassRoomsType();
Entities.Location oLocation = new Entities.Location();
Entities.Program oProgram = new Entities.Program();
oClassRoom.code = Convert.ToInt32(txtCode.Text);
oClassRoom.num_room = txtDescription.Text;
oClassRoomsType.code = Convert.ToInt32(cboClassRoomType.SelectedValue);
oLocation.code = Convert.ToInt32(cboLocation.SelectedValue);
oClassRoom.size = Convert.ToInt32(txtSize.Text);
oProgram.code = Convert.ToInt32(cboprogram.SelectedValue);
oClassRoom.state = Convert.ToInt16(cboState.SelectedValue);
oClassRoom.oClassRoomsType = oClassRoomsType;
oClassRoom.oLocation = oLocation;
oClassRoom.oProgram = oProgram;
if (ClassRoomBLL.getInstance().exists(oClassRoom.code))
{
records = ClassRoomBLL.getInstance().modify(oClassRoom);
}
else
{
records = ClassRoomBLL.getInstance().insert(oClassRoom);
}
blockControls();
loadData();
if (records > 0)
{
lblMessage.Text = "Datos almacenados correctamente";
}
}
}
private void LoadClassRoomList()//列表数据源显示所有教室数据
{
ClassRoomBLL classRoom = new ClassRoomBLL();
ClassRoomList.DataSource = classRoom.GetList();
}
protected void btnNew_Click(object sender, ImageClickEventArgs e)
{
unlockControls();
txtCode.Text = ClassRoomBLL.getInstance().getNextCode().ToString();
}
protected void btnReport_Click(object sender, EventArgs e)
{
try
{
int code = oUser.oProgram.code;
List <Entities.ClassRoom> listRoom;
if (code == 1)
{
listRoom = ClassRoomBLL.getInstance().getAll();
}
else
{
listRoom = ClassRoomBLL.getInstance().getAllByProgram(code);
}
System.IO.MemoryStream memoryStream = new System.IO.MemoryStream();
text::Document pdfDoc = new text::Document(text::PageSize.A4, 10, 10, 10, 10);
pdfDoc.SetPageSize(iTextSharp.text.PageSize.A4.Rotate());
PdfWriter.GetInstance(pdfDoc, memoryStream);
pdfDoc.Open();
String imagepath = Server.MapPath("../../images/page-icons");
iTextSharp.text.Image deas = iTextSharp.text.Image.GetInstance(imagepath + "/DEAS-logo.jpg");
deas.ScaleToFit(140f, 120f);
//Give space before image
deas.SpacingBefore = 10f;
//Give some space after the image
deas.SpacingAfter = 1f;
deas.Alignment = text::Element.ALIGN_LEFT;
pdfDoc.Add(deas);
text::Paragraph title = new text::Paragraph();
title.Font = text::FontFactory.GetFont("dax-black", 32, new text::BaseColor(0, 51, 102));
title.Alignment = text::Element.ALIGN_CENTER;
title.Add("\n\n Reporte de Aulas\n\n\n\n");
pdfDoc.Add(title);
PdfPTable oPTable = new PdfPTable(6);
oPTable.TotalWidth = 100;
oPTable.SpacingBefore = 20f;
oPTable.SpacingAfter = 30f;
oPTable.AddCell("Descripción");
oPTable.AddCell("Capacidad");
oPTable.AddCell("Programa");
oPTable.AddCell("Tipo de Aula");
oPTable.AddCell("Localizacion");
oPTable.AddCell("Estado");
if (listRoom.Count > 0)
{
foreach (Entities.ClassRoom pRoom in listRoom)
{
oPTable.AddCell(pRoom.num_room);
oPTable.AddCell(pRoom.size.ToString());
oPTable.AddCell(pRoom.oProgram.name);
oPTable.AddCell(pRoom.oClassRoomsType.description);
oPTable.AddCell(pRoom.oLocation.oHeadquarters.description + " - " + pRoom.oLocation.building + " - " + pRoom.oLocation.module);
oPTable.AddCell((pRoom.state == 1 ? "Activo" : "Inactivo"));
}
}
else
{
PdfPCell cell = new PdfPCell(new text::Phrase("No existen aulas registrados."));
cell.Colspan = 5;
cell.HorizontalAlignment = 1; //0=Left, 1=Centre, 2=Right
oPTable.AddCell(cell);
}
pdfDoc.Add(oPTable);
pdfDoc.Close();
byte[] bytes = memoryStream.ToArray();
memoryStream.Close();
Response.Clear();
Response.ContentType = "application/pdf";
Response.AddHeader("Content-Disposition", "attachment; filename=Aulas.pdf");
Response.ContentType = "application/pdf";
Response.Buffer = true;
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.BinaryWrite(bytes);
Response.End();
Response.Close();
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
}
