public NV_DonViTuBo_ChiTiet GetById(int id) { using (SqlConnection myConnection = new SqlConnection(ConnectionString)) { using (SqlCommand myCommand = new SqlCommand("NV_DonViTuBo_getByID", myConnection)) { myCommand.CommandType = CommandType.StoredProcedure; SqlParameter pID = new SqlParameter("@id", SqlDbType.Int); pID.Value = id; myCommand.Parameters.Add(pID); DataTable dt; NV_DonViTuBo_ChiTiet model = new NV_DonViTuBo_ChiTiet(); myConnection.Open(); using (SqlDataAdapter mData = new SqlDataAdapter(myCommand)) { dt = new DataTable(); mData.Fill(dt); } if (dt != null && dt.Rows.Count > 0) { model = new NV_DonViTuBo_ChiTiet(dt.Rows[0]); } return(model); } } }
public NV_KeHoachTuBo_ChiTiet() { ChuDauTu = new NV_DonViTuBo_ChiTiet(); CapQD = new NV_DonViTuBo_ChiTiet(); DonViGiamSat = new NV_DonViTuBo_ChiTiet(); DonViThiCong = new NV_DonViTuBo_ChiTiet(); DonViThietKe = new NV_DonViTuBo_ChiTiet(); }
public bool update(NV_DonViTuBo_ChiTiet model) { using (SqlConnection myConnection = new SqlConnection(ConnectionString)) { using (SqlCommand myCommand = new SqlCommand("NV_DonViTuBo_update", myConnection)) { myCommand.CommandType = CommandType.StoredProcedure; SqlParameter pID = new SqlParameter("@DonViID", SqlDbType.Int); pID.Value = model.DonViID; myCommand.Parameters.Add(pID); SqlParameter pTenDonVi = new SqlParameter("@TenDonVi", SqlDbType.NVarChar, 50); pTenDonVi.Value = model.TenDonVi; myCommand.Parameters.Add(pTenDonVi); SqlParameter pNguoiDaiDien = new SqlParameter("@NguoiDaiDien", SqlDbType.NVarChar, 50); pNguoiDaiDien.Value = model.NguoiDaiDien; myCommand.Parameters.Add(pNguoiDaiDien); SqlParameter pDiaChi = new SqlParameter("@DiaChi", SqlDbType.NVarChar, 500); pDiaChi.Value = model.DiaChi; myCommand.Parameters.Add(pDiaChi); SqlParameter pSoDienThoai = new SqlParameter("@SoDienThoai", SqlDbType.NVarChar, 50); pSoDienThoai.Value = model.SoDienThoai; myCommand.Parameters.Add(pSoDienThoai); SqlParameter pCapDonVi = new SqlParameter("@CapDonVi", SqlDbType.Int); pCapDonVi.Value = model.CapDonVi; myCommand.Parameters.Add(pCapDonVi); SqlParameter pChungChiHanhNghe = new SqlParameter("@ChungChiHanhNghe", SqlDbType.NVarChar, 100); pChungChiHanhNghe.Value = model.ChungChihanhNghe; myCommand.Parameters.Add(pChungChiHanhNghe); SqlParameter pGhiChu = new SqlParameter("@GhiChu", SqlDbType.NVarChar, 4000); pGhiChu.Value = model.GhiChu; myCommand.Parameters.Add(pGhiChu); SqlParameter pFile = new SqlParameter("@File", SqlDbType.NVarChar, 200); pFile.Value = model.File; myCommand.Parameters.Add(pFile); SqlParameter pChucNang = new SqlParameter("@ChucNang", SqlDbType.NVarChar, 20); pChucNang.Value = model.ChucNang; myCommand.Parameters.Add(pChucNang); try { myConnection.Open(); myCommand.ExecuteNonQuery(); return(true); } catch { return(false); } } } }