protected void GridView_TAIXE_SelectedIndexChanged(object sender, EventArgs e) { int iMaTaiXe; GridViewRow row = GridView_TAIXE.SelectedRow; iMaTaiXe = Convert.ToInt32(row.Cells[1].Text); // Cap nhat lai chuyen xe da phan cong var chuyenxe = (from x in db.CHUYEN_XEs where x.MaChuyenXe == iMaChuyenXe select x).Single(); chuyenxe.MaTaiXe = iMaTaiXe; db.SubmitChanges(); //Load lai du lieu GridView_CHUYENXE.DataSource = db.ChuyenXeChuaPhanCong(); GridView_CHUYENXE.DataBind(); GridView_TAIXE.DataSource = null; GridView_TAIXE.DataBind(); }
protected void Button_OK_Click(object sender, EventArgs e) { GridViewRow row; bool isChecked; int iMaChuyenXe; for (int i = 0; i < GridView_CHUYENXE.Rows.Count; i++) { row = GridView_CHUYENXE.Rows[i]; iMaChuyenXe = Convert.ToInt32(row.Cells[1].Text); var dc = (from x in db.CHUYEN_XEs where x.MaChuyenXe == iMaChuyenXe select x).Single(); isChecked = ((CheckBox)row.FindControl("chkSelect")).Checked; if (isChecked) { dc.TinhTrang = 3; dc.ThoiGianDenTram = DateTime.Now; } db.SubmitChanges(); } GridView_CHUYENXE.DataBind(); }
protected void GridView_TUYENXE_SelectedIndexChanged(object sender, EventArgs e) { // Insert nhung chuyen moi dua theo tuyen da chon // Ngay mai DateTime ngaymai = DateTime.Now; ngaymai = ngaymai.AddDays(1); GridViewRow row = GridView_TUYENXE.SelectedRow; iMaTuyenXe = Convert.ToInt32(row.Cells[1].Text); var tuyenxe = (from x in db.TUYEN_XEs where x.MaTuyenXe == iMaTuyenXe select x).Single(); CHUYEN_XE cx; int iMaChuyenXe; DAT_CHO dc; DateTime KhoiHanh; int i; // Chuyen dau tien cx = new CHUYEN_XE(); // Tinh thoi gian khoi hanh KhoiHanh = ngaymai; KhoiHanh = KhoiHanh.AddHours((double)tuyenxe.ThoiGianBatDau); cx.KhoiHanh = KhoiHanh; cx.MaTuyenXe = iMaTuyenXe; cx.TinhTrang = 1;// Chua khoi hanh cx.DuKienDen = KhoiHanh.AddHours((double)tuyenxe.ThoiGianDi); cx.LuongTaiXe = (float)tuyenxe.LuongTaiXe; cx.GiaVe = (float)tuyenxe.GiaVe; cx.SoLuongMuaVe = 0; // So luong mua ve ban dau db.CHUYEN_XEs.InsertOnSubmit(cx); db.SubmitChanges(); // Lay ma chuyen vua insert iMaChuyenXe = (from y in db.CHUYEN_XEs select y.MaChuyenXe).Max(); // Insert DAT_CHO // Lay tat ca cho ngoi var listChoNgoi = (from cn in db.CHO_NGOIs select cn); foreach (CHO_NGOI cn in listChoNgoi) { dc = new DAT_CHO(); dc.MaChoNgoi = cn.MaChoiNgoi; dc.MaChuyenXe = iMaChuyenXe; dc.TinhTrang = 1; // Chua dat cho db.DAT_CHOs.InsertOnSubmit(dc); db.SubmitChanges(); } // Chuyen tiep theo for (i = 1; i < tuyenxe.SoLuongChuyen; i++) { cx = new CHUYEN_XE(); // Tinh thoi gian khoi hanh KhoiHanh = KhoiHanh.AddHours((double)tuyenxe.TanSuatChuyen); cx.KhoiHanh = KhoiHanh; cx.MaTuyenXe = iMaTuyenXe; cx.TinhTrang = 1;// Chua khoi hanh cx.DuKienDen = KhoiHanh.AddHours((double)tuyenxe.ThoiGianDi); cx.LuongTaiXe = (float)tuyenxe.LuongTaiXe; cx.GiaVe = (float)tuyenxe.GiaVe; cx.SoLuongMuaVe = 0; // So luong mua ve ban dau db.CHUYEN_XEs.InsertOnSubmit(cx); db.SubmitChanges(); // Lay ma chuyen vua insert iMaChuyenXe = (from y in db.CHUYEN_XEs select y.MaChuyenXe).Max(); // Insert DAT_CHO foreach (CHO_NGOI cn in listChoNgoi) { dc = new DAT_CHO(); dc.MaChoNgoi = cn.MaChoiNgoi; dc.MaChuyenXe = iMaChuyenXe; dc.TinhTrang = 1; // Chua dat cho db.DAT_CHOs.InsertOnSubmit(dc); db.SubmitChanges(); } } var chuyenxe = (from x in db.CHUYEN_XEs where x.MaTuyenXe == iMaTuyenXe && x.KhoiHanh > DateTime.Now select x); GridView_CHUYENXE.DataSource = chuyenxe; GridView_CHUYENXE.DataBind(); GridView_TUYENXE.SelectedRow.Visible = false; }
protected void Page_Load(object sender, EventArgs e) { GridView_CHUYENXE.DataSource = db.ChuyenXeChuaPhanCong(); GridView_CHUYENXE.DataBind(); }
protected void DropDownList_TUYENXE_SelectedIndexChanged(object sender, EventArgs e) { GridView_CHUYENXE.DataBind(); }