void XulyTimKiemTCL() { c = new BUS_Chuyen(); DataTable dt = new DataTable(); dto_c = new DTO_Chuyen(); int Tuyen = -1; dto_c.ID_Chuyen = -1; if (cbbTuyenXe.SelectedIndex != 0) { if (Int32.TryParse(cbbTuyenXe.Text.ToString(), out int x)) { Tuyen = x; } } if (cbbChuyenXe.SelectedIndex != 0) { if (Int32.TryParse(cbbChuyenXe.Text.ToString(), out int x)) { dto_c.ID_Chuyen = x; } } string Loai = cbbLoaiXe.Text.ToString(); if (cbbChuyenXe.Text.ToString() == "All" && cbbLoaiXe.Text.ToString() == "All" && cbbTuyenXe.Text.ToString() == "All") { LoaddgvChuyen(); } dt = c.ListChuyenDK(Tuyen, dto_c.ID_Chuyen, Loai); dgvChuyenXe.DataSource = dt; }
public void InsertChuyen(DTO_Chuyen c) { DAL dal = new DAL(); dal.Connect(); dal.ExecuteNonQuery(CommandType.StoredProcedure, "insertChuyen", new SqlParameter { ParameterName = "ID_Chuyen", Value = c.ID_Chuyen }, new SqlParameter { ParameterName = "Tuyen", Value = c.Tuyen_ID_Tuyen }, new SqlParameter { ParameterName = "GKH", Value = c.Gio_khoi_hanh }, new SqlParameter { ParameterName = "Ghichu", Value = c.Ghi_chu }, new SqlParameter { ParameterName = "Xe", Value = c.Xe_XeID }, new SqlParameter { ParameterName = "TaiXe", Value = c.Tai_xe_ID_TaiXe }); dal.DisConnected(); }
public bool UpdateChuyen(DTO_Chuyen c) { try { SqlConnection conn = DBConnect.Connect(); SqlCommand cmd = conn.CreateCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "updateChuyen"; cmd.Parameters.Add(new SqlParameter { ParameterName = "ID_Chuyen", Value = c.ID_Chuyen }); cmd.Parameters.Add(new SqlParameter { ParameterName = "Tuyen", Value = c.Tuyen_ID_Tuyen }); cmd.Parameters.Add(new SqlParameter { ParameterName = "GKH", Value = c.Gio_khoi_hanh }); cmd.Parameters.Add(new SqlParameter { ParameterName = "Ghichu", Value = c.Ghi_chu }); cmd.Parameters.Add(new SqlParameter { ParameterName = "Xe", Value = c.Xe_XeID }); cmd.Parameters.Add(new SqlParameter { ParameterName = "TaiXe", Value = c.Tai_xe_ID_TaiXe }); int row = cmd.ExecuteNonQuery(); DBConnect.Close(conn); if (row > 0) { return(true); } return(false); } catch (Exception ex) { throw new Exception(ex.Message); } }
public void InsertChuyen(DTO_Chuyen c) { dal_chuyen.InsertChuyen(c); }
public void UpdateChuyen(DTO_Chuyen c) { dal_chuyen.UpdateChuyen(c); }
public frmIUChuyen(DTO_Chuyen dto, int i) { InitializeComponent(); dto_c = dto; xet = i; }